ABAP Select data from SAP table DB6_VIEW_APPLICATION_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_APPLICATION_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_APPLICATION_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_APPLICATION_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_APPLICATION_DETAIL TYPE STANDARD TABLE OF DB6_VIEW_APPLICATION_DETAIL,
WA_DB6_VIEW_APPLICATION_DETAIL TYPE DB6_VIEW_APPLICATION_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_APPLICATION_DETAIL> TYPE DB6_VIEW_APPLICATION_DETAIL.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_DB6_VIEW_APPLICATION_DETAIL.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM DB6_VIEW_APPLICATION_DETAIL
INTO TABLE IT_DB6_VIEW_APPLICATION_DETAIL.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM DB6_VIEW_APPLICATION_DETAIL
* INTO TABLE @DATA(IT_DB6_VIEW_APPLICATION_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_APPLICATION_DETAIL INDEX 1 INTO DATA(WA_DB6_VIEW_APPLICATION_DETAIL2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_DB6_VIEW_APPLICATION_DETAIL ASSIGNING <DB6_VIEW_APPLICATION_DETAIL>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<DB6_VIEW_APPLICATION_DETAIL>-ROW_SELECT = 1.
<DB6_VIEW_APPLICATION_DETAIL>-CURRENT = 1.
<DB6_VIEW_APPLICATION_DETAIL>-TOTAL = 1.
<DB6_VIEW_APPLICATION_DETAIL>-TABSSTMT = 1.
<DB6_VIEW_APPLICATION_DETAIL>-COMPTIME = 1.
ENDLOOP. LOOP AT IT_DB6_VIEW_APPLICATION_DETAIL INTO WA_DB6_VIEW_APPLICATION_DETAIL. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_DB6_VIEW_APPLICATION_DETAIL-PARTITN, sy-vline,
WA_DB6_VIEW_APPLICATION_DETAIL-DBMSTRTTME, sy-vline,
WA_DB6_VIEW_APPLICATION_DETAIL-AGENT_ID, sy-vline,
WA_DB6_VIEW_APPLICATION_DETAIL-STMT_TYPE, sy-vline,
WA_DB6_VIEW_APPLICATION_DETAIL-STMT_OPERA, sy-vline,
WA_DB6_VIEW_APPLICATION_DETAIL-RW_READ, sy-vline.
ENDLOOP. *Add any further fields from structure WA_DB6_VIEW_APPLICATION_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_APPLICATION_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_APPLICATION_DETAIL INTO WA_DB6_VIEW_APPLICATION_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_APPLICATION_DETAIL_STR,
ROW_SELECT TYPE STRING,
CURRENT TYPE STRING,
TOTAL TYPE STRING,
TABSSTMT TYPE STRING,
COMPTIME TYPE STRING,
PARTITN TYPE STRING,
DBMSTRTTME TYPE STRING,
AGENT_ID TYPE STRING,
STMT_TYPE TYPE STRING,
STMT_OPERA TYPE STRING,
RW_READ TYPE STRING,
RW_WRITTEN TYPE STRING,
STMT_LEN TYPE STRING,
STMT_TEXT TYPE STRING,
PL_TD_LRS TYPE STRING,
PL_TD_PRS TYPE STRING,
PL_TI_LRS TYPE STRING,
PL_TI_PRS TYPE STRING,
BLKCURSOR TYPE STRING,
STMTELAS TYPE STRING,
STMTELAMS TYPE STRING,
PL_D_LRS TYPE STRING,
PL_D_PRS TYPE STRING,
PL_I_LRS TYPE STRING,
PL_I_PRS TYPE STRING,
STMTSTRTDT TYPE STRING,
STMTSTRTTM TYPE STRING,
STMTSTOPDT TYPE STRING,
STMTSTOPTM TYPE STRING,
TOT_SRT_TM TYPE STRING,
STMT_SORTS TYPE STRING,
SRT_OF TYPE STRING,
TABSAPPL TYPE STRING,
COMPTIME TYPE STRING,
PARTITN TYPE STRING,
DBMSTRTTME TYPE STRING,
AUTH_ID TYPE STRING,
AGENT_ID TYPE STRING,
AGENT_PID TYPE STRING,
APPL_NAME TYPE STRING,
CLI_PID TYPE STRING,
CLI_HOST TYPE STRING,
CLI_PLATFO TYPE STRING,
AP_STATUS TYPE STRING,
BP_QAL TYPE STRING,
BP_AV_RTM TYPE STRING,
BP_AV_WTM TYPE STRING,
BP_D_HITRT TYPE STRING,
BP_I_HITRT TYPE STRING,
PL_D_LRS TYPE STRING,
PL_D_PRS TYPE STRING,
PL_D_WS TYPE STRING,
PL_I_LRS TYPE STRING,
PL_I_PRS TYPE STRING,
PL_I_WS TYPE STRING,
PL_RD_TM TYPE STRING,
PL_WT_TM TYPE STRING,
DIRCT_RDS TYPE STRING,
DIRCT_WTS TYPE STRING,
DIRCT_RTM TYPE STRING,
DIRCT_WTM TYPE STRING,
DIRCT_RRQS TYPE STRING,
DIRCT_WRQS TYPE STRING,
AV_DCT_RTM TYPE STRING,
AV_DCT_WTM TYPE STRING,
AV_DCT_RDS TYPE STRING,
AV_DCT_WTS TYPE STRING,
PL_D_TE TYPE STRING,
PL_D_FE TYPE STRING,
PL_I_TE TYPE STRING,
PL_I_FE TYPE STRING,
LCK_ESCALS TYPE STRING,
X_LCK_ESCA TYPE STRING,
LCK_WAITS TYPE STRING,
LCK_W_TM TYPE STRING,
AV_WTM_LCK TYPE STRING,
LCKS_HELD TYPE STRING,
DEADLOCKS TYPE STRING,
LCK_TMOUT TYPE STRING,
CMMT_SQLST TYPE STRING,
RBCK_SQLST TYPE STRING,
SELC_SQLST TYPE STRING,
UID_SQLST TYPE STRING,
DYN_SQLST TYPE STRING,
STC_SQLST TYPE STRING,
FAIL_SQLST TYPE STRING,
DDL_SQLST TYPE STRING,
RW_DELETED TYPE STRING,
RW_INSRTED TYPE STRING,
RW_SELECED TYPE STRING,
RW_UPDATED TYPE STRING,
TOT_SORTS TYPE STRING,
TOT_SRT_TM TYPE STRING,
AV_SORT_TM TYPE STRING,
SRT_OF TYPE STRING,
CATCA_QAL TYPE STRING,
PKG_CA_QAL TYPE STRING,
CATCA_LKU TYPE STRING,
CATCA_INS TYPE STRING,
CATCA_OF TYPE STRING,
CATCA_HPFL TYPE STRING,
PKG_CA_LKU TYPE STRING,
PKG_CA_INS TYPE STRING,
AP_CON_DT TYPE STRING,
AP_CON_TM TYPE STRING,
AP_IDLE_TM TYPE STRING,
PF_WTTM TYPE STRING,
AGT_UCP_S TYPE STRING,
AGT_SCT_S TYPE STRING,
CRD_AG_PID TYPE STRING,
NUM_ASS_AG TYPE STRING,
ASS_AGT_TP TYPE STRING,
AGT_STOLEN TYPE STRING,
UOW_STRTDT TYPE STRING,
UOW_STRTTM TYPE STRING,
UOW_STOPDT TYPE STRING,
UOW_STOPTM TYPE STRING,
UOW_LWTM TYPE STRING,
UOW_LGSPUD TYPE STRING,
PR_UOW_SDT TYPE STRING,
PR_UOW_STM TYPE STRING,
UOW_ELA_S TYPE STRING,
UOW_ELA_MS TYPE STRING,
UOW_CMPSTA TYPE STRING,
TOT_HAJN TYPE STRING,
TOT_HALOOP TYPE STRING,
HAJN_OF TYPE STRING,
HAJN_SM_OF TYPE STRING,
PL_TD_LRS TYPE STRING,
PL_TD_PRS TYPE STRING,
PL_TI_LRS TYPE STRING,
PL_TI_PRS TYPE STRING,
POOL_XDA_L_READS TYPE STRING,
POOL_XDA_P_READS TYPE STRING,
POOL_XDA_WRITES TYPE STRING,
PL_TEMP_XDA_L_RD TYPE STRING,
PL_TEMP_XDA_P_RD TYPE STRING,
ELPSD_EXC_TIM_MS TYPE STRING,
ELPSD_EXC_TIM_S TYPE STRING,
INACT_STMTHISTSZ TYPE STRING,
LOCK_TIMEOUT_VAL TYPE STRING,
PRV_WS_NUM_OVFL TYPE STRING,
PRV_WS_SCT_INSRT TYPE STRING,
PRV_WS_SCT_LKUP TYPE STRING,
PRV_WS_SIZE_TOP TYPE STRING,
SHR_WS_NUM_OVFL TYPE STRING,
SHR_WS_SCT_INSRT TYPE STRING,
SHR_WS_SCT_LKUP TYPE STRING,
SHR_WS_SIZE_TOP TYPE STRING,
SESSION_AUTH_ID TYPE STRING,
TPMON_ACC_STR TYPE STRING,
TPMON_CLIENT_APP TYPE STRING,
TPMON_CLIENT_UID TYPE STRING,
TPMON_CLIENT_WKS TYPE STRING,
AUTHORITY_LEVEL TYPE STRING,
OLAP_FUNC_OVERFLOWS TYPE STRING,
TOTAL_OLAP_FUNCS TYPE STRING,
WORKLOAD_ID TYPE STRING,
IS_SYSTEM_APPL TYPE STRING,
AGENT_PRIO TYPE STRING,
AGENT_PRIO_MAX TYPE STRING,
AGENT_PRIO_MIN TYPE STRING,
PREFETCH_PRIO TYPE STRING,
PREFETCH_PRIO_MAX TYPE STRING,
PREFETCH_PRIO_MIN 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,
BP_C_HITRT TYPE STRING,
MEMORY_POOLS TYPE STRING,
ASSIGNED_AGENTS TYPE STRING,END OF T_EKKO_STR. DATA: WA_DB6_VIEW_APPLICATION_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_APPLICATION_DETAIL_STR-ROW_SELECT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CURRENT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TOTAL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TABSSTMT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-COMPTIME sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PARTITN sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DBMSTRTTME sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AGENT_ID sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMT_TYPE sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMT_OPERA sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-RW_READ sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-RW_WRITTEN sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMT_LEN sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMT_TEXT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TD_LRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TD_PRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TI_LRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TI_PRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-BLKCURSOR sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMTELAS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMTELAMS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_D_LRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_D_PRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_I_LRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_I_PRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMTSTRTDT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMTSTRTTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMTSTOPDT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMTSTOPTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TOT_SRT_TM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STMT_SORTS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-SRT_OF sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TABSAPPL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-COMPTIME sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PARTITN sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DBMSTRTTME sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AUTH_ID sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AGENT_ID sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AGENT_PID sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-APPL_NAME sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CLI_PID sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CLI_HOST sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CLI_PLATFO sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AP_STATUS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-BP_QAL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-BP_AV_RTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-BP_AV_WTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-BP_D_HITRT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-BP_I_HITRT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_D_LRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_D_PRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_D_WS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_I_LRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_I_PRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_I_WS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_RD_TM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_WT_TM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DIRCT_RDS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DIRCT_WTS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DIRCT_RTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DIRCT_WTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DIRCT_RRQS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DIRCT_WRQS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AV_DCT_RTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AV_DCT_WTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AV_DCT_RDS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AV_DCT_WTS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_D_TE sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_D_FE sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_I_TE sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_I_FE sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-LCK_ESCALS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-X_LCK_ESCA sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-LCK_WAITS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-LCK_W_TM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AV_WTM_LCK sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-LCKS_HELD sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DEADLOCKS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-LCK_TMOUT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CMMT_SQLST sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-RBCK_SQLST sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-SELC_SQLST sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UID_SQLST sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DYN_SQLST sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-STC_SQLST sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-FAIL_SQLST sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-DDL_SQLST sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-RW_DELETED sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-RW_INSRTED sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-RW_SELECED sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-RW_UPDATED sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TOT_SORTS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TOT_SRT_TM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AV_SORT_TM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-SRT_OF sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CATCA_QAL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PKG_CA_QAL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CATCA_LKU sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CATCA_INS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CATCA_OF sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CATCA_HPFL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PKG_CA_LKU sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PKG_CA_INS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AP_CON_DT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AP_CON_TM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AP_IDLE_TM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PF_WTTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AGT_UCP_S sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AGT_SCT_S sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-CRD_AG_PID sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-NUM_ASS_AG sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-ASS_AGT_TP sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AGT_STOLEN sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UOW_STRTDT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UOW_STRTTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UOW_STOPDT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UOW_STOPTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UOW_LWTM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UOW_LGSPUD sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PR_UOW_SDT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PR_UOW_STM sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UOW_ELA_S sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UOW_ELA_MS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-UOW_CMPSTA sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TOT_HAJN sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TOT_HALOOP sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-HAJN_OF sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-HAJN_SM_OF sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TD_LRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TD_PRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TI_LRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TI_PRS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-POOL_XDA_L_READS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-POOL_XDA_P_READS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-POOL_XDA_WRITES sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TEMP_XDA_L_RD sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PL_TEMP_XDA_P_RD sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-ELPSD_EXC_TIM_MS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-ELPSD_EXC_TIM_S sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-INACT_STMTHISTSZ sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-LOCK_TIMEOUT_VAL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PRV_WS_NUM_OVFL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PRV_WS_SCT_INSRT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PRV_WS_SCT_LKUP sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PRV_WS_SIZE_TOP sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-SHR_WS_NUM_OVFL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-SHR_WS_SCT_INSRT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-SHR_WS_SCT_LKUP sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-SHR_WS_SIZE_TOP sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-SESSION_AUTH_ID sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TPMON_ACC_STR sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TPMON_CLIENT_APP sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TPMON_CLIENT_UID sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TPMON_CLIENT_WKS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AUTHORITY_LEVEL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-OLAP_FUNC_OVERFLOWS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-TOTAL_OLAP_FUNCS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-WORKLOAD_ID sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-IS_SYSTEM_APPL sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AGENT_PRIO sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AGENT_PRIO_MAX sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-AGENT_PRIO_MIN sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PREFETCH_PRIO sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PREFETCH_PRIO_MAX sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-PREFETCH_PRIO_MIN sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-POOL_COL_L_READS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-POOL_COL_P_READS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-POOL_TEMP_COL_L_READS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-POOL_TEMP_COL_P_READS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-POOL_COL_WRITES sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-BP_C_HITRT sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-MEMORY_POOLS sy-vline
WA_DB6_VIEW_APPLICATION_DETAIL_STR-ASSIGNED_AGENTS sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
