FI delta extractions

[Former Member]

I am extracting data for FI-AR using 0FI_AR_4, I wanted to understand how the deltas work for this. I thought that with the PI2002.1 we can run deltas more than once in a day or atleast get docs posted today to BW.

So I was wondering if there are documents posted in the morning and I run the deltas today evening, will I be able to get those documents to BW? If not till what all documents will I get in the delta being run today?

The time in tables BWOM2_TIMEST shows the time from 5PM the day my init was run and and 5PM on the day when I am running the deltas. Is that 5PM time standard or can be changed somewhere or is based on the when I run my Init? How does this time changes with each of my delta uploads.

Also, for table BWFI_AEDAT, once I load the deltas will the older entries from here be cleared?

If I am running an Init for only a few company codes (as that is the requirement currently) if after 6 months the users want to have data for other company codes loaded to BW, how can I achieve that. I can load the full historical data for that company code but what do I do for init. and deltas for that company code?

Answers/suggestions for the above questions are greatly appreciated.

[former_member205352 · Accepted solution]

If I am running an Init for only a few company codes (as that is the requirement currently) if after 6 months the users want to have data for other company codes loaded to BW, how can I achieve that. I can load the full historical data for that company code but what do I do for init. and deltas for that company code?

Later create a new init that particular company code selection.

Later deltas should pull fine inclusive of this new company code..

[Former Member · Accepted solution]

Thanks for the quick response, so in this case I dont need to delete the earlier int request all I do is to create a new init for the new company code and load full data. And the deltas will take the combination of both old and new parameters automatically? Thanks & Regards.

[former_member205352 · Accepted solution]

>

> Thanks for the quick response, so in this case I dont need to delete the earlier int request all I do is to create a new init for the new company code and load full data. And the deltas will take the combination of both old and new parameters automatically? Thanks & Regards.

Yes thats right.

[Former Member · Accepted solution]

When trying to load deltas documents for which the status is changed from open to cleared are not getting updated to BW system. The Clearing document (a new document) is posted into BW but the status for the old document is not being updated.

Changed items from BSID are being update, for eg. if a field on the invoice is changed but the documents which are updated from BSID to BSAD are not being updated.

Did anyone face this problem earlier?

The status of the open item should get updated from open (O) to cleared (C) in BW when they cleared?

Are there any particular settings that needs to be updated or am I just missing something very obvious.

Thanks for your help in advance.

[former_member205352 · Accepted solution]

Once the AR document is cleared in R3.

It should pull to BW in the next delta.There is one field called Doc status which precisely indicates this.

Did you get my first reply in this thread ?? There is a time lap of 1 day for the delta to be pulled.Hope you are checking correctly.

If you want to check it immediately,check in table BWFI_AEDAT.The document number should be present in this table and this is the doc which will be pulled further to BW.

[former_member205352]

 am extracting data for FI-AR using 0FI_AR_4, I wanted to understand how the deltas work for this. I thought that with the PI2002.1 we can run deltas more than once in a day or atleast get docs posted today to BW. 

No, you can pull delta only once ie., till 23:59 of previous day for any pull after 2:00 AM current day.

eg: If you pull delta today after 2:00 AM you have data till yesterday 23:59 only.

If you want to pull data multiple times a day you need to apply "minute based delta" Oss note (search with this keyword).

You may not have to implement the entire OSS note just make BWFINEXT = "X" in BWOM_SETTINGS table, as the code part is mostly implemented in the support packs mentioned in the note.

(Edit: OSS note :991429 - Minute Based extraction enhancement for 0FI_*_4 extractors)

Edited by: Praveen G on Mar 25, 2009 11:08 AM