ACMCTECOLNAME

Transparent Table System Table (transport)
23 Fields 11 CDS Views

ACM: CTE column names (fieldnames/pathnames)

ACMCTECOLNAME is an SAP database table in S/4HANA. ACM: CTE column names (fieldnames/pathnames). It contains 23 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
ACM_DT_DEPENDENCIES_CELL view left_outer ACM DT-Dependencies for cell-based access
acm_dt_dependencies_cte view left_outer ACM DT-Dependencies
ACM_DT_DEPENDENCIES_HIERAR_CTE view inner ACM DT-Dependencies of Hierarchy-Objects
ACM_DT_DEPENDENCIES_ROW view left_outer ACM DT-Dependencies for row-based access
SACMDT_ACCESSRELEVANTELEMENT view inner Access Relevant Elements of a Resource
sacmdt_role_and_its_aspects view left_outer Aspect/aspect-related DT data for a role
SACMRT_ACCESSRELEVANTELEMENT view inner Access Relevant Elements of a Resource
SACMRT_PFCG_HIERARCHY_MAPPING view_entity left_outer ACM RT: PFCG Hierarchy Mapping
SACMRT_PFCG_MAPPING_AUTH_QUERY view_entity inner ACM RT: PFCG-Mapping for Auth Query
SACMRTGEN_DTTABLES_VIEW view left_outer ACM Runtime-Generator - Get DT entries (row-based)
SACMRTGEN_DTTABLES_VIEW_CBA view left_outer ACM Runtime-Generator - Get DT entries (cell-based)

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY id acm_ctecolname_id Column Name ID
cte_id acm_cte_id CTE ID
cte_fieldname acm_cte_fieldname Field Name
is_field acm_is_field Is Field
colname_type acm_cte_colnametype Column Name Type
column_canon_dcl acm_column_sstring Column Content
column_canon_dcl_extuse acm_column_string_extuse Use Extent
column_canon_dcl_extent acm_column_string_extent Column Content
column_canon_osql acm_column_sstring Column Content
column_canon_osql_extuse acm_column_string_extuse Use Extent
column_canon_osql_extent acm_column_string_extent Column Content
path_cardinality abap.int4 ***DEPRECATED:
entity_name acm_entity_id CDS Entity Name
entity_fieldname acm_field_name Field Name
entity_paramname acm_parameter_name Parameter
sessionvar_name acm_sessionvar_name Sess. Variable
literal_leftside acm_literal_leftside Value
dclfunction_name acm_dclfunction_name Function
ddic_datatype abap.char ***DEPRECATED:
ddic_leng abap.numc ***DEPRECATED:
ddic_decimals abap.numc ***DEPRECATED:
mappingdetail_id acm_mappingdetail_id Detail ID
mappingoutput_id acm_mappingoutput_id Output ID

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- ACM: CTE column names (fieldnames/pathnames)
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMCTECOLNAME (
    ID,                        -- Column Name ID [acm_ctecolname_id]
    CTE_ID,                    -- CTE ID [acm_cte_id]
    CTE_FIELDNAME,             -- Field Name [acm_cte_fieldname]
    IS_FIELD,                  -- Is Field [acm_is_field]
    COLNAME_TYPE,              -- Column Name Type [acm_cte_colnametype]
    COLUMN_CANON_DCL,          -- Column Content [acm_column_sstring]
    COLUMN_CANON_DCL_EXTUSE,   -- Use Extent [acm_column_string_extuse]
    COLUMN_CANON_DCL_EXTENT,   -- Column Content [acm_column_string_extent]
    COLUMN_CANON_OSQL,         -- Column Content [acm_column_sstring]
    COLUMN_CANON_OSQL_EXTUSE,  -- Use Extent [acm_column_string_extuse]
    COLUMN_CANON_OSQL_EXTENT,  -- Column Content [acm_column_string_extent]
    PATH_CARDINALITY,          -- ***DEPRECATED: [abap.int4]
    ENTITY_NAME,               -- CDS Entity Name [acm_entity_id]
    ENTITY_FIELDNAME,          -- Field Name [acm_field_name]
    ENTITY_PARAMNAME,          -- Parameter [acm_parameter_name]
    SESSIONVAR_NAME,           -- Sess. Variable [acm_sessionvar_name]
    LITERAL_LEFTSIDE,          -- Value [acm_literal_leftside]
    DCLFUNCTION_NAME,          -- Function [acm_dclfunction_name]
    DDIC_DATATYPE,             -- ***DEPRECATED: [abap.char]
    DDIC_LENG,                 -- ***DEPRECATED: [abap.numc]
    DDIC_DECIMALS,             -- ***DEPRECATED: [abap.numc]
    MAPPINGDETAIL_ID,          -- Detail ID [acm_mappingdetail_id]
    MAPPINGOUTPUT_ID,          -- Output ID [acm_mappingoutput_id]
    PRIMARY KEY (ID)
);

Learn More