R_FINTRANSCONDITION

CDS View
70 Fields 7 CDS Views

Financial Transaction Condition

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

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_FinTransCndnScale view inner COMPOSITE Fin Trans Condition Scaled Interest
I_FinTransCndnScale_2 view_entity 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 (70)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY ConditionItemValidityStartDate ConditionItemValidityStartDate 4
KEY FinancialInstrumentActivity FinancialInstrumentActivity 4
KEY FinancialTransaction FinancialTransaction 4
KEY FinancialTransactionDirection FinancialTransactionDirection 4
KEY FinConditionItem FinancialConditionScaleItem,FinConditionItem 4
KEY FinConditionSubItem FinConditionSubItem 2
KEY FinInstrConditionLogicGroup FinInstrConditionLogicGroup 3
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
FinCndnDayFracRoundingCat FinCndnDayFracRoundingCat 1
FinCndnDayFracRoundingDcmls FinCndnDayFracRoundingDcmls 1
FinCndnFactorRoundingCategory FinCndnFactorRoundingCategory 1
FinCndnFactorRoundingDecimals FinCndnFactorRoundingDecimals 1
FinCndnLimitAmountCurrency FinCndnLimitAmountCurrency 2
FinCndnPaytDateWrkgDayShft FinCndnPaytDateWrkgDayShft 1
FinCndnProcessingSequenceValue FinCndnProcessingSequenceValue 1
FinCndnRateFactorRndngCategory FinCndnRateFactorRndngCategory 1
FinCndnRateFactorRndngDecimals FinCndnRateFactorRndngDecimals 1
FinCndnRateFixingLockoutPeriod FinCndnRateFixingLockoutPeriod 1
FinCndnScaleLowerLimitAmount FinCndnScaleLowerLimitAmount 2
FinCndnScaleUpperLimitAmount FinCndnScaleUpperLimitAmount 2
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
FinConditionForm FinConditionForm 1
FinConditionHasSingleDateEntry FinConditionHasSingleDateEntry 1
FinConditionInterestCategory FinConditionInterestCategory 2
FinConditionIntrstBaseAmount FinConditionIntrstBaseAmount 1
FinConditionRpaytCurrency FinConditionRpaytCurrency 1
FinConditionRpaytPercentRate FinConditionRpaytPercentRate 1
FinConditionSettlementCrcy FinConditionSettlementCrcy 1
PrcIdxAdjmtDateReference PrcIdxAdjmtDateReference 1
PrcIdxAdjmtDateShftDrctn PrcIdxAdjmtDateShftDrctn 1
PrcIdxAdjmtDateWrkgDayShift PrcIdxAdjmtDateWrkgDayShift 1
PrcIdxAdjmtFixingDateShftDrctn PrcIdxAdjmtFixingDateShftDrctn 1
PrcIdxAdjmtFixingHighDate PrcIdxAdjmtFixingHighDate 1
PrcIdxAdjmtFixingLowDate PrcIdxAdjmtFixingLowDate 1
PrcIdxAdjmtFxngDteWrkgDayShft PrcIdxAdjmtFxngDteWrkgDayShft 1
PrcIdxFctrCalcCompoundingFrqcy PrcIdxFctrCalcCompoundingFrqcy 1
PriceIndexAdjustmentBaseDate PriceIndexAdjustmentBaseDate 1
PriceIndexApplicationMethod PriceIndexApplicationMethod 1
PriceIndexInterpolationMethod PriceIndexInterpolationMethod 1
RefcdIntrstRateAdjmtCondition RefcdIntrstRateAdjmtCondition 1
RefcdPrcIdxAdjmtCondition RefcdPrcIdxAdjmtCondition 1
RndngBaseUntAmtInCndnItmCrcy RndngBaseUntAmtInCndnItmCrcy 1
TreasuryContractType TreasuryContractType 1
TreasuryPriceIndex TreasuryPriceIndex 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,
    FINCNDNDAYFRACROUNDINGCAT,
    FINCNDNDAYFRACROUNDINGDCMLS,
    FINCNDNFACTORROUNDINGCATEGORY,
    FINCNDNFACTORROUNDINGDECIMALS,
    FINCNDNLIMITAMOUNTCURRENCY,
    FINCNDNPAYTDATEWRKGDAYSHFT,
    FINCNDNPROCESSINGSEQUENCEVALUE,
    FINCNDNRATEFACTORRNDNGCATEGORY,
    FINCNDNRATEFACTORRNDNGDECIMALS,
    FINCNDNRATEFIXINGLOCKOUTPERIOD,
    FINCNDNSCALELOWERLIMITAMOUNT,
    FINCNDNSCALEUPPERLIMITAMOUNT,
    FINCONDITIONCONDITIONCATEGORY,
    FINCONDITIONCONDITIONTYPE,
    FINCONDITIONFACTORYCALENDAR1,
    FINCONDITIONFACTORYCALENDAR2,
    FINCONDITIONFACTORYCALENDAR3,
    FINCONDITIONFACTORYCALENDAR4,
    FINCONDITIONFACTORYCALENDAR5,
    FINCONDITIONFIXEDAMOUNT,
    FINCONDITIONFIXEDAMOUNTCRCY,
    FINCONDITIONFORM,
    FINCONDITIONHASSINGLEDATEENTRY,
    FINCONDITIONINTERESTCATEGORY,
    FINCONDITIONINTRSTBASEAMOUNT,
    FINCONDITIONRPAYTCURRENCY,
    FINCONDITIONRPAYTPERCENTRATE,
    FINCONDITIONSETTLEMENTCRCY,
    PRCIDXADJMTDATEREFERENCE,
    PRCIDXADJMTDATESHFTDRCTN,
    PRCIDXADJMTDATEWRKGDAYSHIFT,
    PRCIDXADJMTFIXINGDATESHFTDRCTN,
    PRCIDXADJMTFIXINGHIGHDATE,
    PRCIDXADJMTFIXINGLOWDATE,
    PRCIDXADJMTFXNGDTEWRKGDAYSHFT,
    PRCIDXFCTRCALCCOMPOUNDINGFRQCY,
    PRICEINDEXADJUSTMENTBASEDATE,
    PRICEINDEXAPPLICATIONMETHOD,
    PRICEINDEXINTERPOLATIONMETHOD,
    REFCDINTRSTRATEADJMTCONDITION,
    REFCDPRCIDXADJMTCONDITION,
    RNDNGBASEUNTAMTINCNDNITMCRCY,
    TREASURYCONTRACTTYPE,
    TREASURYPRICEINDEX,
    PRIMARY KEY (COMPANYCODE, CONDITIONITEMVALIDITYSTARTDATE, FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION, FINANCIALTRANSACTIONDIRECTION, FINCONDITIONITEM, FINCONDITIONSUBITEM, FININSTRCONDITIONLOGICGROUP)
);

Learn More