Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Extraction and Loading data into BW from SD Extractor

Hi Gurus,

Can you Please advice me Step by Step procedure of extracting, tranformation and loading of data into BI 7 datatarget (Cube) from R/3 SD Extractor (ex. 2LIS_13_VDITM) ??

I need to know each of the steps from LBWE (R/3) to DTP (execute).

Please help...

I will definitely assign good points...

Former Member
Former Member replied

HI Akash,

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 inyour case 2LIS_13_VDITM 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

Hope this helps

Ravi

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question