SELECT WHERE

[Private_Member_527672]

Hi Guys,

I would like know how i can do a SELECT with more than one value to one field.

For example:

v_value1 = 001.

v_value2 = 002.

SELECT lifnr

where lifnr eq v_value1 and v_value2.

I want do the select using two variable comparing one field.

Someone can help me?

Thanks

Denilson

always use meaningful subject in future

Edited by: Vijay Babu Dudla on Jan 2, 2009 1:15 PM

[former_member191735]

Do a range

Check this out

RANGES: r_date FOR vbak-erdat.

r_date-low = sy-datum - 61.

r_date-sign = 'I'.

r_date-option = 'EQ'.

Append R_DATE. Clear: R_DATE.

r_date-low = sy-datum - 61.

r_date-sign = 'I'.

r_date-option = 'EQ'.

Append R_DATE. Clear: R_DATE.

select erdat into w_erdat from vbak

where erdat in r_date.

This should compare two values agains one field in select statement

[Former Member]

SELECT lifnr
where lifnr IN ( v_value1 , v_value2 ).

[Private_Member_527672]

Thanks Guys for the help.

I did :

Select lifnr

WHERE ( ( lifnr = value1 ) or ( lifnr = value2 ) ).

It's OK.

Thaks

Denilson

[Former Member]

Try.

v_value1 = 001.

v_value2 = 002.

SELECT lifnr

where lifnr = v_value1 or

lifnr = v_value2.

Edited by: Manuel Reck on Jan 2, 2009 7:30 PM

[Former Member]

Hi,

What you did is also ok but as far as my knowledge goes better approach will be

SELECT LIFNR WHERE LIFNR IN ( VALUE1, VALUE2).

It is just matter of understanding frpm person to person .

Pooja.