You’re offline. This is a read only version of the page.
17
Hi All ,
This is my first post on this forum - I apologize if I am not able to phrase my question correctly .
I am trying to extract list of child components / buy components that will be required for assembling a SKU or finished Goods[Parent Item]. My SKU is having multi-level BOM with levels extending up to 5 levels.
I want to have this data on component level to estimate the future requirement of child components w.r.to particular SKU
I currently have access to two tables namely BM00101 and BM00111 . There is no data in other BOM Tables such as BM10300.
I am not able to map parent child relationship between the parts & subsequently not in a position to determine how many child parts goes into an SKU.
I would like to put forward following example for illustration
SKU Name : A SKU Name : B
Child Parts of SKU A : Child Parts of SKU B :
111 - 2 nos 111 - 1 no
222 - 3 nos 222 - 8 nos
333 - 4 nos 333 - 9 nos
444 - 5 nos 555 - 11 nos
If I manufacture 1 qty of SKU A , I will need child part in respective multiples , same goes for SKU B. Ideally when I visualize this data [ preferably in PowerBI] matrix visual , I should get Parent Item on row side& respective child items with quantities on values section
I can share few more examples if needed . Thank you and look forward to receive your valuable inputs.
Thanks,
Aaditya
Good Day
The BOM00111 has the data that shows the Finished Good item ( parent ) as the ITEMNMBR and the child as the CMPTITNM.
The quantity of each child per parent is the Design_Qty field.
This is how the data is stored in SQL
so that it can be displayed in GP
We do not store any other information in terms of relationship, so you'll need to use this table for your data.
Thanks
Dean
Share
Report
All responses (
Answers (
