R_FinTransCndnFmlaVarblTP

DDL: R_FINTRANSCNDNFMLAVARBLTP Type: view_entity TRANSACTIONAL Package: RAP_FIN_TRM_TM_FT

Fin Trans Variable Interest Formula - TP

R_FinTransCndnFmlaVarblTP is a Transactional CDS View that provides data about "Fin Trans Variable Interest Formula - TP" in SAP S/4HANA. It reads from 1 data source (I_FinTransCndnFmlaVarbl) and exposes 14 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinancialTransactionDirection, FinConditionItem. It has 1 association to related views. Part of development package RAP_FIN_TRM_TM_FT.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_FinTransCndnFmlaVarbl FormulaVariable from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_FinancialTransactionTP _FinancialTransaction $projection.CompanyCode = _FinancialTransaction.CompanyCode and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Fin Trans Variable Interest Formula - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinTransCndnFmlaVarbl CompanyCode
KEY FinancialTransaction I_FinTransCndnFmlaVarbl FinancialTransaction
KEY FinancialInstrumentActivity I_FinTransCndnFmlaVarbl FinancialInstrumentActivity
KEY FinancialTransactionDirection I_FinTransCndnFmlaVarbl FinancialTransactionDirection
KEY FinConditionItem I_FinTransCndnFmlaVarbl FinConditionItem
KEY ConditionItemValidityStartDate I_FinTransCndnFmlaVarbl ConditionItemValidityStartDate
KEY FinConditionFormulaReference I_FinTransCndnFmlaVarbl FinConditionFormulaReference
KEY FinCndnFormulaVariable I_FinTransCndnFmlaVarbl FinCndnFormulaVariable
ConditionPercentageRate I_FinTransCndnFmlaVarbl ConditionPercentageRate
InterestReference I_FinTransCndnFmlaVarbl InterestReference
FinancialInstrProductCategory I_FinTransCndnFmlaVarbl FinancialInstrProductCategory
_Condition _Condition
_FinancialTransaction _FinancialTransaction
_FinTrans I_FinTransCndnFmlaVarbl _FinTrans 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel:{
    usageType : {
        sizeCategory: #M,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }
}
@EndUserText.label: 'Fin Trans Variable Interest Formula - TP'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view entity R_FinTransCndnFmlaVarblTP
  as select from I_FinTransCndnFmlaVarbl  as FormulaVariable
  left outer many to one join I_FinTransCndnScale_2   as Scale on  FormulaVariable.CompanyCode                    = Scale.CompanyCode
                                                                 and FormulaVariable.FinancialTransaction           = Scale.FinancialTransaction
                                                                 and FormulaVariable.FinancialInstrumentActivity    = Scale.FinancialInstrumentActivity
                                                                 and FormulaVariable.FinancialTransactionDirection  = Scale.FinancialTransactionDirection
                                                                 and FormulaVariable.ConditionItemValidityStartDate = Scale.ConditionItemValidityStartDate
                                                                 and FormulaVariable.FinConditionItem               = Scale.FinancialConditionScaleItem  
  association to parent R_FinTransConditionTP as _Condition on  $projection.CompanyCode                    = _Condition.CompanyCode
                                                            and $projection.FinancialTransaction           = _Condition.FinancialTransaction
                                                            and $projection.FinancialInstrumentActivity    = _Condition.FinancialInstrumentActivity
                                                            and $projection.FinancialTransactionDirection  = _Condition.FinancialTransactionDirection
                                                            and $projection.FinConditionItem               = _Condition.FinConditionItem
                                                            and $projection.ConditionItemValidityStartDate = _Condition.ConditionItemValidityStartDate
                                                            
  association [1..1] to R_FinancialTransactionTP as _FinancialTransaction on  $projection.CompanyCode          = _FinancialTransaction.CompanyCode
                                                            and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction  

{

  key  FormulaVariable.CompanyCode,
  key  FormulaVariable.FinancialTransaction,
  key  FormulaVariable.FinancialInstrumentActivity,
  key  FormulaVariable.FinancialTransactionDirection,
  key  FormulaVariable.FinConditionItem,
  key  FormulaVariable.ConditionItemValidityStartDate,
  key  FormulaVariable.FinConditionFormulaReference,
  key  FormulaVariable.FinCndnFormulaVariable,
       
       FormulaVariable.ConditionPercentageRate,
       FormulaVariable.InterestReference,
       
       FormulaVariable.FinancialInstrProductCategory,

       _Condition,
       _FinancialTransaction,
       @Consumption.hidden: true
       FormulaVariable._FinTrans
}
where Scale.FinConditionItem is null

Learn More