I_REFERENCEINTERESTRATEVAL

CDS View

Reference Interest Rate Value

I_REFERENCEINTERESTRATEVAL is a CDS View in S/4HANA. Reference Interest Rate Value. It contains 4 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_EffectiveInterestRate view from COMPOSITE Effective Interest Rate
I_MktDataRefIntrstRateCube view from COMPOSITE Reference IR - Cube
I_RefInterestRateHistory view inner COMPOSITE Reference Interest Rate History
P_IRM_IR_Effective_Date view from COMPOSITE
P_IRM_IR_Pre_Effective_Date view left_outer COMPOSITE
P_IRM_REFINT_HIST_KEYDATE view left_outer COMPOSITE
P_MDRefInt view left_outer COMPOSITE
P_MDRefIntCalDate view left_outer COMPOSITE
P_PreEffectiveInterestRate view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ReferenceInterestRate ReferenceInterestRate 6
_ReferenceInterestRate _ReferenceInterestRate 5
EffectiveDate EffectiveDate 2
EffectiveInterestRate EffectiveInterestRate 5

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Reference Interest Rate Value
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_REFERENCEINTERESTRATEVAL (
    REFERENCEINTERESTRATE,
    _REFERENCEINTERESTRATE,
    EFFECTIVEDATE,
    EFFECTIVEINTERESTRATE,
    PRIMARY KEY (REFERENCEINTERESTRATE)
);