I_FinancialTransactionManage

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_FinancialTransactionManage.
-- 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: IFINTRSMANAGE
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW I_FinancialTransactionManage AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinTransWithCompanyCode,
  CreatedByUser,
  FinTransCreationDate,
  FinTransCreationTime,
  LastChangedByUser,
  LastChangeDate,
  FinInstrumentLastChangedTime,
  TreasuryContractType,
  FinancialInstrProductCategory,
  FinancialInstrumentProductType,
  TradeFinanceCategory,
  TreasurySettlementType,
  FinInstrTransactionCategory,
  FinancialInstrTransactionType,
  FinInstrLastActiveActivity,
  FinTransGenActivityCategory,
  FinancialInstrActivityCategory,
  FinancialTransaction.Counterparty AS Counterparty,
  Portfolio,
  FinancialInstrumentAssignment,
  FinancialInstrumentReference,
  FinancialInstrCharacteristic,
  TreasuryValuationClass,
  HedgingClassification,
  HedgeRequestIdentifier,
  ProfitCenter,
  CostCenter,
  WBSElementInternalID,
  Segment,
  OnBehalfOfCompany,
  TreasuryFacilityCompanyCode,
  TreasuryFacility,
  FinancialInstrumentStatus,
  FinTransIsRiskMitigating,
  TermStartDate,
  FinTransActyConclusionDate,
  Trader,
  FinInstrExternalReference,
  TermEndDate,
  TreasuryFinanceProject,
  TransactionCurrency,
  AmountInTransactionCurrency,
  FinTransFlowNomAmt,
  FinTransFlowNomAmtCrcy,
  FinInstrOutgoingNominalAmount,
  FinInstrumentOutgoingCurrency,
  FinInstrIncomingNominalAmount,
  FinInstrumentIncomingCurrency,
  FinTransFlowPaytAmt,
  FinTransFlowPaytAmtCrcy,
  FinConditionInterestCategory,
  InterestCalculationMethod,
  ConditionPercentageRate,
  InterestReference,
  FinCndnUpperLimitPctgRate,
  FinCndnLowerLimitPctgRate,
  FinInstrOutgCndnIntrstCategory,
  FinInstrOutgCndnPctgRate,
  FinInstrOutgIntrstReference,
  FinInstrOutgIntrstCalcMeth,
  FinInstrIncgCndnIntrstCategory,
  FinInstrIncgIntrstCalcMeth,
  FinInstrIncgCndnPctgRate,
  FinInstrIncgIntrstReference,
  InterestMarkupMarkdownValue,
  OutgIntrstMarkupMarkdownVal,
  IncgIntrstMarkupMarkdownVal,
  FwdRateAgrmtLeadTmeStrtDte,
  FwdRateAgrmtHdgPerdStrtDte,
  FwdRateAgrmtHdgPerdEndDte,
  LetterOfCredit,
  TreasuryBeneficiary,
  TreasuryAdvisingBank,
  TreasuryApplicant,
  TreasuryIssuingBank,
  BankGuaranteeNumber,
  BankGuaranteeType,
  SecurityClass,
  SecurityAccount,
  FinTransFlowPaymentDate,
  CalculationDate,
  FinTransPositionValueDate,
  FinTransTradedPricePercent,
  FinTransTradedNumberOfUnits,
  FinTransTrdPriceCrcyUnitRate,
  FinTransTradedPriceCrcyUnit,
  SecurityExchange,
  MarketValueInQtanCurrency,
  QuotationCurrency,
  TrsyTradedAmountBuySellCode,
  FinTransFixingDate,
  ForeignExchangeFixingReference,
  ExchangeRate,
  SpotExchangeRate,
  SwapExchangeRate,
  LiquidityEffectValue,
  AmountInTradedCurrency,
  TradedCurrency,
  FXOppositeAmount,
  FXOppositeCurrency,
  CurrencyPair,
  CashSettlementAmount,
  CashSettlementCurrency,
  CashSettlementPaymentDate,
  OptionExpirationDate,
  OptionExerciseType,
  OptionSettlementType,
  OptionPutCallCode,
  OptionUndrlgFXStrikeRate,
  ForeignExchangeValueDate,
  OptionUnderlyingProductType,
  OptionUndrlgTransactionType,
  FinTransExerciseDate,
  PremiumPriceQuotedInPercent,
  PremiumPriceQuotedInPointsRate,
  OptionPremiumNotation,
  FinTransPremiumAmount,
  FinTransPremiumAmountCurrency,
  FinTransPremiumPaymentDate,
  OptionUnderlyingTermStartDate,
  OptionUnderlyingTermEndDate,
  FinancialTransactionFromExer,
  TotalAmountInTransactionCrcy,
  CreditLineCurrency,
  FinTransReferenceCategory,
  FinTransReferenceNumber,
  FcltyTermEndExceededIsAllowed,
  ClassificationOfFinInstr,
  UniqueProductIdentifier,
  InternationalSecuritiesIdnNmbr,
  ReportTrackingNumber
