topic Re: Selection field into select statement in Application Development and Automation Discussions

Selection field into select statement

Former Member — Fri, 15 Nov 2019 05:25:21 GMT

I want to link my select-option field (material) to my select statement so user input from the selection screen will go into my select statement.

*&---------------------------------------------------------------------*
*& Report  ZTYPES
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*


REPORT  ztypes LINE-SIZE 132.


*Table declaration (new method)
TYPES: BEGIN OF t_ekpo,
  ebeln TYPE ekpo-ebeln,
  ebelp TYPE ekpo-ebelp,
  bukrs TYPE ekpo-bukrs,
  matnr TYPE ekpo-matnr,
 END OF t_ekpo.
 
DATA: it_ekpo TYPE STANDARD TABLE OF t_ekpo INITIAL SIZE 0,      "itab
wa_ekpo type t_ekpo,                    "work area (header line)
wa_ekpo1 like line of it_ekpo.


**************************************************************************


*parameters: Material like ekpo-matnr.


SELECT-OPTIONS material FOR wa_ekpo-matnr.




*START-OF-SELECTION.
START-OF-SELECTION.


*Select data in itab
  SELECT ebeln
         ebelp
         bukrs
         matnr
    FROM ekpo
    INTO TABLE it_ekpo.
  IF wa_ekpo-matnr IN material.


*Process data within itab using LOOP statement
    LOOP AT it_ekpo INTO wa_ekpo.
      WRITE: /   wa_ekpo-ebelp,wa_ekpo-bukrs,wa_ekpo-ebeln,wa_ekpo-matnr.
* processing......
    ENDLOOP.


  ENDIF.

Re: Selection field into select statement

FredericGirod — Fri, 15 Nov 2019 06:19:20 GMT

SELECT-OPTIONS --> WHERE table_field IN select_option_name

PARAMETERS --> WHERE table_field EQ parameters_name

SELECT-OPTIONS material FOR wa_ekpo-matnr.




*START-OF-SELECTION.
START-OF-SELECTION.


*Select data in itab
  SELECT ebeln
         ebelp
         bukrs
         matnr
    FROM ekpo
    INTO TABLE it_ekpo
    WHERE MATNR in material

Re: Selection field into select statement

FredericGirod — Fri, 15 Nov 2019 06:21:26 GMT

And with new abap statement, it is better to do (using the inline declaration the code is lighter)

REPORT  ztypes LINE-SIZE 132.


*parameters: Material like ekpo-matnr.

SELECT-OPTIONS material FOR wa_ekpo-matnr.




*START-OF-SELECTION.
START-OF-SELECTION.


*Select data in itab
  SELECT ebeln
         ebelp
         bukrs
         matnr
    FROM ekpo
    INTO TABLE @data(it_ekpo)
    WHERE MATERIAL in @material


*Process data within itab using LOOP statement
    LOOP AT it_ekpo INTO data(wa_ekpo).
      WRITE: /   wa_ekpo-ebelp,wa_ekpo-bukrs,wa_ekpo-ebeln,wa_ekpo-matnr.
* processing......
    ENDLOOP.