SYCMA_USG_ODATA

Transparent Table Application Table
8 Fields 1 CDS Views

Usage Data on object level

SYCMA_USG_ODATA is an SAP database table in S/4HANA. Usage Data on object level. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
sycm_aps_i_usage view_entity inner Usage aggregated for project

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY usgid SYCM_APS_USAGE_ID Usage ID
KEY roottype SYCM_APS_USAGE_ROOTTYPE Entry Point Category
KEY rootname SYCM_APS_USAGE_ROOTNAME Request Entry Point
KEY progname PROGRAM Tcode/program
KEY obj_type TROBJTYPE Object Type
KEY obj_name SOBJ_NAME Object Name
counter abap.dec
last_used abap.dats

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.

-- Usage Data on object level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SYCMA_USG_ODATA (
    USGID,      -- Usage ID [SYCM_APS_USAGE_ID]
    ROOTTYPE,   -- Entry Point Category [SYCM_APS_USAGE_ROOTTYPE]
    ROOTNAME,   -- Request Entry Point [SYCM_APS_USAGE_ROOTNAME]
    PROGNAME,   -- Tcode/program [PROGRAM]
    OBJ_TYPE,   -- Object Type [TROBJTYPE]
    OBJ_NAME,   -- Object Name [SOBJ_NAME]
    COUNTER,    -- abap.dec
    LAST_USED,  -- abap.dats
    PRIMARY KEY (USGID, ROOTTYPE, ROOTNAME, PROGNAME, OBJ_TYPE, OBJ_NAME)
);

Learn More