P_MDREFINTCALDATE

CDS View

P_MDREFINTCALDATE is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MDRefInt view from COMPOSITE 
@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

  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"I_REFERENCEINTERESTRATEVAL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More