help in Where statment

[Former Member]

hi

i doing that where in loop but i have eroor

like

<b>Statement "5" is not defined. Check your spelling. spelling.</b>

but if i do stdaz = '0.5'.

its working o.k.

but <b>i wont LE the 0.5</b>

LOOP AT target_hours_exp ASSIGNING <target_hours_exp> WHERE stdaz <b>le 0.5 .</b> ADD 1 TO cnt_days.

ENDLOOP.

.

Regards

[Former Member]

hi

i doing that where in loop but i have eroor

like

<b>Statement "5" is not defined. Check your spelling. spelling.</b>

but if i do stdaz = '0.5'.

its working o.k.

but <b>i wont LE the 0.5</b>

LOOP AT target_hours_exp ASSIGNING <target_hours_exp> WHERE stdaz <b>le 0.5 .</b> ADD 1 TO cnt_days.

ENDLOOP.

.

Regards

[varma_narayana]

Hi

Check the Correction..

Here the Value 0.5 must be in Single quotes...

LOOP AT target_hours_exp ASSIGNING <target_hours_exp>

<b> WHERE stdaz le '0.5' . </b>

ADD 1 TO cnt_days.

ENDLOOP.

reward if Helpful.

[former_member188827]

LOOP AT target_hours_exp ASSIGNING <target_hours_exp>.

if <target_hours_exp>-stdaz le 0.5.

ADD 1 TO cnt_days.

endif.

endloop.

use da above logic.it will work

Message was edited by:

abapuser

[Former Member]

Hi,

try to declare a variable.

data I_stdaz like t550p-stdaz.

i_stdaz = 1 / 2.

LOOP AT target_hours_exp ASSIGNING <target_hours_exp>

<b>WHERE stdaz le i_stdaz</b> .

ADD 1 TO cnt_days.

ENDLOOP.

Regards, Dieter

[Former Member]

Hi,

When you are validating a condition using ' where' condition be it ay where .

You must enclose a constant value in colons in the where statement.

LOOP AT target_hours_exp ASSIGNING <target_hours_exp>

WHERE stdaz le ' 0.5' .

ADD 1 TO cnt_days.

ENDLOOP.

or

data i1 type p value ' 0.5'.

LOOP AT target_hours_exp ASSIGNING <target_hours_exp>

WHERE stdaz le i1 .

ADD 1 TO cnt_days.

ENDLOOP.

Reward if found use full.

Regards,

Rama Murthy.P