Skip to Content

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

Inventory Transfer PLD total quantity


We are trying to add total quantity to the standard Batch report PLD at BTN3 level for inventory transfer. We are using colsum() for a column that is in the repetitive column. However, It is not adding the total quantity it is only adding partial quantity. Any advise?

Former Member


Try this solution:

1. Create new header level at inventory transfer to get total quantity.

2. Run below FMS and assign this query above UDF field.

SELECT SUM(T1.[Quantity]) FROM OWTR T0  INNER JOIN WTR1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.Docentry = $[OWTR.Docentry]

3. Edit PLD to get UDF field to get total quantity.

Over all view:

0 View this answer in context

Helpful Answer

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