Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Inventory management

Hi All,

I have a requirement to find out the Stock holding for a period.


Raw material

Work in progress

Finished goods

Annualized Finished goods stock consumption= quantity sold X historical moving average price/user input period *12.

when i go to the Stock cube i could only get issues and receipts and also valuated stock...i am confused how to identify

which is raw material,

which is Work in progress

which is finished goods

in that particular cube r else are these figures are seperatly stored.

please kindly help.

if any body want i can give the details of the KPI to their mail.

thanks and regards


Former Member
Former Member replied

Hello Neel,

I guess fields like material type, movement type will play a imp role to solve ur issues.

for eg: material type will decide a material to be a raw material or a finished product. Material type will be a attribute in the material master.

Movement types will tell the type of movement, i.e if a goods receipt, goods issue etc. try to discuss with the R/3 consultant to understadn the basis of knowing WIP.

also try and find out queries similar to your requirements from the standard queris.

try to refer to the following:

Hope it helps..


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question