cancel
Showing results for 
Search instead for 
Did you mean: 

Delta Capability of FIAR Lineitems Datasource

Former Member
0 Kudos
131

Hi,

We are facing some what tricky problem, that is Delta capability of FI Ar Lineitems datasource(0FI_AR_4)

(We r in development only)Let me explain in step by step way, I did initialisation so i got some 100 records lets take, and i did added 2 lineitems in source system so when i did delta i got those two , and next when i added two more records in source sytem and do delta then getting again 4 records in delta infact i have to get only 2 records na...? as i already loaded first added 2 records as part of first delta, its happening for all added new records i mean its getting cumulated in delta ,

so then i deleted initilasation and did init again for testing purpose, so then this time i got all records came which i added in in delta as well ,but surprsingly when i do delta its giving same number of records of old delta load(here i mean cumulated records i got in last delta be4 i had deleted Init) , briefly i can say about this here is my delta buffer is not getting freed even after load as well..what could be the reason??

I gone through all time stamp related tables like BWOM_SETTINGS, BWOM2_TIMEST i could observe those settings are as per SAP standard suggestion only i mean as per SAP notes, Please let me know if any body has faced this sort of problem earlier or if u know the solution .

My system details : PI : 2004_1_470 level 0002

SP : SAPKIPZI52

<b>Many Many Thanks in Advance..</b>

BRB

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

BRB,

Are you using 0FI_GL_4 as the lead or have you decoupled the 0FI_AR_4 from 0FI_GL_4.

It has been a couple of years since I have last used GL/AR/AP in BW in 3.0B but that table drived the extractors to some extent back them. I think normally the GL/AR/AP extractors only extract to about 2:00am of the current day and is sufficient fo most since BW is a datawarehouse rather than a live system to have info up to the previous day. If you need it more frequently, there is an OSS note which you should be able to find if you put 0FI_GL_4 and 0FI_AR_4 into the search terms that talkes about more frequent extractions.

Hope this helps,

Mary

Former Member
0 Kudos

Hi Mary,

Our R/3 system is already PI - 2004_1_470 ,level 02, SP :SAPKIPZI52 so i think its alraedy decoupled anyway I checked with SAP NOTES 551044( which says about Decoupling), its being applied in my system, Even though my doubt is why its getting cumulated delta , when its retrieved once all records and if i dont have any changes in my source system, next delta should be " 0 Records " right..? but not happening like that..

Please if anybody else also face this problem let me know the solution..

Thanks in Advance..

BRB

Message was edited by: BRB

Former Member
0 Kudos

Hi BRB,

Do you currently have the datasource 0FI_GL_4 feeding any DataTarget? If so, then you should run a delta or full on 0FI_GL_4. Although, the FI datasources are decoupled, when it comes to Time Stamp, GL datasource is still the leading datasource that determines the time stamp.

The new 0FI_GL_4,0FI_AP_4 & 0FI_AR_4 are not linked i.e. you can have different selections on the infopackage selection, but they are still linked and your AP and AR delta has to always follow the GL delta.

Steps:

1) Perform an initialization on 0FI_GL_4,

2) Create a GL document with clearning in R/3. Tcode : F-04.

3) Peform a delta on 0FI_GL_4

4) Perform an initialization either on AP or AR followed by a delta

5) To load daily deltas always load 0FI_GL_4 first followed by AR and/or AP

Hope this helps,

Sree

Former Member
0 Kudos

Solved or not ?!

Former Member
0 Kudos

Hi Roberto,

I havent got solution yet, but mistakenly i selcted as i solved it myself..