Calculate Invoiced weight/ Ordered weight in 0SD_C03 InfoCube
I have a requirement to calculate the invoiced weight / Orderd weight. I knew that the 0SD_C03 contains orders, invoices and delivries items with all information like, Material, Company, Weight, Amount, Quantity...Etc.
I m confused on how to use this infoCube to calculate Invoiced weight / Orderd weight because this two mesures exists on different records. The first one, Invoiced weight, exists in invoices records. And the second one, Orderd weight exists on orders records...
Can you just guide me on how to calculate Invoiced weight/Ordered weight.
thank's a lot.