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
  cast( Flow.RepetitiveCode as rpcode ) AS RepetitiveCode,
  cast( Flow.RepetitiveCode as farp_repetitive_code ) AS PaymentRepetitiveCode,
  cast(Flow.PremiumPriceQuotedInPercent as tb_pwkurs) AS FinTransPaytRateInPercent,
  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.FinTransFlowInLoclCrcyPaytAmt AS FinTransFlowInLoclCrcyPaytAmt,
  Flow.FinTransFlowLoclCrcyCnvrsnRate AS FinTransFlowLoclCrcyCnvrsnRate,
  Flow.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  Flow.FinTransFlowPaymentDueDate AS FinTransFlowPaymentDueDate,
  Flow.FinTransFlowPostingDate AS FinTransFlowPostingDate,
  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.FinInterestRateAdjmtStatus AS FinInterestRateAdjmtStatus,
  Flow.HouseBank AS HouseBank,
  Flow.HouseBankAccount AS HouseBankAccount,
  Flow.PayerPayee AS PayerPayee,
  Flow.PayerPayeeBankDetail AS PayerPayeeBankDetail,
  Flow.PaymentMethod AS PaymentMethod,
  Flow.PaymentMethodsList AS PaymentMethodsList,
  Flow.PaymentMethodSupplement AS PaymentMethodSupplement,
  Flow.TreasuryIndividualPayment AS TreasuryIndividualPayment,
  Flow.TrsyPaytGroupingSameDrctnIsRqd AS TrsyPaytGroupingSameDrctnIsRqd,
  Flow.TreasuryPaymentRequestGrouping AS TreasuryPaymentRequestGrouping,
  Flow.TreasuryIntGrpgForPaytValue AS TreasuryIntGrpgForPaytValue,
  Flow.PaymentRequest AS PaymentRequest,
  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,
  Flow.PaymentReason AS PaymentReason,
  Flow_Unfixed.LocalCurrency AS LocalCurrency,
  Flow_Unfixed.Country AS Country
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 _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_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]
-- UNION ALL with additional select branch(es): R_FinTransCashFlowActivity
;