R_FINTRANSFLOW

CDS View
96 Fields 4 CDS Views

Financial Transaction Flow

R_FINTRANSFLOW is a CDS View in S/4HANA. Financial Transaction Flow. It contains 96 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_FinTransFlow view inner COMPOSITE Financial Transaction Flow
I_FinTransInterest view inner COMPOSITE Fin Trans Interest Information
P_FinTransFlowWithOneDirection view inner COMPOSITE Flow with One Direction
P_FinTransFlowWithTwoDirection view inner COMPOSITE Flow with Two Direction

Fields (96)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 3
KEY FinancialInstrumentActivity FinancialInstrumentActivity 1
KEY FinancialTransaction FinancialTransaction 3
KEY FinancialTransactionDirection FinancialTransactionDirection 3
KEY FinTransFlowCreationDate FinTransFlowCreationDate 1
KEY FinTransFlowCreationTime FinTransFlowCreationTime 1
KEY FinTransFlowNumber FinTransFlowNumber 1
AssignmentReference AssignmentReference 1
CalcPeriodEndDateIsInclusive CalcPeriodEndDateIsInclusive 1
CalcPeriodEndDateIsMonthEnd CalcPeriodEndDateIsMonthEnd 1
CalcPeriodStartDateIsInclusive CalcPeriodStartDateIsInclusive 1
CalcPeriodStartDateIsMonthEnd CalcPeriodStartDateIsMonthEnd 1
CalculationPeriodEndDate CalculationPeriodEndDate 1
CalculationPeriodStartDate CalculationPeriodStartDate 1
ConditionPercentageRate ConditionPercentageRate 2
FinCndnCrsRefcdAccmlnCndnGrp FinCndnCrsRefcdAccmlnCndnGrp 1
FinInstrConditionLogicGroup FinInstrConditionLogicGroup 1
FinInterestRateAdjmtStatus FinInterestRateAdjmtStatus 2
FinTransFlowAccumulatingFlowID FinTransFlowAccumulatingFlowID 1
FinTransFlowCalcBaseAmount FinTransFlowCalcBaseAmount 1
FinTransFlowCalcBaseAmountCrcy FinTransFlowCalcBaseAmountCrcy 1
FinTransFlowCalculationDate FinTransFlowCalculationDate 1
FinTransFlowCategory FinTransFlowCategory 1
FinTransFlowCreatedByUser FinTransFlowCreatedByUser 1
FinTransFlowFixingBlkgReason FinTransFlowFixingBlkgReason 1
FinTransFlowFixingStatus FinTransFlowFixingStatus 1
FinTransFlowFXRateReadDate FinTransFlowFXRateReadDate 1
FinTransFlowIndexCleanAmount FinTransFlowIndexCleanAmount 1
FinTransFlowInLoclCrcyPaytAmt FinTransFlowInLoclCrcyPaytAmt 1
FinTransFlowIntrstRateFixDate FinTransFlowIntrstRateFixDate 2
FinTransFlowIsFixingReleased FinTransFlowIsFixingReleased 1
FinTransFlowIsReversed FinTransFlowIsReversed 1
FinTransFlowLastChangeDate FinTransFlowLastChangeDate 1
FinTransFlowLastChangedByUser FinTransFlowLastChangedByUser 1
FinTransFlowLastChangeTime FinTransFlowLastChangeTime 1
FinTransFlowLoclCrcyCnvrsnRate FinTransFlowLoclCrcyCnvrsnRate 1
FinTransFlowModificationStatus FinTransFlowModificationStatus 1
FinTransFlowNomAmt FinTransFlowNomAmt 1
FinTransFlowNomAmtCrcy FinTransFlowNomAmtCrcy 2
FinTransFlowPaymentDate FinTransFlowPaymentDate 2
FinTransFlowPaymentDueDate FinTransFlowPaymentDueDate 2
FinTransFlowPaytAmt FinTransFlowPaytAmt 2
FinTransFlowPaytAmtCrcy FinTransFlowPaytAmtCrcy 2
FinTransFlowPaytAmtDirection FinTransFlowPaytAmtDirection 2
FinTransFlowPaytRsnIsChgd FinTransFlowPaytRsnIsChgd 1
FinTransFlowPositionAmount FinTransFlowPositionAmount 1
FinTransFlowPostingBlkgReason FinTransFlowPostingBlkgReason 1
FinTransFlowPostingDate FinTransFlowPostingDate 1
FinTransFlowPostingRelease FinTransFlowPostingRelease 1
FinTransFlowPostingStatus FinTransFlowPostingStatus 1
FinTransFlowPrcIdxReadHighDate FinTransFlowPrcIdxReadHighDate 1
FinTransFlowPrcIdxReadLowDate FinTransFlowPrcIdxReadLowDate 1
FinTransFlowPriceIndexValue FinTransFlowPriceIndexValue 1
FinTransFlowReferencedFlowType FinTransFlowReferencedFlowType 1
FinTransFlowType FinTransFlowType 1
FinTransFlwAltvPaytDetIsStated FinTransFlwAltvPaytDetIsStated 1
FinTransFlwDerivationProcedure FinTransFlwDerivationProcedure 1
FinTransFlwDerivdFlwGrpgTerm FinTransFlwDerivdFlwGrpgTerm 1
FinTransFlwLoclCrcyAmtCalcType FinTransFlwLoclCrcyAmtCalcType 1
FinTransFlwPosAmtCrcy FinTransFlwPosAmtCrcy 1
FinTransFlwReltdAccumulatingID FinTransFlwReltdAccumulatingID 1
FinTransPresentationItemID FinTransPresentationItemID 1
FlowCalcDateIsExclusive FlowCalcDateIsExclusive 1
FlowCalcDateIsMonthEnd FlowCalcDateIsMonthEnd 1
FXRateAdjustmentFixingDate FXRateAdjustmentFixingDate 1
FXRateAdjustmentStatus FXRateAdjustmentStatus 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
InterestCalculationMethod InterestCalculationMethod 1
InterestCalculationType InterestCalculationType 1
IntrstCalcMethFactoryCalendar IntrstCalcMethFactoryCalendar 1
NrOfBaseDaysPerCalcPeriod NrOfBaseDaysPerCalcPeriod 1
NumberOfCalculationDays NumberOfCalculationDays 1
PayerPayee PayerPayee 1
PayerPayeeBankDetail PayerPayeeBankDetail 1
PaymentMethod PaymentMethod 1
PaymentMethodsList PaymentMethodsList 1
PaymentMethodSupplement PaymentMethodSupplement 1
PaymentReason PaymentReason 1
PaymentRequest PaymentRequest 1
PaymentWithAccruedIntrstAmount PaymentWithAccruedIntrstAmount 1
PrcIdxAdjmtFixingHighDate PrcIdxAdjmtFixingHighDate 1
PrcIdxAdjmtFixingLowDate PrcIdxAdjmtFixingLowDate 1
PrcIdxAdjustmentStatus PrcIdxAdjustmentStatus 1
RepetitiveCodeReferenceText RepetitiveCodeReferenceText 1
StateCentralBankPaymentReason StateCentralBankPaymentReason 1
TreasuryContractType TreasuryContractType 1
TreasuryIndividualPayment TreasuryIndividualPayment 1
TreasuryIntGrpgForPaytValue TreasuryIntGrpgForPaytValue 1
TreasuryPaymentIsIndividual TreasuryPaymentIsIndividual 1
TreasuryPaymentRequestGrouping TreasuryPaymentRequestGrouping 1
TrsyPaymentSupplyingCountry TrsyPaymentSupplyingCountry 1
TrsyPaytGroupingSameDrctnIsRqd TrsyPaytGroupingSameDrctnIsRqd 1
TrsyPaytIsPostdToGLAccount TrsyPaytIsPostdToGLAccount 1
TrsyPaytRequestIsGenerated TrsyPaytRequestIsGenerated 1
TrsyTransacMgmtBizTransaction TrsyTransacMgmtBizTransaction 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Financial Transaction Flow
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_FINTRANSFLOW (
    COMPANYCODE,
    FINANCIALINSTRUMENTACTIVITY,
    FINANCIALTRANSACTION,
    FINANCIALTRANSACTIONDIRECTION,
    FINTRANSFLOWCREATIONDATE,
    FINTRANSFLOWCREATIONTIME,
    FINTRANSFLOWNUMBER,
    ASSIGNMENTREFERENCE,
    CALCPERIODENDDATEISINCLUSIVE,
    CALCPERIODENDDATEISMONTHEND,
    CALCPERIODSTARTDATEISINCLUSIVE,
    CALCPERIODSTARTDATEISMONTHEND,
    CALCULATIONPERIODENDDATE,
    CALCULATIONPERIODSTARTDATE,
    CONDITIONPERCENTAGERATE,
    FINCNDNCRSREFCDACCMLNCNDNGRP,
    FININSTRCONDITIONLOGICGROUP,
    FININTERESTRATEADJMTSTATUS,
    FINTRANSFLOWACCUMULATINGFLOWID,
    FINTRANSFLOWCALCBASEAMOUNT,
    FINTRANSFLOWCALCBASEAMOUNTCRCY,
    FINTRANSFLOWCALCULATIONDATE,
    FINTRANSFLOWCATEGORY,
    FINTRANSFLOWCREATEDBYUSER,
    FINTRANSFLOWFIXINGBLKGREASON,
    FINTRANSFLOWFIXINGSTATUS,
    FINTRANSFLOWFXRATEREADDATE,
    FINTRANSFLOWINDEXCLEANAMOUNT,
    FINTRANSFLOWINLOCLCRCYPAYTAMT,
    FINTRANSFLOWINTRSTRATEFIXDATE,
    FINTRANSFLOWISFIXINGRELEASED,
    FINTRANSFLOWISREVERSED,
    FINTRANSFLOWLASTCHANGEDATE,
    FINTRANSFLOWLASTCHANGEDBYUSER,
    FINTRANSFLOWLASTCHANGETIME,
    FINTRANSFLOWLOCLCRCYCNVRSNRATE,
    FINTRANSFLOWMODIFICATIONSTATUS,
    FINTRANSFLOWNOMAMT,
    FINTRANSFLOWNOMAMTCRCY,
    FINTRANSFLOWPAYMENTDATE,
    FINTRANSFLOWPAYMENTDUEDATE,
    FINTRANSFLOWPAYTAMT,
    FINTRANSFLOWPAYTAMTCRCY,
    FINTRANSFLOWPAYTAMTDIRECTION,
    FINTRANSFLOWPAYTRSNISCHGD,
    FINTRANSFLOWPOSITIONAMOUNT,
    FINTRANSFLOWPOSTINGBLKGREASON,
    FINTRANSFLOWPOSTINGDATE,
    FINTRANSFLOWPOSTINGRELEASE,
    FINTRANSFLOWPOSTINGSTATUS,
    FINTRANSFLOWPRCIDXREADHIGHDATE,
    FINTRANSFLOWPRCIDXREADLOWDATE,
    FINTRANSFLOWPRICEINDEXVALUE,
    FINTRANSFLOWREFERENCEDFLOWTYPE,
    FINTRANSFLOWTYPE,
    FINTRANSFLWALTVPAYTDETISSTATED,
    FINTRANSFLWDERIVATIONPROCEDURE,
    FINTRANSFLWDERIVDFLWGRPGTERM,
    FINTRANSFLWLOCLCRCYAMTCALCTYPE,
    FINTRANSFLWPOSAMTCRCY,
    FINTRANSFLWRELTDACCUMULATINGID,
    FINTRANSPRESENTATIONITEMID,
    FLOWCALCDATEISEXCLUSIVE,
    FLOWCALCDATEISMONTHEND,
    FXRATEADJUSTMENTFIXINGDATE,
    FXRATEADJUSTMENTSTATUS,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERESTCALCULATIONMETHOD,
    INTERESTCALCULATIONTYPE,
    INTRSTCALCMETHFACTORYCALENDAR,
    NROFBASEDAYSPERCALCPERIOD,
    NUMBEROFCALCULATIONDAYS,
    PAYERPAYEE,
    PAYERPAYEEBANKDETAIL,
    PAYMENTMETHOD,
    PAYMENTMETHODSLIST,
    PAYMENTMETHODSUPPLEMENT,
    PAYMENTREASON,
    PAYMENTREQUEST,
    PAYMENTWITHACCRUEDINTRSTAMOUNT,
    PRCIDXADJMTFIXINGHIGHDATE,
    PRCIDXADJMTFIXINGLOWDATE,
    PRCIDXADJUSTMENTSTATUS,
    REPETITIVECODEREFERENCETEXT,
    STATECENTRALBANKPAYMENTREASON,
    TREASURYCONTRACTTYPE,
    TREASURYINDIVIDUALPAYMENT,
    TREASURYINTGRPGFORPAYTVALUE,
    TREASURYPAYMENTISINDIVIDUAL,
    TREASURYPAYMENTREQUESTGROUPING,
    TRSYPAYMENTSUPPLYINGCOUNTRY,
    TRSYPAYTGROUPINGSAMEDRCTNISRQD,
    TRSYPAYTISPOSTDTOGLACCOUNT,
    TRSYPAYTREQUESTISGENERATED,
    TRSYTRANSACMGMTBIZTRANSACTION,
    PRIMARY KEY (COMPANYCODE, FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION, FINANCIALTRANSACTIONDIRECTION, FINTRANSFLOWCREATIONDATE, FINTRANSFLOWCREATIONTIME, FINTRANSFLOWNUMBER)
);

Learn More