What is I_FinancialTransactionDEX in SAP S/4HANA?

I_FinancialTransactionDEX is a composite CDS view in SAP S/4HANA. Financial Transaction It contains 137 fields.

Which tables does I_FinancialTransactionDEX read from?

I_FinancialTransactionDEX reads data from: I_FinancialTransaction.

What VDM layer is I_FinancialTransactionDEX?

I_FinancialTransactionDEX is classified as a Composite view that combines data from multiple basic views.

I_FinancialTransactionDEX

DDL: I_FINANCIALTRANSACTIONDEX Type: view_entity COMPOSITE

137 Fields 1 Data Sources 40 Associations

Financial Transaction

I_FinancialTransactionDEX (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Transaction · Financial Operations

I_FinancialTransactionDEX is a Composite CDS View (Dimension) that provides data about "Financial Transaction" in SAP S/4HANA. It reads from 1 data source (I_FinancialTransaction) and exposes 137 fields with key fields CompanyCode, FinancialTransaction. It has 40 associations to related views.

SAP Help Documentation

Category	CDS Views for Transactional Data
Data Category	Dimension

Purpose
This CDS view supports the extraction of administrative financial transaction data. This CDS view provides the data to answer the following business questions: Which financial transactions exist? Which financial transactions are made with a specific counterparty? Which financial transactions are created for a specific hedging classification? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Authorization Object ID Authorization Object Text T_DEAL_DP Authorization for Securities Account T_DEAL_PD Authorization for Product/Transaction Types T_DEAL_PF Portfolio Authorization

Structure
Important Fields Important fields in this view include the following: Field Name Is Key Data Element Label CompanyCode X BUKRS Company Code FinancialTransaction X TB_RFHA Transaction FinTransCreationDate FTR_CREATION_DATE Created On FinTransCreationTime TB_TCRTIM Entry Time LastChangeDate TB_DUPDAT Changed On FinInstrumentLastChangedTime TB_TUPTIM Time Changed TreasuryContractType RANTYP Contract Type FinancialInstrProductCategory FTR_GEN_FIN_INSTR_PROD_CATEG Product Category FinancialInstrumentProductType VVSART Product Type FinInstrTransactionCategory TB_SFGTYP Transaction Category FinancialInstrTransactionType FTR_GEN_TRANSACTION_TYPE Transaction Type TermStartDate TB_DBLFZ Term Start FinTransNoticePeriod TB_AKUEND Period of Notice FinTransNoticePeriodUnit TB_SKUEND Unit FinTransFactoryCalendar1 SKALID Calendar FinTransFactoryCalendar2 SKALID Calendar Counterparty RKONTRAH_NEW Counterparty FinancialInstrumentGuarantor TB_RGARANT_NEW Guarantor Portfolio RPORTB Portfolio TreasuryFinanceProject TB_TFPROJ Finance Project FinancialInstrumentAssignment FTR_GEN_FIN_INSTR_ASSIGNMENT Free Assignment FinancialInstrumentReference FTR_GEN_FIN_INSTR_INTERNAL_REF Free Internal Ref. FinancialInstrCharacteristic FTR_GEN_FIN_INSTR_CHAR Free Charact. ControllingArea KOKRS Controlling Area CostCenter KOSTL Cost Center HedgingClassification TOE_HEDGING_CLASSIFICATION Hedging Classificatn HedgeRequestIdentifier HEDGE_REQUEST_IDENTIFIER Hedge Request ID ProfitCenter PRCTR Profit Center WBSElementInternalID PS_S4_PSPNR WBS Internal ID TreasuryFacilityCompanyCode TB_FACILITYBUKRS CoCd of Facility TreasuryFacility TB_FACILITYNR Facility FinancialInstrumentStatus TB_SAKTIV Active Status FinTransReleaseStatus TB_FRGZUST Release Status TransactionCurrency TB_WGSCHFT Transaction Currency FinInstrumentOutgoingCurrency TB_WGSCHF1 Outgoing Currency FinInstrumentIncomingCurrency TB_WGSCHF2 Incoming Currency TradedCurrency FTR_TRADED_CURR Traded Currency SecurityClass FTR_GEN_SECURITY_CLASS Security Class ClassificationOfFinInstr FTR_CFI_CODE CFI Code SecurityAccount FTR_GEN_SECURITY_ACCOUNT Securities Account FinTransIsRiskMitigating FTR_THRESHOLD_RISK_MITIGATING Risk Mitigation FinInstrLastActiveActivity FTR_GEN_FIN_INSTR_LAST_ACT_ACT Last Active Activity TrsyTradedAmountBuySellCode TTM_FX_BUY_SELL Buy/Sell Segment FB_SEGMENT Segment OnBehalfOfCompany TRBA_BEHALF_OF_COMPANY On Behalf of CoCode MarketIdentifierCode TBA_MIC MIC FinTransRoundingCategory TB_SRNDNG Round FinTransGeneralValuationClass TPM_COM_VAL_CLASS Gen. Valn Class Fund FM_FUND Fund GrantID GM_GRANT_NBR Grant FinTransAuthorizationGroup TBEGRU Authorization Group BusinessPlace BUPLA Business Place FunctionalArea FKBER Functional Area TrsyPosCustomDiffntnTerm1 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val. TrsyPosCustomDiffntnTerm2 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val. TrsyPosCustomDiffntnTerm3 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val. TrsyPosCustomDiffntnTerm4 TPM_CUST_DIFF_TERM_VA

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Financial Operations
Application Component	FIN-FSCM-TRM
Capabilities	Analytical Dimension, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction, Data Source for Defining CDS Entities
Package	Financial Operations for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_FinancialTransaction	FiancialTransaction	from

Associations (40)

Cardinality	Target	Alias	Condition
[1..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_TreasuryContractType	_ContractType	`$projection.TreasuryContractType = _ContractType.TreasuryContractType`
[0..1]	I_FinancialInstrProdCat	_FinancialInstrProdCat	`$projection.FinancialInstrProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory`
[0..1]	I_FinancialinstrProductType	_FinancialInstrProdType	`$projection.FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType`
[0..1]	I_FinInstrTransCat	_FinInstrTransCat	`$projection.FinancialInstrProductCategory = _FinInstrTransCat.FinancialInstrProductCategory and $projection.FinInstrTransactionCategory = _FinInstrTransCat.FinInstrTransactionCategory`
[1..1]	I_FinancialInstrTransType	_FinancialInstrTransType	`$projection.FinancialInstrTransactionType = _FinancialInstrTransType.FinancialInstrTransactionType and $projection.FinancialInstrumentProductType = _FinancialInstrTransType.FinancialInstrumentProductType`
[0..1]	I_FinTransNoticePeriodUnit	_NoticePeriodUnit	`$projection.FinTransNoticePeriodUnit = _NoticePeriodUnit.FinTransNoticePeriodUnit`
[0..1]	I_FactoryCalendar	_Calendar	`$projection.FinTransFactoryCalendar1 = _Calendar.FactoryCalendar`
[0..1]	I_FactoryCalendar	_Calendar2	`$projection.FinTransFactoryCalendar2 = _Calendar2.FactoryCalendar`
[1..1]	I_BusinessPartner	_Counterparty	`$projection.Counterparty = _Counterparty.BusinessPartner`
[0..1]	I_BusinessPartner	_Guarantor	`$projection.FinancialInstrumentGuarantor = _Guarantor.BusinessPartner`
[0..1]	I_TreasuryPortfolio	_Portfolio	`$projection.CompanyCode = _Portfolio.CompanyCode and $projection.Portfolio = _Portfolio.Portfolio`
[0..1]	I_ControllingArea	_ControllingArea	`$projection.controllingarea = _ControllingArea.ControllingArea`
[0..*]	I_CostCenter	_CostCenter	`$projection.controllingarea = _CostCenter.ControllingArea and $projection.CostCenter = _CostCenter.CostCenter`
[0..*]	I_ProfitCenter	_ProfitCenter	`$projection.controllingarea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter`
[0..1]	I_FinancialInstrAssignment	_Assignment	`$projection.FinancialInstrumentAssignment = _Assignment.FinancialInstrumentAssignment`
[0..1]	I_FinancialInstrReference	_Reference	`$projection.FinancialInstrumentReference = _Reference.FinancialInstrumentReference`
[0..1]	I_FinancialInstrCharacteristic	_Characteristics	`$projection.FinancialInstrCharacteristic = _Characteristics.FinancialInstrCharacteristic`
[0..1]	I_Financialinstrvaluationclass	_GeneralValuationClass	`$projection.FinTransGeneralValuationClass = _GeneralValuationClass.FinancialInstrValuationClass`
[0..1]	I_TreasuryHedgingClassfctn	_TreasuryHedgingClassfctn	`$projection.HedgingClassification = _TreasuryHedgingClassfctn.HedgingClassification`
[0..1]	I_WBSElementBasicData	_WBSElement	`$projection.WBSElementInternalID = _WBSElement.WBSElementInternalID`
[0..1]	I_CompanyCode	_FacilityCompanyCode	`$projection.TreasuryFacilityCompanyCode = _FacilityCompanyCode.CompanyCode`
[0..1]	I_FinInstrumentStatus	_Status	`$projection.FinancialInstrumentStatus = _Status.FinancialInstrumentStatus`
[0..1]	I_FinTransReleaseStatus	_ReleaseStatus	`$projection.FinTransReleaseStatus = _ReleaseStatus.FinTransReleaseStatus`
[0..1]	I_Currency	_Currency	`$projection.TransactionCurrency = _Currency.Currency`
[0..1]	I_Currency	_OutgoingCurrency	`$projection.FinInstrumentOutgoingCurrency = _OutgoingCurrency.Currency`
[0..1]	I_Currency	_IncomingCurrency	`$projection.FinInstrumentIncomingCurrency = _IncomingCurrency.Currency`
[0..1]	I_Currency	_TradedCurrency	`$projection.TradedCurrency = _TradedCurrency.Currency`
[0..1]	I_SecurityClass	_SecurityClass	`$projection.SecurityClass = _SecurityClass.SecurityClass`
[0..1]	I_SecurityAccount	_SecurityAccount	`$projection.SecurityAccount = _SecurityAccount.SecurityAccount and $projection.CompanyCode = _SecurityAccount.CompanyCode`
[0..1]	I_TimeZone	_TimeZone	`$projection.FinTransActyConclusionTimeZone = _TimeZone.TimeZoneID`
[0..1]	I_FXFixingReference	_FixingReference	`$projection.ForeignExchangeFixingReference = _FixingReference.ForeignExchangeFixingReference`
[0..1]	I_TreasuryReversalReason	_ReversalReason	`$projection.TreasuryReversalReason = _ReversalReason.TreasuryReversalReason`
[0..1]	I_Currency	_LeadingCurrency	`$projection.LeadingCurrency = _LeadingCurrency.Currency`
[0..1]	I_Currency	_FollowingCurrency	`$projection.FollowingCurrency = _FollowingCurrency.Currency`
[0..1]	I_BusinessPartner	_Applicant	`$projection.TreasuryApplicant = _Applicant.BusinessPartner`
[0..1]	I_BusinessPartner	_Beneficiary	`$projection.TreasuryBeneficiary = _Beneficiary.BusinessPartner`
[0..1]	I_BusinessPartner	_AdvisingBank	`$projection.TreasuryAdvisingBank = _AdvisingBank.BusinessPartner`
[0..1]	I_BusinessPartner	_IssuingBank	`$projection.TreasuryIssuingBank = _IssuingBank.BusinessPartner`
[0..1]	I_FinInstrActivityCategory	_ActivityCategory	`$projection.FinancialInstrProductCategory = _ActivityCategory.FinancialInstrProductCategory and $projection.FinInstrTransactionCategory = _ActivityCategory.FinInstrTransactionCategory and $projection.FinancialInstrActivityCategory = _ActivityCategory.FinancialInstrActivityCategory`

Annotations (15)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Financial Transaction	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.representativeKey	FinancialTransaction	view
ObjectModel.sapObjectNodeType.name	FinancialTransaction	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataCategory	#DIMENSION	view
Analytics.internalName	#LOCAL	view
Metadata.allowExtensions	true	view
VDM.viewType	#COMPOSITE	view

Fields (137)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_FinancialTransaction	CompanyCode	Receiver Company Code
KEY	FinancialTransaction	I_FinancialTransaction	FinancialTransaction	Financial Transaction
	FinTransCreationDate	I_FinancialTransaction	FinTransCreationDate	Entered On
	FinTransCreationTime	I_FinancialTransaction	FinTransCreationTime	Entry Time
	LastChangeDate	I_FinancialTransaction	LastChangeDate	Time Stamp
	FinInstrumentLastChangedTime	I_FinancialTransaction	FinInstrumentLastChangedTime	Time Changed
	TreasuryContractType	I_FinancialTransaction	TreasuryContractType	Treasury Contract Type
	FinancialInstrProductCategory	I_FinancialTransaction	FinancialInstrProductCategory	Financial Instrument Product Category
	FinancialInstrumentProductType	I_FinancialTransaction	FinancialInstrumentProductType	Product Type
	FinInstrTransactionCategory	I_FinancialTransaction	FinInstrTransactionCategory	Transaction Category
	FinancialInstrTransactionType	I_FinancialTransaction	FinancialInstrTransactionType	Financial Instrument Transaction Type
	TermStartDate	I_FinancialTransaction	TermStartDate	Term Start
	FinTransNoticePeriod	I_FinancialTransaction	FinTransNoticePeriod	Period of Notice
	FinTransNoticePeriodUnit	I_FinancialTransaction	FinTransNoticePeriodUnit	Unit of Period of Notice
	FinTransFactoryCalendar1	I_FinancialTransaction	FinTransFactoryCalendar1	Factory calendar
	FinTransFactoryCalendar2	I_FinancialTransaction	FinTransFactoryCalendar2	Factory calendar
	Counterparty	I_FinancialTransaction	Counterparty	Counterparty Number
	FinancialInstrumentGuarantor	I_FinancialTransaction	FinancialInstrumentGuarantor	Guarantor of Financial Transaction
	Portfolio	I_FinancialTransaction	Portfolio	Portfolio
	TreasuryFinanceProject	I_FinancialTransaction	TreasuryFinanceProject	Finance Project
	FinancialInstrumentAssignment	I_FinancialTransaction	FinancialInstrumentAssignment	Free Assignment of Financial Transaction
	FinancialInstrumentReference	I_FinancialTransaction	FinancialInstrumentReference	Free Internal Reference of Financial Transaction
	FinancialInstrCharacteristic	I_FinancialTransaction	FinancialInstrCharacteristic	Free Characteristic of Financial Transaction
	ControllingArea	_CompanyCode	ControllingArea	Controlling Area
	CostCenter	I_FinancialTransaction	CostCenter	Cost Center
	HedgingClassification	I_FinancialTransaction	HedgingClassification	Hedging Classification
	HedgeRequestIdentifier	I_FinancialTransaction	HedgeRequestIdentifier	Hedge Request Identifier
	ProfitCenter	I_FinancialTransaction	ProfitCenter	Profit Center
	WBSElementInternalID	I_FinancialTransaction	WBSElementInternalID	WBS Internal ID
	TreasuryFacilityCompanyCode	I_FinancialTransaction	TreasuryFacilityCompanyCode	Company Code of Facility
	TreasuryFacility	I_FinancialTransaction	TreasuryFacility	Transaction Number of Facility
	FinancialInstrumentStatus	I_FinancialTransaction	FinancialInstrumentStatus	Active Status of Transaction or Activity
	FinTransReleaseStatus	I_FinancialTransaction	FinTransReleaseStatus	Transaction Release: Release Status
	TransactionCurrency	I_FinancialTransaction	TransactionCurrency	Transaction Currency
	FinInstrumentOutgoingCurrency	I_FinancialTransaction	FinInstrumentOutgoingCurrency	Currency of Outgoing Side
	FinInstrumentIncomingCurrency	I_FinancialTransaction	FinInstrumentIncomingCurrency	Currency of Incoming Side
	TradedCurrency	I_FinancialTransaction	TradedCurrency	Traded Currency
	SecurityClass	I_FinancialTransaction	SecurityClass	Security Class
	ClassificationOfFinInstr	I_FinancialTransaction	ClassificationOfFinInstr	CFI Code
	SecurityAccount	I_FinancialTransaction	SecurityAccount	Security Account
	FinTransIsRiskMitigating	I_FinancialTransaction	FinTransIsRiskMitigating	Risk Mitigation Indicator
	FinInstrLastActiveActivity	I_FinancialTransaction	FinInstrLastActiveActivity	Last Active Activity of Financial Transaction
	TrsyTradedAmountBuySellCode	I_FinancialTransaction	TrsyTradedAmountBuySellCode	FX: Buy Sell Indicator
	Segment	I_FinancialTransaction	Segment	Segment for Segmental Reporting
	OnBehalfOfCompany	I_FinancialTransaction	OnBehalfOfCompany	On Behalf of Company Code
	MarketIdentifierCode	I_FinancialTransaction	MarketIdentifierCode	Market Identifier Code
	FinTransRoundingCategory	I_FinancialTransaction	FinTransRoundingCategory	Rounding of Amount from Generated Flows
	FinTransGeneralValuationClass	I_FinancialTransaction	FinTransGeneralValuationClass	General Valuation Class
	Fund	I_FinancialTransaction	Fund	Sender Fund
	GrantID	I_FinancialTransaction	GrantID	Sender Grant
	FinTransAuthorizationGroup	I_FinancialTransaction	FinTransAuthorizationGroup	Authorization Group
	BusinessPlace	I_FinancialTransaction	BusinessPlace	Business place
	FunctionalArea	I_FinancialTransaction	FunctionalArea	Sendr Fctl Area
	TrsyPosCustomDiffntnTerm1	I_FinancialTransaction	TrsyPosCustomDiffntnTerm1	Custom Differentiation Term Value
	TrsyPosCustomDiffntnTerm2	I_FinancialTransaction	TrsyPosCustomDiffntnTerm2	Custom Differentiation Term Value
	TrsyPosCustomDiffntnTerm3	I_FinancialTransaction	TrsyPosCustomDiffntnTerm3	Custom Differentiation Term Value
	TrsyPosCustomDiffntnTerm4	I_FinancialTransaction	TrsyPosCustomDiffntnTerm4	Custom Differentiation Term Value
	TrsyPosCustomDiffntnTerm5	I_FinancialTransaction	TrsyPosCustomDiffntnTerm5	Custom Differentiation Term Value
	UniqueProductIdentifier	I_FinancialTransaction	UniqueProductIdentifier	Unique Product Identifier (UPI)
	InternationalSecuritiesIdnNmbr	I_FinancialTransaction	InternationalSecuritiesIdnNmbr	Security ID Number (ISIN)
	ReportTrackingNumber	I_FinancialTransaction	ReportTrackingNumber	Report Tracking Number (RTN)
	FinTransOptionNumber	I_FinancialTransaction	FinTransOptionNumber	Class
	FinancialInstrActivityCategory	CurrentActivity	FinancialInstrActivityCategory	Transaction Activity Category
	TermEndDate	CurrentActivity	TermEndDate	Term End
	FinTransTermCategory	CurrentActivity	FinTransTermCategory	Financial Transaction Term Category
	FinTransTermStartEndInclusive	CurrentActivity	FinTransTermStartEndInclusive	Financial Transaction Term Start End Inclusive
	FinTransNoticeDate	CurrentActivity	FinTransNoticeDate	OTC Notice Date
	FinTransActyConclusionDate	CurrentActivity	FinTransActyConclusionDate	Conclusion Date of a Financial Transaction Activity
	FinTransActyConclusionTime	CurrentActivity	FinTransActyConclusionTime	Time of Contract Conclusion
	FinTransActyConclusionTimeZone	CurrentActivity	FinTransActyConclusionTimeZone	Time Zone of Contract Date and Time
	FinTransRolloverDate	CurrentActivity	FinTransRolloverDate	Term Start
	FinTransExerciseDate	CurrentActivity	FinTransExerciseDate	Term End
	FinTransOrderValidityEndDate	CurrentActivity	FinTransOrderValidityEndDate	Limit Date
	FinTransFixingDate	CurrentActivity	FinTransFixingDate	Fixing Date
	ForeignExchangeFixingReference	CurrentActivity	ForeignExchangeFixingReference	Fixing Reference ID
	Trader	CurrentActivity	Trader	Trader
	FinancialInstrContactPerson	CurrentActivity	FinancialInstrContactPerson	Contact Person
	FinInstrExternalReference	CurrentActivity	FinInstrExternalReference	External Reference
	TreasuryReversalReason	CurrentActivity	TreasuryReversalReason	Reason for Reversal
	LeadingCurrency	CurrentActivity	LeadingCurrency	Leading Currency
	FollowingCurrency	CurrentActivity	FollowingCurrency	Following Currency
	ExchangeRate	CurrentActivity	ExchangeRate	Rate of Foreign Exchange Transaction
	SpotExchangeRate	CurrentActivity	SpotExchangeRate	Spot Rate
	SwapExchangeRate	CurrentActivity	SwapExchangeRate	Swap Rate
	LiquidityEffectValue	CurrentActivity	LiquidityEffectValue	Liquidity Effect for Rollover
	CurrencyPair	CurrentActivity	CurrencyPair	Currency Pair
	EffectiveInterestRate	CurrentActivity	EffectiveInterestRate	Effective Interest Rate
	EffectiveInterestMethod	CurrentActivity	EffectiveInterestMethod	Effective Interest Method (Financial Mathematics)
	LetterOfCredit	CurrentActivity	LetterOfCredit	Letter of Credit Number
	TreasuryApplicant	CurrentActivity	TreasuryApplicant	Applicant
	TreasuryBeneficiary	CurrentActivity	TreasuryBeneficiary	Beneficiary
	TrsyMnllyEnteredBnfcyName	CurrentActivity	TrsyMnllyEnteredBnfcyName	Manually Entered Beneficiary Name
	TrsyMnllyEnteredApplcntName	CurrentActivity	TrsyMnllyEnteredApplcntName	Manual Company Name
	TreasuryAdvisingBank	CurrentActivity	TreasuryAdvisingBank	Advising Bank
	TreasuryIssuingBank	CurrentActivity	TreasuryIssuingBank	Issuing Bank
	BankGuaranteeNumber	CurrentActivity	BankGuaranteeNumber	Bank Guarantee Number
	BankGuaranteeType	CurrentActivity	BankGuaranteeType	Bank Guarantee Type
	_CompanyCode		_CompanyCode
	_ContractType		_ContractType
	_FinancialInstrProdCat		_FinancialInstrProdCat
	_FinancialInstrProdType		_FinancialInstrProdType
	_FinInstrTransCat		_FinInstrTransCat
	_FinancialInstrTransType		_FinancialInstrTransType
	_NoticePeriodUnit		_NoticePeriodUnit
	_Calendar		_Calendar
	_Calendar2		_Calendar2
	_Counterparty		_Counterparty
	_Guarantor		_Guarantor
	_Portfolio		_Portfolio
	_Assignment		_Assignment
	_Reference		_Reference
	_ControllingArea		_ControllingArea
	_CostCenter		_CostCenter
	_ProfitCenter		_ProfitCenter
	_Characteristics		_Characteristics
	_GeneralValuationClass		_GeneralValuationClass
	_TreasuryHedgingClassfctn		_TreasuryHedgingClassfctn
	_WBSElement		_WBSElement
	_FacilityCompanyCode		_FacilityCompanyCode
	_Status		_Status
	_ReleaseStatus		_ReleaseStatus
	_Currency		_Currency
	_OutgoingCurrency		_OutgoingCurrency
	_IncomingCurrency		_IncomingCurrency
	_TradedCurrency		_TradedCurrency
	_SecurityClass		_SecurityClass
	_SecurityAccount		_SecurityAccount
	_ActivityCategory		_ActivityCategory
	_TimeZone		_TimeZone
	_FixingReference		_FixingReference
	_ReversalReason		_ReversalReason
	_LeadingCurrency		_LeadingCurrency
	_FollowingCurrency		_FollowingCurrency
	_Applicant		_Applicant
	_Beneficiary		_Beneficiary
	_AdvisingBank		_AdvisingBank
	_IssuingBank		_IssuingBank

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FinancialTransactionDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_FinancialTransactionDEX AS
SELECT
  FiancialTransaction.CompanyCode AS CompanyCode,
  FiancialTransaction.FinancialTransaction AS FinancialTransaction,
  FiancialTransaction.FinTransCreationDate AS FinTransCreationDate,
  FiancialTransaction.FinTransCreationTime AS FinTransCreationTime,
  FiancialTransaction.LastChangeDate AS LastChangeDate,
  FiancialTransaction.FinInstrumentLastChangedTime AS FinInstrumentLastChangedTime,
  FiancialTransaction.TreasuryContractType AS TreasuryContractType,
  FiancialTransaction.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  FiancialTransaction.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  FiancialTransaction.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  FiancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  FiancialTransaction.TermStartDate AS TermStartDate,
  FiancialTransaction.FinTransNoticePeriod AS FinTransNoticePeriod,
  FiancialTransaction.FinTransNoticePeriodUnit AS FinTransNoticePeriodUnit,
  FiancialTransaction.FinTransFactoryCalendar1 AS FinTransFactoryCalendar1,
  FiancialTransaction.FinTransFactoryCalendar2 AS FinTransFactoryCalendar2,
  FiancialTransaction.Counterparty AS Counterparty,
  FiancialTransaction.FinancialInstrumentGuarantor AS FinancialInstrumentGuarantor,
  FiancialTransaction.Portfolio AS Portfolio,
  FiancialTransaction.TreasuryFinanceProject AS TreasuryFinanceProject,
  FiancialTransaction.FinancialInstrumentAssignment AS FinancialInstrumentAssignment,
  FiancialTransaction.FinancialInstrumentReference AS FinancialInstrumentReference,
  FiancialTransaction.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
  _CompanyCode.ControllingArea AS ControllingArea,
  FiancialTransaction.CostCenter AS CostCenter,
  FiancialTransaction.HedgingClassification AS HedgingClassification,
  FiancialTransaction.HedgeRequestIdentifier AS HedgeRequestIdentifier,
  FiancialTransaction.ProfitCenter AS ProfitCenter,
  FiancialTransaction.WBSElementInternalID AS WBSElementInternalID,
  FiancialTransaction.TreasuryFacilityCompanyCode AS TreasuryFacilityCompanyCode,
  FiancialTransaction.TreasuryFacility AS TreasuryFacility,
  FiancialTransaction.FinancialInstrumentStatus AS FinancialInstrumentStatus,
  FiancialTransaction.FinTransReleaseStatus AS FinTransReleaseStatus,
  FiancialTransaction.TransactionCurrency AS TransactionCurrency,
  FiancialTransaction.FinInstrumentOutgoingCurrency AS FinInstrumentOutgoingCurrency,
  FiancialTransaction.FinInstrumentIncomingCurrency AS FinInstrumentIncomingCurrency,
  FiancialTransaction.TradedCurrency AS TradedCurrency,
  FiancialTransaction.SecurityClass AS SecurityClass,
  FiancialTransaction.ClassificationOfFinInstr AS ClassificationOfFinInstr,
  FiancialTransaction.SecurityAccount AS SecurityAccount,
  FiancialTransaction.FinTransIsRiskMitigating AS FinTransIsRiskMitigating,
  FiancialTransaction.FinInstrLastActiveActivity AS FinInstrLastActiveActivity,
  FiancialTransaction.TrsyTradedAmountBuySellCode AS TrsyTradedAmountBuySellCode,
  FiancialTransaction.Segment AS Segment,
  FiancialTransaction.OnBehalfOfCompany AS OnBehalfOfCompany,
  FiancialTransaction.MarketIdentifierCode AS MarketIdentifierCode,
  FiancialTransaction.FinTransRoundingCategory AS FinTransRoundingCategory,
  FiancialTransaction.FinTransGeneralValuationClass AS FinTransGeneralValuationClass,
  FiancialTransaction.Fund AS Fund,
  FiancialTransaction.GrantID AS GrantID,
  FiancialTransaction.FinTransAuthorizationGroup AS FinTransAuthorizationGroup,
  FiancialTransaction.BusinessPlace AS BusinessPlace,
  FiancialTransaction.FunctionalArea AS FunctionalArea,
  FiancialTransaction.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  FiancialTransaction.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  FiancialTransaction.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  FiancialTransaction.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  FiancialTransaction.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  FiancialTransaction.UniqueProductIdentifier AS UniqueProductIdentifier,
  FiancialTransaction.InternationalSecuritiesIdnNmbr AS InternationalSecuritiesIdnNmbr,
  FiancialTransaction.ReportTrackingNumber AS ReportTrackingNumber,
  FiancialTransaction.FinTransOptionNumber AS FinTransOptionNumber,
  CurrentActivity.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
  CurrentActivity.TermEndDate AS TermEndDate,
  CurrentActivity.FinTransTermCategory AS FinTransTermCategory,
  CurrentActivity.FinTransTermStartEndInclusive AS FinTransTermStartEndInclusive,
  CurrentActivity.FinTransNoticeDate AS FinTransNoticeDate,
  CurrentActivity.FinTransActyConclusionDate AS FinTransActyConclusionDate,
  CurrentActivity.FinTransActyConclusionTime AS FinTransActyConclusionTime,
  CurrentActivity.FinTransActyConclusionTimeZone AS FinTransActyConclusionTimeZone,
  CurrentActivity.FinTransRolloverDate AS FinTransRolloverDate,
  CurrentActivity.FinTransExerciseDate AS FinTransExerciseDate,
  CurrentActivity.FinTransOrderValidityEndDate AS FinTransOrderValidityEndDate,
  CurrentActivity.FinTransFixingDate AS FinTransFixingDate,
  CurrentActivity.ForeignExchangeFixingReference AS ForeignExchangeFixingReference,
  CurrentActivity.Trader AS Trader,
  CurrentActivity.FinancialInstrContactPerson AS FinancialInstrContactPerson,
  CurrentActivity.FinInstrExternalReference AS FinInstrExternalReference,
  CurrentActivity.TreasuryReversalReason AS TreasuryReversalReason,
  CurrentActivity.LeadingCurrency AS LeadingCurrency,
  CurrentActivity.FollowingCurrency AS FollowingCurrency,
  CurrentActivity.ExchangeRate AS ExchangeRate,
  CurrentActivity.SpotExchangeRate AS SpotExchangeRate,
  CurrentActivity.SwapExchangeRate AS SwapExchangeRate,
  CurrentActivity.LiquidityEffectValue AS LiquidityEffectValue,
  CurrentActivity.CurrencyPair AS CurrencyPair,
  CurrentActivity.EffectiveInterestRate AS EffectiveInterestRate,
  CurrentActivity.EffectiveInterestMethod AS EffectiveInterestMethod,
  CurrentActivity.LetterOfCredit AS LetterOfCredit,
  CurrentActivity.TreasuryApplicant AS TreasuryApplicant,
  CurrentActivity.TreasuryBeneficiary AS TreasuryBeneficiary,
  CurrentActivity.TrsyMnllyEnteredBnfcyName AS TrsyMnllyEnteredBnfcyName,
  CurrentActivity.TrsyMnllyEnteredApplcntName AS TrsyMnllyEnteredApplcntName,
  CurrentActivity.TreasuryAdvisingBank AS TreasuryAdvisingBank,
  CurrentActivity.TreasuryIssuingBank AS TreasuryIssuingBank,
  CurrentActivity.BankGuaranteeNumber AS BankGuaranteeNumber,
  CurrentActivity.BankGuaranteeType AS BankGuaranteeType
FROM I_FinancialTransaction AS FiancialTransaction
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_TreasuryContractType AS _ContractType ON TreasuryContractType = _ContractType.TreasuryContractType  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrProdCat AS _FinancialInstrProdCat ON FinancialInstrProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _FinancialInstrProdType ON FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_FinInstrTransCat AS _FinInstrTransCat ON FinancialInstrProductCategory = _FinInstrTransCat.FinancialInstrProductCategory AND FinInstrTransactionCategory = _FinInstrTransCat.FinInstrTransactionCategory  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrTransType AS _FinancialInstrTransType ON FinancialInstrTransactionType = _FinancialInstrTransType.FinancialInstrTransactionType AND FinancialInstrumentProductType = _FinancialInstrTransType.FinancialInstrumentProductType  -- association [1..1]
LEFT OUTER JOIN I_FinTransNoticePeriodUnit AS _NoticePeriodUnit ON FinTransNoticePeriodUnit = _NoticePeriodUnit.FinTransNoticePeriodUnit  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar ON FinTransFactoryCalendar1 = _Calendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar2 ON FinTransFactoryCalendar2 = _Calendar2.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Counterparty ON Counterparty = _Counterparty.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _Guarantor ON FinancialInstrumentGuarantor = _Guarantor.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPortfolio AS _Portfolio ON CompanyCode = _Portfolio.CompanyCode AND Portfolio = _Portfolio.Portfolio  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON controllingarea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON controllingarea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON controllingarea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_FinancialInstrAssignment AS _Assignment ON FinancialInstrumentAssignment = _Assignment.FinancialInstrumentAssignment  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrReference AS _Reference ON FinancialInstrumentReference = _Reference.FinancialInstrumentReference  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrCharacteristic AS _Characteristics ON FinancialInstrCharacteristic = _Characteristics.FinancialInstrCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_Financialinstrvaluationclass AS _GeneralValuationClass ON FinTransGeneralValuationClass = _GeneralValuationClass.FinancialInstrValuationClass  -- association [0..1]
LEFT OUTER JOIN I_TreasuryHedgingClassfctn AS _TreasuryHedgingClassfctn ON HedgingClassification = _TreasuryHedgingClassfctn.HedgingClassification  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _FacilityCompanyCode ON TreasuryFacilityCompanyCode = _FacilityCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinInstrumentStatus AS _Status ON FinancialInstrumentStatus = _Status.FinancialInstrumentStatus  -- association [0..1]
LEFT OUTER JOIN I_FinTransReleaseStatus AS _ReleaseStatus ON FinTransReleaseStatus = _ReleaseStatus.FinTransReleaseStatus  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _OutgoingCurrency ON FinInstrumentOutgoingCurrency = _OutgoingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _IncomingCurrency ON FinInstrumentIncomingCurrency = _IncomingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TradedCurrency ON TradedCurrency = _TradedCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SecurityClass AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON SecurityAccount = _SecurityAccount.SecurityAccount AND CompanyCode = _SecurityAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON FinTransActyConclusionTimeZone = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_FXFixingReference AS _FixingReference ON ForeignExchangeFixingReference = _FixingReference.ForeignExchangeFixingReference  -- association [0..1]
LEFT OUTER JOIN I_TreasuryReversalReason AS _ReversalReason ON TreasuryReversalReason = _ReversalReason.TreasuryReversalReason  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _LeadingCurrency ON LeadingCurrency = _LeadingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FollowingCurrency ON FollowingCurrency = _FollowingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Applicant ON TreasuryApplicant = _Applicant.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Beneficiary ON TreasuryBeneficiary = _Beneficiary.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _AdvisingBank ON TreasuryAdvisingBank = _AdvisingBank.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _IssuingBank ON TreasuryIssuingBank = _IssuingBank.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_FinInstrActivityCategory AS _ActivityCategory ON FinancialInstrProductCategory = _ActivityCategory.FinancialInstrProductCategory AND FinInstrTransactionCategory = _ActivityCategory.FinInstrTransactionCategory AND FinancialInstrActivityCategory = _ActivityCategory.FinancialInstrActivityCategory  -- association [0..1]
;

Depth:

I_FinancialTransactionDEX view_entity

I_FinancialTransaction view