The ACMCTE table in SAP ERP or S/4HANA stores ACM: CTEs data. There are total 8 fields in ACMCTE table. The ACM: CTEs table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ACMCTE table. It is in Common Objects for Access Control Management (SACM_COMMON) ABAP package and is part of the Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL) module.
SAP ACMCTE Table Fields
Following is the list of fields that are available in SAP ACMCTE table. The primary key fields of the table are ID (ACM: UUID of a CTE entry).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| ID | ACM: UUID of a CTE entry | ACM_CTE_ID | RAW (16) | |
| ENTITY_NAME | ACM: Name of an CDS Entity | ACM_ENTITY_ID | CHAR (30) | |
| BASEV_CTE_ID | ACM: UUID of a CTE entry | ACM_CTE_ID | RAW (16) | |
| VIEW_TYPE | ACM: View-type of a CTE | ACM_CTE_VIEWTYPE | CHAR (6) | |
| DEFINED_AT | ACM: Definition time of a CTE | ACM_CTE_DEFINEDAT | CHAR (2) | |
| MERGE_TYPE | ACM: Merge-type of a CTE | ACM_CTE_MERGETYPE | CHAR (10) | |
| COLUMN_TYPE | ACM: Column-type of a CTE | ACM_CTE_COLUMNTYPE | CHAR (10) | |
| USING_DISTINCT | ACM: Flag, if the SELECT statement uses DISTINCT | ACM_USING_DISTINCT | CHAR (1) |
