cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping Sales Order line item

deva_gembali2
Participant
0 Kudos

Dear PI experts,

    Concept :

  FILE ---> PI --> IDOC

In my file ,Multiple Line items by same material but different quantity to map to IDOC.

Please advise me to group by Material and add quantities and map to IDOC.

Please send me udf if requrired else how to handle ? thanks you.

Deva

Accepted Solutions (1)

Accepted Solutions (1)

markangelo_dihiansan
Active Contributor
0 Kudos

Hi Deva,

You can group amounts by using formatByExample for the material number e.g

Amount --------------------------------> formatByExample -> sum (from statistic function) -> target

MaterialNum -> splitByValue:ValueChanged

Regards,

Mark

deva_gembali2
Participant
0 Kudos

Dear  Mark,

   if multiple order , multiple material, multiple quantites may come in same file . Then how can i group it

BY order wise, by Material wise adding up quantities . Please advise me. Thank you.

Deva

markangelo_dihiansan
Active Contributor
0 Kudos

Hi Deva,

Please provide us a sample input message and the expected output.

Regards,

Mark

deva_gembali2
Participant
0 Kudos

Dear Mark,

  ORDER, MATERIAL ,QTY

input :

0001  ,  MAT1, 1

   0001,    MAT1,  2

   0001,    MAT1,  5

   0001,    MAT2 , 10

   0001,    MAT2,  4

   0002  ,  MAT1, 1

   0002,    MAT1,  2

   0002,    MAT1,  5

   0002,    MAT2 , 10

   0002,    MAT2,  4

OUTPUT:

0001,MAT1,8

0001,MAT2,14

0002,MAT1,8

0002,MAT2,14

Thank you

markangelo_dihiansan
Active Contributor
0 Kudos

Hi Deva,

You could use the logic below:

QTY --------------------------------------------------------> formatByExample -> sum -> target

ORDER concat MATERIAL -> splitByValue:ValueChanged -> /

Regards,

Mark

Answers (1)

Answers (1)

former_member182455
Active Contributor
0 Kudos

Hi Dev,

you can write the UDF,

for (int i=0;i<var1[0];i++)

result.addValue("");

Regards

srinivas

deva_gembali2
Participant
0 Kudos

HI Srinu,

   could you please send me full screen by coversing source and target aswell.