I_IL_INDEXVALUESADDITIONALINFO

CDS View
10 Fields 2 CDS Views

Additional attributes for indexes

I_IL_INDEXVALUESADDITIONALINFO is a CDS View in S/4HANA. Additional attributes for indexes. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_IL_IndexValuesPrev123Month view_entity from COMPOSITE Index value for 1 and 2 and 3 month back
I_IL_IndexValuesPrev123Month view_entity inner COMPOSITE Index value for 1 and 2 and 3 month back

Fields (10)

KeyField CDS FieldsUsed in Views
KEY IL_InfltnAdjIdxDateValValdFrom IL_InfltnAdjIdxDateValValdFrom 1
KEY IL_InfltnAdjustmentIndexId IL_InfltnAdjustmentIndexId 1
IL_IdxValueValidFromFormatDate IL_IdxValueValidFromFormatDate 1
IL_IdxValValdForPrev1MonthDate IL_IdxValValdForPrev1MonthDate 1
IL_IdxValValdForPrev2MonthDate IL_IdxValValdForPrev2MonthDate 1
IL_IdxValValdForPrev3MonthDate IL_IdxValValdForPrev3MonthDate 1
IL_IndexDateYearMonth IL_IndexDateYearMonth 1
IL_IndexFinAdjustmentFactor IL_IndexFinAdjustmentFactor 1
IL_InfltnAdjustmentIndexStatus IL_InfltnAdjustmentIndexStatus 1
IL_InfltnAdjustmentIndexValue IL_IndexCurrentPeriodValue,IL_IndexForPrevious1MonthValue,IL_IndexForPrevious2MonthValue,IL_IndexForPrevious3MonthValue 1

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.

-- Additional attributes for indexes
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_IL_INDEXVALUESADDITIONALINFO (
    IL_INFLTNADJIDXDATEVALVALDFROM,
    IL_INFLTNADJUSTMENTINDEXID,
    IL_IDXVALUEVALIDFROMFORMATDATE,
    IL_IDXVALVALDFORPREV1MONTHDATE,
    IL_IDXVALVALDFORPREV2MONTHDATE,
    IL_IDXVALVALDFORPREV3MONTHDATE,
    IL_INDEXDATEYEARMONTH,
    IL_INDEXFINADJUSTMENTFACTOR,
    IL_INFLTNADJUSTMENTINDEXSTATUS,
    IL_INFLTNADJUSTMENTINDEXVALUE,
    PRIMARY KEY (IL_INFLTNADJIDXDATEVALVALDFROM, IL_INFLTNADJUSTMENTINDEXID)
);

Learn More