Steps to load data from R/3 to BW

[Former Member]

Hi all,

1. I am loading data fromDS : 2LIS_12_VCITM to cube. Can somebody explain what steps we need to follow in R/3 and then in BW.

2. Also i have a Z - Extract Structure for 2lis_13_vditm,which has additional fields, how or where should i link 2lis_13_vditm with Z-extract. And how does the newly added fields get value?\

Thanks,

Gowri

[Former Member]

hi gowri,

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 u2013 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 u2013 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

[Former Member]

Hi Gowri,

1. Go to transaction code RSA3 and see if any data is available related to your DataSource (2LIS_12_VCITM ) . If data is there in RSA3 then go to transaction code LBWG (Delete Setup data) and delete the data by entering the application name 12 for your data source (2LIS_12_VCITM ).

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(Delta queue). 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.

I hope it will serve your requirements.

Regards

Suresh B.G.

[Former Member]

Hi,

Check this.

Regards.

[former_member205352]

Q1)

For loading from R3 2LIS_12_VCITM

1) Have a quiet period.

2)Delete set up tables.

3) Fill the set up tables.

4) Intialize delta on the BW side.

6) Check in RSA7 if you have delta queue.

7)From now on you can load delta at BW side.

Q2)

You can populate your Z fields in the user exit at R3 side.

Hope this helps.