P_MDRefIntCalDate

DDL: P_MDREFINTCALDATE SQL: PMDREFINTCALDATE Type: view COMPOSITE Package: FTR_MDM_CORE

Reference Interest Rate with Calendar Date

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

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate CalendarDate from
I_ReferenceInterestRateVal RefInt left_outer

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (8)

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

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ReferenceInterestRate I_ReferenceInterestRateVal ReferenceInterestRate
KEY CalendarDate I_CalendarDate CalendarDate
EffectiveDate 
@AbapCatalog.sqlViewName: 'PMDREFINTCALDATE'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true
@ObjectModel.usageType.serviceQuality: #B
define view P_MDRefIntCalDate 
    with parameters
        @Environment.systemField: #SYSTEM_DATE
        P_KeyDate          : vdm_v_key_date
        as select from I_CalendarDate               as CalendarDate
         left outer join I_ReferenceInterestRateVal as RefInt
                       on CalendarDate.CalendarDate >= RefInt.EffectiveDate
                       
    {
        key RefInt.ReferenceInterestRate,
        key CalendarDate.CalendarDate,

            max ( RefInt.EffectiveDate) as EffectiveDate
    }
    where
            CalendarDate.CalendarDate <= $parameters.P_KeyDate
        and CalendarDate.CalendarDate >= DATS_ADD_MONTHS($parameters.P_KeyDate, - 13, 'NULL')
    group by 
            RefInt.ReferenceInterestRate,
            CalendarDate.CalendarDate

Learn More