C_CustomCDSViewRoot

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_CustomCDSViewRoot.
-- 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_ROOT_V

CREATE VIEW C_CustomCDSViewRoot AS
SELECT
  entity_name AS EntityName,
  draft_entity_name AS DraftEntityName,
  camel_case_entity_name AS CamelCaseEntityName,
  authorization_check AS AuthorizationCheck,
  view_name AS ViewName,
  Scenario,
  Type,
  entity_label AS EntityLabel,
  representative_key_uuid AS RepresentativeKeyElementUUID,
  _RepresentativeKeyElement.elem_alias AS RepresentativeKeyElementAlias,
  db_hints AS DBHints,
  ' ' AS UseHEXPlanIndicator,
  crea_date_time AS CreationDateTime,
  crea_uname AS CreationUserName,
  _CreatedByUser.description AS CreationUserDescription,
  lchg_date_time AS LastChangedDateTime,
  lchg_uname AS LastChangedUserName,
  _LastChangedByUser.description AS LastChangedUserDescription,
  filter_comparison_operator AS FilterComparisonOperator,
  filter_manual_changed_ind AS FilterManuallyChangedIndicator,
  Filter,
  generation_state AS GenerationState,
  cast( generation_log_handle as abap.sstring(22) ) AS GenerationLogHandle,
  0 AS NumberOfDependentObjects,
  ' ' AS CDBStatusCode,
  _Rework.ReworkIndicator AS ReworkIndicator,
  _Rework.HighestPriority AS TaskPriorityId,
  _Rework.HighestPriorityText AS TaskPriority,
  _Rework.HighestPrioritySortOrder AS TaskPrioritySortOrder,
  _Rework.Category AS TaskCategoryId,
  _Rework.CategoryText AS TaskCategory,
  _AtoItemExported._IsExported AS _IsExported,
  _AtoItemExported.ExportedState AS ExportedState,
  _Rework._TaskPriority AS _TaskPriority
FROM I_CustomCDSViewRoot
LEFT OUTER JOIN C_CustomCDSViewDataSource AS _Datasource ON _Datasource.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CustomCDSViewFilter AS _Filter ON _Filter.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CustomCDSViewParameter AS _Parameter ON _Parameter.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CustomCDSViewParameterValue AS _ParameterValue ON _ParameterValue.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CustomCDSViewElement AS _Element ON _Element.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CustomCDSViewElemProperties AS _ElementProperties ON _ElementProperties.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN C_CustomCDSViewATOSettings AS _Ato ON _Ato.dummy = EntityName  -- association [1..1]
LEFT OUTER JOIN I_CustomCDSViewElement AS _RepresentativeKeyElement ON _RepresentativeKeyElement.entity_name = EntityName AND _RepresentativeKeyElement.elem_uuid = RepresentativeKeyElementUUID  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewDependents AS _DependentObjects ON _DependentObjects.EntityName = EntityName  -- association [0..*]
LEFT OUTER JOIN I_CustomCDSViewUser AS _CreatedByUser ON _CreatedByUser.name = CreationUserName  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewUser AS _LastChangedByUser ON _LastChangedByUser.name = LastChangedUserName  -- association [0..1]
LEFT OUTER JOIN C_CCV_EIT_Migration AS _MigrationList ON _MigrationList.EntityName = EntityName  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewRework AS _Rework ON _Rework.EntityName = EntityName  -- association [0..1]
LEFT OUTER JOIN I_CCV_ATO_ITEMS_EXPORTED AS _AtoItemExported ON _AtoItemExported.EntityName = EntityName  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewReworkTask AS _ReworkTask ON _ReworkTask.Item_Id = EntityName  -- association [0..*]
;