ABAP Select data from SAP table WDFR_SMAT 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 WDFR_SMAT 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 WDFR_SMAT. 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 WDFR_SMAT 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_WDFR_SMAT TYPE STANDARD TABLE OF WDFR_SMAT,
      WA_WDFR_SMAT TYPE WDFR_SMAT,
      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: <WDFR_SMAT> TYPE WDFR_SMAT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM WDFR_SMAT
*  INTO TABLE @DATA(IT_WDFR_SMAT2).
*--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_WDFR_SMAT INDEX 1 INTO DATA(WA_WDFR_SMAT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<WDFR_SMAT>-WERKS = 1.
<WDFR_SMAT>-MATNR = 1.
<WDFR_SMAT>-DISPNR = 1.
<WDFR_SMAT>-TABIX = 1.
<WDFR_SMAT>-SELKZ = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_WDFR_SMAT-MAKTX, sy-vline,
  WA_WDFR_SMAT-EMATN, sy-vline,
  WA_WDFR_SMAT-ATTYP, sy-vline,
  WA_WDFR_SMAT-UEBPO, sy-vline,
  WA_WDFR_SMAT-UPTYP, sy-vline,
  WA_WDFR_SMAT-UPVOR, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_WDFR_SMAT 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_WDFR_SMAT 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_WDFR_SMAT INTO WA_WDFR_SMAT.


*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 MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-MATNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit CUNIT, internal->external for field MEINS
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-MEINS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-MEINS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BPRME
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-BPRME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-BPRME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BMEINS
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-BMEINS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-BMEINS.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit CUNIT, internal->external for field VRKME
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-VRKME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-VRKME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BASME
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-BASME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-BASME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field ANZME
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-ANZME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-ANZME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field INDBAS
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-INDBAS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-INDBAS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field INDANZ
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-INDANZ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-INDANZ.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field ABSMEI
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-ABSMEI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-ABSMEI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field AMEINS
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WDFR_SMAT-AMEINS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WDFR_SMAT-AMEINS.
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_WDFR_SMAT_STR, 
WERKS TYPE STRING,
MATNR TYPE STRING,
DISPNR TYPE STRING,
TABIX TYPE STRING,
SELKZ TYPE STRING,
MAKTX TYPE STRING,
EMATN TYPE STRING,
ATTYP TYPE STRING,
UEBPO TYPE STRING,
UPTYP TYPE STRING,
UPVOR TYPE STRING,
KTMNG TYPE STRING,
MENGE TYPE STRING,
PLANM TYPE STRING,
MEINS TYPE STRING,
BPRME TYPE STRING,
BPUMZ TYPE STRING,
BPUMN TYPE STRING,
UMREZ TYPE STRING,
UMREN TYPE STRING,
NETPR TYPE STRING,
PEINH TYPE STRING,
NETWR TYPE STRING,
BRTWR TYPE STRING,
WAERS TYPE STRING,
BMENGE TYPE STRING,
BMEINS TYPE STRING,
EBELN TYPE STRING,
EBELP TYPE STRING,
LOEKZ TYPE STRING,
STATU TYPE STRING,
AEDAT TYPE STRING,
LGORT TYPE STRING,
BEDNR TYPE STRING,
MATKL TYPE STRING,
INFNR TYPE STRING,
IDNLF TYPE STRING,
AGDAT TYPE STRING,
WEBAZ TYPE STRING,
MWSKZ TYPE STRING,
BONUS TYPE STRING,
INSMK TYPE STRING,
SPINF TYPE STRING,
PRSDR TYPE STRING,
SCHPR TYPE STRING,
MAHNZ TYPE STRING,
MAHN1 TYPE STRING,
MAHN2 TYPE STRING,
MAHN3 TYPE STRING,
UEBTO TYPE STRING,
UEBTK TYPE STRING,
UNTTO TYPE STRING,
BWTAR TYPE STRING,
BWTTY TYPE STRING,
ABSKZ TYPE STRING,
AGMEM TYPE STRING,
ELIKZ TYPE STRING,
EREKZ TYPE STRING,
BSART TYPE STRING,
PSTYP TYPE STRING,
KNTTP TYPE STRING,
KTMNG_ABG TYPE STRING,
BKTMNG_ABG TYPE STRING,
RANG TYPE STRING,
EKPNN TYPE STRING,
EKPGR TYPE STRING,
EKPGR_K TYPE STRING,
EKPGR_VME TYPE STRING,
SPABA TYPE STRING,
SPANE TYPE STRING,
SPANA TYPE STRING,
ENDPA TYPE STRING,
VKPNE TYPE STRING,
VRKME TYPE STRING,
HWAER TYPE STRING,
KWAER TYPE STRING,
VWAER TYPE STRING,
PROZ TYPE STRING,
MENGE_BAS TYPE STRING,
UMSMNG_BAS TYPE STRING,
UAVMNG_BAS TYPE STRING,
BVLMNG_BAS TYPE STRING,
DIFMNG_BAS TYPE STRING,
TEMMNG_BAS TYPE STRING,
LABST_BAS TYPE STRING,
ATPBST_BAS TYPE STRING,
BSTBDRF_BAS TYPE STRING,
BASME TYPE STRING,
UMSMNG_ANZ TYPE STRING,
UAVMNG_ANZ TYPE STRING,
BVLMNG_ANZ TYPE STRING,
DIFMNG_ANZ TYPE STRING,
TEMMNG_ANZ TYPE STRING,
LABST_ANZ TYPE STRING,
ATPBST_ANZ TYPE STRING,
BSTBDRF_ANZ TYPE STRING,
ANZME TYPE STRING,
INDMN1 TYPE STRING,
INDMN2 TYPE STRING,
INDMN3 TYPE STRING,
INDMN4 TYPE STRING,
INDMN5 TYPE STRING,
INDBAS TYPE STRING,
INDMA1 TYPE STRING,
INDMA2 TYPE STRING,
INDMA3 TYPE STRING,
INDMA4 TYPE STRING,
INDMA5 TYPE STRING,
INDANZ TYPE STRING,
INDPR1 TYPE STRING,
INDPR2 TYPE STRING,
INDPR3 TYPE STRING,
INDWA1 TYPE STRING,
INDWA2 TYPE STRING,
INDWA3 TYPE STRING,
INDA08 TYPE STRING,
INDA16 TYPE STRING,
INDA32 TYPE STRING,
INDA081 TYPE STRING,
INDA161 TYPE STRING,
INDA321 TYPE STRING,
INDST1 TYPE STRING,
INDST2 TYPE STRING,
INDST3 TYPE STRING,
INDST4 TYPE STRING,
INDST5 TYPE STRING,
DISART TYPE STRING,
ABGART TYPE STRING,
AUFAR TYPE STRING,
APSTP TYPE STRING,
SBELN TYPE STRING,
ASTRA TYPE STRING,
ABELN TYPE STRING,
ABELP TYPE STRING,
LISTG TYPE STRING,
RUNDG TYPE STRING,
RESTV TYPE STRING,
AAVIT TYPE STRING,
BERMIMA TYPE STRING,
BSTGE TYPE STRING,
BEZCH TYPE STRING,
AFDTP TYPE STRING,
AFDAT TYPE STRING,
VKDTP TYPE STRING,
VKDAT TYPE STRING,
FBDAT TYPE STRING,
FUDAT TYPE STRING,
FLDAT TYPE STRING,
FBDTP TYPE STRING,
FUDTP TYPE STRING,
FLDTP TYPE STRING,
WBTYP TYPE STRING,
AKTBE TYPE STRING,
I_BELNR TYPE STRING,
I_POSNR TYPE STRING,
LEIND TYPE STRING,
LZEIT TYPE STRING,
ALIFNR TYPE STRING,
ABSMNG TYPE STRING,
ABSMEI TYPE STRING,
AMENGE TYPE STRING,
AMEINS TYPE STRING,
IA_SAMMELBEST TYPE STRING,
UPDKZ TYPE STRING,
BESKZ TYPE STRING,
SATKZ TYPE STRING,
AKTKZ TYPE STRING,
ABNKZ TYPE STRING,
EINDT TYPE STRING,
BESAB TYPE STRING,
BESBI TYPE STRING,
AINDT TYPE STRING,
ABGAB TYPE STRING,
ABGBI TYPE STRING,
AUSAB TYPE STRING,
AUSBI TYPE STRING,
LFDAT_AB TYPE STRING,
LFDAT_BI TYPE STRING,
UHRAB TYPE STRING,
UHRBI TYPE STRING,
DTIME TYPE STRING,
DHOUR TYPE STRING,
CD TYPE STRING,
FT TYPE STRING,
PA TYPE STRING,
CD_FT TYPE STRING,
CD_PA TYPE STRING,
KABE TYPE STRING,
BEBE TYPE STRING,
BRBE TYPE STRING,
OPTI TYPE STRING,
AVAIL TYPE STRING,
ROULE TYPE STRING,
STOCK TYPE STRING,
SAMKZ TYPE STRING,END OF T_EKKO_STR.
DATA: WA_WDFR_SMAT_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_WDFR_SMAT_STR-WERKS sy-vline 
WA_WDFR_SMAT_STR-MATNR sy-vline 
WA_WDFR_SMAT_STR-DISPNR sy-vline 
WA_WDFR_SMAT_STR-TABIX sy-vline 
WA_WDFR_SMAT_STR-SELKZ sy-vline 
WA_WDFR_SMAT_STR-MAKTX sy-vline 
WA_WDFR_SMAT_STR-EMATN sy-vline 
WA_WDFR_SMAT_STR-ATTYP sy-vline 
WA_WDFR_SMAT_STR-UEBPO sy-vline 
WA_WDFR_SMAT_STR-UPTYP sy-vline 
WA_WDFR_SMAT_STR-UPVOR sy-vline 
WA_WDFR_SMAT_STR-KTMNG sy-vline 
WA_WDFR_SMAT_STR-MENGE sy-vline 
WA_WDFR_SMAT_STR-PLANM sy-vline 
WA_WDFR_SMAT_STR-MEINS sy-vline 
WA_WDFR_SMAT_STR-BPRME sy-vline 
WA_WDFR_SMAT_STR-BPUMZ sy-vline 
WA_WDFR_SMAT_STR-BPUMN sy-vline 
WA_WDFR_SMAT_STR-UMREZ sy-vline 
WA_WDFR_SMAT_STR-UMREN sy-vline 
WA_WDFR_SMAT_STR-NETPR sy-vline 
WA_WDFR_SMAT_STR-PEINH sy-vline 
WA_WDFR_SMAT_STR-NETWR sy-vline 
WA_WDFR_SMAT_STR-BRTWR sy-vline 
WA_WDFR_SMAT_STR-WAERS sy-vline 
WA_WDFR_SMAT_STR-BMENGE sy-vline 
WA_WDFR_SMAT_STR-BMEINS sy-vline 
WA_WDFR_SMAT_STR-EBELN sy-vline 
WA_WDFR_SMAT_STR-EBELP sy-vline 
WA_WDFR_SMAT_STR-LOEKZ sy-vline 
WA_WDFR_SMAT_STR-STATU sy-vline 
WA_WDFR_SMAT_STR-AEDAT sy-vline 
WA_WDFR_SMAT_STR-LGORT sy-vline 
WA_WDFR_SMAT_STR-BEDNR sy-vline 
WA_WDFR_SMAT_STR-MATKL sy-vline 
WA_WDFR_SMAT_STR-INFNR sy-vline 
WA_WDFR_SMAT_STR-IDNLF sy-vline 
WA_WDFR_SMAT_STR-AGDAT sy-vline 
WA_WDFR_SMAT_STR-WEBAZ sy-vline 
WA_WDFR_SMAT_STR-MWSKZ sy-vline 
WA_WDFR_SMAT_STR-BONUS sy-vline 
WA_WDFR_SMAT_STR-INSMK sy-vline 
WA_WDFR_SMAT_STR-SPINF sy-vline 
WA_WDFR_SMAT_STR-PRSDR sy-vline 
WA_WDFR_SMAT_STR-SCHPR sy-vline 
WA_WDFR_SMAT_STR-MAHNZ sy-vline 
WA_WDFR_SMAT_STR-MAHN1 sy-vline 
WA_WDFR_SMAT_STR-MAHN2 sy-vline 
WA_WDFR_SMAT_STR-MAHN3 sy-vline 
WA_WDFR_SMAT_STR-UEBTO sy-vline 
WA_WDFR_SMAT_STR-UEBTK sy-vline 
WA_WDFR_SMAT_STR-UNTTO sy-vline 
WA_WDFR_SMAT_STR-BWTAR sy-vline 
WA_WDFR_SMAT_STR-BWTTY sy-vline 
WA_WDFR_SMAT_STR-ABSKZ sy-vline 
WA_WDFR_SMAT_STR-AGMEM sy-vline 
WA_WDFR_SMAT_STR-ELIKZ sy-vline 
WA_WDFR_SMAT_STR-EREKZ sy-vline 
WA_WDFR_SMAT_STR-BSART sy-vline 
WA_WDFR_SMAT_STR-PSTYP sy-vline 
WA_WDFR_SMAT_STR-KNTTP sy-vline 
WA_WDFR_SMAT_STR-KTMNG_ABG sy-vline 
WA_WDFR_SMAT_STR-BKTMNG_ABG sy-vline 
WA_WDFR_SMAT_STR-RANG sy-vline 
WA_WDFR_SMAT_STR-EKPNN sy-vline 
WA_WDFR_SMAT_STR-EKPGR sy-vline 
WA_WDFR_SMAT_STR-EKPGR_K sy-vline 
WA_WDFR_SMAT_STR-EKPGR_VME sy-vline 
WA_WDFR_SMAT_STR-SPABA sy-vline 
WA_WDFR_SMAT_STR-SPANE sy-vline 
WA_WDFR_SMAT_STR-SPANA sy-vline 
WA_WDFR_SMAT_STR-ENDPA sy-vline 
WA_WDFR_SMAT_STR-VKPNE sy-vline 
WA_WDFR_SMAT_STR-VRKME sy-vline 
WA_WDFR_SMAT_STR-HWAER sy-vline 
WA_WDFR_SMAT_STR-KWAER sy-vline 
WA_WDFR_SMAT_STR-VWAER sy-vline 
WA_WDFR_SMAT_STR-PROZ sy-vline 
WA_WDFR_SMAT_STR-MENGE_BAS sy-vline 
WA_WDFR_SMAT_STR-UMSMNG_BAS sy-vline 
WA_WDFR_SMAT_STR-UAVMNG_BAS sy-vline 
WA_WDFR_SMAT_STR-BVLMNG_BAS sy-vline 
WA_WDFR_SMAT_STR-DIFMNG_BAS sy-vline 
WA_WDFR_SMAT_STR-TEMMNG_BAS sy-vline 
WA_WDFR_SMAT_STR-LABST_BAS sy-vline 
WA_WDFR_SMAT_STR-ATPBST_BAS sy-vline 
WA_WDFR_SMAT_STR-BSTBDRF_BAS sy-vline 
WA_WDFR_SMAT_STR-BASME sy-vline 
WA_WDFR_SMAT_STR-UMSMNG_ANZ sy-vline 
WA_WDFR_SMAT_STR-UAVMNG_ANZ sy-vline 
WA_WDFR_SMAT_STR-BVLMNG_ANZ sy-vline 
WA_WDFR_SMAT_STR-DIFMNG_ANZ sy-vline 
WA_WDFR_SMAT_STR-TEMMNG_ANZ sy-vline 
WA_WDFR_SMAT_STR-LABST_ANZ sy-vline 
WA_WDFR_SMAT_STR-ATPBST_ANZ sy-vline 
WA_WDFR_SMAT_STR-BSTBDRF_ANZ sy-vline 
WA_WDFR_SMAT_STR-ANZME sy-vline 
WA_WDFR_SMAT_STR-INDMN1 sy-vline 
WA_WDFR_SMAT_STR-INDMN2 sy-vline 
WA_WDFR_SMAT_STR-INDMN3 sy-vline 
WA_WDFR_SMAT_STR-INDMN4 sy-vline 
WA_WDFR_SMAT_STR-INDMN5 sy-vline 
WA_WDFR_SMAT_STR-INDBAS sy-vline 
WA_WDFR_SMAT_STR-INDMA1 sy-vline 
WA_WDFR_SMAT_STR-INDMA2 sy-vline 
WA_WDFR_SMAT_STR-INDMA3 sy-vline 
WA_WDFR_SMAT_STR-INDMA4 sy-vline 
WA_WDFR_SMAT_STR-INDMA5 sy-vline 
WA_WDFR_SMAT_STR-INDANZ sy-vline 
WA_WDFR_SMAT_STR-INDPR1 sy-vline 
WA_WDFR_SMAT_STR-INDPR2 sy-vline 
WA_WDFR_SMAT_STR-INDPR3 sy-vline 
WA_WDFR_SMAT_STR-INDWA1 sy-vline 
WA_WDFR_SMAT_STR-INDWA2 sy-vline 
WA_WDFR_SMAT_STR-INDWA3 sy-vline 
WA_WDFR_SMAT_STR-INDA08 sy-vline 
WA_WDFR_SMAT_STR-INDA16 sy-vline 
WA_WDFR_SMAT_STR-INDA32 sy-vline 
WA_WDFR_SMAT_STR-INDA081 sy-vline 
WA_WDFR_SMAT_STR-INDA161 sy-vline 
WA_WDFR_SMAT_STR-INDA321 sy-vline 
WA_WDFR_SMAT_STR-INDST1 sy-vline 
WA_WDFR_SMAT_STR-INDST2 sy-vline 
WA_WDFR_SMAT_STR-INDST3 sy-vline 
WA_WDFR_SMAT_STR-INDST4 sy-vline 
WA_WDFR_SMAT_STR-INDST5 sy-vline 
WA_WDFR_SMAT_STR-DISART sy-vline 
WA_WDFR_SMAT_STR-ABGART sy-vline 
WA_WDFR_SMAT_STR-AUFAR sy-vline 
WA_WDFR_SMAT_STR-APSTP sy-vline 
WA_WDFR_SMAT_STR-SBELN sy-vline 
WA_WDFR_SMAT_STR-ASTRA sy-vline 
WA_WDFR_SMAT_STR-ABELN sy-vline 
WA_WDFR_SMAT_STR-ABELP sy-vline 
WA_WDFR_SMAT_STR-LISTG sy-vline 
WA_WDFR_SMAT_STR-RUNDG sy-vline 
WA_WDFR_SMAT_STR-RESTV sy-vline 
WA_WDFR_SMAT_STR-AAVIT sy-vline 
WA_WDFR_SMAT_STR-BERMIMA sy-vline 
WA_WDFR_SMAT_STR-BSTGE sy-vline 
WA_WDFR_SMAT_STR-BEZCH sy-vline 
WA_WDFR_SMAT_STR-AFDTP sy-vline 
WA_WDFR_SMAT_STR-AFDAT sy-vline 
WA_WDFR_SMAT_STR-VKDTP sy-vline 
WA_WDFR_SMAT_STR-VKDAT sy-vline 
WA_WDFR_SMAT_STR-FBDAT sy-vline 
WA_WDFR_SMAT_STR-FUDAT sy-vline 
WA_WDFR_SMAT_STR-FLDAT sy-vline 
WA_WDFR_SMAT_STR-FBDTP sy-vline 
WA_WDFR_SMAT_STR-FUDTP sy-vline 
WA_WDFR_SMAT_STR-FLDTP sy-vline 
WA_WDFR_SMAT_STR-WBTYP sy-vline 
WA_WDFR_SMAT_STR-AKTBE sy-vline 
WA_WDFR_SMAT_STR-I_BELNR sy-vline 
WA_WDFR_SMAT_STR-I_POSNR sy-vline 
WA_WDFR_SMAT_STR-LEIND sy-vline 
WA_WDFR_SMAT_STR-LZEIT sy-vline 
WA_WDFR_SMAT_STR-ALIFNR sy-vline 
WA_WDFR_SMAT_STR-ABSMNG sy-vline 
WA_WDFR_SMAT_STR-ABSMEI sy-vline 
WA_WDFR_SMAT_STR-AMENGE sy-vline 
WA_WDFR_SMAT_STR-AMEINS sy-vline 
WA_WDFR_SMAT_STR-IA_SAMMELBEST sy-vline 
WA_WDFR_SMAT_STR-UPDKZ sy-vline 
WA_WDFR_SMAT_STR-BESKZ sy-vline 
WA_WDFR_SMAT_STR-SATKZ sy-vline 
WA_WDFR_SMAT_STR-AKTKZ sy-vline 
WA_WDFR_SMAT_STR-ABNKZ sy-vline 
WA_WDFR_SMAT_STR-EINDT sy-vline 
WA_WDFR_SMAT_STR-BESAB sy-vline 
WA_WDFR_SMAT_STR-BESBI sy-vline 
WA_WDFR_SMAT_STR-AINDT sy-vline 
WA_WDFR_SMAT_STR-ABGAB sy-vline 
WA_WDFR_SMAT_STR-ABGBI sy-vline 
WA_WDFR_SMAT_STR-AUSAB sy-vline 
WA_WDFR_SMAT_STR-AUSBI sy-vline 
WA_WDFR_SMAT_STR-LFDAT_AB sy-vline 
WA_WDFR_SMAT_STR-LFDAT_BI sy-vline 
WA_WDFR_SMAT_STR-UHRAB sy-vline 
WA_WDFR_SMAT_STR-UHRBI sy-vline 
WA_WDFR_SMAT_STR-DTIME sy-vline 
WA_WDFR_SMAT_STR-DHOUR sy-vline 
WA_WDFR_SMAT_STR-CD sy-vline 
WA_WDFR_SMAT_STR-FT sy-vline 
WA_WDFR_SMAT_STR-PA sy-vline 
WA_WDFR_SMAT_STR-CD_FT sy-vline 
WA_WDFR_SMAT_STR-CD_PA sy-vline 
WA_WDFR_SMAT_STR-KABE sy-vline 
WA_WDFR_SMAT_STR-BEBE sy-vline 
WA_WDFR_SMAT_STR-BRBE sy-vline 
WA_WDFR_SMAT_STR-OPTI sy-vline 
WA_WDFR_SMAT_STR-AVAIL sy-vline 
WA_WDFR_SMAT_STR-ROULE sy-vline 
WA_WDFR_SMAT_STR-STOCK sy-vline 
WA_WDFR_SMAT_STR-SAMKZ sy-vline      INTO ld_text SEPARATED BY SPACE.

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