The ACMCTECOLNAME table in SAP ERP or S/4HANA stores ACM: CTE column names (fieldnames/pathnames) data. There are total 14 fields in ACMCTECOLNAME table. The ACM: CTE column names (fieldnames/pathnames) 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 ACMCTECOLNAME 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 ACMCTECOLNAME Table Fields
Following is the list of fields that are available in SAP ACMCTECOLNAME table. The primary key fields of the table are ID (ACM: UUID of a CTE-columnname entry).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| ID | ACM: UUID of a CTE-columnname entry | ACM_CTECOLNAME_ID | RAW (16) | |
| CTE_ID | ACM: UUID of a CTE entry | ACM_CTE_ID | RAW (16) | |
| CTE_FIELDNAME | ACM: Name of a CTE field | ACM_CTE_FIELDNAME | CHAR (30) | |
| IS_FIELD | ACM: Field belongs to the protected entity (no path) | ACM_IS_FIELD | CHAR (1) | |
| COLNAME_TYPE | ACM: Type of a CTE Column-name | ACM_CTE_COLNAMETYPE | CHAR (9) | |
| ENTITY_NAME | ACM: Name of an CDS Entity | ACM_ENTITY_ID | CHAR (30) | |
| ENTITY_FIELDNAME | ACM: Field Name | ACM_FIELD_NAME | CHAR (30) | |
| ENTITY_PARAMNAME | ACM: Name of an (Entity) Parameter | ACM_PARAMETER_NAME | CHAR (30) | |
| LITERAL_LEFTSIDE | ACM: Value of a literal on the left side of a condition | ACM_LITERAL_LEFTSIDE | SSTR (250) | |
| DDIC_DATATYPE | Data Type in ABAP Dictionary | DATATYPE_D | CHAR (4) | |
| DDIC_LENG | Length (No. of Characters) | DDLENG | NUMC (6) | |
| DDIC_DECIMALS | Number of Decimal Places | DECIMALS | NUMC (6) | |
| MAPPINGDETAIL_ID | ACM: Mapping-Detail ID | ACM_MAPPINGDETAIL_ID | RAW (16) | |
| MAPPINGOUTPUT_ID | ACM: Mapping-Output ID | ACM_MAPPINGOUTPUT_ID | RAW (16) |
