AQS_ASSOC_ELEM

Transparent Table System Table (transport)
8 Fields 1 CDS Views

Custom Analytical Projection View Field

AQS_ASSOC_ELEM is an SAP database table in S/4HANA. Custom Analytical Projection View Field. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CAQS_ASSOC_ELEM view_entity from Custom Query Element Entity

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY view_name ddlname DDL Source Name
KEY version_state r3state Program Status
KEY base_assoc_name aqs_assoc_name
KEY field_name aqs_field_name
KEY field_alias aqs_field_name
expression_value aqs_expression_value
field_category aqs_field_category
reference_element aqs_field_name

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.

-- Custom Analytical Projection View Field
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AQS_ASSOC_ELEM (
    VIEW_NAME,          -- DDL Source Name [ddlname]
    VERSION_STATE,      -- Program Status [r3state]
    BASE_ASSOC_NAME,    -- aqs_assoc_name
    FIELD_NAME,         -- aqs_field_name
    FIELD_ALIAS,        -- aqs_field_name
    EXPRESSION_VALUE,   -- aqs_expression_value
    FIELD_CATEGORY,     -- aqs_field_category
    REFERENCE_ELEMENT,  -- aqs_field_name
    PRIMARY KEY (VIEW_NAME, VERSION_STATE, BASE_ASSOC_NAME, FIELD_NAME, FIELD_ALIAS)
);

Learn More