ACMCTE - ACM: CTEs
ACM: CTEs information is stored in SAP table ACMCTE.
It is part of development package SACM_COMMON in software component BC-SEC-AUT-DCL. This development package consists of objects that can be grouped under "Common Objects for Access Control Management".
It is part of development package SACM_COMMON in software component BC-SEC-AUT-DCL. This development package consists of objects that can be grouped under "Common Objects for Access Control Management".
Fields for table ACMCTE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| ID | ACM: UUID of a CTE entry | X | ACM_CTE_ID | RAW | 16 | |
| NAME | ACM: Name of a CTE entry | ACM_CTE_NAME | CHAR | 60 | ||
| ENTITY_NAME | ACM: Name of an CDS Entity | ACM_ENTITY_ID | CHAR | 60 | ||
| BASEV_CTE_ID | ***DEPRECATED: | RAW | 16 | |||
| VIEW_TYPE | ACM: View-type of a CTE | ACM_CTE_VIEWTYPE | CHAR | 12 | ||
| DEFINED_AT | ACM: Definition time of a CTE | ACM_CTE_DEFINEDAT | CHAR | 4 | ||
| MERGE_TYPE | ACM: Merge-type of a CTE | ACM_CTE_MERGETYPE | CHAR | 20 | ||
| COLUMN_TYPE | ACM: Column-type of a CTE | ACM_CTE_COLUMNTYPE | CHAR | 20 | ||
| USING_DISTINCT | ACM: Flag, if the SELECT statement uses DISTINCT | ACM_USING_DISTINCT | CHAR | 2 | ||
| EXPRESSION | ACM: Expression of a CTE | ACM_CTE_EXPRESSION | STRG | 8 |