ABAP Select data from SAP table DB6_VIEW_TABLE_DETAIL 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 DB6_VIEW_TABLE_DETAIL 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 DB6_VIEW_TABLE_DETAIL. 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 DB6_VIEW_TABLE_DETAIL 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_DB6_VIEW_TABLE_DETAIL TYPE STANDARD TABLE OF DB6_VIEW_TABLE_DETAIL,
      WA_DB6_VIEW_TABLE_DETAIL TYPE DB6_VIEW_TABLE_DETAIL,
      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: <DB6_VIEW_TABLE_DETAIL> TYPE DB6_VIEW_TABLE_DETAIL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM DB6_VIEW_TABLE_DETAIL
*  INTO TABLE @DATA(IT_DB6_VIEW_TABLE_DETAIL2).
*--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_DB6_VIEW_TABLE_DETAIL INDEX 1 INTO DATA(WA_DB6_VIEW_TABLE_DETAIL2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_DB6_VIEW_TABLE_DETAIL ASSIGNING <DB6_VIEW_TABLE_DETAIL>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<DB6_VIEW_TABLE_DETAIL>-IT_IDX_REORGCHK = 1.
<DB6_VIEW_TABLE_DETAIL>-IT_IDX_INFO = 1.
<DB6_VIEW_TABLE_DETAIL>-IT_IDX_COMPRESS = 1.
<DB6_VIEW_TABLE_DETAIL>-IT_IDX_COLUMNS = 1.
<DB6_VIEW_TABLE_DETAIL>-IT_TAB_COLUMNS = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_DB6_VIEW_TABLE_DETAIL-IT_TAB_INDEXES, sy-vline,
WA_DB6_VIEW_TABLE_DETAIL-IT_TAB_INFO, sy-vline,
WA_DB6_VIEW_TABLE_DETAIL-IT_TAB_COMPRESS, sy-vline,
WA_DB6_VIEW_TABLE_DETAIL-IT_TAB_REORGCHK, sy-vline,
WA_DB6_VIEW_TABLE_DETAIL-IT_TAB_DATAPARTITIONS, sy-vline,
WA_DB6_VIEW_TABLE_DETAIL-IT_TAB_COLDIST, sy-vline.
ENDLOOP. *Add any further fields from structure WA_DB6_VIEW_TABLE_DETAIL 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_DB6_VIEW_TABLE_DETAIL 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_DB6_VIEW_TABLE_DETAIL INTO WA_DB6_VIEW_TABLE_DETAIL. *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_DB6_VIEW_TABLE_DETAIL_STR,
IT_IDX_REORGCHK TYPE STRING,
IT_IDX_INFO TYPE STRING,
IT_IDX_COMPRESS TYPE STRING,
IT_IDX_COLUMNS TYPE STRING,
IT_TAB_COLUMNS TYPE STRING,
IT_TAB_INDEXES TYPE STRING,
IT_TAB_INFO TYPE STRING,
IT_TAB_COMPRESS TYPE STRING,
IT_TAB_REORGCHK TYPE STRING,
IT_TAB_DATAPARTITIONS TYPE STRING,
IT_TAB_COLDIST TYPE STRING,
TAB_SYSCAT TYPE STRING,
TABSCHEMA TYPE STRING,
TABNAME TYPE STRING,
DEFINER TYPE STRING,
TYPE TYPE STRING,
STATUS TYPE STRING,
BASE_TABSCHEMA TYPE STRING,
BASE_TABNAME TYPE STRING,
ROWTYPESCHEMA TYPE STRING,
ROWTYPENAME TYPE STRING,
CREATE_TIME TYPE STRING,
STATS_TIME TYPE STRING,
COLCOUNT TYPE STRING,
TABLEID TYPE STRING,
TBSPACEID TYPE STRING,
CARD TYPE STRING,
NPAGES TYPE STRING,
FPAGES TYPE STRING,
OVERFLOW TYPE STRING,
TBSPACE TYPE STRING,
INDEX_TBSPACE TYPE STRING,
LONG_TBSPACE TYPE STRING,
PARENTS TYPE STRING,
CHILDREN TYPE STRING,
SELFREFS TYPE STRING,
KEYCOLUMNS TYPE STRING,
KEYINDEXID TYPE STRING,
KEYUNIQUE TYPE STRING,
CHECKCOUNT TYPE STRING,
DATACAPTURE TYPE STRING,
CONST_CHECKED TYPE STRING,
PMAP_ID TYPE STRING,
PARTITION_MODE TYPE STRING,
LOG_ATTRIBUTE TYPE STRING,
PCTFREE TYPE STRING,
APPEND_MODE TYPE STRING,
REFRESH TYPE STRING,
REFRESH_TIME TYPE STRING,
LOCKSIZE TYPE STRING,
VOLATILE TYPE STRING,
REMARKS TYPE STRING,
ROW_FORMAT TYPE STRING,
PROPERTY TYPE STRING,
STATISTICS_PROFILE TYPE STRING,
COMPRESSION TYPE STRING,
ACCESS_MODE TYPE STRING,
CLUSTERED TYPE STRING,
ACTIVE_BLOCKS TYPE STRING,
DROPRULE TYPE STRING,
MAXFREESPACESEARCH TYPE STRING,
AVGCOMPRESSEDROWSIZE TYPE STRING,
AVGROWCOMPRESSIONRATIO TYPE STRING,
AVGROWSIZE TYPE STRING,
PCTROWSCOMPRESSED TYPE STRING,
PCTPAGESSAVED TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
ROWCOMPMODE TYPE STRING,
TABLEORG TYPE STRING,
TAB_REORGCHK TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
TABSCHEMA TYPE STRING,
TABNAME TYPE STRING,
DATAPARTITIONNAME TYPE STRING,
CARD TYPE STRING,
OVERFLOW TYPE STRING,
NPAGES TYPE STRING,
FPAGES TYPE STRING,
ACTIVE_BLOCKS TYPE STRING,
TSIZE TYPE STRING,
F1 TYPE STRING,
F2 TYPE STRING,
F3 TYPE STRING,
REORG TYPE STRING,
F1_ICON TYPE STRING,
F2_ICON TYPE STRING,
F3_ICON TYPE STRING,
TAB_INFO TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
TABSCHEMA TYPE STRING,
TABNAME TYPE STRING,
TABTYPE TYPE STRING,
PARTITN TYPE STRING,
DATA_PARTITION_ID TYPE STRING,
AVAILABLE TYPE STRING,
DATA_OBJECT_L_SIZE TYPE STRING,
DATA_OBJECT_P_SIZE TYPE STRING,
INDEX_OBJECT_L_SIZE TYPE STRING,
INDEX_OBJECT_P_SIZE TYPE STRING,
LONG_OBJECT_L_SIZE TYPE STRING,
LONG_OBJECT_P_SIZE TYPE STRING,
LOB_OBJECT_L_SIZE TYPE STRING,
LOB_OBJECT_P_SIZE TYPE STRING,
XML_OBJECT_L_SIZE TYPE STRING,
XML_OBJECT_P_SIZE TYPE STRING,
INDEX_TYPE TYPE STRING,
REORG_PENDING TYPE STRING,
INPLACE_REORG_STATUS TYPE STRING,
LOAD_STATUS TYPE STRING,
READ_ACCESS_ONLY TYPE STRING,
NO_LOAD_RESTART TYPE STRING,
NUM_REORG_REC_ALTERS TYPE STRING,
INDEXES_REQUIRE_REBUILD TYPE STRING,
LARGE_RIDS TYPE STRING,
LARGE_SLOTS TYPE STRING,
DICTIONARY_SIZE TYPE STRING,
BLOCKS_PENDING_CLEANUP TYPE STRING,
STATSTYPE TYPE STRING,
XML_RECORD_TYPE TYPE STRING,
RECLAIMABLE_SPACE TYPE STRING,
XML_DICTIONARY_SIZE TYPE STRING,
AMT_STATUS TYPE STRING,
COL_OBJECT_L_SIZE TYPE STRING,
COL_OBJECT_P_SIZE TYPE STRING,
TAB_COMPRESSION TYPE STRING,
TABSCHEMA TYPE STRING,
TABNAME TYPE STRING,
PARTITN TYPE STRING,
DATA_PARTITION_ID TYPE STRING,
COMPRESS_ATTR TYPE STRING,
DICT_BUILDER TYPE STRING,
SAVED_PAGES_PCT TYPE STRING,
SAVED_BYTES_PCT TYPE STRING,
ROWS_TOO_SMALL_PCT TYPE STRING,
COMPRESSION_DICT_SIZE TYPE STRING,
EXPANSION_DICT_SIZE TYPE STRING,
ROWS_SAMPLED TYPE STRING,
AVG_COMPRESS_REC_LENGTH TYPE STRING,
OBJECT_TYPE TYPE STRING,
DICT_BUILD_TIMESTAMP TYPE STRING,
CHECK_TIMESTAMP TYPE STRING,
ROWCOMPMODE TYPE STRING,
PCTPAGESSAVED_ADAPTIVE TYPE STRING,
AVGROWSIZE_ADAPTIVE TYPE STRING,
IDX_SYSCAT TYPE STRING,
INDSCHEMA TYPE STRING,
INDNAME TYPE STRING,
DEFINER TYPE STRING,
TABSCHEMA TYPE STRING,
TABNAME TYPE STRING,
COLNAMES TYPE STRING,
UNIQUERULE TYPE STRING,
MADE_UNIQUE TYPE STRING,
COLCOUNT TYPE STRING,
UNIQUE_COLCOUNT TYPE STRING,
INDEXTYPE TYPE STRING,
ENTRYTYPE TYPE STRING,
PCTFREE TYPE STRING,
IID TYPE STRING,
NLEAF TYPE STRING,
NLEVELS TYPE STRING,
FIRSTKEYCARD TYPE STRING,
FIRST2KEYCARD TYPE STRING,
FIRST3KEYCARD TYPE STRING,
FIRST4KEYCARD TYPE STRING,
FULLKEYCARD TYPE STRING,
CLUSTERRATIO TYPE STRING,
CLUSTERFACTOR TYPE STRING,
SEQUENTIAL_PAGES TYPE STRING,
DENSITY TYPE STRING,
USER_DEFINED TYPE STRING,
SYSTEM_REQUIRED TYPE STRING,
CREATE_TIME TYPE STRING,
STATS_TIME TYPE STRING,
MINPCTUSED TYPE STRING,
REVERSE_SCANS TYPE STRING,
INTERNAL_FORMAT TYPE STRING,
REMARKS TYPE STRING,
INDEX_OBJECTID TYPE STRING,
NUMRIDS TYPE STRING,
NUMRIDS_DELETED TYPE STRING,
NUM_EMPTY_LEAFS TYPE STRING,
AVERAGE_RANDOM_FETCH_PAGES TYPE STRING,
AVERAGE_RANDOM_PAGES TYPE STRING,
AVERAGE_SEQUENCE_GAP TYPE STRING,
AVERAGE_SEQUENCE_FETCH_GAP TYPE STRING,
AVERAGE_SEQUENCE_PAGES TYPE STRING,
AVERAGE_SEQUENCE_FETCH_PAGES TYPE STRING,
TBSPACEID TYPE STRING,
PCTPAGESSAVED TYPE STRING,
COMPRESSION TYPE STRING,
INDCARD TYPE STRING,
AVGLEAFKEYSIZE TYPE STRING,
AVGNLEAFKEYSIZE TYPE STRING,
COLLECTSTATISTICS TYPE STRING,
LASTUSED TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
IDX_REORGCHK TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
TABSCHEMA TYPE STRING,
TABNAME TYPE STRING,
DATAPARTITIONNAME TYPE STRING,
INDSCHEMA TYPE STRING,
INDNAME TYPE STRING,
CARD TYPE STRING,
NLEAF TYPE STRING,
NUM_EMPTY_LEAFS TYPE STRING,
NLEVELS TYPE STRING,
ISIZE TYPE STRING,
NUMRIDS_DELETED TYPE STRING,
FULLKEYCARD TYPE STRING,
LEAF_RECSIZE TYPE STRING,
NONLEAF_RECSIZE TYPE STRING,
LEAF_PAGE_OVERHEAD TYPE STRING,
NONLEAF_PAGE_OVERHEAD TYPE STRING,
PCT_PAGES_SAVED TYPE STRING,
F4 TYPE STRING,
F5 TYPE STRING,
F6 TYPE STRING,
F7 TYPE STRING,
F8 TYPE STRING,
REORG TYPE STRING,
F4_ICON TYPE STRING,
F5_ICON TYPE STRING,
F6_ICON TYPE STRING,
F7_ICON TYPE STRING,
F8_ICON TYPE STRING,
UNIQUERULE TYPE STRING,
IDX_INFO TYPE STRING,
INDSCHEMA TYPE STRING,
INDNAME TYPE STRING,
TABSCHEMA TYPE STRING,
TABNAME TYPE STRING,
DBPARTITIONNUM TYPE STRING,
DATAPARTITIONID TYPE STRING,
COMPRESS_ATTR TYPE STRING,
INDEX_COMPRESSED TYPE STRING,
INDEX_PARTITIONING TYPE STRING,
INDEX_OBJECT_L_SIZE TYPE STRING,
INDEX_OBJECT_P_SIZE TYPE STRING,
INDEX_REQUIRES_REBUILD TYPE STRING,
LARGE_RIDS TYPE STRING,
IID TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
RECLAIMABLE_SPACE TYPE STRING,
IDX_COMPRESSION TYPE STRING,
INDSCHEMA TYPE STRING,
INDNAME TYPE STRING,
TABSCHEMA TYPE STRING,
TABNAME TYPE STRING,
DBPARTITIONNUM TYPE STRING,
DATAPARTITIONID TYPE STRING,
COMPRESS_ATTR TYPE STRING,
INDEX_COMPRESSED TYPE STRING,
PCT_PAGES_SAVED TYPE STRING,
NUM_LEAF_PAGES_SAVED TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
VALUE_COMPRESSION TYPE STRING,
ROW_COMPRESSION TYPE STRING,
HIDE_COUNT TYPE STRING,
TRUE_CARDINALITY TYPE STRING,
DELTA_CARDINALITY TYPE STRING,
POOL_LIKE TYPE STRING,
TAB_STATS_TIME TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
TAB_REORGCHK_TIME TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
REORG_TIME TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
REORG_RUNTIME TYPE STRING,
CB_DISTRIBUTION_STATISTICS TYPE STRING,
IDX_REORGCHK_TIME TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
DICT_BUILD_TIME TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
VOLATILE TYPE STRING,
TAB_REORGCHK_RESULT TYPE STRING,
IDX_REORGCHK_RESULT TYPE STRING,
TOTAL TYPE STRING,
TABLE_SIZE TYPE STRING,
INDEX_SIZE TYPE STRING,
INDEXES TYPE STRING,
COMPRESSION_STATUS TYPE STRING,
REORG_RESULT TYPE STRING,
SYSCAT_COMPRESSION_PCT TYPE STRING,
SYSCAT_COMPRESSION_ABS TYPE STRING,
TAB_COMPRESSION_PCT TYPE STRING,
TAB_COMPRESSION_ABS TYPE STRING,
DELTA_COMPRESSION_ABS TYPE STRING,
RUNSTATS_STATUS TYPE STRING,
AVGROWCOMPRESSIONPCT TYPE STRING,
DDL_STATEMENT TYPE STRING,
SAP_BUFFERED TYPE STRING,END OF T_EKKO_STR. DATA: WA_DB6_VIEW_TABLE_DETAIL_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_DB6_VIEW_TABLE_DETAIL_STR-IT_IDX_REORGCHK sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_IDX_INFO sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_IDX_COMPRESS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_IDX_COLUMNS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_TAB_COLUMNS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_TAB_INDEXES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_TAB_INFO sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_TAB_COMPRESS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_TAB_REORGCHK sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_TAB_DATAPARTITIONS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IT_TAB_COLDIST sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TAB_SYSCAT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DEFINER sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TYPE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-STATUS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-BASE_TABSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-BASE_TABNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ROWTYPESCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ROWTYPENAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CREATE_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-STATS_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COLCOUNT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABLEID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TBSPACEID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NPAGES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-FPAGES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-OVERFLOW sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TBSPACE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_TBSPACE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LONG_TBSPACE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PARENTS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CHILDREN sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SELFREFS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-KEYCOLUMNS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-KEYINDEXID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-KEYUNIQUE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CHECKCOUNT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATACAPTURE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CONST_CHECKED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PMAP_ID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PARTITION_MODE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LOG_ATTRIBUTE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PCTFREE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-APPEND_MODE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REFRESH sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REFRESH_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LOCKSIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-VOLATILE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REMARKS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ROW_FORMAT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PROPERTY sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-STATISTICS_PROFILE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COMPRESSION sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ACCESS_MODE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CLUSTERED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ACTIVE_BLOCKS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DROPRULE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-MAXFREESPACESEARCH sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVGCOMPRESSEDROWSIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVGROWCOMPRESSIONRATIO sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVGROWSIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PCTROWSCOMPRESSED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PCTPAGESSAVED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SNAPSHOT_TIMESTAMP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ROWCOMPMODE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABLEORG sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TAB_REORGCHK sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SNAPSHOT_TIMESTAMP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATAPARTITIONNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-OVERFLOW sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NPAGES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-FPAGES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ACTIVE_BLOCKS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TSIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F1 sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F2 sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F3 sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REORG sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F1_ICON sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F2_ICON sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F3_ICON sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TAB_INFO sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SNAPSHOT_TIMESTAMP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABTYPE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PARTITN sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATA_PARTITION_ID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVAILABLE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATA_OBJECT_L_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATA_OBJECT_P_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_OBJECT_L_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_OBJECT_P_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LONG_OBJECT_L_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LONG_OBJECT_P_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LOB_OBJECT_L_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LOB_OBJECT_P_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-XML_OBJECT_L_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-XML_OBJECT_P_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_TYPE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REORG_PENDING sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INPLACE_REORG_STATUS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LOAD_STATUS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-READ_ACCESS_ONLY sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NO_LOAD_RESTART sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NUM_REORG_REC_ALTERS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEXES_REQUIRE_REBUILD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LARGE_RIDS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LARGE_SLOTS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DICTIONARY_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-BLOCKS_PENDING_CLEANUP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-STATSTYPE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-XML_RECORD_TYPE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-RECLAIMABLE_SPACE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-XML_DICTIONARY_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AMT_STATUS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COL_OBJECT_L_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COL_OBJECT_P_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TAB_COMPRESSION sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PARTITN sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATA_PARTITION_ID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COMPRESS_ATTR sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DICT_BUILDER sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SAVED_PAGES_PCT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SAVED_BYTES_PCT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ROWS_TOO_SMALL_PCT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COMPRESSION_DICT_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-EXPANSION_DICT_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ROWS_SAMPLED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVG_COMPRESS_REC_LENGTH sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-OBJECT_TYPE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DICT_BUILD_TIMESTAMP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CHECK_TIMESTAMP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ROWCOMPMODE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PCTPAGESSAVED_ADAPTIVE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVGROWSIZE_ADAPTIVE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IDX_SYSCAT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DEFINER sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COLNAMES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-UNIQUERULE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-MADE_UNIQUE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COLCOUNT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-UNIQUE_COLCOUNT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEXTYPE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ENTRYTYPE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PCTFREE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NLEAF sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NLEVELS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-FIRSTKEYCARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-FIRST2KEYCARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-FIRST3KEYCARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-FIRST4KEYCARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-FULLKEYCARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CLUSTERRATIO sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CLUSTERFACTOR sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SEQUENTIAL_PAGES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DENSITY sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-USER_DEFINED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SYSTEM_REQUIRED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CREATE_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-STATS_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-MINPCTUSED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REVERSE_SCANS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INTERNAL_FORMAT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REMARKS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_OBJECTID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NUMRIDS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NUMRIDS_DELETED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NUM_EMPTY_LEAFS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVERAGE_RANDOM_FETCH_PAGES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVERAGE_RANDOM_PAGES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVERAGE_SEQUENCE_GAP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVERAGE_SEQUENCE_FETCH_GAP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVERAGE_SEQUENCE_PAGES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVERAGE_SEQUENCE_FETCH_PAGES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TBSPACEID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PCTPAGESSAVED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COMPRESSION sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDCARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVGLEAFKEYSIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVGNLEAFKEYSIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COLLECTSTATISTICS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LASTUSED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SNAPSHOT_TIMESTAMP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IDX_REORGCHK sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SNAPSHOT_TIMESTAMP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATAPARTITIONNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NLEAF sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NUM_EMPTY_LEAFS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NLEVELS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ISIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NUMRIDS_DELETED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-FULLKEYCARD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LEAF_RECSIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NONLEAF_RECSIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LEAF_PAGE_OVERHEAD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NONLEAF_PAGE_OVERHEAD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PCT_PAGES_SAVED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F4 sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F5 sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F6 sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F7 sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F8 sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REORG sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F4_ICON sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F5_ICON sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F6_ICON sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F7_ICON sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-F8_ICON sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-UNIQUERULE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IDX_INFO sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DBPARTITIONNUM sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATAPARTITIONID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COMPRESS_ATTR sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_COMPRESSED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_PARTITIONING sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_OBJECT_L_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_OBJECT_P_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_REQUIRES_REBUILD sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-LARGE_RIDS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SNAPSHOT_TIMESTAMP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-RECLAIMABLE_SPACE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IDX_COMPRESSION sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABSCHEMA sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABNAME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DBPARTITIONNUM sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATAPARTITIONID sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COMPRESS_ATTR sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_COMPRESSED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-PCT_PAGES_SAVED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-NUM_LEAF_PAGES_SAVED sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SNAPSHOT_TIMESTAMP sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-VALUE_COMPRESSION sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-ROW_COMPRESSION sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-HIDE_COUNT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TRUE_CARDINALITY sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DELTA_CARDINALITY sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-POOL_LIKE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TAB_STATS_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TAB_REORGCHK_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REORG_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REORG_RUNTIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-CB_DISTRIBUTION_STATISTICS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IDX_REORGCHK_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DICT_BUILD_TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DATE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TIME sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-VOLATILE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TAB_REORGCHK_RESULT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-IDX_REORGCHK_RESULT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TOTAL sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TABLE_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEX_SIZE sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-INDEXES sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-COMPRESSION_STATUS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-REORG_RESULT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SYSCAT_COMPRESSION_PCT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SYSCAT_COMPRESSION_ABS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TAB_COMPRESSION_PCT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-TAB_COMPRESSION_ABS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DELTA_COMPRESSION_ABS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-RUNSTATS_STATUS sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-AVGROWCOMPRESSIONPCT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-DDL_STATEMENT sy-vline
WA_DB6_VIEW_TABLE_DETAIL_STR-SAP_BUFFERED sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.