LO Extraction
1. Go to transaction code RSA3 and see if any data is available related to your DataSource. If data is there in RSA3 then go to transaction code LBWG (Delete Setup data) and delete the data by entering the application name.
2. Go to transaction SBIW –> Settings for Application Specific Datasource –> Logistics –> Managing extract structures –> Initialization –> Filling the Setup table –> Application specific setup of statistical data –> perform setup (relevant application)
3. In OLI*** (for example OLI7BW for Statistical setup for old documents : Orders) give the name of the run and execute. Now all the available records from R/3 will be loaded to setup tables.
4. Go to transaction RSA3 and check the data.
5. Go to transaction LBWE and make sure the update mode for the corresponding DataSource is serialized V3 update.
6. Go to BW system and create infopackage and under the update tab select the initialize delta process. And schedule the package. Now all the data available in the setup tables are now loaded into the data target.
7. Now for the delta records go to LBWE in R/3 and change the update mode for the corresponding DataSource to Direct/Queue delta. By doing this record will bypass SM13 and directly go to RSA7. Go to transaction code RSA7 there you can see green light # Once the new records are added immediately you can see the record in RSA7.
8. Go to BW system and create a new infopackage for delta loads. Double click on new infopackage. Under update tab you can see the delta update radio button.
9. Now you can go to your data target and see the delta
Some more info @
https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1096
https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1106
https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1183
2 Responses to LO Extraction
Hi ,
one question.
if the update mode is queued delta..Then transactions will first go to Extraction Queue and afer the LBWE job runs they will be transfered from LBWQ to RSA7...
AM i RIGHT ?
suppose I am working with app area02 (purchasing )..my datasources are :-
1. 2lis_02_HDR
2. 2LIS_02_ITM
3. 2LIS_02_scl
all three were initialized but after some months initialization of 2lis_02_scl failed.
now how should i proceed ?
Thanks for your reply...your answer can really help me clearling a big doubt of mine..
Manish
Dear Manish,
Why suddenly initialization creating problem now..? any upgrades at R/3 or BW side..? are you getting problem with Delta's or new initialization...?
You can do 2nd initialization for same source system(r/3) and target(ODS or CUBE) for same datasource.
Hope it Helps
Srini
Something to say?