select-options

[Former Member]

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

[MateuszAdamus]

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

[Former Member]

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

[MateuszAdamus]

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

[Sandra_Rossi]

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