I_RefInterestRateHistory

DDL: I_REFINTERESTRATEHISTORY SQL: IREFINTRATEHIST Type: view COMPOSITE

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.

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 Ref.int.rate
EffectiveInterestRate I_ReferenceInterestRateVal EffectiveInterestRate Interest Rate
_ReferenceInterestRate I_ReferenceInterestRateVal _ReferenceInterestRate
KeyDate TermKeyDate KeyDate Maturity Key Date
ReportingPeriod TermKeyDate CreditLineReportingPeriod

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_RefInterestRateHistory.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IREFINTRATEHIST
-- Parameters: P_KeyDate : vdm_v_key_date, P_ReportingPeriod : ftr_date_granularity

CREATE VIEW I_RefInterestRateHistory AS
SELECT
  ReferenceInterestRate.ReferenceInterestRate AS ReferenceInterestRate,
  ReferenceInterestRate.EffectiveInterestRate AS EffectiveInterestRate,
  ReferenceInterestRate._ReferenceInterestRate AS _ReferenceInterestRate,
  TermKeyDate.KeyDate AS KeyDate,
  TermKeyDate.CreditLineReportingPeriod AS ReportingPeriod
FROM P_IRM_REFINT_HIST_KEYDATE
INNER JOIN I_ReferenceInterestRateVal AS ReferenceInterestRate ON /* join condition not captured in parsed metadata */
;