SYCM_API_CACHE

Transparent Table Application Table
9 Fields 2 CDS Views

Cache for APIs

SYCM_API_CACHE is an SAP database table in S/4HANA. Cache for APIs. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
sycm_apis_c_scsr view_entity from CDS view for classic api with successors
sycm_apis_r_scsr view_entity from CDS view for release api with successors

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY api_id GUID GUID
KEY file_id GUID GUID
KEY tadir_object TROBJTYPE Object Type
KEY tadir_obj_name SOBJ_NAME Object Name
object_type ARS_SUB_OBJECT_TYPE Subobject Type
object_key ARS_SUB_OBJECT_NAME Subobject Name
software_component DLVUNIT Softw. Comp.
application_component UFPS_POSID Applic. Component
state SYCM_API_STATE State

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.

-- Cache for APIs
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SYCM_API_CACHE (
    API_ID,                 -- GUID [GUID]
    FILE_ID,                -- GUID [GUID]
    TADIR_OBJECT,           -- Object Type [TROBJTYPE]
    TADIR_OBJ_NAME,         -- Object Name [SOBJ_NAME]
    OBJECT_TYPE,            -- Subobject Type [ARS_SUB_OBJECT_TYPE]
    OBJECT_KEY,             -- Subobject Name [ARS_SUB_OBJECT_NAME]
    SOFTWARE_COMPONENT,     -- Softw. Comp. [DLVUNIT]
    APPLICATION_COMPONENT,  -- Applic. Component [UFPS_POSID]
    STATE,                  -- State [SYCM_API_STATE]
    PRIMARY KEY (API_ID, FILE_ID, TADIR_OBJECT, TADIR_OBJ_NAME)
);

Learn More