Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a BOM which look like this:
BOM:
Load * Inline [
Item_Parent, Item_Child, Amount
29M20, Z16, 1
29M20, Z17, 1
29M20, L00, 1
L00, R00, 2
R00, K10, 1
R00, K20, 1
R00, K30, 1
R00, K40, 1
20M20, L00, 1
];
My goal is to calculate the quantity needed for each item below the one I select.
E.g. if I select 29M20 then I want to know that I need 1xZ16, 1xZ17, 1xL00, 2xR00, 2xK10, 2xK20, 2xK30, 2xK40.
I have tried using hierarchy loads but I don't get the desired result, perhaps I am using it wrong.
Right now I am loading the table beforehand, then doing the HierarchyBelongsTo and dropping the original table. So now it seems like I only have to concatenate each root item once with itself as the parent. I think this should work, thank you @Saravanan_Desingh ! However if anyone has a different approach, please share them.