SAP Basis Articles - Page 47 of 60

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.

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.

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

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

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;

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.

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

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.

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

Try to use “shellHash” property instead of “semanticObject” like below:-------------------------------------------------------- sap.ushell.Container.getService("CrossApplicationNavigation").toExternal({     target: {         shellHash: "#"     } }); --------------------------------------------------------