Data source 0CA_TS_IS_1, Fillter Selection issues
We have issues with Delta load in the data source 0CA_TS_IS_1, In CATSDB table z*fields are included which is FI GL indicator which this field is used to determine whether the time entries in CATSDB has been done the FI posting or not. if the time entries posting into FI document then the GL indicator field will be filled with 'X'.
Current Function & requirement:-
now our requirement is to report only the approved & time posted records In the report. but the current 0CA_TS_IS_1 Data source the delta setup is numeric pointer which will not update the changes on the existing record in the BW however it will read the new document created.
The data was loaded daily as a delta load. if the data loaded already without time posting indicator in BW, then later the time posted in the ECC means in the next delta load the indicator is not updating, I understand this issues is occurring due to the Numeric pointer setup for delta.
so I thought to add the GL indicator field as a selection field in data source but when I used 'X' in the selection filter the data is not getting filtered by X.
so do I need to enhance the FM CATS_BIW_GET_DATA2? please let me know.