0MAT_DOC missing in 2LIS_03_UM

[Former Member]

Am presently uploading 2LIS_03_BF into an ODS which has 0CAL_YEAR,0BWCOUNTER,0MAT_DOC and 0MAT_ITM as the key fields. I also want the same ODS to source data from 2LIS_03_UM. However the above keyfields are not there in the 2LIS_03_UM. Other threads(and also note 417703) seem to suggest that the same key figures <i>are</i> available in 2LIS_03_UM. ( The corresponding R3 fields are MBLNR, MJAH & ZEILE). Can anyone suggest how I can create a single ODS sourcing both 2LIS_03_UM and 2LIS_03_BF ?

Am on 3.5 with the SP19.

Thanks in advance.

D

[Former Member]

Replicate your datasource into BW.

Create new infosource and assign datasource as 2LIS_03_UM.

In transfer rules, assign 0MAT_DOC to MBLNR

0mat_itm to ZEILE

0CAL_YEARto MJAHR

in right side of the transfer rules

and map them to left side.

Activate your Infosource and create update rules to your ODS based on above new infosource.

cheers

sb

assign points if useful

[former_member188975]

Hi Dorothy,

Not sure if that would go well...as per note 581778 the keys for 2LIS_03_UM are:

1. MCMSEG-BUKRS

2. MCMSEG-BELNR

3. MCMSEG-GJAHR

4. MCMSEG-BUZEI

[Former Member]

Bhanu,

Thank you. So I guess I have to use a second ODS. Part of my problem with the inventory DS's was their joint association with 0IC_C03. Am using the ODS as a drilldown for the cube which is why I wanted only one ODS. So I guess if there are CO-PA type queries requiring drilldowns I will have to use the 2nd revaluations ODS.

What do you think ?

D