0FI_GL_10: Data missing in BW (Business Warehousing)

Updated May 20, 2018

0FI_GL_10: Data missing in BW (Business Warehousing) because RTCUR is not in field list

Hello SAP Experts,

I missing my data in SAP BW (Business Warehousing) while using data source 0FI_GL_10 (or generated 3FI_GL_xx_TT with delta mode AIED) in delta mode. How can I resolve this issue?

Please help me.

Comments

14 Feb 2017 12:02 pm Sugandh Helpful Answer
In order to resolve this error please do this:
1. First please make sure that 'RTCUR' is also in the field list and also make sure that 'RTCUR' is transferred to the overwrite DSO as a key field.
2. After that please run the new delta init
After performing both the steps as given above the system will check whether RTCUR is in the field list or not and if not then the error message FAGL_GBIW007 (If currency type '00' is extracted, 'RTCUR' must be in the field list) is shown in the BW extraction log.

14 Feb 2017 12:03 pm Romil Tripathi Helpful Answer

The issue you are facing is caused because the Currency type (CURTYPE) '00' is extracted and the field 'RTCUR' is not in the field list. Therefore due to some conceptual reason, this may lead to missing of the data for other extracted currency types like '10' or '30' etc.