cancel
Showing results for 
Search instead for 
Did you mean: 

MATNR is not repeating for multiple material type

Former Member
0 Kudos

Hi EveryOne,

I'm mapping MATMAS with sql structure(which consists of 8 tables). Everything is working fine except the multiple MARMM segments. MARMM is linked with table8 when i tested it in messagemapping its creating multiple ACCESS's but the primary key (MATNR number) and the Itemcode were not created in the second and third ACCESS.

*Column Name_ Data Type_ *

Item_CD : nvarchar (material number)

Plant_ID : nvarchar (item code)

EAN_CAT : nvarchar

EAN : nvarchar

Numerator_For_Conversion_To_BaseUOM : Numeric

Display_UOM : Numeric 3

Denominator_for_conversion_To_baseUOM : Numeric

after executing the result is:

ACCESS1 contains all the records

ACCESS2 contains only 3 fields which are from MARMM. (rest are not comming)

Can someone please help me regarding this?

Regards,

Cj

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

look at the queue in the message mapping and you will see a much smaller number of entries in the queue of the MATNR then the other fields from MARMM.

you need to duplicate the MATNR according to the number of times that MARM appear for this you need to use the node function "UseOneAsMany".

read the documantation of the function to know how to operate it.

if you still having problems i try and give you an example

regards,

roi grosfeld

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Roi,

Thanks for your help. Its working now.

Regards,

Cj

Edited by: kuncjy on May 27, 2011 8:11 AM