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

[Former Member]

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

[Former Member]

Dear Mangal Raj ,

Thank you for your reply...

[former_member184655]

Dear Kumar,

You can use any one of this Functional Module,

CS_WHERE_USED_MAT Bills of material; where-used list

CS_WHERE_USED_MAT_ANY Bills of material; where-used list as material or class item

MASS_WHERE_USED where used list for mass maintenance screens

CSEP_MAT_BOM_SELECT_WHERE_USED API Bills of Material: Select BOM(s)

Regards

Mangalraj.S