ABAP Select data from SAP table QGSE 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 QGSE 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 QGSE. 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 QGSE 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_QGSE TYPE STANDARD TABLE OF QGSE,
      WA_QGSE TYPE QGSE,
      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: <QGSE> TYPE QGSE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM QGSE
*  INTO TABLE @DATA(IT_QGSE2).
*--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_QGSE INDEX 1 INTO DATA(WA_QGSE2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_QGSE ASSIGNING <QGSE>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<QGSE>-PRUEFLOS = 1.
<QGSE>-STUECKNR = 1.
<QGSE>-PROBENR = 1.
<QGSE>-MBEWERTG_KEYTEXT = 1.
<QGSE>-MESSWERT = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_QGSE-ANZFEHLER, sy-vline,
WA_QGSE-FEHLKLAS_KEYTEXT, sy-vline,
WA_QGSE-ESTUECKNR, sy-vline,
WA_QGSE-SERIALNR, sy-vline,
WA_QGSE-ATTRIBUT_KEYTEXT, sy-vline,
WA_QGSE-PRUEFER, sy-vline.
ENDLOOP. *Add any further fields from structure WA_QGSE 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_QGSE 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_QGSE INTO WA_QGSE. *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 PRUEFLOS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_QGSE-PRUEFLOS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_QGSE-PRUEFLOS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field MASCHINE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_QGSE-MASCHINE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_QGSE-MASCHINE.
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_QGSE_STR,
PRUEFLOS TYPE STRING,
STUECKNR TYPE STRING,
PROBENR TYPE STRING,
MBEWERTG_KEYTEXT TYPE STRING,
MESSWERT TYPE STRING,
ANZFEHLER TYPE STRING,
FEHLKLAS_KEYTEXT TYPE STRING,
ESTUECKNR TYPE STRING,
SERIALNR TYPE STRING,
ATTRIBUT_KEYTEXT TYPE STRING,
PRUEFER TYPE STRING,
PRUEFDATUV TYPE STRING,
PRUEFDATUB TYPE STRING,
PRUEFZEITV TYPE STRING,
PRUEFZEITB TYPE STRING,
PRUEFBEMKT TYPE STRING,
KATALGART1 TYPE STRING,
GRUPPE1 TYPE STRING,
CODE1 TYPE STRING,
VERSION1 TYPE STRING,
KATALGART2 TYPE STRING,
GRUPPE2 TYPE STRING,
CODE2 TYPE STRING,
VERSION2 TYPE STRING,
KATALGART3 TYPE STRING,
GRUPPE3 TYPE STRING,
CODE3 TYPE STRING,
VERSION3 TYPE STRING,
KATALGART4 TYPE STRING,
GRUPPE4 TYPE STRING,
CODE4 TYPE STRING,
VERSION4 TYPE STRING,
KATALGART5 TYPE STRING,
GRUPVERS5 TYPE STRING,
GRUPPE5 TYPE STRING,
CODE5 TYPE STRING,
VERSION5 TYPE STRING,
CODE1TEXT TYPE STRING,
ERSTELLER TYPE STRING,
ERSTELLDAT TYPE STRING,
ZEITERSTL TYPE STRING,
AENDERER TYPE STRING,
AENDERDAT TYPE STRING,
ZEITAEND TYPE STRING,
MASCHINE TYPE STRING,
POSITION TYPE STRING,
DETAILERG TYPE STRING,
VORGLFNR TYPE STRING,
MERKNR TYPE STRING,
MESSWERT_C TYPE STRING,
ORIGINAL_INPUT TYPE STRING,
TECH TYPE STRING,
MANDANT TYPE STRING,
MESSWERTNI TYPE STRING,
MBEWERTG TYPE STRING,
FEHLKLAS TYPE STRING,
ATTRIBUT TYPE STRING,
DIFF_DEC_PLACES TYPE STRING,END OF T_EKKO_STR. DATA: WA_QGSE_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_QGSE_STR-PRUEFLOS sy-vline
WA_QGSE_STR-STUECKNR sy-vline
WA_QGSE_STR-PROBENR sy-vline
WA_QGSE_STR-MBEWERTG_KEYTEXT sy-vline
WA_QGSE_STR-MESSWERT sy-vline
WA_QGSE_STR-ANZFEHLER sy-vline
WA_QGSE_STR-FEHLKLAS_KEYTEXT sy-vline
WA_QGSE_STR-ESTUECKNR sy-vline
WA_QGSE_STR-SERIALNR sy-vline
WA_QGSE_STR-ATTRIBUT_KEYTEXT sy-vline
WA_QGSE_STR-PRUEFER sy-vline
WA_QGSE_STR-PRUEFDATUV sy-vline
WA_QGSE_STR-PRUEFDATUB sy-vline
WA_QGSE_STR-PRUEFZEITV sy-vline
WA_QGSE_STR-PRUEFZEITB sy-vline
WA_QGSE_STR-PRUEFBEMKT sy-vline
WA_QGSE_STR-KATALGART1 sy-vline
WA_QGSE_STR-GRUPPE1 sy-vline
WA_QGSE_STR-CODE1 sy-vline
WA_QGSE_STR-VERSION1 sy-vline
WA_QGSE_STR-KATALGART2 sy-vline
WA_QGSE_STR-GRUPPE2 sy-vline
WA_QGSE_STR-CODE2 sy-vline
WA_QGSE_STR-VERSION2 sy-vline
WA_QGSE_STR-KATALGART3 sy-vline
WA_QGSE_STR-GRUPPE3 sy-vline
WA_QGSE_STR-CODE3 sy-vline
WA_QGSE_STR-VERSION3 sy-vline
WA_QGSE_STR-KATALGART4 sy-vline
WA_QGSE_STR-GRUPPE4 sy-vline
WA_QGSE_STR-CODE4 sy-vline
WA_QGSE_STR-VERSION4 sy-vline
WA_QGSE_STR-KATALGART5 sy-vline
WA_QGSE_STR-GRUPVERS5 sy-vline
WA_QGSE_STR-GRUPPE5 sy-vline
WA_QGSE_STR-CODE5 sy-vline
WA_QGSE_STR-VERSION5 sy-vline
WA_QGSE_STR-CODE1TEXT sy-vline
WA_QGSE_STR-ERSTELLER sy-vline
WA_QGSE_STR-ERSTELLDAT sy-vline
WA_QGSE_STR-ZEITERSTL sy-vline
WA_QGSE_STR-AENDERER sy-vline
WA_QGSE_STR-AENDERDAT sy-vline
WA_QGSE_STR-ZEITAEND sy-vline
WA_QGSE_STR-MASCHINE sy-vline
WA_QGSE_STR-POSITION sy-vline
WA_QGSE_STR-DETAILERG sy-vline
WA_QGSE_STR-VORGLFNR sy-vline
WA_QGSE_STR-MERKNR sy-vline
WA_QGSE_STR-MESSWERT_C sy-vline
WA_QGSE_STR-ORIGINAL_INPUT sy-vline
WA_QGSE_STR-TECH sy-vline
WA_QGSE_STR-MANDANT sy-vline
WA_QGSE_STR-MESSWERTNI sy-vline
WA_QGSE_STR-MBEWERTG sy-vline
WA_QGSE_STR-FEHLKLAS sy-vline
WA_QGSE_STR-ATTRIBUT sy-vline
WA_QGSE_STR-DIFF_DEC_PLACES sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.