ABAP Select data from SAP table CRMS4IUVICAP 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 CRMS4IUVICAP 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 CRMS4IUVICAP. 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 CRMS4IUVICAP 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_CRMS4IUVICAP TYPE STANDARD TABLE OF CRMS4IUVICAP,
      WA_CRMS4IUVICAP TYPE CRMS4IUVICAP,
      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: <CRMS4IUVICAP> TYPE CRMS4IUVICAP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CRMS4IUVICAP
*  INTO TABLE @DATA(IT_CRMS4IUVICAP2).
*--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_CRMS4IUVICAP INDEX 1 INTO DATA(WA_CRMS4IUVICAP2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CRMS4IUVICAP>-MANDT = 1.
<CRMS4IUVICAP>-CONTRACTACCOUNT = 1.
<CRMS4IUVICAP>-BUSINESSPARTNER = 1.
<CRMS4IUVICAP>-GUID = 1.
<CRMS4IUVICAP>-CONTRACTACCOUNTNAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CRMS4IUVICAP-CREATIONDATE, sy-vline,
  WA_CRMS4IUVICAP-CREATEDBYUSER, sy-vline,
  WA_CRMS4IUVICAP-ISMARKEDFORDELETION, sy-vline,
  WA_CRMS4IUVICAP-LASTCHANGEDATE, sy-vline,
  WA_CRMS4IUVICAP-LASTCHANGEDBYUSER, sy-vline,
  WA_CRMS4IUVICAP-PARTNERCOMPANY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CRMS4IUVICAP 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_CRMS4IUVICAP 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_CRMS4IUVICAP INTO WA_CRMS4IUVICAP.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field CAADDRESSIDOFJURISDICTIONCODE
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CRMS4IUVICAP-CAADDRESSIDOFJURISDICTIONCODE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRMS4IUVICAP-CAADDRESSIDOFJURISDICTIONCODE.
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_CRMS4IUVICAP_STR, 
MANDT TYPE STRING,
CONTRACTACCOUNT TYPE STRING,
BUSINESSPARTNER TYPE STRING,
GUID TYPE STRING,
CONTRACTACCOUNTNAME TYPE STRING,
CREATIONDATE TYPE STRING,
CREATEDBYUSER TYPE STRING,
ISMARKEDFORDELETION TYPE STRING,
LASTCHANGEDATE TYPE STRING,
LASTCHANGEDBYUSER TYPE STRING,
PARTNERCOMPANY TYPE STRING,
CARELATIONSHIPOFBPTOCONTRACCT TYPE STRING,
CACOLLECTIONSCLERK TYPE STRING,
CAAUTHORIZATIONGROUP TYPE STRING,
CACLEARINGCATEGORY TYPE STRING,
CASHPLANNINGGROUP TYPE STRING,
CAINTERESTCODE TYPE STRING,
CABPREFERENCENUMBER TYPE STRING,
CAADDITIONALDAYSFORCASHMGMT TYPE STRING,
PAYMENTCONDITION TYPE STRING,
CAACCOUNTDETERMINATIONCODE TYPE STRING,
CAALTERNATIVEINVOICERECIPIENT TYPE STRING,
ALTVCONTRACTACCTFORCOLLVBILLS TYPE STRING,
TAXJURISDICTION TYPE STRING,
CACOMPANYCODEGROUP TYPE STRING,
CASTANDARDCOMPANYCODE TYPE STRING,
CABUSINESSPARTNERFORPAYMENT TYPE STRING,
CONTRACTACCOUNTFORPAYMENT TYPE STRING,
CAHOUSEBANKREFERENCE TYPE STRING,
CAPAYMENTMETHODFORINCGPAYMENT TYPE STRING,
CADIRECTDEBITLIMIT TYPE STRING,
CACURRENCYFORDIRECTDEBITLIMIT TYPE STRING,
CADIRECTDEBITLIMITCALCMODE TYPE STRING,
CAALTERNATIVEPAYER TYPE STRING,
CABANKIDFORINCOMINGPAYMENTS TYPE STRING,
SEPAMANDATE TYPE STRING,
CAPAYMENTCARDIDFORINCOMINGPAYT TYPE STRING,
CAPAYMENTMETHODFOROUTGPAYMENT TYPE STRING,
CAALTERNATIVEPAYEE TYPE STRING,
CABANKIDFOROUTGOINGPAYMENTS TYPE STRING,
CAPAYMENTCARDIDFOROUTGOINGPAYT TYPE STRING,
CAWHLDGTAXCODEINCOMINGPAYT TYPE STRING,
CAWHLDGTAXCODEOUTGOINGPAYT TYPE STRING,
SUPPLYINGCOUNTRY TYPE STRING,
BUSINESSPLACE TYPE STRING,
WITHHOLDINGTAXCERTIFICATE TYPE STRING,
VALDTYDATEFORWHLDGTAXEXMPCERT TYPE STRING,
FITYP TYPE STRING,
PROVINCE TYPE STRING,
COUNTY TYPE STRING,
CACOLLECTIONSMASTERDATAGROUP TYPE STRING,
CACOLLECTIONSTRATEGY TYPE STRING,
CACOLLECTIONSCONTACTPERSON TYPE STRING,
CACORRESPONDENCEVARIANT TYPE STRING,
CACORRESPONDENCEDUNNINGPROCED TYPE STRING,
CAALTERNATIVECORRESPNCRCPNT TYPE STRING,
CACORRESPONDENCEACTIVITYCODE TYPE STRING,
CAINVCGCATEGORY TYPE STRING,
CAINVCGSCHEDULE TYPE STRING,
CATARGETCURRENCYFORINVOICING TYPE STRING,
CADETNCODEFORALTVINVOICEFORM TYPE STRING,
CABUSINESSPARTNERFORPOSTING TYPE STRING,
CONTRACTACCOUNTFORPOSTING TYPE STRING,
CABUSINESSPARTNERFORINVCGLIST TYPE STRING,
CONTRACTACCOUNTFORINVCGLIST TYPE STRING,
CAMASTERAGREEMENT TYPE STRING,
CAPARTNERSETTLEMENTRULE TYPE STRING,
CABILLGCYCLE TYPE STRING,
CALASTDAYOFBILLINGPERIOD TYPE STRING,
CASTARTDATEFORBILLINGPERIOD TYPE STRING,
CADUNNINGPROCEDURE TYPE STRING,
CADUNNINGNOTICEGROUP TYPE STRING,
CAALTERNATIVEDUNNINGRECIPIENT TYPE STRING,
CAADDRESSIDOFALTERNATIVEPAYER TYPE STRING,
CAADDRESSIDOFALTERNATIVEPAYEE TYPE STRING,
CAADDRESSIDOFALTVDUNRECIPIENT TYPE STRING,
CAADDRESSIDOFALTVINVOICERCPNT TYPE STRING,
ADDRESSID TYPE STRING,
CAADDRESSIDOFJURISDICTIONCODE TYPE STRING,
CACLEARINGRESTRICTION TYPE STRING,
CAPAYMENTCOMPANYCODE TYPE STRING,
COUNTRY TYPE STRING,
CATOLERANCEGROUP TYPE STRING,
CABUSINESSPARTNERLOCK TYPE STRING,
CABUSINESSPARTNERLOCKSTARTDATE TYPE STRING,
CABUSINESSPARTNERLOCKENDDATE TYPE STRING,
CANMBRMNTHSFORDIRECTDEBITLIMIT TYPE STRING,
BUSINESSAREA TYPE STRING,
DUNNINGLOCKREASON TYPE STRING,
INVOICINGLOCKREASON TYPE STRING,
CONVERGENTINVOICINGLOCKREASON TYPE STRING,
POSTINGLOCKREASON TYPE STRING,
CALCULATEINTERESTLOCKREASON TYPE STRING,
INCOMINGPAYMENTLOCKREASON TYPE STRING,
OUTGOINGPAYMENTLOCKREASON TYPE STRING,
CORRDUNNINGLOCKREASON TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CRMS4IUVICAP_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_CRMS4IUVICAP_STR-MANDT sy-vline 
WA_CRMS4IUVICAP_STR-CONTRACTACCOUNT sy-vline 
WA_CRMS4IUVICAP_STR-BUSINESSPARTNER sy-vline 
WA_CRMS4IUVICAP_STR-GUID sy-vline 
WA_CRMS4IUVICAP_STR-CONTRACTACCOUNTNAME sy-vline 
WA_CRMS4IUVICAP_STR-CREATIONDATE sy-vline 
WA_CRMS4IUVICAP_STR-CREATEDBYUSER sy-vline 
WA_CRMS4IUVICAP_STR-ISMARKEDFORDELETION sy-vline 
WA_CRMS4IUVICAP_STR-LASTCHANGEDATE sy-vline 
WA_CRMS4IUVICAP_STR-LASTCHANGEDBYUSER sy-vline 
WA_CRMS4IUVICAP_STR-PARTNERCOMPANY sy-vline 
WA_CRMS4IUVICAP_STR-CARELATIONSHIPOFBPTOCONTRACCT sy-vline 
WA_CRMS4IUVICAP_STR-CACOLLECTIONSCLERK sy-vline 
WA_CRMS4IUVICAP_STR-CAAUTHORIZATIONGROUP sy-vline 
WA_CRMS4IUVICAP_STR-CACLEARINGCATEGORY sy-vline 
WA_CRMS4IUVICAP_STR-CASHPLANNINGGROUP sy-vline 
WA_CRMS4IUVICAP_STR-CAINTERESTCODE sy-vline 
WA_CRMS4IUVICAP_STR-CABPREFERENCENUMBER sy-vline 
WA_CRMS4IUVICAP_STR-CAADDITIONALDAYSFORCASHMGMT sy-vline 
WA_CRMS4IUVICAP_STR-PAYMENTCONDITION sy-vline 
WA_CRMS4IUVICAP_STR-CAACCOUNTDETERMINATIONCODE sy-vline 
WA_CRMS4IUVICAP_STR-CAALTERNATIVEINVOICERECIPIENT sy-vline 
WA_CRMS4IUVICAP_STR-ALTVCONTRACTACCTFORCOLLVBILLS sy-vline 
WA_CRMS4IUVICAP_STR-TAXJURISDICTION sy-vline 
WA_CRMS4IUVICAP_STR-CACOMPANYCODEGROUP sy-vline 
WA_CRMS4IUVICAP_STR-CASTANDARDCOMPANYCODE sy-vline 
WA_CRMS4IUVICAP_STR-CABUSINESSPARTNERFORPAYMENT sy-vline 
WA_CRMS4IUVICAP_STR-CONTRACTACCOUNTFORPAYMENT sy-vline 
WA_CRMS4IUVICAP_STR-CAHOUSEBANKREFERENCE sy-vline 
WA_CRMS4IUVICAP_STR-CAPAYMENTMETHODFORINCGPAYMENT sy-vline 
WA_CRMS4IUVICAP_STR-CADIRECTDEBITLIMIT sy-vline 
WA_CRMS4IUVICAP_STR-CACURRENCYFORDIRECTDEBITLIMIT sy-vline 
WA_CRMS4IUVICAP_STR-CADIRECTDEBITLIMITCALCMODE sy-vline 
WA_CRMS4IUVICAP_STR-CAALTERNATIVEPAYER sy-vline 
WA_CRMS4IUVICAP_STR-CABANKIDFORINCOMINGPAYMENTS sy-vline 
WA_CRMS4IUVICAP_STR-SEPAMANDATE sy-vline 
WA_CRMS4IUVICAP_STR-CAPAYMENTCARDIDFORINCOMINGPAYT sy-vline 
WA_CRMS4IUVICAP_STR-CAPAYMENTMETHODFOROUTGPAYMENT sy-vline 
WA_CRMS4IUVICAP_STR-CAALTERNATIVEPAYEE sy-vline 
WA_CRMS4IUVICAP_STR-CABANKIDFOROUTGOINGPAYMENTS sy-vline 
WA_CRMS4IUVICAP_STR-CAPAYMENTCARDIDFOROUTGOINGPAYT sy-vline 
WA_CRMS4IUVICAP_STR-CAWHLDGTAXCODEINCOMINGPAYT sy-vline 
WA_CRMS4IUVICAP_STR-CAWHLDGTAXCODEOUTGOINGPAYT sy-vline 
WA_CRMS4IUVICAP_STR-SUPPLYINGCOUNTRY sy-vline 
WA_CRMS4IUVICAP_STR-BUSINESSPLACE sy-vline 
WA_CRMS4IUVICAP_STR-WITHHOLDINGTAXCERTIFICATE sy-vline 
WA_CRMS4IUVICAP_STR-VALDTYDATEFORWHLDGTAXEXMPCERT sy-vline 
WA_CRMS4IUVICAP_STR-FITYP sy-vline 
WA_CRMS4IUVICAP_STR-PROVINCE sy-vline 
WA_CRMS4IUVICAP_STR-COUNTY sy-vline 
WA_CRMS4IUVICAP_STR-CACOLLECTIONSMASTERDATAGROUP sy-vline 
WA_CRMS4IUVICAP_STR-CACOLLECTIONSTRATEGY sy-vline 
WA_CRMS4IUVICAP_STR-CACOLLECTIONSCONTACTPERSON sy-vline 
WA_CRMS4IUVICAP_STR-CACORRESPONDENCEVARIANT sy-vline 
WA_CRMS4IUVICAP_STR-CACORRESPONDENCEDUNNINGPROCED sy-vline 
WA_CRMS4IUVICAP_STR-CAALTERNATIVECORRESPNCRCPNT sy-vline 
WA_CRMS4IUVICAP_STR-CACORRESPONDENCEACTIVITYCODE sy-vline 
WA_CRMS4IUVICAP_STR-CAINVCGCATEGORY sy-vline 
WA_CRMS4IUVICAP_STR-CAINVCGSCHEDULE sy-vline 
WA_CRMS4IUVICAP_STR-CATARGETCURRENCYFORINVOICING sy-vline 
WA_CRMS4IUVICAP_STR-CADETNCODEFORALTVINVOICEFORM sy-vline 
WA_CRMS4IUVICAP_STR-CABUSINESSPARTNERFORPOSTING sy-vline 
WA_CRMS4IUVICAP_STR-CONTRACTACCOUNTFORPOSTING sy-vline 
WA_CRMS4IUVICAP_STR-CABUSINESSPARTNERFORINVCGLIST sy-vline 
WA_CRMS4IUVICAP_STR-CONTRACTACCOUNTFORINVCGLIST sy-vline 
WA_CRMS4IUVICAP_STR-CAMASTERAGREEMENT sy-vline 
WA_CRMS4IUVICAP_STR-CAPARTNERSETTLEMENTRULE sy-vline 
WA_CRMS4IUVICAP_STR-CABILLGCYCLE sy-vline 
WA_CRMS4IUVICAP_STR-CALASTDAYOFBILLINGPERIOD sy-vline 
WA_CRMS4IUVICAP_STR-CASTARTDATEFORBILLINGPERIOD sy-vline 
WA_CRMS4IUVICAP_STR-CADUNNINGPROCEDURE sy-vline 
WA_CRMS4IUVICAP_STR-CADUNNINGNOTICEGROUP sy-vline 
WA_CRMS4IUVICAP_STR-CAALTERNATIVEDUNNINGRECIPIENT sy-vline 
WA_CRMS4IUVICAP_STR-CAADDRESSIDOFALTERNATIVEPAYER sy-vline 
WA_CRMS4IUVICAP_STR-CAADDRESSIDOFALTERNATIVEPAYEE sy-vline 
WA_CRMS4IUVICAP_STR-CAADDRESSIDOFALTVDUNRECIPIENT sy-vline 
WA_CRMS4IUVICAP_STR-CAADDRESSIDOFALTVINVOICERCPNT sy-vline 
WA_CRMS4IUVICAP_STR-ADDRESSID sy-vline 
WA_CRMS4IUVICAP_STR-CAADDRESSIDOFJURISDICTIONCODE sy-vline 
WA_CRMS4IUVICAP_STR-CACLEARINGRESTRICTION sy-vline 
WA_CRMS4IUVICAP_STR-CAPAYMENTCOMPANYCODE sy-vline 
WA_CRMS4IUVICAP_STR-COUNTRY sy-vline 
WA_CRMS4IUVICAP_STR-CATOLERANCEGROUP sy-vline 
WA_CRMS4IUVICAP_STR-CABUSINESSPARTNERLOCK sy-vline 
WA_CRMS4IUVICAP_STR-CABUSINESSPARTNERLOCKSTARTDATE sy-vline 
WA_CRMS4IUVICAP_STR-CABUSINESSPARTNERLOCKENDDATE sy-vline 
WA_CRMS4IUVICAP_STR-CANMBRMNTHSFORDIRECTDEBITLIMIT sy-vline 
WA_CRMS4IUVICAP_STR-BUSINESSAREA sy-vline 
WA_CRMS4IUVICAP_STR-DUNNINGLOCKREASON sy-vline 
WA_CRMS4IUVICAP_STR-INVOICINGLOCKREASON sy-vline 
WA_CRMS4IUVICAP_STR-CONVERGENTINVOICINGLOCKREASON sy-vline 
WA_CRMS4IUVICAP_STR-POSTINGLOCKREASON sy-vline 
WA_CRMS4IUVICAP_STR-CALCULATEINTERESTLOCKREASON sy-vline 
WA_CRMS4IUVICAP_STR-INCOMINGPAYMENTLOCKREASON sy-vline 
WA_CRMS4IUVICAP_STR-OUTGOINGPAYMENTLOCKREASON sy-vline 
WA_CRMS4IUVICAP_STR-CORRDUNNINGLOCKREASON sy-vline      INTO ld_text SEPARATED BY SPACE.

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