Found 594 Articles for SAP Basis

Fetch fields from table or structure in ABAP SAP

Monica Mona
Updated on 14-Feb-2020 10:07:18

2K+ Views

If you need to identify the fields and number of fields in a structure, then you should use runtime type services. Using runtime type services makes more sense in this case as if we have some data in our environment, then it’s not ideal to call database for fetching the same.DATA(structure) = VALUE ( ) DATA(Descriptor) = CAST cl_abap_structdescr( cl_abap_datadescr=>describe_by_data                    (structure) ) DATA(Fields = LINES(Descriptor ->components ) This will give you the count of the components of the table or structure.You can also try another option if you do not want to ... Read More

Identify the database used for backend in ABAP

Samual Sam
Updated on 30-Jul-2019 22:30:20

164 Views

If you would have searched a little in the SAP documentation, then you would have found out the answer.You can use the CL_DB_SYS=>DBSYS_TYPE to fetch the database. For e.g. If you are using SAP HANA as the database, then the DBSYS_TYPE will have the value as HDB.

RV_INVOICE_DOCUMENT_READ not returning any data in form in SAP FM

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

294 Views

I think what you may be missing over here is Alpha conversion set.When you are calling a function module in SE37, it performs alpha conversions as a part of parameter processions. You might do go for internal formatting of the parameters before passing it to ABAP for further use.

Sort data in SQL using Dynamic SQL in SAP HANA

Giri Raju
Updated on 05-Dec-2019 09:51:18

849 Views

In order to execute dynamic SQL in your stored procedure, you need to use the ‘EXECUTE IMMEDIATE’ statement. You can use SQL as shown below to execute it:EXECUTE IMMEDIATE 'SELECT FROM ' || : || ' DESC';Another thing to notice over here is that if you are planning to use the table type in the final select statement with dynamic SQL, it will not work. Dynamic SQL does not support table type in select. What you can try as a work around is that you can dump the data in a temporary table before using it in the ... Read More

Using SAP Web Service from SAP by PHP with parameters

Anvi Jain
Updated on 30-Jul-2019 22:30:20

308 Views

Possible reason would be that SAP is case sensitive. Please try using HeadData instead of HEADDATA. Take a look at WSDL - all members inside “StandardMaterialSaveData” are option and SOAP is case sensitive so try using HeadData instead of HEADDATA

Ending a connection with SAP Instance and stop scripting

Hayat Azam
Updated on 13-Feb-2020 10:24:41

1K+ Views

This can be resolved by ensuring that you destroy all reference to public objects at the end of your script.In Excel VBA, you can use the following to do this −Set session = NothingIn C#, you should be using below −obj = Null;

Connecting system with SAP system using a Web Service

Shahyan Ali
Updated on 13-Feb-2020 10:23:30

562 Views

The best solution of this is to regenerate web service code the client system. Navigate to Add Service Reference in Visual Studio and regenerate WSDL code.

In SAP Crystal Reports XI, return records that match multiple conditions

Raja Ali
Updated on 13-Feb-2020 10:22:43

128 Views

It is advisable to use functions to pass such filter conditions in CR. Also try changing the order of your condition like −({PR.cov} = "A" and {PR.cov}="B") or {PR.cov} = "A" Try using function like this: {@A}:if {PR.cov} = "A" then 1 else 0To create custom functions in Crystal Report, navigate to Report Menu → Formula Expert → Right Click on Custom Functions → NewIt is advisable to use custom functions when you have multiple parameters to pass in the condition. You can also use the following when you have two string parameters −( 'A' IN {?cov} OR {PR.cov} IN ... Read More

SAP connector failed, use of port number 3350

Syed Nauman
Updated on 30-Jul-2019 22:30:20

197 Views

This port is used to provide a range of connections to SAP gateway for RFC connection. If you are getting this error, try to resolve your server name with “nslookup” or try connecting to IP address instead of server name.

Error while passing an image value to an OData request in SAP

Altamas Khan
Updated on 05-Dec-2019 07:54:55

269 Views

If you ImgData includes an image in Data URI format base64 then add the below line to Imgvalue to convert it to ImgData:var imgData = JSON.stringify(ImgValue);I suggest you to use AJAX to post image through OData as shown in below code:OData.request ({      requestUri:"http://test.test1.net:8081/sap/opu/odata/sap/ SALES_VRS/DailySalesSet",      method: "GET",      headers:      {       -Requested-With": "XMLHttpRequest",       "Content-Type": "application/atom+xml",       "DataServiceVersion": "2.0",                 "X-CSRF-Token":"Fetch"                                    }     ... Read More

Advertisements