SAP

538

Solutions

819

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Share tech news, updates, or what's on your mind.

Sign up to Post

Dear Experts
At present we are using CRM application which is hosted on premise and it is mainly used for handling the support cases, automated email alerts and to store all the case related data, repair and maintenance data ( all data are imported  only , ie, operational users will not use instead all these to be imported  ) and tool is only used for reporting and analytics purpose only . Now that for other business process where the operational users will use in every stage  hence the need for technology solution in additional to above mainly on following business process and solution to be deployed on premises only.
1.       complete material movement tracking and capture the activities involved and automated email notifications and if the delay escalation rules .  
2.      Service, repair and maintenance  
3.      Warehouse/logistics management
4.      Inventory management
5.      Invoice management/HRMS/Vendor bills/salary # this is optional mainly 1 to 4 is important
We cannot go for cloud solutions the solution to hosted on premise.  Please suggest the ERP application that can be best suited for above should we have to evaluate Microsoft dynamics ERP AX , SAP  or any other where it to be used for operational and also for reporting and analytics . please suggest the best suited ERP or other solutions. Thanks in advance.
0
C++ 11 Fundamentals
LVL 12
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Hi All,

I am working on a new project which is SAP eWM implementation.

Now reading on SAP official site i understand i need to do a blueprint but they don’t have any sample of blueprints, can someone please share SAP eWM blueprint sample or template with me please?

Need this help urgently.

Thanks

A
0
I need to add an additional criteria to the following formula and I tried but it is not working??
This one works:

{="Unique Numbers in SAP = "&SUM(--(FREQUENCY(IF(Sheet2!C2:C50000<>"",MATCH(Sheet2!C2:C50000,Sheet2!C2:C50000,0)),ROW(Sheet2!C2:C50000)-ROW(Sheet2!C2)+1)>0))}

This one does not work:

{="Unique Numbers in SAP = "&SUM(--(FREQUENCY(IF(,Sheet2!H2:H50000"<>SESA"),IF(Sheet2!C2:C50000<>"",MATCH(Sheet2!C2:C50000,Sheet2!C2:C50000,0))),ROW(Sheet2!C2:C50000)-ROW(Sheet2!C2)+1)>0))}
0
http request to receive a login token from BusinessObjects worked a week ago, but no longer works, but https works.

The custom application to call BusinessObjects cannot process https call to BusinessObjects, so it's just using http.  The Windows Server 2012 had some recent updates and that seems to be the point the http call stopped working. However, the https call also doesn't work on the test server, also a recent occurance, previously http call worked, but that server hasn't changed.

We are calling BusinessObjects to get the login token, using custom.jsp, The call is this: http://businessintel.xxx.edu/BOE/OpenDocument/opendoc/custom.jsp, returning a token such as [my.server].xxx.edu:6400@1035920Jat23ZRZurWSuUdChkH7potPPeh4WnA4L1035918JhHah7YSxtrZnVHLEphyINv3xF2BcOI2O

The http call results in http error 404.

An http call to an outside link works - http://www.daggerpress.com/

So Windows Server 2012 now cannot (all of a sudden) call SAP BusinessObjects with http

I realize this is an environment issue that you won't be able to troubleshoot. Also it's Business Objects so we are pursuing assistance in other places.

But just thought I would see what anyone might say as far as how to further troubleshoot this.

Business Objects BI Suite 4.2 SP-05
Windows Server 2012
0
I'm getting the following error 7235 while starting backup service when discovering the solutions, find the KB for Error 7234/7235

Error: 7235, Severity: 17, State: 0  No other query entry found for the remote server SYBASESRV_BS - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.   

Open in new window


after issuing the following dump command line to Check that the remote server is up and running. I got the below error :

1> exec SYB_BACKUP...sp_who
2> go

If Backup Server is running, will get a meaningful response to this query. Unfourantly, we got the below error

Msg 7205, Level 17, State 2:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Server boot directory.
Msg 7205, Level 18, State 3:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Open in new window


as per the Action plan, we should check the interface file and I am not able to find the interface file yet. I would appreciate if anyone can share thoughts on this, please.
0
Want to print continuous crystal report using from range, below attaching image of what i want to achieve:

