ABAP Select data from SAP table ETEXECDATA into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP ETEXECDATA 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 ETEXECDATA. 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 ETEXECDATA 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_ETEXECDATA TYPE STANDARD TABLE OF ETEXECDATA,
      WA_ETEXECDATA TYPE ETEXECDATA,
      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: <ETEXECDATA> TYPE ETEXECDATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ETEXECDATA
*  INTO TABLE @DATA(IT_ETEXECDATA2).
*--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_ETEXECDATA INDEX 1 INTO DATA(WA_ETEXECDATA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ETEXECDATA ASSIGNING <ETEXECDATA>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<ETEXECDATA>-INTERRUPT = 1.
<ETEXECDATA>-EXEC_CTRL = 1.
<ETEXECDATA>-DEBUG = 1.
<ETEXECDATA>-FSTARTMODE = 1.
<ETEXECDATA>-STARTMODE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ETEXECDATA-SYSTEMDATA, sy-vline,
  WA_ETEXECDATA-TARGETSYSTEM, sy-vline,
  WA_ETEXECDATA-VARIANT_ID, sy-vline,
  WA_ETEXECDATA-START_TYPE, sy-vline,
  WA_ETEXECDATA-MAXRUNTIME, sy-vline,
  WA_ETEXECDATA-ARCHIVE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_ETEXECDATA 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_ETEXECDATA 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_ETEXECDATA INTO WA_ETEXECDATA.


*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.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_ETEXECDATA_STR, 
INTERRUPT TYPE STRING,
EXEC_CTRL TYPE STRING,
DEBUG TYPE STRING,
FSTARTMODE TYPE STRING,
STARTMODE TYPE STRING,
SYSTEMDATA TYPE STRING,
TARGETSYSTEM TYPE STRING,
VARIANT_ID TYPE STRING,
START_TYPE TYPE STRING,
MAXRUNTIME TYPE STRING,
ARCHIVE TYPE STRING,
MODE_SAPGUI TYPE STRING,
MODE_EXTTOOL TYPE STRING,
MODE_SAPGUI_BREAK TYPE STRING,
MODE_SAPGUI_SYNC TYPE STRING,
MODE_SAPGUI_DEBUG TYPE STRING,
DISPLAY_LOG TYPE STRING,
MODE_SAPGUI_CLOSE TYPE STRING,
USERNAME TYPE STRING,
PASSWORD TYPE STRING,
PROJECT TYPE STRING,
CANCEL TYPE STRING,
OLD_LOG_ID TYPE STRING,
TWB_STATE_SET TYPE STRING,
PERF_TRACE TYPE STRING,
REM_CATT_INT_TSYS TYPE STRING,
PERF_TRACE_SQL TYPE STRING,
PERF_TRACE_ENQ TYPE STRING,
PERF_TRACE_RFC TYPE STRING,
PERF_TRACE_BUF TYPE STRING,
PERF_TRACE_RESCON TYPE STRING,
TWB_RFC_CLOSE TYPE STRING,
MODE_SAPGUI_HIGHLIGHT TYPE STRING,
MODE_SAPGUI_IN_ONE_SESS TYPE STRING,
RFC_USE_ASYNC TYPE STRING,
APL_LOG TYPE STRING,
WEB_MODE TYPE STRING,
WEB_DURATION TYPE STRING,
MODE_SAPGUI_PIC TYPE STRING,
GUIPIC1 TYPE STRING,
GUIPIC2 TYPE STRING,
GUIPIC3 TYPE STRING,
GUIPIC4 TYPE STRING,
GUIPIC_PATH TYPE STRING,
GUIPIC_PATH_E TYPE STRING,
GUIMINI TYPE STRING,
ESF_DEBUG TYPE STRING,
PRECONDITION TYPE STRING,
SHORT_LOG TYPE STRING,
MODE_EXTTOOL_DB TYPE STRING,
MODE_EXTTOOL_LOG TYPE STRING,
AGSSMT_BPCA_TRC TYPE STRING,
TRANSFER_EXTTOOL_LOG TYPE STRING,
SCOV_MEASUREMENT_TYPE TYPE STRING,
SCOV_INTERRUPT TYPE STRING,
SCOV_EVALUATION_PERIOD TYPE STRING,
SCOV_SDL_SWITCH TYPE STRING,
BCSET_ACTIVATION_MODE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_ETEXECDATA_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_ETEXECDATA_STR-INTERRUPT sy-vline 
WA_ETEXECDATA_STR-EXEC_CTRL sy-vline 
WA_ETEXECDATA_STR-DEBUG sy-vline 
WA_ETEXECDATA_STR-FSTARTMODE sy-vline 
WA_ETEXECDATA_STR-STARTMODE sy-vline 
WA_ETEXECDATA_STR-SYSTEMDATA sy-vline 
WA_ETEXECDATA_STR-TARGETSYSTEM sy-vline 
WA_ETEXECDATA_STR-VARIANT_ID sy-vline 
WA_ETEXECDATA_STR-START_TYPE sy-vline 
WA_ETEXECDATA_STR-MAXRUNTIME sy-vline 
WA_ETEXECDATA_STR-ARCHIVE sy-vline 
WA_ETEXECDATA_STR-MODE_SAPGUI sy-vline 
WA_ETEXECDATA_STR-MODE_EXTTOOL sy-vline 
WA_ETEXECDATA_STR-MODE_SAPGUI_BREAK sy-vline 
WA_ETEXECDATA_STR-MODE_SAPGUI_SYNC sy-vline 
WA_ETEXECDATA_STR-MODE_SAPGUI_DEBUG sy-vline 
WA_ETEXECDATA_STR-DISPLAY_LOG sy-vline 
WA_ETEXECDATA_STR-MODE_SAPGUI_CLOSE sy-vline 
WA_ETEXECDATA_STR-USERNAME sy-vline 
WA_ETEXECDATA_STR-PASSWORD sy-vline 
WA_ETEXECDATA_STR-PROJECT sy-vline 
WA_ETEXECDATA_STR-CANCEL sy-vline 
WA_ETEXECDATA_STR-OLD_LOG_ID sy-vline 
WA_ETEXECDATA_STR-TWB_STATE_SET sy-vline 
WA_ETEXECDATA_STR-PERF_TRACE sy-vline 
WA_ETEXECDATA_STR-REM_CATT_INT_TSYS sy-vline 
WA_ETEXECDATA_STR-PERF_TRACE_SQL sy-vline 
WA_ETEXECDATA_STR-PERF_TRACE_ENQ sy-vline 
WA_ETEXECDATA_STR-PERF_TRACE_RFC sy-vline 
WA_ETEXECDATA_STR-PERF_TRACE_BUF sy-vline 
WA_ETEXECDATA_STR-PERF_TRACE_RESCON sy-vline 
WA_ETEXECDATA_STR-TWB_RFC_CLOSE sy-vline 
WA_ETEXECDATA_STR-MODE_SAPGUI_HIGHLIGHT sy-vline 
WA_ETEXECDATA_STR-MODE_SAPGUI_IN_ONE_SESS sy-vline 
WA_ETEXECDATA_STR-RFC_USE_ASYNC sy-vline 
WA_ETEXECDATA_STR-APL_LOG sy-vline 
WA_ETEXECDATA_STR-WEB_MODE sy-vline 
WA_ETEXECDATA_STR-WEB_DURATION sy-vline 
WA_ETEXECDATA_STR-MODE_SAPGUI_PIC sy-vline 
WA_ETEXECDATA_STR-GUIPIC1 sy-vline 
WA_ETEXECDATA_STR-GUIPIC2 sy-vline 
WA_ETEXECDATA_STR-GUIPIC3 sy-vline 
WA_ETEXECDATA_STR-GUIPIC4 sy-vline 
WA_ETEXECDATA_STR-GUIPIC_PATH sy-vline 
WA_ETEXECDATA_STR-GUIPIC_PATH_E sy-vline 
WA_ETEXECDATA_STR-GUIMINI sy-vline 
WA_ETEXECDATA_STR-ESF_DEBUG sy-vline 
WA_ETEXECDATA_STR-PRECONDITION sy-vline 
WA_ETEXECDATA_STR-SHORT_LOG sy-vline 
WA_ETEXECDATA_STR-MODE_EXTTOOL_DB sy-vline 
WA_ETEXECDATA_STR-MODE_EXTTOOL_LOG sy-vline 
WA_ETEXECDATA_STR-AGSSMT_BPCA_TRC sy-vline 
WA_ETEXECDATA_STR-TRANSFER_EXTTOOL_LOG sy-vline 
WA_ETEXECDATA_STR-SCOV_MEASUREMENT_TYPE sy-vline 
WA_ETEXECDATA_STR-SCOV_INTERRUPT sy-vline 
WA_ETEXECDATA_STR-SCOV_EVALUATION_PERIOD sy-vline 
WA_ETEXECDATA_STR-SCOV_SDL_SWITCH sy-vline 
WA_ETEXECDATA_STR-BCSET_ACTIVATION_MODE sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.