I have a requirement to find out the Stock holding for a period.
Work in progress
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
Abhijit Bhalerao replied
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..