SAP ACMCTE ACM: CTEs Table

Overview

ACMCTE is a standard SAP S/4HANA table that stores ACM: CTEs data. There are total 8 fields in the ACMCTE table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ACMCTE belongs to Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL) module and is located in the package Common Objects for Access Control Management (SACM_COMMON).

In addition, following links provide an overview of foreign key relationships, if any, that link ACMCTE to other SAP tables and standard CDS views available based on ACMCTE table in S/4HANA 2020.

Techincal Settings of ACMCTE

Below are technical details of the table ACMCTE

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ACMCTE Fields

The following table gives you an overview of the fields available in ACMCTE

FieldDescriptionData ElementCheck TableData TypeLength
IDACM: UUID of a CTE entryACM_CTE_IDRAW16
ENTITY_NAMEACM: Name of an CDS EntityACM_ENTITY_IDCHAR30
BASEV_CTE_IDACM: UUID of a CTE entryACM_CTE_IDRAW16
VIEW_TYPEACM: View-type of a CTEACM_CTE_VIEWTYPECHAR6
DEFINED_ATACM: Definition time of a CTEACM_CTE_DEFINEDATCHAR2
MERGE_TYPEACM: Merge-type of a CTEACM_CTE_MERGETYPECHAR10
COLUMN_TYPEACM: Column-type of a CTEACM_CTE_COLUMNTYPECHAR10
USING_DISTINCTACM: Flag, if the SELECT statement uses DISTINCTACM_USING_DISTINCTCHAR1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACMCTE

Other References