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.bbbetr as ftr_position_amount preserving type ) AS FinTransFlowPositionAmount,
  Flow.wbbetr AS FinTransFlwPosAmtCrcy,
  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.sbewebe AS FinTransFlowFixingStatus,
  Flow.ssprgrd AS FinTransFlowFixingBlkgReason,
  Flow.sbfrei AS FinTransFlowIsFixingReleased,
  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.sprsng AS TreasuryPaymentIsIndividual,
  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.svult AS FlowCalcDateIsMonthEnd,
  Flow.skalidwt AS IntrstCalcMethFactoryCalendar,
  Flow.sabverf AS FinTransFlwDerivationProcedure,
  Flow.pwkurs AS FinTransPaytRateInPercent,
  Flow.payment_reason AS PaymentReason,
  cast( Flow.cruser as ftr_flow_cruser) AS FinTransFlowCreatedByUser,
  cast( Flow.upuser as ftr_flow_upuser) AS FinTransFlowLastChangedByUser,
  cast( Flow.dupdat as ftr_flow_dupdat) AS FinTransFlowLastChangeDate,
  cast( Flow.tuptim as ftr_flow_tuptim) AS FinTransFlowLastChangeTime,
  Flow.sbzvabw AS FinTransFlwAltvPaytDetIsStated,
  Flow.spayrq AS TrsyPaytRequestIsGenerated,
  Flow.sstornobwg AS FinTransFlowIsReversed,
  Flow.abastage AS NrOfBaseDaysPerCalcPeriod,
  Flow.sbwgartref AS FinTransFlowReferencedFlowType,
  Flow.index_value AS FinTransFlowPriceIndexValue,
  Flow.rp_text AS RepetitiveCodeReferenceText,
  Flow.lzbkz AS StateCentralBankPaymentReason,
  Flow.landl AS TrsyPaymentSupplyingCountry,
  cast( Flow.bdirty as ftr_payt_accrued_intrst_amount) AS PaymentWithAccruedIntrstAmount,
  Flow.grouping_term AS FinTransFlwDerivdFlwGrpgTerm,
  cast( Flow.fx_fixing_date as ftr_fixing_ref_date) AS FXRateAdjustmentFixingDate,
  Flow.fx_regi_state AS FXRateAdjustmentStatus,
  Flow.fx_read_date AS FinTransFlowFXRateReadDate,
  Flow.priceindex_fix_date_low AS PrcIdxAdjmtFixingLowDate,
  Flow.priceindex_read_date_low AS FinTransFlowPrcIdxReadLowDate,
  Flow.priceindex_fix_date_high AS PrcIdxAdjmtFixingHighDate,
  Flow.priceindex_read_date_high AS FinTransFlowPrcIdxReadHighDate,
  Flow.priceindex_regi_state AS PrcIdxAdjustmentStatus,
  Flow.bbbetr_idxclean AS FinTransFlowIndexCleanAmount,
  cast( case when Flow.payment_reason_changed = '1' then 'X' else '' end as ftr_payment_reason_is_chgd) AS FinTransFlowPaytRsnIsChgd,
  Flow.sum_rkond AS FinCndnCrsRefcdAccmlnCndnGrp,
  Flow.sum_id_source AS FinTransFlwReltdAccumulatingID,
  Flow.sum_id_sum AS FinTransFlowAccumulatingFlowID,
  Flow.saend AS FinTransFlowModificationStatus
FROM vtbfhapo_unfixed AS Flow
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
;