Zero records in Delta Extraction from 0FI_GL_6 to CMFIGL06

[former_member698308]

I have tried to extract some data from DataSource 0FI_GL_6 to ADSO CMFIGL06 using delta extraction of DTP.

However, the result returns zero records.

I confirmed following points

• 15488 records is returned as a result of DeltaInit.
• 15568 records is returned as a result of full extraction

So I expect that 80 records is returned as a result of delta extraction, but it doesn't go well.

Please give me your advice to solve this problem if you have any ideas.

[bhavinvyas]

For FI data=sources delta works in time stamps and the settings maintained in BWOM_SETTINGS table.

Please refer these blogs for details,

https://blogs.sap.com/2013/04/02/bwomsettings-for-fi-loads-in-sap-bi/

https://blogs.sap.com/2020/08/04/fi-co-delta-safety-interval-summary/

Thanks,

Bhavin

[former_member698308]

Hi, bhavin.vyas

Thank you for your response.

I understand about setting table by your advice.

But I can't get some data by delta extraction in spite of running on next day.

I guess there are other cause except for time stamps.

Regards.

[john_hawk]

Check to see if the keys for your DSO match the keys of your datasource. Some records may be overwritten if there is a mismatch.

John Hawk

[former_member698308]

Hi, john.hawk.

Thank you for your response.

Below is screen shot of transformation between 0FI_GL_6 and CMFIGL06.

I think it is correct, but please tell me there are strange points.

Regards.