topic Re: select-options in Application Development and Automation Discussions

select-options

Former Member — Wed, 17 Jun 2020 06:11:14 GMT

hi can anyone help me with the syntax for selection data from internal table based on 2 or more select options.

Re: select-options

MateuszAdamus — Wed, 17 Jun 2020 06:16:08 GMT

Hello karoncdas_31

What information exactly do you need? An example of LOOP using SELECT-OPTIONS follows.

SELECT-OPTIONS: s1 FOR some_table-some_field.
SELECT-OPTIONS: s2 FOR some_table2-some_field2.
SELECT-OPTIONS: s3 FOR some_table3-some_field3

LOOP AT lt_internal_table REFERENCE INTO DATA(ld_row_of_internal_table)
  WHERE some_field IN s1
    AND some_field2 IN s2
    AND some_field3 IN s3.
ENDLOOP.

Here is SAP Help about select-options.

Kind regards,

Mateusz

Re: select-options

Sandra_Rossi — Wed, 17 Jun 2020 06:52:38 GMT

You may study SELECT-OPTIONS and its use as a ranges table in the ABAP documentation.

Re: select-options

Former Member — Wed, 17 Jun 2020 13:56:00 GMT

i need to link the input fields to the logic for example i have to write records that satisfies all the select-options. if not error message to be thrown

Re: select-options

MateuszAdamus — Wed, 17 Jun 2020 14:03:18 GMT

SELECT-OPTIONS: s1 FOR some_table-some_field.
SELECT-OPTIONS: s2 FOR some_table2-some_field2.
SELECT-OPTIONS: s3 FOR some_table3-some_field3

LOOP AT lt_internal_table REFERENCE INTO DATA(ld_row_of_internal_table)
  WHERE some_field IN s1
    AND some_field2 IN s2
    AND some_field3 IN s3.

  WRITE: / ld_row_of_internal_table->some_field, ld_row_of_internal_table->some_field2, ld_row_of_internal_table->some_field3.
ENDLOOP.
IF sy-subrc <> 0. 
  WRITE: / 'No records meet given criteria'.
ENDIF.

Kind regards,
Mateusz