Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

GET and CHECK select-options.

Former Member
0 Kudos
1,333

hi,

i have a report where it has lines like

GET ekko FIELDS bstyp ebeln ekorg ekgrp bedat ernam lifnr.

CHECK select-options.

i tried to check for SAP help, but it said, its become obsolete.

can you please tell me how does this syntax work and if i want to change it what is the alternative to it?

thanks in advance.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
165

hi.

GET and CHECK are used only in case of logical databases.

GET is used for fetching the required data from databse tables and CHECK is required for checking the data gin in select options.

they are used only in case of reports used for logical databases,it is not used in the usual report programs.

5 REPLIES 5

Former Member
0 Kudos
165

Hi Chinmay,

This is the way in which coding is done while using logical database.

CHECK select-options.

is just like adding select-options values in the where clause of select query.

GET ekko FIELDS bstyp ebeln ekorg ekgrp bedat ernam lifnr.

This statement will loop at entries in EKKO.

In CHECK select-options, it will check if the entrie are valid as per select-option criteria

Former Member
0 Kudos
165

Hi,

In logical database, GET means fetch data from the specified table for the given fields.

And check select-options, is for to filter the fetched records like where clause.

Former Member
0 Kudos
166

hi.

GET and CHECK are used only in case of logical databases.

GET is used for fetching the required data from databse tables and CHECK is required for checking the data gin in select options.

they are used only in case of reports used for logical databases,it is not used in the usual report programs.

0 Kudos
165

hi all, thanx a lot for replying.

so, i guess this GET + CHECK can be replaced by 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?

Former Member
0 Kudos
165

created a seperate question post for the same