C_CustomCDSViewFilter

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_CustomCDSViewFilter.
-- 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_CCV_C_FILT_V

CREATE VIEW C_CustomCDSViewFilter AS
SELECT
  entity_name AS EntityName,
  filter_uuid AS FilterUUID,
  Counter,
  data_source_uuid AS ViewFieldDatasourceUUID,
  _DataSource.DataSourceName AS ViewFieldDatasourceName,
  _DataSource.DataSourceAlias AS ViewFieldDatasourceAlias,
  view_field AS ViewField,
  cast('' as abap.sstring(1000) ) AS ViewFieldDisplay,
  Operator,
  value_type AS FieldValueType,
  field_value_constant AS FieldValueConstant,
  field_value_path AS FieldValuePath,
  field_value_path_ds_uuid AS FieldValuePathDatasourceUUID,
  field_value_param_uuid AS FieldValueParameterUUID,
  field_value_session_var AS FieldValueSessionVariable,
  cast('' as abap.sstring(1000) ) AS FieldValuePathDisplay,
  cast('' as abap.sstring(15) ) AS DataType,
  _FieldValueDataSource.DataSourceAlias AS FieldValueDatasourceAlias,
  _FieldValueParameter.ParameterName AS FieldValueParameterName
FROM I_CustomCDSViewFilter
LEFT OUTER JOIN C_CustomCDSViewRoot AS _Root ON _Root.EntityName = EntityName  -- association [1..1]
LEFT OUTER JOIN C_CustomCDSViewDataSource AS _DataSource ON _DataSource.EntityName = EntityName AND _DataSource.DataSourceUUID = ViewFieldDatasourceUUID  -- association [1..1]
LEFT OUTER JOIN C_CustomCDSViewDataSource AS _FieldValueDataSource ON _FieldValueDataSource.EntityName = EntityName AND _FieldValueDataSource.DataSourceUUID = FieldValuePathDatasourceUUID  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewParameter AS _Parameters ON _Parameters.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CustomCDSViewParameter AS _FieldValueParameter ON _FieldValueParameter.EntityName = EntityName AND _FieldValueParameter.ParameterUUID = FieldValueParameterUUID  -- association [0..1]
;