Share
Report
17Hi 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
All responses (
Answers (
