topic Re: selection screen in Application Development and Automation Discussions

selection screen

Former Member — Tue, 22 May 2007 01:05:06 GMT

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

And vbrk~vbtyp = ( 'M' or 'P' or 'O' ).

this is giving me error messages.

Re: selection screen

Former Member — Tue, 22 May 2007 01:08:18 GMT

can you send me the total code ?

Re: selection screen

Former Member — Tue, 22 May 2007 01:09:10 GMT

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

Siva

Message was edited by:

Siva K

Re: selection screen

Former Member — Tue, 22 May 2007 01:10:03 GMT

Change the code as

And ( vbrk~vbtyp = 'M' or

vbrk~vbtyp = 'P' or

vbrk~vbtyp = 'O' ).

Reward points if useful.

Regards,

Atish

Re: selection screen

Former Member — Tue, 22 May 2007 01:14:41 GMT

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

And vbrk~vbtyp IN ( 'M' , 'P' , 'O' ).

or you can even break the statment to

And ( (vbrk~vbtyp = 'M') or

(vbrk~vbtyp = 'P' ) or

(vbrk~vbtyp = 'O' ) ).

Regards,

George

Reward point for helpful answers

Re: selection screen

Former Member — Tue, 22 May 2007 01:17:42 GMT

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

Re: selection screen

Former Member — Tue, 22 May 2007 01:34:35 GMT

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.

Re: selection screen

Former Member — Tue, 22 May 2007 01:36:42 GMT

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' ).