P_MDRefInt

DDL: P_MDREFINT SQL: PMDREFRATE Type: view COMPOSITE Package: FTR_MDM_CORE

Market Data: Reference Interest Rate

P_MDRefInt is a Composite CDS View that provides data about "Market Data: Reference Interest Rate" in SAP S/4HANA. It reads from 2 data sources (P_MDRefIntCalDate, I_ReferenceInterestRateVal) and exposes 5 fields with key fields ReferenceInterestRate, CalendarDate. Part of development package FTR_MDM_CORE.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
P_MDRefIntCalDate P_MDRefIntCalDate from
I_ReferenceInterestRateVal RefIntVal left_outer

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMDREFRATE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #B view
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ReferenceInterestRate RefInt ReferenceInterestRate
KEY CalendarDate RefInt CalendarDate
Currency
EffectiveDate RefInt EffectiveDate
EffectiveInterestRate I_ReferenceInterestRateVal EffectiveInterestRate 
@AbapCatalog.sqlViewName: 'PMDREFRATE'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.serviceQuality: #B
@VDM.private:true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_MDRefInt
    with parameters
        @Environment.systemField: #SYSTEM_DATE
        P_KeyDate          : vdm_v_key_date
        as select from P_MDRefIntCalDate ( P_KeyDate : $parameters.P_KeyDate ) as RefInt
                                   left outer join I_ReferenceInterestRateVal  as RefIntVal
                                                on RefInt.ReferenceInterestRate = RefIntVal.ReferenceInterestRate                                                             
        {
            key RefInt.ReferenceInterestRate,
            key RefInt.CalendarDate,
               
                RefIntVal._ReferenceInterestRate.Currency,
                RefInt.EffectiveDate,
                RefIntVal.EffectiveInterestRate 
        } where RefInt.EffectiveDate = RefIntVal.EffectiveDate

Learn More