SYCM_SITEM_STATS

Transparent Table System Table (transport)

States of a simplification item

SYCM_SITEM_STATS is an SAP database table in S/4HANA. States of a simplification item. It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Sycm_Code_Inspector_Content view inner Content for Code inspector
SYCM_PLIST_OBJS_SUBOBJS view inner Subobjects with Item, PieceList
SYCM_PLIST_OBJS_SUBOBJS_WHU view inner Objects and subobjects where used check
Sycm_S_Item_Status view from Status assigned to a Simplification Item

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY id guid_32 GUID 16
KEY version sycm_sitem_version Version of a simplification item
KEY state sycm_sitem_state Category
software_component dlvunit Softw. Comp.
release_from saprelease SAP Release
patch_level_from sappatchlv SP Level
release_to saprelease SAP Release
patch_level_to sappatchlv SP Level

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.

-- States of a simplification item
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SYCM_SITEM_STATS (
    ID,                  -- GUID 16 [guid_32]
    VERSION,             -- Version of a simplification item [sycm_sitem_version]
    STATE,               -- Category [sycm_sitem_state]
    SOFTWARE_COMPONENT,  -- Softw. Comp. [dlvunit]
    RELEASE_FROM,        -- SAP Release [saprelease]
    PATCH_LEVEL_FROM,    -- SP Level [sappatchlv]
    RELEASE_TO,          -- SAP Release [saprelease]
    PATCH_LEVEL_TO,      -- SP Level [sappatchlv]
    PRIMARY KEY (ID, VERSION, STATE)
);