ABAP Select data from SAP table FVD_CHK_SEPA_DD_RECORDS 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 FVD_CHK_SEPA_DD_RECORDS 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 FVD_CHK_SEPA_DD_RECORDS. 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 FVD_CHK_SEPA_DD_RECORDS 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_FVD_CHK_SEPA_DD_RECORDS TYPE STANDARD TABLE OF FVD_CHK_SEPA_DD_RECORDS,
      WA_FVD_CHK_SEPA_DD_RECORDS TYPE FVD_CHK_SEPA_DD_RECORDS,
      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: <FVD_CHK_SEPA_DD_RECORDS> TYPE FVD_CHK_SEPA_DD_RECORDS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FVD_CHK_SEPA_DD_RECORDS
*  INTO TABLE @DATA(IT_FVD_CHK_SEPA_DD_RECORDS2).
*--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_FVD_CHK_SEPA_DD_RECORDS INDEX 1 INTO DATA(WA_FVD_CHK_SEPA_DD_RECORDS2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FVD_CHK_SEPA_DD_RECORDS>-MANDT = 1.
<FVD_CHK_SEPA_DD_RECORDS>-BUKRS = 1.
<FVD_CHK_SEPA_DD_RECORDS>-RANL = 1.
<FVD_CHK_SEPA_DD_RECORDS>-DTRANS = 1.
<FVD_CHK_SEPA_DD_RECORDS>-TTRANS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FVD_CHK_SEPA_DD_RECORDS-NTRANS, sy-vline,
  WA_FVD_CHK_SEPA_DD_RECORDS-RERF, sy-vline,
  WA_FVD_CHK_SEPA_DD_RECORDS-DERF, sy-vline,
  WA_FVD_CHK_SEPA_DD_RECORDS-TERF, sy-vline,
  WA_FVD_CHK_SEPA_DD_RECORDS-REHER, sy-vline,
  WA_FVD_CHK_SEPA_DD_RECORDS-RBEAR, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FVD_CHK_SEPA_DD_RECORDS 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_FVD_CHK_SEPA_DD_RECORDS 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_FVD_CHK_SEPA_DD_RECORDS INTO WA_FVD_CHK_SEPA_DD_RECORDS.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field PRKEY
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FVD_CHK_SEPA_DD_RECORDS-PRKEY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FVD_CHK_SEPA_DD_RECORDS-PRKEY.
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_FVD_CHK_SEPA_DD_RECORDS_STR, 
MANDT TYPE STRING,
BUKRS TYPE STRING,
RANL TYPE STRING,
DTRANS TYPE STRING,
TTRANS TYPE STRING,
NTRANS TYPE STRING,
RERF TYPE STRING,
DERF TYPE STRING,
TERF TYPE STRING,
REHER TYPE STRING,
RBEAR TYPE STRING,
DBEAR TYPE STRING,
TBEAR TYPE STRING,
RBHER TYPE STRING,
DVORGANG TYPE STRING,
SVORGANG TYPE STRING,
NVORGANG TYPE STRING,
SBEWART TYPE STRING,
SREFBEW TYPE STRING,
SBEWZITI TYPE STRING,
SPLANIST TYPE STRING,
SSOLHAB TYPE STRING,
SSTORNO TYPE STRING,
SSTOGRD TYPE STRING,
ZUONR TYPE STRING,
RSTBLG TYPE STRING,
SGTXT TYPE STRING,
SANLF TYPE STRING,
DGUEL_KK TYPE STRING,
NLFD_ANG TYPE STRING,
SSTATI TYPE STRING,
GSART TYPE STRING,
RREFKONT TYPE STRING,
GSBER TYPE STRING,
DORDER TYPE STRING,
NORDER TYPE STRING,
BNWHR TYPE STRING,
SNWHR TYPE STRING,
BBWHR TYPE STRING,
SBWHR TYPE STRING,
BCWHR TYPE STRING,
SCWHR TYPE STRING,
BHWHR TYPE STRING,
KURS1 TYPE STRING,
KURS2 TYPE STRING,
DVALUT TYPE STRING,
DFAELL TYPE STRING,
DDISPO TYPE STRING,
DBESTAND TYPE STRING,
DBERVON TYPE STRING,
DBERBIS TYPE STRING,
ATAGE TYPE STRING,
ABASTAGE TYPE STRING,
SZBMETH TYPE STRING,
UMSKZ TYPE STRING,
KOSTL TYPE STRING,
SSPESEN TYPE STRING,
RSOLL TYPE STRING,
RHABEN TYPE STRING,
RZKSOLL TYPE STRING,
RZKHABE TYPE STRING,
SBSLSOLL TYPE STRING,
SBSLZKSO TYPE STRING,
SBSLZKHA TYPE STRING,
SHSLHABEN TYPE STRING,
RBANKK TYPE STRING,
SFDLEV TYPE STRING,
JFDUPD TYPE STRING,
JONLAEN TYPE STRING,
JZINSBAS TYPE STRING,
JZINSZPT TYPE STRING,
PKOND TYPE STRING,
BBASIS TYPE STRING,
SSORTZIT TYPE STRING,
SWOHER TYPE STRING,
SSTCKKZ TYPE STRING,
SSTCKTG TYPE STRING,
PEFFZINS TYPE STRING,
SEFFMETH TYPE STRING,
JVERF TYPE STRING,
KUNNR TYPE STRING,
BVTYP TYPE STRING,
ZLSCH TYPE STRING,
MABER TYPE STRING,
ZAHLS TYPE STRING,
RPARTNR TYPE STRING,
SROLEXT TYPE STRING,
RKLAMMER TYPE STRING,
JEINBEHALT TYPE STRING,
SZEGEN TYPE STRING,
MWSKZ TYPE STRING,
DTRANSREF TYPE STRING,
TTRANSREF TYPE STRING,
NTRANSREF TYPE STRING,
RPNNR TYPE STRING,
HBKID TYPE STRING,
SBUST TYPE STRING,
PWKURS TYPE STRING,
DSTOCK TYPE STRING,
JVORAUS TYPE STRING,
AMMRHY TYPE STRING,
SKOART TYPE STRING,
SEXCLVON TYPE STRING,
SULTVON TYPE STRING,
SINCLBIS TYPE STRING,
SULTBIS TYPE STRING,
SINCL TYPE STRING,
DVERRECH TYPE STRING,
DPKOND TYPE STRING,
RUMBLG TYPE STRING,
ZINKZ TYPE STRING,
SVULT TYPE STRING,
JSOFVERR TYPE STRING,
SINCLVERR TYPE STRING,
SULTVERR TYPE STRING,
SREFZITI TYPE STRING,
STGBASIS TYPE STRING,
STGMETH TYPE STRING,
SBASIS TYPE STRING,
SBERFIMA TYPE STRING,
SVORGKZ TYPE STRING,
MANSP TYPE STRING,
DGUEL_KP TYPE STRING,
NSTUFE TYPE STRING,
DBPERIOD TYPE STRING,
SPAEXCL TYPE STRING,
SPAULT TYPE STRING,
DEPERIOD TYPE STRING,
SPEINCL TYPE STRING,
SPEULT TYPE STRING,
RKONT TYPE STRING,
DAUSZ TYPE STRING,
SSOLIST TYPE STRING,
RDARNEHM TYPE STRING,
BKOND TYPE STRING,
RZEBEL TYPE STRING,
ZFBDT TYPE STRING,
DZFEST TYPE STRING,
SBERECH TYPE STRING,
BKARZINS TYPE STRING,
BTITALK TYPE STRING,
HDN_KUNNR TYPE STRING,
SZART TYPE STRING,
RUZBEL TYPE STRING,
REBZJ TYPE STRING,
REBZG TYPE STRING,
REBZZ TYPE STRING,
S_SSDREF TYPE STRING,
SAEND TYPE STRING,
XPORE TYPE STRING,
SPAYRQ TYPE STRING,
PRKEY TYPE STRING,
HKTID TYPE STRING,
VORGTYP TYPE STRING,
ACENV TYPE STRING,
SSIGN TYPE STRING,
SPRSNG TYPE STRING,
UZAWE TYPE STRING,
SPRGRD TYPE STRING,
SCSPAY TYPE STRING,
ZWELS TYPE STRING,
PAYGR TYPE STRING,
JEXPOZINS TYPE STRING,
SREVALEXCL TYPE STRING,
RBO TYPE STRING,
SROUND TYPE STRING,
SKALIDWT TYPE STRING,
PPAYMENT TYPE STRING,
AMMRHYZV TYPE STRING,
LC_CAPITALS TYPE STRING,
LC_DISBURSE TYPE STRING,
OP_APPLICATION TYPE STRING,
OP_RBO TYPE STRING,
DFAELL_OLD_EXT TYPE STRING,
DDISPO_OLD_EXT TYPE STRING,
RBO_EXT TYPE STRING,
SBEWEGRP2 TYPE STRING,
SUSP_REASON_TYPE TYPE STRING,
MNDID TYPE STRING,
SBEWEGRP TYPE STRING,
REMIT_INFO TYPE STRING,
DIP_KUKEY TYPE STRING,
DIP_ESNUM TYPE STRING,
DIP_ID TYPE STRING,
DIP_DATE TYPE STRING,
FLG_IP_CLI_NOTICE TYPE STRING,
AAVGDAYS TYPE STRING,
PAVGINTEREST TYPE STRING,
JAVGCAP TYPE STRING,
PAVGCAP TYPE STRING,
JAVGFLOOR TYPE STRING,
PAVGFLOOR TYPE STRING,
PAVGSPREAD TYPE STRING,
SROUNDAVGINTEREST TYPE STRING,
ROUNDDECAVGINTEREST TYPE STRING,
AAVGWEIGHT TYPE STRING,
AAVGWEIGHTSUM TYPE STRING,
JEXPOINTFACTOR TYPE STRING,
FLOWFACTOR TYPE STRING,
BASEFACTOR TYPE STRING,
SFACTORRESET TYPE STRING,
CA_DTRANS TYPE STRING,
CA_TTRANS TYPE STRING,
CA_NTRANS TYPE STRING,
CA_FLG_ORG TYPE STRING,
CA_REFERENCE TYPE STRING,
BROUNDUNIT TYPE STRING,
SEPA_PD TYPE STRING,
B2B TYPE STRING,
MND_USAGE TYPE STRING,
FLG_FULDISB TYPE STRING,
SND_COUNTRY TYPE STRING,
SND_BIC TYPE STRING,
REC_COUNTRY TYPE STRING,
REC_BIC TYPE STRING,
LEADTIME TYPE STRING,
CALENDAR TYPE STRING,
SEPA_LEAD_DATE TYPE STRING,
SEPA_ERROR_CODE TYPE STRING,
SEPA_ERROR_MESSAGE TYPE STRING,
SEPA_BADI_CHANGE TYPE STRING,
SEPA_INDEX TYPE STRING,
SIGN TYPE STRING,
I_BUKRS TYPE STRING,
I_B2B TYPE STRING,
I_SEQ_TYPE TYPE STRING,
I_UBNKS TYPE STRING,
I_UBNKY TYPE STRING,
I_ZBNKS TYPE STRING,
I_ZBNKY TYPE STRING,
I_ZIBAN TYPE STRING,
DEFAULT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FVD_CHK_SEPA_DD_RECORDS_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_FVD_CHK_SEPA_DD_RECORDS_STR-MANDT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BUKRS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RANL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DTRANS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-TTRANS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-NTRANS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RERF sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DERF sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-TERF sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-REHER sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RBEAR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DBEAR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-TBEAR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RBHER sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DVORGANG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SVORGANG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-NVORGANG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBEWART sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SREFBEW sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBEWZITI sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SPLANIST sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSOLHAB sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSTORNO sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSTOGRD sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ZUONR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RSTBLG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SGTXT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SANLF sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DGUEL_KK sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-NLFD_ANG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSTATI sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-GSART sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RREFKONT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-GSBER sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DORDER sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-NORDER sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BNWHR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SNWHR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BBWHR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBWHR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BCWHR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SCWHR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BHWHR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-KURS1 sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-KURS2 sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DVALUT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DFAELL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DDISPO sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DBESTAND sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DBERVON sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DBERBIS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ATAGE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ABASTAGE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SZBMETH sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-UMSKZ sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-KOSTL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSPESEN sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RSOLL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RHABEN sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RZKSOLL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RZKHABE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBSLSOLL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBSLZKSO sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBSLZKHA sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SHSLHABEN sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RBANKK sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SFDLEV sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JFDUPD sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JONLAEN sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JZINSBAS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JZINSZPT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PKOND sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BBASIS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSORTZIT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SWOHER sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSTCKKZ sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSTCKTG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PEFFZINS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SEFFMETH sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JVERF sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-KUNNR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BVTYP sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ZLSCH sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-MABER sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ZAHLS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RPARTNR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SROLEXT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RKLAMMER sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JEINBEHALT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SZEGEN sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-MWSKZ sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DTRANSREF sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-TTRANSREF sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-NTRANSREF sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RPNNR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-HBKID sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBUST sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PWKURS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DSTOCK sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JVORAUS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-AMMRHY sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SKOART sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SEXCLVON sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SULTVON sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SINCLBIS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SULTBIS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SINCL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DVERRECH sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DPKOND sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RUMBLG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ZINKZ sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SVULT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JSOFVERR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SINCLVERR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SULTVERR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SREFZITI sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-STGBASIS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-STGMETH sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBASIS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBERFIMA sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SVORGKZ sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-MANSP sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DGUEL_KP sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-NSTUFE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DBPERIOD sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SPAEXCL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SPAULT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DEPERIOD sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SPEINCL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SPEULT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RKONT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DAUSZ sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSOLIST sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RDARNEHM sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BKOND sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RZEBEL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ZFBDT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DZFEST sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBERECH sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BKARZINS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BTITALK sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-HDN_KUNNR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SZART sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RUZBEL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-REBZJ sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-REBZG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-REBZZ sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-S_SSDREF sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SAEND sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-XPORE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SPAYRQ sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PRKEY sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-HKTID sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-VORGTYP sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ACENV sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SSIGN sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SPRSNG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-UZAWE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SPRGRD sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SCSPAY sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ZWELS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PAYGR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JEXPOZINS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SREVALEXCL sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RBO sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SROUND sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SKALIDWT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PPAYMENT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-AMMRHYZV sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-LC_CAPITALS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-LC_DISBURSE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-OP_APPLICATION sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-OP_RBO sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DFAELL_OLD_EXT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DDISPO_OLD_EXT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-RBO_EXT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBEWEGRP2 sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SUSP_REASON_TYPE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-MNDID sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SBEWEGRP sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-REMIT_INFO sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DIP_KUKEY sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DIP_ESNUM sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DIP_ID sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DIP_DATE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-FLG_IP_CLI_NOTICE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-AAVGDAYS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PAVGINTEREST sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JAVGCAP sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PAVGCAP sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JAVGFLOOR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PAVGFLOOR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-PAVGSPREAD sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SROUNDAVGINTEREST sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-ROUNDDECAVGINTEREST sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-AAVGWEIGHT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-AAVGWEIGHTSUM sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-JEXPOINTFACTOR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-FLOWFACTOR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BASEFACTOR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SFACTORRESET sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-CA_DTRANS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-CA_TTRANS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-CA_NTRANS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-CA_FLG_ORG sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-CA_REFERENCE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-BROUNDUNIT sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SEPA_PD sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-B2B sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-MND_USAGE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-FLG_FULDISB sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SND_COUNTRY sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SND_BIC sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-REC_COUNTRY sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-REC_BIC sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-LEADTIME sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-CALENDAR sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SEPA_LEAD_DATE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SEPA_ERROR_CODE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SEPA_ERROR_MESSAGE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SEPA_BADI_CHANGE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SEPA_INDEX sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-SIGN sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-I_BUKRS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-I_B2B sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-I_SEQ_TYPE sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-I_UBNKS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-I_UBNKY sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-I_ZBNKS sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-I_ZBNKY sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-I_ZIBAN sy-vline 
WA_FVD_CHK_SEPA_DD_RECORDS_STR-DEFAULT sy-vline      INTO ld_text SEPARATED BY SPACE.

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