AQS_ELEMENT

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

Custom Analytical Projection View Field

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CAQS_ELEMENT view_entity from Custom Query Element Entity

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY view_name ddlname DDL Source Name
KEY version_state r3state Program Status
KEY field_name aqs_field_name
expression_value aqs_expression_value
field_category aqs_field_category
next_field_name aqs_field_name
virt_field_name aqs_field_name
virt_datatype aqs_data_type
virt_decimal_val aqs_decimals
virt_dt_length aqs_data_length
filter_type aqs_filter_type
cast_dtype aqs_cast_dtype

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_ELEMENT (
    VIEW_NAME,         -- DDL Source Name [ddlname]
    VERSION_STATE,     -- Program Status [r3state]
    FIELD_NAME,        -- aqs_field_name
    EXPRESSION_VALUE,  -- aqs_expression_value
    FIELD_CATEGORY,    -- aqs_field_category
    NEXT_FIELD_NAME,   -- aqs_field_name
    VIRT_FIELD_NAME,   -- aqs_field_name
    VIRT_DATATYPE,     -- aqs_data_type
    VIRT_DECIMAL_VAL,  -- aqs_decimals
    VIRT_DT_LENGTH,    -- aqs_data_length
    FILTER_TYPE,       -- aqs_filter_type
    CAST_DTYPE,        -- aqs_cast_dtype
    PRIMARY KEY (VIEW_NAME, VERSION_STATE, FIELD_NAME)
);

Learn More