Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

What is SAP B1 query for Parent Item, Quantity, Child Item & Total sum of BOM Stock Quantity?(e.g. if 00050B,00050BO,00050FG,00050LG is BOM data & in hand quantities are 50, 40, 10 & 15. I want below result from the query) :


Dear Experts,

What is SAP B1 query for Parent Item, Quantity, Child Item & Total sum of BOM Stock Quantity?(e.g. if 00050B,00050BO,00050FG,00050LG is BOM data & in hand quantities are 50, 40, 10 & 15. I want below result from the query) :

Parent Item    Quantity   Child Item   in Stock

00050B             267         RM.....        77220

00050BO           1           ........               456

0005FG             357        ........            4500

00050LG            500        00050B      500

      Total Sum of In Stock Qty.           82676

Not what you were looking for? View more on this topic or Ask a question