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 Field Name
KEY field_name AQS_FIELD_NAME Field Name
KEY field_alias AQS_FIELD_NAME Field Name
expression_value AQS_EXPRESSION_VALUE Expression Value
field_category AQS_FIELD_CATEGORY Field Category
reference_element AQS_FIELD_NAME 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,    -- Field Name [AQS_ASSOC_NAME]
    FIELD_NAME,         -- Field Name [AQS_FIELD_NAME]
    FIELD_ALIAS,        -- Field Name [AQS_FIELD_NAME]
    EXPRESSION_VALUE,   -- Expression Value [AQS_EXPRESSION_VALUE]
    FIELD_CATEGORY,     -- Field Category [AQS_FIELD_CATEGORY]
    REFERENCE_ELEMENT,  -- Field Name [AQS_FIELD_NAME]
    PRIMARY KEY (VIEW_NAME, VERSION_STATE, BASE_ASSOC_NAME, FIELD_NAME, FIELD_ALIAS)
);

Learn More