selection screen

[Former Member]

hi here is how i am trying to select .

how do i get the And vbrk condition correctly.

SELECT *

FROM vbrk

INNER JOIN vbrp ON vbrk_{vbeln = vbrp}vbeln

INNER JOIN kna1 ON vbrk_{kunag = kna1}kunnr

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE vbrk~vbeln IN p_vbeln

AND vbrk~kunag IN p_kunag

AND vbrp~matnr IN p_matnr

AND vbrp~augru_auft IN p_augru

AND vbrk~fkdat IN r_fkdat

<b> And vbrk~vbtyp = ( 'M' or 'P' or 'O' ).</b>

this is giving me error messages.

[Former Member]

can you send me the total code ?

[Former Member]

And vbrk~vbtyp in ('M','P','O')..should resolve your issue.

Siva

Message was edited by:

Siva K

[Former Member]

Hi

Change the code as

And ( vbrk~vbtyp = 'M' or

vbrk~vbtyp = 'P' or

vbrk~vbtyp = 'O' ).

Reward points if useful.

Regards,

Atish

[Former Member]

Hi,

Specify the fields in you select statement based on the internal table if possible. Replace the statement "And vbrk~vbtyp = ( 'M' or 'P' or 'O' )" with

<b>And vbrk~vbtyp IN ( 'M' , 'P' , 'O' ).</b>

or you can even break the statment to

<b>And ( (vbrk~vbtyp = 'M') or

(vbrk~vbtyp = 'P' ) or

(vbrk~vbtyp = 'O' ) ).</b>

Regards,

George

• Reward point for helpful answers

[Former Member]

See the below code and i made some changes :

REPORT ZTEST3 line-size 400.

tables : vbrk,

vbrp,

kna1.

data : begin of itab occurs 0.

include structure vbrk.

data : end of itab.

select-options: p_vbeln for vbrk-vbeln,

p_kunag for vbrk-kunag,

p_matnr for vbrp-matnr,

r_fkdat for vbrk-fkdat,

p_augru for vbrp-augru_auft.

start-of-selection.

SELECT *

FROM vbrk

INNER JOIN vbrp ON vbrk_{vbeln = vbrp}vbeln

INNER JOIN kna1 ON vbrk_{kunag = kna1}kunnr

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE vbrk~vbeln IN p_vbeln

AND vbrk~kunag IN p_kunag

AND vbrp~matnr IN p_matnr

AND vbrp~augru_auft IN p_augru

AND vbrk~fkdat IN r_fkdat

And ( vbrk~vbtyp = 'M' or

vbrk~vbtyp = 'P' or

vbrk~vbtyp = 'O' ).

Reward Points if it is helpful

Thanks

Seshu

[Former Member]

thank you all.

i have one more question. i need to add one more condition in checking.

i need to check if vbrk~fksto is initial , in the same select statement.

how do i do that.

[Former Member]

See the code :

REPORT ZTEST3 line-size 400.

tables : vbrk,

vbrp,

kna1.

data : begin of itab occurs 0.

include structure vbrk.

data : end of itab.

select-options: p_vbeln for vbrk-vbeln,

p_kunag for vbrk-kunag,

p_matnr for vbrp-matnr,

r_fkdat for vbrk-fkdat,

p_augru for vbrp-augru_auft.

start-of-selection.

SELECT *

FROM vbrk

INNER JOIN vbrp ON vbrk_{vbeln = vbrp}vbeln

INNER JOIN kna1 ON vbrk_{kunag = kna1}kunnr

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE vbrk~vbeln IN p_vbeln

AND vbrk~kunag IN p_kunag

AND vbrp~matnr IN p_matnr

AND vbrp~augru_auft IN p_augru

AND vbrk~fkdat IN r_fkdat

and vbrk~fksto is null

And ( vbrk~vbtyp = 'M' or

vbrk~vbtyp = 'P' or

vbrk~vbtyp = 'O' ).