C_WorkCenterGroupTree

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_WorkCenterGroupTree.
-- 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: CWRKCTRGRPTREE

CREATE VIEW C_WorkCenterGroupTree AS
SELECT
  WrkCtrGroupHierarchyRootNode AS HierarchyRootNode,
  WrkCtrGroupHierarchyParentNode AS HierarchyParentNode,
  WorkCenterGroupHierarchyNode AS HierarchyNode,
  WrkCtrGroupHierarchyNodeType AS HierarchyNodeType,
  WrkCtrGrpHierParNodeUniqueID AS ParentNode,
  WrkCtrGrpHierarchyNodeUniqueID AS HierarchyNodeUniqueID,
  WorkCenterGroupRoot,
  WorkCenterGroup,
  ObjectName,
  ObjectDescription,
  ObjectTypeText,
  WorkCenterGroupType,
  WorkCenterGroupTypeDescription,
  WorkCenterGroupRootType,
  WorkCenterGroupRootTypeDesc,
  NumberOfWorkCenters,
  _ObjectCount.WorkCenterGroupObjectCount AS WorkCenterGroupObjectCount,
  Plant,
  _PlantName.PlantName AS PlantName,
  WrkCtrGrpHierNodeOrdinalNumber AS WrkCtrGrpNodeID,
  WrkCtrGrpHierParNodeOrdnlNmbr AS WrkCtrGrpParentNodeID,
  WrkCtrGrpHierNodeSubTreeSize,
  WrkCtrGrpHierarchyLevel,
  WrkCtrGrpHierarchyNodeIsOrphan,
  WrkCtrGrpHierNodeIsCycEndPoint,
  WrkCtrGrpDrillState,
  cast( '' as abap.char(1) ) AS WorkCenterGroupIsUpdateEnabled,
  cast( '' as abap.char(1) ) AS WorkCenterGroupIsDeleteEnabled,
  ShiftNoteType,
  ShiftReportType,
  _RepoTypeVH.ShiftReportDescription AS ShiftReportDescription,
  _NoteTypeVH.ShiftNoteTypeDescription AS ShiftNoteTypeDescription
FROM I_WorkCenterGroupTreeAggrgn
LEFT OUTER JOIN C_WorkCenterGroupStructure AS _WorkCenterGroupStructure ON HierarchyNodeType = _WorkCenterGroupStructure.WorkCenterGroupTypeCode AND HierarchyNode = _WorkCenterGroupStructure.WorkCenterGroupInternalID  -- association [0..*]
LEFT OUTER JOIN C_WorkCenterGroupWhereUsed AS _WorkCenterGroupWhereUsed ON HierarchyNodeType = _WorkCenterGroupWhereUsed.ObjectTypeCode AND HierarchyNode = _WorkCenterGroupWhereUsed.ObjectInternalID  -- association [1..*]
LEFT OUTER JOIN I_WorkCenterGroupObjectCount AS _ObjectCount ON HierarchyNodeType = _ObjectCount.ObjectTypeCode AND HierarchyNode = _ObjectCount.ObjectInternalID  -- association [0..1]
LEFT OUTER JOIN C_WorkCenterGroupAdminvData AS _AdminData ON HierarchyNodeType = _AdminData.ObjectTypeCode AND HierarchyNode = _AdminData.ObjectInternalID  -- association [1..1]
LEFT OUTER JOIN C_ManageWrkCtrGrpWorkCenterVH AS _WorkCenterVH ON HierarchyNodeType = 'G'  -- association [1..*]
LEFT OUTER JOIN C_WorkCenterGroupSubTree AS _SubTree ON HierarchyRootNode = _SubTree.HierarchyNode  -- association [1..1]
LEFT OUTER JOIN C_ShiftReportTypeVH AS _RepoTypeVH ON _RepoTypeVH.ShiftReportType = ShiftReportType  -- association [0..1]
LEFT OUTER JOIN C_ShiftNoteTypeVH AS _NoteTypeVH ON _NoteTypeVH.ShiftNoteType = ShiftNoteType  -- association [0..1]
;