R_FINTRANSCONDITION

CDS View
53 Fields 6 CDS Views

Financial Transaction Condition

R_FINTRANSCONDITION is a CDS View in S/4HANA. Financial Transaction Condition. It contains 53 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_FinTransCndnScale view inner COMPOSITE Fin Trans Condition Scaled Interest
I_FinTransCndnSingleDate view inner COMPOSITE Fin Trans Condition Single Date
I_FinTransCndnSingleDate view left_outer COMPOSITE Fin Trans Condition Single Date
I_FinTransCondition view inner COMPOSITE Financial Transaction Condition
I_FinTransCondition view left_outer COMPOSITE Financial Transaction Condition
I_FinTransInterest view inner COMPOSITE Fin Trans Interest Information

Fields (53)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 3
KEY ConditionItemValidityStartDate ConditionItemValidityStartDate 3
KEY FinancialInstrumentActivity FinancialInstrumentActivity 3
KEY FinancialTransaction FinancialTransaction 3
KEY FinancialTransactionDirection FinancialTransactionDirection 3
KEY FinConditionItem FinConditionItem 3
KEY FinConditionSubItem FinConditionSubItem 2
KEY FinInstrConditionLogicGroup FinInstrConditionLogicGroup 2
AverageInterestLowerLimitRate AverageInterestLowerLimitRate 1
AverageInterestRateSpreadValue AverageInterestRateSpreadValue 1
AverageInterestUpperLimitRate AverageInterestUpperLimitRate 1
AverageIntrstRateResetCalcEvt AverageIntrstRateResetCalcEvt 1
AverageIntrstRateRndngCategory AverageIntrstRateRndngCategory 1
AverageIntrstRateRndngDecimals AverageIntrstRateRndngDecimals 1
AverageIntrstRateWeightingCat AverageIntrstRateWeightingCat 1
AvgIntrstRateHasUsedLowerLimit AvgIntrstRateHasUsedLowerLimit 1
AvgIntrstRateHasUsedUpperLimit AvgIntrstRateHasUsedUpperLimit 1
ConditionPercentageRate ConditionPercentageRate 1
DueDate DueDate 1
DueDateIsAsEndDateMonthEnd DueDateIsAsEndDateMonthEnd 1
ExponentialIntrstSettlmtFrqcy ExponentialIntrstSettlmtFrqcy 1
FinCndnAmountRoundingCategory FinCndnAmountRoundingCategory 1
FinCndnAmountRoundingUnit FinCndnAmountRoundingUnit 1
FinCndnBaseFactorRndngCategory FinCndnBaseFactorRndngCategory 1
FinCndnBaseFactorRndngDecimals FinCndnBaseFactorRndngDecimals 1
FinCndnCrsRefcdAccmlnCndnGrp FinCndnCrsRefcdAccmlnCndnGrp 1
FinCndnFactorRoundingCategory FinCndnFactorRoundingCategory 1
FinCndnFactorRoundingDecimals FinCndnFactorRoundingDecimals 1
FinCndnLimitAmountCurrency FinCndnLimitAmountCurrency 1
FinCndnPaytDateWrkgDayShft FinCndnPaytDateWrkgDayShft 1
FinCndnProcessingSequenceValue FinCndnProcessingSequenceValue 1
FinCndnRateFactorRndngCategory FinCndnRateFactorRndngCategory 1
FinCndnRateFactorRndngDecimals FinCndnRateFactorRndngDecimals 1
FinCndnRateFixingLockoutPeriod FinCndnRateFixingLockoutPeriod 1
FinCndnScaleLowerLimitAmount FinCndnScaleLowerLimitAmount 1
FinCndnScaleUpperLimitAmount FinCndnScaleUpperLimitAmount 1
FinConditionConditionCategory FinConditionConditionCategory 2
FinConditionConditionType FinConditionConditionType 1
FinConditionFactoryCalendar1 FinConditionFactoryCalendar1 1
FinConditionFactoryCalendar2 FinConditionFactoryCalendar2 1
FinConditionFactoryCalendar3 FinConditionFactoryCalendar3 1
FinConditionFactoryCalendar4 FinConditionFactoryCalendar4 1
FinConditionFactoryCalendar5 FinConditionFactoryCalendar5 1
FinConditionFixedAmount FinConditionFixedAmount 1
FinConditionFixedAmountCrcy FinConditionFixedAmountCrcy 1
FinConditionHasSingleDateEntry FinConditionHasSingleDateEntry 1
FinConditionInterestCategory FinConditionInterestCategory 2
FinConditionIntrstBaseAmount FinConditionIntrstBaseAmount 1
FinConditionRpaytCurrency FinConditionRpaytCurrency 1
FinConditionRpaytPercentRate FinConditionRpaytPercentRate 1
InterestFirstPeriodRate InterestFirstPeriodRate 1
RndngBaseUntAmtInCndnItmCrcy RndngBaseUntAmtInCndnItmCrcy 1
TreasuryContractType TreasuryContractType 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 Condition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_FINTRANSCONDITION (
    COMPANYCODE,
    CONDITIONITEMVALIDITYSTARTDATE,
    FINANCIALINSTRUMENTACTIVITY,
    FINANCIALTRANSACTION,
    FINANCIALTRANSACTIONDIRECTION,
    FINCONDITIONITEM,
    FINCONDITIONSUBITEM,
    FININSTRCONDITIONLOGICGROUP,
    AVERAGEINTERESTLOWERLIMITRATE,
    AVERAGEINTERESTRATESPREADVALUE,
    AVERAGEINTERESTUPPERLIMITRATE,
    AVERAGEINTRSTRATERESETCALCEVT,
    AVERAGEINTRSTRATERNDNGCATEGORY,
    AVERAGEINTRSTRATERNDNGDECIMALS,
    AVERAGEINTRSTRATEWEIGHTINGCAT,
    AVGINTRSTRATEHASUSEDLOWERLIMIT,
    AVGINTRSTRATEHASUSEDUPPERLIMIT,
    CONDITIONPERCENTAGERATE,
    DUEDATE,
    DUEDATEISASENDDATEMONTHEND,
    EXPONENTIALINTRSTSETTLMTFRQCY,
    FINCNDNAMOUNTROUNDINGCATEGORY,
    FINCNDNAMOUNTROUNDINGUNIT,
    FINCNDNBASEFACTORRNDNGCATEGORY,
    FINCNDNBASEFACTORRNDNGDECIMALS,
    FINCNDNCRSREFCDACCMLNCNDNGRP,
    FINCNDNFACTORROUNDINGCATEGORY,
    FINCNDNFACTORROUNDINGDECIMALS,
    FINCNDNLIMITAMOUNTCURRENCY,
    FINCNDNPAYTDATEWRKGDAYSHFT,
    FINCNDNPROCESSINGSEQUENCEVALUE,
    FINCNDNRATEFACTORRNDNGCATEGORY,
    FINCNDNRATEFACTORRNDNGDECIMALS,
    FINCNDNRATEFIXINGLOCKOUTPERIOD,
    FINCNDNSCALELOWERLIMITAMOUNT,
    FINCNDNSCALEUPPERLIMITAMOUNT,
    FINCONDITIONCONDITIONCATEGORY,
    FINCONDITIONCONDITIONTYPE,
    FINCONDITIONFACTORYCALENDAR1,
    FINCONDITIONFACTORYCALENDAR2,
    FINCONDITIONFACTORYCALENDAR3,
    FINCONDITIONFACTORYCALENDAR4,
    FINCONDITIONFACTORYCALENDAR5,
    FINCONDITIONFIXEDAMOUNT,
    FINCONDITIONFIXEDAMOUNTCRCY,
    FINCONDITIONHASSINGLEDATEENTRY,
    FINCONDITIONINTERESTCATEGORY,
    FINCONDITIONINTRSTBASEAMOUNT,
    FINCONDITIONRPAYTCURRENCY,
    FINCONDITIONRPAYTPERCENTRATE,
    INTERESTFIRSTPERIODRATE,
    RNDNGBASEUNTAMTINCNDNITMCRCY,
    TREASURYCONTRACTTYPE,
    PRIMARY KEY (COMPANYCODE, CONDITIONITEMVALIDITYSTARTDATE, FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION, FINANCIALTRANSACTIONDIRECTION, FINCONDITIONITEM, FINCONDITIONSUBITEM, FININSTRCONDITIONLOGICGROUP)
);

Learn More