I_CAQS_ASSOC_ELEM

DDL: I_CAQS_ASSOC_ELEM Type: view_entity
9 Fields 1 Data Sources

Custom Query Element Entity

I_CAQS_ASSOC_ELEM is a CDS View that provides data about "Custom Query Element Entity" in SAP S/4HANA. It reads from 1 data source (aqs_assoc_elem) and exposes 9 fields with key fields ViewName, VersionState, BaseAssocName, FieldName, FieldAlias.

Data Sources (1)

SourceAliasJoin Type
aqs_assoc_elem aqs_assoc_elem from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Custom Query Element Entity view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ViewName view_name View Name
KEY VersionState version_state Version state
KEY BaseAssocName base_assoc_name
KEY FieldName field_name VAT Declaration Fld
KEY FieldAlias field_alias
ExpressionValue expression_value
FieldCategory field_category Field category
ReferenceElement reference_element
_view_root _view_root

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CAQS_ASSOC_ELEM.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CAQS_ASSOC_ELEM AS
SELECT
  view_name AS ViewName,
  version_state AS VersionState,
  base_assoc_name AS BaseAssocName,
  field_name AS FieldName,
  field_alias AS FieldAlias,
  expression_value AS ExpressionValue,
  field_category AS FieldCategory,
  reference_element AS ReferenceElement
FROM aqs_assoc_elem
;

Learn More