SYCM_SITEM_STATS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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