C_CCV_EIT_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 C_CCV_EIT_Root.
-- 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_ROOT

CREATE VIEW C_CCV_EIT_Root AS
SELECT
  entity_name AS EntityName,
  camel_case_entity_name AS CamelCaseEntityName,
  draft_entity_name AS DraftEntityName,
  authorization_check AS AuthorizationCheck,
  Scenario,
  Type,
  ddl_impl_vers AS DDLImplementationVersion,
  entity_label AS EntityLabel,
  _RepKeyElement.elem_alias AS RepresentativeKeyElementAlias,
  db_hints AS DBHints,
  filter_comparison_operator AS FilterComparisonOperator,
  filter_manual_changed_ind AS FilterManuallyChangedIndicator,
  Filter,
  entity_name AS TransportOrganizerItemName,
  cast(tstmp_current_utctimestamp() as timestamp) AS LastChangedAt,
  $session.user AS LastChangedBy,
  $session.system_language AS OriginalLanguage,
  view_name AS ViewName,
  migrated_ind AS Migrated
FROM I_CustomCDSViewRoot
LEFT OUTER JOIN C_CCV_EIT_DataSource AS _Datasource ON _Datasource.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CCV_EIT_Filter AS _Filter ON _Filter.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CCV_EIT_Parameter AS _Parameter ON _Parameter.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CCV_EIT_Element AS _Element ON _Element.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CCV_EIT_ViewAnnotation AS _ViewAnnotation ON _ViewAnnotation.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN I_CustomCDSViewElement AS _RepKeyElement ON _RepKeyElement.entity_name = EntityName AND _RepKeyElement.elem_uuid = representative_key_uuid  -- association [0..1]
;