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 —  \\10.200.100.10\bods abap/test.dat>.

Screenshot of SAP BW source Datastore settings:

Possible solutions:

1.  Read/Write permission issues : Your BW service should have access to write  in the folder \\10.200.100.10\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 :

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