I_RefInterestRateHistory

DDL: I_REFINTERESTRATEHISTORY SQL: IREFINTRATEHIST Type: view COMPOSITE Package: FTR_IRM_CORE

Reference Interest Rate History

I_RefInterestRateHistory is a Composite CDS View that provides data about "Reference Interest Rate History" in SAP S/4HANA. It reads from 2 data sources (P_IRM_REFINT_HIST_KEYDATE, I_ReferenceInterestRateVal) and exposes 5 fields. Part of development package FTR_IRM_CORE.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
P_IRM_REFINT_HIST_KEYDATE P_IRM_REFINT_HIST_KEYDATE from
I_ReferenceInterestRateVal ReferenceInterestRate inner

Parameters (2)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_ReportingPeriod ftr_date_granularity

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IREFINTRATEHIST view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Reference Interest Rate History view

Fields (5)

KeyFieldSource TableSource FieldDescription
ReferenceInterestRate I_ReferenceInterestRateVal ReferenceInterestRate
EffectiveInterestRate I_ReferenceInterestRateVal EffectiveInterestRate
_ReferenceInterestRate I_ReferenceInterestRateVal _ReferenceInterestRate
KeyDate TermKeyDate KeyDate
ReportingPeriod TermKeyDate CreditLineReportingPeriod 
@AbapCatalog.sqlViewName: 'IREFINTRATEHIST'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Reference Interest Rate History'
define view I_RefInterestRateHistory
    with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : vdm_v_key_date,
    P_ReportingPeriod  : ftr_date_granularity
    as select from P_IRM_REFINT_HIST_KEYDATE (
                   P_KeyDate : $parameters.P_KeyDate,
                   P_CalendarFrequency : $parameters.P_ReportingPeriod ) as TermKeyDate
    inner join I_ReferenceInterestRateVal as ReferenceInterestRate on  TermKeyDate.ReferenceInterestRate = ReferenceInterestRate.ReferenceInterestRate
                                                          and TermKeyDate.EffectiveDate = ReferenceInterestRate.EffectiveDate
    {
        ReferenceInterestRate.ReferenceInterestRate,
        ReferenceInterestRate.EffectiveInterestRate,
        ReferenceInterestRate._ReferenceInterestRate,
        TermKeyDate.KeyDate,
        TermKeyDate.CreditLineReportingPeriod as ReportingPeriod
    }

Learn More