Z <System Temp Dir or local FTP dir>/ O D I _ < I n t e r f a c e I d > _ < S r c S e t > _ < C o n t e x t > . e r r
LKM - Runtime
OS error output during SQLLDR execution, may contain information, e.g. when SQLLDR is not installed
Controling ABAP Uploading in Development and in Production
During development, ABAP code is uploaded to the SAP system with every interface execution. This upload can be explicitely turned off by setting the LKM option UPLOAD_ABAP_CODE to No.
Once an Interface or Package has been unit tested and is ready to be migrated out of the development environment, ODI should no longer upload ABAP code, as the ABAP code will be transported by SAP's CTS (Change and Transport System).
Alternatively, the upload can be turned off using the FlexField SAP Allow ABAP Upload defined on the SAP data server in the Topology: The ABAP code is only uploaded, if the LKM option UPLOAD_ABAP_CODE and the Flexfield SAP Allow ABAPUpload are both set to Yes. So for disabling upload for non-development systems the user must set the Flexfield SAP Allow ABAPUpload to 0 in Topology.
Note: Before starting the extraction process, ODI verifies that the interface/scenario matches the code installed in SAP. Otherwise an exception is thrown.
Limitations of the SAP ABAP BW Adapter
The SAP ABAP BW adapter has the following limitations:
The Test button for validating SAP Connection definition in ODI’s Topology manager is not supported.
The SAP BW data store type (InfoCube, InfoObject, ODS/DSO, OpenHub and Text Table) cannot be changed after a table has been reverse-engineered.
The SAP ABAP KMs only support Ordered Joins. Full Outer join and Right outer joins are not supported.
In one-to-many relationships (InfoCube and associated InfoObject join), the first data target should be InfoCube and then InfoObjects and its TextTables
Knowledge Module Options Reference RKM SAP BW
Yes | No
Knowledge Modules Reference Guide
If set to Yes, the Tree Metadata Browser UI for selecting SAP BW data target to reverse-engineer is shown.
If Set to No, only the specified