LO & COPA Extraction!!

[Former Member]

Hi Experts,

I am new to Sap .I am learning extractors now..I find it very difficult understanding from the pdf file 350.Can anyone please give me some other links or a video demonstration of doing Lo and COPA extraction.And also a simple way of understanding delta and V3 update..i am really very confused and feel sad aas i been trying to get hold of this for last 2 days.

Thanks a lot for help in advance.

Shania.

[Former Member]

Hi kavi,

Thanks a lot for the references but the thing is i am new to this feild and trying to learn.i saw robert's weblogs but i didn't find any step by step guide.Till now with the help of pdf350 Leson:LO Customizing Cockpit.

I created extract structure,datasource.Now,the problem i am facing is i am not able to find my datasource in E13CLIENT800.This is what i did so far:

1.rsa1>context menu(T90CLNT090)>Customizing for Extractors.

2.Selected Information Structure S523.(which was available but had no LIS environment setup )

3.result said LIS envir..not setup,,Infosource 2LIS_02_S523 not generated.

4.I set up LIS environment and generated datasource for the information structure i created.

Now the problem arises.It says go to rsa1>context menu(T90CLNT090)>Datasource Overview>context menu on Apllication component MM(not MM-IO)>Replicate datasources.

I did till right clicking on T90CLNT090 and selected datasource overview. but i didnt find any application component for MM neither i found my datasource name when i searched.

Can anyone help me regarding this please?

Thanks.

[Former Member]

Hi

Roberto Negro weblogs are very informative.

follow this link to get a better understnding of LO extraction.

https://www.sdn.sap.com/irj/sdn/collaboration

rewarding points is saying a note of thanks in sdn.

kavi

[Former Member]

H kavi,

Thanks for the mail.I clicked this link but it again forwarded me to this forum.Can i ask u 1 more question i tried doing lo extraction from this url http://wiki.ittoolbox.com/index.php/HOWTO:How_to_do_LO_Extraction..But when i did the first step. my

datasource -

---

>>was empty.

Request no:--->test

Data records/calls---100

Display etr call---->10

update mode--->Fand other feld were empty.

Then i foloowed the second step.and when i reached "perform setup" it says relevant application.now what does that mean?and where should i give the name of teh run and execute?

I went to another site which says this to do in step by step.

Go to Transaction LBWE (LO Customizing Cockpit)

1). Select Logistics Application

SD Sales BW

Extract Structures

2). Select the desired Extract Structure and deactivate it first.

3). Give the Transport Request number and continue

i did select the extract structure in step 2 but now how do i deactivate that?

plzz help me i am so confused.

[edwin_harpino]

hi Shania,

LO

Roberto's weblog series

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

/people/sap.user72/blog/2004/12/23/logistic-cockpit-delta-mechanism--episode-two-v3-update-when-some-problems-can-occur

/people/sap.user72/blog/2005/01/19/logistic-cockpit-delta-mechanism--episode-three-the-new-update-methods

/people/sap.user72/blog/2005/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis

/people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it

other doc

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

COPA

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/fb07ab90-0201-0010-c489-d52...

[Former Member]

Hi

here is some notes i saved for myself as a qucik reference for LO. But plz be advised to go thro and make changes as per ur reqt.

LO-EXTRACTION

• T-Code: LBWE

• First we need to check which data source suits the client’s requirements in LBWE.

• Check whether it is in Active version/Modified version. If it is in M version go to RSA5 and select our data source and press on Transfer. Then go to RSA6 and see whether the datsource is been transferred.

• If the datasource is already in active version then we need to check whether the datsource is already extracting data in to BW.

• If the datasource is extracting the data then we need to check the data existence in Setup tables (use SE11 to check the setup tables data. For every extract structure one and only one setup table is generated whose technical name is Extract structure name+ setup, for eg. If extract structure name is MC11VAOHDR then set up tables name is MC11VAOHDRSETUP) and Extraction Queue (LBWQ) and Update tables(SM13) and Delta Queue (RSA7). If data exists in any of these T-codes we need to decide whether we need the data in BW or not. If we need the extract it as we do in LO-Extraction below. I f we don’t need delete the data.

The dataflow from R/3 into BW:

• we need to generate the extract structure by selecting the fields from the communication structure in LBWE.

• Generate the datasource and select the selection fields, cancellation fields, hide fields that we want.

• Replicate it into BW. Then we need to attach Info source(Transfer rules/communication structure) to the datasource. We got 3 methods to attach the infosource..

1) Business content:: Business content automatically proposes the transfer rules and communication structure, we don’t have to do anything manually.

2) Application proposal: Here too proposal is done but some objects will be missing which we need to assign in the transfer rules.

3) Others: here we need to create the transfer structure, rules, comm. Strct from the scratch.

• Modeling like infocube, Infosurce attachment,….

• Then activate the extract structure.

• We need to fill the setup tables for the first time loading. In filling the setup tables we can select between Full load and delta initialization loads.

Filling Set up table:

T Code : SBIW

Settings for Application-Specific DataSources (PI)->Logistics>Managing Extract Structures>Initialization-->Filling in the Setup Table -->Application-Specific Setup of Statistical Data --> in that Youcan perform the Setup (Example : SD-Sales Orders - Perform Setup) and execute .. or else direct T Code : OLIBW ( means based on your application like sales order/billing/ purchase etc)• For setup tables T-Code is OLI*BW where * equals to application number like 02 fro purchasing,08 for shipment…..

• First we need to decide whether we want delta loads to be performed in the future. If we want to do delta loads, then we need to go for Delta Initialization process or else do full load.

• When we perform setup tables extraction, since setup tables are cluster tables, we can’t see the data in the setup tables. So we go for Extractor checker (RSA3) just to see the setup tables data (full/delta initialization).

• Then create infopackage and select Full or Delta initialization in Update tab and schedule it.

• Delete the setup tables data by using LBWG.

• Now we need to do delta loads.

• Delta load data flow differs with various delta update methods. We got 3 delta update methods as u know.

• If we select “Queued Delta”update method then the data moves to Extraction queue(LBWQ). Then run Collective update to move the data from LBWQ into Delta Queue (RSA7). Then schedule the data using the infopackage by selecting Delta Load in the update tab.

• If we select “Direct delta” then the delta data moves into RSA7 directly.

• If we select “Unserialized V3” method then the data goes into “Update tables(SM13)”, then run Collective update to move the data from SM13 into RSA7. Schedule the data using infopackage.

• If we click on Maintenance, we can generate the extract structure.

• If we click on 2LIS_02_CGR button, then we we can generate data source

• Inactive under Update column: we can make a extract structure as active or inactive.

• If we click on Job control button the we can maintain the collective update parameters like, start time, and is it hourly once or dialy once ……

• If we click on Queued delta button under Update mode then we can select among 3 delta update methods.

• Only Full/Delta initialization data loads only moves into setup tables. Delta load data doesn’t move into setup tables.

**RSA3 contains only setup table’s data

• Only Delta update data moves into RSA7/LBWQ/SM13 no full/delta initialization loads data.

The type of work process:

DIA - Work process for executing dialog steps in user transactions

UPD - Update process for executing update requests

ENQ - Process for executing enqueue requests

BTC - Process for executing batch requests

SPO - Process for executing spool requests

UP2 - Process for executing V2 update requests

**all the credit goes to the person who wrote this**

kavi