I_FINTRANSFLOW

CDS View
38 Fields 5 CDS Views

Financial Transaction Flow

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_FinTransAdditionalFlow view from COMPOSITE Financial Transaction Additional Flow
I_FinTransFeeFlow view from COMPOSITE Fin Trans Flows Relevant For Fee
I_FinTransMainFlow view from COMPOSITE Financial Transaction Main Flow
I_FinTransNominal view from COMPOSITE Fin Trans Nominal Amount
P_FinTransOpenFlowBusVol view inner COMPOSITE

Fields (38)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 5
KEY FinancialInstrumentActivity FinancialInstrumentActivity 4
KEY FinancialTransaction FinancialTransaction 5
KEY FinancialTransactionDirection FinancialTransactionDirection 4
KEY FinTransFlowCreationDate FinTransFlowCreationDate 4
KEY FinTransFlowCreationTime FinTransFlowCreationTime 4
KEY FinTransFlowNumber FinTransFlowNumber 4
AssignmentReference AssignmentReference 2
CalcPeriodEndDateIsInclusive CalcPeriodEndDateIsInclusive 1
CalcPeriodEndDateIsMonthEnd CalcPeriodEndDateIsMonthEnd 1
CalcPeriodStartDateIsInclusive CalcPeriodStartDateIsInclusive 1
CalcPeriodStartDateIsMonthEnd CalcPeriodStartDateIsMonthEnd 1
CalculationPeriodEndDate CalculationPeriodEndDate 1
CalculationPeriodStartDate CalculationPeriodStartDate 1
ConditionPercentageRate ConditionPercentageRate 1
FinTransFlowCalcBaseAmount FinTransFlowCalcBaseAmount 1
FinTransFlowCalcBaseAmountCrcy FinTransFlowCalcBaseAmountCrcy 1
FinTransFlowCalculationDate FinTransFlowCalculationDate 1
FinTransFlowCategory FinTransFlowCategory 1
FinTransFlowInLoclCrcyPaytAmt FinTransFlowInLoclCrcyPaytAmt 2
FinTransFlowLoclCrcyCnvrsnRate FinTransFlowLoclCrcyCnvrsnRate 2
FinTransFlowNomAmt FinTransFlowNomAmt 2
FinTransFlowNomAmtCrcy FinTransFlowNomAmtCrcy 3
FinTransFlowPaymentDate FinTransFlowPaymentDate 4
FinTransFlowPaytAmt FinTransFlowPaytAmt 4
FinTransFlowPaytAmtCrcy FinTransFlowPaytAmtCrcy 4
FinTransFlowPaytAmtDirection FinTransFlowPaytAmtDirection 3
FinTransFlowPostingStatus FinTransFlowPostingStatus 1
FinTransFlowType FinTransFlowType 3
FinTransFlwLoclCrcyAmtCalcType FinTransFlwLoclCrcyAmtCalcType 2
FinTransPaytRateInPercent FinTransPaytRateInPercent 1
FlowCalcDateIsExclusive FlowCalcDateIsExclusive 1
FlowCalcDateIsMonthEnd FlowCalcDateIsMonthEnd 1
InterestCalculationMethod InterestCalculationMethod 1
InterestCalculationType InterestCalculationType 1
IntrstCalcMethFactoryCalendar IntrstCalcMethFactoryCalendar 1
LocalCurrency LocalCurrency 2
TreasuryContractType TreasuryContractType 3

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 I_FINTRANSFLOW (
    COMPANYCODE,
    FINANCIALINSTRUMENTACTIVITY,
    FINANCIALTRANSACTION,
    FINANCIALTRANSACTIONDIRECTION,
    FINTRANSFLOWCREATIONDATE,
    FINTRANSFLOWCREATIONTIME,
    FINTRANSFLOWNUMBER,
    ASSIGNMENTREFERENCE,
    CALCPERIODENDDATEISINCLUSIVE,
    CALCPERIODENDDATEISMONTHEND,
    CALCPERIODSTARTDATEISINCLUSIVE,
    CALCPERIODSTARTDATEISMONTHEND,
    CALCULATIONPERIODENDDATE,
    CALCULATIONPERIODSTARTDATE,
    CONDITIONPERCENTAGERATE,
    FINTRANSFLOWCALCBASEAMOUNT,
    FINTRANSFLOWCALCBASEAMOUNTCRCY,
    FINTRANSFLOWCALCULATIONDATE,
    FINTRANSFLOWCATEGORY,
    FINTRANSFLOWINLOCLCRCYPAYTAMT,
    FINTRANSFLOWLOCLCRCYCNVRSNRATE,
    FINTRANSFLOWNOMAMT,
    FINTRANSFLOWNOMAMTCRCY,
    FINTRANSFLOWPAYMENTDATE,
    FINTRANSFLOWPAYTAMT,
    FINTRANSFLOWPAYTAMTCRCY,
    FINTRANSFLOWPAYTAMTDIRECTION,
    FINTRANSFLOWPOSTINGSTATUS,
    FINTRANSFLOWTYPE,
    FINTRANSFLWLOCLCRCYAMTCALCTYPE,
    FINTRANSPAYTRATEINPERCENT,
    FLOWCALCDATEISEXCLUSIVE,
    FLOWCALCDATEISMONTHEND,
    INTERESTCALCULATIONMETHOD,
    INTERESTCALCULATIONTYPE,
    INTRSTCALCMETHFACTORYCALENDAR,
    LOCALCURRENCY,
    TREASURYCONTRACTTYPE,
    PRIMARY KEY (COMPANYCODE, FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION, FINANCIALTRANSACTIONDIRECTION, FINTRANSFLOWCREATIONDATE, FINTRANSFLOWCREATIONTIME, FINTRANSFLOWNUMBER)
);

Learn More