ACMCTECOLVALUE

Transparent Table System Table (transport)
14 Fields 7 CDS Views

ACM: CTE column values

ACMCTECOLVALUE is an SAP database table in S/4HANA. ACM: CTE column values. It contains 14 fields. 7 CDS views read from this table.

CDS Views using this table (7)

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
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 (14)

KeyField Data ElementDescription DomainTypeLength
KEY id acm_ctecolvalue_id Column Value ID
accondition_id acm_condition_id Condition ID
pos acm_sequence_number Position
colname_id acm_ctecolname_id Column Name ID
value_type acm_value_type
comp_oper abap.char ***DEPRECATED:
aspect_id abap.raw ***DEPRECATED:
bypass_operator acm_comparison_operator Comp. Operator
optional_element_operator acm_comparison_operator Comp. Operator
value_literal acm_value_literal Value
value_literal_to acm_value_literal Value
escape_character acm_escape_character Escape Char.
value_name acm_value_name
colmap_ctecolname_id acm_ctecolname_id Column Name 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 values
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMCTECOLVALUE (
    ID,                         -- Column Value ID [acm_ctecolvalue_id]
    ACCONDITION_ID,             -- Condition ID [acm_condition_id]
    POS,                        -- Position [acm_sequence_number]
    COLNAME_ID,                 -- Column Name ID [acm_ctecolname_id]
    VALUE_TYPE,                 -- acm_value_type
    COMP_OPER,                  -- ***DEPRECATED: [abap.char]
    ASPECT_ID,                  -- ***DEPRECATED: [abap.raw]
    BYPASS_OPERATOR,            -- Comp. Operator [acm_comparison_operator]
    OPTIONAL_ELEMENT_OPERATOR,  -- Comp. Operator [acm_comparison_operator]
    VALUE_LITERAL,              -- Value [acm_value_literal]
    VALUE_LITERAL_TO,           -- Value [acm_value_literal]
    ESCAPE_CHARACTER,           -- Escape Char. [acm_escape_character]
    VALUE_NAME,                 -- acm_value_name
    COLMAP_CTECOLNAME_ID,       -- Column Name ID [acm_ctecolname_id]
    PRIMARY KEY (ID)
);

Learn More