ABAP Select data from SAP table PSYST into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP PSYST table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to PSYST. See here for more generic Select statement tips.

Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.

There is also a full declaration of the PSYST table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.

DATA: IT_PSYST TYPE STANDARD TABLE OF PSYST,
      WA_PSYST TYPE PSYST,
      GD_STR TYPE STRING.

DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.

FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: <PSYST> TYPE PSYST.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_PSYST.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM PSYST
  INTO TABLE IT_PSYST.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PSYST
*  INTO TABLE @DATA(IT_PSYST2).
*--Further methods of using ABAP code to  select data from SAP database tables

*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_PSYST INDEX 1 INTO DATA(WA_PSYST2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_PSYST ASSIGNING <PSYST>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<PSYST>-FIRST = 1.
<PSYST>-IINIT = 1.
<PSYST>-NSELC = 1.
<PSYST>-IOPER = 1.
<PSYST>-FSTAT = 1.
ENDLOOP.

LOOP AT IT_PSYST INTO WA_PSYST.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PSYST-MSGST, sy-vline,
WA_PSYST-MSGTP, sy-vline,
WA_PSYST-INPST, sy-vline,
WA_PSYST-BEGDA, sy-vline,
WA_PSYST-ENDDA, sy-vline,
WA_PSYST-BUKRS, sy-vline.
ENDLOOP. *Add any further fields from structure WA_PSYST you want to display... WRITE:/ sy-uline. * Aternatively use generic code to Write field values (and NAME) to screen report DO. ASSIGN COMPONENT sy-index OF STRUCTURE wa_PSYST TO <field>. IF sy-subrc <> 0. EXIT. ENDIF. WRITE:/ 'Field Value', <field>, sy-vline. gd_str = <field> . lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ). lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ). WRITE:/ 'Field Name', lv_fieldname. ENDDO. *Redo loop but convert all fields from internal to out value LOOP AT IT_PSYST INTO WA_PSYST. *Write horizonal line to screen report. WRITE:/ sy-uline. *Convert all fields to display/output versions using conversion routines PERFORM convert_all_field_values CHANGING wa_EKKO. ENDLOOP. *&---------------------------------------------------------------------* *& Form convert_all_field_values *&---------------------------------------------------------------------* FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO. DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.

*Conversion exit ALPHA, internal->external for field KOSTL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PSYST-KOSTL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PSYST-KOSTL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field PABRJ CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_PSYST-PABRJ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PSYST-PABRJ.
WRITE:/ 'New Value:', ld_input.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_PSYST_STR,
FIRST TYPE STRING,
IINIT TYPE STRING,
NSELC TYPE STRING,
IOPER TYPE STRING,
FSTAT TYPE STRING,
MSGST TYPE STRING,
MSGTP TYPE STRING,
INPST TYPE STRING,
BEGDA TYPE STRING,
ENDDA TYPE STRING,
BUKRS TYPE STRING,
BUTXT TYPE STRING,
GSBER TYPE STRING,
WERKS TYPE STRING,
PERSG TYPE STRING,
PERSK TYPE STRING,
BTRTL TYPE STRING,
ABKRS TYPE STRING,
KOSTL TYPE STRING,
PLANS TYPE STRING,
PROZT TYPE STRING,
STELL TYPE STRING,
ORGEH TYPE STRING,
MASSN TYPE STRING,
LAND TYPE STRING,
PSABP TYPE STRING,
PSKOP TYPE STRING,
BDEAP TYPE STRING,
PABRJ TYPE STRING,
PABRP TYPE STRING,
APEXT TYPE STRING,
ICONF TYPE STRING,
EXCMD TYPE STRING,
ERROR TYPE STRING,
DYNNR TYPE STRING,
DBILD TYPE STRING,
SOPER TYPE STRING,
DDATE TYPE STRING,
DOPER TYPE STRING,
DSUBT TYPE STRING,
DYMOD TYPE STRING,
DINIT TYPE STRING,
STACK TYPE STRING,
MFLAG TYPE STRING,
NALGA TYPE STRING,
NAOPK TYPE STRING,
NAEIT TYPE STRING,
NAEIN TYPE STRING,
NABET TYPE STRING,
NAANZ TYPE STRING,
NADAT TYPE STRING,
NAIBW TYPE STRING,END OF T_EKKO_STR. DATA: WA_PSYST_STR type T_EKKO_STR. DATA: ld_text TYPE string. LOOP AT IT_EKKO INTO WA_EKKO. MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR. CONCATENATE: sy-vline
WA_PSYST_STR-FIRST sy-vline
WA_PSYST_STR-IINIT sy-vline
WA_PSYST_STR-NSELC sy-vline
WA_PSYST_STR-IOPER sy-vline
WA_PSYST_STR-FSTAT sy-vline
WA_PSYST_STR-MSGST sy-vline
WA_PSYST_STR-MSGTP sy-vline
WA_PSYST_STR-INPST sy-vline
WA_PSYST_STR-BEGDA sy-vline
WA_PSYST_STR-ENDDA sy-vline
WA_PSYST_STR-BUKRS sy-vline
WA_PSYST_STR-BUTXT sy-vline
WA_PSYST_STR-GSBER sy-vline
WA_PSYST_STR-WERKS sy-vline
WA_PSYST_STR-PERSG sy-vline
WA_PSYST_STR-PERSK sy-vline
WA_PSYST_STR-BTRTL sy-vline
WA_PSYST_STR-ABKRS sy-vline
WA_PSYST_STR-KOSTL sy-vline
WA_PSYST_STR-PLANS sy-vline
WA_PSYST_STR-PROZT sy-vline
WA_PSYST_STR-STELL sy-vline
WA_PSYST_STR-ORGEH sy-vline
WA_PSYST_STR-MASSN sy-vline
WA_PSYST_STR-LAND sy-vline
WA_PSYST_STR-PSABP sy-vline
WA_PSYST_STR-PSKOP sy-vline
WA_PSYST_STR-BDEAP sy-vline
WA_PSYST_STR-PABRJ sy-vline
WA_PSYST_STR-PABRP sy-vline
WA_PSYST_STR-APEXT sy-vline
WA_PSYST_STR-ICONF sy-vline
WA_PSYST_STR-EXCMD sy-vline
WA_PSYST_STR-ERROR sy-vline
WA_PSYST_STR-DYNNR sy-vline
WA_PSYST_STR-DBILD sy-vline
WA_PSYST_STR-SOPER sy-vline
WA_PSYST_STR-DDATE sy-vline
WA_PSYST_STR-DOPER sy-vline
WA_PSYST_STR-DSUBT sy-vline
WA_PSYST_STR-DYMOD sy-vline
WA_PSYST_STR-DINIT sy-vline
WA_PSYST_STR-STACK sy-vline
WA_PSYST_STR-MFLAG sy-vline
WA_PSYST_STR-NALGA sy-vline
WA_PSYST_STR-NAOPK sy-vline
WA_PSYST_STR-NAEIT sy-vline
WA_PSYST_STR-NAEIN sy-vline
WA_PSYST_STR-NABET sy-vline
WA_PSYST_STR-NAANZ sy-vline
WA_PSYST_STR-NADAT sy-vline
WA_PSYST_STR-NAIBW sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.