Found 1044 Articles for SAP

Handline #Multivalue Error in SAP BO Webi report

varun
Updated on 13-Jun-2020 14:35:13

2K+ Views

This error occurs when your formula returns more than one value and Webi report doesn’t know how to aggregate those values. This error occurs in below ways:#multivalue in aggregation #multivalue in breaks header or footer #multivalue in section level.Example:Let us say an account number which is associated to more than one order numbers. Your solution will not work and hence you are seeing #MULTIVALUE “Multiple Order Numbers for the same account number”.You can handle this by using an aggregated function as per your requirement like Max(), sum() or avg(). You can also check more details using this link:https://archive.sap.com/discussions/thread/1919325Read More

Identify required fields for an MB01 transaction in SAP

karthikeya Boyini
Updated on 30-Jul-2019 22:30:20

193 Views

As you have mentioned that you have access to SAP system. The solution lies within. Specify the transaction SE37 and mention the BAPI call that you have identified. It will navigate you to proper documentation of the call.But in order for that documentation to be of any help, you will still require movement type for your system. You can check it out with your infrastructure team to help you identify the movement type. Once you know the movement type, you will require other details like material number and others for more details. But that can be determined with minimal efforts. ... Read More

Transaction Jobs with no access to SM36 in SAP system

Swarali Sree
Updated on 30-Jul-2019 22:30:20

183 Views

There are few modules which let you schedule jobs programmatically like ‘JOB_OPEN’ or ‘JOB_CLOSE’. You can use these modules to schedule the job and then run it.You can programmatically handle it irrespective of privilege issue.

Unable to access DBCONN after upgrading to EHP7 in SAP system

seetha
Updated on 10-Dec-2019 08:56:39

88 Views

You can test the connection using T-code: SE38 using ADBC_TEST_CONNECTION. You could check details of exception as below:TRY. EXEC SQL. CONNECT TO 'ZUNIXDB_DBCON' ENDEXEC. EXEC SQL. OPEN dbcur FOR SELECT id FROM table ENDEXEC. CATCH cx_sy_native_sql_error INTO lr_cx_native_sql_error.

Using SAP Tables from C# application - RFC_READ_TABLE

vanithasree
Updated on 10-Dec-2019 09:01:35

504 Views

Many users use RFC_READ_Table as API for generic table access.Joins are not supported in RFC_READ_TABLE - Not correct as you can any time join your application. If you face any issues, you can ask user ABAP developer to create a Function Module.Select * query does not work for most cases as the data_buffer_exceed error is thrown- You shouldn’t run select * all the time as you don’t need all the data. You should only pull information that is required.

Getting Error while calling XBP Function Module via SAP.net connector

radhakrishna
Updated on 10-Dec-2019 09:03:22

67 Views

Note that you need to execute function call in a single session so you have to wrap your logic into JCoContext. Try using below method:try {    JCoContext.begin(destination);    try {       // your function calls here       // probably bapiTransactionCommit.execute(destination);    } catch(AbapException ex) {       // probably bapiTransactionRollback.execute(destination);    } } catch(JCoException ex) {    [...] } finally {    JCoContext.end(destination); }

Combining LIKE and CONTAINS operator in SAP HANA

Samual Sam
Updated on 26-Feb-2020 06:11:45

574 Views

The code you are using \1+ just removes consecutive occurrences only. You can use the below code.SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' OCCURRENCE ALL)  FROM DUMMYThe output will come out to be “312”. This will remove all multiple occurrences and only last one will be kept.

SAP interfaces throws an error message "Completion Code 2, Reason 2161, MQJMS2002”

Monica Mona
Updated on 24-Feb-2020 09:22:46

114 Views

As per my understanding,  the only way to get the MQ jar files or the MQ C/C++ library files onto a system is by installing any of the below:Using WebSphere MQ product orUsing WebSphere MQ Client SupportPacsYou can find jar file under WebSphere MQ V7.0 Clients SupportPacks. The install files are commonly available under java/lib directory.You can try installing jar files from Fix Central. Go to Fix Central and enter "Java" in the Text search box.https://www-945.ibm.com/support/fixcentral/swg/identifyFixes?query.parent=ibm~WebSphere&query.product=ibm~WebSphere~WebSphere%20MQ&query.release=9.0&query.platform=AllThe name of the file to be downloaded is in this format:-[IBM|WS]-MQ-Install-Java-All.jar.For example, for MQ V9.0:9.0.0.0-IBM-MQ-Install-Java-All.jar.You have the following files that can be moved to ... Read More

Using Function Module BAPI_ISUPARTNER_CREATEFROMDATA to create BP in SAP IS-U system

Srinivas Gorla
Updated on 30-Jul-2019 22:30:22

743 Views

Note that home page URL is part of Business Partner’s communication data and comes under address data or address independent communication.You can use Function Module - BAPI_BUPA_ADDRESS_ADD/BAPI_BUPA_ADDRESS_CHANGE for updating it with communication data or FM’s BAPI_BUPA_CREATE_FROM_DATA/BAPI_BUPA_CENTRAL_CHANGE for address independent communication.BAPI_BUPA_CREATE_FROM_DATA  SAP BP, BAPI: Create Business PartnerBAPI_BUPA_CENTRAL_CHANGESAP BP, BAPI: Change Central DataBAPI_BUPA_ADDRESS_ADDSAP BP, BAPI: Add AddressBAPI_BUPA_ADDRESS_CHANGE  SAP BP, BAPI: Change AddressFunction Module: BAPI_BUPA_ADDRESS_ADD   Function Group: BUBA_3 SAP BP: External BAPI Function Modules Program Name: SAPLBUBA_3Following are the parameters:Read More

Getting data in SAPUI5 application from backend tables in NetWeaver

mkotla
Updated on 30-Jul-2019 22:30:20

258 Views

Note that Eclipse is just a standard editor to develop UI5 application. You should use SAP IDE which is one of the recommended editor now.When you backend system as NetWeaver system, Gateway and OData would be the recommended way to use.

Advertisements