Forum Discussion
How to get data that not sum & not count
Hi all, Previously I merger SAP_PPT_EV_ProductionOrderConfirmationAdd (3) with SAP_PPT_EV_MaterialDocument_TotalGR by production order to get the total GR and the table show as below. Do you have...
Hi lbendlin ,
My expected outcome as below
| Production Order | Abnormality Category | Abnormality Quantity (M2) | Machine | Total GR |
| 100001709052 | C1_Scratch | 58.50 | 640 CH Machine | 10,368.00 |
| 100001709052 | C7.Moist.W | 87.00 | 640 CH Machine | 0 |
| 100001709052 | C7.Moist.W | 28.50 | 640 CH Machine | 0 |
| 100001709052 | C7.Moist.W | 18.00 | 640 CH Machine | 0 |
| 100001709052 | A5.Adh Line | 87.00 | 640 CH Machine | 0 |
Regards,
Nuha
Would you always assign the "Total GR" value to the C1_Scratch abnormality?
It may be easier to create a proper data model. That way you don't need to do the merges, and the data model can do all the work for you.