ABAP Select data from SAP table ORA_S_ST04_MAIN_DATA 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 ORA_S_ST04_MAIN_DATA 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 ORA_S_ST04_MAIN_DATA. 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 ORA_S_ST04_MAIN_DATA 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_ORA_S_ST04_MAIN_DATA TYPE STANDARD TABLE OF ORA_S_ST04_MAIN_DATA,
WA_ORA_S_ST04_MAIN_DATA TYPE ORA_S_ST04_MAIN_DATA,
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: <ORA_S_ST04_MAIN_DATA> TYPE ORA_S_ST04_MAIN_DATA.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_ORA_S_ST04_MAIN_DATA.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM ORA_S_ST04_MAIN_DATA
INTO TABLE IT_ORA_S_ST04_MAIN_DATA.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM ORA_S_ST04_MAIN_DATA
* INTO TABLE @DATA(IT_ORA_S_ST04_MAIN_DATA2).
*--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_ORA_S_ST04_MAIN_DATA INDEX 1 INTO DATA(WA_ORA_S_ST04_MAIN_DATA2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ORA_S_ST04_MAIN_DATA ASSIGNING <ORA_S_ST04_MAIN_DATA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<ORA_S_ST04_MAIN_DATA>-DB_INST_ID = 1.
<ORA_S_ST04_MAIN_DATA>-DB_INSTANCE = 1.
<ORA_S_ST04_MAIN_DATA>-DB_NODE = 1.
<ORA_S_ST04_MAIN_DATA>-DB_RELEASE = 1.
<ORA_S_ST04_MAIN_DATA>-DB_SYS_TIMESTAMP = 1.
ENDLOOP. LOOP AT IT_ORA_S_ST04_MAIN_DATA INTO WA_ORA_S_ST04_MAIN_DATA. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_ORA_S_ST04_MAIN_DATA-DB_SYSDATE, sy-vline,
WA_ORA_S_ST04_MAIN_DATA-DB_SYSTIME, sy-vline,
WA_ORA_S_ST04_MAIN_DATA-DB_STARTUP_TIMESTAMP, sy-vline,
WA_ORA_S_ST04_MAIN_DATA-DB_STARTDATE, sy-vline,
WA_ORA_S_ST04_MAIN_DATA-DB_STARTTIME, sy-vline,
WA_ORA_S_ST04_MAIN_DATA-DB_ELAPSED, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ORA_S_ST04_MAIN_DATA 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_ORA_S_ST04_MAIN_DATA 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_ORA_S_ST04_MAIN_DATA INTO WA_ORA_S_ST04_MAIN_DATA. *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_ORA_S_ST04_MAIN_DATA_STR,
DB_INST_ID TYPE STRING,
DB_INSTANCE TYPE STRING,
DB_NODE TYPE STRING,
DB_RELEASE TYPE STRING,
DB_SYS_TIMESTAMP TYPE STRING,
DB_SYSDATE TYPE STRING,
DB_SYSTIME TYPE STRING,
DB_STARTUP_TIMESTAMP TYPE STRING,
DB_STARTDATE TYPE STRING,
DB_STARTTIME TYPE STRING,
DB_ELAPSED TYPE STRING,
DB_SNAPDIFF TYPE STRING,
DATABUFFER_SIZE TYPE STRING,
NDATABUFFER_SIZE TYPE STRING,
DBUFF_QUALITY TYPE STRING,
NDBUFF_QUALITY TYPE STRING,
SIZE_DEFAULT_POOL TYPE STRING,
NSIZE_DEFAULT_POOL TYPE STRING,
SIZE_KEEP_POOL TYPE STRING,
NSIZE_KEEP_POOL TYPE STRING,
SIZE_OTHERS TYPE STRING,
NSIZE_OTHERS TYPE STRING,
DBUFF_LOGREADS TYPE STRING,
NDBUFF_LOGREADS TYPE STRING,
DBUFF_PHYSREADS TYPE STRING,
NDBUFF_PHYSREADS TYPE STRING,
DBUFF_PHYSWRITES TYPE STRING,
NDBUFF_PHYSWRITES TYPE STRING,
DBUFF_PHYSREADD TYPE STRING,
NDBUFF_PHYSREADD TYPE STRING,
DBUFF_PHYSREADDL TYPE STRING,
NDBUFF_PHYSREADDL TYPE STRING,
DBUFF_BUSYWAITS TYPE STRING,
NDBUFF_BUSYWAITS TYPE STRING,
DBUFF_WAITTIME TYPE STRING,
NDBUFF_WAITTIME TYPE STRING,
SHPL_SIZE TYPE STRING,
NSHPL_SIZE TYPE STRING,
SHPL_CAQUAL TYPE STRING,
NSHPL_CAQUAL TYPE STRING,
SHPL_GETRATIO TYPE STRING,
NSHPL_GETRATIO TYPE STRING,
SHPL_PINRATIO TYPE STRING,
NSHPL_PINRATIO TYPE STRING,
SHPL_RELOADSPINS TYPE STRING,
NSHPL_RELOADSPINS TYPE STRING,
LGBF_SIZE TYPE STRING,
NLGBF_SIZE TYPE STRING,
LGBF_ENTRIES TYPE STRING,
NLGBF_ENTRIES TYPE STRING,
LGBF_ALLORETR TYPE STRING,
NLGBF_ALLORETR TYPE STRING,
LGBF_ALLOFRAT TYPE STRING,
NLGBF_ALLOFRAT TYPE STRING,
LGBF_REDLGWT TYPE STRING,
NLGBF_REDLGWT TYPE STRING,
LGBF_LOGFILES TYPE STRING,
NLGBF_LOGFILES TYPE STRING,
LGBF_LOGFUSE TYPE STRING,
NLGBF_LOGFUSE TYPE STRING,
CLL_USERCALLS TYPE STRING,
NCLL_USERCALLS TYPE STRING,
CLL_USERCOMM TYPE STRING,
NCLL_USERCOMM TYPE STRING,
CLL_USERROLLB TYPE STRING,
NCLL_USERROLLB TYPE STRING,
CLL_RECURSIVE TYPE STRING,
NCLL_RECURSIVE TYPE STRING,
CLL_PARSECNT TYPE STRING,
NCLL_PARSECNT TYPE STRING,
CLL_USR_PER_RCCLL TYPE STRING,
NCLL_USR_PER_RCCLL TYPE STRING,
CLL_RDS_PER_UCLL TYPE STRING,
NCLL_RDS_PER_UCLL TYPE STRING,
TIMS_BUSYWT TYPE STRING,
NTIMS_BUSYWT TYPE STRING,
TIMS_CPUTIME TYPE STRING,
NTIMS_CPUTIME TYPE STRING,
TIMS_TIM_PER_UCLL TYPE STRING,
NTIMS_TIM_PER_UCLL TYPE STRING,
TIMS_SESS_BUSY TYPE STRING,
NTIMS_SESS_BUSY TYPE STRING,
TIMS_CPUUSAGE TYPE STRING,
NTIMS_CPUUSAGE TYPE STRING,
TIMS_CPUCOUNT TYPE STRING,
NTIMS_CPUCOUNT TYPE STRING,
RDLG_WRITES TYPE STRING,
NRDLG_WRITES TYPE STRING,
RDLG_OSBLCKWRT TYPE STRING,
NRDLG_OSBLCKWRT TYPE STRING,
RDLG_LTCHTIM TYPE STRING,
NRDLG_LTCHTIM TYPE STRING,
RDLG_WRTTIM TYPE STRING,
NRDLG_WRTTIM TYPE STRING,
RDLG_MBWRITTEN TYPE STRING,
NRDLG_MBWRITTEN TYPE STRING,
TABSF_SHTABSCAN TYPE STRING,
NTABSF_SHTABSCAN TYPE STRING,
TABSF_LGTABSCAN TYPE STRING,
NTABSF_LGTABSCAN TYPE STRING,
TABSF_FBYROWID TYPE STRING,
NTABSF_FBYROWID TYPE STRING,
TABSF_FBYCONTROW TYPE STRING,
NTABSF_FBYCONTROW TYPE STRING,
SORT_MEMORY TYPE STRING,
NSORT_MEMORY TYPE STRING,
SORT_DISK TYPE STRING,
NSORT_DISK TYPE STRING,
SORT_ROWS TYPE STRING,
NSORT_ROWS TYPE STRING,
SORT_WAEXOPT TYPE STRING,
NSORT_WAEXOPT TYPE STRING,
SORT_WAEXONEP TYPE STRING,
NSORT_WAEXONEP TYPE STRING,
SORT_WAEXMULTP TYPE STRING,
NSORT_WAEXMULTP TYPE STRING,
IEFF_SOFTPARSE TYPE STRING,
NIEFF_SOFTPARSE TYPE STRING,
IEFF_INMEM_SORT TYPE STRING,
NIEFF_INMEM_SORT TYPE STRING,
IEFF_PARSTOEXEC TYPE STRING,
NIEFF_PARSTOEXEC TYPE STRING,
IEFF_PARSCPUTOTOT TYPE STRING,
NIEFF_PARSCPUTOTOT TYPE STRING,
IEFF_PTCPU_PTELPS TYPE STRING,
NIEFF_PTCPU_PTELPS TYPE STRING,
NTOTGETS TYPE STRING,
NTOTGETMISS TYPE STRING,
NGETHITS TYPE STRING,
NPINHITS TYPE STRING,
NGETS TYPE STRING,
NPINS TYPE STRING,
NRELOADS TYPE STRING,
NLOGICALIO TYPE STRING,
NPARSECOUNTHARD TYPE STRING,
NPARSECOUNTTOTAL TYPE STRING,
NSORTSMEMORY TYPE STRING,
NSORTSDISK TYPE STRING,
NEXECUTECOUNT TYPE STRING,
NPARSETIMECPU TYPE STRING,
NCPUSESSION TYPE STRING,
NPARSETIMEELAPSED TYPE STRING,
NELAPSETIMESEC TYPE STRING,
NTOTALWAITTIME TYPE STRING,
NDB_CACHE_SIZE TYPE STRING,
NDBBUFSIZE_DBCACHE0 TYPE STRING,
NDBBUFSIZE_DEFPOOL0 TYPE STRING,
NMEMORY_TARGET TYPE STRING,
INMEMORY_SIZE TYPE STRING,
NINMEMORY_SIZE TYPE STRING,
DBTIME TYPE STRING,
NDBTIME TYPE STRING,
REDOLOG_GROUPS TYPE STRING,
NREDOLOG_GROUPS TYPE STRING,
READBYOTHERSESS TYPE STRING,
NREADBYOTHERSESS TYPE STRING,
READBYOTHERSESSTW TYPE STRING,
NREADBYOTHERSESSTW TYPE STRING,
DB_ELAPSED_C TYPE STRING,
NSQLNETSND TYPE STRING,
SQLNETSND TYPE STRING,
NSQLNETRCV TYPE STRING,
SQLNETRCV TYPE STRING,
NSQLNETRND TYPE STRING,
SQLNETRND TYPE STRING,
NSQLNETAVG TYPE STRING,
SQLNETAVG TYPE STRING,
NSQLNETSNDRAW TYPE STRING,
NSQLNETRCVRAW TYPE STRING,
NSQLNETRNDRAW TYPE STRING,END OF T_EKKO_STR. DATA: WA_ORA_S_ST04_MAIN_DATA_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_ORA_S_ST04_MAIN_DATA_STR-DB_INST_ID sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_INSTANCE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_NODE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_RELEASE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_SYS_TIMESTAMP sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_SYSDATE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_SYSTIME sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_STARTUP_TIMESTAMP sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_STARTDATE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_STARTTIME sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_ELAPSED sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_SNAPDIFF sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DATABUFFER_SIZE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDATABUFFER_SIZE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DBUFF_QUALITY sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBUFF_QUALITY sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SIZE_DEFAULT_POOL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSIZE_DEFAULT_POOL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SIZE_KEEP_POOL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSIZE_KEEP_POOL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SIZE_OTHERS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSIZE_OTHERS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DBUFF_LOGREADS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBUFF_LOGREADS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DBUFF_PHYSREADS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBUFF_PHYSREADS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DBUFF_PHYSWRITES sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBUFF_PHYSWRITES sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DBUFF_PHYSREADD sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBUFF_PHYSREADD sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DBUFF_PHYSREADDL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBUFF_PHYSREADDL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DBUFF_BUSYWAITS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBUFF_BUSYWAITS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DBUFF_WAITTIME sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBUFF_WAITTIME sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SHPL_SIZE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSHPL_SIZE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SHPL_CAQUAL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSHPL_CAQUAL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SHPL_GETRATIO sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSHPL_GETRATIO sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SHPL_PINRATIO sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSHPL_PINRATIO sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SHPL_RELOADSPINS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSHPL_RELOADSPINS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-LGBF_SIZE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NLGBF_SIZE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-LGBF_ENTRIES sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NLGBF_ENTRIES sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-LGBF_ALLORETR sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NLGBF_ALLORETR sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-LGBF_ALLOFRAT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NLGBF_ALLOFRAT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-LGBF_REDLGWT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NLGBF_REDLGWT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-LGBF_LOGFILES sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NLGBF_LOGFILES sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-LGBF_LOGFUSE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NLGBF_LOGFUSE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-CLL_USERCALLS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NCLL_USERCALLS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-CLL_USERCOMM sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NCLL_USERCOMM sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-CLL_USERROLLB sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NCLL_USERROLLB sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-CLL_RECURSIVE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NCLL_RECURSIVE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-CLL_PARSECNT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NCLL_PARSECNT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-CLL_USR_PER_RCCLL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NCLL_USR_PER_RCCLL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-CLL_RDS_PER_UCLL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NCLL_RDS_PER_UCLL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TIMS_BUSYWT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTIMS_BUSYWT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TIMS_CPUTIME sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTIMS_CPUTIME sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TIMS_TIM_PER_UCLL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTIMS_TIM_PER_UCLL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TIMS_SESS_BUSY sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTIMS_SESS_BUSY sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TIMS_CPUUSAGE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTIMS_CPUUSAGE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TIMS_CPUCOUNT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTIMS_CPUCOUNT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-RDLG_WRITES sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NRDLG_WRITES sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-RDLG_OSBLCKWRT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NRDLG_OSBLCKWRT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-RDLG_LTCHTIM sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NRDLG_LTCHTIM sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-RDLG_WRTTIM sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NRDLG_WRTTIM sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-RDLG_MBWRITTEN sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NRDLG_MBWRITTEN sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TABSF_SHTABSCAN sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTABSF_SHTABSCAN sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TABSF_LGTABSCAN sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTABSF_LGTABSCAN sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TABSF_FBYROWID sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTABSF_FBYROWID sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-TABSF_FBYCONTROW sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTABSF_FBYCONTROW sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SORT_MEMORY sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSORT_MEMORY sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SORT_DISK sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSORT_DISK sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SORT_ROWS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSORT_ROWS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SORT_WAEXOPT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSORT_WAEXOPT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SORT_WAEXONEP sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSORT_WAEXONEP sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SORT_WAEXMULTP sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSORT_WAEXMULTP sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-IEFF_SOFTPARSE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NIEFF_SOFTPARSE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-IEFF_INMEM_SORT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NIEFF_INMEM_SORT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-IEFF_PARSTOEXEC sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NIEFF_PARSTOEXEC sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-IEFF_PARSCPUTOTOT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NIEFF_PARSCPUTOTOT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-IEFF_PTCPU_PTELPS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NIEFF_PTCPU_PTELPS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTOTGETS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTOTGETMISS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NGETHITS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NPINHITS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NGETS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NPINS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NRELOADS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NLOGICALIO sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NPARSECOUNTHARD sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NPARSECOUNTTOTAL sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSORTSMEMORY sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSORTSDISK sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NEXECUTECOUNT sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NPARSETIMECPU sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NCPUSESSION sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NPARSETIMEELAPSED sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NELAPSETIMESEC sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NTOTALWAITTIME sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDB_CACHE_SIZE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBBUFSIZE_DBCACHE0 sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBBUFSIZE_DEFPOOL0 sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NMEMORY_TARGET sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-INMEMORY_SIZE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NINMEMORY_SIZE sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DBTIME sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NDBTIME sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-REDOLOG_GROUPS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NREDOLOG_GROUPS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-READBYOTHERSESS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NREADBYOTHERSESS sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-READBYOTHERSESSTW sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NREADBYOTHERSESSTW sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-DB_ELAPSED_C sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSQLNETSND sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SQLNETSND sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSQLNETRCV sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SQLNETRCV sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSQLNETRND sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SQLNETRND sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSQLNETAVG sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-SQLNETAVG sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSQLNETSNDRAW sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSQLNETRCVRAW sy-vline
WA_ORA_S_ST04_MAIN_DATA_STR-NSQLNETRNDRAW sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.