All
Is there anyone using the Extractors extensively? I am not getting the DELTA data for the 0FI_AP_4 extractor…
Is there any order I should follow to make the DELTA work? Also will there be a way to check if the DELTA is processed in SAP System?
ganeshxp 
(BOB member since 2008-07-17)
Hi ganeshxp,
I’ve been working with FI_AP_4 and delta worked fine for me.
Important thing is that in the extractor you are setting Initial as YES (at the Dataflow, doulbe click on the extractor and Initial = Yes)
Then a FULL load will occur and at the same time it will Initialize the Delta logic, after it completes, you must set the INITIAL to NO, and then the changes made in the system since the first INITIAL load will come at the next execution.
You can also monitor which kind of execution is taking place at the transaction ODQMON.
Good luck!
inver5 
(BOB member since 2012-05-23)
Thanks that is what we’re doing as well - but when you use this approach, do you still need to supply a delta datetime to the extractor in the data flow?
Or does SAP retains the delta snapshot in the ERP/CRM system so that the extractor will automatically offer only delta records without any further input from Data Services?
ErikR 
(BOB member since 2007-01-10)
you don’t ‘have’ to supply the timestamp, but if you don’t you will never be able to re-run that delta. To re-run a delta you need to pass the exact timestamp to the extactor.
What we do is set a variable to sysdate()-1, print that out in our log via a scripting task and then pass the variable to the extractor.
If we ever need to re-run it, we can look at the old log to get the right timestamp.
Leigh Kennedy 
(BOB member since 2012-01-17)
But what about the Delta Queue Extractors? We can never get the data back once it is lost in a failure too! Currently we handle them by refilling the Initialisation queue and getting done in worst cases!
Anyone uses 2LIS_03_BF? I should probably open a topic for this in SDN for BW ! I am having an issue around this. Not technical…but functionally!
ganeshxp (BOB member since 2008-07-17)
You can get the deltas again if you do what I suggested. When you re-run, you would set the variable to be the same timestamp as the prior run.
Leigh Kennedy (BOB member since 2012-01-17)
Haha! nope not for the 2LIS extractors! They are different!
But yes, if the queue is not cleaned up though
ganeshxp (BOB member since 2008-07-17)
I have been able to run deltas again for the 2LIS extractors before.
Leigh Kennedy (BOB member since 2012-01-17)
Hi ganeshxp and Leigh Kennedy,
I have seen your blogs regarding Delta Mechanisms of Extractors.
I think you both have good experience in Extractors.
Actually i am new to Extractors part. Thing is i am trying to extract the Extractors like 2LIS_11_VAHDR, 0CUST_SALES_ATTR AND SO ON. I can able to import the Extractors which i need but the thing is i can’t able to view the data in SAP BODS (using VIEW DATA option). While selecting ‘View Data’ for the Extractors in BODS it is throwing error called
‘Vendor-Supplied Function Module ‘Z_AW_RFC_READ_EXTRACTOR’ not found. Ensure that you can execute the function module in SAP via transaction /nSE37.’
Can you please let me know, is there any settings that we need to do before we import the Extractors from ECC into BODS.
Appreciate for your help.
Thank You,
Sudheer
Sudheer Kodimi (BOB member since 2013-03-29)
Sounds like the transport files haven’t been installed correctly. See the SAP supplement manual.
Leigh Kennedy (BOB member since 2012-01-17)
Thank you Leigh Kennedy.
Actually i have copied the cofiles and data files from transport folder in sap bods into SAP ECC server based on the information given in the document.
There after i can’t able to execute the transport files in SAP ECC Server.
Can u send me the document or link that gives more clarity to execute the transport files in sap ecc side if possible.
Thank you.
Sudheer
Sudheer Kodimi (BOB member since 2013-03-29)
No idea - thats one for your ERP support guys. They should know what to do.
Leigh Kennedy (BOB member since 2012-01-17)