ABAP Select data from SAP table DB6_XCHG_PKGC 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_XCHG_PKGC 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_XCHG_PKGC. 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_XCHG_PKGC 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_XCHG_PKGC TYPE STANDARD TABLE OF DB6_XCHG_PKGC,
WA_DB6_XCHG_PKGC TYPE DB6_XCHG_PKGC,
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_XCHG_PKGC> TYPE DB6_XCHG_PKGC.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_DB6_XCHG_PKGC.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM DB6_XCHG_PKGC
INTO TABLE IT_DB6_XCHG_PKGC.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM DB6_XCHG_PKGC
* INTO TABLE @DATA(IT_DB6_XCHG_PKGC2).
*--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_XCHG_PKGC INDEX 1 INTO DATA(WA_DB6_XCHG_PKGC2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_DB6_XCHG_PKGC ASSIGNING <DB6_XCHG_PKGC>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<DB6_XCHG_PKGC>-WA_PKGC_STMT = 1.
<DB6_XCHG_PKGC>-MEMBER = 1.
<DB6_XCHG_PKGC>-SECTION_TYPE = 1.
<DB6_XCHG_PKGC>-INSERT_TIMESTAMP = 1.
<DB6_XCHG_PKGC>-EXECUTABLE_ID = 1.
ENDLOOP. LOOP AT IT_DB6_XCHG_PKGC INTO WA_DB6_XCHG_PKGC. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_DB6_XCHG_PKGC-PACKAGE_SCHEMA, sy-vline,
WA_DB6_XCHG_PKGC-PACKAGE_NAME, sy-vline,
WA_DB6_XCHG_PKGC-PACKAGE_VERSION_ID, sy-vline,
WA_DB6_XCHG_PKGC-SECTION_NUMBER, sy-vline,
WA_DB6_XCHG_PKGC-EFFECTIVE_ISOLATION, sy-vline,
WA_DB6_XCHG_PKGC-NUM_EXECUTIONS, sy-vline.
ENDLOOP. *Add any further fields from structure WA_DB6_XCHG_PKGC 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_XCHG_PKGC 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_XCHG_PKGC INTO WA_DB6_XCHG_PKGC. *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_XCHG_PKGC_STR,
WA_PKGC_STMT TYPE STRING,
MEMBER TYPE STRING,
SECTION_TYPE TYPE STRING,
INSERT_TIMESTAMP TYPE STRING,
EXECUTABLE_ID TYPE STRING,
PACKAGE_SCHEMA TYPE STRING,
PACKAGE_NAME TYPE STRING,
PACKAGE_VERSION_ID TYPE STRING,
SECTION_NUMBER TYPE STRING,
EFFECTIVE_ISOLATION TYPE STRING,
NUM_EXECUTIONS TYPE STRING,
NUM_EXEC_WITH_METRICS TYPE STRING,
PREP_TIME TYPE STRING,
TOTAL_ACT_TIME TYPE STRING,
TOTAL_ACT_WAIT_TIME TYPE STRING,
TOTAL_CPU_TIME TYPE STRING,
POOL_READ_TIME TYPE STRING,
POOL_WRITE_TIME TYPE STRING,
DIRECT_READ_TIME TYPE STRING,
DIRECT_WRITE_TIME TYPE STRING,
LOCK_WAIT_TIME TYPE STRING,
TOTAL_SECTION_SORT_TIME TYPE STRING,
TOTAL_SECTION_SORT_PROC_TIME TYPE STRING,
TOTAL_SECTION_SORTS TYPE STRING,
LOCK_ESCALS TYPE STRING,
LOCK_WAITS TYPE STRING,
ROWS_MODIFIED TYPE STRING,
ROWS_READ TYPE STRING,
ROWS_RETURNED TYPE STRING,
DIRECT_READS TYPE STRING,
DIRECT_READ_REQS TYPE STRING,
DIRECT_WRITES TYPE STRING,
DIRECT_WRITE_REQS TYPE STRING,
POOL_DATA_L_READS TYPE STRING,
POOL_TEMP_DATA_L_READS TYPE STRING,
POOL_XDA_L_READS TYPE STRING,
POOL_TEMP_XDA_L_READS TYPE STRING,
POOL_INDEX_L_READS TYPE STRING,
POOL_TEMP_INDEX_L_READS TYPE STRING,
POOL_DATA_P_READS TYPE STRING,
POOL_TEMP_DATA_P_READS TYPE STRING,
POOL_XDA_P_READS TYPE STRING,
POOL_TEMP_XDA_P_READS TYPE STRING,
POOL_INDEX_P_READS TYPE STRING,
POOL_TEMP_INDEX_P_READS TYPE STRING,
POOL_DATA_WRITES TYPE STRING,
POOL_XDA_WRITES TYPE STRING,
POOL_INDEX_WRITES TYPE STRING,
TOTAL_SORTS TYPE STRING,
POST_THRESHOLD_SORTS TYPE STRING,
POST_SHRTHRESHOLD_SORTS TYPE STRING,
SORT_OVERFLOWS TYPE STRING,
WLM_QUEUE_TIME_TOTAL TYPE STRING,
WLM_QUEUE_ASSIGNMENTS_TOTAL TYPE STRING,
DEADLOCKS TYPE STRING,
FCM_RECV_VOLUME TYPE STRING,
FCM_RECVS_TOTAL TYPE STRING,
FCM_SEND_VOLUME TYPE STRING,
FCM_SENDS_TOTAL TYPE STRING,
FCM_RECV_WAIT_TIME TYPE STRING,
FCM_SEND_WAIT_TIME TYPE STRING,
LOCK_TIMEOUTS TYPE STRING,
LOG_BUFFER_WAIT_TIME TYPE STRING,
NUM_LOG_BUFFER_FULL TYPE STRING,
LOG_DISK_WAIT_TIME TYPE STRING,
LOG_DISK_WAITS_TOTAL TYPE STRING,
LAST_METRICS_UPDATE TYPE STRING,
NUM_COORD_EXEC TYPE STRING,
NUM_COORD_EXEC_WITH_METRICS TYPE STRING,
VALID TYPE STRING,
TOTAL_ROUTINE_TIME TYPE STRING,
TOTAL_ROUTINE_INVOCATIONS TYPE STRING,
ROUTINE_ID TYPE STRING,
STMT_TYPE_ID TYPE STRING,
QUERY_COST_ESTIMATE TYPE STRING,
STMT_PKG_CACHE_ID TYPE STRING,
COORD_STMT_EXEC_TIME TYPE STRING,
STMT_EXEC_TIME TYPE STRING,
TOTAL_SECTION_TIME TYPE STRING,
TOTAL_SECTION_PROC_TIME TYPE STRING,
TOTAL_ROUTINE_NON_SECT_TIME TYPE STRING,
TOTAL_ROUTINE_NON_SECT_PROC_TI TYPE STRING,
AVG_COORD_STMT_EXEC_TIME TYPE STRING,
ROWS_READ_PER_ROWS_PROCESSED TYPE STRING,
BP_GETS_PER_ROWS_PROCESSED TYPE STRING,
POOL_QUALITY TYPE STRING,
COORD_MEMBER TYPE STRING,
MEMBER_COUNT TYPE STRING,
PREFETCH_WAITS TYPE STRING,
PREFETCH_WAIT_TIME TYPE STRING,
PL_QUED_ASYNC_DATA_PAGES TYPE STRING,
PL_QUED_ASYNC_DATA_REQS TYPE STRING,
PL_QUED_ASYNC_INDEX_PAGES TYPE STRING,
PL_QUED_ASYNC_INDEX_REQS TYPE STRING,
PL_QUED_ASYNC_OTHER_REQS TYPE STRING,
PL_QUED_ASYNC_TEMP_DATA_PAGES TYPE STRING,
PL_QUED_ASYNC_TEMP_DATA_REQS TYPE STRING,
PL_QUED_ASYNC_TEMP_INDEX_PAGES TYPE STRING,
PL_QUED_ASYNC_TEMP_INDEX_REQS TYPE STRING,
PL_QUED_ASYNC_TEMP_XDA_PAGES TYPE STRING,
PL_QUED_ASYNC_TEMP_XDA_REQS TYPE STRING,
PL_QUED_ASYNC_XDA_PAGES TYPE STRING,
PL_QUED_ASYNC_XDA_REQS TYPE STRING,
PL_FAILED_ASYNC_DATA_REQS TYPE STRING,
PL_FAILED_ASYNC_INDEX_REQS TYPE STRING,
PL_FAILED_ASYNC_OTHER_REQS TYPE STRING,
PL_FAILED_ASYNC_TEMP_DATA_REQS TYPE STRING,
PL_FAILED_ASYNC_TEMP_INDEX_REQ TYPE STRING,
PL_FAILED_ASYNC_TEMP_XDA_REQS TYPE STRING,
PL_FAILED_ASYNC_XDA_REQS TYPE STRING,
POOL_COL_L_READS TYPE STRING,
POOL_COL_P_READS TYPE STRING,
POOL_TEMP_COL_L_READS TYPE STRING,
POOL_TEMP_COL_P_READS TYPE STRING,
POOL_COL_WRITES TYPE STRING,
PL_QUED_ASYNC_COL_PAGES TYPE STRING,
PL_QUED_ASYNC_COL_REQS TYPE STRING,
PL_QUED_ASYNC_TEMP_COL_PAGES TYPE STRING,
PL_QUED_ASYNC_TEMP_COL_REQS TYPE STRING,
PL_FAILED_ASYNC_COL_REQS TYPE STRING,
PL_FAILED_ASYNC_TEMP_COL_REQS TYPE STRING,
PL_D_GBP_INDEP_PAGES_FND_LBP TYPE STRING,
PL_D_GBP_INVALID_PAGES TYPE STRING,
PL_D_GBP_L_READS TYPE STRING,
PL_D_GBP_P_READS TYPE STRING,
PL_D_LBP_PAGES_FOUND TYPE STRING,
PL_I_GBP_INDEP_PAGES_FND_LBP TYPE STRING,
PL_I_GBP_INVALID_PAGES TYPE STRING,
PL_I_GBP_L_READS TYPE STRING,
PL_I_GBP_P_READS TYPE STRING,
PL_I_LBP_PAGES_FOUND TYPE STRING,
PL_X_GBP_INDEP_PAGES_FND_LBP TYPE STRING,
PL_X_GBP_INVALID_PAGES TYPE STRING,
PL_X_GBP_L_READS TYPE STRING,
PL_X_GBP_P_READS TYPE STRING,
PL_X_LBP_PAGES_FOUND TYPE STRING,
PL_C_GBP_INDEP_PAGES_FND_LBP TYPE STRING,
PL_C_GBP_INVALID_PAGES TYPE STRING,
PL_C_GBP_L_READS TYPE STRING,
PL_C_GBP_P_READS TYPE STRING,
PL_C_LBP_PAGES_FOUND TYPE STRING,
LBP_GBP_DEP_HIT_RATIO TYPE STRING,
LBP_GBP_IND_HIT_RATIO TYPE STRING,
GBP_HIT_RATIO TYPE STRING,
D_LBP_GBP_DEP_HIT_RATIO TYPE STRING,
D_LBP_GBP_IND_HIT_RATIO TYPE STRING,
D_GBP_HIT_RATIO TYPE STRING,
I_LBP_GBP_DEP_HIT_RATIO TYPE STRING,
I_LBP_GBP_IND_HIT_RATIO TYPE STRING,
I_GBP_HIT_RATIO TYPE STRING,
X_LBP_GBP_DEP_HIT_RATIO TYPE STRING,
X_LBP_GBP_IND_HIT_RATIO TYPE STRING,
X_GBP_HIT_RATIO TYPE STRING,
C_LBP_GBP_DEP_HIT_RATIO TYPE STRING,
C_LBP_GBP_IND_HIT_RATIO TYPE STRING,
C_GBP_HIT_RATIO TYPE STRING,
LOCK_WAITS_GLOBAL TYPE STRING,
LOCK_WAIT_TIME_GLOBAL TYPE STRING,
LOCK_TIMEOUTS_GLOBAL TYPE STRING,
LOCK_ESCALS_MAXLOCKS TYPE STRING,
LOCK_ESCALS_LOCKLIST TYPE STRING,
LOCK_ESCALS_GLOBAL TYPE STRING,
RECLAIM_WAIT_TIME TYPE STRING,
SPACEMAPPAGE_RECLAIM_WAIT_TIME TYPE STRING,
TOTAL_RECLAIM_WAIT_TIME TYPE STRING,
CF_WAITS TYPE STRING,
CF_WAIT_TIME TYPE STRING,
TOTAL_EXTENDED_LATCH_WAIT_TIME TYPE STRING,
TOTAL_EXTENDED_LATCH_WAITS TYPE STRING,
STMTNO TYPE STRING,
NUM_ROUTINES TYPE STRING,
ROWS_DELETED TYPE STRING,
ROWS_INSERTED TYPE STRING,
ROWS_UPDATED TYPE STRING,
TOTAL_HASH_JOINS TYPE STRING,
TOTAL_HASH_LOOPS TYPE STRING,
HASH_JOIN_OVERFLOWS TYPE STRING,
HASH_JOIN_SMALL_OVERFLOWS TYPE STRING,
POST_SHRTHRESHOLD_HASH_JOINS TYPE STRING,
TOTAL_OLAP_FUNCS TYPE STRING,
OLAP_FUNC_OVERFLOWS TYPE STRING,
INT_ROWS_DELETED TYPE STRING,
INT_ROWS_INSERTED TYPE STRING,
INT_ROWS_UPDATED TYPE STRING,
TOTAL_COL_TIME TYPE STRING,
TOTAL_COL_PROC_TIME TYPE STRING,
TOTAL_COL_EXECUTIONS TYPE STRING,
COMM_EXIT_WAIT_TIME TYPE STRING,
COMM_EXIT_WAITS TYPE STRING,
POST_THRESHOLD_HASH_JOINS TYPE STRING,
TOTAL_HASH_GRPBYS TYPE STRING,
HASH_GRPBY_OVERFLOWS TYPE STRING,
POST_THRESHOLD_HASH_GRPBYS TYPE STRING,
POST_THRESHOLD_OLAP_FUNCS TYPE STRING,
SEMANTIC_ENV_ID TYPE STRING,
STMTID TYPE STRING,
PLANID TYPE STRING,
PREP_WARNING TYPE STRING,
PREP_WARNING_REASON TYPE STRING,
POST_THR_COL_VECT_CONSUMERS TYPE STRING,
TOTAL_COL_VECTOR_CONSUMERS TYPE STRING,
ACTIVE_HASH_GRPBYS_TOP TYPE STRING,
ACTIVE_HASH_JOINS_TOP TYPE STRING,
ACTIVE_OLAP_FUNCS_TOP TYPE STRING,
ACTIVE_PEAS_TOP TYPE STRING,
ACTIVE_PEDS_TOP TYPE STRING,
ACTIVE_SORT_CONSUMERS_TOP TYPE STRING,
ACTIVE_SORTS_TOP TYPE STRING,
ACTIVE_COL_VECT_CONSUMERS_TOP TYPE STRING,
SORT_CONSUMER_HEAP_TOP TYPE STRING,
SORT_CONSUMER_SHRHEAP_TOP TYPE STRING,
SORT_HEAP_TOP TYPE STRING,
SORT_SHRHEAP_TOP TYPE STRING,
TOTAL_INDEX_BUILD_TIME TYPE STRING,
TOTAL_INDEX_BUILD_PROC_TIME TYPE STRING,
TOTAL_INDEXES_BUILT TYPE STRING,
COL_SYNOPSIS_ROWS_INSERTED TYPE STRING,
COL_VECTOR_CONSUMER_OVERFLOWS TYPE STRING,
LOB_PREFETCH_REQS TYPE STRING,
LOB_PREFETCH_WAIT_TIME TYPE STRING,
TOTAL_COL_SYNOPSIS_EXECUTIONS TYPE STRING,
TOTAL_COL_SYNOPSIS_PROC_TIME TYPE STRING,
TOTAL_COL_SYNOPSIS_TIME TYPE STRING,
STMT_COMMENTS TYPE STRING,
AGENTS_TOP TYPE STRING,
LAST_EXEC_ERROR TYPE STRING,
LAST_EXEC_WARNING TYPE STRING,
LAST_EXEC_ERROR_SQLERRMC TYPE STRING,
LAST_EXEC_WARNING_SQLERRMC TYPE STRING,
LAST_EXEC_ERROR_TIMESTAMP TYPE STRING,
LAST_EXEC_WARNING_TIMESTAMP TYPE STRING,
NUM_EXEC_WITH_ERROR TYPE STRING,
NUM_EXEC_WITH_WARNING TYPE STRING,
STMT_TEXT TYPE STRING,
COLOR TYPE STRING,
MEMBER_IMAGE TYPE STRING,
SHORT_STMT_TEXT TYPE STRING,
STMT_HASH_VALUE TYPE STRING,
COMP_ENV_DESC TYPE STRING,
COORD_MEMBER_IMAGE TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
TIMESTAMP_FROM TYPE STRING,
TIMESTAMP_TO TYPE STRING,
TIME_PERIOD TYPE STRING,
EXPLAIN_VERSION TYPE STRING,
EXPLAIN_TIME TYPE STRING,
REMOVED_DETECTION_TIMESTAMP TYPE STRING,
CURR_TOPNMETRIC TYPE STRING,
CURR_MEMBER_SELECTION TYPE STRING,
SELECTED_MEMBER TYPE STRING,
MULTI_SELECTION TYPE STRING,
SELECTED_GROUP TYPE STRING,
CURR_TIMEFRAME_SELECTION TYPE STRING,
FROM_DATE TYPE STRING,
FROM_TIME TYPE STRING,
TO_DATE TYPE STRING,
TO_TIME TYPE STRING,
TIME_FRAME TYPE STRING,
RANGETYPE TYPE STRING,
TIME_ZONE TYPE STRING,
GRANULARITY TYPE STRING,
TIME_RANGE_READONLY TYPE STRING,
TIME_RANGE_HIDDEN TYPE STRING,
TIME_RANGE_DESCR TYPE STRING,
CONFIRM_ENABLED TYPE STRING,
GRANULARITY_ENABLED TYPE STRING,
AGGREGATE TYPE STRING,
SECTIONS_TAB TYPE STRING,END OF T_EKKO_STR. DATA: WA_DB6_XCHG_PKGC_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_XCHG_PKGC_STR-WA_PKGC_STMT sy-vline
WA_DB6_XCHG_PKGC_STR-MEMBER sy-vline
WA_DB6_XCHG_PKGC_STR-SECTION_TYPE sy-vline
WA_DB6_XCHG_PKGC_STR-INSERT_TIMESTAMP sy-vline
WA_DB6_XCHG_PKGC_STR-EXECUTABLE_ID sy-vline
WA_DB6_XCHG_PKGC_STR-PACKAGE_SCHEMA sy-vline
WA_DB6_XCHG_PKGC_STR-PACKAGE_NAME sy-vline
WA_DB6_XCHG_PKGC_STR-PACKAGE_VERSION_ID sy-vline
WA_DB6_XCHG_PKGC_STR-SECTION_NUMBER sy-vline
WA_DB6_XCHG_PKGC_STR-EFFECTIVE_ISOLATION sy-vline
WA_DB6_XCHG_PKGC_STR-NUM_EXECUTIONS sy-vline
WA_DB6_XCHG_PKGC_STR-NUM_EXEC_WITH_METRICS sy-vline
WA_DB6_XCHG_PKGC_STR-PREP_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_ACT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_ACT_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_CPU_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_READ_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_WRITE_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-DIRECT_READ_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-DIRECT_WRITE_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_SECTION_SORT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_SECTION_SORT_PROC_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_SECTION_SORTS sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_ESCALS sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_WAITS sy-vline
WA_DB6_XCHG_PKGC_STR-ROWS_MODIFIED sy-vline
WA_DB6_XCHG_PKGC_STR-ROWS_READ sy-vline
WA_DB6_XCHG_PKGC_STR-ROWS_RETURNED sy-vline
WA_DB6_XCHG_PKGC_STR-DIRECT_READS sy-vline
WA_DB6_XCHG_PKGC_STR-DIRECT_READ_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-DIRECT_WRITES sy-vline
WA_DB6_XCHG_PKGC_STR-DIRECT_WRITE_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_DATA_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_TEMP_DATA_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_XDA_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_TEMP_XDA_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_INDEX_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_TEMP_INDEX_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_DATA_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_TEMP_DATA_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_XDA_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_TEMP_XDA_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_INDEX_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_TEMP_INDEX_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_DATA_WRITES sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_XDA_WRITES sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_INDEX_WRITES sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_SORTS sy-vline
WA_DB6_XCHG_PKGC_STR-POST_THRESHOLD_SORTS sy-vline
WA_DB6_XCHG_PKGC_STR-POST_SHRTHRESHOLD_SORTS sy-vline
WA_DB6_XCHG_PKGC_STR-SORT_OVERFLOWS sy-vline
WA_DB6_XCHG_PKGC_STR-WLM_QUEUE_TIME_TOTAL sy-vline
WA_DB6_XCHG_PKGC_STR-WLM_QUEUE_ASSIGNMENTS_TOTAL sy-vline
WA_DB6_XCHG_PKGC_STR-DEADLOCKS sy-vline
WA_DB6_XCHG_PKGC_STR-FCM_RECV_VOLUME sy-vline
WA_DB6_XCHG_PKGC_STR-FCM_RECVS_TOTAL sy-vline
WA_DB6_XCHG_PKGC_STR-FCM_SEND_VOLUME sy-vline
WA_DB6_XCHG_PKGC_STR-FCM_SENDS_TOTAL sy-vline
WA_DB6_XCHG_PKGC_STR-FCM_RECV_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-FCM_SEND_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_TIMEOUTS sy-vline
WA_DB6_XCHG_PKGC_STR-LOG_BUFFER_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-NUM_LOG_BUFFER_FULL sy-vline
WA_DB6_XCHG_PKGC_STR-LOG_DISK_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-LOG_DISK_WAITS_TOTAL sy-vline
WA_DB6_XCHG_PKGC_STR-LAST_METRICS_UPDATE sy-vline
WA_DB6_XCHG_PKGC_STR-NUM_COORD_EXEC sy-vline
WA_DB6_XCHG_PKGC_STR-NUM_COORD_EXEC_WITH_METRICS sy-vline
WA_DB6_XCHG_PKGC_STR-VALID sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_ROUTINE_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_ROUTINE_INVOCATIONS sy-vline
WA_DB6_XCHG_PKGC_STR-ROUTINE_ID sy-vline
WA_DB6_XCHG_PKGC_STR-STMT_TYPE_ID sy-vline
WA_DB6_XCHG_PKGC_STR-QUERY_COST_ESTIMATE sy-vline
WA_DB6_XCHG_PKGC_STR-STMT_PKG_CACHE_ID sy-vline
WA_DB6_XCHG_PKGC_STR-COORD_STMT_EXEC_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-STMT_EXEC_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_SECTION_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_SECTION_PROC_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_ROUTINE_NON_SECT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_ROUTINE_NON_SECT_PROC_TI sy-vline
WA_DB6_XCHG_PKGC_STR-AVG_COORD_STMT_EXEC_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-ROWS_READ_PER_ROWS_PROCESSED sy-vline
WA_DB6_XCHG_PKGC_STR-BP_GETS_PER_ROWS_PROCESSED sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_QUALITY sy-vline
WA_DB6_XCHG_PKGC_STR-COORD_MEMBER sy-vline
WA_DB6_XCHG_PKGC_STR-MEMBER_COUNT sy-vline
WA_DB6_XCHG_PKGC_STR-PREFETCH_WAITS sy-vline
WA_DB6_XCHG_PKGC_STR-PREFETCH_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_DATA_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_DATA_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_INDEX_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_INDEX_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_OTHER_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_TEMP_DATA_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_TEMP_DATA_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_TEMP_INDEX_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_TEMP_INDEX_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_TEMP_XDA_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_TEMP_XDA_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_XDA_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_XDA_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_FAILED_ASYNC_DATA_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_FAILED_ASYNC_INDEX_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_FAILED_ASYNC_OTHER_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_FAILED_ASYNC_TEMP_DATA_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_FAILED_ASYNC_TEMP_INDEX_REQ sy-vline
WA_DB6_XCHG_PKGC_STR-PL_FAILED_ASYNC_TEMP_XDA_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_FAILED_ASYNC_XDA_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_COL_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_COL_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_TEMP_COL_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_TEMP_COL_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-POOL_COL_WRITES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_COL_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_COL_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_TEMP_COL_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_QUED_ASYNC_TEMP_COL_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_FAILED_ASYNC_COL_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_FAILED_ASYNC_TEMP_COL_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_D_GBP_INDEP_PAGES_FND_LBP sy-vline
WA_DB6_XCHG_PKGC_STR-PL_D_GBP_INVALID_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_D_GBP_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_D_GBP_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_D_LBP_PAGES_FOUND sy-vline
WA_DB6_XCHG_PKGC_STR-PL_I_GBP_INDEP_PAGES_FND_LBP sy-vline
WA_DB6_XCHG_PKGC_STR-PL_I_GBP_INVALID_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_I_GBP_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_I_GBP_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_I_LBP_PAGES_FOUND sy-vline
WA_DB6_XCHG_PKGC_STR-PL_X_GBP_INDEP_PAGES_FND_LBP sy-vline
WA_DB6_XCHG_PKGC_STR-PL_X_GBP_INVALID_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_X_GBP_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_X_GBP_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_X_LBP_PAGES_FOUND sy-vline
WA_DB6_XCHG_PKGC_STR-PL_C_GBP_INDEP_PAGES_FND_LBP sy-vline
WA_DB6_XCHG_PKGC_STR-PL_C_GBP_INVALID_PAGES sy-vline
WA_DB6_XCHG_PKGC_STR-PL_C_GBP_L_READS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_C_GBP_P_READS sy-vline
WA_DB6_XCHG_PKGC_STR-PL_C_LBP_PAGES_FOUND sy-vline
WA_DB6_XCHG_PKGC_STR-LBP_GBP_DEP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-LBP_GBP_IND_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-GBP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-D_LBP_GBP_DEP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-D_LBP_GBP_IND_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-D_GBP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-I_LBP_GBP_DEP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-I_LBP_GBP_IND_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-I_GBP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-X_LBP_GBP_DEP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-X_LBP_GBP_IND_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-X_GBP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-C_LBP_GBP_DEP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-C_LBP_GBP_IND_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-C_GBP_HIT_RATIO sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_WAITS_GLOBAL sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_WAIT_TIME_GLOBAL sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_TIMEOUTS_GLOBAL sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_ESCALS_MAXLOCKS sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_ESCALS_LOCKLIST sy-vline
WA_DB6_XCHG_PKGC_STR-LOCK_ESCALS_GLOBAL sy-vline
WA_DB6_XCHG_PKGC_STR-RECLAIM_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-SPACEMAPPAGE_RECLAIM_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_RECLAIM_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-CF_WAITS sy-vline
WA_DB6_XCHG_PKGC_STR-CF_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_EXTENDED_LATCH_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_EXTENDED_LATCH_WAITS sy-vline
WA_DB6_XCHG_PKGC_STR-STMTNO sy-vline
WA_DB6_XCHG_PKGC_STR-NUM_ROUTINES sy-vline
WA_DB6_XCHG_PKGC_STR-ROWS_DELETED sy-vline
WA_DB6_XCHG_PKGC_STR-ROWS_INSERTED sy-vline
WA_DB6_XCHG_PKGC_STR-ROWS_UPDATED sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_HASH_JOINS sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_HASH_LOOPS sy-vline
WA_DB6_XCHG_PKGC_STR-HASH_JOIN_OVERFLOWS sy-vline
WA_DB6_XCHG_PKGC_STR-HASH_JOIN_SMALL_OVERFLOWS sy-vline
WA_DB6_XCHG_PKGC_STR-POST_SHRTHRESHOLD_HASH_JOINS sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_OLAP_FUNCS sy-vline
WA_DB6_XCHG_PKGC_STR-OLAP_FUNC_OVERFLOWS sy-vline
WA_DB6_XCHG_PKGC_STR-INT_ROWS_DELETED sy-vline
WA_DB6_XCHG_PKGC_STR-INT_ROWS_INSERTED sy-vline
WA_DB6_XCHG_PKGC_STR-INT_ROWS_UPDATED sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_COL_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_COL_PROC_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_COL_EXECUTIONS sy-vline
WA_DB6_XCHG_PKGC_STR-COMM_EXIT_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-COMM_EXIT_WAITS sy-vline
WA_DB6_XCHG_PKGC_STR-POST_THRESHOLD_HASH_JOINS sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_HASH_GRPBYS sy-vline
WA_DB6_XCHG_PKGC_STR-HASH_GRPBY_OVERFLOWS sy-vline
WA_DB6_XCHG_PKGC_STR-POST_THRESHOLD_HASH_GRPBYS sy-vline
WA_DB6_XCHG_PKGC_STR-POST_THRESHOLD_OLAP_FUNCS sy-vline
WA_DB6_XCHG_PKGC_STR-SEMANTIC_ENV_ID sy-vline
WA_DB6_XCHG_PKGC_STR-STMTID sy-vline
WA_DB6_XCHG_PKGC_STR-PLANID sy-vline
WA_DB6_XCHG_PKGC_STR-PREP_WARNING sy-vline
WA_DB6_XCHG_PKGC_STR-PREP_WARNING_REASON sy-vline
WA_DB6_XCHG_PKGC_STR-POST_THR_COL_VECT_CONSUMERS sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_COL_VECTOR_CONSUMERS sy-vline
WA_DB6_XCHG_PKGC_STR-ACTIVE_HASH_GRPBYS_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-ACTIVE_HASH_JOINS_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-ACTIVE_OLAP_FUNCS_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-ACTIVE_PEAS_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-ACTIVE_PEDS_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-ACTIVE_SORT_CONSUMERS_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-ACTIVE_SORTS_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-ACTIVE_COL_VECT_CONSUMERS_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-SORT_CONSUMER_HEAP_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-SORT_CONSUMER_SHRHEAP_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-SORT_HEAP_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-SORT_SHRHEAP_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_INDEX_BUILD_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_INDEX_BUILD_PROC_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_INDEXES_BUILT sy-vline
WA_DB6_XCHG_PKGC_STR-COL_SYNOPSIS_ROWS_INSERTED sy-vline
WA_DB6_XCHG_PKGC_STR-COL_VECTOR_CONSUMER_OVERFLOWS sy-vline
WA_DB6_XCHG_PKGC_STR-LOB_PREFETCH_REQS sy-vline
WA_DB6_XCHG_PKGC_STR-LOB_PREFETCH_WAIT_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_COL_SYNOPSIS_EXECUTIONS sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_COL_SYNOPSIS_PROC_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TOTAL_COL_SYNOPSIS_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-STMT_COMMENTS sy-vline
WA_DB6_XCHG_PKGC_STR-AGENTS_TOP sy-vline
WA_DB6_XCHG_PKGC_STR-LAST_EXEC_ERROR sy-vline
WA_DB6_XCHG_PKGC_STR-LAST_EXEC_WARNING sy-vline
WA_DB6_XCHG_PKGC_STR-LAST_EXEC_ERROR_SQLERRMC sy-vline
WA_DB6_XCHG_PKGC_STR-LAST_EXEC_WARNING_SQLERRMC sy-vline
WA_DB6_XCHG_PKGC_STR-LAST_EXEC_ERROR_TIMESTAMP sy-vline
WA_DB6_XCHG_PKGC_STR-LAST_EXEC_WARNING_TIMESTAMP sy-vline
WA_DB6_XCHG_PKGC_STR-NUM_EXEC_WITH_ERROR sy-vline
WA_DB6_XCHG_PKGC_STR-NUM_EXEC_WITH_WARNING sy-vline
WA_DB6_XCHG_PKGC_STR-STMT_TEXT sy-vline
WA_DB6_XCHG_PKGC_STR-COLOR sy-vline
WA_DB6_XCHG_PKGC_STR-MEMBER_IMAGE sy-vline
WA_DB6_XCHG_PKGC_STR-SHORT_STMT_TEXT sy-vline
WA_DB6_XCHG_PKGC_STR-STMT_HASH_VALUE sy-vline
WA_DB6_XCHG_PKGC_STR-COMP_ENV_DESC sy-vline
WA_DB6_XCHG_PKGC_STR-COORD_MEMBER_IMAGE sy-vline
WA_DB6_XCHG_PKGC_STR-SNAPSHOT_TIMESTAMP sy-vline
WA_DB6_XCHG_PKGC_STR-TIMESTAMP_FROM sy-vline
WA_DB6_XCHG_PKGC_STR-TIMESTAMP_TO sy-vline
WA_DB6_XCHG_PKGC_STR-TIME_PERIOD sy-vline
WA_DB6_XCHG_PKGC_STR-EXPLAIN_VERSION sy-vline
WA_DB6_XCHG_PKGC_STR-EXPLAIN_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-REMOVED_DETECTION_TIMESTAMP sy-vline
WA_DB6_XCHG_PKGC_STR-CURR_TOPNMETRIC sy-vline
WA_DB6_XCHG_PKGC_STR-CURR_MEMBER_SELECTION sy-vline
WA_DB6_XCHG_PKGC_STR-SELECTED_MEMBER sy-vline
WA_DB6_XCHG_PKGC_STR-MULTI_SELECTION sy-vline
WA_DB6_XCHG_PKGC_STR-SELECTED_GROUP sy-vline
WA_DB6_XCHG_PKGC_STR-CURR_TIMEFRAME_SELECTION sy-vline
WA_DB6_XCHG_PKGC_STR-FROM_DATE sy-vline
WA_DB6_XCHG_PKGC_STR-FROM_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TO_DATE sy-vline
WA_DB6_XCHG_PKGC_STR-TO_TIME sy-vline
WA_DB6_XCHG_PKGC_STR-TIME_FRAME sy-vline
WA_DB6_XCHG_PKGC_STR-RANGETYPE sy-vline
WA_DB6_XCHG_PKGC_STR-TIME_ZONE sy-vline
WA_DB6_XCHG_PKGC_STR-GRANULARITY sy-vline
WA_DB6_XCHG_PKGC_STR-TIME_RANGE_READONLY sy-vline
WA_DB6_XCHG_PKGC_STR-TIME_RANGE_HIDDEN sy-vline
WA_DB6_XCHG_PKGC_STR-TIME_RANGE_DESCR sy-vline
WA_DB6_XCHG_PKGC_STR-CONFIRM_ENABLED sy-vline
WA_DB6_XCHG_PKGC_STR-GRANULARITY_ENABLED sy-vline
WA_DB6_XCHG_PKGC_STR-AGGREGATE sy-vline
WA_DB6_XCHG_PKGC_STR-SECTIONS_TAB sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
