Calculate Invoiced weight/ Ordered weight in 0SD_C03 InfoCube

[Former Member]

Hi Experts,

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.

Abdess,

[Former Member]

Hi Abdessamad

you can create two restricted key figures for Invoiced weight and Ordered weight based on char values which decide whether it is invoice or order, then calculate Invoiced weight/Ordered weight by a formula or CKF.