R_FINTRANSUNFIXEDFLOW

CDS View
62 Fields 2 CDS Views

Financial Transaction Unfixed Flow

R_FINTRANSUNFIXEDFLOW is a CDS View in S/4HANA. Financial Transaction Unfixed Flow. It contains 62 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FinTransFlow view inner COMPOSITE Financial Transaction Flow
I_FinTransInterest view inner COMPOSITE Fin Trans Interest Information

Fields (62)

KeyField CDS FieldsUsed in Views
KEY FinancialInstrumentActivity FinancialInstrumentActivity 1
KEY FinancialTransaction FinancialTransaction 2
KEY FinancialTransactionDirection FinancialTransactionDirection 2
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
Country Country 1
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 1
FinTransFlowNomAmtCrcy FinTransFlowNomAmtCrcy 1
FinTransFlowPaymentDate FinTransFlowPaymentDate 2
FinTransFlowPaymentDueDate FinTransFlowPaymentDueDate 2
FinTransFlowPaytAmt FinTransFlowPaytAmt 2
FinTransFlowPaytAmtCrcy FinTransFlowPaytAmtCrcy 2
FinTransFlowPaytAmtDirection FinTransFlowPaytAmtDirection 1
FinTransFlowPostingBlkgReason FinTransFlowPostingBlkgReason 1
FinTransFlowPostingDate FinTransFlowPostingDate 1
FinTransFlowPostingRelease FinTransFlowPostingRelease 1
FinTransFlowPostingStatus FinTransFlowPostingStatus 1
FinTransFlowType FinTransFlowType 1
FinTransFlwDerivationProcedure FinTransFlwDerivationProcedure 1
FinTransFlwLoclCrcyAmtCalcType FinTransFlwLoclCrcyAmtCalcType 1
FinTransPaytRateInPercent FinTransPaytRateInPercent 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
LocalCurrency LocalCurrency 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
RepetitiveCode RepetitiveCode 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 Unfixed Flow
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_FINTRANSUNFIXEDFLOW (
    FINANCIALINSTRUMENTACTIVITY,
    FINANCIALTRANSACTION,
    FINANCIALTRANSACTIONDIRECTION,
    FINTRANSFLOWCREATIONDATE,
    FINTRANSFLOWCREATIONTIME,
    FINTRANSFLOWNUMBER,
    ASSIGNMENTREFERENCE,
    CALCPERIODENDDATEISINCLUSIVE,
    CALCPERIODENDDATEISMONTHEND,
    CALCPERIODSTARTDATEISINCLUSIVE,
    CALCPERIODSTARTDATEISMONTHEND,
    CALCULATIONPERIODENDDATE,
    CALCULATIONPERIODSTARTDATE,
    CONDITIONPERCENTAGERATE,
    COUNTRY,
    FININSTRCONDITIONLOGICGROUP,
    FININTERESTRATEADJMTSTATUS,
    FINTRANSFLOWCALCBASEAMOUNT,
    FINTRANSFLOWCALCBASEAMOUNTCRCY,
    FINTRANSFLOWCALCULATIONDATE,
    FINTRANSFLOWCATEGORY,
    FINTRANSFLOWINLOCLCRCYPAYTAMT,
    FINTRANSFLOWINTRSTRATEFIXDATE,
    FINTRANSFLOWLOCLCRCYCNVRSNRATE,
    FINTRANSFLOWNOMAMT,
    FINTRANSFLOWNOMAMTCRCY,
    FINTRANSFLOWPAYMENTDATE,
    FINTRANSFLOWPAYMENTDUEDATE,
    FINTRANSFLOWPAYTAMT,
    FINTRANSFLOWPAYTAMTCRCY,
    FINTRANSFLOWPAYTAMTDIRECTION,
    FINTRANSFLOWPOSTINGBLKGREASON,
    FINTRANSFLOWPOSTINGDATE,
    FINTRANSFLOWPOSTINGRELEASE,
    FINTRANSFLOWPOSTINGSTATUS,
    FINTRANSFLOWTYPE,
    FINTRANSFLWDERIVATIONPROCEDURE,
    FINTRANSFLWLOCLCRCYAMTCALCTYPE,
    FINTRANSPAYTRATEINPERCENT,
    FINTRANSPRESENTATIONITEMID,
    FLOWCALCDATEISEXCLUSIVE,
    FLOWCALCDATEISMONTHEND,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERESTCALCULATIONMETHOD,
    INTERESTCALCULATIONTYPE,
    INTRSTCALCMETHFACTORYCALENDAR,
    LOCALCURRENCY,
    NUMBEROFCALCULATIONDAYS,
    PAYERPAYEE,
    PAYERPAYEEBANKDETAIL,
    PAYMENTMETHOD,
    PAYMENTMETHODSLIST,
    PAYMENTMETHODSUPPLEMENT,
    PAYMENTREASON,
    PAYMENTREQUEST,
    REPETITIVECODE,
    TREASURYCONTRACTTYPE,
    TREASURYINDIVIDUALPAYMENT,
    TREASURYINTGRPGFORPAYTVALUE,
    TREASURYPAYMENTREQUESTGROUPING,
    TRSYPAYTGROUPINGSAMEDRCTNISRQD,
    PRIMARY KEY (FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION, FINANCIALTRANSACTIONDIRECTION, FINTRANSFLOWCREATIONDATE, FINTRANSFLOWCREATIONTIME, FINTRANSFLOWNUMBER)
);

Learn More