TOE_CDS_TRM_DEALS

CDS View for Financial Transaction Selection | view: TOEV_TR_DEALS | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: REFH, REFON, VTBFHAPO, VTBFHAZU, VTIOFZU, T001, VTBFHA, VTIFHA, VTIFHAPO, VTIFHAZU, VTIOF, ATPA
Column Name Description
Column Name Description
amount null
company_code_amount null
Column Name Description
Column Name Description
trm_end_of_term Term End
trm_fixing_date Term End
end_of_term_opt_exec Term End
trm_end_opt_ndf Term End
trm_contract_conclusion_date Contract Conclusion Date
trm_contract_date Term Start
Column Name Description
trm_contract_type Contract Type Show values
Column Name Description Domain name
deal_number Financial Transaction T_RFHA
trm_characteristics Characteristics CHAR25
trm_assignment Assignment TEXT18
business_partner Business Partner Number BU_PARTNER
hedge_request_id Hedge Request ID TOE_REQUEST_ID
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • TOE_CDS_TRM_DEALS.MANDT == TGSB.MANDT
  • TOE_CDS_TRM_DEALS.BUSINESS_AREA == TGSB.GSBER
Company code
  • Client
  • Company Code
  • TOE_CDS_TRM_DEALS.MANDT == T001.MANDT
  • TOE_CDS_TRM_DEALS.COMPANY_CODE == T001.BUKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • ?
  • TOE_CDS_TRM_DEALS.MANDT == CSKS.MANDT
  • TOE_CDS_TRM_DEALS.COST_CENTER == CSKS.KOSTL
  • TOE_CDS_TRM_DEALS.[column in domain "KOKRS"] == CSKS.KOKRS
  • TOE_CDS_TRM_DEALS.[column in domain "DATBI"] == CSKS.DATBI
Country/Region Key
  • Client
  • Country/Region Key
  • TOE_CDS_TRM_DEALS.MANDT == T005.MANDT
  • TOE_CDS_TRM_DEALS.COUNTRY == T005.LAND1
Hedging Classification
  • Client
  • Hedging Classification
  • TOE_CDS_TRM_DEALS.MANDT == TOEC_CLASS.CLIENT
  • TOE_CDS_TRM_DEALS.HEDGING_CLASS == TOEC_CLASS.HEDGING_CLASSIFICATION
On Behalf of Company Code
  • On Behalf of Company Code
  • Client
  • TOE_CDS_TRM_DEALS.ON_BEHALF_OF_COMPANY == T001.BUKRS
  • TOE_CDS_TRM_DEALS.MANDT == T001.MANDT
Portfolio
  • Client
  • Portfolio
  • Company Code
  • TOE_CDS_TRM_DEALS.MANDT == TWPOB.MANDT
  • TOE_CDS_TRM_DEALS.PORTFOLIO == TWPOB.RPORTB
  • TOE_CDS_TRM_DEALS.COMPANY_CODE == TWPOB.BUKRS
Profit Center
  • Client
  • Profit Center
  • ?
  • ?
  • TOE_CDS_TRM_DEALS.MANDT == CEPC.MANDT
  • TOE_CDS_TRM_DEALS.PROFIT_CENTER == CEPC.PRCTR
  • TOE_CDS_TRM_DEALS.[column in domain "KOKRS"] == CEPC.KOKRS
  • TOE_CDS_TRM_DEALS.[column in domain "DATBI"] == CEPC.DATBI
Currency Key
  • Client
  • Currency Key
  • TOE_CDS_TRM_DEALS.MANDT == TCURC.MANDT
  • TOE_CDS_TRM_DEALS.RISKFREE_CURRENCY == TCURC.WAERS
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • TOE_CDS_TRM_DEALS.MANDT == FAGL_SEGM.MANDT
  • TOE_CDS_TRM_DEALS.SEGMENT == FAGL_SEGM.SEGMENT
Transaction Activity Category
  • Transaction Activity Category
  • ?
  • ?
  • TOE_CDS_TRM_DEALS.TRM_ACTIVITY_CATEGORY == AT02.SFGZUSTT
  • TOE_CDS_TRM_DEALS.[column in domain "TB_SFGTYP"] == AT02.SFGTYP
  • TOE_CDS_TRM_DEALS.[column in domain "TB_SANLF"] == AT02.SANLFOR
Transaction type
  • Client
  • Product Type
  • TOE_CDS_TRM_DEALS.MANDT == TZPA.MANDT
  • TOE_CDS_TRM_DEALS.TRM_PRODUCT_TYPE == TZPA.GSART
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • Product Type
  • TOE_CDS_TRM_DEALS.MANDT == AT10.MANDT
  • TOE_CDS_TRM_DEALS.TRM_TRANSACTION_TYPE == AT10.SFHAART
  • TOE_CDS_TRM_DEALS.TRM_PRODUCT_TYPE == AT10.SGSART
Transaction Category
  • Transaction Category
  • Transaction Category
  • ?
  • TOE_CDS_TRM_DEALS.TRM_TRANS_TYPE_LONG == AT01.SFGTYP
  • TOE_CDS_TRM_DEALS.TRM_TRANS_CAT == AT01.SFGTYP
  • TOE_CDS_TRM_DEALS.[column in domain "TB_SANLF"] == AT01.SANLFOR
Transaction Category
  • Transaction Category
  • Transaction Category
  • ?
  • TOE_CDS_TRM_DEALS.TRM_TRANS_TYPE_LONG == AT01.SFGTYP
  • TOE_CDS_TRM_DEALS.TRM_TRANS_CAT == AT01.SFGTYP
  • TOE_CDS_TRM_DEALS.[column in domain "TB_SANLF"] == AT01.SANLFOR