regarding select statement

[Former Member]

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.

[seshatalpasai_madala]

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

[Former Member]

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

[Former Member]

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 <b>IN</b> instead of =.

Regards,

Neelambari

[Former Member]

Hi ABAP King,

No problem in this query

Regards

Sarath

[Former Member]

Hi,

It is equvivalent to :

SELECT SINGLE * FROM vbfa WHERE

vbeln = s_bkpf-awkey AND

<b>(</b>vbtyp_v = 'C' OR

vbtyp_v = 'E' OR

vbtyp_v = 'M' OR

vbtyp_v = 'J' OR

vbtyp_v = 'R' <u><b>)</b></u>.

Jogdand M B

[Former Member]

Hi

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.