I_REFERENCEINTERESTRATEVAL
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA