ABAP Select data from SAP table DB4_EXPLAIN into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP DB4_EXPLAIN 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 DB4_EXPLAIN. 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 DB4_EXPLAIN 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_DB4_EXPLAIN TYPE STANDARD TABLE OF DB4_EXPLAIN,
      WA_DB4_EXPLAIN TYPE DB4_EXPLAIN,
      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: <DB4_EXPLAIN> TYPE DB4_EXPLAIN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM DB4_EXPLAIN
*  INTO TABLE @DATA(IT_DB4_EXPLAIN2).
*--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_DB4_EXPLAIN INDEX 1 INTO DATA(WA_DB4_EXPLAIN2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_DB4_EXPLAIN ASSIGNING <DB4_EXPLAIN>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<DB4_EXPLAIN>-QQRID = 1.
<DB4_EXPLAIN>-QQTIME = 1.
<DB4_EXPLAIN>-QQJFLD = 1.
<DB4_EXPLAIN>-QQRDBN = 1.
<DB4_EXPLAIN>-QQSYS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_DB4_EXPLAIN-QQJOB, sy-vline,
  WA_DB4_EXPLAIN-QQUSER, sy-vline,
  WA_DB4_EXPLAIN-QQJNUM, sy-vline,
  WA_DB4_EXPLAIN-QQUCNT, sy-vline,
  WA_DB4_EXPLAIN-QQUDEF, sy-vline,
  WA_DB4_EXPLAIN-QQSTN, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_DB4_EXPLAIN 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_DB4_EXPLAIN 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_DB4_EXPLAIN INTO WA_DB4_EXPLAIN.


*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_DB4_EXPLAIN_STR, 
QQRID TYPE STRING,
QQTIME TYPE STRING,
QQJFLD TYPE STRING,
QQRDBN TYPE STRING,
QQSYS TYPE STRING,
QQJOB TYPE STRING,
QQUSER TYPE STRING,
QQJNUM TYPE STRING,
QQUCNT TYPE STRING,
QQUDEF TYPE STRING,
QQSTN TYPE STRING,
QQQDTN TYPE STRING,
QQQDTL TYPE STRING,
QQMATN TYPE STRING,
QQMATL TYPE STRING,
QQTLN TYPE STRING,
QQTFN TYPE STRING,
QQTMN TYPE STRING,
QQPTLN TYPE STRING,
QQPTFN TYPE STRING,
QQPTMN TYPE STRING,
QQILNM TYPE STRING,
QQIFNM TYPE STRING,
QQIMNM TYPE STRING,
QQNTNM TYPE STRING,
QQNLNM TYPE STRING,
QQSTIM TYPE STRING,
QQETIM TYPE STRING,
QQKP TYPE STRING,
QQKS TYPE STRING,
QQTOTR TYPE STRING,
QQTMPR TYPE STRING,
QQJNP TYPE STRING,
QQEPT TYPE STRING,
QQDSS TYPE STRING,
QQIDXA TYPE STRING,
QQORDG TYPE STRING,
QQGRPG TYPE STRING,
QQJNG TYPE STRING,
QQUNIN TYPE STRING,
QQSUBQ TYPE STRING,
QQHSTV TYPE STRING,
QQRCDS TYPE STRING,
QQRCOD TYPE STRING,
QQRSS TYPE STRING,
QQREST TYPE STRING,
QQRIDX TYPE STRING,
QQFKEY TYPE STRING,
QQKSEL TYPE STRING,
QQAJN TYPE STRING,
QQIDXD_1 TYPE STRING,
QQIDXD_2 TYPE STRING,
QQIDXD_3 TYPE STRING,
QQIDXD_4 TYPE STRING,
QQC11 TYPE STRING,
QQC12 TYPE STRING,
QQC13 TYPE STRING,
QQC14 TYPE STRING,
QQC15 TYPE STRING,
QQC16 TYPE STRING,
QQC18 TYPE STRING,
QQC21 TYPE STRING,
QQC22 TYPE STRING,
QQC23 TYPE STRING,
QQI1 TYPE STRING,
QQI2 TYPE STRING,
QQI3 TYPE STRING,
QQI4 TYPE STRING,
QQI5 TYPE STRING,
QQI6 TYPE STRING,
QQI7 TYPE STRING,
QQI8 TYPE STRING,
QQI9 TYPE STRING,
QQIA TYPE STRING,
QQF1 TYPE STRING,
QQF2 TYPE STRING,
QQF3 TYPE STRING,
QQC61 TYPE STRING,
QQC81 TYPE STRING,
QQC82 TYPE STRING,
QQC83 TYPE STRING,
QQC84 TYPE STRING,
QQC101 TYPE STRING,
QQC102 TYPE STRING,
QQC103 TYPE STRING,
QQC104 TYPE STRING,
QQC105 TYPE STRING,
QQC106 TYPE STRING,
QQC181 TYPE STRING,
QQC182 TYPE STRING,
QQC183 TYPE STRING,
QQC301 TYPE STRING,
QQC302 TYPE STRING,
QQC303 TYPE STRING,
QQ1000_1 TYPE STRING,
QQ1000_2 TYPE STRING,
QQ1000_3 TYPE STRING,
QQ1000_4 TYPE STRING,
QQTIM1 TYPE STRING,
QQTIM2 TYPE STRING,
QVQTBL TYPE STRING,
QVQLIB TYPE STRING,
QVPTBL TYPE STRING,
QVPLIB TYPE STRING,
QVINAM TYPE STRING,
QVILIB TYPE STRING,
QVQTBLI TYPE STRING,
QVPTBLI TYPE STRING,
QVINAMI TYPE STRING,
QVBNDY TYPE STRING,
QVJFANO TYPE STRING,
QVPARPF TYPE STRING,
QVPARPL TYPE STRING,
QVC11 TYPE STRING,
QVC12 TYPE STRING,
QVC13 TYPE STRING,
QVC14 TYPE STRING,
QVC15 TYPE STRING,
QVC16 TYPE STRING,
QVC17 TYPE STRING,
QVC18 TYPE STRING,
QVC19 TYPE STRING,
QVC1A TYPE STRING,
QVC1B TYPE STRING,
QVC1C TYPE STRING,
QVC1D TYPE STRING,
QVC1E TYPE STRING,
QVC1F TYPE STRING,
QWC11 TYPE STRING,
QWC12 TYPE STRING,
QWC13 TYPE STRING,
QWC14 TYPE STRING,
QWC15 TYPE STRING,
QWC16 TYPE STRING,
QWC17 TYPE STRING,
QWC18 TYPE STRING,
QWC19 TYPE STRING,
QWC1A TYPE STRING,
QWC1B TYPE STRING,
QWC1C TYPE STRING,
QWC1D TYPE STRING,
QWC1E TYPE STRING,
QWC1F TYPE STRING,
QVC21 TYPE STRING,
QVC22 TYPE STRING,
QVC23 TYPE STRING,
QVC24 TYPE STRING,
QVCTIM TYPE STRING,
QVPARD TYPE STRING,
QVPARU TYPE STRING,
QVPARRC TYPE STRING,
QVRCNT TYPE STRING,
QVFILES TYPE STRING,
QVP151 TYPE STRING,
QVP152 TYPE STRING,
QVP153 TYPE STRING,
QVP154 TYPE STRING,
QVP155 TYPE STRING,
QVP156 TYPE STRING,
QVP157 TYPE STRING,
QVP158 TYPE STRING,
QVP159 TYPE STRING,
QVP15A TYPE STRING,
QVP15B TYPE STRING,
QVP15C TYPE STRING,
QVP15D TYPE STRING,
QVP15E TYPE STRING,
QVP15F TYPE STRING,
QVC41 TYPE STRING,
QVC42 TYPE STRING,
QVC43 TYPE STRING,
QVC44 TYPE STRING,
QVC81 TYPE STRING,
QVC82 TYPE STRING,
QVC83 TYPE STRING,
QVC84 TYPE STRING,
QVC85 TYPE STRING,
QVC86 TYPE STRING,
QVC87 TYPE STRING,
QVC88 TYPE STRING,
QVC101 TYPE STRING,
QVC102 TYPE STRING,
QVC103 TYPE STRING,
QVC104 TYPE STRING,
QVC105 TYPE STRING,
QVC106 TYPE STRING,
QVC107 TYPE STRING,
QVC108 TYPE STRING,
QVC1281 TYPE STRING,
QVC1282 TYPE STRING,
QVC1283 TYPE STRING,
QVC1284 TYPE STRING,
QVC3001 TYPE STRING,
QVC3002 TYPE STRING,
QVC3003 TYPE STRING,
QVC3004 TYPE STRING,
QVC3005 TYPE STRING,
QVC3006 TYPE STRING,
QVC3007 TYPE STRING,
QVC3008 TYPE STRING,
QVC5001 TYPE STRING,
QVC5002 TYPE STRING,
QVC1000 TYPE STRING,
QWC1000 TYPE STRING,
IDXDLEN TYPE STRING,
LONGLEN TYPE STRING,
TOTTIM TYPE STRING,END OF T_EKKO_STR.
DATA: WA_DB4_EXPLAIN_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_DB4_EXPLAIN_STR-QQRID sy-vline 
WA_DB4_EXPLAIN_STR-QQTIME sy-vline 
WA_DB4_EXPLAIN_STR-QQJFLD sy-vline 
WA_DB4_EXPLAIN_STR-QQRDBN sy-vline 
WA_DB4_EXPLAIN_STR-QQSYS sy-vline 
WA_DB4_EXPLAIN_STR-QQJOB sy-vline 
WA_DB4_EXPLAIN_STR-QQUSER sy-vline 
WA_DB4_EXPLAIN_STR-QQJNUM sy-vline 
WA_DB4_EXPLAIN_STR-QQUCNT sy-vline 
WA_DB4_EXPLAIN_STR-QQUDEF sy-vline 
WA_DB4_EXPLAIN_STR-QQSTN sy-vline 
WA_DB4_EXPLAIN_STR-QQQDTN sy-vline 
WA_DB4_EXPLAIN_STR-QQQDTL sy-vline 
WA_DB4_EXPLAIN_STR-QQMATN sy-vline 
WA_DB4_EXPLAIN_STR-QQMATL sy-vline 
WA_DB4_EXPLAIN_STR-QQTLN sy-vline 
WA_DB4_EXPLAIN_STR-QQTFN sy-vline 
WA_DB4_EXPLAIN_STR-QQTMN sy-vline 
WA_DB4_EXPLAIN_STR-QQPTLN sy-vline 
WA_DB4_EXPLAIN_STR-QQPTFN sy-vline 
WA_DB4_EXPLAIN_STR-QQPTMN sy-vline 
WA_DB4_EXPLAIN_STR-QQILNM sy-vline 
WA_DB4_EXPLAIN_STR-QQIFNM sy-vline 
WA_DB4_EXPLAIN_STR-QQIMNM sy-vline 
WA_DB4_EXPLAIN_STR-QQNTNM sy-vline 
WA_DB4_EXPLAIN_STR-QQNLNM sy-vline 
WA_DB4_EXPLAIN_STR-QQSTIM sy-vline 
WA_DB4_EXPLAIN_STR-QQETIM sy-vline 
WA_DB4_EXPLAIN_STR-QQKP sy-vline 
WA_DB4_EXPLAIN_STR-QQKS sy-vline 
WA_DB4_EXPLAIN_STR-QQTOTR sy-vline 
WA_DB4_EXPLAIN_STR-QQTMPR sy-vline 
WA_DB4_EXPLAIN_STR-QQJNP sy-vline 
WA_DB4_EXPLAIN_STR-QQEPT sy-vline 
WA_DB4_EXPLAIN_STR-QQDSS sy-vline 
WA_DB4_EXPLAIN_STR-QQIDXA sy-vline 
WA_DB4_EXPLAIN_STR-QQORDG sy-vline 
WA_DB4_EXPLAIN_STR-QQGRPG sy-vline 
WA_DB4_EXPLAIN_STR-QQJNG sy-vline 
WA_DB4_EXPLAIN_STR-QQUNIN sy-vline 
WA_DB4_EXPLAIN_STR-QQSUBQ sy-vline 
WA_DB4_EXPLAIN_STR-QQHSTV sy-vline 
WA_DB4_EXPLAIN_STR-QQRCDS sy-vline 
WA_DB4_EXPLAIN_STR-QQRCOD sy-vline 
WA_DB4_EXPLAIN_STR-QQRSS sy-vline 
WA_DB4_EXPLAIN_STR-QQREST sy-vline 
WA_DB4_EXPLAIN_STR-QQRIDX sy-vline 
WA_DB4_EXPLAIN_STR-QQFKEY sy-vline 
WA_DB4_EXPLAIN_STR-QQKSEL sy-vline 
WA_DB4_EXPLAIN_STR-QQAJN sy-vline 
WA_DB4_EXPLAIN_STR-QQIDXD_1 sy-vline 
WA_DB4_EXPLAIN_STR-QQIDXD_2 sy-vline 
WA_DB4_EXPLAIN_STR-QQIDXD_3 sy-vline 
WA_DB4_EXPLAIN_STR-QQIDXD_4 sy-vline 
WA_DB4_EXPLAIN_STR-QQC11 sy-vline 
WA_DB4_EXPLAIN_STR-QQC12 sy-vline 
WA_DB4_EXPLAIN_STR-QQC13 sy-vline 
WA_DB4_EXPLAIN_STR-QQC14 sy-vline 
WA_DB4_EXPLAIN_STR-QQC15 sy-vline 
WA_DB4_EXPLAIN_STR-QQC16 sy-vline 
WA_DB4_EXPLAIN_STR-QQC18 sy-vline 
WA_DB4_EXPLAIN_STR-QQC21 sy-vline 
WA_DB4_EXPLAIN_STR-QQC22 sy-vline 
WA_DB4_EXPLAIN_STR-QQC23 sy-vline 
WA_DB4_EXPLAIN_STR-QQI1 sy-vline 
WA_DB4_EXPLAIN_STR-QQI2 sy-vline 
WA_DB4_EXPLAIN_STR-QQI3 sy-vline 
WA_DB4_EXPLAIN_STR-QQI4 sy-vline 
WA_DB4_EXPLAIN_STR-QQI5 sy-vline 
WA_DB4_EXPLAIN_STR-QQI6 sy-vline 
WA_DB4_EXPLAIN_STR-QQI7 sy-vline 
WA_DB4_EXPLAIN_STR-QQI8 sy-vline 
WA_DB4_EXPLAIN_STR-QQI9 sy-vline 
WA_DB4_EXPLAIN_STR-QQIA sy-vline 
WA_DB4_EXPLAIN_STR-QQF1 sy-vline 
WA_DB4_EXPLAIN_STR-QQF2 sy-vline 
WA_DB4_EXPLAIN_STR-QQF3 sy-vline 
WA_DB4_EXPLAIN_STR-QQC61 sy-vline 
WA_DB4_EXPLAIN_STR-QQC81 sy-vline 
WA_DB4_EXPLAIN_STR-QQC82 sy-vline 
WA_DB4_EXPLAIN_STR-QQC83 sy-vline 
WA_DB4_EXPLAIN_STR-QQC84 sy-vline 
WA_DB4_EXPLAIN_STR-QQC101 sy-vline 
WA_DB4_EXPLAIN_STR-QQC102 sy-vline 
WA_DB4_EXPLAIN_STR-QQC103 sy-vline 
WA_DB4_EXPLAIN_STR-QQC104 sy-vline 
WA_DB4_EXPLAIN_STR-QQC105 sy-vline 
WA_DB4_EXPLAIN_STR-QQC106 sy-vline 
WA_DB4_EXPLAIN_STR-QQC181 sy-vline 
WA_DB4_EXPLAIN_STR-QQC182 sy-vline 
WA_DB4_EXPLAIN_STR-QQC183 sy-vline 
WA_DB4_EXPLAIN_STR-QQC301 sy-vline 
WA_DB4_EXPLAIN_STR-QQC302 sy-vline 
WA_DB4_EXPLAIN_STR-QQC303 sy-vline 
WA_DB4_EXPLAIN_STR-QQ1000_1 sy-vline 
WA_DB4_EXPLAIN_STR-QQ1000_2 sy-vline 
WA_DB4_EXPLAIN_STR-QQ1000_3 sy-vline 
WA_DB4_EXPLAIN_STR-QQ1000_4 sy-vline 
WA_DB4_EXPLAIN_STR-QQTIM1 sy-vline 
WA_DB4_EXPLAIN_STR-QQTIM2 sy-vline 
WA_DB4_EXPLAIN_STR-QVQTBL sy-vline 
WA_DB4_EXPLAIN_STR-QVQLIB sy-vline 
WA_DB4_EXPLAIN_STR-QVPTBL sy-vline 
WA_DB4_EXPLAIN_STR-QVPLIB sy-vline 
WA_DB4_EXPLAIN_STR-QVINAM sy-vline 
WA_DB4_EXPLAIN_STR-QVILIB sy-vline 
WA_DB4_EXPLAIN_STR-QVQTBLI sy-vline 
WA_DB4_EXPLAIN_STR-QVPTBLI sy-vline 
WA_DB4_EXPLAIN_STR-QVINAMI sy-vline 
WA_DB4_EXPLAIN_STR-QVBNDY sy-vline 
WA_DB4_EXPLAIN_STR-QVJFANO sy-vline 
WA_DB4_EXPLAIN_STR-QVPARPF sy-vline 
WA_DB4_EXPLAIN_STR-QVPARPL sy-vline 
WA_DB4_EXPLAIN_STR-QVC11 sy-vline 
WA_DB4_EXPLAIN_STR-QVC12 sy-vline 
WA_DB4_EXPLAIN_STR-QVC13 sy-vline 
WA_DB4_EXPLAIN_STR-QVC14 sy-vline 
WA_DB4_EXPLAIN_STR-QVC15 sy-vline 
WA_DB4_EXPLAIN_STR-QVC16 sy-vline 
WA_DB4_EXPLAIN_STR-QVC17 sy-vline 
WA_DB4_EXPLAIN_STR-QVC18 sy-vline 
WA_DB4_EXPLAIN_STR-QVC19 sy-vline 
WA_DB4_EXPLAIN_STR-QVC1A sy-vline 
WA_DB4_EXPLAIN_STR-QVC1B sy-vline 
WA_DB4_EXPLAIN_STR-QVC1C sy-vline 
WA_DB4_EXPLAIN_STR-QVC1D sy-vline 
WA_DB4_EXPLAIN_STR-QVC1E sy-vline 
WA_DB4_EXPLAIN_STR-QVC1F sy-vline 
WA_DB4_EXPLAIN_STR-QWC11 sy-vline 
WA_DB4_EXPLAIN_STR-QWC12 sy-vline 
WA_DB4_EXPLAIN_STR-QWC13 sy-vline 
WA_DB4_EXPLAIN_STR-QWC14 sy-vline 
WA_DB4_EXPLAIN_STR-QWC15 sy-vline 
WA_DB4_EXPLAIN_STR-QWC16 sy-vline 
WA_DB4_EXPLAIN_STR-QWC17 sy-vline 
WA_DB4_EXPLAIN_STR-QWC18 sy-vline 
WA_DB4_EXPLAIN_STR-QWC19 sy-vline 
WA_DB4_EXPLAIN_STR-QWC1A sy-vline 
WA_DB4_EXPLAIN_STR-QWC1B sy-vline 
WA_DB4_EXPLAIN_STR-QWC1C sy-vline 
WA_DB4_EXPLAIN_STR-QWC1D sy-vline 
WA_DB4_EXPLAIN_STR-QWC1E sy-vline 
WA_DB4_EXPLAIN_STR-QWC1F sy-vline 
WA_DB4_EXPLAIN_STR-QVC21 sy-vline 
WA_DB4_EXPLAIN_STR-QVC22 sy-vline 
WA_DB4_EXPLAIN_STR-QVC23 sy-vline 
WA_DB4_EXPLAIN_STR-QVC24 sy-vline 
WA_DB4_EXPLAIN_STR-QVCTIM sy-vline 
WA_DB4_EXPLAIN_STR-QVPARD sy-vline 
WA_DB4_EXPLAIN_STR-QVPARU sy-vline 
WA_DB4_EXPLAIN_STR-QVPARRC sy-vline 
WA_DB4_EXPLAIN_STR-QVRCNT sy-vline 
WA_DB4_EXPLAIN_STR-QVFILES sy-vline 
WA_DB4_EXPLAIN_STR-QVP151 sy-vline 
WA_DB4_EXPLAIN_STR-QVP152 sy-vline 
WA_DB4_EXPLAIN_STR-QVP153 sy-vline 
WA_DB4_EXPLAIN_STR-QVP154 sy-vline 
WA_DB4_EXPLAIN_STR-QVP155 sy-vline 
WA_DB4_EXPLAIN_STR-QVP156 sy-vline 
WA_DB4_EXPLAIN_STR-QVP157 sy-vline 
WA_DB4_EXPLAIN_STR-QVP158 sy-vline 
WA_DB4_EXPLAIN_STR-QVP159 sy-vline 
WA_DB4_EXPLAIN_STR-QVP15A sy-vline 
WA_DB4_EXPLAIN_STR-QVP15B sy-vline 
WA_DB4_EXPLAIN_STR-QVP15C sy-vline 
WA_DB4_EXPLAIN_STR-QVP15D sy-vline 
WA_DB4_EXPLAIN_STR-QVP15E sy-vline 
WA_DB4_EXPLAIN_STR-QVP15F sy-vline 
WA_DB4_EXPLAIN_STR-QVC41 sy-vline 
WA_DB4_EXPLAIN_STR-QVC42 sy-vline 
WA_DB4_EXPLAIN_STR-QVC43 sy-vline 
WA_DB4_EXPLAIN_STR-QVC44 sy-vline 
WA_DB4_EXPLAIN_STR-QVC81 sy-vline 
WA_DB4_EXPLAIN_STR-QVC82 sy-vline 
WA_DB4_EXPLAIN_STR-QVC83 sy-vline 
WA_DB4_EXPLAIN_STR-QVC84 sy-vline 
WA_DB4_EXPLAIN_STR-QVC85 sy-vline 
WA_DB4_EXPLAIN_STR-QVC86 sy-vline 
WA_DB4_EXPLAIN_STR-QVC87 sy-vline 
WA_DB4_EXPLAIN_STR-QVC88 sy-vline 
WA_DB4_EXPLAIN_STR-QVC101 sy-vline 
WA_DB4_EXPLAIN_STR-QVC102 sy-vline 
WA_DB4_EXPLAIN_STR-QVC103 sy-vline 
WA_DB4_EXPLAIN_STR-QVC104 sy-vline 
WA_DB4_EXPLAIN_STR-QVC105 sy-vline 
WA_DB4_EXPLAIN_STR-QVC106 sy-vline 
WA_DB4_EXPLAIN_STR-QVC107 sy-vline 
WA_DB4_EXPLAIN_STR-QVC108 sy-vline 
WA_DB4_EXPLAIN_STR-QVC1281 sy-vline 
WA_DB4_EXPLAIN_STR-QVC1282 sy-vline 
WA_DB4_EXPLAIN_STR-QVC1283 sy-vline 
WA_DB4_EXPLAIN_STR-QVC1284 sy-vline 
WA_DB4_EXPLAIN_STR-QVC3001 sy-vline 
WA_DB4_EXPLAIN_STR-QVC3002 sy-vline 
WA_DB4_EXPLAIN_STR-QVC3003 sy-vline 
WA_DB4_EXPLAIN_STR-QVC3004 sy-vline 
WA_DB4_EXPLAIN_STR-QVC3005 sy-vline 
WA_DB4_EXPLAIN_STR-QVC3006 sy-vline 
WA_DB4_EXPLAIN_STR-QVC3007 sy-vline 
WA_DB4_EXPLAIN_STR-QVC3008 sy-vline 
WA_DB4_EXPLAIN_STR-QVC5001 sy-vline 
WA_DB4_EXPLAIN_STR-QVC5002 sy-vline 
WA_DB4_EXPLAIN_STR-QVC1000 sy-vline 
WA_DB4_EXPLAIN_STR-QWC1000 sy-vline 
WA_DB4_EXPLAIN_STR-IDXDLEN sy-vline 
WA_DB4_EXPLAIN_STR-LONGLEN sy-vline 
WA_DB4_EXPLAIN_STR-TOTTIM sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.