2 Replies Latest reply: Nov 22, 2011 6:27 AM by Rob Arundel RSS

    Help with syntax in load statement

      Hi Everyone,

       

      I am new to this and first post so hello all

       

      Please could someone help with the syntax for this script

       

      Existing code:

       

      LOAD

          BWKEY & '_' & mid(MATNR, findoneof(MATNR, '123456789')) as [Product Plant ID] ,     // Modified in v1.2

          LBKUM         as [Stock Quantity],

          VPRSV          as [Price Control Indicator], //Add in v2.71

       

      What I want to add but do not know best syntax:

       

      VERPR          as [Item Current MAP] where VPRSV = V

      STPRS          as [Item Current MAP] where VPRSV = S

       

       

      please could someone help me with this?

       

       

      thanks!