FROM P_FinancialTransactionManage
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_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_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 _ValuationClass ON TreasuryValuationClass = _ValuationClass.FinancialInstrValuationClass  -- association [0..1]
LEFT OUTER JOIN I_TreasuryHedgingClassfctn AS _TreasuryHedgingClassfctn ON HedgingClassification = _TreasuryHedgingClassfctn.HedgingClassification  -- 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_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_FinTransContractActivity AS _ContractActivity ON CompanyCode = _ContractActivity.CompanyCode AND FinancialTransaction = _ContractActivity.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_FinTransActivity AS _CurrentActivity ON CompanyCode = _CurrentActivity.CompanyCode AND FinancialTransaction = _CurrentActivity.FinancialTransaction AND FinInstrLastActiveActivity = _CurrentActivity.FinancialInstrumentActivity  -- association [0..1]
LEFT OUTER JOIN I_LetterOfCredit AS _LetterOfCredit ON CompanyCode = _LetterOfCredit.CompanyCode AND FinancialTransaction = _LetterOfCredit.FinancialTransaction AND FinInstrLastActiveActivity = _LetterOfCredit.FinancialInstrumentActivity  -- association [0..1]
LEFT OUTER JOIN I_FinCndnInterestCategory AS _InterestCategory ON FinConditionInterestCategory = _InterestCategory.FinConditionInterestCategory  -- association [0..1]
LEFT OUTER JOIN I_FinCndnInterestCategory AS _OutgInterestCategory ON FinInstrOutgCndnIntrstCategory = _OutgInterestCategory.FinConditionInterestCategory  -- association [0..1]
LEFT OUTER JOIN I_FinCndnInterestCategory AS _IncgInterestCategory ON FinInstrIncgCndnIntrstCategory = _IncgInterestCategory.FinConditionInterestCategory  -- association [0..1]
LEFT OUTER JOIN I_ReferenceInterestRate AS _ReferenceInterestRate ON InterestReference = _ReferenceInterestRate.ReferenceInterestRate  -- association [0..1]
LEFT OUTER JOIN I_OptionExerciseType AS _OptionExerciseType ON OptionExerciseType = _OptionExerciseType.OptionExerciseType  -- association [1..1]
LEFT OUTER JOIN I_FinTransReferenceCategory AS _ReferenceCategory ON FinTransReferenceCategory = _ReferenceCategory.FinTransReferenceCategory  -- association [1..1]
LEFT OUTER JOIN I_FXTradingActivity AS _BuySell ON TrsyTradedAmountBuySellCode = _BuySell.ForeignExchangeTradingActivity  -- association [1..1]
LEFT OUTER JOIN I_FinInstrActivityCategory AS _FinInstrActivityCategory ON FinancialInstrProductCategory = _FinInstrActivityCategory.FinancialInstrProductCategory AND FinInstrTransactionCategory = _FinInstrActivityCategory.FinInstrTransactionCategory AND FinancialInstrActivityCategory = _FinInstrActivityCategory.FinancialInstrActivityCategory  -- association [0..1]
LEFT OUTER JOIN I_FinTransGenActyCategory AS _GenActivityCategory ON FinTransGenActivityCategory = _GenActivityCategory.FinTransGenActivityCategory  -- association [1..1]
LEFT OUTER JOIN I_BankGuaranteeType AS _BankGuaranteeType ON BankGuaranteeType = _BankGuaranteeType.BankGuaranteeType  -- association [1..1]
LEFT OUTER JOIN I_OptionPutCallCode AS _OptionPutCall ON OptionPutCallCode = _OptionPutCall.OptionPutCallCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _ApplicantBP ON TreasuryApplicant = _ApplicantBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BeneficiaryBP ON TreasuryBeneficiary = _BeneficiaryBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CounterpartyBP ON Counterparty = _CounterpartyBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BankGroup AS _AdvisingBank ON TreasuryAdvisingBank = _AdvisingBank.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BankGroup AS _IssuingBank ON TreasuryIssuingBank = _IssuingBank.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_FXFixingReference AS _FixingReference ON ForeignExchangeFixingReference = _FixingReference.ForeignExchangeFixingReference  -- association [1..1]
LEFT OUTER JOIN I_FinTransCurrencyPairVH AS _CurrencyPair ON CurrencyPair = _CurrencyPair.CurrencyPair  -- association [1..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _UnderlyingProdType ON OptionUnderlyingProductType = _UnderlyingProdType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrTransType AS _UnderlyingTransType ON OptionUndrlgTransactionType = _UnderlyingTransType.FinancialInstrTransactionType AND OptionUnderlyingProductType = _UnderlyingTransType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_OptionSettlementType AS _OptionSettlementType ON OptionSettlementType = _OptionSettlementType.OptionSettlementType  -- association [1..1]
LEFT OUTER JOIN I_InterestCalculationMethod AS _InterestCalcualationMethod ON InterestCalculationMethod = _InterestCalcualationMethod.InterestCalculationMethod  -- association [0..1]
LEFT OUTER JOIN I_InterestCalculationMethod AS _OutgInterestCalMethod ON FinInstrOutgIntrstCalcMeth = _OutgInterestCalMethod.InterestCalculationMethod  -- association [0..1]
LEFT OUTER JOIN I_InterestCalculationMethod AS _IncgInterestCalMethod ON FinInstrIncgIntrstCalcMeth = _IncgInterestCalMethod.InterestCalculationMethod  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_OptionPremiumNotation AS _OptionPremiumNotation ON OptionPremiumNotation = _OptionPremiumNotation.OptionPremiumNotation  -- association [0..1]
LEFT OUTER JOIN I_FacilityTermEndExceededAllwd AS _TermEndExceedAllowed ON FcltyTermEndExceededIsAllowed = _TermEndExceedAllowed.FcltyTermEndExceededIsAllowed  -- association [0..1]
LEFT OUTER JOIN I_TradeFinanceCategory AS _TradeFinanceCategory ON TradeFinanceCategory = _TradeFinanceCategory.TradeFinanceCategory  -- association [0..1]
LEFT OUTER JOIN I_OptionSettlementType AS _TreasurySettlementType ON TreasurySettlementType = _TreasurySettlementType.OptionSettlementType  -- association [0..1]
LEFT OUTER JOIN I_SecurityExchange AS _SecurityExchange ON SecurityExchange = _SecurityExchange.SecurityExchange  -- association [0..1]
;