Sap BW Finance Extractor 0fi_gl_14 Delta Timestamp table

[Former Member]

Hi All,

I have implemented 0fi_gl_14 extractor in our environment.Delta init & regular delta processing are going fine.There is no issue in this.

After my regular delta loads i have noticed in the Table: BWOM2_TIMEST but there is no entries against this extractor: 0fi_gl_14.I thought that sap

might have some other new table which will hold this delta timestamp details of this extractor.Could please let me know which standard table in ECC keeping the delta timestamp details of this extractor.Your answers are really appreciated!!!

Thanks,

Karthikeyan

[sander_vanwilligen]

Hi Karthikeyan,

DataSource 0FI_GL_14 uses table BWFI_AEDAT for delta processing.

Best regards,

Sander

[Former Member]

Hi Sander,

BWFI_AEDAT will capture only the changed FI Documents of 0FI_GL_14.But i would like to know the Timestamp table name(like  for BWOM2_TIMEST for 0fi_gl_4) which will be used to capture the new FI documents posted???

i mean how gl_14 extractor recognise the last timestamp delta extraction information??where it is storing this information i know it is not storing this informarion in BWOM2_TIMEST table....

Please kindly help me to get this details...

Thanks,

Karthi

[former_member186053]

Hi Karthi,

Please see the below thread.

https://scn.sap.com/thread/3259160

Thanks,

Vengal.

[RamanKorrapati]

Hi,

for FI data sources we have only one table which shows time stamp details.

that is the one which you checked BWOM2_TIMEST.

at RSA7 also you can see the last delta time stamp.

Please explore at RSA7 against your data source.

Even check the table table which is mentioned by Sander also.

To know more about FI delta load/time stamp details please search from google and get the useful information.

Use google search key as "BWOM_SETTINGS for FI loads in SAP BI".

Thanks

[Former Member]

Hi,

You just see the table content for BWOM2_TIMEST in live system.there u can find all finance datasource with last extracted Delta-Timestamp details...but Extractor 0FI_GL_14 you wont find over there.....so i would like to know any other table is holding those information for gl_14??

sametime i have clearly mentioned tht BWFI_AEDAT will hold only changed records not new records...here i am worrying for only new records of GL_14....

Thanks.

[Former Member]

Hi Vengal,

In the above thread one of the folks have given the below link for this extraction process.

http://expertisesapbi.blogspot.in/2010/06/fi-extraction-fi-module-deals-with.html

But there is no blog in this link.If you have any information about this kindly let me know.

Thanks,

Karthikeyan