BOM wise stock report.

[Former Member]

Dear Gurus,

Good Morning !!

My user' requirement is,

he wants a BOM wise stock report.

He will just enter the Header Item, Plant and the storage location,

and system should list all its sub-items with the stock available in that plant & the storage location.

PLease tell me if this is possible.

Thanks & Regards

[Former Member]

you may have to get a custom development done for this:

If I understand coreectly, there are two major steps in this:

1) Get the detailed BOM

To do this, you may use teh data from transatcion CS03(display material BOM), or from CS13 (Display summarized BOM) based on teh requirement. You may have to read table like MAST/STKO/STPO. For summarized BOM, you may use the function module CS_BOM_EXPL_MAT_V2

2) Get the available quantity

If your requiremnt is simple with the avialable qty, you may get the read the unrestrcited qty availble in tables MARC and MARD for quantities of a materila/ sub-items at the plant and storage locations level respoectively. If the requiremnts is to get more poslished available stock, you may use the std availability check concept (where we specify whether other stocks like quality check, in transit, etc need to be considered, or not). In this case function module AVAILABILITY_CHECK may be used and teh paranmter may be material, plant, Checking rule, etc.

Hope it helps.