ABAP Select data from SAP table SDB_OVERVIEW 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 SDB_OVERVIEW 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 SDB_OVERVIEW. 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 SDB_OVERVIEW 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_SDB_OVERVIEW TYPE STANDARD TABLE OF SDB_OVERVIEW,
      WA_SDB_OVERVIEW TYPE SDB_OVERVIEW,
      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: <SDB_OVERVIEW> TYPE SDB_OVERVIEW.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SDB_OVERVIEW
*  INTO TABLE @DATA(IT_SDB_OVERVIEW2).
*--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_SDB_OVERVIEW INDEX 1 INTO DATA(WA_SDB_OVERVIEW2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<SDB_OVERVIEW>-REFRESH_DATE = 1.
<SDB_OVERVIEW>-REFRESH_TIME = 1.
<SDB_OVERVIEW>-CON_NAME = 1.
<SDB_OVERVIEW>-DESCRIPTION = 1.
<SDB_OVERVIEW>-DBNAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SDB_OVERVIEW-SQL_USER, sy-vline,
  WA_SDB_OVERVIEW-DBM_USER, sy-vline,
  WA_SDB_OVERVIEW-DBSERVER, sy-vline,
  WA_SDB_OVERVIEW-DBVERSION, sy-vline,
  WA_SDB_OVERVIEW-DISP_VERSION, sy-vline,
  WA_SDB_OVERVIEW-OPERATING_SYSTEM, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_SDB_OVERVIEW 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_SDB_OVERVIEW 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_SDB_OVERVIEW INTO WA_SDB_OVERVIEW.


*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_SDB_OVERVIEW_STR, 
REFRESH_DATE TYPE STRING,
REFRESH_TIME TYPE STRING,
CON_NAME TYPE STRING,
DESCRIPTION TYPE STRING,
DBNAME TYPE STRING,
SQL_USER TYPE STRING,
DBM_USER TYPE STRING,
DBSERVER TYPE STRING,
DBVERSION TYPE STRING,
DISP_VERSION TYPE STRING,
OPERATING_SYSTEM TYPE STRING,
STATE_ICON TYPE STRING,
NAME_STATE_ICON TYPE STRING,
STATE TYPE STRING,
TEXT_STANDBY TYPE STRING,
RESTART_DATE TYPE STRING,
RESTART_TIME TYPE STRING,
SQL_ACCESS TYPE STRING,
DBM_ACCESS TYPE STRING,
ACTIONS_EXECUTED TYPE STRING,
LAST_INIT_ICON TYPE STRING,
NAME_LAST_INIT_ICON TYPE STRING,
LAST_ACT_ICON TYPE STRING,
NAME_LAST_ACT_ICON TYPE STRING,
LAST_INIT_DATE TYPE STRING,
LAST_INIT_TIME TYPE STRING,
LAST_ACT_DATE TYPE STRING,
LAST_ACT_TIME TYPE STRING,
STATE_AUTOLOG TYPE STRING,
STATE_DBTRACE TYPE STRING,
STATE_COM_MONITOR TYPE STRING,
STATE_REC_MONITOR TYPE STRING,
STATE_OMS_ANALYSIS TYPE STRING,
STATE_DBAN TYPE STRING,
STATE_CHECKPOINT_WANTED TYPE STRING,
INSTROOT TYPE STRING,
INDEPPROGPATH TYPE STRING,
INDEPDATAPATH TYPE STRING,
RUNDIRECTORY TYPE STRING,
PRIVATEDATAPATH TYPE STRING,
HSS_VIRTUAL_NAME TYPE STRING,
HSS_CONFIGURATION TYPE STRING,
HSS_SHARED_LOG TYPE STRING,
ADDRESSING_MODE TYPE STRING,
IS_ONLINE TYPE STRING,
SQL_PROBLEM TYPE STRING,
DBM_PROBLEM TYPE STRING,
MULTI_TENANT TYPE STRING,
DISP_DESCRIPTION TYPE STRING,
DISP_DB_FULL TYPE STRING,
DISP_LOG_FULL TYPE STRING,
DISP_OVERWRITE_MODE TYPE STRING,
DISP_BAD_INDEXES TYPE STRING,
DISP_BAD_VOLUMES TYPE STRING,
DISP_WNG_LOGGING TYPE STRING,
DISP_LAST_INIT TYPE STRING,
DISP_LAST_ACT TYPE STRING,
DISP_HSS TYPE STRING,
DISP_HSS_NO_VIRTUAL_WARNING TYPE STRING,
DISP_ONEDB TYPE STRING,
DISP_BRIDGE TYPE STRING,
DISP_MULTI_TENANT TYPE STRING,
DISP_CHECKPOINT TYPE STRING,
DISP_OMS_ANALYSIS TYPE STRING,
DISP_SNAPSHOT TYPE STRING,
DISP_OPERATING TYPE STRING,
DISP_LVC_ACT TYPE STRING,
DISP_LVC_INIT TYPE STRING,
DISP_LCAPPS_REG TYPE STRING,
DISP_ONLINE_WARNING_1 TYPE STRING,
DISP_ONLINE_WARNING_2 TYPE STRING,
DISP_WARNING_FOOTNOTE TYPE STRING,
DISP_ADDRESSING_MODE TYPE STRING,
DISP_C_DETAILS TYPE STRING,
DISP_C_OPERATING TYPE STRING,
DISP_C_HSS TYPE STRING,
ENABLE_LCAPPS_REG TYPE STRING,
TITLE_DISPLAY TYPE STRING,
TITLE_PROPERTIES TYPE STRING,
TITLE_STATE TYPE STRING,
TITLE_OPERATING TYPE STRING,
TITLE_SETTINGS TYPE STRING,
TITLE_HSS TYPE STRING,
LABEL_REFRESH TYPE STRING,
LABEL_CON_NAME TYPE STRING,
LABEL_DESCRIPTION TYPE STRING,
LABEL_DBNAME TYPE STRING,
LABEL_DBSERVER TYPE STRING,
LABEL_DBVERSION TYPE STRING,
LABEL_DISP_VERSION TYPE STRING,
LABEL_SQL_USER TYPE STRING,
LABEL_DBM_USER TYPE STRING,
LABEL_OP_SYST TYPE STRING,
LABEL_STATE TYPE STRING,
LABEL_ONLINE_SINCE TYPE STRING,
LABEL_OPERATING TYPE STRING,
LABEL_LAST_INIT TYPE STRING,
LABEL_LAST_INIT_TIME TYPE STRING,
LABEL_LAST_ACT TYPE STRING,
LABEL_LAST_ACT_TIME TYPE STRING,
LABEL_INSTROOT TYPE STRING,
LABEL_INDEPPROGPATH TYPE STRING,
LABEL_INDEPDATAPATH TYPE STRING,
LABEL_RUNDIRECTORY TYPE STRING,
LABEL_PRIVATEDATAPATH TYPE STRING,
LABEL_AUTOLOG TYPE STRING,
LABEL_DBTRACE TYPE STRING,
LABEL_COM_MONITOR TYPE STRING,
LABEL_REC_MONITOR TYPE STRING,
LABEL_OMS_ANALYSIS TYPE STRING,
LABEL_DBAN TYPE STRING,
LABEL_CHECKPOINT_WANTED TYPE STRING,
LABEL_SQL_ACCESS TYPE STRING,
LABEL_DBM_ACCESS TYPE STRING,
LABEL_SNAPSHOT TYPE STRING,
LABEL_ONLINE_WARNING_1 TYPE STRING,
LABEL_ONLINE_WARNING_2 TYPE STRING,
LABEL_HSS_VIRTUAL_NAME TYPE STRING,
LABEL_HSS_SHARED_LOG TYPE STRING,
LABEL_MULTI_TENANT TYPE STRING,
LABEL_ADDRESSING_MODE TYPE STRING,
TEXT_SNAPSHOT TYPE STRING,
TEXT_ONEDB TYPE STRING,
TEXT_BRIDGE TYPE STRING,
TEXT_MULTI_TENANT TYPE STRING,
TEXT_LOG_FULL TYPE STRING,
TEXT_DATA_FULL TYPE STRING,
TEXT_OVERWRITE_MODE TYPE STRING,
TEXT_HSS_NO_VIRTUAL_WARNING TYPE STRING,
TEXT_BAD_INDEX TYPE STRING,
TEXT_BAD_VOLUME TYPE STRING,
TEXT_WNG_LOGGING TYPE STRING,
TEXT_STATE_ICON TYPE STRING,
TEXT_LAST_INIT_ICON TYPE STRING,
TEXT_LAST_ACT_ICON TYPE STRING,
TEXT_LOG TYPE STRING,
TEXT_LVC_START TYPE STRING,
TEXT_LVC_STOP TYPE STRING,
TEXT_LVC_INIT TYPE STRING,
TEXT_LCAPPS_REG TYPE STRING,
TEXT_LAST_INIT TYPE STRING,
TEXT_LAST_ACT TYPE STRING,
TEXT_WARNING_FOOTNOTE TYPE STRING,
TEXT_BUTTON_DETAILS TYPE STRING,
TEXT_BUTTON_OPERATING TYPE STRING,
TEXT_BUTTON_HSS TYPE STRING,
ICON_NAME_DETAILS TYPE STRING,
ICON_NAME_OPERATING TYPE STRING,
ICON_NAME_HSS TYPE STRING,
USEDSIZEPERCENTAGE_DATA TYPE STRING,
USEDSIZEPERCENTAGE_LOG TYPE STRING,
USEDSIZEPERCENTAGE_SESS TYPE STRING,
DISP_GRAPH_DATA TYPE STRING,
DISP_GRAPH_LOG TYPE STRING,
DISP_GRAPH_SESS TYPE STRING,
LABEL_GRAPH TYPE STRING,
LABEL_GRAPH_DATA TYPE STRING,
LABEL_GRAPH_LOG TYPE STRING,
LABEL_GRAPH_SESS TYPE STRING,
SQL_POSSIBLE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_SDB_OVERVIEW_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_SDB_OVERVIEW_STR-REFRESH_DATE sy-vline 
WA_SDB_OVERVIEW_STR-REFRESH_TIME sy-vline 
WA_SDB_OVERVIEW_STR-CON_NAME sy-vline 
WA_SDB_OVERVIEW_STR-DESCRIPTION sy-vline 
WA_SDB_OVERVIEW_STR-DBNAME sy-vline 
WA_SDB_OVERVIEW_STR-SQL_USER sy-vline 
WA_SDB_OVERVIEW_STR-DBM_USER sy-vline 
WA_SDB_OVERVIEW_STR-DBSERVER sy-vline 
WA_SDB_OVERVIEW_STR-DBVERSION sy-vline 
WA_SDB_OVERVIEW_STR-DISP_VERSION sy-vline 
WA_SDB_OVERVIEW_STR-OPERATING_SYSTEM sy-vline 
WA_SDB_OVERVIEW_STR-STATE_ICON sy-vline 
WA_SDB_OVERVIEW_STR-NAME_STATE_ICON sy-vline 
WA_SDB_OVERVIEW_STR-STATE sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_STANDBY sy-vline 
WA_SDB_OVERVIEW_STR-RESTART_DATE sy-vline 
WA_SDB_OVERVIEW_STR-RESTART_TIME sy-vline 
WA_SDB_OVERVIEW_STR-SQL_ACCESS sy-vline 
WA_SDB_OVERVIEW_STR-DBM_ACCESS sy-vline 
WA_SDB_OVERVIEW_STR-ACTIONS_EXECUTED sy-vline 
WA_SDB_OVERVIEW_STR-LAST_INIT_ICON sy-vline 
WA_SDB_OVERVIEW_STR-NAME_LAST_INIT_ICON sy-vline 
WA_SDB_OVERVIEW_STR-LAST_ACT_ICON sy-vline 
WA_SDB_OVERVIEW_STR-NAME_LAST_ACT_ICON sy-vline 
WA_SDB_OVERVIEW_STR-LAST_INIT_DATE sy-vline 
WA_SDB_OVERVIEW_STR-LAST_INIT_TIME sy-vline 
WA_SDB_OVERVIEW_STR-LAST_ACT_DATE sy-vline 
WA_SDB_OVERVIEW_STR-LAST_ACT_TIME sy-vline 
WA_SDB_OVERVIEW_STR-STATE_AUTOLOG sy-vline 
WA_SDB_OVERVIEW_STR-STATE_DBTRACE sy-vline 
WA_SDB_OVERVIEW_STR-STATE_COM_MONITOR sy-vline 
WA_SDB_OVERVIEW_STR-STATE_REC_MONITOR sy-vline 
WA_SDB_OVERVIEW_STR-STATE_OMS_ANALYSIS sy-vline 
WA_SDB_OVERVIEW_STR-STATE_DBAN sy-vline 
WA_SDB_OVERVIEW_STR-STATE_CHECKPOINT_WANTED sy-vline 
WA_SDB_OVERVIEW_STR-INSTROOT sy-vline 
WA_SDB_OVERVIEW_STR-INDEPPROGPATH sy-vline 
WA_SDB_OVERVIEW_STR-INDEPDATAPATH sy-vline 
WA_SDB_OVERVIEW_STR-RUNDIRECTORY sy-vline 
WA_SDB_OVERVIEW_STR-PRIVATEDATAPATH sy-vline 
WA_SDB_OVERVIEW_STR-HSS_VIRTUAL_NAME sy-vline 
WA_SDB_OVERVIEW_STR-HSS_CONFIGURATION sy-vline 
WA_SDB_OVERVIEW_STR-HSS_SHARED_LOG sy-vline 
WA_SDB_OVERVIEW_STR-ADDRESSING_MODE sy-vline 
WA_SDB_OVERVIEW_STR-IS_ONLINE sy-vline 
WA_SDB_OVERVIEW_STR-SQL_PROBLEM sy-vline 
WA_SDB_OVERVIEW_STR-DBM_PROBLEM sy-vline 
WA_SDB_OVERVIEW_STR-MULTI_TENANT sy-vline 
WA_SDB_OVERVIEW_STR-DISP_DESCRIPTION sy-vline 
WA_SDB_OVERVIEW_STR-DISP_DB_FULL sy-vline 
WA_SDB_OVERVIEW_STR-DISP_LOG_FULL sy-vline 
WA_SDB_OVERVIEW_STR-DISP_OVERWRITE_MODE sy-vline 
WA_SDB_OVERVIEW_STR-DISP_BAD_INDEXES sy-vline 
WA_SDB_OVERVIEW_STR-DISP_BAD_VOLUMES sy-vline 
WA_SDB_OVERVIEW_STR-DISP_WNG_LOGGING sy-vline 
WA_SDB_OVERVIEW_STR-DISP_LAST_INIT sy-vline 
WA_SDB_OVERVIEW_STR-DISP_LAST_ACT sy-vline 
WA_SDB_OVERVIEW_STR-DISP_HSS sy-vline 
WA_SDB_OVERVIEW_STR-DISP_HSS_NO_VIRTUAL_WARNING sy-vline 
WA_SDB_OVERVIEW_STR-DISP_ONEDB sy-vline 
WA_SDB_OVERVIEW_STR-DISP_BRIDGE sy-vline 
WA_SDB_OVERVIEW_STR-DISP_MULTI_TENANT sy-vline 
WA_SDB_OVERVIEW_STR-DISP_CHECKPOINT sy-vline 
WA_SDB_OVERVIEW_STR-DISP_OMS_ANALYSIS sy-vline 
WA_SDB_OVERVIEW_STR-DISP_SNAPSHOT sy-vline 
WA_SDB_OVERVIEW_STR-DISP_OPERATING sy-vline 
WA_SDB_OVERVIEW_STR-DISP_LVC_ACT sy-vline 
WA_SDB_OVERVIEW_STR-DISP_LVC_INIT sy-vline 
WA_SDB_OVERVIEW_STR-DISP_LCAPPS_REG sy-vline 
WA_SDB_OVERVIEW_STR-DISP_ONLINE_WARNING_1 sy-vline 
WA_SDB_OVERVIEW_STR-DISP_ONLINE_WARNING_2 sy-vline 
WA_SDB_OVERVIEW_STR-DISP_WARNING_FOOTNOTE sy-vline 
WA_SDB_OVERVIEW_STR-DISP_ADDRESSING_MODE sy-vline 
WA_SDB_OVERVIEW_STR-DISP_C_DETAILS sy-vline 
WA_SDB_OVERVIEW_STR-DISP_C_OPERATING sy-vline 
WA_SDB_OVERVIEW_STR-DISP_C_HSS sy-vline 
WA_SDB_OVERVIEW_STR-ENABLE_LCAPPS_REG sy-vline 
WA_SDB_OVERVIEW_STR-TITLE_DISPLAY sy-vline 
WA_SDB_OVERVIEW_STR-TITLE_PROPERTIES sy-vline 
WA_SDB_OVERVIEW_STR-TITLE_STATE sy-vline 
WA_SDB_OVERVIEW_STR-TITLE_OPERATING sy-vline 
WA_SDB_OVERVIEW_STR-TITLE_SETTINGS sy-vline 
WA_SDB_OVERVIEW_STR-TITLE_HSS sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_REFRESH sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_CON_NAME sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_DESCRIPTION sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_DBNAME sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_DBSERVER sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_DBVERSION sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_DISP_VERSION sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_SQL_USER sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_DBM_USER sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_OP_SYST sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_STATE sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_ONLINE_SINCE sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_OPERATING sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_LAST_INIT sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_LAST_INIT_TIME sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_LAST_ACT sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_LAST_ACT_TIME sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_INSTROOT sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_INDEPPROGPATH sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_INDEPDATAPATH sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_RUNDIRECTORY sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_PRIVATEDATAPATH sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_AUTOLOG sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_DBTRACE sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_COM_MONITOR sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_REC_MONITOR sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_OMS_ANALYSIS sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_DBAN sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_CHECKPOINT_WANTED sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_SQL_ACCESS sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_DBM_ACCESS sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_SNAPSHOT sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_ONLINE_WARNING_1 sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_ONLINE_WARNING_2 sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_HSS_VIRTUAL_NAME sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_HSS_SHARED_LOG sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_MULTI_TENANT sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_ADDRESSING_MODE sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_SNAPSHOT sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_ONEDB sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_BRIDGE sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_MULTI_TENANT sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LOG_FULL sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_DATA_FULL sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_OVERWRITE_MODE sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_HSS_NO_VIRTUAL_WARNING sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_BAD_INDEX sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_BAD_VOLUME sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_WNG_LOGGING sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_STATE_ICON sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LAST_INIT_ICON sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LAST_ACT_ICON sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LOG sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LVC_START sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LVC_STOP sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LVC_INIT sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LCAPPS_REG sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LAST_INIT sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_LAST_ACT sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_WARNING_FOOTNOTE sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_BUTTON_DETAILS sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_BUTTON_OPERATING sy-vline 
WA_SDB_OVERVIEW_STR-TEXT_BUTTON_HSS sy-vline 
WA_SDB_OVERVIEW_STR-ICON_NAME_DETAILS sy-vline 
WA_SDB_OVERVIEW_STR-ICON_NAME_OPERATING sy-vline 
WA_SDB_OVERVIEW_STR-ICON_NAME_HSS sy-vline 
WA_SDB_OVERVIEW_STR-USEDSIZEPERCENTAGE_DATA sy-vline 
WA_SDB_OVERVIEW_STR-USEDSIZEPERCENTAGE_LOG sy-vline 
WA_SDB_OVERVIEW_STR-USEDSIZEPERCENTAGE_SESS sy-vline 
WA_SDB_OVERVIEW_STR-DISP_GRAPH_DATA sy-vline 
WA_SDB_OVERVIEW_STR-DISP_GRAPH_LOG sy-vline 
WA_SDB_OVERVIEW_STR-DISP_GRAPH_SESS sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_GRAPH sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_GRAPH_DATA sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_GRAPH_LOG sy-vline 
WA_SDB_OVERVIEW_STR-LABEL_GRAPH_SESS sy-vline 
WA_SDB_OVERVIEW_STR-SQL_POSSIBLE sy-vline      INTO ld_text SEPARATED BY SPACE.

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