ABAP Select data from SAP table TBCO_FU 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 TBCO_FU 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 TBCO_FU. 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 TBCO_FU 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_TBCO_FU TYPE STANDARD TABLE OF TBCO_FU,
      WA_TBCO_FU TYPE TBCO_FU,
      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: <TBCO_FU> TYPE TBCO_FU.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TBCO_FU
*  INTO TABLE @DATA(IT_TBCO_FU2).
*--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_TBCO_FU INDEX 1 INTO DATA(WA_TBCO_FU2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TBCO_FU>-MANDT = 1.
<TBCO_FU>-BUKRS = 1.
<TBCO_FU>-BUTXT = 1.
<TBCO_FU>-BU_SWIFT = 1.
<TBCO_FU>-RANTYP = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TBCO_FU-SGSART, sy-vline,
  WA_TBCO_FU-XSGSART, sy-vline,
  WA_TBCO_FU-XSGSART_K, sy-vline,
  WA_TBCO_FU-XSGSART_E, sy-vline,
  WA_TBCO_FU-SFHAART, sy-vline,
  WA_TBCO_FU-XSFHAART, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TBCO_FU 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_TBCO_FU 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_TBCO_FU INTO WA_TBCO_FU.


*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 ISOLA, internal->external for field LANGU_BEFORE
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_TBCO_FU-LANGU_BEFORE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FU-LANGU_BEFORE.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit SXIDN, internal->external for field KO_ADSMTP
CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT'
  EXPORTING
    input =                      WA_TBCO_FU-KO_ADSMTP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FU-KO_ADSMTP.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit EXCRT, internal->external for field KBWKURS
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_TBCO_FU-KBWKURS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FU-KBWKURS.
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_TBCO_FU_STR, 
MANDT TYPE STRING,
BUKRS TYPE STRING,
BUTXT TYPE STRING,
BU_SWIFT TYPE STRING,
RANTYP TYPE STRING,
SGSART TYPE STRING,
XSGSART TYPE STRING,
XSGSART_K TYPE STRING,
XSGSART_E TYPE STRING,
SFHAART TYPE STRING,
XSFHAART TYPE STRING,
XSFHAART_E TYPE STRING,
SFGZUSTT TYPE STRING,
XSFGZUSTT TYPE STRING,
XSFGZUSTTE TYPE STRING,
SFUNKTV TYPE STRING,
XSFUNKTV TYPE STRING,
SFUNKTL TYPE STRING,
XSFUNKTL TYPE STRING,
XSFUNKTL_E TYPE STRING,
LANGU_BEFORE TYPE STRING,
LANGU_AFTER TYPE STRING,
OBJNR TYPE STRING,
RFHA TYPE STRING,
RFHAZU TYPE STRING,
RFHAZUL TYPE STRING,
SFIXRFHAZU TYPE STRING,
SFIRST TYPE STRING,
RLFDNR TYPE STRING,
SREPEAT TYPE STRING,
DATUM TYPE STRING,
CRUSER TYPE STRING,
DCRDAT TYPE STRING,
TCRTIM TYPE STRING,
UPUSER TYPE STRING,
DUPDAT TYPE STRING,
TUPTIM TYPE STRING,
DVTRAB TYPE STRING,
RMAID TYPE STRING,
GSPPART TYPE STRING,
DBLFZ TYPE STRING,
DELFZ TYPE STRING,
KONTRH TYPE STRING,
XKONTRH TYPE STRING,
ADDRNUMBER TYPE STRING,
ADDR_TYPE TYPE STRING,
PERSNUMBER TYPE STRING,
FROMCOUNTRY TYPE STRING,
ROLETYP TYPE STRING,
XROLETYP TYPE STRING,
RGARANT TYPE STRING,
XRGARANT TYPE STRING,
KO_FAX TYPE STRING,
KO_ADR_COUNTRY TYPE STRING,
KO_SWIFT TYPE STRING,
KO_ADSMTP TYPE STRING,
RPZAHL TYPE STRING,
ZR_SWIFT TYPE STRING,
RPBANK TYPE STRING,
PB_SWIFT TYPE STRING,
PB_IBAN TYPE STRING,
RAHABKI TYPE STRING,
HB_SWIFT TYPE STRING,
HB_IBAN TYPE STRING,
RAHKTID TYPE STRING,
RAHK_NO TYPE STRING,
RPCODE TYPE STRING,
SZART TYPE STRING,
UZAWE TYPE STRING,
NORDEXT TYPE STRING,
RDEALER TYPE STRING,
SSTOGRD TYPE STRING,
XSSTOGRD TYPE STRING,
SRNDNG TYPE STRING,
CORTYP TYPE STRING,
FORMULAR TYPE STRING,
SWIFT_DAT TYPE STRING,
SANLF TYPE STRING,
SFGTYP TYPE STRING,
SAKTIV TYPE STRING,
RPORTB TYPE STRING,
ZUONR TYPE STRING,
RANL TYPE STRING,
RLDEPO TYPE STRING,
PEFFZINS TYPE STRING,
SEFFMETH TYPE STRING,
XEFFMETH TYPE STRING,
ZUOND TYPE STRING,
REFER TYPE STRING,
MERKM TYPE STRING,
RCOMVALCL TYPE STRING,
XRCOMVALCL TYPE STRING,
FACILITYNR TYPE STRING,
FACILITYBUKRS TYPE STRING,
VRFHA TYPE STRING,
RRFHA TYPE STRING,
RBUKRS TYPE STRING,
TRANS_KEY TYPE STRING,
SFORMCT TYPE STRING,
BANKA_SB TYPE STRING,
BRNCH_SB TYPE STRING,
STRAS_SB TYPE STRING,
ORT01_SB TYPE STRING,
SWIFT_SB TYPE STRING,
BNKLZ_SB TYPE STRING,
BANKN_SK TYPE STRING,
BNKN2_SK TYPE STRING,
IBAN_SK TYPE STRING,
SDISP_INTST TYPE STRING,
SDISP_BNOM TYPE STRING,
SDISP_REF TYPE STRING,
SDISP_ZS TYPE STRING,
SDISP_COND TYPE STRING,
SDISP_COND_SE TYPE STRING,
SDISP_COND_REP TYPE STRING,
SDISP_RPAY TYPE STRING,
SDISP_BNOM_IN TYPE STRING,
SDISP_DIVID_FW TYPE STRING,
SFIXRFHAZU_CS TYPE STRING,
SFIXRFHAZU_TRS TYPE STRING,
SDISP_BNOM_TRS TYPE STRING,
SDISP_BNOM_TRS_IN TYPE STRING,
SDISP_DIVID_TRS TYPE STRING,
LEGAL_BASIS TYPE STRING,
TRADE_ID TYPE STRING,
MANDT_CD TYPE STRING,
RANL_CD TYPE STRING,
SANLF_CD TYPE STRING,
SSTATI_CD TYPE STRING,
RANLALT1_CD TYPE STRING,
RANLALT2_CD TYPE STRING,
GSART_CD TYPE STRING,
SBRSCH_CD TYPE STRING,
SWERTTYP_CD TYPE STRING,
SBOERNOT_CD TYPE STRING,
WLOMB_CD TYPE STRING,
JDECK_CD TYPE STRING,
WPFAN_CD TYPE STRING,
SSTBE_CD TYPE STRING,
LOEVM_CD TYPE STRING,
JABMI_CD TYPE STRING,
XALKZ_CD TYPE STRING,
XALLB_CD TYPE STRING,
REPKE_CD TYPE STRING,
BEMPREIS_CD TYPE STRING,
REWHR_CD TYPE STRING,
PEMKURS_CD TYPE STRING,
SNOTI_CD TYPE STRING,
PKUAB_CD TYPE STRING,
BKUAB_CD TYPE STRING,
DANDPFL_CD TYPE STRING,
DANDRE_CD TYPE STRING,
SOBJEKT_CD TYPE STRING,
RERF_CD TYPE STRING,
DERF_CD TYPE STRING,
TERF_CD TYPE STRING,
REHER_CD TYPE STRING,
RBEAR_CD TYPE STRING,
DBEAR_CD TYPE STRING,
TBEAR_CD TYPE STRING,
RBHER_CD TYPE STRING,
SROLEXT_CD TYPE STRING,
VVSLOEKZ_CD TYPE STRING,
JMUENDEL_CD TYPE STRING,
SMOVERW_CD TYPE STRING,
SIHERK_CD TYPE STRING,
KBEMPREIS_CD TYPE STRING,
SDEPOSTAT_CD TYPE STRING,
SFUNDI_CD TYPE STRING,
SWPHGMPF_CD TYPE STRING,
RISIN_CD TYPE STRING,
INSTITUTE_CD TYPE STRING,
RATING_CD TYPE STRING,
PRICE_INDEX_CD TYPE STRING,
PRICE_IDX_BDATE_CD TYPE STRING,
COICODE_CD TYPE STRING,
COILAND_CD TYPE STRING,
SFIMAMETHOD_CD TYPE STRING,
MANDT_PI TYPE STRING,
BUKRS_PI TYPE STRING,
RANL_PI TYPE STRING,
RLDEPO_PI TYPE STRING,
SSTATI_PI TYPE STRING,
XDKBZ_PI TYPE STRING,
RREFKONT_PI TYPE STRING,
SVERWA_PI TYPE STRING,
DANDPFL_PI TYPE STRING,
DANDRE_PI TYPE STRING,
SFIBG_PI TYPE STRING,
SGLZB_PI TYPE STRING,
SBILK_PI TYPE STRING,
JSPRI_PI TYPE STRING,
JBTEI_PI TYPE STRING,
RFGEB_PI TYPE STRING,
DFREI_PI TYPE STRING,
TFREI_PI TYPE STRING,
RERF_PI TYPE STRING,
DERF_PI TYPE STRING,
TERF_PI TYPE STRING,
REHER_PI TYPE STRING,
RBEAR_PI TYPE STRING,
DBEAR_PI TYPE STRING,
TBHER_PI TYPE STRING,
RBHER_PI TYPE STRING,
SBESANT_PI TYPE STRING,
JBETEIL_PI TYPE STRING,
VVSLOEKZ_PI TYPE STRING,
SKWG14NEU_PI TYPE STRING,
SMOVERW_PI TYPE STRING,
TBEAR_PI TYPE STRING,
DERIV_CAT_PI TYPE STRING,
MANDT_PA TYPE STRING,
COMPANY_CODE_PA TYPE STRING,
POS_ACCOUNT_PA TYPE STRING,
POS_ACC_TEXT_PA TYPE STRING,
SETTLEMENT_ACC_PA TYPE STRING,
POS_ACC_NUMBER_PA TYPE STRING,
POS_ACC_BANK_PA TYPE STRING,
HOUSE_BANK_PA TYPE STRING,
HOUSE_BANK_ACC_PA TYPE STRING,
RGSBER_PA TYPE STRING,
RPORTB_PA TYPE STRING,
RERF_PA TYPE STRING,
DERF_PA TYPE STRING,
TERF_PA TYPE STRING,
REHER_PA TYPE STRING,
RBEAR_PA TYPE STRING,
DBEAR_PA TYPE STRING,
TBEAR_PA TYPE STRING,
RBHER_PA TYPE STRING,
BLABLA_PA TYPE STRING,
ATTRIBUTE_SA01_PA TYPE STRING,
ATTRIBUTE_SA02_PA TYPE STRING,
ATTRIBUTE_SC03_PA TYPE STRING,
ATTRIBUTE_SC04_PA TYPE STRING,
ATTRIBUTE_MA01_PA TYPE STRING,
ATTRIBUTE_MA02_PA TYPE STRING,
ATTRIBUTE_MC03_PA TYPE STRING,
ATTRIBUTE_MC04_PA TYPE STRING,
ATTRIBUTE_LA01_PA TYPE STRING,
ATTRIBUTE_LA02_PA TYPE STRING,
ATTRIBUTE_LC03_PA TYPE STRING,
ATTRIBUTE_LC04_PA TYPE STRING,
POSACC TYPE STRING,
RHANDPL TYPE STRING,
XREPKE TYPE STRING,
REPKE_ADDRNO TYPE STRING,
XRANLALT1_L TYPE STRING,
XRANLALT1_S TYPE STRING,
XRANLALT2_L TYPE STRING,
XRANLALT2_S TYPE STRING,
DVALUT TYPE STRING,
DZTERM TYPE STRING,
DBESTAND TYPE STRING,
SFHAZBA TYPE STRING,
XBEWART TYPE STRING,
ASTUECK TYPE STRING,
BNWHR TYPE STRING,
WPRICE TYPE STRING,
BUPRC TYPE STRING,
BPPRC TYPE STRING,
SSIGN TYPE STRING,
WZBETR TYPE STRING,
BZBETR TYPE STRING,
BHWBETR TYPE STRING,
WHWBETR TYPE STRING,
KHWKURS TYPE STRING,
WBBETR TYPE STRING,
BBBETR TYPE STRING,
WEBETR TYPE STRING,
BEBETR TYPE STRING,
BTOTAL TYPE STRING,
BTOTAL_S TYPE STRING,
WTOTAL TYPE STRING,
SRUNIT TYPE STRING,
KZWKURS TYPE STRING,
KBWKURS TYPE STRING,
SDISP_FU TYPE STRING,
AVG_PERIOD_START TYPE STRING,
AVG_PERIOD_END TYPE STRING,
TIMING TYPE STRING,
TIMING_TXT TYPE STRING,
PRICETYPE TYPE STRING,
PRICE_TYPE_TXT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TBCO_FU_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_TBCO_FU_STR-MANDT sy-vline 
WA_TBCO_FU_STR-BUKRS sy-vline 
WA_TBCO_FU_STR-BUTXT sy-vline 
WA_TBCO_FU_STR-BU_SWIFT sy-vline 
WA_TBCO_FU_STR-RANTYP sy-vline 
WA_TBCO_FU_STR-SGSART sy-vline 
WA_TBCO_FU_STR-XSGSART sy-vline 
WA_TBCO_FU_STR-XSGSART_K sy-vline 
WA_TBCO_FU_STR-XSGSART_E sy-vline 
WA_TBCO_FU_STR-SFHAART sy-vline 
WA_TBCO_FU_STR-XSFHAART sy-vline 
WA_TBCO_FU_STR-XSFHAART_E sy-vline 
WA_TBCO_FU_STR-SFGZUSTT sy-vline 
WA_TBCO_FU_STR-XSFGZUSTT sy-vline 
WA_TBCO_FU_STR-XSFGZUSTTE sy-vline 
WA_TBCO_FU_STR-SFUNKTV sy-vline 
WA_TBCO_FU_STR-XSFUNKTV sy-vline 
WA_TBCO_FU_STR-SFUNKTL sy-vline 
WA_TBCO_FU_STR-XSFUNKTL sy-vline 
WA_TBCO_FU_STR-XSFUNKTL_E sy-vline 
WA_TBCO_FU_STR-LANGU_BEFORE sy-vline 
WA_TBCO_FU_STR-LANGU_AFTER sy-vline 
WA_TBCO_FU_STR-OBJNR sy-vline 
WA_TBCO_FU_STR-RFHA sy-vline 
WA_TBCO_FU_STR-RFHAZU sy-vline 
WA_TBCO_FU_STR-RFHAZUL sy-vline 
WA_TBCO_FU_STR-SFIXRFHAZU sy-vline 
WA_TBCO_FU_STR-SFIRST sy-vline 
WA_TBCO_FU_STR-RLFDNR sy-vline 
WA_TBCO_FU_STR-SREPEAT sy-vline 
WA_TBCO_FU_STR-DATUM sy-vline 
WA_TBCO_FU_STR-CRUSER sy-vline 
WA_TBCO_FU_STR-DCRDAT sy-vline 
WA_TBCO_FU_STR-TCRTIM sy-vline 
WA_TBCO_FU_STR-UPUSER sy-vline 
WA_TBCO_FU_STR-DUPDAT sy-vline 
WA_TBCO_FU_STR-TUPTIM sy-vline 
WA_TBCO_FU_STR-DVTRAB sy-vline 
WA_TBCO_FU_STR-RMAID sy-vline 
WA_TBCO_FU_STR-GSPPART sy-vline 
WA_TBCO_FU_STR-DBLFZ sy-vline 
WA_TBCO_FU_STR-DELFZ sy-vline 
WA_TBCO_FU_STR-KONTRH sy-vline 
WA_TBCO_FU_STR-XKONTRH sy-vline 
WA_TBCO_FU_STR-ADDRNUMBER sy-vline 
WA_TBCO_FU_STR-ADDR_TYPE sy-vline 
WA_TBCO_FU_STR-PERSNUMBER sy-vline 
WA_TBCO_FU_STR-FROMCOUNTRY sy-vline 
WA_TBCO_FU_STR-ROLETYP sy-vline 
WA_TBCO_FU_STR-XROLETYP sy-vline 
WA_TBCO_FU_STR-RGARANT sy-vline 
WA_TBCO_FU_STR-XRGARANT sy-vline 
WA_TBCO_FU_STR-KO_FAX sy-vline 
WA_TBCO_FU_STR-KO_ADR_COUNTRY sy-vline 
WA_TBCO_FU_STR-KO_SWIFT sy-vline 
WA_TBCO_FU_STR-KO_ADSMTP sy-vline 
WA_TBCO_FU_STR-RPZAHL sy-vline 
WA_TBCO_FU_STR-ZR_SWIFT sy-vline 
WA_TBCO_FU_STR-RPBANK sy-vline 
WA_TBCO_FU_STR-PB_SWIFT sy-vline 
WA_TBCO_FU_STR-PB_IBAN sy-vline 
WA_TBCO_FU_STR-RAHABKI sy-vline 
WA_TBCO_FU_STR-HB_SWIFT sy-vline 
WA_TBCO_FU_STR-HB_IBAN sy-vline 
WA_TBCO_FU_STR-RAHKTID sy-vline 
WA_TBCO_FU_STR-RAHK_NO sy-vline 
WA_TBCO_FU_STR-RPCODE sy-vline 
WA_TBCO_FU_STR-SZART sy-vline 
WA_TBCO_FU_STR-UZAWE sy-vline 
WA_TBCO_FU_STR-NORDEXT sy-vline 
WA_TBCO_FU_STR-RDEALER sy-vline 
WA_TBCO_FU_STR-SSTOGRD sy-vline 
WA_TBCO_FU_STR-XSSTOGRD sy-vline 
WA_TBCO_FU_STR-SRNDNG sy-vline 
WA_TBCO_FU_STR-CORTYP sy-vline 
WA_TBCO_FU_STR-FORMULAR sy-vline 
WA_TBCO_FU_STR-SWIFT_DAT sy-vline 
WA_TBCO_FU_STR-SANLF sy-vline 
WA_TBCO_FU_STR-SFGTYP sy-vline 
WA_TBCO_FU_STR-SAKTIV sy-vline 
WA_TBCO_FU_STR-RPORTB sy-vline 
WA_TBCO_FU_STR-ZUONR sy-vline 
WA_TBCO_FU_STR-RANL sy-vline 
WA_TBCO_FU_STR-RLDEPO sy-vline 
WA_TBCO_FU_STR-PEFFZINS sy-vline 
WA_TBCO_FU_STR-SEFFMETH sy-vline 
WA_TBCO_FU_STR-XEFFMETH sy-vline 
WA_TBCO_FU_STR-ZUOND sy-vline 
WA_TBCO_FU_STR-REFER sy-vline 
WA_TBCO_FU_STR-MERKM sy-vline 
WA_TBCO_FU_STR-RCOMVALCL sy-vline 
WA_TBCO_FU_STR-XRCOMVALCL sy-vline 
WA_TBCO_FU_STR-FACILITYNR sy-vline 
WA_TBCO_FU_STR-FACILITYBUKRS sy-vline 
WA_TBCO_FU_STR-VRFHA sy-vline 
WA_TBCO_FU_STR-RRFHA sy-vline 
WA_TBCO_FU_STR-RBUKRS sy-vline 
WA_TBCO_FU_STR-TRANS_KEY sy-vline 
WA_TBCO_FU_STR-SFORMCT sy-vline 
WA_TBCO_FU_STR-BANKA_SB sy-vline 
WA_TBCO_FU_STR-BRNCH_SB sy-vline 
WA_TBCO_FU_STR-STRAS_SB sy-vline 
WA_TBCO_FU_STR-ORT01_SB sy-vline 
WA_TBCO_FU_STR-SWIFT_SB sy-vline 
WA_TBCO_FU_STR-BNKLZ_SB sy-vline 
WA_TBCO_FU_STR-BANKN_SK sy-vline 
WA_TBCO_FU_STR-BNKN2_SK sy-vline 
WA_TBCO_FU_STR-IBAN_SK sy-vline 
WA_TBCO_FU_STR-SDISP_INTST sy-vline 
WA_TBCO_FU_STR-SDISP_BNOM sy-vline 
WA_TBCO_FU_STR-SDISP_REF sy-vline 
WA_TBCO_FU_STR-SDISP_ZS sy-vline 
WA_TBCO_FU_STR-SDISP_COND sy-vline 
WA_TBCO_FU_STR-SDISP_COND_SE sy-vline 
WA_TBCO_FU_STR-SDISP_COND_REP sy-vline 
WA_TBCO_FU_STR-SDISP_RPAY sy-vline 
WA_TBCO_FU_STR-SDISP_BNOM_IN sy-vline 
WA_TBCO_FU_STR-SDISP_DIVID_FW sy-vline 
WA_TBCO_FU_STR-SFIXRFHAZU_CS sy-vline 
WA_TBCO_FU_STR-SFIXRFHAZU_TRS sy-vline 
WA_TBCO_FU_STR-SDISP_BNOM_TRS sy-vline 
WA_TBCO_FU_STR-SDISP_BNOM_TRS_IN sy-vline 
WA_TBCO_FU_STR-SDISP_DIVID_TRS sy-vline 
WA_TBCO_FU_STR-LEGAL_BASIS sy-vline 
WA_TBCO_FU_STR-TRADE_ID sy-vline 
WA_TBCO_FU_STR-MANDT_CD sy-vline 
WA_TBCO_FU_STR-RANL_CD sy-vline 
WA_TBCO_FU_STR-SANLF_CD sy-vline 
WA_TBCO_FU_STR-SSTATI_CD sy-vline 
WA_TBCO_FU_STR-RANLALT1_CD sy-vline 
WA_TBCO_FU_STR-RANLALT2_CD sy-vline 
WA_TBCO_FU_STR-GSART_CD sy-vline 
WA_TBCO_FU_STR-SBRSCH_CD sy-vline 
WA_TBCO_FU_STR-SWERTTYP_CD sy-vline 
WA_TBCO_FU_STR-SBOERNOT_CD sy-vline 
WA_TBCO_FU_STR-WLOMB_CD sy-vline 
WA_TBCO_FU_STR-JDECK_CD sy-vline 
WA_TBCO_FU_STR-WPFAN_CD sy-vline 
WA_TBCO_FU_STR-SSTBE_CD sy-vline 
WA_TBCO_FU_STR-LOEVM_CD sy-vline 
WA_TBCO_FU_STR-JABMI_CD sy-vline 
WA_TBCO_FU_STR-XALKZ_CD sy-vline 
WA_TBCO_FU_STR-XALLB_CD sy-vline 
WA_TBCO_FU_STR-REPKE_CD sy-vline 
WA_TBCO_FU_STR-BEMPREIS_CD sy-vline 
WA_TBCO_FU_STR-REWHR_CD sy-vline 
WA_TBCO_FU_STR-PEMKURS_CD sy-vline 
WA_TBCO_FU_STR-SNOTI_CD sy-vline 
WA_TBCO_FU_STR-PKUAB_CD sy-vline 
WA_TBCO_FU_STR-BKUAB_CD sy-vline 
WA_TBCO_FU_STR-DANDPFL_CD sy-vline 
WA_TBCO_FU_STR-DANDRE_CD sy-vline 
WA_TBCO_FU_STR-SOBJEKT_CD sy-vline 
WA_TBCO_FU_STR-RERF_CD sy-vline 
WA_TBCO_FU_STR-DERF_CD sy-vline 
WA_TBCO_FU_STR-TERF_CD sy-vline 
WA_TBCO_FU_STR-REHER_CD sy-vline 
WA_TBCO_FU_STR-RBEAR_CD sy-vline 
WA_TBCO_FU_STR-DBEAR_CD sy-vline 
WA_TBCO_FU_STR-TBEAR_CD sy-vline 
WA_TBCO_FU_STR-RBHER_CD sy-vline 
WA_TBCO_FU_STR-SROLEXT_CD sy-vline 
WA_TBCO_FU_STR-VVSLOEKZ_CD sy-vline 
WA_TBCO_FU_STR-JMUENDEL_CD sy-vline 
WA_TBCO_FU_STR-SMOVERW_CD sy-vline 
WA_TBCO_FU_STR-SIHERK_CD sy-vline 
WA_TBCO_FU_STR-KBEMPREIS_CD sy-vline 
WA_TBCO_FU_STR-SDEPOSTAT_CD sy-vline 
WA_TBCO_FU_STR-SFUNDI_CD sy-vline 
WA_TBCO_FU_STR-SWPHGMPF_CD sy-vline 
WA_TBCO_FU_STR-RISIN_CD sy-vline 
WA_TBCO_FU_STR-INSTITUTE_CD sy-vline 
WA_TBCO_FU_STR-RATING_CD sy-vline 
WA_TBCO_FU_STR-PRICE_INDEX_CD sy-vline 
WA_TBCO_FU_STR-PRICE_IDX_BDATE_CD sy-vline 
WA_TBCO_FU_STR-COICODE_CD sy-vline 
WA_TBCO_FU_STR-COILAND_CD sy-vline 
WA_TBCO_FU_STR-SFIMAMETHOD_CD sy-vline 
WA_TBCO_FU_STR-MANDT_PI sy-vline 
WA_TBCO_FU_STR-BUKRS_PI sy-vline 
WA_TBCO_FU_STR-RANL_PI sy-vline 
WA_TBCO_FU_STR-RLDEPO_PI sy-vline 
WA_TBCO_FU_STR-SSTATI_PI sy-vline 
WA_TBCO_FU_STR-XDKBZ_PI sy-vline 
WA_TBCO_FU_STR-RREFKONT_PI sy-vline 
WA_TBCO_FU_STR-SVERWA_PI sy-vline 
WA_TBCO_FU_STR-DANDPFL_PI sy-vline 
WA_TBCO_FU_STR-DANDRE_PI sy-vline 
WA_TBCO_FU_STR-SFIBG_PI sy-vline 
WA_TBCO_FU_STR-SGLZB_PI sy-vline 
WA_TBCO_FU_STR-SBILK_PI sy-vline 
WA_TBCO_FU_STR-JSPRI_PI sy-vline 
WA_TBCO_FU_STR-JBTEI_PI sy-vline 
WA_TBCO_FU_STR-RFGEB_PI sy-vline 
WA_TBCO_FU_STR-DFREI_PI sy-vline 
WA_TBCO_FU_STR-TFREI_PI sy-vline 
WA_TBCO_FU_STR-RERF_PI sy-vline 
WA_TBCO_FU_STR-DERF_PI sy-vline 
WA_TBCO_FU_STR-TERF_PI sy-vline 
WA_TBCO_FU_STR-REHER_PI sy-vline 
WA_TBCO_FU_STR-RBEAR_PI sy-vline 
WA_TBCO_FU_STR-DBEAR_PI sy-vline 
WA_TBCO_FU_STR-TBHER_PI sy-vline 
WA_TBCO_FU_STR-RBHER_PI sy-vline 
WA_TBCO_FU_STR-SBESANT_PI sy-vline 
WA_TBCO_FU_STR-JBETEIL_PI sy-vline 
WA_TBCO_FU_STR-VVSLOEKZ_PI sy-vline 
WA_TBCO_FU_STR-SKWG14NEU_PI sy-vline 
WA_TBCO_FU_STR-SMOVERW_PI sy-vline 
WA_TBCO_FU_STR-TBEAR_PI sy-vline 
WA_TBCO_FU_STR-DERIV_CAT_PI sy-vline 
WA_TBCO_FU_STR-MANDT_PA sy-vline 
WA_TBCO_FU_STR-COMPANY_CODE_PA sy-vline 
WA_TBCO_FU_STR-POS_ACCOUNT_PA sy-vline 
WA_TBCO_FU_STR-POS_ACC_TEXT_PA sy-vline 
WA_TBCO_FU_STR-SETTLEMENT_ACC_PA sy-vline 
WA_TBCO_FU_STR-POS_ACC_NUMBER_PA sy-vline 
WA_TBCO_FU_STR-POS_ACC_BANK_PA sy-vline 
WA_TBCO_FU_STR-HOUSE_BANK_PA sy-vline 
WA_TBCO_FU_STR-HOUSE_BANK_ACC_PA sy-vline 
WA_TBCO_FU_STR-RGSBER_PA sy-vline 
WA_TBCO_FU_STR-RPORTB_PA sy-vline 
WA_TBCO_FU_STR-RERF_PA sy-vline 
WA_TBCO_FU_STR-DERF_PA sy-vline 
WA_TBCO_FU_STR-TERF_PA sy-vline 
WA_TBCO_FU_STR-REHER_PA sy-vline 
WA_TBCO_FU_STR-RBEAR_PA sy-vline 
WA_TBCO_FU_STR-DBEAR_PA sy-vline 
WA_TBCO_FU_STR-TBEAR_PA sy-vline 
WA_TBCO_FU_STR-RBHER_PA sy-vline 
WA_TBCO_FU_STR-BLABLA_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_SA01_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_SA02_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_SC03_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_SC04_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_MA01_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_MA02_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_MC03_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_MC04_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_LA01_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_LA02_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_LC03_PA sy-vline 
WA_TBCO_FU_STR-ATTRIBUTE_LC04_PA sy-vline 
WA_TBCO_FU_STR-POSACC sy-vline 
WA_TBCO_FU_STR-RHANDPL sy-vline 
WA_TBCO_FU_STR-XREPKE sy-vline 
WA_TBCO_FU_STR-REPKE_ADDRNO sy-vline 
WA_TBCO_FU_STR-XRANLALT1_L sy-vline 
WA_TBCO_FU_STR-XRANLALT1_S sy-vline 
WA_TBCO_FU_STR-XRANLALT2_L sy-vline 
WA_TBCO_FU_STR-XRANLALT2_S sy-vline 
WA_TBCO_FU_STR-DVALUT sy-vline 
WA_TBCO_FU_STR-DZTERM sy-vline 
WA_TBCO_FU_STR-DBESTAND sy-vline 
WA_TBCO_FU_STR-SFHAZBA sy-vline 
WA_TBCO_FU_STR-XBEWART sy-vline 
WA_TBCO_FU_STR-ASTUECK sy-vline 
WA_TBCO_FU_STR-BNWHR sy-vline 
WA_TBCO_FU_STR-WPRICE sy-vline 
WA_TBCO_FU_STR-BUPRC sy-vline 
WA_TBCO_FU_STR-BPPRC sy-vline 
WA_TBCO_FU_STR-SSIGN sy-vline 
WA_TBCO_FU_STR-WZBETR sy-vline 
WA_TBCO_FU_STR-BZBETR sy-vline 
WA_TBCO_FU_STR-BHWBETR sy-vline 
WA_TBCO_FU_STR-WHWBETR sy-vline 
WA_TBCO_FU_STR-KHWKURS sy-vline 
WA_TBCO_FU_STR-WBBETR sy-vline 
WA_TBCO_FU_STR-BBBETR sy-vline 
WA_TBCO_FU_STR-WEBETR sy-vline 
WA_TBCO_FU_STR-BEBETR sy-vline 
WA_TBCO_FU_STR-BTOTAL sy-vline 
WA_TBCO_FU_STR-BTOTAL_S sy-vline 
WA_TBCO_FU_STR-WTOTAL sy-vline 
WA_TBCO_FU_STR-SRUNIT sy-vline 
WA_TBCO_FU_STR-KZWKURS sy-vline 
WA_TBCO_FU_STR-KBWKURS sy-vline 
WA_TBCO_FU_STR-SDISP_FU sy-vline 
WA_TBCO_FU_STR-AVG_PERIOD_START sy-vline 
WA_TBCO_FU_STR-AVG_PERIOD_END sy-vline 
WA_TBCO_FU_STR-TIMING sy-vline 
WA_TBCO_FU_STR-TIMING_TXT sy-vline 
WA_TBCO_FU_STR-PRICETYPE sy-vline 
WA_TBCO_FU_STR-PRICE_TYPE_TXT sy-vline      INTO ld_text SEPARATED BY SPACE.

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