Skip to Content
0
Former Member
Dec 19, 2008 at 05:40 AM

Z report where used bom (how to relate the item and header )

51 Views

Dear all ,

I want to create the new Z report for where used list for bom materials .

I am having 2 alternate boms for the finished material .

In the two boms i am using the one common raw material with differant usage qty .

I got all the item details in the table STPO based on the BOM number (STLNR) , and i got the details fo the finished materials details in the table MAST based on the BOM number(STLNR) .

Here my problem is how to relate the exact alternative bom(STLAL) for the raw material i got in the table STPO .

BOM

Finished material : TESTFINISH

alternative bom :1

plant :1000

item item cat component qty

0010 L TESTRAW-1 1

0020 L TESTRAW-2 1

Alternative bom -2

Finished material : TESTFINISH

item item cat component qty

0010 L TESTRAW-1 2

0020 L TESTRAW-2 1

In the above bom the testraw-1 material is used in both the boms with differant qty .

My input parameters in the report

Plant ;

Material(Raw material) :

Out put

Material (Raw) Finished mat Alternative bom Usage qty

TESTRAW-1 TESTFINISH 1 1

TESTRAW-1 TESTFINISH 2 2

I hope that you all understand my requirements .

If i need to use any Functional module , what are the input parameters ?

I am expecting your valuable suggestions .

Best Regards,

Kumar