Query for BOM components stock

[Former Member]

I have written a query to display stock of all the BOM components by joining table MARA,MAST,STPO & MARD.

But when I run the query then system is not displaying any result.

Any suggestion on how to get Stock of all BOM components, I am putting header material no & plant in selection screen.

Or is there any std report through which I can get stock of all BOM components.

Thanks

apr

[former_member184655 · Accepted solution]

Dear Prasad,

You can not achieve this by creating a query.This can be achieved only a Z Report.

You can use this FM CS_BOM_EXPL_MAT_V2 for preparing Functional Spec's for BOM explosion and in the output format you can

include the component's along with their unrestricted Stock that can be taken from the table MARD.

Check and revert back.

Regards

Mangalraj.S

[csaba_szommer]

First of all, you should decide whether there is any point in creating such report. I mean:

- SAP has standard stock reports (like MB52) >> you can paste the material number of components as selection criteria

- If you check the header material of your BOM component in MD04 you choose "Show overview tree" and then "Order report" icon >> this will explode the BOM (used in the MRP element) of the header material and you can go through the MRP list of all components (please be aware of that MD04 shows the stock level)

If you adhere to your own report I suggest to use MAST-STKO-STPO with MARD. However, storage location is key field in MARD that's why you may get several records for one component based on the number of storage location you use.

Please also notice that MARD is only one stock related table, if you are working special stocks (e.g subcontracting, sales order, projetc, consignemnt, etc) you need additional tables...

So, even if you want to create such a report you should use ABAP instead of query.

But I suggest to use standard SAP stock reports...and MRP list...

Regards,

Csaba

Edited by: Csaba Szommer on Jul 15, 2009 8:03 AM

[Former Member]

I wrote a query by joining tables MAST-STPO & MARD but system is giving message that No record found.

Can you please tell me that what mistake I am doing while creating Query.

Thanks

apr

[Former Member]

Any other solution