ABAP Select data from SAP table WB2_V_MATDOC 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 WB2_V_MATDOC 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 WB2_V_MATDOC. 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 WB2_V_MATDOC 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_WB2_V_MATDOC TYPE STANDARD TABLE OF WB2_V_MATDOC,
      WA_WB2_V_MATDOC TYPE WB2_V_MATDOC,
      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: <WB2_V_MATDOC> TYPE WB2_V_MATDOC.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM WB2_V_MATDOC
*  INTO TABLE @DATA(IT_WB2_V_MATDOC2).
*--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_WB2_V_MATDOC INDEX 1 INTO DATA(WA_WB2_V_MATDOC2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<WB2_V_MATDOC>-MANDT = 1.
<WB2_V_MATDOC>-MBLNR = 1.
<WB2_V_MATDOC>-MJAHR = 1.
<WB2_V_MATDOC>-MANDT_I = 1.
<WB2_V_MATDOC>-MBLNR_I = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_WB2_V_MATDOC-MJAHR_I, sy-vline,
  WA_WB2_V_MATDOC-ZEILE_I, sy-vline,
  WA_WB2_V_MATDOC-VGART, sy-vline,
  WA_WB2_V_MATDOC-BLART, sy-vline,
  WA_WB2_V_MATDOC-BLAUM, sy-vline,
  WA_WB2_V_MATDOC-BLDAT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_WB2_V_MATDOC 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_WB2_V_MATDOC 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_WB2_V_MATDOC INTO WA_WB2_V_MATDOC.


*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 ALPHA, internal->external for field MBLNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_WB2_V_MATDOC-MBLNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_MATDOC-MBLNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MJAHR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_WB2_V_MATDOC-MJAHR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_MATDOC-MJAHR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field MJAHR_I
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_WB2_V_MATDOC-MJAHR_I
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_MATDOC-MJAHR_I.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

*Conversion exit GJAHR, internal->external for field LFBJA_I
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_WB2_V_MATDOC-LFBJA_I
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_MATDOC-LFBJA_I.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field SJAHR_I
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_WB2_V_MATDOC-SJAHR_I
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_MATDOC-SJAHR_I.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit GJAHR, internal->external for field GJAHR_I
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_WB2_V_MATDOC-GJAHR_I
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_MATDOC-GJAHR_I.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit IMKEY, internal->external for field IMKEY_I
CALL FUNCTION 'CONVERSION_EXIT_IMKEY_OUTPUT'
  EXPORTING
    input =                      WA_WB2_V_MATDOC-IMKEY_I
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_MATDOC-IMKEY_I.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit FMCIS, internal->external for field FIPOS_I
CALL FUNCTION 'CONVERSION_EXIT_FMCIS_OUTPUT'
  EXPORTING
    input =                      WA_WB2_V_MATDOC-FIPOS_I
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_MATDOC-FIPOS_I.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field LLIEF_I
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_WB2_V_MATDOC-LLIEF_I
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_MATDOC-LLIEF_I.
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_WB2_V_MATDOC_STR, 
MANDT TYPE STRING,
MBLNR TYPE STRING,
MJAHR TYPE STRING,
MANDT_I TYPE STRING,
MBLNR_I TYPE STRING,
MJAHR_I TYPE STRING,
ZEILE_I TYPE STRING,
VGART TYPE STRING,
BLART TYPE STRING,
BLAUM TYPE STRING,
BLDAT TYPE STRING,
BUDAT TYPE STRING,
CPUDT TYPE STRING,
CPUTM TYPE STRING,
AEDAT TYPE STRING,
USNAM TYPE STRING,
TCODE TYPE STRING,
XBLNR TYPE STRING,
BKTXT TYPE STRING,
FRATH TYPE STRING,
FRBNR TYPE STRING,
WEVER TYPE STRING,
XABLN TYPE STRING,
AWSYS TYPE STRING,
BLA2D TYPE STRING,
TCODE2 TYPE STRING,
BFWMS TYPE STRING,
EXNUM TYPE STRING,
LINE_ID_I TYPE STRING,
PARENT_ID_I TYPE STRING,
LINE_DEPTH_I TYPE STRING,
BWART_I TYPE STRING,
XAUTO_I TYPE STRING,
MATNR_I TYPE STRING,
WERKS_I TYPE STRING,
LGORT_I TYPE STRING,
CHARG_I TYPE STRING,
INSMK_I TYPE STRING,
ZUSCH_I TYPE STRING,
ZUSTD_I TYPE STRING,
SOBKZ_I TYPE STRING,
LIFNR_I TYPE STRING,
KUNNR_I TYPE STRING,
KDAUF_I TYPE STRING,
KDPOS_I TYPE STRING,
KDEIN_I TYPE STRING,
PLPLA_I TYPE STRING,
SHKZG_I TYPE STRING,
WAERS_I TYPE STRING,
DMBTR_I TYPE STRING,
BNBTR_I TYPE STRING,
BUALT_I TYPE STRING,
SHKUM_I TYPE STRING,
DMBUM_I TYPE STRING,
BWTAR_I TYPE STRING,
MENGE_I TYPE STRING,
MEINS_I TYPE STRING,
ERFMG_I TYPE STRING,
ERFME_I TYPE STRING,
BPMNG_I TYPE STRING,
BPRME_I TYPE STRING,
EBELN_I TYPE STRING,
EBELP_I TYPE STRING,
LFBJA_I TYPE STRING,
LFBNR_I TYPE STRING,
LFPOS_I TYPE STRING,
SJAHR_I TYPE STRING,
SMBLN_I TYPE STRING,
SMBLP_I TYPE STRING,
ELIKZ_I TYPE STRING,
SGTXT_I TYPE STRING,
EQUNR_I TYPE STRING,
WEMPF_I TYPE STRING,
ABLAD_I TYPE STRING,
GSBER_I TYPE STRING,
KOKRS_I TYPE STRING,
PARGB_I TYPE STRING,
PARBU_I TYPE STRING,
KOSTL_I TYPE STRING,
PROJN_I TYPE STRING,
AUFNR_I TYPE STRING,
ANLN1_I TYPE STRING,
ANLN2_I TYPE STRING,
XSKST_I TYPE STRING,
XSAUF_I TYPE STRING,
XSPRO_I TYPE STRING,
XSERG_I TYPE STRING,
GJAHR_I TYPE STRING,
XRUEM_I TYPE STRING,
XRUEJ_I TYPE STRING,
BUKRS_I TYPE STRING,
BELNR_I TYPE STRING,
BUZEI_I TYPE STRING,
BELUM_I TYPE STRING,
BUZUM_I TYPE STRING,
RSNUM_I TYPE STRING,
RSPOS_I TYPE STRING,
KZEAR_I TYPE STRING,
PBAMG_I TYPE STRING,
KZSTR_I TYPE STRING,
UMMAT_I TYPE STRING,
UMWRK_I TYPE STRING,
UMLGO_I TYPE STRING,
UMCHA_I TYPE STRING,
UMZST_I TYPE STRING,
UMZUS_I TYPE STRING,
UMBAR_I TYPE STRING,
UMSOK_I TYPE STRING,
KZBEW_I TYPE STRING,
KZVBR_I TYPE STRING,
KZZUG_I TYPE STRING,
WEUNB_I TYPE STRING,
PALAN_I TYPE STRING,
LGNUM_I TYPE STRING,
LGTYP_I TYPE STRING,
LGPLA_I TYPE STRING,
BESTQ_I TYPE STRING,
BWLVS_I TYPE STRING,
TBNUM_I TYPE STRING,
TBPOS_I TYPE STRING,
XBLVS_I TYPE STRING,
VSCHN_I TYPE STRING,
NSCHN_I TYPE STRING,
DYPLA_I TYPE STRING,
UBNUM_I TYPE STRING,
TBPRI_I TYPE STRING,
TANUM_I TYPE STRING,
WEANZ_I TYPE STRING,
GRUND_I TYPE STRING,
EVERS_I TYPE STRING,
EVERE_I TYPE STRING,
IMKEY_I TYPE STRING,
KSTRG_I TYPE STRING,
PAOBJNR_I TYPE STRING,
PRCTR_I TYPE STRING,
PS_PSP_PNR_I TYPE STRING,
NPLNR_I TYPE STRING,
AUFPL_I TYPE STRING,
APLZL_I TYPE STRING,
AUFPS_I TYPE STRING,
VPTNR_I TYPE STRING,
FIPOS_I TYPE STRING,
SAKTO_I TYPE STRING,
BSTMG_I TYPE STRING,
BSTME_I TYPE STRING,
XWSBR_I TYPE STRING,
EMLIF_I TYPE STRING,
EXBWR_I TYPE STRING,
VKWRT_I TYPE STRING,
AKTNR_I TYPE STRING,
ZEKKN_I TYPE STRING,
VFDAT_I TYPE STRING,
CUOBJ_CH_I TYPE STRING,
EXVKW_I TYPE STRING,
PPRCTR_I TYPE STRING,
RSART_I TYPE STRING,
GEBER_I TYPE STRING,
FISTL_I TYPE STRING,
MATBF_I TYPE STRING,
UMMAB_I TYPE STRING,
BUSTM_I TYPE STRING,
BUSTW_I TYPE STRING,
MENGU_I TYPE STRING,
WERTU_I TYPE STRING,
LBKUM_I TYPE STRING,
SALK3_I TYPE STRING,
VPRSV_I TYPE STRING,
FKBER_I TYPE STRING,
DABRBZ_I TYPE STRING,
VKWRA_I TYPE STRING,
DABRZ_I TYPE STRING,
XBEAU_I TYPE STRING,
LSMNG_I TYPE STRING,
LSMEH_I TYPE STRING,
KZBWS_I TYPE STRING,
QINSPST_I TYPE STRING,
URZEI_I TYPE STRING,
J_1BEXBASE_I TYPE STRING,
MWSKZ_I TYPE STRING,
TXJCD_I TYPE STRING,
EMATN_I TYPE STRING,
J_1AGIRUPD_I TYPE STRING,
VKMWS_I TYPE STRING,
HSDAT_I TYPE STRING,
BERKZ_I TYPE STRING,
MAT_KDAUF_I TYPE STRING,
MAT_KDPOS_I TYPE STRING,
MAT_PSPNR_I TYPE STRING,
XWOFF_I TYPE STRING,
BEMOT_I TYPE STRING,
PRZNR_I TYPE STRING,
LLIEF_I TYPE STRING,
LSTAR_I TYPE STRING,
XOBEW_I TYPE STRING,END OF T_EKKO_STR.
DATA: WA_WB2_V_MATDOC_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_WB2_V_MATDOC_STR-MANDT sy-vline 
WA_WB2_V_MATDOC_STR-MBLNR sy-vline 
WA_WB2_V_MATDOC_STR-MJAHR sy-vline 
WA_WB2_V_MATDOC_STR-MANDT_I sy-vline 
WA_WB2_V_MATDOC_STR-MBLNR_I sy-vline 
WA_WB2_V_MATDOC_STR-MJAHR_I sy-vline 
WA_WB2_V_MATDOC_STR-ZEILE_I sy-vline 
WA_WB2_V_MATDOC_STR-VGART sy-vline 
WA_WB2_V_MATDOC_STR-BLART sy-vline 
WA_WB2_V_MATDOC_STR-BLAUM sy-vline 
WA_WB2_V_MATDOC_STR-BLDAT sy-vline 
WA_WB2_V_MATDOC_STR-BUDAT sy-vline 
WA_WB2_V_MATDOC_STR-CPUDT sy-vline 
WA_WB2_V_MATDOC_STR-CPUTM sy-vline 
WA_WB2_V_MATDOC_STR-AEDAT sy-vline 
WA_WB2_V_MATDOC_STR-USNAM sy-vline 
WA_WB2_V_MATDOC_STR-TCODE sy-vline 
WA_WB2_V_MATDOC_STR-XBLNR sy-vline 
WA_WB2_V_MATDOC_STR-BKTXT sy-vline 
WA_WB2_V_MATDOC_STR-FRATH sy-vline 
WA_WB2_V_MATDOC_STR-FRBNR sy-vline 
WA_WB2_V_MATDOC_STR-WEVER sy-vline 
WA_WB2_V_MATDOC_STR-XABLN sy-vline 
WA_WB2_V_MATDOC_STR-AWSYS sy-vline 
WA_WB2_V_MATDOC_STR-BLA2D sy-vline 
WA_WB2_V_MATDOC_STR-TCODE2 sy-vline 
WA_WB2_V_MATDOC_STR-BFWMS sy-vline 
WA_WB2_V_MATDOC_STR-EXNUM sy-vline 
WA_WB2_V_MATDOC_STR-LINE_ID_I sy-vline 
WA_WB2_V_MATDOC_STR-PARENT_ID_I sy-vline 
WA_WB2_V_MATDOC_STR-LINE_DEPTH_I sy-vline 
WA_WB2_V_MATDOC_STR-BWART_I sy-vline 
WA_WB2_V_MATDOC_STR-XAUTO_I sy-vline 
WA_WB2_V_MATDOC_STR-MATNR_I sy-vline 
WA_WB2_V_MATDOC_STR-WERKS_I sy-vline 
WA_WB2_V_MATDOC_STR-LGORT_I sy-vline 
WA_WB2_V_MATDOC_STR-CHARG_I sy-vline 
WA_WB2_V_MATDOC_STR-INSMK_I sy-vline 
WA_WB2_V_MATDOC_STR-ZUSCH_I sy-vline 
WA_WB2_V_MATDOC_STR-ZUSTD_I sy-vline 
WA_WB2_V_MATDOC_STR-SOBKZ_I sy-vline 
WA_WB2_V_MATDOC_STR-LIFNR_I sy-vline 
WA_WB2_V_MATDOC_STR-KUNNR_I sy-vline 
WA_WB2_V_MATDOC_STR-KDAUF_I sy-vline 
WA_WB2_V_MATDOC_STR-KDPOS_I sy-vline 
WA_WB2_V_MATDOC_STR-KDEIN_I sy-vline 
WA_WB2_V_MATDOC_STR-PLPLA_I sy-vline 
WA_WB2_V_MATDOC_STR-SHKZG_I sy-vline 
WA_WB2_V_MATDOC_STR-WAERS_I sy-vline 
WA_WB2_V_MATDOC_STR-DMBTR_I sy-vline 
WA_WB2_V_MATDOC_STR-BNBTR_I sy-vline 
WA_WB2_V_MATDOC_STR-BUALT_I sy-vline 
WA_WB2_V_MATDOC_STR-SHKUM_I sy-vline 
WA_WB2_V_MATDOC_STR-DMBUM_I sy-vline 
WA_WB2_V_MATDOC_STR-BWTAR_I sy-vline 
WA_WB2_V_MATDOC_STR-MENGE_I sy-vline 
WA_WB2_V_MATDOC_STR-MEINS_I sy-vline 
WA_WB2_V_MATDOC_STR-ERFMG_I sy-vline 
WA_WB2_V_MATDOC_STR-ERFME_I sy-vline 
WA_WB2_V_MATDOC_STR-BPMNG_I sy-vline 
WA_WB2_V_MATDOC_STR-BPRME_I sy-vline 
WA_WB2_V_MATDOC_STR-EBELN_I sy-vline 
WA_WB2_V_MATDOC_STR-EBELP_I sy-vline 
WA_WB2_V_MATDOC_STR-LFBJA_I sy-vline 
WA_WB2_V_MATDOC_STR-LFBNR_I sy-vline 
WA_WB2_V_MATDOC_STR-LFPOS_I sy-vline 
WA_WB2_V_MATDOC_STR-SJAHR_I sy-vline 
WA_WB2_V_MATDOC_STR-SMBLN_I sy-vline 
WA_WB2_V_MATDOC_STR-SMBLP_I sy-vline 
WA_WB2_V_MATDOC_STR-ELIKZ_I sy-vline 
WA_WB2_V_MATDOC_STR-SGTXT_I sy-vline 
WA_WB2_V_MATDOC_STR-EQUNR_I sy-vline 
WA_WB2_V_MATDOC_STR-WEMPF_I sy-vline 
WA_WB2_V_MATDOC_STR-ABLAD_I sy-vline 
WA_WB2_V_MATDOC_STR-GSBER_I sy-vline 
WA_WB2_V_MATDOC_STR-KOKRS_I sy-vline 
WA_WB2_V_MATDOC_STR-PARGB_I sy-vline 
WA_WB2_V_MATDOC_STR-PARBU_I sy-vline 
WA_WB2_V_MATDOC_STR-KOSTL_I sy-vline 
WA_WB2_V_MATDOC_STR-PROJN_I sy-vline 
WA_WB2_V_MATDOC_STR-AUFNR_I sy-vline 
WA_WB2_V_MATDOC_STR-ANLN1_I sy-vline 
WA_WB2_V_MATDOC_STR-ANLN2_I sy-vline 
WA_WB2_V_MATDOC_STR-XSKST_I sy-vline 
WA_WB2_V_MATDOC_STR-XSAUF_I sy-vline 
WA_WB2_V_MATDOC_STR-XSPRO_I sy-vline 
WA_WB2_V_MATDOC_STR-XSERG_I sy-vline 
WA_WB2_V_MATDOC_STR-GJAHR_I sy-vline 
WA_WB2_V_MATDOC_STR-XRUEM_I sy-vline 
WA_WB2_V_MATDOC_STR-XRUEJ_I sy-vline 
WA_WB2_V_MATDOC_STR-BUKRS_I sy-vline 
WA_WB2_V_MATDOC_STR-BELNR_I sy-vline 
WA_WB2_V_MATDOC_STR-BUZEI_I sy-vline 
WA_WB2_V_MATDOC_STR-BELUM_I sy-vline 
WA_WB2_V_MATDOC_STR-BUZUM_I sy-vline 
WA_WB2_V_MATDOC_STR-RSNUM_I sy-vline 
WA_WB2_V_MATDOC_STR-RSPOS_I sy-vline 
WA_WB2_V_MATDOC_STR-KZEAR_I sy-vline 
WA_WB2_V_MATDOC_STR-PBAMG_I sy-vline 
WA_WB2_V_MATDOC_STR-KZSTR_I sy-vline 
WA_WB2_V_MATDOC_STR-UMMAT_I sy-vline 
WA_WB2_V_MATDOC_STR-UMWRK_I sy-vline 
WA_WB2_V_MATDOC_STR-UMLGO_I sy-vline 
WA_WB2_V_MATDOC_STR-UMCHA_I sy-vline 
WA_WB2_V_MATDOC_STR-UMZST_I sy-vline 
WA_WB2_V_MATDOC_STR-UMZUS_I sy-vline 
WA_WB2_V_MATDOC_STR-UMBAR_I sy-vline 
WA_WB2_V_MATDOC_STR-UMSOK_I sy-vline 
WA_WB2_V_MATDOC_STR-KZBEW_I sy-vline 
WA_WB2_V_MATDOC_STR-KZVBR_I sy-vline 
WA_WB2_V_MATDOC_STR-KZZUG_I sy-vline 
WA_WB2_V_MATDOC_STR-WEUNB_I sy-vline 
WA_WB2_V_MATDOC_STR-PALAN_I sy-vline 
WA_WB2_V_MATDOC_STR-LGNUM_I sy-vline 
WA_WB2_V_MATDOC_STR-LGTYP_I sy-vline 
WA_WB2_V_MATDOC_STR-LGPLA_I sy-vline 
WA_WB2_V_MATDOC_STR-BESTQ_I sy-vline 
WA_WB2_V_MATDOC_STR-BWLVS_I sy-vline 
WA_WB2_V_MATDOC_STR-TBNUM_I sy-vline 
WA_WB2_V_MATDOC_STR-TBPOS_I sy-vline 
WA_WB2_V_MATDOC_STR-XBLVS_I sy-vline 
WA_WB2_V_MATDOC_STR-VSCHN_I sy-vline 
WA_WB2_V_MATDOC_STR-NSCHN_I sy-vline 
WA_WB2_V_MATDOC_STR-DYPLA_I sy-vline 
WA_WB2_V_MATDOC_STR-UBNUM_I sy-vline 
WA_WB2_V_MATDOC_STR-TBPRI_I sy-vline 
WA_WB2_V_MATDOC_STR-TANUM_I sy-vline 
WA_WB2_V_MATDOC_STR-WEANZ_I sy-vline 
WA_WB2_V_MATDOC_STR-GRUND_I sy-vline 
WA_WB2_V_MATDOC_STR-EVERS_I sy-vline 
WA_WB2_V_MATDOC_STR-EVERE_I sy-vline 
WA_WB2_V_MATDOC_STR-IMKEY_I sy-vline 
WA_WB2_V_MATDOC_STR-KSTRG_I sy-vline 
WA_WB2_V_MATDOC_STR-PAOBJNR_I sy-vline 
WA_WB2_V_MATDOC_STR-PRCTR_I sy-vline 
WA_WB2_V_MATDOC_STR-PS_PSP_PNR_I sy-vline 
WA_WB2_V_MATDOC_STR-NPLNR_I sy-vline 
WA_WB2_V_MATDOC_STR-AUFPL_I sy-vline 
WA_WB2_V_MATDOC_STR-APLZL_I sy-vline 
WA_WB2_V_MATDOC_STR-AUFPS_I sy-vline 
WA_WB2_V_MATDOC_STR-VPTNR_I sy-vline 
WA_WB2_V_MATDOC_STR-FIPOS_I sy-vline 
WA_WB2_V_MATDOC_STR-SAKTO_I sy-vline 
WA_WB2_V_MATDOC_STR-BSTMG_I sy-vline 
WA_WB2_V_MATDOC_STR-BSTME_I sy-vline 
WA_WB2_V_MATDOC_STR-XWSBR_I sy-vline 
WA_WB2_V_MATDOC_STR-EMLIF_I sy-vline 
WA_WB2_V_MATDOC_STR-EXBWR_I sy-vline 
WA_WB2_V_MATDOC_STR-VKWRT_I sy-vline 
WA_WB2_V_MATDOC_STR-AKTNR_I sy-vline 
WA_WB2_V_MATDOC_STR-ZEKKN_I sy-vline 
WA_WB2_V_MATDOC_STR-VFDAT_I sy-vline 
WA_WB2_V_MATDOC_STR-CUOBJ_CH_I sy-vline 
WA_WB2_V_MATDOC_STR-EXVKW_I sy-vline 
WA_WB2_V_MATDOC_STR-PPRCTR_I sy-vline 
WA_WB2_V_MATDOC_STR-RSART_I sy-vline 
WA_WB2_V_MATDOC_STR-GEBER_I sy-vline 
WA_WB2_V_MATDOC_STR-FISTL_I sy-vline 
WA_WB2_V_MATDOC_STR-MATBF_I sy-vline 
WA_WB2_V_MATDOC_STR-UMMAB_I sy-vline 
WA_WB2_V_MATDOC_STR-BUSTM_I sy-vline 
WA_WB2_V_MATDOC_STR-BUSTW_I sy-vline 
WA_WB2_V_MATDOC_STR-MENGU_I sy-vline 
WA_WB2_V_MATDOC_STR-WERTU_I sy-vline 
WA_WB2_V_MATDOC_STR-LBKUM_I sy-vline 
WA_WB2_V_MATDOC_STR-SALK3_I sy-vline 
WA_WB2_V_MATDOC_STR-VPRSV_I sy-vline 
WA_WB2_V_MATDOC_STR-FKBER_I sy-vline 
WA_WB2_V_MATDOC_STR-DABRBZ_I sy-vline 
WA_WB2_V_MATDOC_STR-VKWRA_I sy-vline 
WA_WB2_V_MATDOC_STR-DABRZ_I sy-vline 
WA_WB2_V_MATDOC_STR-XBEAU_I sy-vline 
WA_WB2_V_MATDOC_STR-LSMNG_I sy-vline 
WA_WB2_V_MATDOC_STR-LSMEH_I sy-vline 
WA_WB2_V_MATDOC_STR-KZBWS_I sy-vline 
WA_WB2_V_MATDOC_STR-QINSPST_I sy-vline 
WA_WB2_V_MATDOC_STR-URZEI_I sy-vline 
WA_WB2_V_MATDOC_STR-J_1BEXBASE_I sy-vline 
WA_WB2_V_MATDOC_STR-MWSKZ_I sy-vline 
WA_WB2_V_MATDOC_STR-TXJCD_I sy-vline 
WA_WB2_V_MATDOC_STR-EMATN_I sy-vline 
WA_WB2_V_MATDOC_STR-J_1AGIRUPD_I sy-vline 
WA_WB2_V_MATDOC_STR-VKMWS_I sy-vline 
WA_WB2_V_MATDOC_STR-HSDAT_I sy-vline 
WA_WB2_V_MATDOC_STR-BERKZ_I sy-vline 
WA_WB2_V_MATDOC_STR-MAT_KDAUF_I sy-vline 
WA_WB2_V_MATDOC_STR-MAT_KDPOS_I sy-vline 
WA_WB2_V_MATDOC_STR-MAT_PSPNR_I sy-vline 
WA_WB2_V_MATDOC_STR-XWOFF_I sy-vline 
WA_WB2_V_MATDOC_STR-BEMOT_I sy-vline 
WA_WB2_V_MATDOC_STR-PRZNR_I sy-vline 
WA_WB2_V_MATDOC_STR-LLIEF_I sy-vline 
WA_WB2_V_MATDOC_STR-LSTAR_I sy-vline 
WA_WB2_V_MATDOC_STR-XOBEW_I sy-vline      INTO ld_text SEPARATED BY SPACE.

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