SYCMA_USG_DATA

Transparent Table Application Table

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)
);