topic Re: small help in Application Development and Automation Discussions

small help

Former Member — Wed, 17 Aug 2005 06:57:34 GMT

i am facing one prblm..

*collect value from mbew

SELECT SINGLE * FROM mbew wHERE matnr = t_itab-matnr.

t_itab-verpr = mbew-verpr.

in this code i have to check verpr value .If verpr is 0.00 then i have to rplace by 0.01.

i have try with if comdition but itdoesnt work out.

can anyone throw some light how to change the value if verpr have value 0.00.

Means to say only if verpr gets 0.00 then only 0.01 else it should write the same value as in database table

plz can anyone help.

thanks in advance

andreas_mann3 — Wed, 17 Aug 2005 07:03:47 GMT

Hi,

try this : If MBEW-verpr is initial.

If MBEW-verpr = 0.

Andreas

athavanraja — Wed, 17 Aug 2005 07:06:28 GMT

SELECT SINGLE * FROM mbew wHERE matnr = t_itab-matnr.

if mbew-verpr is initial .

move: '0.01' to t_itab-verpr .

else .

move: mbew-verpr to t_itab-verpr .

endif .

Regards

Raja

jayanthi_jayaraman — Wed, 17 Aug 2005 07:10:35 GMT

Hi,

Try this.

If mbew-verpr = 0.00.

t_itab-verpr = 0.01.

...

endif.