Inventory Data Extraction.

[Former Member]

hi experts,

I am doing an Inventory data extraction with extractor 2LIS_03_BX.

The Steps i m doing are as follows:-

1) In the R/3 System using t-code LBWG, I am first deleting the entries of

Inventory setup tables(Chosing option 03).

2) Then from t-code MCNB, i am filling the set up tables for extractor 2LIS_03_BX.

Here I m geeting a message that "1000 records selected for BW".

3) Now in the R/3 side if again i m looking for the data in datasource(2LIS_03_BX) in RSA3

I m not getting the data records there(showing 0 records).

Can anyone tell what is the reason for this. how can i get the setup tables

filled and data in datasource 2LIS_03_BX in R/3 side.

Thanks

Mrityunjay.

Edited by: mrityu003 on Nov 13, 2009 5:15 AM

[Former Member]

thanks, i m closing this thread

[Former Member]

Hi,

Please follow bellow steps:

Go to Transaction LBWE (LO Customizing Cockpit)

1). Select Logistics Application

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

3). Click on `Maintenance' to maintain such Extract Structure.Select the fields of your choice and continue.Maintain DataSource if needed

4). Activate the extract structure

5). Delete the setup tables (T-Code LBWG)

Select the application (EX:11 u2013 Sales & Distribution) and Execute

6). Fill the Setup tables

7). Select Business Information Warehouse(SBIW)

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

8). Check the data in Setup tables at RSA3

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 .

Regards,

Suman.

[Former Member]

Hi ,

Check following steps for BX data source

Activate ds from RSA5

Delete Set up tables (LBWG) --->03

Initialise stock in ECC--> t-code MCNB

Fill up Set up table OLI1BW

Then pull data from BI.

Regards

Rahul Bindroo

[Former Member]

Hi Rahul,

Your reply seems quite useful, but still when i m implementing the t-code oli1bw

i m getting a meesage "No Extraction Structure Active or no BW Connected".

But in LBWE when i m looking for the extractors 2LIS_03_BF and 2LIS_03_UM,

the looks to be in active state(green).

And also from BW side when i m testing for RFC connection by just clicking on

replicating the Data Source in source system (R/3) , the Data source is

getting replicated, so the BW conection is also maintained, but still i m getting the error!!!!!

Edited by: mrityu003 on Nov 13, 2009 5:55 AM