Skip to Content
Jul 30, 2013 at 01:13 PM

Getting data from SAP b1 database based on BOM .


Hi All,

I have a mother item ABC and i have defined BOM for this mother item with the child items A,B,C. I have defined the following quantity in the bill of materials for the child items as mentioned below .

For Product A : 1

For Product B : 2

For Product C : 1

and in the child items have below stocks in the item master

For Product A : 30

For Product B :70

For Product C : 34

Now I want to find how many mother items 'ABC ' I can made based on the BOM items defined by using SQL query.

Thanks and Regards

Utpal Maity