How to perform LO extraction from SAP R/3 to BW system?

**check whether your Datasource is active and in accordance with the requirements “TCode LBWE”**

Step1:-

Transaction code “RSA3”

Check whether the data is updated for the Data Source

Transaction Code “LBWG”

Delete data in setup table by giving the correct application name.

** Check whether the Datsource is already extracting data in to BW. If the Datasource is extracting the data then we need to check the Setup tables (“SE11” Technical name is ‘SETUP’, Extraction Queue (LBWQ), Update tables (SM13), Delta Queue (RSA7) etc. If data exists in any of these TCodes we need to check whether we need these data in BW or not. If we not need the data delete it using “LBWG”.**

Transaction Code “SBIW”

Navigate to “Settings for Application Specific Data Source (PI)” >> ” Logistics” >> ” Managing Extract Structures” >> ”Initialization” >> “Filling the Setup Table” >> “Application Specific Setup of Statistical Data” >> “Execute for application”

[**or one can directly use the TCode OLI^^BW (^^based on your application)**]

In the next screen give name to the run and execute. Now all the available records from R/3 will get updated to Setup tables

** Only Full/Delta initialization loads will move to Setup tables**

Step2:-

Transaction code “RSA3”

Check whether the data got updated.

Transaction code “LBWE”

Check whether the update mode for DataSource is “Unserialized V3”

**Delta Load data flow differs with various update methods, there are three delta update methods

1.      “Queued Delta”:- Data will move to Extraction queue (“LBWQ”) and then run collective update to move the data to Delta Queue (“RSA7”).

2.      “Direct Delta” :- Data will move to RSA7 directly

3.      “Unserialized V3” :- Data will go to Update tables (“SM13”), then will run collective update to move the data to RSA7 **

Step3:-

Login to BW system and initialize the delta process by scheduling the corresponding InfoPackage. All the data that is available in the setup tables are now loaded to data targets. **First time process**

Transaction code “LBWE” (R/3)

Change the update mode for corresponding Data Source to “Direct/Queue delta”. Data will bypass SM13 and directly go to delta queue in RSA7.

** Only Delta update data moves into RSA7/LBWQ **

Transaction code “RSA7”

Queue will be marked in green. Once the new records are updated one can immediately see the records in RSA7.

Go back to BW system and create new infopackage for delta load and schedule the load.

Cross check the data in Data target