ABAP Select data from SAP table FFO_PAYTLIST_PAYTPRPSL_PAYMENT into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP FFO_PAYTLIST_PAYTPRPSL_PAYMENT 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 FFO_PAYTLIST_PAYTPRPSL_PAYMENT. 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 FFO_PAYTLIST_PAYTPRPSL_PAYMENT 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_FFO_PAYTLIST_PAYTPRPSL_PAYMENT TYPE STANDARD TABLE OF FFO_PAYTLIST_PAYTPRPSL_PAYMENT,
      WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT TYPE FFO_PAYTLIST_PAYTPRPSL_PAYMENT,
      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: <FFO_PAYTLIST_PAYTPRPSL_PAYMENT> TYPE FFO_PAYTLIST_PAYTPRPSL_PAYMENT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FFO_PAYTLIST_PAYTPRPSL_PAYMENT
*  INTO TABLE @DATA(IT_FFO_PAYTLIST_PAYTPRPSL_PAYMENT2).
*--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_FFO_PAYTLIST_PAYTPRPSL_PAYMENT INDEX 1 INTO DATA(WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FFO_PAYTLIST_PAYTPRPSL_PAYMENT ASSIGNING <FFO_PAYTLIST_PAYTPRPSL_PAYMENT>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FFO_PAYTLIST_PAYTPRPSL_PAYMENT>-PAYMENTRUNISPROPOSAL = 1.
<FFO_PAYTLIST_PAYTPRPSL_PAYMENT>-PAYMENTDOCUMENT = 1.
<FFO_PAYTLIST_PAYTPRPSL_PAYMENT>-NUMBEROFPAIDITEMS = 1.
<FFO_PAYTLIST_PAYTPRPSL_PAYMENT>-HOUSEBANK = 1.
<FFO_PAYTLIST_PAYTPRPSL_PAYMENT>-HOUSEBANKACCOUNT = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYMENTMETHOD, sy-vline,
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYMENTMETHODNAME, sy-vline,
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAIDAMOUNTINPAYTCURRENCY, sy-vline,
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYMENTCURRENCY, sy-vline,
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYTAMOUNTINCOCODECURRENCY, sy-vline,
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-LOSTCASHDISCOUNTINCOCODECRCY, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT 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_FFO_PAYTLIST_PAYTPRPSL_PAYMENT 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_FFO_PAYTLIST_PAYTPRPSL_PAYMENT INTO WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT. *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 PAYMENTDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYMENTDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYMENTDOCUMENT.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ISOLA, internal->external for field PAYEELANGUAGE CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYEELANGUAGE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYEELANGUAGE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PAYMENTORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYMENTORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT-PAYMENTORDER.
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_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR,
PAYMENTRUNISPROPOSAL TYPE STRING,
PAYMENTDOCUMENT TYPE STRING,
NUMBEROFPAIDITEMS TYPE STRING,
HOUSEBANK TYPE STRING,
HOUSEBANKACCOUNT TYPE STRING,
PAYMENTMETHOD TYPE STRING,
PAYMENTMETHODNAME TYPE STRING,
PAIDAMOUNTINPAYTCURRENCY TYPE STRING,
PAYMENTCURRENCY TYPE STRING,
PAYTAMOUNTINCOCODECURRENCY TYPE STRING,
LOSTCASHDISCOUNTINCOCODECRCY TYPE STRING,
WHLDGTAXAMTINCOCODECRCY TYPE STRING,
TOTDEDUCTIONAMTINCOCODECRCY TYPE STRING,
LOSTCASHDISCOUNTINTRANSACCRCY TYPE STRING,
WHLDGTAXAMTINTRANSACCRCY TYPE STRING,
TOTDEDUCTIONAMTINTRANSACCRCY TYPE STRING,
BANKACCOUNTHOLDERNAME TYPE STRING,
PAYINGCOMPANYCODE TYPE STRING,
SUPPLIER TYPE STRING,
CUSTOMER TYPE STRING,
PAYMENTRECIPIENT TYPE STRING,
BUSINESSAREA TYPE STRING,
SUPPLIERNAME TYPE STRING,
SUPPLIERADDITIONALNAME TYPE STRING,
POSTALCODE TYPE STRING,
POBOXPOSTALCODE TYPE STRING,
SUPPLIERCITYNAME TYPE STRING,
STREETADDRESSNAME TYPE STRING,
POBOX TYPE STRING,
PAYEEBANKCOUNTRY TYPE STRING,
REGION TYPE STRING,
PAYEENAME TYPE STRING,
PAYEEADDITIONALNAME TYPE STRING,
PAYEEPOSTALCODE TYPE STRING,
PAYEEPOBOXPOSTALCODE TYPE STRING,
PAYEECITYNAME TYPE STRING,
DISTRICT TYPE STRING,
POBOXDEVIATINGCITYNAME TYPE STRING,
PAYEESTREET TYPE STRING,
PAYEEPOBOX TYPE STRING,
PAYEECOUNTRY TYPE STRING,
SUPPLIERCOUNTRY TYPE STRING,
PAYEEBANKKEY TYPE STRING,
PAYEEBANKNUMBER TYPE STRING,
PAYEEBANKACCOUNT TYPE STRING,
PAYEEBANKACCOUNTLONGID TYPE STRING,
PAYEEBANKCONTROLKEY TYPE STRING,
BANKACCOUNTREFERENCETEXT TYPE STRING,
PAYEEIBAN TYPE STRING,
PAYEEBANKNAME TYPE STRING,
PAYEEBANKCITYNAME TYPE STRING,
PAYEELANGUAGE TYPE STRING,
SENDINGCOMPANYCODE TYPE STRING,
BANKCOUNTRY TYPE STRING,
BANKKEY TYPE STRING,
BANKNUMBER TYPE STRING,
BANKCONTROLKEY TYPE STRING,
BANKACCOUNT TYPE STRING,
BANKACCOUNTLONGID TYPE STRING,
HOUSEBANKIBAN TYPE STRING,
PAYMENTMETHODSUPPLEMENT TYPE STRING,
ADDITIONALPAYMENTMETHOD TYPE STRING,
EDIPAYMENTADVICESTATUS TYPE STRING,
EDIPAYMENTORDERSTATUS TYPE STRING,
POSTINGDATE TYPE STRING,
VALUEDATE TYPE STRING,
PAIDITEMDUEDATE TYPE STRING,
NETAMOUNTINTRANSACCURRENCY TYPE STRING,
NETAMOUNTINCOCODECURRENCY TYPE STRING,
CASHDISCOUNTAMTINCOCODECRCY TYPE STRING,
CASHDISCOUNTAMTINTRANSACCRCY TYPE STRING,
GROSSAMOUNTINCOCODECURRENCY TYPE STRING,
GROSSAMOUNTINPAYMENTCURRENCY TYPE STRING,
PAYMENTREQUESTPAYMENTGROUP TYPE STRING,
NUMBEROFTEXTLINES TYPE STRING,
ACCOUNTINGCLERK TYPE STRING,
SUPPLIERCLERKIDBYSUPPLIER TYPE STRING,
PAYMENTREFERENCE TYPE STRING,
DATAEXCHANGEINSTRUCTIONKEY TYPE STRING,
DATAEXCHANGEINSTRUCTION1 TYPE STRING,
DATAEXCHANGEINSTRUCTION2 TYPE STRING,
DATAEXCHANGEINSTRUCTION3 TYPE STRING,
DATAEXCHANGEINSTRUCTION4 TYPE STRING,
PERSONNELNUMBER TYPE STRING,
SWIFTCODE TYPE STRING,
SEPASEQUENCETYPE TYPE STRING,
BANKBRANCH TYPE STRING,
SEPAMANDATE TYPE STRING,
DIRECTDEBITTYPE TYPE STRING,
HOUSEBANKACCOUNTDESCRIPTION TYPE STRING,
COMPANYCODECURRENCY TYPE STRING,
HOUSEBANKNAME TYPE STRING,
PAYMENTORDER TYPE STRING,
PAYEEBANKBRANCH TYPE STRING,
SWIFTTRANSACTIONREFERENCEUUID TYPE STRING,
BUSINESSPLACE TYPE STRING,END OF T_EKKO_STR. DATA: WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_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_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTRUNISPROPOSAL sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTDOCUMENT sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-NUMBEROFPAIDITEMS sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-HOUSEBANK sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-HOUSEBANKACCOUNT sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTMETHOD sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTMETHODNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAIDAMOUNTINPAYTCURRENCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTCURRENCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYTAMOUNTINCOCODECURRENCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-LOSTCASHDISCOUNTINCOCODECRCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-WHLDGTAXAMTINCOCODECRCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-TOTDEDUCTIONAMTINCOCODECRCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-LOSTCASHDISCOUNTINTRANSACCRCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-WHLDGTAXAMTINTRANSACCRCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-TOTDEDUCTIONAMTINTRANSACCRCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BANKACCOUNTHOLDERNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYINGCOMPANYCODE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SUPPLIER sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-CUSTOMER sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTRECIPIENT sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BUSINESSAREA sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SUPPLIERNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SUPPLIERADDITIONALNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-POSTALCODE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-POBOXPOSTALCODE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SUPPLIERCITYNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-STREETADDRESSNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-POBOX sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEBANKCOUNTRY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-REGION sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEENAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEADDITIONALNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEPOSTALCODE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEPOBOXPOSTALCODE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEECITYNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-DISTRICT sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-POBOXDEVIATINGCITYNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEESTREET sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEPOBOX sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEECOUNTRY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SUPPLIERCOUNTRY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEBANKKEY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEBANKNUMBER sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEBANKACCOUNT sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEBANKACCOUNTLONGID sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEBANKCONTROLKEY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BANKACCOUNTREFERENCETEXT sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEIBAN sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEBANKNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEBANKCITYNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEELANGUAGE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SENDINGCOMPANYCODE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BANKCOUNTRY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BANKKEY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BANKNUMBER sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BANKCONTROLKEY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BANKACCOUNT sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BANKACCOUNTLONGID sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-HOUSEBANKIBAN sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTMETHODSUPPLEMENT sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-ADDITIONALPAYMENTMETHOD sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-EDIPAYMENTADVICESTATUS sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-EDIPAYMENTORDERSTATUS sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-POSTINGDATE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-VALUEDATE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAIDITEMDUEDATE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-NETAMOUNTINTRANSACCURRENCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-NETAMOUNTINCOCODECURRENCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-CASHDISCOUNTAMTINCOCODECRCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-CASHDISCOUNTAMTINTRANSACCRCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-GROSSAMOUNTINCOCODECURRENCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-GROSSAMOUNTINPAYMENTCURRENCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTREQUESTPAYMENTGROUP sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-NUMBEROFTEXTLINES sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-ACCOUNTINGCLERK sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SUPPLIERCLERKIDBYSUPPLIER sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTREFERENCE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-DATAEXCHANGEINSTRUCTIONKEY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-DATAEXCHANGEINSTRUCTION1 sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-DATAEXCHANGEINSTRUCTION2 sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-DATAEXCHANGEINSTRUCTION3 sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-DATAEXCHANGEINSTRUCTION4 sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PERSONNELNUMBER sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SWIFTCODE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SEPASEQUENCETYPE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BANKBRANCH sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SEPAMANDATE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-DIRECTDEBITTYPE sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-HOUSEBANKACCOUNTDESCRIPTION sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-COMPANYCODECURRENCY sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-HOUSEBANKNAME sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYMENTORDER sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-PAYEEBANKBRANCH sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-SWIFTTRANSACTIONREFERENCEUUID sy-vline
WA_FFO_PAYTLIST_PAYTPRPSL_PAYMENT_STR-BUSINESSPLACE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.