modelling design question - report requirement
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 ?