I_MktDataRefIntrstRateCube

DDL: I_MKTDATAREFINTRSTRATECUBE SQL: IMDREFINTCUBE Type: view COMPOSITE Package: FTR_MDM_CORE

Reference IR - Cube

I_MktDataRefIntrstRateCube is a Composite CDS View (Cube) that provides data about "Reference IR - Cube" in SAP S/4HANA. It reads from 1 data source (I_ReferenceInterestRateVal) and exposes 7 fields with key fields ReferenceInterestRate, CalendarDate. It has 3 associations to related views. Part of development package FTR_MDM_CORE.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_ReferenceInterestRateVal RefIntVal from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ReferenceInterestRate _RefInterest _RefInterest.ReferenceInterestRate = $projection.ReferenceInterestRate
[1..1] I_CalendarDate _CalendarDate _CalendarDate.CalendarDate = $projection.CalendarDate
[0..1] I_Currency _ReferenceInterestRateCurrency $projection.currency = _ReferenceInterestRateCurrency.Currency

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IMDREFINTCUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey ReferenceInterestRate view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Reference IR - Cube view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ReferenceInterestRate
KEY CalendarDate
Currency
EffectiveInterestRate I_ReferenceInterestRateVal EffectiveInterestRate
_RefInterest _RefInterest
_CalendarDate _CalendarDate
_ReferenceInterestRateCurrency _ReferenceInterestRateCurrency 
@AbapCatalog.sqlViewName: 'IMDREFINTCUBE'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@Metadata.allowExtensions:true
@Analytics.dataCategory: #CUBE
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_PROVIDER, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]
@ObjectModel.modelingPattern: [ #ANALYTICAL_CUBE ]
@Metadata.ignorePropagatedAnnotations:true 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true
@Analytics.internalName:#LOCAL 
@ObjectModel.representativeKey: 'ReferenceInterestRate'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Reference IR - Cube'

define view I_MktDataRefIntrstRateCube 
        as select from I_ReferenceInterestRateVal            as RefIntVal
               association [1..1] to I_ReferenceInterestRate as _RefInterest  on _RefInterest.ReferenceInterestRate = $projection.ReferenceInterestRate                                                                  
               association [1..1] to I_CalendarDate          as _CalendarDate on _CalendarDate.CalendarDate         = $projection.CalendarDate   
               association [0..1] to I_Currency            as _ReferenceInterestRateCurrency on $projection.currency   = _ReferenceInterestRateCurrency.Currency                 
     
        {
        
            @ObjectModel.foreignKey.association: '_RefInterest'
            key cast( RefIntVal.ReferenceInterestRate as ftr_gen_ref_interest_rate ) as ReferenceInterestRate,
            @ObjectModel.foreignKey.association: '_CalendarDate'
            key cast( RefIntVal.EffectiveDate as calendardate ) as CalendarDate,
      
            @ObjectModel.foreignKey.association: '_ReferenceInterestRateCurrency'
                RefIntVal._ReferenceInterestRate.Currency,
                RefIntVal.EffectiveInterestRate,
                _RefInterest,
                _CalendarDate,
                _ReferenceInterestRateCurrency
                
        }

Learn More