ABAP Select data from SAP table SERCHZ 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 SERCHZ 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 SERCHZ. 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 SERCHZ 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_SERCHZ TYPE STANDARD TABLE OF SERCHZ,
      WA_SERCHZ TYPE SERCHZ,
      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: <SERCHZ> TYPE SERCHZ.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SERCHZ
*  INTO TABLE @DATA(IT_SERCHZ2).
*--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_SERCHZ INDEX 1 INTO DATA(WA_SERCHZ2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<SERCHZ>-MANDT = 1.
<SERCHZ>-BELNR = 1.
<SERCHZ>-BELZEILE = 1.
<SERCHZ>-UNIMPORTANT = 1.
<SERCHZ>-GROSSBLOCK = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SERCHZ-OLD_ERCHZ, sy-vline,
  WA_SERCHZ-ISTYPE, sy-vline,
  WA_SERCHZ-CSNO, sy-vline,
  WA_SERCHZ-BELZART, sy-vline,
  WA_SERCHZ-ABSLKZ, sy-vline,
  WA_SERCHZ-DIFFKZ, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_SERCHZ 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_SERCHZ 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_SERCHZ INTO WA_SERCHZ.


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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit GERNR, internal->external for field GERAET
CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT'
  EXPORTING
    input =                      WA_SERCHZ-GERAET
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SERCHZ-GERAET.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit HH_MM, internal->external for field ATIM
CALL FUNCTION 'CONVERSION_EXIT_HH_MM_OUTPUT'
  EXPORTING
    input =                      WA_SERCHZ-ATIM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SERCHZ-ATIM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit HH_MM, internal->external for field ATIMVA
CALL FUNCTION 'CONVERSION_EXIT_HH_MM_OUTPUT'
  EXPORTING
    input =                      WA_SERCHZ-ATIMVA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SERCHZ-ATIMVA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit HH_MM, internal->external for field ATIMMAX
CALL FUNCTION 'CONVERSION_EXIT_HH_MM_OUTPUT'
  EXPORTING
    input =                      WA_SERCHZ-ATIMMAX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SERCHZ-ATIMMAX.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit EXCRT, internal->external for field UMRECHKURS
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_SERCHZ-UMRECHKURS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SERCHZ-UMRECHKURS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field REC_CONTRACT
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SERCHZ-REC_CONTRACT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SERCHZ-REC_CONTRACT.
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_SERCHZ_STR, 
MANDT TYPE STRING,
BELNR TYPE STRING,
BELZEILE TYPE STRING,
UNIMPORTANT TYPE STRING,
GROSSBLOCK TYPE STRING,
OLD_ERCHZ TYPE STRING,
ISTYPE TYPE STRING,
CSNO TYPE STRING,
BELZART TYPE STRING,
ABSLKZ TYPE STRING,
DIFFKZ TYPE STRING,
BUCHREL TYPE STRING,
MENGESTREL TYPE STRING,
BETRSTREL TYPE STRING,
STGRQNT TYPE STRING,
STGRAMT TYPE STRING,
PRINTREL TYPE STRING,
AKLASSE TYPE STRING,
BRANCHE TYPE STRING,
TVORG TYPE STRING,
GEGEN_TVORG TYPE STRING,
TAX_TVORG TYPE STRING,
LINESORT TYPE STRING,
AB TYPE STRING,
BIS TYPE STRING,
TIMTYPZA TYPE STRING,
SCHEMANR TYPE STRING,
SNO TYPE STRING,
PROGRAMM TYPE STRING,
MASSBILL TYPE STRING,
SAISON TYPE STRING,
TIMBASIS TYPE STRING,
TIMTYP TYPE STRING,
FRAN_TYPE TYPE STRING,
KONZIGR TYPE STRING,
TARIFTYP TYPE STRING,
TARIFNR TYPE STRING,
KONDIGR TYPE STRING,
STTARIF TYPE STRING,
GEWKEY TYPE STRING,
WDHFAKT TYPE STRING,
TEMP_AREA TYPE STRING,
DRCKSTUF TYPE STRING,
ABGGRND1 TYPE STRING,
ABGGRND2 TYPE STRING,
ABGGRND3 TYPE STRING,
ABGGRND4 TYPE STRING,
ABGGRND5 TYPE STRING,
ABGGRND6 TYPE STRING,
ABGGRND7 TYPE STRING,
ABGGRND8 TYPE STRING,
ABGGRND9 TYPE STRING,
ABGGRND10 TYPE STRING,
EIN01 TYPE STRING,
EIN02 TYPE STRING,
EIN03 TYPE STRING,
EIN04 TYPE STRING,
AUS01 TYPE STRING,
AUS02 TYPE STRING,
MASS1 TYPE STRING,
MASS2 TYPE STRING,
MASS3 TYPE STRING,
MASS4 TYPE STRING,
DATUM1 TYPE STRING,
DATUM2 TYPE STRING,
RABZUS TYPE STRING,
BACKCANC01 TYPE STRING,
BACKCANC02 TYPE STRING,
BACKCANC03 TYPE STRING,
BACKCANC04 TYPE STRING,
BACKCANC05 TYPE STRING,
BACKCANC TYPE STRING,
BACKEXEC TYPE STRING,
BACKDOCNO TYPE STRING,
BACKDOCLINE TYPE STRING,
DYNCANC01 TYPE STRING,
DYNCANC02 TYPE STRING,
DYNCANC03 TYPE STRING,
DYNCANC04 TYPE STRING,
DYNCANC05 TYPE STRING,
DYNCANC TYPE STRING,
DYNEXEC TYPE STRING,
LRATESTEP TYPE STRING,
PEB TYPE STRING,
OPLFDNR TYPE STRING,
STAFO TYPE STRING,
ARTMENGE TYPE STRING,
STATTART TYPE STRING,
TIMECONTRL TYPE STRING,
TCNUMTOR TYPE STRING,
TCDENOMTOR TYPE STRING,
TIMTYPQUOT TYPE STRING,
AKTIV TYPE STRING,
KONZVER TYPE STRING,
PERTYP TYPE STRING,
ERCHV_ANCHOR TYPE STRING,
OUCONTRACT TYPE STRING,
EQUNR TYPE STRING,
GERAET TYPE STRING,
MATNR TYPE STRING,
ZWNUMMER TYPE STRING,
INDEXNR TYPE STRING,
ABLESGR TYPE STRING,
ABLESGRV TYPE STRING,
ATIM TYPE STRING,
ATIMVA TYPE STRING,
ADATMAX TYPE STRING,
ATIMMAX TYPE STRING,
THGDATUM TYPE STRING,
ZUORDDAT TYPE STRING,
REGRELSORT TYPE STRING,
ABLBELNR TYPE STRING,
LOGIKNR TYPE STRING,
LOGIKZW TYPE STRING,
ISTABLART TYPE STRING,
ISTABLARTVA TYPE STRING,
EXTPKZ TYPE STRING,
BEGPROG TYPE STRING,
ENDEPROG TYPE STRING,
ABLHINW TYPE STRING,
QDPROC TYPE STRING,
MRCONNECT TYPE STRING,
MWSKZ TYPE STRING,
ERMWSKZ TYPE STRING,
NETTOBTR TYPE STRING,
TWAERS TYPE STRING,
PREISTUF TYPE STRING,
PREISTYP TYPE STRING,
PREIS TYPE STRING,
PREISZUS TYPE STRING,
VONZONE TYPE STRING,
BISZONE TYPE STRING,
ZONENNR TYPE STRING,
PREISBTR TYPE STRING,
MNGBASIS TYPE STRING,
PREIGKL TYPE STRING,
URPREIS TYPE STRING,
PREIADD TYPE STRING,
PREIFAKT TYPE STRING,
OPMULT TYPE STRING,
TXDAT_KK TYPE STRING,
PRCTR TYPE STRING,
KOSTL TYPE STRING,
PS_PSP_PNR TYPE STRING,
AUFNR TYPE STRING,
PAOBJNR TYPE STRING,
PAOBJNR_S TYPE STRING,
GSBER TYPE STRING,
APERIODIC TYPE STRING,
GROSSGROUP TYPE STRING,
BRUTTOZEILE TYPE STRING,
BUPLA TYPE STRING,
LINE_CLASS TYPE STRING,
PREISART TYPE STRING,
SEGMENT TYPE STRING,
LEUCHTNR TYPE STRING,
BETRART TYPE STRING,
SPGRUND TYPE STRING,
EIN05 TYPE STRING,
EIN06 TYPE STRING,
EIN07 TYPE STRING,
EIN08 TYPE STRING,
EIN09 TYPE STRING,
EIN10 TYPE STRING,
AUS03 TYPE STRING,
AUS04 TYPE STRING,
AUS05 TYPE STRING,
MASS5 TYPE STRING,
MASS6 TYPE STRING,
SC_BELNR TYPE STRING,
SC_BELZEILE TYPE STRING,
REFBELZEILE TYPE STRING,
SPERRUNG TYPE STRING,
NETTOFRMD TYPE STRING,
WAERSF TYPE STRING,
UMRECHDAT TYPE STRING,
UMRECHKURS TYPE STRING,
REFBELZONE TYPE STRING,
REFBILLDOCNO TYPE STRING,
FIRSTBELNR TYPE STRING,
TAXREL TYPE STRING,
TAXGROUP TYPE STRING,
BILLTYPE TYPE STRING,
OBJNR TYPE STRING,
ORDERNR TYPE STRING,
LAUFNR TYPE STRING,
ORDER_LAUFNR TYPE STRING,
GGVERTRAG TYPE STRING,
OLD_BELNR TYPE STRING,
CONDIREF TYPE STRING,
DATEFROM TYPE STRING,
TIMEFROM TYPE STRING,
DATETO TYPE STRING,
TIMETO TYPE STRING,
RATERELGROUP TYPE STRING,
BASIC_RATE TYPE STRING,
RATERELCAT TYPE STRING,
CONDBILLPROGID TYPE STRING,
GEN_CONTRACT TYPE STRING,
REC_CONTRACT TYPE STRING,
GEN_TOU TYPE STRING,
REC_TOU TYPE STRING,
PROPORTION TYPE STRING,
PROPORTION_EXT TYPE STRING,
I_ZWSTAND TYPE STRING,
I_ZWSTNDAB TYPE STRING,
I_ZWSTVOR TYPE STRING,
I_ABRMENGE TYPE STRING,
I_ABRMENGEVOR TYPE STRING,
I_ZWSTDIFF TYPE STRING,
I_ZAHL1 TYPE STRING,
I_ZAHL2 TYPE STRING,
I_ZAHL3 TYPE STRING,
I_ZAHL4 TYPE STRING,
I_ZAHL5 TYPE STRING,
I_ZAHL6 TYPE STRING,
ZEITANT TYPE STRING,
I_NETTOBTR_L TYPE STRING,
COLOGRP_INST_L TYPE STRING,
POWER_FACT TYPE STRING,
ABLESART TYPE STRING,
ABLESARTVA TYPE STRING,
VERBREL TYPE STRING,
UNITIDOC TYPE STRING,
FREETEXT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_SERCHZ_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_SERCHZ_STR-MANDT sy-vline 
WA_SERCHZ_STR-BELNR sy-vline 
WA_SERCHZ_STR-BELZEILE sy-vline 
WA_SERCHZ_STR-UNIMPORTANT sy-vline 
WA_SERCHZ_STR-GROSSBLOCK sy-vline 
WA_SERCHZ_STR-OLD_ERCHZ sy-vline 
WA_SERCHZ_STR-ISTYPE sy-vline 
WA_SERCHZ_STR-CSNO sy-vline 
WA_SERCHZ_STR-BELZART sy-vline 
WA_SERCHZ_STR-ABSLKZ sy-vline 
WA_SERCHZ_STR-DIFFKZ sy-vline 
WA_SERCHZ_STR-BUCHREL sy-vline 
WA_SERCHZ_STR-MENGESTREL sy-vline 
WA_SERCHZ_STR-BETRSTREL sy-vline 
WA_SERCHZ_STR-STGRQNT sy-vline 
WA_SERCHZ_STR-STGRAMT sy-vline 
WA_SERCHZ_STR-PRINTREL sy-vline 
WA_SERCHZ_STR-AKLASSE sy-vline 
WA_SERCHZ_STR-BRANCHE sy-vline 
WA_SERCHZ_STR-TVORG sy-vline 
WA_SERCHZ_STR-GEGEN_TVORG sy-vline 
WA_SERCHZ_STR-TAX_TVORG sy-vline 
WA_SERCHZ_STR-LINESORT sy-vline 
WA_SERCHZ_STR-AB sy-vline 
WA_SERCHZ_STR-BIS sy-vline 
WA_SERCHZ_STR-TIMTYPZA sy-vline 
WA_SERCHZ_STR-SCHEMANR sy-vline 
WA_SERCHZ_STR-SNO sy-vline 
WA_SERCHZ_STR-PROGRAMM sy-vline 
WA_SERCHZ_STR-MASSBILL sy-vline 
WA_SERCHZ_STR-SAISON sy-vline 
WA_SERCHZ_STR-TIMBASIS sy-vline 
WA_SERCHZ_STR-TIMTYP sy-vline 
WA_SERCHZ_STR-FRAN_TYPE sy-vline 
WA_SERCHZ_STR-KONZIGR sy-vline 
WA_SERCHZ_STR-TARIFTYP sy-vline 
WA_SERCHZ_STR-TARIFNR sy-vline 
WA_SERCHZ_STR-KONDIGR sy-vline 
WA_SERCHZ_STR-STTARIF sy-vline 
WA_SERCHZ_STR-GEWKEY sy-vline 
WA_SERCHZ_STR-WDHFAKT sy-vline 
WA_SERCHZ_STR-TEMP_AREA sy-vline 
WA_SERCHZ_STR-DRCKSTUF sy-vline 
WA_SERCHZ_STR-ABGGRND1 sy-vline 
WA_SERCHZ_STR-ABGGRND2 sy-vline 
WA_SERCHZ_STR-ABGGRND3 sy-vline 
WA_SERCHZ_STR-ABGGRND4 sy-vline 
WA_SERCHZ_STR-ABGGRND5 sy-vline 
WA_SERCHZ_STR-ABGGRND6 sy-vline 
WA_SERCHZ_STR-ABGGRND7 sy-vline 
WA_SERCHZ_STR-ABGGRND8 sy-vline 
WA_SERCHZ_STR-ABGGRND9 sy-vline 
WA_SERCHZ_STR-ABGGRND10 sy-vline 
WA_SERCHZ_STR-EIN01 sy-vline 
WA_SERCHZ_STR-EIN02 sy-vline 
WA_SERCHZ_STR-EIN03 sy-vline 
WA_SERCHZ_STR-EIN04 sy-vline 
WA_SERCHZ_STR-AUS01 sy-vline 
WA_SERCHZ_STR-AUS02 sy-vline 
WA_SERCHZ_STR-MASS1 sy-vline 
WA_SERCHZ_STR-MASS2 sy-vline 
WA_SERCHZ_STR-MASS3 sy-vline 
WA_SERCHZ_STR-MASS4 sy-vline 
WA_SERCHZ_STR-DATUM1 sy-vline 
WA_SERCHZ_STR-DATUM2 sy-vline 
WA_SERCHZ_STR-RABZUS sy-vline 
WA_SERCHZ_STR-BACKCANC01 sy-vline 
WA_SERCHZ_STR-BACKCANC02 sy-vline 
WA_SERCHZ_STR-BACKCANC03 sy-vline 
WA_SERCHZ_STR-BACKCANC04 sy-vline 
WA_SERCHZ_STR-BACKCANC05 sy-vline 
WA_SERCHZ_STR-BACKCANC sy-vline 
WA_SERCHZ_STR-BACKEXEC sy-vline 
WA_SERCHZ_STR-BACKDOCNO sy-vline 
WA_SERCHZ_STR-BACKDOCLINE sy-vline 
WA_SERCHZ_STR-DYNCANC01 sy-vline 
WA_SERCHZ_STR-DYNCANC02 sy-vline 
WA_SERCHZ_STR-DYNCANC03 sy-vline 
WA_SERCHZ_STR-DYNCANC04 sy-vline 
WA_SERCHZ_STR-DYNCANC05 sy-vline 
WA_SERCHZ_STR-DYNCANC sy-vline 
WA_SERCHZ_STR-DYNEXEC sy-vline 
WA_SERCHZ_STR-LRATESTEP sy-vline 
WA_SERCHZ_STR-PEB sy-vline 
WA_SERCHZ_STR-OPLFDNR sy-vline 
WA_SERCHZ_STR-STAFO sy-vline 
WA_SERCHZ_STR-ARTMENGE sy-vline 
WA_SERCHZ_STR-STATTART sy-vline 
WA_SERCHZ_STR-TIMECONTRL sy-vline 
WA_SERCHZ_STR-TCNUMTOR sy-vline 
WA_SERCHZ_STR-TCDENOMTOR sy-vline 
WA_SERCHZ_STR-TIMTYPQUOT sy-vline 
WA_SERCHZ_STR-AKTIV sy-vline 
WA_SERCHZ_STR-KONZVER sy-vline 
WA_SERCHZ_STR-PERTYP sy-vline 
WA_SERCHZ_STR-ERCHV_ANCHOR sy-vline 
WA_SERCHZ_STR-OUCONTRACT sy-vline 
WA_SERCHZ_STR-EQUNR sy-vline 
WA_SERCHZ_STR-GERAET sy-vline 
WA_SERCHZ_STR-MATNR sy-vline 
WA_SERCHZ_STR-ZWNUMMER sy-vline 
WA_SERCHZ_STR-INDEXNR sy-vline 
WA_SERCHZ_STR-ABLESGR sy-vline 
WA_SERCHZ_STR-ABLESGRV sy-vline 
WA_SERCHZ_STR-ATIM sy-vline 
WA_SERCHZ_STR-ATIMVA sy-vline 
WA_SERCHZ_STR-ADATMAX sy-vline 
WA_SERCHZ_STR-ATIMMAX sy-vline 
WA_SERCHZ_STR-THGDATUM sy-vline 
WA_SERCHZ_STR-ZUORDDAT sy-vline 
WA_SERCHZ_STR-REGRELSORT sy-vline 
WA_SERCHZ_STR-ABLBELNR sy-vline 
WA_SERCHZ_STR-LOGIKNR sy-vline 
WA_SERCHZ_STR-LOGIKZW sy-vline 
WA_SERCHZ_STR-ISTABLART sy-vline 
WA_SERCHZ_STR-ISTABLARTVA sy-vline 
WA_SERCHZ_STR-EXTPKZ sy-vline 
WA_SERCHZ_STR-BEGPROG sy-vline 
WA_SERCHZ_STR-ENDEPROG sy-vline 
WA_SERCHZ_STR-ABLHINW sy-vline 
WA_SERCHZ_STR-QDPROC sy-vline 
WA_SERCHZ_STR-MRCONNECT sy-vline 
WA_SERCHZ_STR-MWSKZ sy-vline 
WA_SERCHZ_STR-ERMWSKZ sy-vline 
WA_SERCHZ_STR-NETTOBTR sy-vline 
WA_SERCHZ_STR-TWAERS sy-vline 
WA_SERCHZ_STR-PREISTUF sy-vline 
WA_SERCHZ_STR-PREISTYP sy-vline 
WA_SERCHZ_STR-PREIS sy-vline 
WA_SERCHZ_STR-PREISZUS sy-vline 
WA_SERCHZ_STR-VONZONE sy-vline 
WA_SERCHZ_STR-BISZONE sy-vline 
WA_SERCHZ_STR-ZONENNR sy-vline 
WA_SERCHZ_STR-PREISBTR sy-vline 
WA_SERCHZ_STR-MNGBASIS sy-vline 
WA_SERCHZ_STR-PREIGKL sy-vline 
WA_SERCHZ_STR-URPREIS sy-vline 
WA_SERCHZ_STR-PREIADD sy-vline 
WA_SERCHZ_STR-PREIFAKT sy-vline 
WA_SERCHZ_STR-OPMULT sy-vline 
WA_SERCHZ_STR-TXDAT_KK sy-vline 
WA_SERCHZ_STR-PRCTR sy-vline 
WA_SERCHZ_STR-KOSTL sy-vline 
WA_SERCHZ_STR-PS_PSP_PNR sy-vline 
WA_SERCHZ_STR-AUFNR sy-vline 
WA_SERCHZ_STR-PAOBJNR sy-vline 
WA_SERCHZ_STR-PAOBJNR_S sy-vline 
WA_SERCHZ_STR-GSBER sy-vline 
WA_SERCHZ_STR-APERIODIC sy-vline 
WA_SERCHZ_STR-GROSSGROUP sy-vline 
WA_SERCHZ_STR-BRUTTOZEILE sy-vline 
WA_SERCHZ_STR-BUPLA sy-vline 
WA_SERCHZ_STR-LINE_CLASS sy-vline 
WA_SERCHZ_STR-PREISART sy-vline 
WA_SERCHZ_STR-SEGMENT sy-vline 
WA_SERCHZ_STR-LEUCHTNR sy-vline 
WA_SERCHZ_STR-BETRART sy-vline 
WA_SERCHZ_STR-SPGRUND sy-vline 
WA_SERCHZ_STR-EIN05 sy-vline 
WA_SERCHZ_STR-EIN06 sy-vline 
WA_SERCHZ_STR-EIN07 sy-vline 
WA_SERCHZ_STR-EIN08 sy-vline 
WA_SERCHZ_STR-EIN09 sy-vline 
WA_SERCHZ_STR-EIN10 sy-vline 
WA_SERCHZ_STR-AUS03 sy-vline 
WA_SERCHZ_STR-AUS04 sy-vline 
WA_SERCHZ_STR-AUS05 sy-vline 
WA_SERCHZ_STR-MASS5 sy-vline 
WA_SERCHZ_STR-MASS6 sy-vline 
WA_SERCHZ_STR-SC_BELNR sy-vline 
WA_SERCHZ_STR-SC_BELZEILE sy-vline 
WA_SERCHZ_STR-REFBELZEILE sy-vline 
WA_SERCHZ_STR-SPERRUNG sy-vline 
WA_SERCHZ_STR-NETTOFRMD sy-vline 
WA_SERCHZ_STR-WAERSF sy-vline 
WA_SERCHZ_STR-UMRECHDAT sy-vline 
WA_SERCHZ_STR-UMRECHKURS sy-vline 
WA_SERCHZ_STR-REFBELZONE sy-vline 
WA_SERCHZ_STR-REFBILLDOCNO sy-vline 
WA_SERCHZ_STR-FIRSTBELNR sy-vline 
WA_SERCHZ_STR-TAXREL sy-vline 
WA_SERCHZ_STR-TAXGROUP sy-vline 
WA_SERCHZ_STR-BILLTYPE sy-vline 
WA_SERCHZ_STR-OBJNR sy-vline 
WA_SERCHZ_STR-ORDERNR sy-vline 
WA_SERCHZ_STR-LAUFNR sy-vline 
WA_SERCHZ_STR-ORDER_LAUFNR sy-vline 
WA_SERCHZ_STR-GGVERTRAG sy-vline 
WA_SERCHZ_STR-OLD_BELNR sy-vline 
WA_SERCHZ_STR-CONDIREF sy-vline 
WA_SERCHZ_STR-DATEFROM sy-vline 
WA_SERCHZ_STR-TIMEFROM sy-vline 
WA_SERCHZ_STR-DATETO sy-vline 
WA_SERCHZ_STR-TIMETO sy-vline 
WA_SERCHZ_STR-RATERELGROUP sy-vline 
WA_SERCHZ_STR-BASIC_RATE sy-vline 
WA_SERCHZ_STR-RATERELCAT sy-vline 
WA_SERCHZ_STR-CONDBILLPROGID sy-vline 
WA_SERCHZ_STR-GEN_CONTRACT sy-vline 
WA_SERCHZ_STR-REC_CONTRACT sy-vline 
WA_SERCHZ_STR-GEN_TOU sy-vline 
WA_SERCHZ_STR-REC_TOU sy-vline 
WA_SERCHZ_STR-PROPORTION sy-vline 
WA_SERCHZ_STR-PROPORTION_EXT sy-vline 
WA_SERCHZ_STR-I_ZWSTAND sy-vline 
WA_SERCHZ_STR-I_ZWSTNDAB sy-vline 
WA_SERCHZ_STR-I_ZWSTVOR sy-vline 
WA_SERCHZ_STR-I_ABRMENGE sy-vline 
WA_SERCHZ_STR-I_ABRMENGEVOR sy-vline 
WA_SERCHZ_STR-I_ZWSTDIFF sy-vline 
WA_SERCHZ_STR-I_ZAHL1 sy-vline 
WA_SERCHZ_STR-I_ZAHL2 sy-vline 
WA_SERCHZ_STR-I_ZAHL3 sy-vline 
WA_SERCHZ_STR-I_ZAHL4 sy-vline 
WA_SERCHZ_STR-I_ZAHL5 sy-vline 
WA_SERCHZ_STR-I_ZAHL6 sy-vline 
WA_SERCHZ_STR-ZEITANT sy-vline 
WA_SERCHZ_STR-I_NETTOBTR_L sy-vline 
WA_SERCHZ_STR-COLOGRP_INST_L sy-vline 
WA_SERCHZ_STR-POWER_FACT sy-vline 
WA_SERCHZ_STR-ABLESART sy-vline 
WA_SERCHZ_STR-ABLESARTVA sy-vline 
WA_SERCHZ_STR-VERBREL sy-vline 
WA_SERCHZ_STR-UNITIDOC sy-vline 
WA_SERCHZ_STR-FREETEXT sy-vline      INTO ld_text SEPARATED BY SPACE.

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