Skip to Content
0
Jan 12, 2007 at 08:14 AM

Target Field not being Populated as required

35 Views

Hi All,

Please can any one through some idea on this...

Source

Invoice Detail 1..9999

-->BatchNumber

-->LineNbr

--> MATNR

CartonDetail 1.9999

-->LineNbr

-->MATNR

Target

E1EDL24 1.9999

MATNR

E1EDL24(1) 1.9999 (Duplicate)

MATNR

Node level Has been Mapped such that Invoice Detail --> Batchnumber is * then E1EDL24(1) otherwise E1EDL24

This is working fine to node level

But for E1EDL24(1) >MATNR It should take MATNR if INVOICEDETAIl>LINENbr = CartonDetail-->LineNbr(where Batch number *)

It is taking only the first value ZM1 instead of ZM8

When i test the mapping i am geeting like this

Invoice Detail 1..9999

-->BatchNumber value 1

-->LineNbr Value 10

-->MATNR Value ZM1

Invoice Detail 1..9999

-->BatchNumber value 1

-->LineNbr Value 10

-->MATNR Value ZM2

Invoice Detail 1..9999

-->BatchNumber value *

-->LineNbr Value 30

-->MATNR Value ZM8

CartonDetail 1.9999

-->LineNbr Value 10

-->MATNR Value ZM1

CartonDetail 1.9999

-->LineNbr Value 10

-->MATNR Value ZM2

CartonDetail 1.9999

-->LineNbr Value 30

-->MATNR Value ZM8

CartonDetail 1.9999

-->LineNbr Value 20

-->MATNR Value ZM2

Target

E1EDL24 1.9999

MATNR value ZM1

E1EDL24 1.9999

MATNR ZM2

<b>E1EDL24(1)</b> 1.9999 for carton detail

MATNR <b>Zm1</b> should be <b>ZM8</b>

Thanks and Regards,

sridhar