Help with syntax in load statement

[#1]

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!

[#2 · Accepted solution]

Simple if statement should do. See below-

LBKUM         as [Stock Quantity],

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

if(VPRSV='S','STPRS',if(VPRSV='V','VERPR')) as [Item Current MAP]

Cheers,

Shyam

[#3]

Hi Shyam,

Thanks very much for your help!

Rob