Z TCode for raw matl

[Former Member]

Dear Expert,

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

FG1|Finished Goods1|3|10|30|kg

FG2|Finished Goods2|5|20|100|kg

FG3|Finished Goods3|2|40|80|kg

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

Regards

TG

[Former Member]

clsd.

[Former Member]

FG Matl no|Description|Qty of Raw matl |Produced bags|Total qty|UoM

Dear,

Except [Produced bags] remaining details will come through MB51, Yes? To get related produced bags, did you try any solution through query possible ? I do believe that RM is maintained with alternate UOM.

Regards,

Syed Hussain.

[Former Member]

Hi,

Yes i tried with MB51 before posting in SDN,all RMs are with BaseUoM as KG only, Please can help me how to run query on this requirement with T code & input field selection.

Regards

TG

[Former Member]

Can anyone ans to my question plz?

[JL23]

use SE38 to develope a Z-report, then use SE93 to create Z transaction for this Z-report.

[Former Member]

closed

[Former Member]

Plz can anyone help on this....