How can i print continuous crystal report?
Also i'm using this code to print single report
public void GetInvoiceRpt(string strReportName, string strVno)
        {
            try
            {
                int compcode = Convert.ToInt32(Application.Current.Properties["CompId"]);

                ReportDocument cryRpt = new ReportDocument();
                TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
                TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
                ConnectionInfo crConnectionInfo = new ConnectionInfo();
                Tables CrTables;


                cryRpt.Load(strReportName);

                crConnectionInfo.ServerName = clsconnection.SQLServerName();
                crConnectionInfo.DatabaseName = "MyApplication" + clsconnection.getCompanyCode(compcode);
                crConnectionInfo.UserID = clsconnection.SQLLoginID();
                crConnectionInfo.Password = clsconnection.SQLPW();
                CrTables = cryRpt.Database.Tables;
                foreach (Table CrTable in CrTables)
                {
                    crtableLogoninfo = CrTable.LogOnInfo;
                    crtableLogoninfo.ConnectionInfo = crConnectionInfo;
                    CrTable.ApplyLogOnInfo(crtableLogoninfo);
                }
                cryRpt.Refresh();

                cryRpt.SetParameterValue("@voucherno", strVno);

    

Open in new window

0
We are looking for a software that will manage subscription services.  We have been using Excel, but it's taking off so we need something more Enterprise scaling.
Does anyone use anything they would recommend?  Ideally it would interface with SAP
0
Hi - I am setting up a SAP HANA environment based on VMware 6.5 using RHEL 7.5 VMs.

One of my VMs has a number of drives (100GB OS drive / 32GB Swap / 50GB Binaries / 32GB Shared Data / 750GB DB / 750GB Logs), 48vCPU, and 768GB RAM and resides in a number of different Datastores.

My OS and Swap files share the same disk and datastore.

When I boot my RHEL VM, it tries to create the Swap space to match the amount of RAM = 768GB which instantly fills my storage.

I want 32GB configured for Swap space.

Am I missing the obvious? Is the sudden grabbing of disk space to match the amount of RAM expected behaviour?

Any help or guidance much appreciated
0
Hi

We are running ASE 15.0 (with character set latin-1 on Solaris 10).  We want to convert the charset of database server from latin-1 to UTF-8 to support  Chinese characters.
can anybody help us to list the steps involved in this charset conversion?  We understand we may have to bcp out/in all the tables unless the data stored in tables are only ASCII-7.  Is there any easy method to convert to UTF-8 without bcp in/out?

We have setup Warm standby using Sybase Replication Server. Do we need to change the charset of Replication server too to support UTF-8 along with dataserver? Kindly advise.

thanks
Chan
0
Hi Exchange experts

i dont know how this has to be done so i need help here

we have our ERP system SAP and we need to make a changes about meetings or date and we need an automatic configuration between SAP and exchange calendars

that when the user in SAP change the data about meeting this changes will take effects in the email calendar

someone talk about something called exchange web services

which will use the web mail of exchange to do this changes

i don't know about this

plus if you have any other idea to meet such aim
0
Build an E-Commerce Site with Angular 5
LVL 12
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

SAP B1 - Dunning Wizard - the default reports are PLD - I'm using Crystal Reports and have created a report however I'm not sure what parameter SAP B1 uses from the dunning wizard screen to pass to Crystal.  So, does anybody know which database field I need to use for the DocEntry@ parameter?  The report runs in crystal but in the dunning wizard screen I get an error 'No matching records found' RITM ODBC -2028 Message 131-183
0
Regarding Power BI On Premise Gateway:

The Login User created on the SAP BW server\database  which will login into the server\database from the on premise gateway.

What is this configuration required of the SAP BW server\database gateway user which the Gateway will login into to create the bridge.
0
I am trying to use a quantified expression to check every line item in a purchase order to see if the confirmed date and quantity (E2EDP20_EDATU, E2EDP20_WMENG) match the order date and quantity (E2EDP03_DATUM, E2EDP01_MENGE) within each G03 node..  

This is an SAP ORDERS IDOC.  If the E2EDP01 ordering data matches the E2EDP02 and E2EDP20 order confirmation the order is accepted unchanged.  If the E2EDP20_WMENG quanity is different than E2EDP01_MENGE we detect a change.  If the EDP20_EDATU  is different than E2EDP01_DATUM we also detect a change.

There  may be many G03 groups each with a new line item within to be checked.

When I enter this code below I get "Xpath is Invalid".  Am I not supposed to be able to use pos$ as a variable for each //G03 and use it as part of the Xpath to the E2EDP03 and E2EDP01?

<xsl:value-of select=" if (every $pos in //G03 satisfies (pos$/E2EDP20/E2EDP20_EDATU=pos$/E2EDP03[E2EDP03_IDDAT='002']/E2EDP03_DATUM and pos$/E2EDP20/E2EDP20_WMENG=pos$/E2EDP01/E2EDP01_MENGE)) then 'NOCHANGE' else 'CHANGE' "/>



<?xml version="1.0" encoding="UTF-8"?>
<!-- Based on format description: ordrsp_sr3_ord04 --><ACTIS>
  <Ein_IDOC>
  	  <G01>
  	  	...
  	  <G02>
				...
      <G03>
         <E2EDP01>
            <E2EDP01_POSEX>000010</E2EDP01_POSEX>
            <E2EDP01_ACTION>001</E2EDP01_ACTION>
            <E2EDP01_MENGE>960.000</E2EDP01_MENGE>
            <E2EDP01_MENEE>PCE</E2EDP01_MENEE>
            <E2EDP01_PMENE>PCE</E2EDP01_PMENE>
      

Open in new window

0
I had this question after viewing Append all database values in Parameter not bringing in all data..

I have been trying to append values for site (customer site names) and it is bringing in (on estimate) the first 1000 sites in the database.  If I create an "ALL" selection and run the report it does bring in all sites.  Basically when appending I can see up to values beginning with 'H', but running "ALL" bring up to 'Z'.

It is a standard parameter
Crystal report version is SAP Crystal Reports 2016 Support Pack 5 Version 14.2.5.2618
I am currently in Evaluation to see if we can make use of the system before purchasing!  Not sure if this has an effect.

I have so far attempted:
Creating the parameter in a fresh report but same result
Setting the parameter to dynamic has the same limited number of selections
I have gone into registry and created a new key - LOV, with the string MaxRowsetRecords and set as 1000000.

I have come to the end of any other solutions?

Any help is much appreciated!
0
HI Experts

just a question

some vendors dose not let you get the certificate even if you pass the exam without attend their training

for example  Vmware  so even you pass VCP exam you are not VCP certified till you attend the training

my question

what about


Citrix  -- Veeam  - Microsoft  - SAP

if anyone knows kindly update me


thnaks
0
Hi Experts

Could you explain in what aspects a SAP PowerBuilder app interacts with SAP ERP (MM/ PP/ FI/ CO/ SD...)?

Is it used like ABAP to customize the SAP use?

Or PowerBuilder owned by SAP (an Sybase dev platform before) is just an aparted product.

Thanks in advance!
0
Hello,

I need your advice please  to validate a solution for up to date  a file exchange between MarketPlace MIRAKL and SAP.
Mirakl does not give us the possibility to connect via sftp (user, mdp, port or other ).

However, If we use the CURL (client URL request library) technology to send requests and retrieve orders that are entered into our stores and repatriate them to SAP.
The connection is via https and in the script it will be used an API key that is unique and generate from our MIRAKL account. In this API key we have a user and a password, which makes the connection secure.

About security, the solution is secure (safe) or not and we advise me to implement this solution?

Best regards,
0
Dear Experts,

Could you please have a look this short code part, briefly its target is assigning a button text (from SAP application) to a variable, but if there is no such button then going further:

ErrMes = session.findById("wnd[2]/usr/txtMESSTXT1").Text
Debug.Print ErrMes
If ErrMes Is Nothing Then
    GoTo NoChangeMessage
Else
    ErrMes = session.findById("wnd[2]/usr/txtMESSTXT1").Text
    If InStr(1, ErrMes, "change", vbTextCompare) > 0 Then
    session.findById("wnd[2]/tbar[0]/btn[0]").press
    End If
End If

Open in new window


Actually it has the issue that the ErrMes variable got a value (as Debug.Print shows 'No changes were made' text assigned to it from the button), but then the VBA script stops at line

If ErrMes Is Nothing Then

Open in new window

with error message:

Run-time error '424'
Object required


Could you please advise what is the nature of the issue there and eventually how to eliminate?

Thanks in advance,
0
I'm trying to get SAP to send a report to Excel 2013 but keep getting the error Missing activeX component  Business Explorer Global Services.

Someone mentioned that this will only work with Excel 2010 , which I find odd, but then again this IS Microsoft!

What can I do other than downgrade excel to get it working?

Excel Version:       Excel  (15.0.5059)       2013
Windows Version:       Windows 7 Service Pack 1 (7601)      
Default Browser:       Internet Explorer (11.0.9600.19101)      
SAP GUI:       720 Patch 15      

Thanks

Pete
0
Introduction to R
LVL 12
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Dear Experts,

Could you please advise in Python how to get all the attributes/methods of an object?

Actually I need to write a Python code which works together with SAP application and it took almost a week to find in separate Python codes through Google, that there are 'Info' and 'SystemName' attributes for the "SAPGui" object.

This code so works already with showing the system name of that connection in SysName variable:

import win32com.client

SapGui = win32com.client.GetObject("SAPGUI")
print(SapGui)
Appl = SapGui.GetScriptingEngine
print(Appl)
Connection = Appl.Children(0)
print(Connection)
Session = Connection.Children(0)
print(Session)
CollCon = SapGui.GetScriptingEngine.Children(0)
print(CollCon)

SysName = Connection.Children(0).Info.SystemName
print(SysName)

Open in new window


Now it can be even in one line:

FullAttr = win32com.client.GetObject("SAPGUI").GetScriptingEngine.Children(0).Children(0).Info.SystemName
print(FullAttr)

Open in new window


And here comes my question concretely - what is the way to find these attributes like Info and SystemName in Python for such outside application? I am using Spyder for writing Python code and the default tool which brings a list after pressing '.' for the object, it does not work for such outside application
Attribute finder in Spyder
Thanks in advance,
0
I have several fields i wish to concatenate and display as a single string within a detail section.  

a. Is there a limit on the number of fields that can be concatenated?
b. Is there a limit on the length of the resulting string?

When I run the report in SAP BusinessObjects XI 3.1 I get the following cryptic error when I try to go to the next page.
message: Syntax error
description: Syntax error
number: -2146827286
name: SyntaxError

However; when the report is ran in Crystal Reports 2008 it works fine.
0
Hi,

How to call windows exe file in ASP.NET Application which has been hosted in IIS.?

The exe does, fetching records from SAP and keep it in local folder.

I have been facing the below issues.

1) I am not able to call the exe file in ASP.NET file.
2) I am not able to connect SAP through ASP.NET which is hosted in IIS.

Can any one give idea/suggestion, how to proceed above scenario...?
0
Hi,

Our team is facing frequent disconnection while working on SAP kernel "connection partner broken" error.

WSAE:CONNRESET: connection reset by peer.

Error No: 10054

We are using IPsec tunnel between these two sites over public Internet cloud. Could you urgently suggest if there is any parameter to be checked at our firewalls (model Cisco ASA) where VPN configured.  

Anticipating favorable reply soon.

Regards

Srini
0
Dear EE,

We have licensed EAServer 6.3.1 software available.

Now we want to relocate our EAServer machine from one location to another. (Geographic relocation).

Please help us to confirm whether same EAServer license will work or we have to request SAP for another license.

As per our understanding EAServer license is bind with Server MAC Address.

Do we need to maintain same server name and ip address etc ?

Thanks
0
Is there any software that can record desktop screen. I am working on a SAP project which requires picking data 1 by 1 from the excel file and then  going to SAP field and thus saving it.
0

SAP

538

Solutions

819

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Top Experts In
SAP
<
Monthly
>