R_FinTransConditionTP

DDL: R_FINTRANSCONDITIONTP Type: view_entity TRANSACTIONAL Package: RAP_FIN_TRM_TM_FT

Financial Transaction Condition - TP

R_FinTransConditionTP is a Transactional CDS View that provides data about "Financial Transaction Condition - TP" in SAP S/4HANA. It reads from 1 data source (I_FinTransCondition) and exposes 137 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, FinConditionItem. It has 3 associations to related views. Part of development package RAP_FIN_TRM_TM_FT.

Data Sources (1)

SourceAliasJoin Type
I_FinTransCondition I_FinTransCondition from

Associations (3)

CardinalityTargetAliasCondition
[0..*] R_FinTransCndnSingleDateTP _ConditionSingleDate
[0..*] R_FinTransCndnFmlaVarblTP _CndnVariableInterestFormula
[0..*] R_FinTransCndnScaleTP _ConditionScale

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Financial Transaction Condition - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (137)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY FinancialTransaction FinancialTransaction
KEY FinancialInstrumentActivity FinancialInstrumentActivity
KEY FinancialTransactionDirection FinancialTransactionDirection
KEY FinConditionItem FinConditionItem
KEY ConditionItemValidityStartDate ConditionItemValidityStartDate
FinConditionForm FinConditionForm
FinInstrConditionLogicGroup FinInstrConditionLogicGroup
TreasuryContractType TreasuryContractType
FinConditionConditionCategory FinConditionConditionCategory
FinConditionConditionType FinConditionConditionType
InterestCalculationMethod InterestCalculationMethod
InterestCalculationType InterestCalculationType
FinConditionInterestCategory FinConditionInterestCategory
ConditionPercentageRate ConditionPercentageRate
FinConditionFormulaReference FinConditionFormulaReference
InterestReference InterestReference
FinConditionFixedAmount FinConditionFixedAmount
FinConditionFixedAmountCrcy FinConditionFixedAmountCrcy
FinConditionRpaytPercentRate FinConditionRpaytPercentRate
FinConditionRpaytBaseAmount FinConditionRpaytBaseAmount
FinConditionRpaytAmount FinConditionRpaytAmount
FinConditionRpaytCurrency FinConditionRpaytCurrency
CalculationDate CalculationDate
FinCndnCalcDteUpdateRule FinCndnCalcDteUpdateRule
FinCndnCalcDteFrequency FinCndnCalcDteFrequency
FinCndnCalcDteFrqcyUnit FinCndnCalcDteFrqcyUnit
CalcDateIsAsEndDateInclusive CalcDateIsAsEndDateInclusive
CalcDateIsAsEndDateMonthEnd CalcDateIsAsEndDateMonthEnd
FinCndnCalcDteWrkgDayShft FinCndnCalcDteWrkgDayShft
FinCndnCalcDteShftDrctn FinCndnCalcDteShftDrctn
FinCndnCalcDteShftNrOfDays FinCndnCalcDteShftNrOfDays
DueDate DueDate
FinCndnDueDteUpdateRule FinCndnDueDteUpdateRule
FinCndnDueDteFrequency FinCndnDueDteFrequency
FinCndnDueDteFrqcyUnit FinCndnDueDteFrqcyUnit
DueDateIsAsEndDateInclusive DueDateIsAsEndDateInclusive
DueDateIsAsEndDateMonthEnd DueDateIsAsEndDateMonthEnd
FinCndnDueDteWrkgDayShft FinCndnDueDteWrkgDayShft
FinCndnDueDteShftDrctn FinCndnDueDteShftDrctn
FinCndnDueDteShftNrOfDays FinCndnDueDteShftNrOfDays
FinConditionFactoryCalendar1 FinConditionFactoryCalendar1
FinConditionFactoryCalendar2 FinConditionFactoryCalendar2
FinConditionFactoryCalendar3 FinConditionFactoryCalendar3
FinConditionFactoryCalendar4 FinConditionFactoryCalendar4
FinConditionFactoryCalendar5 FinConditionFactoryCalendar5
ExponentialIntrstSettlmtFrqcy ExponentialIntrstSettlmtFrqcy
IntrstCalcMethFactoryCalendar IntrstCalcMethFactoryCalendar
FinancialConditionPaymentRate FinancialConditionPaymentRate
InterestMarkupMarkdownValue InterestMarkupMarkdownValue
InterestFirstPeriodRate InterestFirstPeriodRate
AverageIntrstRateWeightingCat AverageIntrstRateWeightingCat
AverageIntrstRateRndngCategory AverageIntrstRateRndngCategory
AverageIntrstRateRndngDecimals AverageIntrstRateRndngDecimals
AverageInterestRateSpreadValue AverageInterestRateSpreadValue
AvgIntrstRateHasUsedUpperLimit AvgIntrstRateHasUsedUpperLimit
AverageInterestUpperLimitRate AverageInterestUpperLimitRate
AvgIntrstRateHasUsedLowerLimit AvgIntrstRateHasUsedLowerLimit
AverageInterestLowerLimitRate AverageInterestLowerLimitRate
AverageIntrstRateResetCalcEvt AverageIntrstRateResetCalcEvt
FinCndnRateFactorRndngCategory FinCndnRateFactorRndngCategory
FinCndnRateFactorRndngDecimals FinCndnRateFactorRndngDecimals
FinCndnFactorRoundingCategory FinCndnFactorRoundingCategory
FinCndnFactorRoundingDecimals FinCndnFactorRoundingDecimals
FinCndnBaseFactorRndngCategory FinCndnBaseFactorRndngCategory
FinCndnBaseFactorRndngDecimals FinCndnBaseFactorRndngDecimals
FinCndnAmountRoundingCategory FinCndnAmountRoundingCategory
FinCndnAmountRoundingUnit FinCndnAmountRoundingUnit
RndngBaseUntAmtInCndnItmCrcy RndngBaseUntAmtInCndnItmCrcy
FinConditionIntrstBaseAmount FinConditionIntrstBaseAmount
FinCndnCalcBaseReference FinCndnCalcBaseReference
FinCndnProcessingSequenceValue FinCndnProcessingSequenceValue
FinCndnAmountTimeUnit FinCndnAmountTimeUnit
FinCndnLimitAmountCurrency FinCndnLimitAmountCurrency
FinCndnItmHasUsedLowerLimitAmt FinCndnItmHasUsedLowerLimitAmt
FinCndnItemLowerLimitAmount FinCndnItemLowerLimitAmount
FinCndnItmHasUsedUpperLimitAmt FinCndnItmHasUsedUpperLimitAmt
FinCndnItemUpperLimitAmount FinCndnItemUpperLimitAmount
FinCndnCrsRefcdAccmlnCndnGrp FinCndnCrsRefcdAccmlnCndnGrp
RefcdIntrstRateAdjmtCondition RefcdIntrstRateAdjmtCondition
RefcdPrcIdxAdjmtCondition RefcdPrcIdxAdjmtCondition
InterestCalculationDateRef InterestCalculationDateRef
InterestDueDateReference InterestDueDateReference
CalcDteIsRegularWithVarblDte CalcDteIsRegularWithVarblDte
DueDteIsRegularWithVarblDte DueDteIsRegularWithVarblDte
FinCndnFirstPeriodCalcMethod FinCndnFirstPeriodCalcMethod
FinCndnLastPeriodCalcMethod FinCndnLastPeriodCalcMethod
FinCndnDueDteShiftToTermEnd FinCndnDueDteShiftToTermEnd
FinCndnPaytDateWrkgDayShft FinCndnPaytDateWrkgDayShft
FinCndnRpaytSettlmt FinCndnRpaytSettlmt
InterestRateAdjustmentDateRule InterestRateAdjustmentDateRule
InterestRateAdjustmentFrqcy InterestRateAdjustmentFrqcy
InterestRateAdjmtFrqcyUnit InterestRateAdjmtFrqcyUnit
InterestRateAdjustmentDate InterestRateAdjustmentDate
IntrstRateAdjmtDateIsMonthEnd IntrstRateAdjmtDateIsMonthEnd
IntrstRateAdjmtDteIsExclusive IntrstRateAdjmtDteIsExclusive
IntrstRateAdjmtDateWrkgDayShft IntrstRateAdjmtDateWrkgDayShft
IntrstRateAdjmtShftNrOfDays IntrstRateAdjmtShftNrOfDays
FinCndnAdjmtDteShftDrctn FinCndnAdjmtDteShftDrctn
InterestRateFixingDateRule InterestRateFixingDateRule
InterestRateFixingFrqcy InterestRateFixingFrqcy
InterestRateFixingFrqcyUnit InterestRateFixingFrqcyUnit
InterestRateFixingDate InterestRateFixingDate
IntrstRateFixingDateIsMonthEnd IntrstRateFixingDateIsMonthEnd
FinCndnFixingDteShftDrctn FinCndnFixingDteShftDrctn
InterestRateFixingShftNrOfDays InterestRateFixingShftNrOfDays
IntrstRateFixDteShftIsModifd IntrstRateFixDteShftIsModifd
InterestRateFixingDateRef InterestRateFixingDateRef
FinCndnRateFixingLockoutPeriod FinCndnRateFixingLockoutPeriod
TreasuryPriceIndex TreasuryPriceIndex
PriceIndexInterpolationMethod PriceIndexInterpolationMethod
PriceIndexApplicationMethod PriceIndexApplicationMethod
PrcIdxFctrCalcCompoundingFrqcy PrcIdxFctrCalcCompoundingFrqcy
FinCndnDayFracRoundingCat FinCndnDayFracRoundingCat
FinCndnDayFracRoundingDcmls FinCndnDayFracRoundingDcmls
PrcIdxAdjmtDateReference PrcIdxAdjmtDateReference
PrcIdxAdjmtDateWrkgDayShift PrcIdxAdjmtDateWrkgDayShift
PrcIdxAdjmtDateShftDrctn PrcIdxAdjmtDateShftDrctn
PrcIdxAdjmtShftNrOfDays PrcIdxAdjmtShftNrOfDays
PriceIndexAdjustmentBaseDate PriceIndexAdjustmentBaseDate
PrcIdxAdjmtFixingLowDate PrcIdxAdjmtFixingLowDate
PrcIdxAdjmtFixingHighDate PrcIdxAdjmtFixingHighDate
PrcIdxAdjmtFxngDteWrkgDayShft PrcIdxAdjmtFxngDteWrkgDayShft
PrcIdxAdjmtFixingDateShftDrctn PrcIdxAdjmtFixingDateShftDrctn
PrcIdxAdjmtFxngDteShftNrOfDays PrcIdxAdjmtFxngDteShftNrOfDays
FinConditionSettlementCrcy FinConditionSettlementCrcy
ForeignExchangeFixingReference ForeignExchangeFixingReference
FXRateAdjmtFixingDateRef FXRateAdjmtFixingDateRef
FXRateAdjmtFixingDateShftDrctn FXRateAdjmtFixingDateShftDrctn
FXRateAdjmtFxngDteShftNrOfDays FXRateAdjmtFxngDteShftNrOfDays
FXRateAdjmtFxngDteShftIsModifd FXRateAdjmtFxngDteShftIsModifd
FinancialInstrProductCategory _FinancialTransaction FinancialInstrProductCategory
_ConditionScale _ConditionScale
_CndnVariableInterestFormula _CndnVariableInterestFormula
_ConditionSingleDate _ConditionSingleDate
_FinancialTransaction _FinancialTransaction
_FinTrans _FinTrans
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel:{
    usageType : {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }
}
@EndUserText.label: 'Financial Transaction Condition - TP'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view entity R_FinTransConditionTP
  as select from I_FinTransCondition

  composition [0..*] of R_FinTransCndnSingleDateTP as _ConditionSingleDate

  composition [0..*] of R_FinTransCndnFmlaVarblTP  as _CndnVariableInterestFormula

  composition [0..*] of R_FinTransCndnScaleTP      as _ConditionScale

  association to parent R_FinancialTransactionTP   as _FinancialTransaction on  $projection.CompanyCode          = _FinancialTransaction.CompanyCode
                                                                            and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction

