Bill of Material - Generate multi-level from single level
Hello everyone - I have been able to have the raw BOM tables downloaded into qvds from SAP and have been able to link them to construct single-level bills. Now what I need is multi-level bills from those single-level bills. I have read a number of posts but they seem to be constructed from an existing multi-level bill (typically from a spreadsheet). If this is posted somewhere I apologize for either not finding it or not recognizing it. Any suggestions/solutions are welcomed!
My current file looks something like:
Material Component Qty per parent
_______ __________ _____________
Table Leg 4.000
Table Top 1.000
Table Drawer 3.00
Leg Wood Post 1.000
Leg Metal Foot 1.000
Top Wood 4.560
Drawer Frame 1.000
Drawer Handle 1.000
Frame Side 2.000
Frame End 2.000
Frame Bottom 1.000
I have tried Hierarchy and some examples but I guess I don't understand enough to quite get there. I have thought of some combination of Hierarchy and Semantic Link but I hit a wall. HELP!!!
Re: Bill of Material - Generate multi-level from single level
I have - I feel that the answer is in there somewhere but using this code I end up with some that only go down so far in the tree. I think this may only work if the source data is in the proper sequence and structured line-for-line. I feel this is close.