R_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 R_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: RFINTRANSFLOW

CREATE VIEW R_FinTransFlow AS
SELECT
  Flow.bukrs AS CompanyCode,
  Flow.rfha AS FinancialTransaction,
  Flow.rfhazu AS FinancialInstrumentActivity,
  Flow.dcrdat AS FinTransFlowCreationDate,
  cast( Flow.tcrtim as ftr_flow_creation_time preserving type ) AS FinTransFlowCreationTime,
  Flow.rfhazb AS FinTransFlowNumber,
  Flow.rantyp AS TreasuryContractType,
  cast( Flow.sbktyp as ftr_flow_category preserving type ) AS FinTransFlowCategory,
  Flow.sfhazba AS FinTransFlowType,
  cast( Flow.bzbetr as ftr_flow_payment_amount preserving type ) AS FinTransFlowPaytAmt,
  Flow.wzbetr AS FinTransFlowPaytAmtCrcy,
  cast( Flow.ssign as ftr_flow_payment_amt_direction preserving type ) AS FinTransFlowPaytAmtDirection,
  Flow.bhwbetr AS FinTransFlowInLoclCrcyPaytAmt,
  cast( Flow.khwkurs as ftr_flow_rate_in_locl_crcy preserving type ) AS FinTransFlowLoclCrcyCnvrsnRate,
  cast( Flow.dzterm as ftr_flow_payment_date preserving type ) AS FinTransFlowPaymentDate,
  Flow.dfaell AS FinTransFlowPaymentDueDate,
  cast( Flow.dbuchung as ftr_flow_posting_date preserving type ) AS FinTransFlowPostingDate,
  Flow.dzfest AS FinTransFlowIntrstRateFixDate,
  Flow.dbervon AS CalculationPeriodStartDate,
  Flow.sultvon AS CalcPeriodStartDateIsMonthEnd,
  Flow.dberbis AS CalculationPeriodEndDate,
  Flow.sultbis AS CalcPeriodEndDateIsMonthEnd,
  Flow.atage AS NumberOfCalculationDays,
  Flow.szbmeth AS InterestCalculationMethod,
  Flow.bbasis AS FinTransFlowCalcBaseAmount,
  Flow.wbasis AS FinTransFlowCalcBaseAmountCrcy,
  Flow.pkond AS ConditionPercentageRate,
  Flow.present_id AS FinTransPresentationItemID,
  Flow.sbewebe AS FinTransFlowPostingStatus,
  Flow.ssprgrd AS FinTransFlowPostingBlkgReason,
  Flow.sbfrei AS FinTransFlowPostingRelease,
  Flow.regi_state AS FinInterestRateAdjmtStatus,
  cast( Flow.rpcode as farp_repetitive_code preserving type ) AS RepetitiveCode,
  Flow.rahabki AS HouseBank,
  Flow.rahktid AS HouseBankAccount,
  Flow.rpzahl AS PayerPayee,
  Flow.rpbank AS PayerPayeeBankDetail,
  Flow.zlsch AS PaymentMethod,
  Flow.zwels AS PaymentMethodsList,
  Flow.uzawe AS PaymentMethodSupplement,
  Flow.sprsng AS TreasuryIndividualPayment,
  Flow.scspay AS TrsyPaytGroupingSameDrctnIsRqd,
  Flow.sprgrd AS TreasuryPaymentRequestGrouping,
  Flow.paygr AS TreasuryIntGrpgForPaytValue,
  Flow.prkey AS PaymentRequest,
  Flow.rkondgr AS FinancialTransactionDirection,
  cast( Flow.logic_rkond as ftr_instr_cndn_logic_group preserving type ) AS FinInstrConditionLogicGroup,
  Flow.dguel_kp AS ConditionItemValidityStartDate,
  Flow.rkond AS FinConditionItem,
  Flow.nstufe AS FinConditionSubItem,
  Flow.sherkunft AS FinTransFlowSource,
  cast( Flow.prkkurs as ftr_premium_price_in_points preserving type ) AS PremiumPriceQuotedInPointsRate,
  cast( Flow.pwkurs as ftr_premium_price_in_percent preserving type ) AS PremiumPriceQuotedInPercent,
  Flow.zuonr AS AssignmentReference,
  Flow.skhwfix AS FinTransFlwLoclCrcyAmtCalcType,
  Flow.dvalut AS FinTransFlowCalculationDate,
  cast( Flow.svult as tb_nomsvult preserving type ) AS FlowCalcDateIsMonthEnd,
  Flow.skalidwt AS IntrstCalcMethFactoryCalendar,
  Flow.sabverf AS FinTransFlwDerivationProcedure,
  Flow.payment_reason AS PaymentReason
FROM vtbfhapo AS Flow
;