6 Replies Latest reply: Jun 13, 2016 11:25 AM by Bob Schmidt RSS

    Bill of Material - Generate multi-level from single level

    Bob Schmidt

      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!!!

      Thanks in advance

      Bob Schmidt

        • Re: Bill of Material - Generate multi-level from single level
          Stefan Wühl

          What is your expected result?

            • Re: Bill of Material - Generate multi-level from single level
              Bob Schmidt

              Something like (but am open to suggestions):

               

              Material   Level   L-1 Comp      L-1 Qty   L-2 Comp       L-2 Qty    L-3 Comp     L-3 Qty   L-4 Comp    L-4 Qty.......

              ______    ____   ________      ______   _________     ______    ________    ______   ________    ______

              Table          1      Leg                 4.000

              Table          2                                            Wood Post     1.000

              Table          2                                             Metal Foot     1.000

              Table          1      Top                 1.000                           

              Table          2                                              Wood            4.560

              Table          1       Drawer           3.000

              Table          2                                               Frame          1.000

              Table          3                                                                                     Side            2.000

              Table          4                                                                                                                      S-Wood       2.533

              Table          3                                                                                      End            2.000

              Table          4                                                                                                                       E-Wood       2.688

              Table          3                                                                                      Bottom       1.000

              Table          4                                                                                                                        B-Wood      4.605

              Table          2                                               Handle          1.000

               

              Perhaps I really need to be something like:

               

              Table          -       Leg                  4.000      Wood Post      1.000

              Table          -       Leg                  4.000      Metal Foot       1.000

              Table          -       Top                  1.000      Wood               4.560

              Table          -       Drawer             3.000      Frame              1.000      Side              2.000    S-Wood       2.533

              Table          -       Drawer             3.000      Frame              1.000      End               2.000    E-Wood       2.688   

              Table          -       Drawer             3.000      Frame              1.000      Handle             1.000  

               

              As you can see, I am not sure of the best structure to use to "explode" BOMs.