I_FinTransFlow

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_FinTransFlow.
-- 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: IFINTRANSFLOW

CREATE VIEW I_FinTransFlow AS
SELECT
  Flow.CompanyCode AS CompanyCode,
  Flow.FinancialTransaction AS FinancialTransaction,
  Flow.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  Flow.FinTransFlowCreationDate AS FinTransFlowCreationDate,
  Flow.FinTransFlowCreationTime AS FinTransFlowCreationTime,
  Flow.FinTransFlowNumber AS FinTransFlowNumber,
  Flow.TreasuryContractType AS TreasuryContractType,
  Flow.FinTransFlowCategory AS FinTransFlowCategory,
  Flow.FinTransFlowType AS FinTransFlowType,
  Flow.FinTransFlowPaytAmt AS FinTransFlowPaytAmt,
  Flow.FinTransFlowPaytAmtCrcy AS FinTransFlowPaytAmtCrcy,
  Flow.FinTransFlowPaytAmtDirection AS FinTransFlowPaytAmtDirection,
  Flow.FinTransFlowNomAmt AS FinTransFlowNomAmt,
  Flow.FinTransFlowNomAmtCrcy AS FinTransFlowNomAmtCrcy,
  Flow.FinTransFlowPositionAmount AS FinTransFlowPositionAmount,
  Flow.FinTransFlwPosAmtCrcy AS FinTransFlwPosAmtCrcy,
  Flow.FinTransFlowInLoclCrcyPaytAmt AS FinTransFlowInLoclCrcyPaytAmt,
  _CompanyCode.Currency AS LocalCurrency,
  Flow.FinTransFlowLoclCrcyCnvrsnRate AS FinTransFlowLoclCrcyCnvrsnRate,
  Flow.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  Flow.FinTransFlowPaymentDueDate AS FinTransFlowPaymentDueDate,
  Flow.FinTransFlowIntrstRateFixDate AS FinTransFlowIntrstRateFixDate,
  Flow.CalculationPeriodStartDate AS CalculationPeriodStartDate,
  Flow.CalcPeriodStartDateIsMonthEnd AS CalcPeriodStartDateIsMonthEnd,
  Flow.CalculationPeriodEndDate AS CalculationPeriodEndDate,
  Flow.CalcPeriodEndDateIsMonthEnd AS CalcPeriodEndDateIsMonthEnd,
  Flow.NumberOfCalculationDays AS NumberOfCalculationDays,
  Flow.InterestCalculationMethod AS InterestCalculationMethod,
  Flow.FinTransFlowCalcBaseAmount AS FinTransFlowCalcBaseAmount,
  Flow.FinTransFlowCalcBaseAmountCrcy AS FinTransFlowCalcBaseAmountCrcy,
  Flow.ConditionPercentageRate AS ConditionPercentageRate,
  Flow.FinTransPresentationItemID AS FinTransPresentationItemID,
  Flow.FinTransFlowPostingStatus AS FinTransFlowPostingStatus,
  Flow.FinTransFlowPostingBlkgReason AS FinTransFlowPostingBlkgReason,
  Flow.FinTransFlowPostingRelease AS FinTransFlowPostingRelease,
  Flow.FinTransFlowFixingStatus AS FinTransFlowFixingStatus,
  Flow.FinTransFlowFixingBlkgReason AS FinTransFlowFixingBlkgReason,
  Flow.FinTransFlowIsFixingReleased AS FinTransFlowIsFixingReleased,
  Flow.FinInterestRateAdjmtStatus AS FinInterestRateAdjmtStatus,
  cast( Flow.RepetitiveCode as rpcode ) AS RepetitiveCode,
  cast( Flow.RepetitiveCode as farp_repetitive_code ) AS PaymentRepetitiveCode,
  Flow.HouseBank AS HouseBank,
  Flow.HouseBankAccount AS HouseBankAccount,
  Flow.PayerPayee AS PayerPayee,
  Flow.PayerPayeeBankDetail AS PayerPayeeBankDetail,
  _CompanyCode.Country AS Country,
  Flow.PaymentMethod AS PaymentMethod,
  Flow.PaymentMethodsList AS PaymentMethodsList,
  Flow.PaymentMethodSupplement AS PaymentMethodSupplement,
  Flow.TreasuryIndividualPayment AS TreasuryIndividualPayment,
  Flow.TreasuryPaymentIsIndividual AS TreasuryPaymentIsIndividual,
  Flow.TrsyPaytGroupingSameDrctnIsRqd AS TrsyPaytGroupingSameDrctnIsRqd,
  Flow.TreasuryPaymentRequestGrouping AS TreasuryPaymentRequestGrouping,
  Flow.TreasuryIntGrpgForPaytValue AS TreasuryIntGrpgForPaytValue,
  Flow.FinancialTransactionDirection AS FinancialTransactionDirection,
  Flow.FinInstrConditionLogicGroup AS FinInstrConditionLogicGroup,
  Flow.AssignmentReference AS AssignmentReference,
  Flow.FinTransFlwLoclCrcyAmtCalcType AS FinTransFlwLoclCrcyAmtCalcType,
  Flow.FinTransFlowCalculationDate AS FinTransFlowCalculationDate,
  Flow.FlowCalcDateIsExclusive AS FlowCalcDateIsExclusive,
  Flow.FlowCalcDateIsMonthEnd AS FlowCalcDateIsMonthEnd,
  Flow.IntrstCalcMethFactoryCalendar AS IntrstCalcMethFactoryCalendar,
  Flow.InterestCalculationType AS InterestCalculationType,
  Flow.CalcPeriodStartDateIsInclusive AS CalcPeriodStartDateIsInclusive,
  Flow.CalcPeriodEndDateIsInclusive AS CalcPeriodEndDateIsInclusive,
  Flow.FinTransFlwDerivationProcedure AS FinTransFlwDerivationProcedure,
  cast(Flow.PremiumPriceQuotedInPercent as tb_pwkurs) AS FinTransPaytRateInPercent,
  Flow.PaymentReason AS PaymentReason,
  Flow.FinTransFlowCreatedByUser AS FinTransFlowCreatedByUser,
  Flow.FinTransFlowLastChangedByUser AS FinTransFlowLastChangedByUser,
  Flow.FinTransFlowLastChangeDate AS FinTransFlowLastChangeDate,
  Flow.FinTransFlowLastChangeTime AS FinTransFlowLastChangeTime,
  Flow.FinTransFlwAltvPaytDetIsStated AS FinTransFlwAltvPaytDetIsStated,
  Flow.TrsyPaytIsPostdToGLAccount AS TrsyPaytIsPostdToGLAccount,
  Flow.TrsyPaytRequestIsGenerated AS TrsyPaytRequestIsGenerated,
  Flow.FinTransFlowIsReversed AS FinTransFlowIsReversed,
  Flow.NrOfBaseDaysPerCalcPeriod AS NrOfBaseDaysPerCalcPeriod,
  Flow.FinTransFlowReferencedFlowType AS FinTransFlowReferencedFlowType,
  Flow.FinTransFlowPriceIndexValue AS FinTransFlowPriceIndexValue,
  Flow.RepetitiveCodeReferenceText AS RepetitiveCodeReferenceText,
  Flow.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  Flow.TrsyPaymentSupplyingCountry AS TrsyPaymentSupplyingCountry,
  Flow.PaymentWithAccruedIntrstAmount AS PaymentWithAccruedIntrstAmount,
  Flow.FinTransFlwDerivdFlwGrpgTerm AS FinTransFlwDerivdFlwGrpgTerm,
  Flow.FXRateAdjustmentFixingDate AS FXRateAdjustmentFixingDate,
  Flow.FXRateAdjustmentStatus AS FXRateAdjustmentStatus,
  Flow.FinTransFlowFXRateReadDate AS FinTransFlowFXRateReadDate,
  Flow.PrcIdxAdjmtFixingLowDate AS PrcIdxAdjmtFixingLowDate,
  Flow.FinTransFlowPrcIdxReadLowDate AS FinTransFlowPrcIdxReadLowDate,
  Flow.PrcIdxAdjmtFixingHighDate AS PrcIdxAdjmtFixingHighDate,
  Flow.FinTransFlowPrcIdxReadHighDate AS FinTransFlowPrcIdxReadHighDate,
  Flow.PrcIdxAdjustmentStatus AS PrcIdxAdjustmentStatus,
  Flow.FinTransFlowIndexCleanAmount AS FinTransFlowIndexCleanAmount,
  Flow.FinTransFlowPaytRsnIsChgd AS FinTransFlowPaytRsnIsChgd,
  Flow.FinCndnCrsRefcdAccmlnCndnGrp AS FinCndnCrsRefcdAccmlnCndnGrp,
  Flow.FinTransFlwReltdAccumulatingID AS FinTransFlwReltdAccumulatingID,
  Flow.FinTransFlowAccumulatingFlowID AS FinTransFlowAccumulatingFlowID,
  Flow.FinTransFlowModificationStatus AS FinTransFlowModificationStatus,
  Flow.TrsyTransacMgmtBizTransaction AS TrsyTransacMgmtBizTransaction,
  Flow.PaymentRequest AS PaymentRequest,
  Flow.FinTransFlowPostingDate AS FinTransFlowPostingDate
