2 Replies Latest reply: Oct 20, 2015 4:57 AM by Tugba Dündar RSS

    Inventory Level

      Hello now I have another question,

       

      I wanted to Show the Aggregate stock for inventory.

       

      But I have a Problem instead of having one product in stock I have 4 products products expressed in MatID.

      So now what I want to have is the Level for each products in years. At first it would be helpful to Show the percentage of each product per year. And then look after the months. I have the months and years in separate columns.

       

      Thanks in advance

        • Re: Inventory Level
          Robert Mika

          Post your data or app.

            • Re: Inventory Level

              MANDT|MATNR|WERKS|LGORT|LFGJA|LFMON|LABST|UMLME|INSME|ENME|SPEME|RETME|VKLAB|VKUML

              150|AB01218559|st01|BRE0|2012|4|5000.00||0|0|0|0|0|0

              150|AB01218559|st03|EMM0|2012|4|40000.00||0|0|0|0|0|0

              150|AB01218559|st04|RHE0|2012|4|270000.00||0|0|0|0|0|0

              150|AB01218559|st02|GUN0|2012|4|24196.00||0|0|0|0|0|0

              150|AB01218559|st05|BRO0|2012|4|.00||0|0|0|0|0|0

              150|AB01218559|st02|GUN0|2012|5|300000.00||0|0|0|0|0|0

              150|AB01218559|st05|BRO0|2012|5|626608.00||0|0|0|0|0|0

              150|AB01218559|st05|BRO0|2012|6|750000.00||0|0|0|0|0|0

              150|AB01218559|st05|BRO0|2012|10|.00||0|0|0|0|0|0

              150|AB01218559|st02|GUN0|2012|10|.00||0|0|0|0|0|0

              150|AB01218559|st04|RHE0|2012|10|104791.00||0|0|0|0|0|0

              150|AB01218559|st03|EMM0|2012|10|40000.00||0|0|0|0|0|0

              150|AB01218559|st01|BRE0|2012|10|5000.00||0|0|0|0|0|0

              150|AB01218559|st04|RHE0|2012|11|.00||0|0|0|0|0|0

              150|AB01218559|st03|EMM0|2012|11|.00||0|0|0|0|0|0

              150|AB01218559|st01|BRE0|2012|11|.00||0|0|0|0|0|0

              150|AB01218559|st01|BRE0|2013|4|5000.00||0|0|0|0|0|0