ABAP Select data from SAP table TBCO_FW 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_FW 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_FW. 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_FW 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_FW TYPE STANDARD TABLE OF TBCO_FW,
      WA_TBCO_FW TYPE TBCO_FW,
      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_FW> TYPE TBCO_FW.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TBCO_FW
*  INTO TABLE @DATA(IT_TBCO_FW2).
*--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_FW INDEX 1 INTO DATA(WA_TBCO_FW2).


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

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

ENDLOOP.

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

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


*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_FW-LANGU_BEFORE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-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_FW-LANGU_AFTER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-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_FW-RFHA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-RFHA.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit ALPHA, internal->external for field RGARANT
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_TBCO_FW-RGARANT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-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_FW-KO_ADSMTP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-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_FW-RPZAHL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-RPZAHL.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit ALPHA, internal->external for field RRFHA
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_TBCO_FW-RRFHA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-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_FW-RANL_CD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-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_FW-REPKE_CD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-REPKE_CD.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field REPKE_ADDRNO
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_TBCO_FW-REPKE_ADDRNO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-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_FW-KHWKURS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-KHWKURS.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit EXCRT, internal->external for field KBWKURS
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_TBCO_FW-KBWKURS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TBCO_FW-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_FW_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_AD TYPE STRING,
BUKRS_AD TYPE STRING,
RLDEPO_AD TYPE STRING,
VERKONTO_AD TYPE STRING,
RDEPOTNR_AD TYPE STRING,
XLDEPO_AD TYPE STRING,
RERTRK_AD TYPE STRING,
RDPBANK_AD TYPE STRING,
RBGUE_AD TYPE STRING,
SSPERRV_AD TYPE STRING,
DSPERR_AD TYPE STRING,
RGSBER_AD TYPE STRING,
SSKZB_AD TYPE STRING,
JVERMST_AD TYPE STRING,
SUDEC_AD TYPE STRING,
DEDEC_AD TYPE STRING,
RFGEB_AD TYPE STRING,
DFREI_AD TYPE STRING,
TFREI_AD TYPE STRING,
RERF_AD TYPE STRING,
DERF_AD TYPE STRING,
TERF_AD TYPE STRING,
REHER_AD TYPE STRING,
RBEAR_AD TYPE STRING,
DBEAR_AD TYPE STRING,
TBEAR_AD TYPE STRING,
RBHER_AD TYPE STRING,
RPORTB_AD TYPE STRING,
SOBJEKT_AD TYPE STRING,
SROLEXTDEP_AD TYPE STRING,
SROLEXTBEG_AD TYPE STRING,
VVSLOEKZ_AD TYPE STRING,
SSPERR_AD TYPE STRING,
RAHABKI_AD TYPE STRING,
RAHKTID_AD TYPE STRING,
SEC_ACC_GRP_AD TYPE STRING,
STATUS_AD TYPE STRING,
STATUS_RBEAR_AD TYPE STRING,
STATUS_DBEAR_AD TYPE STRING,
STATUS_TBEAR_AD TYPE STRING,
SECACC_TYPE_AD TYPE STRING,
EXT_SEC_ACC_NO_AD TYPE STRING,
FLG_NO_TAX_MAP_AD TYPE STRING,
BUDAT_AD TYPE STRING,
COUNTRY_VAR_AD TYPE STRING,
SPARTE_AD TYPE STRING,
STOCKBAV_AD TYPE STRING,
ADDRNUMBER_AD TYPE STRING,
ANRED_AD TYPE STRING,
NAME1_AD TYPE STRING,
NAME2_AD TYPE STRING,
NAME3_AD TYPE STRING,
NAME4_AD TYPE STRING,
STRAS_AD TYPE STRING,
PFACH_AD TYPE STRING,
PSTL2_AD TYPE STRING,
PFORT_AD TYPE STRING,
LAND1_AD TYPE STRING,
PSTLZ_AD TYPE STRING,
ORT01_AD TYPE STRING,
ORT02_AD TYPE STRING,
REGIO_AD TYPE STRING,
SPRAS_AD TYPE STRING,
INLND_AD TYPE STRING,
ANZZL_AD TYPE STRING,
PRIOR_AD TYPE STRING,
WAREN_AD 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,
WTOTAL TYPE STRING,
SRUNIT TYPE STRING,
KZWKURS TYPE STRING,
KBWKURS TYPE STRING,
BPPRC_SPOT2 TYPE STRING,
BPPRC_SPOT1 TYPE STRING,
BPPRC_MARG TYPE STRING,
BUPRC_MARG TYPE STRING,
BUPRC_SPOT1 TYPE STRING,
BUPRC_SPOT2 TYPE STRING,
COC_RATE TYPE STRING,
SDISP_FW TYPE STRING,
BNWHR_TBANXT TYPE STRING,
BNWHR_RMNG TYPE STRING,
ASTUECK_TBANXT TYPE STRING,
ASTUECK_RMNG TYPE STRING,
INTREST_FWD TYPE STRING,
COST_FWD TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TBCO_FW_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_FW_STR-MANDT sy-vline 
WA_TBCO_FW_STR-BUKRS sy-vline 
WA_TBCO_FW_STR-BUTXT sy-vline 
WA_TBCO_FW_STR-BU_SWIFT sy-vline 
WA_TBCO_FW_STR-RANTYP sy-vline 
WA_TBCO_FW_STR-SGSART sy-vline 
WA_TBCO_FW_STR-XSGSART sy-vline 
WA_TBCO_FW_STR-XSGSART_K sy-vline 
WA_TBCO_FW_STR-XSGSART_E sy-vline 
WA_TBCO_FW_STR-SFHAART sy-vline 
WA_TBCO_FW_STR-XSFHAART sy-vline 
WA_TBCO_FW_STR-XSFHAART_E sy-vline 
WA_TBCO_FW_STR-SFGZUSTT sy-vline 
WA_TBCO_FW_STR-XSFGZUSTT sy-vline 
WA_TBCO_FW_STR-XSFGZUSTTE sy-vline 
WA_TBCO_FW_STR-SFUNKTV sy-vline 
WA_TBCO_FW_STR-XSFUNKTV sy-vline 
WA_TBCO_FW_STR-SFUNKTL sy-vline 
WA_TBCO_FW_STR-XSFUNKTL sy-vline 
WA_TBCO_FW_STR-XSFUNKTL_E sy-vline 
WA_TBCO_FW_STR-LANGU_BEFORE sy-vline 
WA_TBCO_FW_STR-LANGU_AFTER sy-vline 
WA_TBCO_FW_STR-OBJNR sy-vline 
WA_TBCO_FW_STR-RFHA sy-vline 
WA_TBCO_FW_STR-RFHAZU sy-vline 
WA_TBCO_FW_STR-RFHAZUL sy-vline 
WA_TBCO_FW_STR-SFIXRFHAZU sy-vline 
WA_TBCO_FW_STR-SFIRST sy-vline 
WA_TBCO_FW_STR-RLFDNR sy-vline 
WA_TBCO_FW_STR-SREPEAT sy-vline 
WA_TBCO_FW_STR-DATUM sy-vline 
WA_TBCO_FW_STR-CRUSER sy-vline 
WA_TBCO_FW_STR-DCRDAT sy-vline 
WA_TBCO_FW_STR-TCRTIM sy-vline 
WA_TBCO_FW_STR-UPUSER sy-vline 
WA_TBCO_FW_STR-DUPDAT sy-vline 
WA_TBCO_FW_STR-TUPTIM sy-vline 
WA_TBCO_FW_STR-DVTRAB sy-vline 
WA_TBCO_FW_STR-RMAID sy-vline 
WA_TBCO_FW_STR-GSPPART sy-vline 
WA_TBCO_FW_STR-DBLFZ sy-vline 
WA_TBCO_FW_STR-DELFZ sy-vline 
WA_TBCO_FW_STR-KONTRH sy-vline 
WA_TBCO_FW_STR-XKONTRH sy-vline 
WA_TBCO_FW_STR-ADDRNUMBER sy-vline 
WA_TBCO_FW_STR-ADDR_TYPE sy-vline 
WA_TBCO_FW_STR-PERSNUMBER sy-vline 
WA_TBCO_FW_STR-FROMCOUNTRY sy-vline 
WA_TBCO_FW_STR-ROLETYP sy-vline 
WA_TBCO_FW_STR-XROLETYP sy-vline 
WA_TBCO_FW_STR-RGARANT sy-vline 
WA_TBCO_FW_STR-XRGARANT sy-vline 
WA_TBCO_FW_STR-KO_FAX sy-vline 
WA_TBCO_FW_STR-KO_ADR_COUNTRY sy-vline 
WA_TBCO_FW_STR-KO_SWIFT sy-vline 
WA_TBCO_FW_STR-KO_ADSMTP sy-vline 
WA_TBCO_FW_STR-RPZAHL sy-vline 
WA_TBCO_FW_STR-ZR_SWIFT sy-vline 
WA_TBCO_FW_STR-RPBANK sy-vline 
WA_TBCO_FW_STR-PB_SWIFT sy-vline 
WA_TBCO_FW_STR-PB_IBAN sy-vline 
WA_TBCO_FW_STR-RAHABKI sy-vline 
WA_TBCO_FW_STR-HB_SWIFT sy-vline 
WA_TBCO_FW_STR-HB_IBAN sy-vline 
WA_TBCO_FW_STR-RAHKTID sy-vline 
WA_TBCO_FW_STR-RAHK_NO sy-vline 
WA_TBCO_FW_STR-RPCODE sy-vline 
WA_TBCO_FW_STR-SZART sy-vline 
WA_TBCO_FW_STR-UZAWE sy-vline 
WA_TBCO_FW_STR-NORDEXT sy-vline 
WA_TBCO_FW_STR-RDEALER sy-vline 
WA_TBCO_FW_STR-SSTOGRD sy-vline 
WA_TBCO_FW_STR-XSSTOGRD sy-vline 
WA_TBCO_FW_STR-SRNDNG sy-vline 
WA_TBCO_FW_STR-CORTYP sy-vline 
WA_TBCO_FW_STR-FORMULAR sy-vline 
WA_TBCO_FW_STR-SWIFT_DAT sy-vline 
WA_TBCO_FW_STR-SANLF sy-vline 
WA_TBCO_FW_STR-SFGTYP sy-vline 
WA_TBCO_FW_STR-SAKTIV sy-vline 
WA_TBCO_FW_STR-RPORTB sy-vline 
WA_TBCO_FW_STR-ZUONR sy-vline 
WA_TBCO_FW_STR-RANL sy-vline 
WA_TBCO_FW_STR-RLDEPO sy-vline 
WA_TBCO_FW_STR-PEFFZINS sy-vline 
WA_TBCO_FW_STR-SEFFMETH sy-vline 
WA_TBCO_FW_STR-XEFFMETH sy-vline 
WA_TBCO_FW_STR-ZUOND sy-vline 
WA_TBCO_FW_STR-REFER sy-vline 
WA_TBCO_FW_STR-MERKM sy-vline 
WA_TBCO_FW_STR-RCOMVALCL sy-vline 
WA_TBCO_FW_STR-XRCOMVALCL sy-vline 
WA_TBCO_FW_STR-FACILITYNR sy-vline 
WA_TBCO_FW_STR-FACILITYBUKRS sy-vline 
WA_TBCO_FW_STR-VRFHA sy-vline 
WA_TBCO_FW_STR-RRFHA sy-vline 
WA_TBCO_FW_STR-RBUKRS sy-vline 
WA_TBCO_FW_STR-TRANS_KEY sy-vline 
WA_TBCO_FW_STR-SFORMCT sy-vline 
WA_TBCO_FW_STR-BANKA_SB sy-vline 
WA_TBCO_FW_STR-BRNCH_SB sy-vline 
WA_TBCO_FW_STR-STRAS_SB sy-vline 
WA_TBCO_FW_STR-ORT01_SB sy-vline 
WA_TBCO_FW_STR-SWIFT_SB sy-vline 
WA_TBCO_FW_STR-BNKLZ_SB sy-vline 
WA_TBCO_FW_STR-BANKN_SK sy-vline 
WA_TBCO_FW_STR-BNKN2_SK sy-vline 
WA_TBCO_FW_STR-IBAN_SK sy-vline 
WA_TBCO_FW_STR-SDISP_INTST sy-vline 
WA_TBCO_FW_STR-SDISP_BNOM sy-vline 
WA_TBCO_FW_STR-SDISP_REF sy-vline 
WA_TBCO_FW_STR-SDISP_ZS sy-vline 
WA_TBCO_FW_STR-SDISP_COND sy-vline 
WA_TBCO_FW_STR-SDISP_COND_SE sy-vline 
WA_TBCO_FW_STR-SDISP_COND_REP sy-vline 
WA_TBCO_FW_STR-SDISP_RPAY sy-vline 
WA_TBCO_FW_STR-SDISP_BNOM_IN sy-vline 
WA_TBCO_FW_STR-SDISP_DIVID_FW sy-vline 
WA_TBCO_FW_STR-SFIXRFHAZU_CS sy-vline 
WA_TBCO_FW_STR-SFIXRFHAZU_TRS sy-vline 
WA_TBCO_FW_STR-SDISP_BNOM_TRS sy-vline 
WA_TBCO_FW_STR-SDISP_BNOM_TRS_IN sy-vline 
WA_TBCO_FW_STR-SDISP_DIVID_TRS sy-vline 
WA_TBCO_FW_STR-LEGAL_BASIS sy-vline 
WA_TBCO_FW_STR-TRADE_ID sy-vline 
WA_TBCO_FW_STR-MANDT_CD sy-vline 
WA_TBCO_FW_STR-RANL_CD sy-vline 
WA_TBCO_FW_STR-SANLF_CD sy-vline 
WA_TBCO_FW_STR-SSTATI_CD sy-vline 
WA_TBCO_FW_STR-RANLALT1_CD sy-vline 
WA_TBCO_FW_STR-RANLALT2_CD sy-vline 
WA_TBCO_FW_STR-GSART_CD sy-vline 
WA_TBCO_FW_STR-SBRSCH_CD sy-vline 
WA_TBCO_FW_STR-SWERTTYP_CD sy-vline 
WA_TBCO_FW_STR-SBOERNOT_CD sy-vline 
WA_TBCO_FW_STR-WLOMB_CD sy-vline 
WA_TBCO_FW_STR-JDECK_CD sy-vline 
WA_TBCO_FW_STR-WPFAN_CD sy-vline 
WA_TBCO_FW_STR-SSTBE_CD sy-vline 
WA_TBCO_FW_STR-LOEVM_CD sy-vline 
WA_TBCO_FW_STR-JABMI_CD sy-vline 
WA_TBCO_FW_STR-XALKZ_CD sy-vline 
WA_TBCO_FW_STR-XALLB_CD sy-vline 
WA_TBCO_FW_STR-REPKE_CD sy-vline 
WA_TBCO_FW_STR-BEMPREIS_CD sy-vline 
WA_TBCO_FW_STR-REWHR_CD sy-vline 
WA_TBCO_FW_STR-PEMKURS_CD sy-vline 
WA_TBCO_FW_STR-SNOTI_CD sy-vline 
WA_TBCO_FW_STR-PKUAB_CD sy-vline 
WA_TBCO_FW_STR-BKUAB_CD sy-vline 
WA_TBCO_FW_STR-DANDPFL_CD sy-vline 
WA_TBCO_FW_STR-DANDRE_CD sy-vline 
WA_TBCO_FW_STR-SOBJEKT_CD sy-vline 
WA_TBCO_FW_STR-RERF_CD sy-vline 
WA_TBCO_FW_STR-DERF_CD sy-vline 
WA_TBCO_FW_STR-TERF_CD sy-vline 
WA_TBCO_FW_STR-REHER_CD sy-vline 
WA_TBCO_FW_STR-RBEAR_CD sy-vline 
WA_TBCO_FW_STR-DBEAR_CD sy-vline 
WA_TBCO_FW_STR-TBEAR_CD sy-vline 
WA_TBCO_FW_STR-RBHER_CD sy-vline 
WA_TBCO_FW_STR-SROLEXT_CD sy-vline 
WA_TBCO_FW_STR-VVSLOEKZ_CD sy-vline 
WA_TBCO_FW_STR-JMUENDEL_CD sy-vline 
WA_TBCO_FW_STR-SMOVERW_CD sy-vline 
WA_TBCO_FW_STR-SIHERK_CD sy-vline 
WA_TBCO_FW_STR-KBEMPREIS_CD sy-vline 
WA_TBCO_FW_STR-SDEPOSTAT_CD sy-vline 
WA_TBCO_FW_STR-SFUNDI_CD sy-vline 
WA_TBCO_FW_STR-SWPHGMPF_CD sy-vline 
WA_TBCO_FW_STR-RISIN_CD sy-vline 
WA_TBCO_FW_STR-INSTITUTE_CD sy-vline 
WA_TBCO_FW_STR-RATING_CD sy-vline 
WA_TBCO_FW_STR-PRICE_INDEX_CD sy-vline 
WA_TBCO_FW_STR-PRICE_IDX_BDATE_CD sy-vline 
WA_TBCO_FW_STR-COICODE_CD sy-vline 
WA_TBCO_FW_STR-COILAND_CD sy-vline 
WA_TBCO_FW_STR-SFIMAMETHOD_CD sy-vline 
WA_TBCO_FW_STR-MANDT_AD sy-vline 
WA_TBCO_FW_STR-BUKRS_AD sy-vline 
WA_TBCO_FW_STR-RLDEPO_AD sy-vline 
WA_TBCO_FW_STR-VERKONTO_AD sy-vline 
WA_TBCO_FW_STR-RDEPOTNR_AD sy-vline 
WA_TBCO_FW_STR-XLDEPO_AD sy-vline 
WA_TBCO_FW_STR-RERTRK_AD sy-vline 
WA_TBCO_FW_STR-RDPBANK_AD sy-vline 
WA_TBCO_FW_STR-RBGUE_AD sy-vline 
WA_TBCO_FW_STR-SSPERRV_AD sy-vline 
WA_TBCO_FW_STR-DSPERR_AD sy-vline 
WA_TBCO_FW_STR-RGSBER_AD sy-vline 
WA_TBCO_FW_STR-SSKZB_AD sy-vline 
WA_TBCO_FW_STR-JVERMST_AD sy-vline 
WA_TBCO_FW_STR-SUDEC_AD sy-vline 
WA_TBCO_FW_STR-DEDEC_AD sy-vline 
WA_TBCO_FW_STR-RFGEB_AD sy-vline 
WA_TBCO_FW_STR-DFREI_AD sy-vline 
WA_TBCO_FW_STR-TFREI_AD sy-vline 
WA_TBCO_FW_STR-RERF_AD sy-vline 
WA_TBCO_FW_STR-DERF_AD sy-vline 
WA_TBCO_FW_STR-TERF_AD sy-vline 
WA_TBCO_FW_STR-REHER_AD sy-vline 
WA_TBCO_FW_STR-RBEAR_AD sy-vline 
WA_TBCO_FW_STR-DBEAR_AD sy-vline 
WA_TBCO_FW_STR-TBEAR_AD sy-vline 
WA_TBCO_FW_STR-RBHER_AD sy-vline 
WA_TBCO_FW_STR-RPORTB_AD sy-vline 
WA_TBCO_FW_STR-SOBJEKT_AD sy-vline 
WA_TBCO_FW_STR-SROLEXTDEP_AD sy-vline 
WA_TBCO_FW_STR-SROLEXTBEG_AD sy-vline 
WA_TBCO_FW_STR-VVSLOEKZ_AD sy-vline 
WA_TBCO_FW_STR-SSPERR_AD sy-vline 
WA_TBCO_FW_STR-RAHABKI_AD sy-vline 
WA_TBCO_FW_STR-RAHKTID_AD sy-vline 
WA_TBCO_FW_STR-SEC_ACC_GRP_AD sy-vline 
WA_TBCO_FW_STR-STATUS_AD sy-vline 
WA_TBCO_FW_STR-STATUS_RBEAR_AD sy-vline 
WA_TBCO_FW_STR-STATUS_DBEAR_AD sy-vline 
WA_TBCO_FW_STR-STATUS_TBEAR_AD sy-vline 
WA_TBCO_FW_STR-SECACC_TYPE_AD sy-vline 
WA_TBCO_FW_STR-EXT_SEC_ACC_NO_AD sy-vline 
WA_TBCO_FW_STR-FLG_NO_TAX_MAP_AD sy-vline 
WA_TBCO_FW_STR-BUDAT_AD sy-vline 
WA_TBCO_FW_STR-COUNTRY_VAR_AD sy-vline 
WA_TBCO_FW_STR-SPARTE_AD sy-vline 
WA_TBCO_FW_STR-STOCKBAV_AD sy-vline 
WA_TBCO_FW_STR-ADDRNUMBER_AD sy-vline 
WA_TBCO_FW_STR-ANRED_AD sy-vline 
WA_TBCO_FW_STR-NAME1_AD sy-vline 
WA_TBCO_FW_STR-NAME2_AD sy-vline 
WA_TBCO_FW_STR-NAME3_AD sy-vline 
WA_TBCO_FW_STR-NAME4_AD sy-vline 
WA_TBCO_FW_STR-STRAS_AD sy-vline 
WA_TBCO_FW_STR-PFACH_AD sy-vline 
WA_TBCO_FW_STR-PSTL2_AD sy-vline 
WA_TBCO_FW_STR-PFORT_AD sy-vline 
WA_TBCO_FW_STR-LAND1_AD sy-vline 
WA_TBCO_FW_STR-PSTLZ_AD sy-vline 
WA_TBCO_FW_STR-ORT01_AD sy-vline 
WA_TBCO_FW_STR-ORT02_AD sy-vline 
WA_TBCO_FW_STR-REGIO_AD sy-vline 
WA_TBCO_FW_STR-SPRAS_AD sy-vline 
WA_TBCO_FW_STR-INLND_AD sy-vline 
WA_TBCO_FW_STR-ANZZL_AD sy-vline 
WA_TBCO_FW_STR-PRIOR_AD sy-vline 
WA_TBCO_FW_STR-WAREN_AD sy-vline 
WA_TBCO_FW_STR-RHANDPL sy-vline 
WA_TBCO_FW_STR-XREPKE sy-vline 
WA_TBCO_FW_STR-REPKE_ADDRNO sy-vline 
WA_TBCO_FW_STR-XRANLALT1_L sy-vline 
WA_TBCO_FW_STR-XRANLALT1_S sy-vline 
WA_TBCO_FW_STR-XRANLALT2_L sy-vline 
WA_TBCO_FW_STR-XRANLALT2_S sy-vline 
WA_TBCO_FW_STR-DVALUT sy-vline 
WA_TBCO_FW_STR-DZTERM sy-vline 
WA_TBCO_FW_STR-DBESTAND sy-vline 
WA_TBCO_FW_STR-SFHAZBA sy-vline 
WA_TBCO_FW_STR-XBEWART sy-vline 
WA_TBCO_FW_STR-ASTUECK sy-vline 
WA_TBCO_FW_STR-BNWHR sy-vline 
WA_TBCO_FW_STR-WPRICE sy-vline 
WA_TBCO_FW_STR-BUPRC sy-vline 
WA_TBCO_FW_STR-BPPRC sy-vline 
WA_TBCO_FW_STR-SSIGN sy-vline 
WA_TBCO_FW_STR-WZBETR sy-vline 
WA_TBCO_FW_STR-BZBETR sy-vline 
WA_TBCO_FW_STR-BHWBETR sy-vline 
WA_TBCO_FW_STR-WHWBETR sy-vline 
WA_TBCO_FW_STR-KHWKURS sy-vline 
WA_TBCO_FW_STR-WBBETR sy-vline 
WA_TBCO_FW_STR-BBBETR sy-vline 
WA_TBCO_FW_STR-WEBETR sy-vline 
WA_TBCO_FW_STR-BEBETR sy-vline 
WA_TBCO_FW_STR-BTOTAL sy-vline 
WA_TBCO_FW_STR-WTOTAL sy-vline 
WA_TBCO_FW_STR-SRUNIT sy-vline 
WA_TBCO_FW_STR-KZWKURS sy-vline 
WA_TBCO_FW_STR-KBWKURS sy-vline 
WA_TBCO_FW_STR-BPPRC_SPOT2 sy-vline 
WA_TBCO_FW_STR-BPPRC_SPOT1 sy-vline 
WA_TBCO_FW_STR-BPPRC_MARG sy-vline 
WA_TBCO_FW_STR-BUPRC_MARG sy-vline 
WA_TBCO_FW_STR-BUPRC_SPOT1 sy-vline 
WA_TBCO_FW_STR-BUPRC_SPOT2 sy-vline 
WA_TBCO_FW_STR-COC_RATE sy-vline 
WA_TBCO_FW_STR-SDISP_FW sy-vline 
WA_TBCO_FW_STR-BNWHR_TBANXT sy-vline 
WA_TBCO_FW_STR-BNWHR_RMNG sy-vline 
WA_TBCO_FW_STR-ASTUECK_TBANXT sy-vline 
WA_TBCO_FW_STR-ASTUECK_RMNG sy-vline 
WA_TBCO_FW_STR-INTREST_FWD sy-vline 
WA_TBCO_FW_STR-COST_FWD sy-vline      INTO ld_text SEPARATED BY SPACE.

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