R_FinTransCndnScFmlaVarblTP

DDL: R_FINTRANSCNDNSCFMLAVARBLTP Type: view_entity TRANSACTIONAL Package: RAP_FIN_TRM_TM_FT

Fin Trans Cndn Scale Formula - TP

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

1 data source(s) 15 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 Cndn Scale Formula - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinTransCndnFmlaVarbl CompanyCode
KEY FinancialTransaction I_FinTransCndnFmlaVarbl FinancialTransaction
KEY FinancialInstrumentActivity I_FinTransCndnFmlaVarbl FinancialInstrumentActivity
KEY FinancialTransactionDirection I_FinTransCndnFmlaVarbl FinancialTransactionDirection
KEY ConditionItemValidityStartDate I_FinTransCndnFmlaVarbl ConditionItemValidityStartDate
KEY FinConditionItem Scale FinConditionItem
KEY FinancialConditionScaleItem I_FinTransCndnFmlaVarbl FinConditionItem
KEY FinConditionFormulaReference I_FinTransCndnFmlaVarbl FinConditionFormulaReference
KEY FinCndnFormulaVariable I_FinTransCndnFmlaVarbl FinCndnFormulaVariable
ConditionPercentageRate I_FinTransCndnFmlaVarbl ConditionPercentageRate
InterestReference I_FinTransCndnFmlaVarbl InterestReference
FinancialInstrProductCategory I_FinTransCndnFmlaVarbl FinancialInstrProductCategory
_FinancialTransaction _FinancialTransaction
_ConditionScale _ConditionScale
_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 Cndn Scale Formula - TP'
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view entity R_FinTransCndnScFmlaVarblTP
  as select from           I_FinTransCndnFmlaVarbl as FormulaVariable
  //fetch the main condition item for scaled condition item

    inner 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_FinTransCndnScaleTP as _ConditionScale on  $projection.CompanyCode                    = _ConditionScale.CompanyCode
                                                                 and $projection.FinancialTransaction           = _ConditionScale.FinancialTransaction
                                                                 and $projection.FinancialInstrumentActivity    = _ConditionScale.FinancialInstrumentActivity
                                                                 and $projection.FinancialTransactionDirection  = _ConditionScale.FinancialTransactionDirection
                                                                 and $projection.ConditionItemValidityStartDate = _ConditionScale.ConditionItemValidityStartDate
                                                                 and $projection.FinConditionItem               = _ConditionScale.FinConditionItem
                                                                 and $projection.FinancialConditionScaleItem    = _ConditionScale.FinancialConditionScaleItem
                                                                 
  association [1..1] to R_FinancialTransactionTP as _FinancialTransaction on  $projection.CompanyCode          = _FinancialTransaction.CompanyCode
                                                            and $projection.FinancialTransaction = _FinancialTransaction.FinancialTransaction   

{

  key  FormulaVariable.CompanyCode                    as CompanyCode,
  key  FormulaVariable.FinancialTransaction           as FinancialTransaction,
  key  FormulaVariable.FinancialInstrumentActivity    as FinancialInstrumentActivity,
  key  FormulaVariable.FinancialTransactionDirection  as FinancialTransactionDirection,
  key  FormulaVariable.ConditionItemValidityStartDate as ConditionItemValidityStartDate,
  key  Scale.FinConditionItem                         as FinConditionItem,
  key  FormulaVariable.FinConditionItem               as FinancialConditionScaleItem,
  key  FormulaVariable.FinConditionFormulaReference   as FinConditionFormulaReference,
  key  FormulaVariable.FinCndnFormulaVariable         as FinCndnFormulaVariable,

       FormulaVariable.ConditionPercentageRate        as ConditionPercentageRate,
       FormulaVariable.InterestReference              as InterestReference,

       FormulaVariable.FinancialInstrProductCategory  as FinancialInstrProductCategory,

       _FinancialTransaction,
       _ConditionScale,
       @Consumption.hidden: true
       FormulaVariable._FinTrans
}

Learn More