Final product of raw material

[Former Member]

Hi,

I need to develop a report, when I give a raw material end result must be a final product omitting all other semifinished assemblies.

can anyone guide how to solve this

[Former Member · Accepted solution]

Hi Krishnan,

Study the report CS15, it is doing what you are expected to do. The only difference is, it reads all levels upto the top parent.

Anyway you can use the FM - > CS_WHERE_USED_MAT to achieve the same. You need to loop back the output to input & this way read all the way upto the top parent.

But a word of caution, if a single raw material is associated with multiple top parents, then you will have to handle this case.

Hope the above helps.

Regards,

Vivek

[Former Member · Accepted solution]

Hi Vivek,

Can you pls send me the code, where specifically we need to pass the output as input for next level? I have used Fm - CSEP_MAT_BOM_SELECT_WHERE_USED. I got till second level & need to get all the levels.

[Former Member · Accepted solution]

hi,

The output of the FM i.e. T_BOM_HEADER in this pass the value of the field - Material to an internal table & then loop back this as an input to your FM.

But are you sure you want to use CSEP_MAT_BOM_SELECT_WHERE_USED? As it does not have an input selection field for Plant.

Hope it answers your query.

Regards,

Vivek

[Former Member]

Use this FM to achieve final products from a raw material - 'CS_WHERE_USED_MAT'

call this fm thro' subroutine till you get parent product. check the table WULTB whether it is initial or not & pass the output as input to the same fm.