ILMA_SNAPSHOT

Transparent Table Temporary Data

ILM Provider Memory Footprint Snapshot

ILMA_SNAPSHOT is an SAP database table in S/4HANA. ILM Provider Memory Footprint Snapshot. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ILMAdvrMemorySnapshot view_entity left_outer ILM Advisor Memory Snapshot

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY provider_id ilma_provider_id Provider ID
KEY snapshot_month ilma_snapshot_month SnapShot Month
KEY ilma_snapshot_date ilma_snapshot_date Snapshot Date
ilma_records ilma_record Record Count
ilma_size ilma_size ILM Object Size
ilma_totsize_ratio ilma_totsize_ratio Object Table Ratio

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.

-- ILM Provider Memory Footprint Snapshot
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ILMA_SNAPSHOT (
    MANDT,               -- Client [mandt]
    PROVIDER_ID,         -- Provider ID [ilma_provider_id]
    SNAPSHOT_MONTH,      -- SnapShot Month [ilma_snapshot_month]
    ILMA_SNAPSHOT_DATE,  -- Snapshot Date [ilma_snapshot_date]
    ILMA_RECORDS,        -- Record Count [ilma_record]
    ILMA_SIZE,           -- ILM Object Size [ilma_size]
    ILMA_TOTSIZE_RATIO,  -- Object Table Ratio [ilma_totsize_ratio]
    PRIMARY KEY (MANDT, PROVIDER_ID, SNAPSHOT_MONTH, ILMA_SNAPSHOT_DATE)
);