topic select options in Application Development and Automation Discussions

select options

Former Member — Wed, 22 Jul 2020 11:27:11 GMT

Hi, I am just studying ABAP. I'm creating a program that uses select-options and date as input and extracts data by comparing with DB table . I don't know what to do when the get data. So please help me and provide sample code.

REPORT ZEXERCISE.

DATA: WA_DATE TYPE ZDATE-DATBI.

SELECT-OPTIONS DATE FOR WA_DATE NO INTERVALS.

*WA_DATE = ?? (what can i do)

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

date_external = WA_DATE

IMPORTING

date_internal = WA_DATE.

WRITE :/5 'No',20 'Valid Date'.

SKIP.

tables : ZDATE.

SELECT * FROM ZDATE.

IF ZDATE-DATBI < WA_DATE.

WRITE:/5 ZDATE-NO,20 ZDSTE-DATBI.

ENDIF.

ENDSELECT.

Re: select options

Sandra_Rossi — Wed, 22 Jul 2020 11:44:33 GMT

Please use the CODE button to format your code so that it's shown in a more user-friendly format (colorized).

Re: select options

Sandra_Rossi — Wed, 22 Jul 2020 11:47:13 GMT

Is that what you want to do

SELECT * FROM ZDATE INTO TABLE @DATA(lines_zdate) WHERE datbi IN date.

NB: TABLES is mostly obsolete, SELECT ... ENDSELECT is to avoid as far as possible.

Re: select options

AnmolBhat — Wed, 22 Jul 2020 14:16:47 GMT

Hi,

You need to learn with some latest ABAP documents. Please search for ABAP 740 and you get current syntax for ABAP.

Regarding your requirement, it can be written in few lines like below

DATA: WA_DATE TYPE ZDATE-DATBI.
SELECT-OPTIONS DATE FOR WA_DATE NO INTERVALS.

select * from zdate into table @data(lt_date) where DATBI in s_date.
"print
cl_abap_demo_services=>list_table( table =  lt_date ).

Re: select options

Former Member — Mon, 27 Jul 2020 11:36:07 GMT

sandra.rossi Thank you for the sample code. I tried as your advice, but error was occurred.How to solve it.?

Error :

When escaped, all host variable must be escaped using @ The variable

DATE is not escaped in the same way as the preceding host variables.

Re: select options

Sandra_Rossi — Mon, 27 Jul 2020 11:37:26 GMT

cross Ts and dot Is:

SELECT * FROM ZDATE INTO TABLE @DATA(lines_zdate) WHERE datbi IN @date.

Re: select options

FredericGirod — Mon, 27 Jul 2020 11:45:55 GMT

If I could add something.

Do not try to modify SELECT-OPTIONS, this is the perfect object to play with SELECT statement. It will accept a lot of possibility (Include, Exclude, Between, Greater than, ...). You just have to use IN operator in the WHERE clause.

Re: select options

Former Member — Thu, 30 Jul 2020 02:33:35 GMT

anmolamb Thank you for advice. As your advice, the entered date has been output.

How do I do coding if I would like to list dates before the entered date?

Re: select options

AnmolBhat — Thu, 30 Jul 2020 06:51:06 GMT

In that case, you have to pass the LT operator to the select option.

you can do that in the initialization event, so the user also see that on the selection screen or if you want to do this silently then just do that before the select query

"in the initialization, 
INITIALIZATION.
s_date[] = value #( ( sign = 'I' option = 'LT' ) ).

"or just before select query

loop at s_date assigning field-symbol(<ls_date>).
<ls_date>-option = 'LT'.
endloop.
"select query save as before

Re: select options

Former Member — Thu, 30 Jul 2020 07:31:36 GMT

anmolamb I see. It was able to list previous dates. Thank you so much. I have to learn more.

Re: select options

Former Member — Thu, 30 Jul 2020 07:33:54 GMT

sandra.rossi Thank you so much. It was solve the error.

Re: select options

Former Member — Thu, 30 Jul 2020 07:34:37 GMT

frdric.girod Thank you so much.

Re: select options

Sandra_Rossi — Thu, 30 Jul 2020 08:12:10 GMT

You may edit your answer to correct a syntax error:

Before correction:

select * from zdate into table @data(lt_date) where DATBI in s_date.

After correction:

select * from zdate into table @data(lt_date) where DATBI in @date.