I_FinTransRepaymentCndn

DDL: I_FINTRANSREPAYMENTCNDN SQL: IFINRPAYTCNDN Type: view COMPOSITE

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)

SourceAliasJoin Type
I_FinTransCondition I_FinTransCondition from

Annotations (13)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/