topic Re: SELECT WHERE in Application Development and Automation Discussions

SELECT WHERE

Private_Member_527672 — Fri, 02 Jan 2009 15:36:39 GMT

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

Re: SELECT WHERE

former_member191735 — Fri, 02 Jan 2009 15:47:49 GMT

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

Re: SELECT WHERE

Former Member — Fri, 02 Jan 2009 15:54:43 GMT

SELECT lifnr
where lifnr IN ( v_value1 , v_value2 ).

Re: SELECT WHERE

Private_Member_527672 — Fri, 02 Jan 2009 16:08:00 GMT

Thanks Guys for the help.

I did :

Select lifnr

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

It's OK.

Thaks

Denilson

Re: SELECT WHERE

Former Member — Fri, 02 Jan 2009 18:30:01 GMT

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

Re: SELECT WHERE

Former Member — Mon, 05 Jan 2009 06:29:05 GMT

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.