SAP Data Control Language (DCL) (Define Authorizations for CDS) Tables
Are you looking for the right table related to SAP Data Control Language (DCL) (Define Authorizations for CDS) Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL) module.
Top 10 tables in Data Control Language (DCL) (Define Authorizations for CDS)
| Table | Description |
|---|---|
| ACMTST_DB_AD | ACMTST: Address (DB-Table) |
| ACMTSTASPECTCOLU | ACM: Aspect Columns |
| ACMRTCOLUMN | ACM-Runtime: Column data |
| ACMACFIELD | ACM: Access-Condition Field |
| ACMHEXDB_SCARR | ACMHEX: Airlines (DBTable) |
| ACMDCLMETADATARA | ACM Metadata: Role usage of Aspects |
| ACMTSTCTE2CTE | ACMTST: CTE-to-CTE links (Expected test-results) |
| ACMRTMRCONDITION | ACM-Runtime: Restriction-Conditions (for Mapping-Roles) |
| ACMTSTRTRESTRICT | ACM-Runtime: Restrictions |
| ACMTST_DB_EMPL | ACMTST: Employee (DB-Table) |
List of tables in Data Control Language (DCL) (Define Authorizations for CDS)
| Table | Description |
|---|---|
| ACMTST_DB_AD | ACMTST: Address (DB-Table) |
| ACMTSTASPECTCOLU | ACM: Aspect Columns |
| ACMRTCOLUMN | ACM-Runtime: Column data |
| ACMACFIELD | ACM: Access-Condition Field |
| ACMHEXDB_SCARR | ACMHEX: Airlines (DBTable) |
| ACMDCLMETADATARA | ACM Metadata: Role usage of Aspects |
| ACMTSTCTE2CTE | ACMTST: CTE-to-CTE links (Expected test-results) |
| ACMRTMRCONDITION | ACM-Runtime: Restriction-Conditions (for Mapping-Roles) |
| ACMTSTRTRESTRICT | ACM-Runtime: Restrictions |
| ACMTST_DB_EMPL | ACMTST: Employee (DB-Table) |
| ACMTSTCTECOLNAME | ACMTST: CTE column names (Expected test-results) |
| ACMTST_DB_PROD | ACMTST: Product (DB-Table) |
| ACMATMRASSIGASP | ACM-Admintime: Assigned Aspects to a Mapping-Role |
| ACMHEXDB_SCURREN | ACMHEX: Currencies (DBTable) |
| ACMDCLSRC | ACM: DCL Source (Accesspolicy or Role) |
| ACMGENHIERID | ACM: Generated Hierarchies(Hierarchy-IDs) |
| ACMRTMRCONTENT | ACM-Runtime: Restrict.-Condition-Contents (for Mapping-Roles |
| ACMDCLMETADATARP | ACM Metadata: Role usage of PFCG Mappings |
| ACMHEXDB_SPFLI | ACMHEX: Flight Schedules (DBTable) |
| ACMTSTAGGREGATE | ACMTST: Aggregate (Expected test-results) |
| ACMTST_DB_BPA | ACMTST: Business Partner (DB-Table) |
| ACMDCLSRCT | ACM: DCL Source Text Table |
| ACMRTMRRESTRICT | ACM-Runtime: Restrictions (for Mapping-Roles) |
| ACMTSTCTECOLVALU | ACMTST: CTE column values (Expected test-results) |
| ACMTSTASPPFCGDET | ACMTST: PFCG_AUTH-Aspect-Details (Expected results) |
| ACMTST_DB_SO | ACMTST: Sales Order Header (DB-Table) |
| ACMTSTRTCOLUMN | ACMTST: Runtime Column data (Expected test-results) |
| ACMTSTRULE | ACMTST: Rule (Expected test-results) |
| ACMTSTASPECTPFCG | ACMTST: Dedicated PFCG_AUTH-Aspects (Expected results) |
| ACMRTRESTRICTION | ACM-Runtime: Restrictions |
| ACMASPECTVIEW | ACM: Aspect-View Persistence |
| ACMDCLMETADATAEN | ACM Metadata: Role usage of protected Entities |
| ACMCTECOLNAME | ACM: CTE column names (fieldnames/pathnames) |
| ACMPFWWORKLIST | Worklist for parallel DCL activation |
| ACMATASSIGASPECT | ACM-Admintime: Assigned Aspects to a Subj2Role entry |
| ACMDCLMETADATAIE | ACM Metadata: Role usage of inherited Entities |
| ACMCTEKEY | ACM: CTE keys |
| ACMRTHEADER | ACM-Runtime: Header data |
| ACMATMR | ACM-Admintime: Mapping-Role Assignments |
| ACMHEXDB_H4D1DIR | ACMHEX: Directory for Hierarchies-for-Dimension-1 (DBTable) |
| ACMHEXDB_H4D3DIR | ACMHEX: Directory for Hierarchy-for-Dimension-3 (DBTable) |
| ACMDCLMETADATAAS | ACM Metadata: Aspects |
| ACMHEXDB_HI4DIM2 | ACMHEX: Hierarchies for Dimension-2 (DBTable) |
| ACMRTCONDITION | ACM-Runtime: Restriction-Conditions |
| ACMPFCGMAPPING | ACM: PFCG Field Mapping (for Hierarchy Authorization) |
| ACMTSTRTMRRESTR | ACMTST: Runtime: Restrictions (for Mapping-Roles) |
| ACMHIERARDUMMY | Dummy table for hierarchy data storage NEEDED! |
| ACMTSTACFIELD | ACMTST: AC-Field (Expected test-results) |
| ACMTSTMAPPINGOUT | ACMTST: Outputs for PFCG Mapping (Expected test-results) |
| ACMCTE2CTE | ACM: CTE-to-CTE links |
| ACMCTECOLVALUE | ACM: CTE column values |
| ACMHEXDB_SCONTIN | ACMHEX: Continent (DBTable) |
| ACMTSTATMR | ACMTST: Admintime: Mapping-Role Assignments |
| ACMCTEPAR | ACM: CTE parameters |
| ACM_DTLOG | ACM: Log Table for Designtime-Artifacts |
| ACMTSTCTECONAPAR | ACMTST: CTE column name (path-)parts (Expected test-results) |
| ACMTSTRTCONDITIO | ACM-Runtime: Restriction-Conditions |
| ACMTSTASPECT | ACMTST: Aspect (Expected test-results) |
| ACMOBJSTATRESITM | ACM: Object-Status results - Item table |
| ACMATASSASPCONT | ACM-Admintime: Assigned Aspect-Values to a Subj2Role entry |
| ACMDCLMETADATAPM | ACM Metadata: PFCG Mappings |
| ACMHIERARDATADTL | ACM Hierarchy Metadata Details (DDIC information) |
| ACMENTITYSTATUS | ACM: ACM-Status of Entities |
| ACMTSTGENHIERVIE | ACMTST: Generated Hierarchy-Views |
| ACMTRACE | ACM Main Trace Table |
| ACMTSTCTEPAR | ACMTST: CTE parameters (Expected test-results) |
| ACMATDT2RTRESTR | ACM: Link-Table between AT/DT-Tables and RT-Tables |
| ACMGENHIERVIEW | ACM: Generated Hierarchy-Views |
| ACMTST_EMPL_H | ACMTST: Hierarchy for Employee (ACMTST_DB_EMPL) |
| ACMASPECTPFCG | ACM: Dedicated PFCG_AUTH-Aspects |
| ACMAGGREGATE | ACM: Aggregate for Aspect Aggregation |
| ACMRULE | ACM: Rule Persistence |
| ACM_LOCK | ACM: Lock Table for ACM |
| ACMTSTRTMRCONTEN | ACMTST: Runtime: Restrict.-Condition-Contents (Mapping-Roles |
| ACMTSTASPECTVIEW | ACMTST: Aspect-View (Expected test-results) |
| ACMTSTGENHIERID | ACMTST: Generated Hierarchies(Hierarchy-IDs) |
| ACMHIERARDATAACC | ACM: Hierarchy Metadata Details - Link to ACCondition |
| ACMHEXDB_SCOUNTR | ACMHEX: Countries (DBTable) |
| ACMTSTATASSIGASP | ACM-Admintime: Assigned Aspects to a Subj2Role entry |
| ACMTSTACCONDITIO | ACMTST: ACCondition (Expected test-results) |
| ACMASPPFCGDETAIL | ACM: Details for PFCG_AUTH-Aspects |
| ACMTSTAD2RRSTRMR | ACMTST: Link-Table betw. AT/DT- and RT-Tables (MappingRoles) |
| ACMTSTHIERARKEY | ACMTST: Hierachy View Key Fields |
| ACMNESTEDROLE | ACM: !!Misused a base-table for Protectionviews!! |
| ACMTSTCTE | ACMTST: CTEs (Expected test-results) |
| ACMTST_DB_USR2 | ACMTST: Mapping between ACMTST-User and USR02-User |
| ACMTSTPFCGMAPPIN | ACMTST: PFCG Field Mapping (for Hierarchy Authorization) |
| ACMRTCOND | ACM-Runtime: Condition data - referencing to DT-Condition |
| ACMACAUTHVIEW | ACM: Access-Condition Authorization-Views |
| ACMHEXDB_HI4DIM3 | ACMHEX: Hierarchy for Dimension-3 (DBTable) |
| ACMACAVIEWDETAIL | ACM: Access-Condition Authorization-View Details |
| ACMTSTATDT2RTRES | ACM: Link-Table between AT/DT-Tables and RT-Tables |
| ACMHIERARDATATAB | ACM Hierarchy Metadata Headerinfo |
| ACMCTE | ACM: CTEs |
| ACMASPECTCOLUMN | ACM: Aspect Columns |
| ACM_XCHG_DATA | ACM Test Handle exchange data between processes |
| ACMTSTHIERDATACC | ACMTST: Hierarchy Metadata Details - Link to ACCondition |
| ACMTSTACAUTHVIEW | ACMTST: AC-AuthorizationView (Expected test-results) |
| ACMHEXDB_HI4DIM1 | ACMHEX: Hierarchies for Dimension-1 (DBTable) |
| ACMTSTATASSASPCO | ACM-Admintime: Assigned Aspect-Values to a Subj2Role entry |
| ACMHEXDB_SCITY | ACMHEX: Cities (DBTable) |
| ACMACCONDITION | ACM: Access-Conditions (globally+reusable) |
| ACMDTCONDITION | ACM: GRANT Condition Persistence |
| ACM_DTLOGROOT | ACM: Root-Entry Log Table for Designtime-Artifacts |
| ACMDCLMETADATAIN | ACM Metadata: Role usage of inherited Roles |
| ACMATSUBJ2ROLE | ACM-Admintime: Subjects(Users) assigned to Roles |
| ACMASPECT | ACM: Aspect Definition Persistence |
| ACMTSTRAP1_T_CUS | ACMTST-RAP-1: Customer (DB-Table) |
| ACMHEXDB_SPRODUC | ACMHEX: Producers (DBTable) |
| ACMTSTRTCOND | ACMTST: Runtime Condition data (Expected test-results) |
| ACMVERSION | Versions of DCL artefacts |
| ACMTSTMAPPINGDET | ACMTST: Details for PFCG Mapping (Expected test-results) |
| ACMCTECOLNAMPART | ACM: CTE column name (path-)parts |
| ACMMAPPINGOUTPUT | ACM: Output fields of PFCG Mapping |
| ACMTSTACAVIEWDET | ACMTST: AC-AuthView-Detail (Expected test-results) |
| ACMATDT2RTRSTRMR | ACM: Link-Table between AT/DT- and RT-Tables (MappingRoles) |
| ACMTST_DB_PTXT | ACMTST: Product Texts/Descriptions (DB-Table) |
| ACMTSTATMRASSASP | ACMTST: Admintime: Assigned Aspects to a Mapping-Role |
| ACMRTCONTENT | ACM-Runtime: Restriction-Condition-Contents |
| ACMROLE | ACM: Role Persistency |
| ACMMAPPINGDETAIL | ACM: Details for PFCG Mapping |
| ACMHEXDB_SREGION | ACMHEX: Regions (DBTable) |
| ACMTSTRAP1_T_SO | ACMTST-RAP-1: Sales Order Header (DB-Table) |
| ACMHEXDB_SFLIGHT | ACMHEX: Flights (DBTable) |
| ACMHIERARCHYKEY | ACM: Hierachy View Key Fields |
| ACMTSTROLE | ACMTST: Role (Expected test-results) |
| ACMOBJSTATRESHDR | ACM: Object-Status results - Header table |
| ACMTST_ID_HASHES | ACMTST: ACMTST-ID-Hashes + their corresponding values |
| ACMHEXDB_H4D2DIR | ACMHEX: Directory for Hierarchies-for-Dimension-2 (DBTable) |
| ACMHEXDB_SPLANET | ACMHEX: Plane-Types (DBTable) |
| ACMTSTCTEKEY | ACMTST: CTE keys (Expected test-results) |
| ACMTSTRTMRCONDIT | ACMTST: Runtime: Restriction-Conditions (for Mapping-Roles) |
| ACMTSTATSUBJ2ROL | ACM-Admintime: Subjects(Users) assigned to Roles |
| ACMTSTDTCONDITIO | ACMTST: DTCondition (Expected test-results) |
| ACMTSTHIERDATDTL | ACMTST: Hierarchy Metadata Details (DDIC information) |
| ACM_OBJECT_DATA | ACM work bench object data table |
| ACMTSTHIERDATTAB | ACMTST: Hierarchy Metadata Headerinfo |
| ACMTSTRAP1_T_SOI | ACMTST-RAP-1: Sales Order Item (DB-Table) |
| ACMTST_DB_SOI | ACMTST: SalesOrder-Item (DB-Table) |
| ACMTST_LOG | ACMTST: Log-Table (also used for Locking!) |
| ACMTSTRTCONTENT | ACM-Runtime: Restriction-Condition-Contents |
| ACMTSTRTHEADER | ACMTST: Runtime Header data (Expected test-results) |
| ACMTST_EMPL_HD | ACMTST: Hierarchy directory for Employee (ACMTST_DB_EMPL) |
| ACMDCLMETADATA | ACM Metadata: DCL Source |