C_CCV_EIT_Filter

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 C_CCV_EIT_Filter.
-- 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.
-- SQL view name: APS_CCVEIT_FILT

CREATE VIEW C_CCV_EIT_Filter AS
SELECT
  entity_name AS EntityName,
  _DS_ViewField.data_source_alias AS DataSourceAlias,
  view_field AS ViewField,
  Counter,
  Operator,
  value_type AS FieldValueType,
  field_value_constant AS FieldValueConstant,
  _DS_Field.data_source_alias AS FieldValuePathDatasourceAlias,
  field_value_path AS FieldValuePath,
  _Parameter.parameter_name AS FieldValueParameterName,
  field_value_session_var AS FieldValueSessionVariable,
  filter_uuid
FROM I_CustomCDSViewFilter
LEFT OUTER JOIN C_CCV_EIT_Root AS _Root ON _Root.EntityName = EntityName  -- association [1..1]
LEFT OUTER JOIN I_CustomCDSViewDataSource AS _DS_ViewField ON _DS_ViewField.entity_name = EntityName AND _DS_ViewField.data_source_uuid = data_source_uuid  -- association [1..1]
LEFT OUTER JOIN I_CustomCDSViewDataSource AS _DS_Field ON _DS_Field.entity_name = EntityName AND _DS_Field.data_source_uuid = field_value_path_ds_uuid  -- association [1..1]
LEFT OUTER JOIN I_CustomCDSViewParameter AS _Parameter ON _Parameter.entity_name = EntityName AND _Parameter.param_uuid = field_value_param_uuid  -- association [1..1]
;