Extraction of inventory datasources

[Former Member]

Hello Gurus

I need complete step by step procedure for extraction of inventory datasources from the R/3 syatem to a fresh BW system...i'll appreciate a prompt reply and detailed information will be speciall rewarded with max. points

[Former Member]

Hi Akash,

Inventory Management :

R/3

1. Goto RSA5 - Activate data sources 2LIS_03_BX,2LIS_03_BF,2LIS_03_UM.

BW

2. Replicate data sources

3. Business content in RSA1. Install 0IC_C03 cube data flow before and after

R/3.

4. Tcode: LBWE Activate 2LIS_03_BF and 2LIS_03_UM

5. Tcode: MCNB generate intial stock

6. fill the setup tables for 2LIS_03_BF, AND 2LIS_03_UM under SBIW- Logistics-Maintaince extract structe-filling setup tables - Inventory management - Material movements and Material revaluations.

7. Load the data in BW side for 0IC_C03 cube.

Please let me know if u want any more information.

Thanks,

Chandra

[Former Member]

Hi there,

this how-to guide will help you. https://www.sdn.sap.com/irj/sdn/howtoguides?rid=/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e328

Follow it step by set and nothing will go wrong, have used it so many times at different customers.

Kind regards

/martin

[Former Member]

Tnx for the prompt reply people ..there is a slight twist...as i got to know now that we have to enhance the the standard inventory datasorces and need to get them into a fresh BW system...i'lll appreciate if you people could share your realtime experiences regarding this and help me with some documents for the same....

[Former Member]

Hi

To enhance the standard structure you will have to

append fields in Extract structure

Structure name from RSA6

Then write a user exit

Component RSAP0001

Enhancement EXIT_SAPLRSAP_001

in the Function module write the

when 'DATASOURCE'

followed by your code

[former_member181964]

Dear friend,

If you want to enhance the datasources in LO, you need to follow the steps.Just week back we did some enhancement for LO datasource.

1. Clear all Qs i.e SMQ1/LBWQ.

2. For UM datasource you can find MC03BF0 is the structure, this you see it in RSA3 (just extract data and see in RSA3).

3.Goto mc03um0 in SE11 and append the structure and give the feild and dataelement and activate it.

4.And then go to CMOD and find your Enhancement program or create (under EXIT_SAPLRSAP_001) it and write code like below.

DATA: l_s_data9 LIKE mc03um0.

WHEN '2LIS_03_UM'.

DATA : l_subrc TYPE sy-subrc.

LOOP AT c_t_data INTO l_s_data9.

l_tabix = sy-tabix.

SELECT SINGLE blart INTO (l_s_data9-blart) FROM bkpf

WHERE bukrs = l_s_data9-bukrs

AND belnr = l_s_data9-belnr

AND gjahr = l_s_data9-gjahr .

l_subrc = sy-subrc .

SELECT SINGLE lifnr INTO (l_s_data9-lifnr) FROM bseg

WHERE bukrs = l_s_data9-bukrs

AND belnr = l_s_data9-belnr

AND gjahr = l_s_data9-gjahr

AND koart = 'K'.

IF ( l_subrc = 0 OR sy-subrc = 0 ).

MODIFY c_t_data FROM l_s_data9 INDEX l_tabix.

ENDIF.

ENDLOOP.

and activate it and check it on RSA3.

Thanks

Reddy