on 05-26-2011 11:46 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Roi,
Thanks for your help. Its working now.
Regards,
Cj
Edited by: kuncjy on May 27, 2011 8:11 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.