Function Module Extraction!! Please HELP!!

[Former Member]

Hi Experts,

This is my first project in BW. Please help!! The existing function module using 3 tables to extract (Full update) data. Now, I have to enable the delta for this generic extractor. I have seen RSA3_GET_DATA_SIMPLE (nothing specified for Delta) and RSVD_BW_GET_DELTA_DATA function module to make use of it using OPEN CURSOR but in that fm I can see only one table being used.

Should I use 3 cursors to extract if so how should I join them? Can anyone please help me how to use cursors joining 3 tables and extract right delta data?

This would be a greatest help!! Thanks in advance.

Rishi

[Former Member]

Delta is coming with 5 records without any change.

[Former Member]

When you put AEDAT as delta, and put a safety limit (1), it will bring data where

AEDAT >= system-date - 1.

So, it is possible there were 5 records with AEDAT = 20071030 which were not picked yesterday, but were picked today.

However it should bring that only one time, not every time. Do check the AEDAT value in those 5 records. Are you running the delta through infopackage or testing in RSA3?

[Former Member]

Hi Ajay,

Thanks for your quick reply. It is taking those 5 records from the existing 8 records only and that too those were updated on 05072007 only. The tables that we are using will be updated only once in a month... If it is updating from somewhere else then what is the best place to check?

[Former Member]

I checked both in RSA3 and also loading data thru InfoPack. BTW, I'll create a new thread as I can not assign points it seems.

Rishi