FROM R_FinTransCashFlowActivity AS Activity
INNER JOIN R_FinTransFlow AS Flow ON /* join condition not captured in parsed metadata */
INNER JOIN R_FinTransUnfixedFlow AS Flow_Unfixed ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinTrans ON CompanyCode = _FinTrans.CompanyCode AND FinancialTransaction = _FinTrans.FinancialTransaction  -- association [0..1]
LEFT OUTER JOIN I_FinTransActivity AS _Activity ON CompanyCode = _Activity.CompanyCode AND FinancialTransaction = _Activity.FinancialTransaction AND FinancialInstrumentActivity = _Activity.FinancialInstrumentActivity  -- association [0..1]
LEFT OUTER JOIN I_TreasuryContractType AS _ContractType ON TreasuryContractType = _ContractType.TreasuryContractType  -- association [0..1]
LEFT OUTER JOIN I_FinTransFlowCategory AS _FlowCategory ON FinTransFlowCategory = _FlowCategory.FinTransFlowCategory  -- association [0..1]
LEFT OUTER JOIN I_FinTransFlowType AS _FlowType ON TreasuryContractType = _FlowType.TreasuryContractType AND FinTransFlowType = _FlowType.FinTransFlowType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON FinTransFlowPaytAmtCrcy = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _NominalCurrency ON FinTransFlowNomAmtCrcy = _NominalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PositionCurrency ON FinTransFlwPosAmtCrcy = _PositionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _LocalCurrency ON LocalCurrency = _LocalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BaseAmtCurrency ON FinTransFlowCalcBaseAmountCrcy = _BaseAmtCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FinTransFlowPostgStatus AS _PostingStatus ON FinTransFlowPostingStatus = _PostingStatus.FinTransFlowPostingStatus  -- association [0..1]
LEFT OUTER JOIN I_FinTransFlowPostgBlkgRsn AS _PostingBlkgRsn ON FinTransFlowPostingBlkgReason = _PostingBlkgRsn.FinTransFlowPostingBlkgReason  -- association [0..1]
LEFT OUTER JOIN I_FinTransFlowFixingStatus AS _FixingStatus ON FinTransFlowFixingStatus = _FixingStatus.FinTransFlowFixingStatus  -- association [0..1]
LEFT OUTER JOIN I_FinTransFlowFixingBlkgRsn AS _FixingBlkgRsn ON FinTransFlowFixingBlkgReason = _FixingBlkgRsn.FinTransFlowFixingBlkgReason  -- association [0..1]
LEFT OUTER JOIN I_FinIntrstRateAdjmtStatus AS _AdjmtStatus ON FinInterestRateAdjmtStatus = _AdjmtStatus.FinInterestRateAdjmtStatus  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _PayerPayee ON PayerPayee = _PayerPayee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND Country = _PaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_Paymentmethodsupplement AS _PaymentMethodSupp ON PaymentMethodSupplement = _PaymentMethodSupp.PaymentMethodSupplement  -- association [0..1]
LEFT OUTER JOIN I_PaymentRequest AS _PaymentRequest ON PaymentRequest = _PaymentRequest.PaymentRequest  -- association [0..1]
LEFT OUTER JOIN I_FinTransactionDirection AS _Direction ON FinancialTransactionDirection = _Direction.FinancialTransactionDirection  -- association [0..1]
LEFT OUTER JOIN I_FinTransFlowAcctgPaytInfo AS _FlowAcctgPaytInfo ON TrsyTransacMgmtBizTransaction = _FlowAcctgPaytInfo.TrsyTransacMgmtBizTransaction  -- association [1..1]
-- UNION ALL with additional select branch(es): R_FinTransCashFlowActivity
;