R_FinTransUnfixedFlow

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_FinTransUnfixedFlow.
-- 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: RFINTRANSUNFFLOW

CREATE VIEW R_FinTransUnfixedFlow 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,
  cast( Flow.wzbetr as ftr_flow_norminal_amount_crcy preserving type ) AS FinTransFlowNomAmtCrcy,
  Flow.bhwbetr AS FinTransFlowInLoclCrcyPaytAmt,
  CompanyCode.Currency AS LocalCurrency,
  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 ) AS RepetitiveCode,
  Flow.rahabki AS HouseBank,
  Flow.rahktid AS HouseBankAccount,
  Flow.rpzahl AS PayerPayee,
  Flow.rpbank AS PayerPayeeBankDetail,
  Flow.zlsch AS PaymentMethod,
  CompanyCode.Country AS Country,
  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.zuonr AS AssignmentReference,
  Flow.skhwfix AS FinTransFlwLoclCrcyAmtCalcType,
  Flow.dvalut AS FinTransFlowCalculationDate,
  Flow.sincl AS FlowCalcDateIsExclusive,
  Flow.svult AS FlowCalcDateIsMonthEnd,
  Flow.skalidwt AS IntrstCalcMethFactoryCalendar,
  Flow.sexclvon AS CalcPeriodStartDateIsInclusive,
  Flow.sinclbis AS CalcPeriodEndDateIsInclusive,
  Flow.sabverf AS FinTransFlwDerivationProcedure,
  Flow.pwkurs AS FinTransPaytRateInPercent,
  Flow.payment_reason AS PaymentReason
FROM vtbfhapo_unfixed AS Flow
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
;