SAP MATDOCOILEXTRACT ABAP Select data from SAP table

Search SAP Tables

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

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MATDOCOILEXTRACT
*  INTO TABLE @DATA(IT_MATDOCOILEXTRACT2).
*--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_MATDOCOILEXTRACT INDEX 1 INTO DATA(WA_MATDOCOILEXTRACT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MATDOCOILEXTRACT>-MANDT = 1.
<MATDOCOILEXTRACT>-KEY1 = 1.
<MATDOCOILEXTRACT>-KEY2 = 1.
<MATDOCOILEXTRACT>-KEY3 = 1.
<MATDOCOILEXTRACT>-KEY4 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MATDOCOILEXTRACT-KEY5, sy-vline,
  WA_MATDOCOILEXTRACT-KEY6, sy-vline,
  WA_MATDOCOILEXTRACT-MATBF, sy-vline,
  WA_MATDOCOILEXTRACT-WERKS, sy-vline,
  WA_MATDOCOILEXTRACT-LGORT_SID, sy-vline,
  WA_MATDOCOILEXTRACT-CHARG_SID, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MATDOCOILEXTRACT 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_MATDOCOILEXTRACT 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_MATDOCOILEXTRACT INTO WA_MATDOCOILEXTRACT.


*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.

*Conversion exit MATN1, internal->external for field MATBF
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_MATDOCOILEXTRACT-MATBF
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MATDOCOILEXTRACT-MATBF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field LIFNR_SID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MATDOCOILEXTRACT-LIFNR_SID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MATDOCOILEXTRACT-LIFNR_SID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field MAT_KDAUF
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MATDOCOILEXTRACT-MAT_KDAUF
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MATDOCOILEXTRACT-MAT_KDAUF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSP, internal->external for field MAT_PSPNR
CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT'
  EXPORTING
    input =                      WA_MATDOCOILEXTRACT-MAT_PSPNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MATDOCOILEXTRACT-MAT_PSPNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KUNNR_SID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MATDOCOILEXTRACT-KUNNR_SID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MATDOCOILEXTRACT-KUNNR_SID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field DISUB_OWNER_SID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MATDOCOILEXTRACT-DISUB_OWNER_SID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MATDOCOILEXTRACT-DISUB_OWNER_SID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PERI7, internal->external for field GJPER
CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT'
  EXPORTING
    input =                      WA_MATDOCOILEXTRACT-GJPER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MATDOCOILEXTRACT-GJPER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PERI7, internal->external for field GJPER_CURR_PER
CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT'
  EXPORTING
    input =                      WA_MATDOCOILEXTRACT-GJPER_CURR_PER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MATDOCOILEXTRACT-GJPER_CURR_PER.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_MATDOCOILEXTRACT_STR, 
MANDT TYPE STRING,
KEY1 TYPE STRING,
KEY2 TYPE STRING,
KEY3 TYPE STRING,
KEY4 TYPE STRING,
KEY5 TYPE STRING,
KEY6 TYPE STRING,
MATBF TYPE STRING,
WERKS TYPE STRING,
LGORT_SID TYPE STRING,
CHARG_SID TYPE STRING,
LIFNR_SID TYPE STRING,
MAT_KDAUF TYPE STRING,
MAT_KDPOS TYPE STRING,
MAT_PSPNR TYPE STRING,
KUNNR_SID TYPE STRING,
SOBKZ TYPE STRING,
LBBSA_SID TYPE STRING,
DISUB_OWNER_SID TYPE STRING,
BUKRS TYPE STRING,
RECORD_TYPE TYPE STRING,
PERIV TYPE STRING,
GJPER TYPE STRING,
GJPER_CURR_PER TYPE STRING,
CPUDT_L1 TYPE STRING,
CPUDT_L2 TYPE STRING,
STOCK_IND_L2 TYPE STRING,
TIMESTAMP TYPE STRING,
UOM_SUM_FLAG TYPE STRING,
ADQNTP1L1 TYPE STRING,
ADQNTP1L2 TYPE STRING,
ADQNTP2L1 TYPE STRING,
ADQNTP2L2 TYPE STRING,
ADQNTP3L1 TYPE STRING,
ADQNTP3L2 TYPE STRING,
ADQNTP4L1 TYPE STRING,
ADQNTP4L2 TYPE STRING,
ADQNTP5L1 TYPE STRING,
ADQNTP5L2 TYPE STRING,
ADQNTP6L1 TYPE STRING,
ADQNTP6L2 TYPE STRING,
ADQNTP7L1 TYPE STRING,
ADQNTP7L2 TYPE STRING,
ADQNTP8L1 TYPE STRING,
ADQNTP8L2 TYPE STRING,
ADQNTP9L1 TYPE STRING,
ADQNTP9L2 TYPE STRING,
ADQNTP10L1 TYPE STRING,
ADQNTP10L2 TYPE STRING,
ADQNTP11L1 TYPE STRING,
ADQNTP11L2 TYPE STRING,
ADQNTP12L1 TYPE STRING,
ADQNTP12L2 TYPE STRING,
ADQNTP13L1 TYPE STRING,
ADQNTP13L2 TYPE STRING,
ADQNTP14L1 TYPE STRING,
ADQNTP14L2 TYPE STRING,
ADQNTP15L1 TYPE STRING,
ADQNTP15L2 TYPE STRING,
ADQNTP16L1 TYPE STRING,
ADQNTP16L2 TYPE STRING,
ADQNTP17L1 TYPE STRING,
ADQNTP17L2 TYPE STRING,
ADQNTP18L1 TYPE STRING,
ADQNTP18L2 TYPE STRING,
ADQNTP19L1 TYPE STRING,
ADQNTP19L2 TYPE STRING,
ADQNTP20L1 TYPE STRING,
ADQNTP20L2 TYPE STRING,
ADQNTP21L1 TYPE STRING,
ADQNTP21L2 TYPE STRING,
ADQNTP22L1 TYPE STRING,
ADQNTP22L2 TYPE STRING,
ADQNTP23L1 TYPE STRING,
ADQNTP23L2 TYPE STRING,
ADQNTP24L1 TYPE STRING,
ADQNTP24L2 TYPE STRING,
ADQNTP25L1 TYPE STRING,
ADQNTP25L2 TYPE STRING,
ADQNTP26L1 TYPE STRING,
ADQNTP26L2 TYPE STRING,
ADQNTP27L1 TYPE STRING,
ADQNTP27L2 TYPE STRING,
ADQNTP28L1 TYPE STRING,
ADQNTP28L2 TYPE STRING,
ADQNTP29L1 TYPE STRING,
ADQNTP29L2 TYPE STRING,
ADQNTP30L1 TYPE STRING,
ADQNTP30L2 TYPE STRING,
ADQNTP31L1 TYPE STRING,
ADQNTP31L2 TYPE STRING,
ADQNTP32L1 TYPE STRING,
ADQNTP32L2 TYPE STRING,
ADQNTP33L1 TYPE STRING,
ADQNTP33L2 TYPE STRING,
ADQNTP34L1 TYPE STRING,
ADQNTP34L2 TYPE STRING,
ADQNTP35L1 TYPE STRING,
ADQNTP35L2 TYPE STRING,
ADQNTP36L1 TYPE STRING,
ADQNTP36L2 TYPE STRING,
ADQNTP37L1 TYPE STRING,
ADQNTP37L2 TYPE STRING,
ADQNTP38L1 TYPE STRING,
ADQNTP38L2 TYPE STRING,
ADQNTP39L1 TYPE STRING,
ADQNTP39L2 TYPE STRING,
ADQNTP40L1 TYPE STRING,
ADQNTP40L2 TYPE STRING,
ADQNTP41L1 TYPE STRING,
ADQNTP41L2 TYPE STRING,
ADQNTP42L1 TYPE STRING,
ADQNTP42L2 TYPE STRING,
ADQNTP43L1 TYPE STRING,
ADQNTP43L2 TYPE STRING,
ADQNTP44L1 TYPE STRING,
ADQNTP44L2 TYPE STRING,
ADQNTP45L1 TYPE STRING,
ADQNTP45L2 TYPE STRING,
ADQNTP46L1 TYPE STRING,
ADQNTP46L2 TYPE STRING,
ADQNTP47L1 TYPE STRING,
ADQNTP47L2 TYPE STRING,
ADQNTP48L1 TYPE STRING,
ADQNTP48L2 TYPE STRING,
ADQNTP49L1 TYPE STRING,
ADQNTP49L2 TYPE STRING,
ADQNTP50L1 TYPE STRING,
ADQNTP50L2 TYPE STRING,
ADQNTP51L1 TYPE STRING,
ADQNTP51L2 TYPE STRING,
ADQNTP52L1 TYPE STRING,
ADQNTP52L2 TYPE STRING,
ADQNTP53L1 TYPE STRING,
ADQNTP53L2 TYPE STRING,
ADQNTP54L1 TYPE STRING,
ADQNTP54L2 TYPE STRING,
ADQNTP55L1 TYPE STRING,
ADQNTP55L2 TYPE STRING,
ADQNTP56L1 TYPE STRING,
ADQNTP56L2 TYPE STRING,
ADQNTP57L1 TYPE STRING,
ADQNTP57L2 TYPE STRING,
ADQNTP58L1 TYPE STRING,
ADQNTP58L2 TYPE STRING,
ADQNTP59L1 TYPE STRING,
ADQNTP59L2 TYPE STRING,
ADQNTP60L1 TYPE STRING,
ADQNTP60L2 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MATDOCOILEXTRACT_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_MATDOCOILEXTRACT_STR-MANDT sy-vline 
WA_MATDOCOILEXTRACT_STR-KEY1 sy-vline 
WA_MATDOCOILEXTRACT_STR-KEY2 sy-vline 
WA_MATDOCOILEXTRACT_STR-KEY3 sy-vline 
WA_MATDOCOILEXTRACT_STR-KEY4 sy-vline 
WA_MATDOCOILEXTRACT_STR-KEY5 sy-vline 
WA_MATDOCOILEXTRACT_STR-KEY6 sy-vline 
WA_MATDOCOILEXTRACT_STR-MATBF sy-vline 
WA_MATDOCOILEXTRACT_STR-WERKS sy-vline 
WA_MATDOCOILEXTRACT_STR-LGORT_SID sy-vline 
WA_MATDOCOILEXTRACT_STR-CHARG_SID sy-vline 
WA_MATDOCOILEXTRACT_STR-LIFNR_SID sy-vline 
WA_MATDOCOILEXTRACT_STR-MAT_KDAUF sy-vline 
WA_MATDOCOILEXTRACT_STR-MAT_KDPOS sy-vline 
WA_MATDOCOILEXTRACT_STR-MAT_PSPNR sy-vline 
WA_MATDOCOILEXTRACT_STR-KUNNR_SID sy-vline 
WA_MATDOCOILEXTRACT_STR-SOBKZ sy-vline 
WA_MATDOCOILEXTRACT_STR-LBBSA_SID sy-vline 
WA_MATDOCOILEXTRACT_STR-DISUB_OWNER_SID sy-vline 
WA_MATDOCOILEXTRACT_STR-BUKRS sy-vline 
WA_MATDOCOILEXTRACT_STR-RECORD_TYPE sy-vline 
WA_MATDOCOILEXTRACT_STR-PERIV sy-vline 
WA_MATDOCOILEXTRACT_STR-GJPER sy-vline 
WA_MATDOCOILEXTRACT_STR-GJPER_CURR_PER sy-vline 
WA_MATDOCOILEXTRACT_STR-CPUDT_L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-CPUDT_L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-STOCK_IND_L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-TIMESTAMP sy-vline 
WA_MATDOCOILEXTRACT_STR-UOM_SUM_FLAG sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP1L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP1L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP2L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP2L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP3L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP3L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP4L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP4L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP5L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP5L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP6L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP6L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP7L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP7L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP8L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP8L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP9L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP9L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP10L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP10L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP11L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP11L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP12L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP12L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP13L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP13L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP14L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP14L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP15L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP15L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP16L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP16L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP17L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP17L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP18L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP18L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP19L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP19L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP20L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP20L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP21L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP21L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP22L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP22L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP23L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP23L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP24L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP24L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP25L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP25L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP26L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP26L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP27L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP27L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP28L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP28L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP29L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP29L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP30L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP30L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP31L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP31L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP32L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP32L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP33L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP33L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP34L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP34L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP35L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP35L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP36L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP36L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP37L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP37L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP38L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP38L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP39L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP39L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP40L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP40L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP41L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP41L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP42L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP42L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP43L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP43L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP44L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP44L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP45L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP45L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP46L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP46L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP47L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP47L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP48L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP48L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP49L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP49L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP50L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP50L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP51L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP51L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP52L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP52L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP53L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP53L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP54L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP54L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP55L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP55L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP56L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP56L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP57L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP57L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP58L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP58L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP59L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP59L2 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP60L1 sy-vline 
WA_MATDOCOILEXTRACT_STR-ADQNTP60L2 sy-vline      INTO ld_text SEPARATED BY SPACE.

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

Search for further information about these or an SAP related objects