ABAP Select data from SAP table CFIN_ACCIT_APP 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 CFIN_ACCIT_APP 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 CFIN_ACCIT_APP. 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 CFIN_ACCIT_APP 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_CFIN_ACCIT_APP TYPE STANDARD TABLE OF CFIN_ACCIT_APP,
      WA_CFIN_ACCIT_APP TYPE CFIN_ACCIT_APP,
      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: <CFIN_ACCIT_APP> TYPE CFIN_ACCIT_APP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CFIN_ACCIT_APP
*  INTO TABLE @DATA(IT_CFIN_ACCIT_APP2).
*--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_CFIN_ACCIT_APP INDEX 1 INTO DATA(WA_CFIN_ACCIT_APP2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CFIN_ACCIT_APP>-CLIENT = 1.
<CFIN_ACCIT_APP>-ACCHD_GUID = 1.
<CFIN_ACCIT_APP>-ITEMNO = 1.
<CFIN_ACCIT_APP>-MANDT = 1.
<CFIN_ACCIT_APP>-AWTYP = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CFIN_ACCIT_APP-AWREF, sy-vline,
  WA_CFIN_ACCIT_APP-AWORG, sy-vline,
  WA_CFIN_ACCIT_APP-POSNR, sy-vline,
  WA_CFIN_ACCIT_APP-DUMMY_INCL_EEW_COBL, sy-vline,
  WA_CFIN_ACCIT_APP-DOC_CURR_KEY, sy-vline,
  WA_CFIN_ACCIT_APP-CC_CURR_KEY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CFIN_ACCIT_APP 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_CFIN_ACCIT_APP 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_CFIN_ACCIT_APP INTO WA_CFIN_ACCIT_APP.


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

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

*Conversion exit AU132, internal->external for field BSBTR_EX
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_CFIN_ACCIT_APP-BSBTR_EX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CFIN_ACCIT_APP-BSBTR_EX.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit GJAHR, internal->external for field TP_ENDPER_EX
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_CFIN_ACCIT_APP-TP_ENDPER_EX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CFIN_ACCIT_APP-TP_ENDPER_EX.
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_CFIN_ACCIT_APP_STR, 
CLIENT TYPE STRING,
ACCHD_GUID TYPE STRING,
ITEMNO TYPE STRING,
MANDT TYPE STRING,
AWTYP TYPE STRING,
AWREF TYPE STRING,
AWORG TYPE STRING,
POSNR TYPE STRING,
DUMMY_INCL_EEW_COBL TYPE STRING,
DOC_CURR_KEY TYPE STRING,
CC_CURR_KEY TYPE STRING,
CASH_CURR_KEY TYPE STRING,
CCA_CURR_KEY TYPE STRING,
AUTH_CC_CURR_KEY TYPE STRING,
MANDT_EX TYPE STRING,
AWTYP_EX TYPE STRING,
AWREF_EX TYPE STRING,
AWORG_EX TYPE STRING,
POSNR_EX TYPE STRING,
ELIKZ_EX TYPE STRING,
ELIKZ_OLD_EX TYPE STRING,
REB_SUBNO_EX TYPE STRING,
REL_VER_EX TYPE STRING,
POSNR_ORG_EX TYPE STRING,
REFKZ_EX TYPE STRING,
BSBTR_EX TYPE STRING,
BSWRS_EX TYPE STRING,
IGNR_IVREF_EX TYPE STRING,
CC_BUKRS_EX TYPE STRING,
CC_ACCOUNT_EX TYPE STRING,
RE_BUKRS_EX TYPE STRING,
RE_ACCOUNT_EX TYPE STRING,
CASH_BUKRS_EX TYPE STRING,
CASH_ACCOUNT_EX TYPE STRING,
KNBUKRS_EX TYPE STRING,
KNGJAHR_EX TYPE STRING,
KNBELNR_EX TYPE STRING,
KNBUZEI_EX TYPE STRING,
VOBUKRS_EX TYPE STRING,
VOGJAHR_EX TYPE STRING,
VOBELNR_EX TYPE STRING,
ORECID_EX TYPE STRING,
BILLM_EX TYPE STRING,
POM_EX TYPE STRING,
CBRUNID_EX TYPE STRING,
CBRACCT_EX TYPE STRING,
CBOBJNR_EX TYPE STRING,
PVNAME_EX TYPE STRING,
PEGRUP_EX TYPE STRING,
RAGNCY_LCTN_CODE_EX TYPE STRING,
PMT_OFFICE_EX TYPE STRING,
SGL_ACCOUNT_EX TYPE STRING,
FLG_COVERED_EX TYPE STRING,
FLG_CUSTODIAL_EX TYPE STRING,
FLG_ENTITY_EX TYPE STRING,
FLG_EXCHANGE_EX TYPE STRING,
FLG_FEDERAL_EX TYPE STRING,
BUREAU_EX TYPE STRING,
BUSINESS_LINE_EX TYPE STRING,
FGDPRTMNT_EX TYPE STRING,
FGDPRTMNT_PART_EX TYPE STRING,
FUND_ACC_SYMBL_EX TYPE STRING,
FLG_APPORT_EX TYPE STRING,
FLG_AVAIL_EX TYPE STRING,
FLG_BORROW_EX TYPE STRING,
FLG_DEFINITE_EX TYPE STRING,
FLG_PARTNER_EX TYPE STRING,
FLG_BEA_EX TYPE STRING,
LEGIS_EX TYPE STRING,
FLG_REIMBUR_EX TYPE STRING,
COHORT_EX TYPE STRING,
PUBLAW_EX TYPE STRING,
FLG_AUTHOR_EX TYPE STRING,
TRANSFER_AGCY_9_EX TYPE STRING,
TRANSFER_ACCT_9_EX TYPE STRING,
YEAR_BDGT_AUTH_9_EX TYPE STRING,
FLG_ADVANCE_9_EX TYPE STRING,
DEFENSE_INDIC_9_EX TYPE STRING,
PROG_REPT_CAT_EX TYPE STRING,
APPOR_CATB_DTL_9_EX TYPE STRING,
BDGT_IMPACT_EX TYPE STRING,
FLG_PYA_EX TYPE STRING,
PROGRAM_IND_EX TYPE STRING,
TP_AGENCID_EX TYPE STRING,
TP_MAIN_ACCT_EX TYPE STRING,
BETC_EX TYPE STRING,
SUBLEVL_EX TYPE STRING,
AGENCID_EX TYPE STRING,
ALTRAID_EX TYPE STRING,
BEGPER_EX TYPE STRING,
ENDPER_EX TYPE STRING,
AVTYPE_EX TYPE STRING,
SUB_ACCT_EX TYPE STRING,
BDGT_FUNC_CLSS_EX TYPE STRING,
FLG_NO_FACTS_DERIVE_EX TYPE STRING,
TP_SUBLEVL_EX TYPE STRING,
TP_ALTRAID_EX TYPE STRING,
TP_BEGPER_EX TYPE STRING,
TP_ENDPER_EX TYPE STRING,
TP_AVTYPE_EX TYPE STRING,
TP_SUB_ACCT_EX TYPE STRING,
TP_BETC_EX TYPE STRING,
TREASURY_OFFS_EX TYPE STRING,
GARNISHMENT_EX TYPE STRING,
FUND_TYPE_EX TYPE STRING,
RFINUSE_EX TYPE STRING,
KEY_DATE_MIG_EX TYPE STRING,
ACDOC_EEW_DUMMY TYPE STRING,
PRODPER TYPE STRING,
JVACTIVITY TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CFIN_ACCIT_APP_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_CFIN_ACCIT_APP_STR-CLIENT sy-vline 
WA_CFIN_ACCIT_APP_STR-ACCHD_GUID sy-vline 
WA_CFIN_ACCIT_APP_STR-ITEMNO sy-vline 
WA_CFIN_ACCIT_APP_STR-MANDT sy-vline 
WA_CFIN_ACCIT_APP_STR-AWTYP sy-vline 
WA_CFIN_ACCIT_APP_STR-AWREF sy-vline 
WA_CFIN_ACCIT_APP_STR-AWORG sy-vline 
WA_CFIN_ACCIT_APP_STR-POSNR sy-vline 
WA_CFIN_ACCIT_APP_STR-DUMMY_INCL_EEW_COBL sy-vline 
WA_CFIN_ACCIT_APP_STR-DOC_CURR_KEY sy-vline 
WA_CFIN_ACCIT_APP_STR-CC_CURR_KEY sy-vline 
WA_CFIN_ACCIT_APP_STR-CASH_CURR_KEY sy-vline 
WA_CFIN_ACCIT_APP_STR-CCA_CURR_KEY sy-vline 
WA_CFIN_ACCIT_APP_STR-AUTH_CC_CURR_KEY sy-vline 
WA_CFIN_ACCIT_APP_STR-MANDT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-AWTYP_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-AWREF_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-AWORG_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-POSNR_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-ELIKZ_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-ELIKZ_OLD_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-REB_SUBNO_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-REL_VER_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-POSNR_ORG_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-REFKZ_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-BSBTR_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-BSWRS_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-IGNR_IVREF_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-CC_BUKRS_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-CC_ACCOUNT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-RE_BUKRS_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-RE_ACCOUNT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-CASH_BUKRS_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-CASH_ACCOUNT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-KNBUKRS_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-KNGJAHR_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-KNBELNR_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-KNBUZEI_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-VOBUKRS_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-VOGJAHR_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-VOBELNR_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-ORECID_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-BILLM_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-POM_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-CBRUNID_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-CBRACCT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-CBOBJNR_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-PVNAME_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-PEGRUP_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-RAGNCY_LCTN_CODE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-PMT_OFFICE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-SGL_ACCOUNT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_COVERED_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_CUSTODIAL_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_ENTITY_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_EXCHANGE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_FEDERAL_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-BUREAU_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-BUSINESS_LINE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FGDPRTMNT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FGDPRTMNT_PART_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FUND_ACC_SYMBL_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_APPORT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_AVAIL_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_BORROW_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_DEFINITE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_PARTNER_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_BEA_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-LEGIS_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_REIMBUR_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-COHORT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-PUBLAW_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_AUTHOR_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TRANSFER_AGCY_9_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TRANSFER_ACCT_9_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-YEAR_BDGT_AUTH_9_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_ADVANCE_9_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-DEFENSE_INDIC_9_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-PROG_REPT_CAT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-APPOR_CATB_DTL_9_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-BDGT_IMPACT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_PYA_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-PROGRAM_IND_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TP_AGENCID_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TP_MAIN_ACCT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-BETC_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-SUBLEVL_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-AGENCID_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-ALTRAID_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-BEGPER_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-ENDPER_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-AVTYPE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-SUB_ACCT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-BDGT_FUNC_CLSS_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FLG_NO_FACTS_DERIVE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TP_SUBLEVL_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TP_ALTRAID_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TP_BEGPER_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TP_ENDPER_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TP_AVTYPE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TP_SUB_ACCT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TP_BETC_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-TREASURY_OFFS_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-GARNISHMENT_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-FUND_TYPE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-RFINUSE_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-KEY_DATE_MIG_EX sy-vline 
WA_CFIN_ACCIT_APP_STR-ACDOC_EEW_DUMMY sy-vline 
WA_CFIN_ACCIT_APP_STR-PRODPER sy-vline 
WA_CFIN_ACCIT_APP_STR-JVACTIVITY sy-vline      INTO ld_text SEPARATED BY SPACE.

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