5 Replies Latest reply: May 15, 2014 10:08 AM by fatboy02 _ RSS

    Footer, header, or ?

    fatboy02 _

      I'm still learning so I hope I am on the correct track here.  I have an SAP report where I need to capture material number followed by description but, on occasion, a header and footer get in my way.  The first 2 material numbers (202495 & 402370)pull in the description as needed but when I get to 202283 it pulls in a blank line.  Would a footer trap be the best way to ignore all of the unnecessary date between the material number and description?  I've tried this but it doesnt seem to work for me...Thanks, Rob

       

       

       

      -


        003K 025 1053510145 17 202495             NONE               EA 

                               BA.SCR N28 MTL G API 45                                                                               

      1111

                                                                     9001

      -


        003K 011 1053510145 17 402370             NONE               EA 

                               BA.SCR DERRICK PWP 500DX - A60           

                                                                     1005

                                                                     9001

      -


        003K 025 1053510145 17 202283             NONE               EA 

                                                                          

      -


      Comments/Warnings -


                      

      BM - Batch Managed     SI - Serialized Item                      

      SL - No surplus sloc   BN - Bin different                        

      ML - Mult Sloc for material                                      

      -


      Date: 10/05/2010                                                  

      Time: 16:14:36                                                                               

      -


      Plant MRP Profit Ctr Dv Matl #             Old Matl #         UOM

                               Description                           SLoc

      -


      -


                               BA.SCR D48 PLS G110 - EA                                                                               

      9001

      -


        003K 025 1053510146 17 101271191          B.002990025BAG     BAG

                               BA.BAROFIBRE SUPERFINE - 25 LB BAG       

                                                                     1111

      -


      /code

        • Footer, header, or ?
          Olly Bond

          Hello Rob,

           

          I think that if you define a page header template to cover the data you don't want to capture. Define this for as many lines as needed, and your detail template should be able to smoothly glide over these interruptions.

           

          Best wishes,

           

          Olly

          • Footer, header, or ?
            Data Kruncher

            Well isn't this just a bit of an ugly one Rob?

             

            I had already tried Olly's approach without success. Sorry Olly. Those dashed lines really make a mess of it.

             

            I have an easy solution, if somewhat unconventional.

             

            Start with the detail template. A two line template, trapping only SLoc values. Paint as Character, end on None of the above.

             

            Add a one line append template for the description, trap as necessary to isolate it properly.

             

            Add another one line append for the Plant, MRP, etc. fields.

             

            Now a bit of a trick. Add yet another one line append for the dashed lines, but don't paint any fields.

             

            No page header or footer template required.

             

            The last step is to split out the SLoc values into multiple columns with calculated fields using LSplit. Are you OK with that?

             

            How does that work for you?

              • Footer, header, or ?
                fatboy02 _

                OK, I was a bit misleading in my original post as I left out a lot of detail because I almost had a fully functional model and had hopes that a correctly constructed header or footer template would complete my model.

                 

                I need to capture the following fields

                Plant

                Material

                Description

                Sloc 1111 Qty

                SLoc 9001 Qty

                SLoc xxxx  Qty (not shown in this sample)

                Slow Move value

                Slow Move Qty

                 

                My intial model uses a multi line sample, trapping on the plant field.  I captured most everything in the detail trap and then used an append trap with preceeding string 9001 to capture the SLoc 9001 Qty (and SLoc xxxx qty if necessary). 

                 

                Kruncher, I am a bit confused on what you mean by 'Add yet another one line append for the dashed lines, but don't paint any fields' EDIT--I understand this now

                 

                Anyways, I am working with your suggestion now but wanted to clarify my omissions from the original post....

                 

                 

                -


                Date: 10/05/2010                                                                                xyz Co.                                                                                Page:     2

                Time: 16:14:36                                                                                Slow Moving Report/Transfer to 9001/9002                                                                         PHL100/ZMR0SR5R/abxd1234

                                                                                                All Values in USD

                -


                Plant MRP Profit Ctr Dv Matl #             Old Matl #         UOM MRP Reorder Pt     Price             Price Unit         Total Qty   Req Qty(Open SO)   Rec Qty(Open PO)          Avail Qty

                                         Description                           SLoc DF   Un Rest Qty  Last Rec Date     Last Con Date    6 Mth Usage        3 Mth Usage    Slow Move Value      Slow Move Qty      Transfer Qty  Sloc Comments/Warnings

                -


                -


                  003K 025 1053510145 17 202495             NONE               EA  PD             0.0        183.31              1                 2                  0                  0                  2

                                         BA.SCR N28 MTL G API 45                                                                                367                  2

                                                                               1111                   1     02/2010        03/2010                  0                  0                                                         9001

                                                                               9001                   1     09/2009        09/2009                  0                  0

                -


                  003K 011 1053510145 17 402370             NONE               EA  PD             0.0        176.00              1                 2                  0                  0                  2

                                         BA.SCR DERRICK PWP 500DX - A60                                                                                352                  2

                                                                               1005                   0                                             0                  0

                                                                               9001                   2                                             0                  0

                -


                  003K 025 1053510145 17 202283             NONE               EA  PD             0.0         71.00              1                 4                  0                  0                  4

                 

                -


                Comments/Warnings -


                BM - Batch Managed     SI - Serialized Item

                SL - No surplus sloc   BN - Bin different

                ML - Mult Sloc for material

                -


                Date: 10/05/2010                                                                                xyz Co.                                                                                Page:     3

                Time: 16:14:36                                                                                Slow Moving Report/Transfer to 9001/9002                                                                         PHL100/ZMR0SR5R/abxd1234

                                                                                                All Values in USD

                -


                Plant MRP Profit Ctr Dv Matl #             Old Matl #         UOM MRP Reorder Pt     Price             Price Unit         Total Qty   Req Qty(Open SO)   Rec Qty(Open PO)          Avail Qty

                                         Description                           SLoc DF   Un Rest Qty  Last Rec Date     Last Con Date    6 Mth Usage        3 Mth Usage    Slow Move Value      Slow Move Qty      Transfer Qty  Sloc Comments/Warnings

                -


                -


                                         BA.SCR D48 PLS G110 - EA                                                                                284                  4

                                                                               9001                   4                    12/2009                  0                  0

                -


                 

                /code

                  • Footer, header, or ?
                    Data Kruncher

                    'Add yet another one line append for the dashed lines, but don't paint any fields'[/quote]Define an append template, single line sample, named Dashes that traps the lines that are nothing but dashes -


                    . Do not define any fields to capture. Monarch will promt you to continue when you OK the template. Click Yes.

                     

                    The technique described works well with this additional sample.