Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

small help

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

athavanraja
Active Contributor
0 Kudos

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

3 REPLIES 3

andreas_mann3
Active Contributor
0 Kudos

Hi,

try this : If MBEW-verpr is initial.

or

If MBEW-verpr = 0.

Andreas

athavanraja
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Hi,

Try this.

If mbew-verpr = 0.00.

t_itab-verpr = 0.01.

...

endif.