I_CAQS_ELEMENT

DDL: I_CAQS_ELEMENT Type: view_entity Package: RS_AQS_RAP
14 Fields 1 Data Sources 3 Associations

Custom Query Element Entity

I_CAQS_ELEMENT is a CDS View that provides data about "Custom Query Element Entity" in SAP S/4HANA. It reads from 1 data source (aqs_element) and exposes 14 fields with key fields ViewName, VersionState, FieldName. It has 3 associations to related views. Part of development package RS_AQS_RAP.

Data Sources (1)

SourceAliasJoin Type
aqs_element aqs_element from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_CAQS_E_ANNOTATION _element_anno
[1..*] I_CAQS_FILTER_LIST _filter_list
[1..*] I_CAQS_EXP_RESTRICTION _restriction

Annotations (2)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ViewName view_name View Name
KEY VersionState version_state Version state
KEY FieldName field_name VAT Declaration Fld
ExpressionValue expression_value
FieldCategory field_category Field category
NextFieldName next_field_name
VirtualField virt_field_name
VirtualDatatype virt_datatype
VirtualDataLength virt_dt_length
VirtualDecimalVal virt_decimal_val
FilterType filter_type
_filter_list _filter_list
_restriction _restriction
_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_ELEMENT.
-- 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_ELEMENT AS
SELECT
  view_name AS ViewName,
  version_state AS VersionState,
  field_name AS FieldName,
  expression_value AS ExpressionValue,
  field_category AS FieldCategory,
  next_field_name AS NextFieldName,
  virt_field_name AS VirtualField,
  virt_datatype AS VirtualDatatype,
  virt_dt_length AS VirtualDataLength,
  virt_decimal_val AS VirtualDecimalVal,
  filter_type AS FilterType
FROM aqs_element
LEFT OUTER JOIN I_CAQS_E_ANNOTATION AS _element_anno ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_CAQS_FILTER_LIST AS _filter_list ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_CAQS_EXP_RESTRICTION AS _restriction ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More