AR Clearing Doucuments comming late in BW

[Former Member]

Hi ,

Can anyone help me to know the list of Table updates in ECC respect to the BI extractor 0FI_AR_4, in sequence, to detimene the delta update.

I could see the some documents cleared in ECC is comming late in BW, although business is expecting it to come in the very next date when it is cleared.

Thanks,

Santanu

[Former Member]

Hi,

BSID table is used for Open Items

BSAD table is Used for Cleared Items ,

Check the below link...it may help.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a7f2f294-0501-0010-11bb-80e0d67c3...

Regards,

Satya

[former_member199691]

check this document once if it helps;

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a7f2f294-0501-0010-11bb-80e0d67c3...

Regards,

Gaurav

[Former Member]

Thanks for your quick reply.

I have already gone through the document. But I have a specific question if I document is cleared we are sure that we will get a new record in BSAD indicating the document is cleared.

Now here is a scenario where document is partially cleared. So how should be the data flow from BSID to BSAD.

2> Other than the application tables there are others table as well like BWFI_AEDAT, BWFI_AEDA2 etc which needs to be updated as part of the transaction. Those tables are required for the delta update in BW.

Can anybody help me to understand the updating sequence for the application tables and the other tables which is actually enable us to get the proper delta records for the data source 0FIA_AR_4.

Function module BWFIP_WRITE_AEDAT_POINTER is vital role to play over here to enter the data in the above table(s). It would be great if anybody can give me an end to end back end tables and Jobs/fuction module involve in the delta generation for the above mentioned data source.

For your information BWFISAFETY parameter is set as 1 day interval in the table BWOM_SETTINGS.

Thanks,

Santanu

[Former Member]

The datasource extracts data from BSAD and BSID.

http://help.sap.com/saphelp_nw70ehp3/helpdata/en/bc/02f93abb013b0de10000000a114084/content

As mentioned by you the safety interval upper limit is set to 1 day, meaning it will only extract data till yesterday, even if you run the extractor multiple times today. See my earlier posts for more details and workarounds to reduce the safety interval.

/message/9947776#9947776 [original link is broken]

/message/10114982#10114982 [original link is broken]