ACMRULE

Transparent Table System Table (transport)
12 Fields 15 CDS Views

ACM: Rule Persistence

ACMRULE is an SAP database table in S/4HANA. ACM: Rule Persistence. It contains 12 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
ACM_DT_DEPENDENCIES view inner ACM: Designtime-Dependencies of DCL-Objects
ACM_DT_DEPENDENCIES_CELL view inner ACM DT-Dependencies for cell-based access
acm_dt_dependencies_cte view inner ACM DT-Dependencies
ACM_DT_DEPENDENCIES_HIERAR_CTE view inner ACM DT-Dependencies of Hierarchy-Objects
ACM_DT_DEPENDENCIES_ROW view inner ACM DT-Dependencies for row-based access
ACM_ROLES_MAXINHERITANCEDEPTH view from ACM - Roles max. inheritance depth
ACM_USED_ACCONDITIONS view inner Used ACConditions within a Role/Rule/DTCondition
ACM_USED_DTCONDITIONS view inner Used DTConditions within a Role/Rule
ACMDT_INHERITANCE_CHAIN view inner ACM-DT: Rules,Roles+DCLs inheriting from each other
SACMDT_ACCESSCTRLD_CDSENTITIES view union Access Controlled CDS entities in ACM
sacmdt_role_and_its_aspects view inner Aspect/aspect-related DT data for a role
SACMRT2DT_VIEW view inner ACM RT: Links between RT+DT entries
SACMRT2DT_VIEW view union ACM RT: Links between RT+DT entries
SACMRTGEN_DTTABLES_VIEW view from ACM Runtime-Generator - Get DT entries (row-based)
SACMRTGEN_DTTABLES_VIEW_CBA view from ACM Runtime-Generator - Get DT entries (cell-based)

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY id acm_rule_id Rule ID
roleid acm_role_id Role ID
rulepos acm_sequence_number Position
acm_resotype acm_resource_type Reso. Type
acm_resource acm_resource Resource
acm_operation acm_operation Operation
effect acm_rule_effect Effect
combination_mode acm_rule_combination_mode Combination
definition_status acm_rule_definition_status Definition
acauthview_for_funcrule abap.raw ***DEPRECATED:
rule_hash acm_rule_hash Rule Hash
expression_canon acm_expression_in_dcl Expression

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.

-- ACM: Rule Persistence
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMRULE (
    ID,                       -- Rule ID [acm_rule_id]
    ROLEID,                   -- Role ID [acm_role_id]
    RULEPOS,                  -- Position [acm_sequence_number]
    ACM_RESOTYPE,             -- Reso. Type [acm_resource_type]
    ACM_RESOURCE,             -- Resource [acm_resource]
    ACM_OPERATION,            -- Operation [acm_operation]
    EFFECT,                   -- Effect [acm_rule_effect]
    COMBINATION_MODE,         -- Combination [acm_rule_combination_mode]
    DEFINITION_STATUS,        -- Definition [acm_rule_definition_status]
    ACAUTHVIEW_FOR_FUNCRULE,  -- ***DEPRECATED: [abap.raw]
    RULE_HASH,                -- Rule Hash [acm_rule_hash]
    EXPRESSION_CANON,         -- Expression [acm_expression_in_dcl]
    PRIMARY KEY (ID)
);

Learn More