R_FinTransConditionTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_FinTransCondition | I_FinTransCondition | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_FinTransCndnSingleDateTP | _ConditionSingleDate | |
| [0..*] | R_FinTransCndnFmlaVarblTP | _CndnVariableInterestFormula | |
| [0..*] | R_FinTransCndnScaleTP | _ConditionScale | |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA