Application Development and Automation 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: 
Read only

small help

Former Member
0 Likes
625

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
Read only

athavanraja
Active Contributor
0 Likes
464

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
Read only

andreas_mann3
Active Contributor
0 Likes
464

Hi,

try this : If MBEW-verpr is initial.

or

If MBEW-verpr = 0.

Andreas

Read only

athavanraja
Active Contributor
0 Likes
465

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

Read only

jayanthi_jayaraman
Active Contributor
0 Likes
464

Hi,

Try this.

If mbew-verpr = 0.00.

t_itab-verpr = 0.01.

...

endif.