Skip to Content
Author's profile photo Former Member

Bottlenecks in SAP BODS-BW integeration and possible solutions

While implementing the SAP BODS-BW integeration, I came across few issues which I am mentioning in this document.

1. While extracting the data from SAP via. ABAP interface,  I was getting the following error :

Execute ABAP program <D:/BODS/Ztest.abap> error <    Open File Error —  \\\bods abap/test.dat>.

Screenshot of SAP BW source Datastore settings:

Datastore _SAP_BW_source.PNG

Possible solutions:

1.  Read/Write permission issues : Your BW service should have access to write  in the folder \\\bods abap and your BODS service should be able to read from this path.

2. File sharing ports should be opened between two servers.

2.  While loading data into SAP datasource from BODS, my job runs successfully but some fields didn’t get populated and displacement of data also takes place

Possible solution :

1. This might be related to code page issue. Change the code page setting from Default to utf-8 into the properties of SAP BW Target Datastore as shown below :

Datastore _SAP_BW_target.PNG

3. In SAP, Data Type for Amount related field is CURR. While loading the data into SAP datasource having Amount related field data type is CURR, I am unable to load negative values. They were appended by 0s

Possible solution:

1. Change the data type from CURR to CHAR in SAP Datasource and keep the datatype CURR in the DSO for the amount related field.

4. Performance issue : While loading 2 millions records into SAP datasource it was taking more that 2 hours initially

Possible solution :

1. In the BODS. Double-click the SAP datasource in work area, You will find an option : ROWS PER COMMIT

Increase its value. Performance can be increased by a factor of 10 almost.

5. Identification of SAP null

In DS designer, Go to tools -> options -> SAP -> environment

and tick mark the option Convert SAP null to null.

Hope this will help. Thanks

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good one

      Author's profile photo Ahalya Inturi
      Ahalya Inturi

      Good ..

      Can you give more suggestions as the same to reduce the job run time