Skip to Content
0
Jul 22, 2008 at 08:35 AM

No INTO TABLE in Select Stmnt and.......

23 Views

Hi Folks,

In At selection screen I have like this

AT SELECTION-SCREEN.

SELECT SINGLE * FROM vbak

WHERE bukrs_vf = p_bukrs

AND erdat IN s_erdat

AND kunnr IN s_kunnr

AND augru IN s_augru

AND faksk IN s_faksk

AND zzequnr IN s_zequnr

AND zzbautl IN s_zbautl.

SELECT SINGLE * FROM qmih WHERE equnr IN s_zequnr.

In the start of selection...

&----


*& Start of Selection *

&----


START-OF-SELECTION.

SELECT * FROM vbak

INTO CORRESPONDING FIELDS OF TABLE it_vbak

WHERE bukrs_vf = p_bukrs

AND erdat IN s_erdat

AND kunnr IN s_kunnr

AND augru IN s_augru

AND faksk IN s_faksk

and zzequnr in s_zequnr

AND zzbautl IN s_zbautl

AND auart EQ 'ZXXX'

AND zzequnr IN s_zequnr.

SELECT SINGLE vbeln INTO it_vbak-vbeln FROM vbak.

I didn't understand the need of the first piece of code ie AT SELECTION SCREEN.

Does that has any logic behind it.There is no INTO TABLE in that select statement.

Thanks,

K.Kiran