ACO_ROLE

Transparent Table Application Table
7 Fields 3 CDS Views

Object-Related Authorizations for a Role

ACO_ROLE is an SAP database table in S/4HANA. Object-Related Authorizations for a Role. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PPM_AuthznByUserRoleH view from BASIC Project Authorizations by User Role
P_PPM_AuthorizationByUserRole view from BASIC
P_PPM_LocalAuthorizations view union BASIC

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY id ACO_AUTHORITY_ID Authorization ID
role_id ACO_ROLE_ID Role ID
object_id ACO_OBJECT_ID Object ID
top_node_id ACO_TOP_ID Highest Node
activity ACO_ACTVT Activity
type ACO_OBJECT_TYPE Object Category

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.

-- Object-Related Authorizations for a Role
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACO_ROLE (
    CLIENT,       -- Client [MANDT]
    ID,           -- Authorization ID [ACO_AUTHORITY_ID]
    ROLE_ID,      -- Role ID [ACO_ROLE_ID]
    OBJECT_ID,    -- Object ID [ACO_OBJECT_ID]
    TOP_NODE_ID,  -- Highest Node [ACO_TOP_ID]
    ACTIVITY,     -- Activity [ACO_ACTVT]
    TYPE,         -- Object Category [ACO_OBJECT_TYPE]
    PRIMARY KEY (CLIENT, ID)
);

Learn More