Here i would like to develop one Zreport & Z T code for the below requirement please provide your advise on this.
BOMs are created for the diff finished goods say FG1, FG2, FG3;In each BOM we will find one common raw matl say RM1.
Now i would like to see the consumption of this RM1 in production order in a particular period.
Ex: FG1 uses 3kg of RM1
FG2 uses 5kg of RM1
FG3 uses 2kg of RM1
Note: The above proportion is for base qty of 1 bag.
Inputs to my ZT code screen will be as below:
Material Number : RM1
From : 01.10.2010 To : 31.10.2010
Now my output should say
FG Matl no|Description|Qty of Raw matl |Produced bags|Total qty|UoM
at the bottom i would like to see the total consumption of this RM1 in a given period.
kindly help me how to provide a FS to develop this ZTcode or Z report