Mapping

[risabhroy_03]

I have to pick Price from table WHUUL301 on the basis of given below condition.

Can anyone please help in achieving this. I am thinking of using applymap but unable to achieve.

Go to table whuul301 based on

whuul301.sfbp = whinh300.sfbp

whuul301.invn = whinh300.asnr

whuul301.item = whinh301.item

whuul301.worn = whinh301.worn

whuul301.wpon = whinh301.wpon

Pick whuul301.pric (Price)

[Anil_Babu_Samineni]

I am afraid, If you mean this?

If whuul301.sfbp = whinh300.sfbp or whuul301.invn = whinh300.asnr or whuul301.item = whinh301.item or whuul301.worn = whinh301.worn or whuul301.wpon = whinh301.wpon Then

Load * From whuul301 Where whuul301.pric='price';

Else

Load ....;

End If;