Skip to Content
0
Former Member
Jun 18, 2008 at 08:38 PM

Replacing GET by a SELECT query

206 Views

hi all.

i have a get+check options syntax in a report.

i want to replace the code with a select query..

i want to replace GET + CHECKby SELECT+WHERE...

but when does this GET statement end? like if i replace it with select, then i would have to put ENDSELECT somewhere.. i guess there is no ENDGET in the report..

the code is like as follows...

START-OF-SELECTION.

GET ekko FIELDS bstyp ebeln ekorg ekgrp bedat ernam lifnr.

CHECK select-options.

CHECK ekko-bstyp = 'F'.

PERFORM some_subroutine

IF sy-subrc EQ 0.

"LOTS OF CODE PROCESSING"

ENDIF.

TOP-OF-PAGE.

"some code"

END-OF-SELECTION.

so, how do i replace it with the select query?

does the GET statement is executed for entire START-OF-SELECTION event?

also, whenever this GET is executed, does it fetch a single entry from the database table to work-area?