Skip to Content

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

modelling design question - report requirement

Hi All,

We have a requirement to get the PO number and line items and the scheduled quantity for each line item along with the PO header amount value in a single row. We are getting these values in 3 different datasources right ? How can I get all the three in a single line ? I mean there are different aggregations in all the 3 datasources. Can you please advice how to do the modelling for this scenario below. I appreciate it.

We are getting PO number and PO line item from 2LIS_02_ITM DS

We are getting the schd qty and issued qty from 2LIS_02_SCL Datasource

We need the PO HDR amount from 2LIS_02_HDF DS, no problem if we can get the same HDR amount for all the line items of that PO.

Can you please advise the modelling scenario... I what key to consider while loading 2LIS_02_ITM ,2LIS_02_SCL into a DSO's and how do we get the PO HDR amount for each of the line item and how to aggregate the scheduled line item's for a PO line item.

Do we need to load 2LIS_02_ITMĀ  & 2LIS_02_SCL into a DSO where PO number and PO line item will be the key, wont the KF get jumbled up ? How do we summarize this data with PO HDR data ?

Thank You

DR

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