Hi experts --- LO Data extraction *Navigation Steps

[Former Member]

Hi experts,

can anybody tell me the navigation steps for LO Data extraction with tcode.

regards

mahesh

[Former Member]

Hi.......

To do basic LO extraction for SAP-R3-BW :

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 record.

find your scenario and find what data sources do you need on R3 side and ensure they are active as well:

http://help.sap.com/saphelp_nw04/helpdata/en/37/5fb13cd0500255e10000000a114084/frameset.htm

find your scenario -> data sources -> go to R3 -> sbiw and activate required data source

replicate data sources in BW:

RSA1 -> source systems -> right click on your source system -> replicate

then activate your BC:

Chek this blogs from Roberto for LO:

/people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146

Also go through this link to know the procedure step by step

http://www.sap-img.com/business/lo-cockpit-step-by-step.htm

Also the How to docs:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98b...

BI content:

http://help.sap.com/saphelp_nw2004s/helpdata/en/17/cd5e407aa4c44ce10000000a1550b0/frameset.htm

Kindly assign pts if helpful....

Regards,

Debjani.......

[Former Member]

Hi Mahesh,

Steps -

1)LBWG - Delete Set-up tables

2)LBWE -->Application area(Purchasing)

Activation of extract structures

Click >Structure>Maintenance

Click>Datasource>2LIS_02_HDR

Click>Update>Active

Click>Update Mode>Queued Delta

Green light should appear on each extraction structures after all STEPS

3)SBIW settings-based on Application area

Inventory Controlling

IMPORTANT - ORDER OF LOADING

ALWAYS LOAD in order as BX datasource first then BF datasource and then UM datasource in cube

a)SBIW>Setings for Application -specific Datasources(PI)>Logistics-->Settings:Inventory Controlling -->

Select Determine Industry sector

Select Transaction Key Maintenance for SAP

Transaction key is used for Process key mappings w/t these the data would not load in to BW though it would come in PSA

b)Select Stock Initialization or TCODE - MCNB

Purchasing

a)SBIW>Setings for Application -specific Datasources(PI)>Logistics-->Settings:Purchasing

Select Determine Industry sector

Select Transaction Key Maintenance for SAP

4)Fill Set up tables

SBIW>Setings for Application -specific Datasources(PI)>Logistics>Managing extract structures>Initialization>Filling in the set up table>Application specific setup of statistical data.

OR

OLI*BW -example for Inventory transaction is OLI1BW

5)BW -Replicate datasources

Please check the below links:

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1522. [original link is broken] [original link is broken] [original link is broken]

/people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146

Regards

Pcrao.