Generic delta Saftey interval.

[Former Member]

hi everybody,

I am trying to make a generic extractor -delta enabled.

i am confused about this --<b>upper limit and lower limit </b>in saftey interval.

for <b>time stamp, numeric pointer, date</b> fields.

could anyone kindly explain me what r these upper limit and lower limit and how they work in regarding this three field types.

i even read hw to generic delta document. but i got stuck with these two --terms.....

plz explain me in simple language. plz ihave even read in help i could only understand about saftey interval but not about upper limit and lower limit.

thanks and regards.

[Former Member · Accepted solution]

Hi Neelkamal,

Let me take an example of GL data extraction for explaining upper limit and lower limit.

Assume that I am extracting GL financial documents and have already extracted data till 10 Nov 2005.

Now if the upper limit for extraction of GL data is 1 that is till previous day.

The next time when I extract data the lower limit will be all GL documents posted subsequent to 10 Nov 2005 and the upper limit would be all documents posted till 16 Nov 2005 i.e. till the previous day, assuming that the data is being extracted on 17 Nov 2005.

In FI there are certain tables BWFI_AEDAT, BWOM2_TIMEST, BWFI_AEDAT which help keep track of change documents.

Moreover you could also do the setting for the parameter

BWFISAFETY in the table BWOM_SETTINGS

for maintaining the settings for delta safety.

I am not very sure how the same could be used in the Generic delta, but just to give you an idea.

Hope it helps.

Cheers

Anurag

Message was edited by: Anurag Khungar

[Former Member · Accepted solution]

hi anurag,

thank you for your help and i still your guideance, so as per your explaination-- i understood that..

so when after extracting data till 10 nov 2005 when i specify the security interval -- upper limit as 1 and lower limit as 0

and here upper limit 1 means till previous day of our extraction, that is if i want to extract on 18 nov 2005 it will get me all the records till 17 nov 2005 . so when i specified lower limit 0 it will get me from 10 nov 2005 to 17 nov 2005.

<b>more clearly</b>--- lower limit corresponds to last extraction

time and upper limit specifies to the current extraction time. <b>this is regarding date </b>

so what about timestamp and numeric pointer.

plz correct me if i am wrong becoz i am trying to get the concept right.

hope you all can understand.

thanks and regards

neelkamal

[Former Member · Accepted solution]

Hi Neelkamal,

<i><b>more clearly</b>--- lower limit corresponds to last extraction

time and upper limit specifies to the current extraction time. <b>this is regarding date</b> </i>

yes you got it right.

But with regard to FI you cannot set the paramter BWFISAFETY lower than 1, so there would always be some time lag between when a document is posted in R/3 and when you could extract the same in BW.

Hope it helps.

Cheers

Anurag

[Former Member]

Hi Neelkamal,

Refer these links:

http://help.sap.com/saphelp_bw33/helpdata/en/af/16533bbb15b762e10000000a114084/frameset.htm

Bye

Dinesh