Skip to Content
author's profile photo Former Member
Former Member

Query for BOM components stock

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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 15, 2009 at 08:45 AM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 15, 2009 at 06:02 AM

    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...



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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.