C_CustomCDSViewElemProperties

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_CustomCDSViewElemProperties.
-- 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_EP_V

CREATE VIEW C_CustomCDSViewElemProperties AS
SELECT
  entity_name AS EntityName,
  elem_uuid AS ElementUUID,
  _Element.Counter AS Counter,
  _Element.ElementLabel AS ElementLabel,
  semantics_annotation AS SemanticsAnnotation,
  semantics_value AS SemanticsAnnotationValue,
  semantics_value_uuid AS SemanticsAnnotationValueUUID,
  _SemanticsValueRefElement.ElementAlias AS SemanticsValueElementAlias,
  Aggregation,
  Hidden,
  ana_excl_runtime_ext AS AnaExclRuntimeExt,
  mandatory_filter AS MandatoryFilter,
  multiselect_filter AS MultiSelectFilter,
  filter_selection_type AS FilterSelectionType,
  _Element.KeyIndicator AS KeyIndicator,
  _Element.SourceEntityName AS SourceEntityName,
  masterdata_view_elem_uuid AS MasterdataViewElementUUID,
  _MasterdataView.ElementAlias AS MasterdataViewElementAlias,
  text_view_elem_uuid AS TextViewElementUUID,
  _TextView.ElementAlias AS TextViewElementAlias,
  value_help_elem_uuid AS ValueHelpElementUUID,
  _ValueHelpView.ElementAlias AS ValueHelpViewElementAlias,
  label_element_uuid AS LabelElementUUID,
  _LabelElement.ElementAlias AS LabelElementAlias,
  group_w_element_uuid AS GroupWithElementUUID,
  _GroupWithElement.ElementAlias AS GroupWithElementAlias,
  _Element.ElementAlias AS ElementAlias,
  _Element.Origincode AS OriginCode
FROM I_CustomCDSViewElemProperties
LEFT OUTER JOIN C_CustomCDSViewRoot AS _Root ON _Root.EntityName = EntityName  -- association [1..1]
LEFT OUTER JOIN C_CustomCDSViewElement AS _Element ON _Element.EntityName = EntityName AND _Element.ElementUUID = ElementUUID  -- association [1..1]
LEFT OUTER JOIN C_CustomCDSViewElement AS _Elements ON _Elements.EntityName = EntityName  -- association [1..*]
LEFT OUTER JOIN C_CustomCDSViewElement AS _SemanticsValueRefElement ON _SemanticsValueRefElement.EntityName = EntityName AND _SemanticsValueRefElement.ElementUUID = SemanticsAnnotationValueUUID  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewElement AS _MasterdataView ON _MasterdataView.EntityName = EntityName AND _MasterdataView.ElementUUID = MasterdataViewElementUUID  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewElement AS _TextView ON _TextView.EntityName = EntityName AND _TextView.ElementUUID = TextViewElementUUID  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewElement AS _ValueHelpView ON _ValueHelpView.EntityName = EntityName AND _ValueHelpView.ElementUUID = ValueHelpElementUUID  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewElement AS _LabelElement ON _LabelElement.EntityName = EntityName AND _LabelElement.ElementUUID = LabelElementUUID  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewElement AS _GroupWithElement ON _GroupWithElement.EntityName = EntityName AND _GroupWithElement.ElementUUID = GroupWithElementUUID  -- association [0..1]
;