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