R_FINTRANSFLOW

CDS View
59 Fields 4 CDS Views

Financial Transaction Flow

R_FINTRANSFLOW is a CDS View in S/4HANA. Financial Transaction Flow. It contains 59 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
P_FinTransFlowWithTwoDirection view inner COMPOSITE

Fields (59)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY FinancialInstrumentActivity FinancialInstrumentActivity 1
KEY FinancialTransaction FinancialTransaction 4
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
FinInstrConditionLogicGroup FinInstrConditionLogicGroup 1
FinInterestRateAdjmtStatus FinInterestRateAdjmtStatus 2
FinTransFlowCalcBaseAmount FinTransFlowCalcBaseAmount 1
FinTransFlowCalcBaseAmountCrcy FinTransFlowCalcBaseAmountCrcy 1
FinTransFlowCalculationDate FinTransFlowCalculationDate 1
FinTransFlowCategory FinTransFlowCategory 1
FinTransFlowInLoclCrcyPaytAmt FinTransFlowInLoclCrcyPaytAmt 1
FinTransFlowIntrstRateFixDate FinTransFlowIntrstRateFixDate 2
FinTransFlowLoclCrcyCnvrsnRate FinTransFlowLoclCrcyCnvrsnRate 1
FinTransFlowNomAmt FinTransFlowNomAmt 2
FinTransFlowNomAmtCrcy FinTransFlowNomAmtCrcy 3
FinTransFlowPaymentDate FinTransFlowPaymentDate 2
FinTransFlowPaymentDueDate FinTransFlowPaymentDueDate 2
FinTransFlowPaytAmt FinTransFlowPaytAmt 3
FinTransFlowPaytAmtCrcy FinTransFlowPaytAmtCrcy 3
FinTransFlowPaytAmtDirection FinTransFlowPaytAmtDirection 3
FinTransFlowPostingBlkgReason FinTransFlowPostingBlkgReason 1
FinTransFlowPostingDate FinTransFlowPostingDate 1
FinTransFlowPostingRelease FinTransFlowPostingRelease 1
FinTransFlowPostingStatus FinTransFlowPostingStatus 1
FinTransFlowType FinTransFlowType 1
FinTransFlwDerivationProcedure FinTransFlwDerivationProcedure 1
FinTransFlwLoclCrcyAmtCalcType FinTransFlwLoclCrcyAmtCalcType 1
FinTransPresentationItemID FinTransPresentationItemID 1
FlowCalcDateIsExclusive FlowCalcDateIsExclusive 1
FlowCalcDateIsMonthEnd FlowCalcDateIsMonthEnd 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
InterestCalculationMethod InterestCalculationMethod 1
InterestCalculationType InterestCalculationType 1
IntrstCalcMethFactoryCalendar IntrstCalcMethFactoryCalendar 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
TreasuryContractType TreasuryContractType 1
TreasuryIndividualPayment TreasuryIndividualPayment 1
TreasuryIntGrpgForPaytValue TreasuryIntGrpgForPaytValue 1
TreasuryPaymentRequestGrouping TreasuryPaymentRequestGrouping 1
TrsyPaytGroupingSameDrctnIsRqd TrsyPaytGroupingSameDrctnIsRqd 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,
    FININSTRCONDITIONLOGICGROUP,
    FININTERESTRATEADJMTSTATUS,
    FINTRANSFLOWCALCBASEAMOUNT,
    FINTRANSFLOWCALCBASEAMOUNTCRCY,
    FINTRANSFLOWCALCULATIONDATE,
    FINTRANSFLOWCATEGORY,
    FINTRANSFLOWINLOCLCRCYPAYTAMT,
    FINTRANSFLOWINTRSTRATEFIXDATE,
    FINTRANSFLOWLOCLCRCYCNVRSNRATE,
    FINTRANSFLOWNOMAMT,
    FINTRANSFLOWNOMAMTCRCY,
    FINTRANSFLOWPAYMENTDATE,
    FINTRANSFLOWPAYMENTDUEDATE,
    FINTRANSFLOWPAYTAMT,
    FINTRANSFLOWPAYTAMTCRCY,
    FINTRANSFLOWPAYTAMTDIRECTION,
    FINTRANSFLOWPOSTINGBLKGREASON,
    FINTRANSFLOWPOSTINGDATE,
    FINTRANSFLOWPOSTINGRELEASE,
    FINTRANSFLOWPOSTINGSTATUS,
    FINTRANSFLOWTYPE,
    FINTRANSFLWDERIVATIONPROCEDURE,
    FINTRANSFLWLOCLCRCYAMTCALCTYPE,
    FINTRANSPRESENTATIONITEMID,
    FLOWCALCDATEISEXCLUSIVE,
    FLOWCALCDATEISMONTHEND,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERESTCALCULATIONMETHOD,
    INTERESTCALCULATIONTYPE,
    INTRSTCALCMETHFACTORYCALENDAR,
    NUMBEROFCALCULATIONDAYS,
    PAYERPAYEE,
    PAYERPAYEEBANKDETAIL,
    PAYMENTMETHOD,
    PAYMENTMETHODSLIST,
    PAYMENTMETHODSUPPLEMENT,
    PAYMENTREASON,
    PAYMENTREQUEST,
    TREASURYCONTRACTTYPE,
    TREASURYINDIVIDUALPAYMENT,
    TREASURYINTGRPGFORPAYTVALUE,
    TREASURYPAYMENTREQUESTGROUPING,
    TRSYPAYTGROUPINGSAMEDRCTNISRQD,
    PRIMARY KEY (COMPANYCODE, FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION, FINANCIALTRANSACTIONDIRECTION, FINTRANSFLOWCREATIONDATE, FINTRANSFLOWCREATIONTIME, FINTRANSFLOWNUMBER)
);

Learn More