Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
General Comment
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

what is your expected outcome?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi lbendlin ,

     

    My expected outcome as below

     

    Production OrderAbnormality Category Abnormality Quantity (M2) Machine Total GR 
    100001709052C1_Scratch                                         58.50640 CH Machine  10,368.00
    100001709052C7.Moist.W                                         87.00640 CH Machine0
    100001709052C7.Moist.W                                         28.50640 CH Machine0
    100001709052C7.Moist.W                                         18.00640 CH Machine0
    100001709052A5.Adh Line                                         87.00640 CH Machine0

     

    Regards,

    Nuha

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi lbendlin ,

         

        No. The "Total GR" coming from another data model. I merge it with the current model