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:



          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?