Skip to Content

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

To Add Quantity in mapping in case if Line items have same Material and same sales order

Hi all

We have an existing interface file to Idoc (DESDAV).

At present though multiple line items has same Material and same Sales Order quantity is received in each segment.

New requirement is to add Quantity.

Example:

Input:

Order1      Material1     2(Quantity)

Order1      Material1     5(Quantity)

Order4      Material3     1

Order5      Material3     10

Output:

Order1     Material1     7(Quantity)

Order4      Material3     1

Order5      Material3     10

Idoc:

E1EDL24

     KDMAT (Material)

     LFIMG  (Quantity)

     E1EDL41

          BSTNR (sales order)

Former Member
replied

Hi Anitha!

In case of data groupping by some key with aggregation you can map message to itself in first step with following transformation:

In second step you can map result message with same structure and groupped data to IDoc.

Regards, Evgeniy.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question