I_CAQS_FILTER_LIST

DDL: I_CAQS_FILTER_LIST Type: view_entity
9 Fields 1 Data Sources

Custom Query filter list

I_CAQS_FILTER_LIST is a CDS View that provides data about "Custom Query filter list" in SAP S/4HANA. It reads from 1 data source (aqs_v_filter) and exposes 9 fields with key fields ViewName, VersionState, FieldName, ConditionPosition.

Data Sources (1)

SourceAliasJoin Type
aqs_v_filter aqs_v_filter from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Custom Query filter list view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ViewName view_name View Name
KEY VersionState version_state Version state
KEY FieldName field_name VAT Declaration Fld
KEY ConditionPosition pos Table position
Operator operator Type of OPTION component in row type of a Ranges type
FieldValueConstant field_value_constant Value
UpperFieldVConst upper_field_v_const
FieldConditionType field_condition_type
_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_FILTER_LIST.
-- 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_FILTER_LIST AS
SELECT
  view_name AS ViewName,
  version_state AS VersionState,
  field_name AS FieldName,
  pos AS ConditionPosition,
  Operator,
  field_value_constant AS FieldValueConstant,
  upper_field_v_const AS UpperFieldVConst,
  field_condition_type AS FieldConditionType
FROM aqs_v_filter
;

Learn More