Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MATNR is not repeating for multiple material type

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?





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


roi grosfeld

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question