topic Re: regarding select statement in Application Development and Automation Discussions

regarding select statement

Former Member — Mon, 11 Jun 2007 10:46:50 GMT

Hi Expert,

Is this select statement is ok ?

actually i have doubt in where clause when it mix both AND and OR without braces

SELECT SINGLE * FROM vbfa WHERE

vbeln = s_bkpf-awkey AND

vbtyp_v = 'C' OR

vbtyp_v = 'E' OR

vbtyp_v = 'M' OR

vbtyp_v = 'J' OR

vbtyp_v = 'R' .

thanks and regards

abaper.

Re: regarding select statement

seshatalpasai_madala — Mon, 11 Jun 2007 10:47:52 GMT

Hi,

The select statement is fine but it will be good if you use IN rather than so many OR's.

Liek this

SELECT SINGLE * FROM vbfa WHERE

vbeln = s_bkpf-awkey AND vbtyp_v IN ('C','E','M','J','R' ).

Regards,

Sesh

Message was edited by:

Seshatalpasai Madala

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 10:50:41 GMT

SELECT SINGLE * FROM vbfa WHERE

vbeln = s_bkpf-awkey AND ( vbtyp_v = 'C' OR

vbtyp_v = 'E' OR

vbtyp_v = 'M' OR

vbtyp_v = 'J' OR

vbtyp_v = 'R' ).

OR YOU CAN USE

SELECT SINGLE * FROM vbfa WHERE

vbeln = s_bkpf-awkey AND

vbtyp_v IN ('C', 'E', 'M', 'J', 'R') .

CHECK THE SPACE NO SPACE BETWEEN ('C' AFTER , ONE SPACE AND NO SPACE BETWEEN 'R'). GIVE THE SPACE CORRECTLY ...

REGARDS

SHIBA DUTTA

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 10:50:59 GMT

hello,

i think it should be in following manner

SELECT SINGLE * FROM vbfa WHERE

vbeln = s_bkpf-awkey AND

(vbtyp_v = 'C' OR

vbtyp_v = 'E' OR

vbtyp_v = 'M' OR

vbtyp_v = 'J' OR

vbtyp_v = 'R' ).

if s_bkpf-awkey is select-option then u should write IN instead of =.

Regards,

Neelambari

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 10:51:29 GMT

Hi ABAP King,

No problem in this query

Regards

Sarath

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 10:52:09 GMT

Hi,

It is equvivalent to :

SELECT SINGLE * FROM vbfa WHERE

vbeln = s_bkpf-awkey AND

(vbtyp_v = 'C' OR

vbtyp_v = 'E' OR

vbtyp_v = 'M' OR

vbtyp_v = 'J' OR

vbtyp_v = 'R' ).

Jogdand M B

Re: regarding select statement

Former Member — Mon, 11 Jun 2007 10:53:03 GMT

Try like this.

SELECT SINGLE * FROM vbfa

into corresponding fields of it_vbfa

WHERE

( ( vbeln = s_bkpf-awkey ) AND ( vbtyp_v = 'C' ) OR ( vbtyp_v = 'E' ) OR ( vbtyp_v = 'M' ) OR ( vbtyp_v = 'J' ) OR

( vbtyp_v = 'R' ) ).

Regards

Haritha.