Extraction and Loading data into BW from SD Extractor

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Ravi,

Thanks so much.

Can you please tell me about Tranformation and Migration.

I do not have clear idea about them.

Thanks.

Points assigned

[Former Member · Accepted solution]

Hi Akash,

When replicating datasource, you will be asked for option 3.x datasource or 7.0 datasource.

when you are selecting 3.x datasource, then you can right click on that datasource and can migrate to 7.0

or directly u can select that option.

First create transformation and then DTP to schedule data from Datasource to target.

follow below links for clear idea.

http://help.sap.com/saphelp_nw70/helpdata/en/43/03b1f4dc636e72e10000000a422035/frameset.htm

fro transormation

http://help.sap.com/saphelp_nw70/helpdata/en/f8/7913426e48db2ce10000000a1550b0/frameset.htm

for creating transformation

http://help.sap.com/saphelp_nw70/helpdata/en/d5/da13426e48db2ce10000000a1550b0/frameset.htm

for DTP

http://help.sap.com/saphelp_nw70/helpdata/en/c5/85e5414f070640e10000000a1550b0/frameset.htm

hope you get some idea now

Ravi

[Former Member]

Thanks all for your support !!!

[Former Member]

Hi Akash,

Follow the steps mentioned below.

1. Lock all psotings for sales in R/3.

2. Go to tcode OLI9BW in R/3. Give and name for the run and change the termination date to a date in future. Execute this in background using the Program menu.

3. Monitor this job in SM37.

4. Once this finishes do an init with data transfer to BI.

5. Unlock R/3 postings.

6. Schedule V3 job in LBWE.

7. Schedule the delta.

Hops this helps.

Regards,

Sumit