ABAP Select data from SAP table /SDF/DB6_700_DB6PMSD 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 /SDF/DB6_700_DB6PMSD 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 /SDF/DB6_700_DB6PMSD. 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 /SDF/DB6_700_DB6PMSD 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_/SDF/DB6_700_DB6PMSD TYPE STANDARD TABLE OF /SDF/DB6_700_DB6PMSD,
WA_/SDF/DB6_700_DB6PMSD TYPE /SDF/DB6_700_DB6PMSD,
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: </SDF/DB6_700_DB6PMSD> TYPE /SDF/DB6_700_DB6PMSD.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_/SDF/DB6_700_DB6PMSD.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM /SDF/DB6_700_DB6PMSD
INTO TABLE IT_/SDF/DB6_700_DB6PMSD.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM /SDF/DB6_700_DB6PMSD
* INTO TABLE @DATA(IT_/SDF/DB6_700_DB6PMSD2).
*--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_/SDF/DB6_700_DB6PMSD INDEX 1 INTO DATA(WA_/SDF/DB6_700_DB6PMSD2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SDF/DB6_700_DB6PMSD ASSIGNING </SDF/DB6_700_DB6PMSD>.
*To update a field value using a field symbol simply change the value via the field symbol pointer</SDF/DB6_700_DB6PMSD>-COMPTIME = 1.
</SDF/DB6_700_DB6PMSD>-PARTITN = 1.
</SDF/DB6_700_DB6PMSD>-CALLERFLAG = 1.
</SDF/DB6_700_DB6PMSD>-DBMSTRTTME = 1.
</SDF/DB6_700_DB6PMSD>-PRGVERS = 1.
ENDLOOP. LOOP AT IT_/SDF/DB6_700_DB6PMSD INTO WA_/SDF/DB6_700_DB6PMSD. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_/SDF/DB6_700_DB6PMSD-IN_DB_ALIA, sy-vline,
WA_/SDF/DB6_700_DB6PMSD-DB_NAME, sy-vline,
WA_/SDF/DB6_700_DB6PMSD-DB_PATH, sy-vline,
WA_/SDF/DB6_700_DB6PMSD-LCKS_HELD, sy-vline,
WA_/SDF/DB6_700_DB6PMSD-LCK_WAITS, sy-vline,
WA_/SDF/DB6_700_DB6PMSD-LCK_W_TM, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SDF/DB6_700_DB6PMSD 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_/SDF/DB6_700_DB6PMSD 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_/SDF/DB6_700_DB6PMSD INTO WA_/SDF/DB6_700_DB6PMSD. *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_/SDF/DB6_700_DB6PMSD_STR,
COMPTIME TYPE STRING,
PARTITN TYPE STRING,
CALLERFLAG TYPE STRING,
DBMSTRTTME TYPE STRING,
PRGVERS TYPE STRING,
IN_DB_ALIA TYPE STRING,
DB_NAME TYPE STRING,
DB_PATH TYPE STRING,
LCKS_HELD TYPE STRING,
LCK_WAITS TYPE STRING,
LCK_W_TM TYPE STRING,
LCK_LSTIU TYPE STRING,
DEADLOCKS TYPE STRING,
LCK_ESCALS TYPE STRING,
X_LCK_ESCA TYPE STRING,
LCK_WTING TYPE STRING,
SRT_HP_ALO TYPE STRING,
TOT_SORTS TYPE STRING,
TOT_SRT_TM TYPE STRING,
SRT_OF TYPE STRING,
ACTIV_SORT 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,
FLS_CLOSED TYPE STRING,
CMMT_SQLST TYPE STRING,
RBCK_SQLST TYPE STRING,
DYN_SQLST TYPE STRING,
STC_SQLST TYPE STRING,
FAIL_SQLST TYPE STRING,
SELC_SQLST TYPE STRING,
DDL_SQLST TYPE STRING,
UID_SQLST TYPE STRING,
INT_ATRBND TYPE STRING,
INT_RW_DEL TYPE STRING,
INT_RW_UPD TYPE STRING,
INT_CMMTS TYPE STRING,
INT_RB TYPE STRING,
INT_DL_RB TYPE STRING,
RW_DELETED TYPE STRING,
RW_INSRTED TYPE STRING,
RW_UPDATED TYPE STRING,
RW_SELECED TYPE STRING,
BIND_PRECC TYPE STRING,
DB_CN_TM TYPE STRING,
LAST_RESET TYPE STRING,
LAST_BKUP TYPE STRING,
TOTAL_CONS TYPE STRING,
APL_CUR_CO TYPE STRING,
APL_IN_DB2 TYPE STRING,
SEC_LGUSTP TYPE STRING,
TOT_LGUTOP TYPE STRING,
SEC_LGALLO TYPE STRING,
NUM_SCDBS TYPE STRING,
PL_A_IRS TYPE STRING,
PL_D_TE TYPE STRING,
PL_I_TE TYPE STRING,
PL_I_FE TYPE STRING,
PL_D_FEI TYPE STRING,
DB_STATUS TYPE STRING,
LCK_TMOUT TYPE STRING,
CN_TOP TYPE STRING,
DB_HP_TOP TYPE STRING,
PL_A_DRS TYPE STRING,
PL_A_DWS TYPE STRING,
PL_A_IWS TYPE STRING,
PL_A_RTM TYPE STRING,
PL_A_WTM TYPE STRING,
PL_A_DRRQ TYPE STRING,
PL_LSNGCL TYPE STRING,
PL_DPSCL TYPE STRING,
PL_DPTCL TYPE STRING,
DIRCT_RDS TYPE STRING,
DIRCT_WTS TYPE STRING,
DIRCT_RRQS TYPE STRING,
DIRCT_WRQS TYPE STRING,
DIRCT_RTM TYPE STRING,
DIRCT_WTM TYPE STRING,
INT_RW_INS TYPE STRING,
LOG_READS TYPE STRING,
LOG_WRITES TYPE STRING,
PKG_CA_LKU TYPE STRING,
PKG_CA_INS TYPE STRING,
CATCA_LKU TYPE STRING,
CATCA_INS TYPE STRING,
CATCA_OF TYPE STRING,
CATCA_HPFL TYPE STRING,
CAT_NODE TYPE STRING,
TOT_SEC_CN TYPE STRING,
NUM_ASS_AG TYPE STRING,
AGENTS_TOP TYPE STRING,
CRD_AG_TOP TYPE STRING,
DB_LOCAT TYPE STRING,
SERV_PLATF TYPE STRING,
CAT_ND_NME TYPE STRING,
PF_WTTM TYPE STRING,
AP_SEC_LKU TYPE STRING,
AP_SEC_INS TYPE STRING,
TOT_HAJN TYPE STRING,
TOT_HALOOP TYPE STRING,
HAJN_OF TYPE STRING,
HAJN_SM_OF TYPE STRING,
TOT_LGUSED TYPE STRING,
TOT_LGAVL TYPE STRING,
UNREADPFPG TYPE STRING,
PKG_NUM_OV TYPE STRING,
PKG_SZ_TOP TYPE STRING,
PL_TD_LRS TYPE STRING,
PL_TD_PRS TYPE STRING,
PL_TI_LRS TYPE STRING,
PL_TI_PRS TYPE STRING,
PL_A_IRRQ TYPE STRING,
CATCASZTOP TYPE STRING,
LOGREADTS TYPE STRING,
LOGREADTNS TYPE STRING,
LOGWRITS TYPE STRING,
LOGWRITNS TYPE STRING,
NUMLOGWRIO TYPE STRING,
NUMLOGRDIO TYPE STRING,
NUMLOGPPIO TYPE STRING,
NUMLOGBFUL TYPE STRING,
NUMLOGDFND TYPE STRING,
LOGREDOREC TYPE STRING,
LOGHELDDTY TYPE STRING,
ACTIVE_HASH_JOIN TYPE STRING,
DBNAME TYPE STRING,
PL_ASYNC_XDA_RDS TYPE STRING,
PL_ASYNC_XDA_RRQ TYPE STRING,
PL_ASYNC_XDA_WRT TYPE STRING,
PL_TEMP_XDA_L_RD TYPE STRING,
PL_TEMP_XDA_P_RD TYPE STRING,
POOL_XDA_L_READS TYPE STRING,
POOL_XDA_P_READS TYPE STRING,
POOL_XDA_WRITES TYPE STRING,
POST_SHRTHRS_HAJ TYPE STRING,
POST_SHRTHRS_SRT TYPE STRING,
SMALLEST_LOG_AVL TYPE STRING,
APPL_ID_OLDEST_X TYPE STRING,
ELPSD_EXC_TIM_MS TYPE STRING,
ELPSD_EXC_TIM_S TYPE STRING,
NUM_DB_STORPATHS TYPE STRING,
NUM_INDOUBT_TRAN TYPE STRING,
PL_NO_VICTIM_BUF TYPE STRING,
ROWS_READ 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,
SORT_SHRHEAP_ALL TYPE STRING,
SORT_SHRHEAP_TOP TYPE STRING,
ACTIVE_OLAP_FUNCS TYPE STRING,
ASYNC_RUNSTATS TYPE STRING,
NUM_THRESHOLD_VIOLATIONS TYPE STRING,
OLAP_FUNC_OVERFLOWS TYPE STRING,
STATS_CACHE_SIZE TYPE STRING,
STATS_FABRICATE_TIME TYPE STRING,
STATS_FABRICATIONS TYPE STRING,
SYNC_RUNSTATS TYPE STRING,
SYNC_RUNSTATS_TIME TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SDF/DB6_700_DB6PMSD_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_/SDF/DB6_700_DB6PMSD_STR-COMPTIME sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PARTITN sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CALLERFLAG sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DBMSTRTTME sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PRGVERS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-IN_DB_ALIA sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DB_NAME sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DB_PATH sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LCKS_HELD sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LCK_WAITS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LCK_W_TM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LCK_LSTIU sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DEADLOCKS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LCK_ESCALS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-X_LCK_ESCA sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LCK_WTING sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SRT_HP_ALO sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-TOT_SORTS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-TOT_SRT_TM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SRT_OF sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-ACTIV_SORT sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_D_LRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_D_PRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_D_WS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_I_LRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_I_PRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_I_WS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_RD_TM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_WT_TM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-FLS_CLOSED sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CMMT_SQLST sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-RBCK_SQLST sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DYN_SQLST sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-STC_SQLST sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-FAIL_SQLST sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SELC_SQLST sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DDL_SQLST sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-UID_SQLST sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-INT_ATRBND sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-INT_RW_DEL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-INT_RW_UPD sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-INT_CMMTS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-INT_RB sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-INT_DL_RB sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-RW_DELETED sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-RW_INSRTED sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-RW_UPDATED sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-RW_SELECED sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-BIND_PRECC sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DB_CN_TM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LAST_RESET sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LAST_BKUP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-TOTAL_CONS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-APL_CUR_CO sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-APL_IN_DB2 sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SEC_LGUSTP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-TOT_LGUTOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SEC_LGALLO sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUM_SCDBS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_A_IRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_D_TE sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_I_TE sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_I_FE sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_D_FEI sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DB_STATUS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LCK_TMOUT sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CN_TOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DB_HP_TOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_A_DRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_A_DWS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_A_IWS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_A_RTM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_A_WTM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_A_DRRQ sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_LSNGCL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_DPSCL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_DPTCL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DIRCT_RDS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DIRCT_WTS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DIRCT_RRQS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DIRCT_WRQS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DIRCT_RTM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DIRCT_WTM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-INT_RW_INS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LOG_READS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LOG_WRITES sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PKG_CA_LKU sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PKG_CA_INS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CATCA_LKU sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CATCA_INS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CATCA_OF sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CATCA_HPFL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CAT_NODE sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-TOT_SEC_CN sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUM_ASS_AG sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-AGENTS_TOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CRD_AG_TOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DB_LOCAT sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SERV_PLATF sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CAT_ND_NME sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PF_WTTM sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-AP_SEC_LKU sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-AP_SEC_INS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-TOT_HAJN sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-TOT_HALOOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-HAJN_OF sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-HAJN_SM_OF sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-TOT_LGUSED sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-TOT_LGAVL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-UNREADPFPG sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PKG_NUM_OV sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PKG_SZ_TOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_TD_LRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_TD_PRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_TI_LRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_TI_PRS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_A_IRRQ sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-CATCASZTOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LOGREADTS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LOGREADTNS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LOGWRITS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LOGWRITNS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUMLOGWRIO sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUMLOGRDIO sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUMLOGPPIO sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUMLOGBFUL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUMLOGDFND sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LOGREDOREC sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-LOGHELDDTY sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-ACTIVE_HASH_JOIN sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-DBNAME sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_ASYNC_XDA_RDS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_ASYNC_XDA_RRQ sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_ASYNC_XDA_WRT sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_TEMP_XDA_L_RD sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_TEMP_XDA_P_RD sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-POOL_XDA_L_READS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-POOL_XDA_P_READS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-POOL_XDA_WRITES sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-POST_SHRTHRS_HAJ sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-POST_SHRTHRS_SRT sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SMALLEST_LOG_AVL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-APPL_ID_OLDEST_X sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-ELPSD_EXC_TIM_MS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-ELPSD_EXC_TIM_S sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUM_DB_STORPATHS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUM_INDOUBT_TRAN sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PL_NO_VICTIM_BUF sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-ROWS_READ sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PRV_WS_NUM_OVFL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PRV_WS_SCT_INSRT sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PRV_WS_SCT_LKUP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-PRV_WS_SIZE_TOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SHR_WS_NUM_OVFL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SHR_WS_SCT_INSRT sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SHR_WS_SCT_LKUP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SHR_WS_SIZE_TOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SORT_SHRHEAP_ALL sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SORT_SHRHEAP_TOP sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-ACTIVE_OLAP_FUNCS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-ASYNC_RUNSTATS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-NUM_THRESHOLD_VIOLATIONS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-OLAP_FUNC_OVERFLOWS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-STATS_CACHE_SIZE sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-STATS_FABRICATE_TIME sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-STATS_FABRICATIONS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SYNC_RUNSTATS sy-vline
WA_/SDF/DB6_700_DB6PMSD_STR-SYNC_RUNSTATS_TIME sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.