{

  key  CompanyCode,
  key  FinancialTransaction,
  key  FinancialInstrumentActivity,
  key  FinancialTransactionDirection,
  key  FinConditionItem,
  key  ConditionItemValidityStartDate,

       // Condition Header

       FinConditionForm,       
       FinInstrConditionLogicGroup,
       TreasuryContractType,
       FinConditionConditionCategory,
       FinConditionConditionType,

       // Fixed Interest 

       InterestCalculationMethod,
       InterestCalculationType,
       FinConditionInterestCategory,
       ConditionPercentageRate,
       FinConditionFormulaReference,
       InterestReference,
       FinConditionFixedAmount,
       FinConditionFixedAmountCrcy,
       
       // Repayment Details

       FinConditionRpaytPercentRate,
       FinConditionRpaytBaseAmount,
       FinConditionRpaytAmount,
       FinConditionRpaytCurrency,

       //FinConditionHasSingleDateEntry,


       // Calculation Date

       CalculationDate,
       FinCndnCalcDteUpdateRule,
       FinCndnCalcDteFrequency,
       FinCndnCalcDteFrqcyUnit,
       CalcDateIsAsEndDateInclusive,
       CalcDateIsAsEndDateMonthEnd,
       FinCndnCalcDteWrkgDayShft,
       FinCndnCalcDteShftDrctn,
       FinCndnCalcDteShftNrOfDays,

       // Due Date

       DueDate,
       FinCndnDueDteUpdateRule,
       FinCndnDueDteFrequency,
       FinCndnDueDteFrqcyUnit,
       DueDateIsAsEndDateInclusive,
       DueDateIsAsEndDateMonthEnd,
       FinCndnDueDteWrkgDayShft,
       FinCndnDueDteShftDrctn,
       FinCndnDueDteShftNrOfDays,

       // Calendars

       FinConditionFactoryCalendar1,
       FinConditionFactoryCalendar2,
       FinConditionFactoryCalendar3,
       FinConditionFactoryCalendar4,
       FinConditionFactoryCalendar5,

       // Exponential Interest Calculation

       ExponentialIntrstSettlmtFrqcy, 
       IntrstCalcMethFactoryCalendar, 
       FinancialConditionPaymentRate,
       InterestMarkupMarkdownValue, 
       InterestFirstPeriodRate,
       
       // Average Interest Calculation

       AverageIntrstRateWeightingCat, 
       AverageIntrstRateRndngCategory,
       AverageIntrstRateRndngDecimals,
       AverageInterestRateSpreadValue, 
       AvgIntrstRateHasUsedUpperLimit,    
       AverageInterestUpperLimitRate, 
       AvgIntrstRateHasUsedLowerLimit, 
       AverageInterestLowerLimitRate, 
       AverageIntrstRateResetCalcEvt, 

       // Rounding Interest Factor

       FinCndnRateFactorRndngCategory,
       FinCndnRateFactorRndngDecimals,
       FinCndnFactorRoundingCategory, // Exponential Interest Cal with Factor

       FinCndnFactorRoundingDecimals,
       FinCndnBaseFactorRndngCategory,
       FinCndnBaseFactorRndngDecimals,
       
       // Rounding Amount

       FinCndnAmountRoundingCategory,
       FinCndnAmountRoundingUnit,
       RndngBaseUntAmtInCndnItmCrcy,

       // Calculation Base

       FinConditionIntrstBaseAmount, 
       FinCndnCalcBaseReference,
       FinCndnProcessingSequenceValue,
       
       // Currency Related Data

       FinCndnAmountTimeUnit,
       FinCndnLimitAmountCurrency,
       FinCndnItmHasUsedLowerLimitAmt,
       FinCndnItemLowerLimitAmount,
       FinCndnItmHasUsedUpperLimitAmt,
       FinCndnItemUpperLimitAmount,
       
       // Referenced condition group

       FinCndnCrsRefcdAccmlnCndnGrp,
       RefcdIntrstRateAdjmtCondition,
       RefcdPrcIdxAdjmtCondition,
       

       InterestCalculationDateRef,
       InterestDueDateReference,
       CalcDteIsRegularWithVarblDte,
       DueDteIsRegularWithVarblDte,
       
       // Other Calculation Data

       FinCndnFirstPeriodCalcMethod,
       FinCndnLastPeriodCalcMethod,
       FinCndnDueDteShiftToTermEnd,
       FinCndnPaytDateWrkgDayShft,
       FinCndnRpaytSettlmt,

       // Interest Rate Adjustment

       InterestRateAdjustmentDateRule,
       InterestRateAdjustmentFrqcy,
       InterestRateAdjmtFrqcyUnit,
       InterestRateAdjustmentDate,
       IntrstRateAdjmtDateIsMonthEnd,
       IntrstRateAdjmtDteIsExclusive,
       IntrstRateAdjmtDateWrkgDayShft,
       IntrstRateAdjmtShftNrOfDays,
       FinCndnAdjmtDteShftDrctn,

       // Interest Rate Fixing Date

       InterestRateFixingDateRule,
       InterestRateFixingFrqcy,
       InterestRateFixingFrqcyUnit,
       InterestRateFixingDate,
       IntrstRateFixingDateIsMonthEnd,
       FinCndnFixingDteShftDrctn,
       InterestRateFixingShftNrOfDays,
       IntrstRateFixDteShftIsModifd,
       InterestRateFixingDateRef,
       FinCndnRateFixingLockoutPeriod,

       //CE2508 -  Price Index Adjustment - general attributes

       TreasuryPriceIndex,
       PriceIndexInterpolationMethod,
       PriceIndexApplicationMethod,
       PrcIdxFctrCalcCompoundingFrqcy,
       FinCndnDayFracRoundingCat,
       FinCndnDayFracRoundingDcmls,

       //CE2508 -  Price Index Adjustment - reference date for index adjustment date

       PrcIdxAdjmtDateReference,
       PrcIdxAdjmtDateWrkgDayShift,
       PrcIdxAdjmtDateShftDrctn,
       PrcIdxAdjmtShftNrOfDays,

       //CE2508 - Price Index Adjustment - index base value

       PriceIndexAdjustmentBaseDate,
       //PrcIdxAdjmtBaseValue,


       //CE2508 - Price Index Adjustment - fixing date

       PrcIdxAdjmtFixingLowDate,
       PrcIdxAdjmtFixingHighDate,
       PrcIdxAdjmtFxngDteWrkgDayShft,
       PrcIdxAdjmtFixingDateShftDrctn,
       PrcIdxAdjmtFxngDteShftNrOfDays,

       //CE2508 - FX Rate Adjustment - FX rate reference

       FinConditionSettlementCrcy,
       ForeignExchangeFixingReference,

       //CE2508 - FX Rate Adjustment - fixing date

       FXRateAdjmtFixingDateRef,
       FXRateAdjmtFixingDateShftDrctn,
       FXRateAdjmtFxngDteShftNrOfDays,
       FXRateAdjmtFxngDteShftIsModifd,


       _FinancialTransaction.FinancialInstrProductCategory as FinancialInstrProductCategory,

       //association

       _ConditionScale,
       _CndnVariableInterestFormula,
       _ConditionSingleDate,
       
       _FinancialTransaction,
       @Consumption.hidden: true
       _FinTrans
}