Skip to Content

In stock, Committed, On Order

Hello,

I just started using SAP, and I want to to generate a report that list all the part numbers related to the device I am building (BOM). In this BOM, I want 3 specific columns that show how many of these parts I have in stock, committed and on order. I would like to export this BOM to excel too. I would appreciate any help. Thank you!

Add a comment
10|10000 characters needed characters exceeded

  • Hi Osama,

    Warm welcome and thank you for visiting SAP Community to get answers to your questions. I am here to help you to get the most out of it.

    First of all, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't done so already), as it provides tips for preparing questions that draw responses from our members.
    For example you:
    - can outline what steps you took to find answers (and why they weren't helpful)
    - can share screenshots of what you've seen/done
    - can use a descriptive subject line

    Please also make sure you're using all appropriate tags, so the right experts can find your question. Overall, the more details you provide, the more likely it is that members will be able to assist you. Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question - but if that happens, you can leave more details in a comment).

    Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

    Best regards,
    Lena (SAP Community Moderator)

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 22, 2020 at 12:59 PM

    Hi,

    Try this query up to six level of components

    SELECT

    T0.[Father] as 'Assembly',

    T0.[code] as 'Component1',t10.[ItemName] 'Description1',T10.[OnHand], T10.[IsCommited], T10.[OnOrder],

    T1.[Code] as 'Component2', t11.[ItemName] 'Description2', T11.[OnHand], T11.[IsCommited], T11.[OnOrder],

    T2.[Code] as 'Component3', t12.[ItemName] 'Description3', T12.[OnHand], T12.[IsCommited], T12.[OnOrder],

    T3.[Code] as 'Component4', t13.[ItemName] 'Description4',T13.[OnHand], T13.[IsCommited], T13.[OnOrder],

    T4.[Code] as 'Component5', t14.[ItemName] 'Description5', T14.[OnHand], T14.[IsCommited], T14.[OnOrder],

    T5.[Code] as 'Component6', t15.[ItemName] 'Description6',

    FROM

    ITT1 T0 LEFT OUTER JOIN ITT1 T1 on T0.Code = T1.Father

    LEFT OUTER JOIN ITT1 T2 on T1.Code = T2.Father

    LEFT OUTER JOIN ITT1 T3 on T2.Code = T3.Father

    LEFT OUTER JOIN ITT1 T4 on T3.Code = T4.Father

    LEFT OUTER JOIN ITT1 T5 on T4.Code = T5.Father

    LEFT OUTER JOIN ITT1 T6 on T5.Code = T6.Father

    left outer join oitm t20 on t0.father = t20.itemcode

    left outer join oitm t10 on t0.code = t10.itemcode

    left outer join oitm t11 on t1.code = t11.itemcode

    left outer join oitm t12 on t2.code = t12.itemcode

    left outer join oitm t13 on t3.code = t13.itemcode

    left outer join oitm t14 on t4.code = t14.itemcode

    left outer join oitm t15 on t5.code = t15.itemcode

    Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 22, 2020 at 11:36 PM

    1. Copy above query

    2. Go to Tools-->Queries-->Query Generator-->Click Execute-->Click pencil icon to activate edit mode.

    3. Paste the above query

    4. Click run

    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.