MATNR is not repeating for multiple material type
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?
Roi Grosfeld replied
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