ABAP Select data from SAP table VVKK_SCT 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 VVKK_SCT 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 VVKK_SCT. 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 VVKK_SCT 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_VVKK_SCT TYPE STANDARD TABLE OF VVKK_SCT,
      WA_VVKK_SCT TYPE VVKK_SCT,
      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: <VVKK_SCT> TYPE VVKK_SCT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VVKK_SCT
*  INTO TABLE @DATA(IT_VVKK_SCT2).
*--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_VVKK_SCT INDEX 1 INTO DATA(WA_VVKK_SCT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<VVKK_SCT>-M1 = 1.
<VVKK_SCT>-M2 = 1.
<VVKK_SCT>-FALLNR = 1.
<VVKK_SCT>-AKTYP = 1.
<VVKK_SCT>-BLTYP = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_VVKK_SCT-GPART, sy-vline,
  WA_VVKK_SCT-VTREF, sy-vline,
  WA_VVKK_SCT-POSNR, sy-vline,
  WA_VVKK_SCT-SCPOSNR, sy-vline,
  WA_VVKK_SCT-SCITEM, sy-vline,
  WA_VVKK_SCT-CHECKLEVEL, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_VVKK_SCT 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_VVKK_SCT 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_VVKK_SCT INTO WA_VVKK_SCT.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field ESRRE
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_VVKK_SCT-ESRRE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VVKK_SCT-ESRRE.
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_VVKK_SCT_STR, 
M1 TYPE STRING,
M2 TYPE STRING,
FALLNR TYPE STRING,
AKTYP TYPE STRING,
BLTYP TYPE STRING,
GPART TYPE STRING,
VTREF TYPE STRING,
POSNR TYPE STRING,
SCPOSNR TYPE STRING,
SCITEM TYPE STRING,
CHECKLEVEL TYPE STRING,
RELIND TYPE STRING,
ZAHLENFORMAT TYPE STRING,
STATPOST TYPE STRING,
PSNGL TYPE STRING,
PMTFR TYPE STRING,
PMTTO TYPE STRING,
RISKFR TYPE STRING,
RISKTO TYPE STRING,
RENEW TYPE STRING,
RNEWX TYPE STRING,
CCODE TYPE STRING,
OPCCODE TYPE STRING,
GSBER TYPE STRING,
OPGSBER TYPE STRING,
PRGRP TYPE STRING,
SEGMENT TYPE STRING,
VSARL_VX TYPE STRING,
INSTAXS TYPE STRING,
TXPOS TYPE STRING,
CRUSER TYPE STRING,
HVORG TYPE STRING,
TVORG TYPE STRING,
OPHVORG TYPE STRING,
OPTVORG TYPE STRING,
S_HKONT TYPE STRING,
H_HKONT TYPE STRING,
PAOBJNR TYPE STRING,
VBUND TYPE STRING,
KONTT TYPE STRING,
KONTL TYPE STRING,
BLART TYPE STRING,
VTRE2 TYPE STRING,
VTRE3 TYPE STRING,
BUGRD TYPE STRING,
XDERE TYPE STRING,
VGPART2 TYPE STRING,
VGPART3 TYPE STRING,
GSFNR TYPE STRING,
VALUT TYPE STRING,
PRCTR TYPE STRING,
KOSTL TYPE STRING,
AUFNR TYPE STRING,
LDGRP TYPE STRING,
PYGRP TYPE STRING,
PDTYP TYPE STRING,
GRKEY TYPE STRING,
VOPBEL TYPE STRING,
ROPBEL TYPE STRING,
MWSKZ TYPE STRING,
QSSKZ TYPE STRING,
STRKZ TYPE STRING,
OPKONTT TYPE STRING,
OPKONTL TYPE STRING,
STRNETTO TYPE STRING,
KTOSL TYPE STRING,
OPTXT TYPE STRING,
ORIGIN TYPE STRING,
XEIBH_KO TYPE STRING,
XEIPH_OPK TYPE STRING,
HZUON TYPE STRING,
SGTXT TYPE STRING,
XEIPH_OP TYPE STRING,
FINRE TYPE STRING,
COINS_CAT TYPE STRING,
AWSYS TYPE STRING,
AWTYP TYPE STRING,
AWKEY TYPE STRING,
EMGPA TYPE STRING,
EMBVT TYPE STRING,
EMADR TYPE STRING,
EMCCID TYPE STRING,
PYMET TYPE STRING,
PYBUK TYPE STRING,
FDGRP TYPE STRING,
FDZTG TYPE STRING,
FAEDS TYPE STRING,
SKTPZ TYPE STRING,
FAEDN TYPE STRING,
IKEY TYPE STRING,
BUDAT TYPE STRING,
STUDT TYPE STRING,
BLDAT TYPE STRING,
DUN_REASON TYPE STRING,
DUN_REASON_DAYS TYPE STRING,
PAY_REASON TYPE STRING,
PAY_REASON_DAYS TYPE STRING,
CLR_REASON TYPE STRING,
CLR_REASON_DAYS TYPE STRING,
INT_REASON TYPE STRING,
INT_REASON_DAYS TYPE STRING,
REFCLAIM TYPE STRING,
WWERT TYPE STRING,
PMEND TYPE STRING,
PMEND_TIME TYPE STRING,
ENDTYPE TYPE STRING,
AMOUNT_NEED TYPE STRING,
AMOUNT_END TYPE STRING,
ATFRD TYPE STRING,
ATFRD_TIME TYPE STRING,
AMOUNT_TOTAL TYPE STRING,
AMOUNT_INST TYPE STRING,
CURR TYPE STRING,
STO_FROM TYPE STRING,
STO_TO TYPE STRING,
REFGF TYPE STRING,
ENDREV TYPE STRING,
ARCHI TYPE STRING,
STMET TYPE STRING,
GPART_EXT TYPE STRING,
VGPART2_EXT TYPE STRING,
VGPART3_EXT TYPE STRING,
EMGPA_EXT TYPE STRING,
EMADR_EXT TYPE STRING,
EMBVT_EXT TYPE STRING,
STAKZ TYPE STRING,
BELNR TYPE STRING,
ANZEP TYPE STRING,
FREQZ TYPE STRING,
GBETR TYPE STRING,
BUKNZ TYPE STRING,
KZSIA TYPE STRING,
KZSIP TYPE STRING,
NFAEL TYPE STRING,
RVTNR TYPE STRING,
SBHSL TYPE STRING,
TCODE TYPE STRING,
REFBL TYPE STRING,
FOKNZ TYPE STRING,
LNDSL TYPE STRING,
VKONT TYPE STRING,
INDYN TYPE STRING,
INFAK TYPE STRING,
STPRZ TYPE STRING,
VERKZ TYPE STRING,
BEWAR TYPE STRING,
ADKZN TYPE STRING,
STPAR TYPE STRING,
MANDT TYPE STRING,
RBART TYPE STRING,
PARTNER TYPE STRING,
TYPE TYPE STRING,
BPKIND TYPE STRING,
BU_GROUP TYPE STRING,
BPEXT TYPE STRING,
BU_SORT1 TYPE STRING,
TITLE TYPE STRING,
AUGRP TYPE STRING,
LEGAL_ENTY TYPE STRING,
IND_SECTOR TYPE STRING,
NAME_LAST TYPE STRING,
NAME_FIRST TYPE STRING,
TITLE_ACA1 TYPE STRING,
TITLE_ACA2 TYPE STRING,
TITLE_ROYL TYPE STRING,
PREFIX1 TYPE STRING,
PREFIX2 TYPE STRING,
XSEXM TYPE STRING,
XSEXF TYPE STRING,
NATIO TYPE STRING,
BIRTHDT TYPE STRING,
CITY1 TYPE STRING,
POST_CODE1 TYPE STRING,
POST_CODE2 TYPE STRING,
PO_BOX TYPE STRING,
PO_BOX_NUM TYPE STRING,
PO_BOX_LOC TYPE STRING,
PO_BOX_REG TYPE STRING,
STREET TYPE STRING,
HOUSE_NUM1 TYPE STRING,
ROOMNUMBER TYPE STRING,
COUNTRY TYPE STRING,
LANGU TYPE STRING,
REGION TYPE STRING,
BKVID TYPE STRING,
BANKS TYPE STRING,
BANKL TYPE STRING,
BANKN TYPE STRING,
BKONT TYPE STRING,
KOINH TYPE STRING,
CCARD_ID TYPE STRING,
CCINS TYPE STRING,
CCNUM TYPE STRING,
LNDSL_VX_OP TYPE STRING,
GSART_VX_OP TYPE STRING,
BSART_VX_OP TYPE STRING,
GZART_VX_OP TYPE STRING,
SDART_VX_OP TYPE STRING,
SJAHR_VX_OP TYPE STRING,
MJAHR_VX_OP TYPE STRING,
RSART_VX_OP TYPE STRING,
FUBER_VX_OP TYPE STRING,
BEBER_VX_OP TYPE STRING,
BSGRP_VX_OP TYPE STRING,
XBLNR TYPE STRING,
AKTYP_COINS TYPE STRING,
COINS_CODE TYPE STRING,
COINS_AMOUNT TYPE STRING,
ESRNR TYPE STRING,
ESRRE TYPE STRING,
ESRPZ TYPE STRING,
ESR_NAME1 TYPE STRING,
ESR_NAME2 TYPE STRING,
ESR_POST_CODE1 TYPE STRING,
ESR_CITY1 TYPE STRING,
ESR_STREET TYPE STRING,
ESR_HOUSE_NUM1 TYPE STRING,
QRIBAN TYPE STRING,
GLO_REF1_OT TYPE STRING,
ESR_LAND1 TYPE STRING,
AKTYP_WH TYPE STRING,
QSSEW TYPE STRING,
STPRZ1 TYPE STRING,
QSSHB TYPE STRING,
QBSHB TYPE STRING,
DUN_REASON_FDATE TYPE STRING,
DUN_REASON_TDATE TYPE STRING,
PAY_REASON_FDATE TYPE STRING,
PAY_REASON_TDATE TYPE STRING,
CLR_REASON_FDATE TYPE STRING,
CLR_REASON_TDATE TYPE STRING,
INT_REASON_FDATE TYPE STRING,
INT_REASON_TDATE TYPE STRING,
CPD_SWIFT TYPE STRING,
CPD_IBAN TYPE STRING,
AKTYP_ETAX TYPE STRING,
KSCHL TYPE STRING,
TAXAM TYPE STRING,
STPRZ_ETAX TYPE STRING,
SBASW TYPE STRING,
MNDID TYPE STRING,
BETRH TYPE STRING,
KURSF TYPE STRING,
KTOSL_TAX TYPE STRING,END OF T_EKKO_STR.
DATA: WA_VVKK_SCT_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_VVKK_SCT_STR-M1 sy-vline 
WA_VVKK_SCT_STR-M2 sy-vline 
WA_VVKK_SCT_STR-FALLNR sy-vline 
WA_VVKK_SCT_STR-AKTYP sy-vline 
WA_VVKK_SCT_STR-BLTYP sy-vline 
WA_VVKK_SCT_STR-GPART sy-vline 
WA_VVKK_SCT_STR-VTREF sy-vline 
WA_VVKK_SCT_STR-POSNR sy-vline 
WA_VVKK_SCT_STR-SCPOSNR sy-vline 
WA_VVKK_SCT_STR-SCITEM sy-vline 
WA_VVKK_SCT_STR-CHECKLEVEL sy-vline 
WA_VVKK_SCT_STR-RELIND sy-vline 
WA_VVKK_SCT_STR-ZAHLENFORMAT sy-vline 
WA_VVKK_SCT_STR-STATPOST sy-vline 
WA_VVKK_SCT_STR-PSNGL sy-vline 
WA_VVKK_SCT_STR-PMTFR sy-vline 
WA_VVKK_SCT_STR-PMTTO sy-vline 
WA_VVKK_SCT_STR-RISKFR sy-vline 
WA_VVKK_SCT_STR-RISKTO sy-vline 
WA_VVKK_SCT_STR-RENEW sy-vline 
WA_VVKK_SCT_STR-RNEWX sy-vline 
WA_VVKK_SCT_STR-CCODE sy-vline 
WA_VVKK_SCT_STR-OPCCODE sy-vline 
WA_VVKK_SCT_STR-GSBER sy-vline 
WA_VVKK_SCT_STR-OPGSBER sy-vline 
WA_VVKK_SCT_STR-PRGRP sy-vline 
WA_VVKK_SCT_STR-SEGMENT sy-vline 
WA_VVKK_SCT_STR-VSARL_VX sy-vline 
WA_VVKK_SCT_STR-INSTAXS sy-vline 
WA_VVKK_SCT_STR-TXPOS sy-vline 
WA_VVKK_SCT_STR-CRUSER sy-vline 
WA_VVKK_SCT_STR-HVORG sy-vline 
WA_VVKK_SCT_STR-TVORG sy-vline 
WA_VVKK_SCT_STR-OPHVORG sy-vline 
WA_VVKK_SCT_STR-OPTVORG sy-vline 
WA_VVKK_SCT_STR-S_HKONT sy-vline 
WA_VVKK_SCT_STR-H_HKONT sy-vline 
WA_VVKK_SCT_STR-PAOBJNR sy-vline 
WA_VVKK_SCT_STR-VBUND sy-vline 
WA_VVKK_SCT_STR-KONTT sy-vline 
WA_VVKK_SCT_STR-KONTL sy-vline 
WA_VVKK_SCT_STR-BLART sy-vline 
WA_VVKK_SCT_STR-VTRE2 sy-vline 
WA_VVKK_SCT_STR-VTRE3 sy-vline 
WA_VVKK_SCT_STR-BUGRD sy-vline 
WA_VVKK_SCT_STR-XDERE sy-vline 
WA_VVKK_SCT_STR-VGPART2 sy-vline 
WA_VVKK_SCT_STR-VGPART3 sy-vline 
WA_VVKK_SCT_STR-GSFNR sy-vline 
WA_VVKK_SCT_STR-VALUT sy-vline 
WA_VVKK_SCT_STR-PRCTR sy-vline 
WA_VVKK_SCT_STR-KOSTL sy-vline 
WA_VVKK_SCT_STR-AUFNR sy-vline 
WA_VVKK_SCT_STR-LDGRP sy-vline 
WA_VVKK_SCT_STR-PYGRP sy-vline 
WA_VVKK_SCT_STR-PDTYP sy-vline 
WA_VVKK_SCT_STR-GRKEY sy-vline 
WA_VVKK_SCT_STR-VOPBEL sy-vline 
WA_VVKK_SCT_STR-ROPBEL sy-vline 
WA_VVKK_SCT_STR-MWSKZ sy-vline 
WA_VVKK_SCT_STR-QSSKZ sy-vline 
WA_VVKK_SCT_STR-STRKZ sy-vline 
WA_VVKK_SCT_STR-OPKONTT sy-vline 
WA_VVKK_SCT_STR-OPKONTL sy-vline 
WA_VVKK_SCT_STR-STRNETTO sy-vline 
WA_VVKK_SCT_STR-KTOSL sy-vline 
WA_VVKK_SCT_STR-OPTXT sy-vline 
WA_VVKK_SCT_STR-ORIGIN sy-vline 
WA_VVKK_SCT_STR-XEIBH_KO sy-vline 
WA_VVKK_SCT_STR-XEIPH_OPK sy-vline 
WA_VVKK_SCT_STR-HZUON sy-vline 
WA_VVKK_SCT_STR-SGTXT sy-vline 
WA_VVKK_SCT_STR-XEIPH_OP sy-vline 
WA_VVKK_SCT_STR-FINRE sy-vline 
WA_VVKK_SCT_STR-COINS_CAT sy-vline 
WA_VVKK_SCT_STR-AWSYS sy-vline 
WA_VVKK_SCT_STR-AWTYP sy-vline 
WA_VVKK_SCT_STR-AWKEY sy-vline 
WA_VVKK_SCT_STR-EMGPA sy-vline 
WA_VVKK_SCT_STR-EMBVT sy-vline 
WA_VVKK_SCT_STR-EMADR sy-vline 
WA_VVKK_SCT_STR-EMCCID sy-vline 
WA_VVKK_SCT_STR-PYMET sy-vline 
WA_VVKK_SCT_STR-PYBUK sy-vline 
WA_VVKK_SCT_STR-FDGRP sy-vline 
WA_VVKK_SCT_STR-FDZTG sy-vline 
WA_VVKK_SCT_STR-FAEDS sy-vline 
WA_VVKK_SCT_STR-SKTPZ sy-vline 
WA_VVKK_SCT_STR-FAEDN sy-vline 
WA_VVKK_SCT_STR-IKEY sy-vline 
WA_VVKK_SCT_STR-BUDAT sy-vline 
WA_VVKK_SCT_STR-STUDT sy-vline 
WA_VVKK_SCT_STR-BLDAT sy-vline 
WA_VVKK_SCT_STR-DUN_REASON sy-vline 
WA_VVKK_SCT_STR-DUN_REASON_DAYS sy-vline 
WA_VVKK_SCT_STR-PAY_REASON sy-vline 
WA_VVKK_SCT_STR-PAY_REASON_DAYS sy-vline 
WA_VVKK_SCT_STR-CLR_REASON sy-vline 
WA_VVKK_SCT_STR-CLR_REASON_DAYS sy-vline 
WA_VVKK_SCT_STR-INT_REASON sy-vline 
WA_VVKK_SCT_STR-INT_REASON_DAYS sy-vline 
WA_VVKK_SCT_STR-REFCLAIM sy-vline 
WA_VVKK_SCT_STR-WWERT sy-vline 
WA_VVKK_SCT_STR-PMEND sy-vline 
WA_VVKK_SCT_STR-PMEND_TIME sy-vline 
WA_VVKK_SCT_STR-ENDTYPE sy-vline 
WA_VVKK_SCT_STR-AMOUNT_NEED sy-vline 
WA_VVKK_SCT_STR-AMOUNT_END sy-vline 
WA_VVKK_SCT_STR-ATFRD sy-vline 
WA_VVKK_SCT_STR-ATFRD_TIME sy-vline 
WA_VVKK_SCT_STR-AMOUNT_TOTAL sy-vline 
WA_VVKK_SCT_STR-AMOUNT_INST sy-vline 
WA_VVKK_SCT_STR-CURR sy-vline 
WA_VVKK_SCT_STR-STO_FROM sy-vline 
WA_VVKK_SCT_STR-STO_TO sy-vline 
WA_VVKK_SCT_STR-REFGF sy-vline 
WA_VVKK_SCT_STR-ENDREV sy-vline 
WA_VVKK_SCT_STR-ARCHI sy-vline 
WA_VVKK_SCT_STR-STMET sy-vline 
WA_VVKK_SCT_STR-GPART_EXT sy-vline 
WA_VVKK_SCT_STR-VGPART2_EXT sy-vline 
WA_VVKK_SCT_STR-VGPART3_EXT sy-vline 
WA_VVKK_SCT_STR-EMGPA_EXT sy-vline 
WA_VVKK_SCT_STR-EMADR_EXT sy-vline 
WA_VVKK_SCT_STR-EMBVT_EXT sy-vline 
WA_VVKK_SCT_STR-STAKZ sy-vline 
WA_VVKK_SCT_STR-BELNR sy-vline 
WA_VVKK_SCT_STR-ANZEP sy-vline 
WA_VVKK_SCT_STR-FREQZ sy-vline 
WA_VVKK_SCT_STR-GBETR sy-vline 
WA_VVKK_SCT_STR-BUKNZ sy-vline 
WA_VVKK_SCT_STR-KZSIA sy-vline 
WA_VVKK_SCT_STR-KZSIP sy-vline 
WA_VVKK_SCT_STR-NFAEL sy-vline 
WA_VVKK_SCT_STR-RVTNR sy-vline 
WA_VVKK_SCT_STR-SBHSL sy-vline 
WA_VVKK_SCT_STR-TCODE sy-vline 
WA_VVKK_SCT_STR-REFBL sy-vline 
WA_VVKK_SCT_STR-FOKNZ sy-vline 
WA_VVKK_SCT_STR-LNDSL sy-vline 
WA_VVKK_SCT_STR-VKONT sy-vline 
WA_VVKK_SCT_STR-INDYN sy-vline 
WA_VVKK_SCT_STR-INFAK sy-vline 
WA_VVKK_SCT_STR-STPRZ sy-vline 
WA_VVKK_SCT_STR-VERKZ sy-vline 
WA_VVKK_SCT_STR-BEWAR sy-vline 
WA_VVKK_SCT_STR-ADKZN sy-vline 
WA_VVKK_SCT_STR-STPAR sy-vline 
WA_VVKK_SCT_STR-MANDT sy-vline 
WA_VVKK_SCT_STR-RBART sy-vline 
WA_VVKK_SCT_STR-PARTNER sy-vline 
WA_VVKK_SCT_STR-TYPE sy-vline 
WA_VVKK_SCT_STR-BPKIND sy-vline 
WA_VVKK_SCT_STR-BU_GROUP sy-vline 
WA_VVKK_SCT_STR-BPEXT sy-vline 
WA_VVKK_SCT_STR-BU_SORT1 sy-vline 
WA_VVKK_SCT_STR-TITLE sy-vline 
WA_VVKK_SCT_STR-AUGRP sy-vline 
WA_VVKK_SCT_STR-LEGAL_ENTY sy-vline 
WA_VVKK_SCT_STR-IND_SECTOR sy-vline 
WA_VVKK_SCT_STR-NAME_LAST sy-vline 
WA_VVKK_SCT_STR-NAME_FIRST sy-vline 
WA_VVKK_SCT_STR-TITLE_ACA1 sy-vline 
WA_VVKK_SCT_STR-TITLE_ACA2 sy-vline 
WA_VVKK_SCT_STR-TITLE_ROYL sy-vline 
WA_VVKK_SCT_STR-PREFIX1 sy-vline 
WA_VVKK_SCT_STR-PREFIX2 sy-vline 
WA_VVKK_SCT_STR-XSEXM sy-vline 
WA_VVKK_SCT_STR-XSEXF sy-vline 
WA_VVKK_SCT_STR-NATIO sy-vline 
WA_VVKK_SCT_STR-BIRTHDT sy-vline 
WA_VVKK_SCT_STR-CITY1 sy-vline 
WA_VVKK_SCT_STR-POST_CODE1 sy-vline 
WA_VVKK_SCT_STR-POST_CODE2 sy-vline 
WA_VVKK_SCT_STR-PO_BOX sy-vline 
WA_VVKK_SCT_STR-PO_BOX_NUM sy-vline 
WA_VVKK_SCT_STR-PO_BOX_LOC sy-vline 
WA_VVKK_SCT_STR-PO_BOX_REG sy-vline 
WA_VVKK_SCT_STR-STREET sy-vline 
WA_VVKK_SCT_STR-HOUSE_NUM1 sy-vline 
WA_VVKK_SCT_STR-ROOMNUMBER sy-vline 
WA_VVKK_SCT_STR-COUNTRY sy-vline 
WA_VVKK_SCT_STR-LANGU sy-vline 
WA_VVKK_SCT_STR-REGION sy-vline 
WA_VVKK_SCT_STR-BKVID sy-vline 
WA_VVKK_SCT_STR-BANKS sy-vline 
WA_VVKK_SCT_STR-BANKL sy-vline 
WA_VVKK_SCT_STR-BANKN sy-vline 
WA_VVKK_SCT_STR-BKONT sy-vline 
WA_VVKK_SCT_STR-KOINH sy-vline 
WA_VVKK_SCT_STR-CCARD_ID sy-vline 
WA_VVKK_SCT_STR-CCINS sy-vline 
WA_VVKK_SCT_STR-CCNUM sy-vline 
WA_VVKK_SCT_STR-LNDSL_VX_OP sy-vline 
WA_VVKK_SCT_STR-GSART_VX_OP sy-vline 
WA_VVKK_SCT_STR-BSART_VX_OP sy-vline 
WA_VVKK_SCT_STR-GZART_VX_OP sy-vline 
WA_VVKK_SCT_STR-SDART_VX_OP sy-vline 
WA_VVKK_SCT_STR-SJAHR_VX_OP sy-vline 
WA_VVKK_SCT_STR-MJAHR_VX_OP sy-vline 
WA_VVKK_SCT_STR-RSART_VX_OP sy-vline 
WA_VVKK_SCT_STR-FUBER_VX_OP sy-vline 
WA_VVKK_SCT_STR-BEBER_VX_OP sy-vline 
WA_VVKK_SCT_STR-BSGRP_VX_OP sy-vline 
WA_VVKK_SCT_STR-XBLNR sy-vline 
WA_VVKK_SCT_STR-AKTYP_COINS sy-vline 
WA_VVKK_SCT_STR-COINS_CODE sy-vline 
WA_VVKK_SCT_STR-COINS_AMOUNT sy-vline 
WA_VVKK_SCT_STR-ESRNR sy-vline 
WA_VVKK_SCT_STR-ESRRE sy-vline 
WA_VVKK_SCT_STR-ESRPZ sy-vline 
WA_VVKK_SCT_STR-ESR_NAME1 sy-vline 
WA_VVKK_SCT_STR-ESR_NAME2 sy-vline 
WA_VVKK_SCT_STR-ESR_POST_CODE1 sy-vline 
WA_VVKK_SCT_STR-ESR_CITY1 sy-vline 
WA_VVKK_SCT_STR-ESR_STREET sy-vline 
WA_VVKK_SCT_STR-ESR_HOUSE_NUM1 sy-vline 
WA_VVKK_SCT_STR-QRIBAN sy-vline 
WA_VVKK_SCT_STR-GLO_REF1_OT sy-vline 
WA_VVKK_SCT_STR-ESR_LAND1 sy-vline 
WA_VVKK_SCT_STR-AKTYP_WH sy-vline 
WA_VVKK_SCT_STR-QSSEW sy-vline 
WA_VVKK_SCT_STR-STPRZ1 sy-vline 
WA_VVKK_SCT_STR-QSSHB sy-vline 
WA_VVKK_SCT_STR-QBSHB sy-vline 
WA_VVKK_SCT_STR-DUN_REASON_FDATE sy-vline 
WA_VVKK_SCT_STR-DUN_REASON_TDATE sy-vline 
WA_VVKK_SCT_STR-PAY_REASON_FDATE sy-vline 
WA_VVKK_SCT_STR-PAY_REASON_TDATE sy-vline 
WA_VVKK_SCT_STR-CLR_REASON_FDATE sy-vline 
WA_VVKK_SCT_STR-CLR_REASON_TDATE sy-vline 
WA_VVKK_SCT_STR-INT_REASON_FDATE sy-vline 
WA_VVKK_SCT_STR-INT_REASON_TDATE sy-vline 
WA_VVKK_SCT_STR-CPD_SWIFT sy-vline 
WA_VVKK_SCT_STR-CPD_IBAN sy-vline 
WA_VVKK_SCT_STR-AKTYP_ETAX sy-vline 
WA_VVKK_SCT_STR-KSCHL sy-vline 
WA_VVKK_SCT_STR-TAXAM sy-vline 
WA_VVKK_SCT_STR-STPRZ_ETAX sy-vline 
WA_VVKK_SCT_STR-SBASW sy-vline 
WA_VVKK_SCT_STR-MNDID sy-vline 
WA_VVKK_SCT_STR-BETRH sy-vline 
WA_VVKK_SCT_STR-KURSF sy-vline 
WA_VVKK_SCT_STR-KTOSL_TAX sy-vline      INTO ld_text SEPARATED BY SPACE.

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