I_FinTransRepaymentCndn
Fin Trans Repayment Condition
I_FinTransRepaymentCndn is a Composite CDS View that provides data about "Fin Trans Repayment Condition" in SAP S/4HANA. It reads from 1 data source (I_FinTransCondition) and exposes 65 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, FinConditionItem.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_FinTransCondition | I_FinTransCondition | from |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IFINRPAYTCNDN | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Fin Trans Repayment Condition | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| Metadata.allowExtensions | false | view | |
| VDM.viewType | #COMPOSITE | view |
Fields (65)
| 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 | ||
| FinancialInstrProductCategory | _FinTrans | FinancialInstrProductCategory | ||
| TreasuryContractType | TreasuryContractType | |||
| FinConditionConditionCategory | FinConditionConditionCategory | |||
| FinConditionConditionType | FinConditionConditionType | |||
| FinInstrConditionLogicGroup | FinInstrConditionLogicGroup | |||
| FinancialConditionItemAmount | FinConditionRpaytAmount | |||
| FinancialConditionItemCurrency | FinConditionRpaytCurrency | |||
| FinCndnAmountTimeUnit | FinCndnAmountTimeUnit | |||
| InterestCalculationType | InterestCalculationType | |||
| InterestCalculationMethod | InterestCalculationMethod | |||
| IntrstCalcMethFactoryCalendar | IntrstCalcMethFactoryCalendar | |||
| ConditionPercentageRate | FinConditionRpaytPercentRate | |||
| FinCndnCalcBaseAmt | FinConditionRpaytBaseAmount | |||
| FinCndnCalcBaseReference | FinCndnCalcBaseReference | |||
| FinConditionFactoryCalendar1 | FinConditionFactoryCalendar1 | |||
| FinConditionFactoryCalendar2 | FinConditionFactoryCalendar2 | |||
| FinConditionFactoryCalendar3 | FinConditionFactoryCalendar3 | |||
| FinConditionFactoryCalendar4 | FinConditionFactoryCalendar4 | |||
| FinConditionFactoryCalendar5 | FinConditionFactoryCalendar5 | |||
| CalculationDate | CalculationDate | |||
| FinCndnCalcDteUpdateRule | FinCndnCalcDteUpdateRule | |||
| FinCndnCalcDteFrequency | FinCndnCalcDteFrequency | |||
| FinCndnCalcDteFrqcyUnit | FinCndnCalcDteFrqcyUnit | |||
| CalcDateIsAsEndDateInclusive | CalcDateIsAsEndDateInclusive | |||
| CalcDteIsRegularWithVarblDte | CalcDteIsRegularWithVarblDte | |||
| CalcDateIsAsEndDateMonthEnd | CalcDateIsAsEndDateMonthEnd | |||
| FinCndnCalcDteWrkgDayShft | FinCndnCalcDteWrkgDayShft | |||
| FinCndnCalcDteShftDrctn | FinCndnCalcDteShftDrctn | |||
| FinCndnCalcDteShftNrOfDays | FinCndnCalcDteShftNrOfDays | |||
| InterestCalculationDateRef | InterestCalculationDateRef | |||
| DueDate | DueDate | |||
| FinCndnDueDteUpdateRule | FinCndnDueDteUpdateRule | |||
| FinCndnDueDteFrequency | FinCndnDueDteFrequency | |||
| FinCndnDueDteFrqcyUnit | FinCndnDueDteFrqcyUnit | |||
| DueDateIsAsEndDateInclusive | DueDateIsAsEndDateInclusive | |||
| DueDteIsRegularWithVarblDte | DueDteIsRegularWithVarblDte | |||
| DueDateIsAsEndDateMonthEnd | DueDateIsAsEndDateMonthEnd | |||
| FinCndnDueDteWrkgDayShft | FinCndnDueDteWrkgDayShft | |||
| FinCndnDueDteShftDrctn | FinCndnDueDteShftDrctn | |||
| FinCndnDueDteShftNrOfDays | FinCndnDueDteShftNrOfDays | |||
| InterestDueDateReference | InterestDueDateReference | |||
| FinCndnDueDteShiftToTermEnd | FinCndnDueDteShiftToTermEnd | |||
| FinCndnRpaytSettlmt | FinCndnRpaytSettlmt | |||
| FinCndnFirstPeriodCalcMethod | FinCndnFirstPeriodCalcMethod | |||
| FinCndnLastPeriodCalcMethod | FinCndnLastPeriodCalcMethod | |||
| _CompanyCode | _CompanyCode | |||
| _FinTrans | _FinTrans | |||
| _Activity | _Activity | |||
| _Direction | _Direction | |||
| _ContractType | _ContractType | |||
| _ConditionCategory | _ConditionCategory | |||
| _ConditionType | _ConditionType | |||
| _ConditionItemCurrency | _RepaymentCurrency | |||
| _Calendar1 | _Calendar1 | |||
| _Calendar2 | _Calendar2 | |||
| _Calendar3 | _Calendar3 | |||
| _Calendar4 | _Calendar4 | |||
| _Calendar5 | _Calendar5 | |||
| _SingleDate | _SingleDate |
@AbapCatalog.sqlViewName: 'IFINRPAYTCNDN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Fin Trans Repayment Condition'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:false
@VDM.viewType: #COMPOSITE
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
define view I_FinTransRepaymentCndn
as select from I_FinTransCondition
//exposed fields
{
@ObjectModel.foreignKey.association: '_CompanyCode'
key CompanyCode,
@ObjectModel.foreignKey.association: '_FinTrans'
key FinancialTransaction,
@ObjectModel.foreignKey.association: '_Activity'
key FinancialInstrumentActivity,
@ObjectModel.foreignKey.association: '_Direction'
key FinancialTransactionDirection,
key FinConditionItem,
key ConditionItemValidityStartDate,
_FinTrans.FinancialInstrProductCategory,
@ObjectModel.foreignKey.association: '_ContractType'
TreasuryContractType,
@ObjectModel.foreignKey.association: '_ConditionCategory'
FinConditionConditionCategory,
@ObjectModel.foreignKey.association: '_ConditionType'
FinConditionConditionType,
FinInstrConditionLogicGroup,
//Amount
@Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
FinConditionRpaytAmount as FinancialConditionItemAmount,
@ObjectModel.foreignKey.association: '_ConditionItemCurrency'
@Semantics.currencyCode: true
FinConditionRpaytCurrency as FinancialConditionItemCurrency,
FinCndnAmountTimeUnit,
//Amount - Rate
InterestCalculationType,
InterestCalculationMethod,
IntrstCalcMethFactoryCalendar,
FinConditionRpaytPercentRate as ConditionPercentageRate,
@Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
FinConditionRpaytBaseAmount as FinCndnCalcBaseAmt,
FinCndnCalcBaseReference,
@ObjectModel.foreignKey.association: '_Calendar1'
FinConditionFactoryCalendar1 as FinConditionFactoryCalendar1,
@ObjectModel.foreignKey.association: '_Calendar2'
FinConditionFactoryCalendar2 as FinConditionFactoryCalendar2,
@ObjectModel.foreignKey.association: '_Calendar3'
FinConditionFactoryCalendar3 as FinConditionFactoryCalendar3,
@ObjectModel.foreignKey.association: '_Calendar4'
FinConditionFactoryCalendar4 as FinConditionFactoryCalendar4,
@ObjectModel.foreignKey.association: '_Calendar5'
FinConditionFactoryCalendar5 as FinConditionFactoryCalendar5,
CalculationDate,
FinCndnCalcDteUpdateRule,
FinCndnCalcDteFrequency,
FinCndnCalcDteFrqcyUnit,
CalcDateIsAsEndDateInclusive,
CalcDteIsRegularWithVarblDte,
CalcDateIsAsEndDateMonthEnd,
FinCndnCalcDteWrkgDayShft,
FinCndnCalcDteShftDrctn,
FinCndnCalcDteShftNrOfDays,
InterestCalculationDateRef,
DueDate,
FinCndnDueDteUpdateRule,
FinCndnDueDteFrequency,
FinCndnDueDteFrqcyUnit,
DueDateIsAsEndDateInclusive,
DueDteIsRegularWithVarblDte,
DueDateIsAsEndDateMonthEnd,
FinCndnDueDteWrkgDayShft,
FinCndnDueDteShftDrctn,
FinCndnDueDteShftNrOfDays,
InterestDueDateReference,
//other calculation data
FinCndnDueDteShiftToTermEnd,
FinCndnRpaytSettlmt,
FinCndnFirstPeriodCalcMethod,
FinCndnLastPeriodCalcMethod,
//exposed dimensions, containing for example text fields
_CompanyCode,
_FinTrans,
_Activity,
_Direction,
_ContractType,
_ConditionCategory,
_ConditionType,
_RepaymentCurrency as _ConditionItemCurrency,
_Calendar1,
_Calendar2,
_Calendar3,
_Calendar4,
_Calendar5,
_SingleDate
}
where
( FinConditionConditionCategory = '12' or FinConditionConditionCategory = '13' or FinConditionConditionCategory = '14')
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALTRANSACTION",
"I_FINTRANSCONDITION"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_FACTORYCALENDAR",
"I_FINANCIALTRANSACTION",
"I_FINCNDNCONDITIONCATEGORY",
"I_FINCNDNCONDITIONTYPE",
"I_FINTRANSACTIONDIRECTION",
"I_FINTRANSACTIVITY",
"I_FINTRANSCNDNSINGLEDATE",
"I_TREASURYCONTRACTTYPE"
],
"BASE":
[
"I_FINTRANSCONDITION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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