How to LO extraction?

What exactly do you want to extract?

Most commonly, standard bw extractors from BC are used (2_LIS_02_* for Purchasing and 2_LIS_03_* for Stocks). To customize them in R/3, you should activate them from BC (RSA5), and then customize them in SBIW (Business Information Warehouse->Settings for Application-Specific DataSources->Logistics->Managing Extract Structures->Logistics Extract Structures Customizing Cockpit (LBWE trans))

Hi Samik

Follow are the steps for LO Extraction

Here is LO Cockpit Step By Step

LO EXTRACTION

- 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

4). Click on `Maintenance' to maintain such Extract Structure

Select the fields of your choice and continue

Maintain DataSource if needed

5). Activate the extract structure

6). Give the Transport Request number and continue

- Next step is to Delete the setup tables

7). Go to T-Code SBIW

8). Select Business Information Warehouse

i. Setting for Application-Specific Datasources

ii. Logistics

iii. Managing Extract Structures

iv. Initialization

v. Delete the content of Setup tables (T-Code LBWG)

vi. Select the application (01 – Sales & Distribution) and Execute

- Now, Fill the Setup tables

9). Select Business Information Warehouse

i. Setting for Application-Specific Datasources

ii. Logistics

iii. Managing Extract Structures

iv. Initialization

v. Filling the Setup tables

vi. Application-Specific Setup of statistical data

vii. SD Sales Orders – Perform Setup (T-Code OLI7BW)

Specify a Run Name and time and Date (put future date)

Execute

- Check the data in Setup tables at RSA3

- Replicate the DataSource

Use of setup tables:

You should fill the setup table in the R/3 system and extract the data to BW - the setup tables is in SBIW - after that you can do delta extractions by initialize the extractor.

Full loads are always taken from the setup tables

Hi Samik

The following weblogs are useful for LO Extraction

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-98bd7c01e328

Cheers

Shiva