SYCMA_USG_DATA

Transparent Table Application Table
10 Fields 1 CDS Views

Usage Data on procedure level

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
sycm_aps_i_usage_by_procedure view inner Usage aggregated for project

Fields (10)

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
KEY sub_type TROBJTYPE Object Type
KEY sub_name SOBJ_SNAME Object name in SUBKEY
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 procedure level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SYCMA_USG_DATA (
    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]
    SUB_TYPE,   -- Object Type [TROBJTYPE]
    SUB_NAME,   -- Object name in SUBKEY [SOBJ_SNAME]
    COUNTER,    -- abap.dec
    LAST_USED,  -- abap.dats
    PRIMARY KEY (USGID, ROOTTYPE, ROOTNAME, PROGNAME, OBJ_TYPE, OBJ_NAME, SUB_TYPE, SUB_NAME)
);

Learn More