I_FinTransUndrlgTransaction

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_FinTransUndrlgTransaction.
-- 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.
-- SQL view name: IFINTRASUNDRLG

CREATE VIEW I_FinTransUndrlgTransaction AS
SELECT
  Underlying.bukrs AS CompanyCode,
  cast( Underlying.rfha as option_underlying_transaction preserving type ) AS OptionUnderlyingTransaction,
  Underlying.dblfz AS TermStartDate,
  Underlying.delfz AS TermEndDate,
  Underlying.wgschft1 AS FinInstrumentOutgoingCurrency,
  Underlying.wgschft2 AS FinInstrumentIncomingCurrency,
  Underlying.cruser AS CreatedByUser,
  cast( Underlying.dcrdat as ftr_creation_date preserving type ) AS FinTransCreationDate,
  Underlying.tcrtim AS FinTransCreationTime,
  Underlying.upuser AS LastChangedByUser,
  Underlying.dupdat AS LastChangeDate,
  Underlying.tuptim AS FinInstrumentLastChangedTime,
  Underlying.rantyp AS TreasuryContractType,
  Underlying.sanlf AS FinancialInstrProductCategory,
  Underlying.sfgtyp AS FinInstrTransactionCategory,
  Underlying.sgsart AS FinancialInstrumentProductType,
  Underlying.sfhaart AS FinancialInstrTransactionType,
  Underlying.rfhazul AS FinInstrLastActiveActivity,
  Underlying.saktiv AS FinancialInstrumentStatus,
  Underlying.kontrh AS Counterparty,
  Underlying.rportb AS Portfolio,
  Underlying.wgschft AS TransactionCurrency,
  cast( Underlying.skalid as ftr_factory_calendar1 preserving type ) AS FinTransFactoryCalendar1,
  cast( Underlying.skalid2 as ftr_factory_calendar2 preserving type ) AS FinTransFactoryCalendar2,
  Underlying.akuend AS FinTransNoticePeriod,
  Underlying.skuend AS FinTransNoticePeriodUnit,
  Underlying.objnr AS TreasuryFinancialObject,
  Underlying.rldepo AS SecurityAccount,
  Underlying.zuonr AS TreasuryFinanceProject,
  Underlying.abwtyp AS FinTransProcessingCategory,
  cast( case when Underlying.ranl is initial then Underlying.rgatt else Underlying.ranl end as vvranlw ) as SecurityClass AS ranlendasvvranlwasSecurityClass,
  Underlying.sinclbe AS TermStartDateIsInclusive,
  Underlying.rcomvalcl AS TreasuryValuationClass
FROM vtifha AS Underlying
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_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_FinInstrTransCat AS _FinInstrTransCat ON FinancialInstrProductCategory = _FinInstrTransCat.FinancialInstrProductCategory AND FinInstrTransactionCategory = _FinInstrTransCat.FinInstrTransactionCategory  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _UnderlyingProdType ON FinancialInstrumentProductType = _UnderlyingProdType.FinancialInstrumentProductType  -- 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_FinInstrumentStatus AS _Status ON FinancialInstrumentStatus = _Status.FinancialInstrumentStatus  -- association [0..1]
LEFT OUTER JOIN I_Ftr_Counterparty AS _Counterparty ON Counterparty = _Counterparty.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_TreasuryPortfolio AS _Portfolio ON CompanyCode = _Portfolio.CompanyCode AND Portfolio = _Portfolio.Portfolio  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FXTradingActivity AS _BuySell ON TrsyTradedAmountBuySellCode = _BuySell.ForeignExchangeTradingActivity  -- association [1..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON SecurityAccount = _SecurityAccount.SecurityAccount AND CompanyCode = _SecurityAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SecurityClass AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
LEFT OUTER JOIN I_Financialinstrvaluationclass AS _ValuationClass ON TreasuryValuationClass = _ValuationClass.FinancialInstrValuationClass  -- association [0..1]
;