C_WorkCenterGroupSubTree

DDL: C_WORKCENTERGROUPSUBTREE SQL: CWCGRPSUBTREE Type: view CONSUMPTION
13 Fields 2 Associations

Tree for Single Work Center Group

C_WorkCenterGroupSubTree is a Consumption CDS View that provides data about "Tree for Single Work Center Group" in SAP S/4HANA. It has 2 associations to related views.

Parameters (1)

NameTypeDefault
P_WorkCenterGroupInternalID cr_objid

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_WorkCenter _WorkCenter $projection.HierarchyNodeType = _WorkCenter.WorkCenterTypeCode and $projection.HierarchyNode = _WorkCenter.WorkCenterInternalID
[0..*] I_WorkCenterGroupObjectCount _ObjectCount $projection.HierarchyNodeType = _ObjectCount.ObjectTypeCode and $projection.HierarchyNode = _ObjectCount.ObjectInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CWCGRPSUBTREE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
EndUserText.label Tree for Single Work Center Group view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY HierarchyNode WorkCenterGroupHierarchyNode
HierarchyParentNode WrkCtrGroupHierarchyParentNode
HierarchyNodeType WrkCtrGroupHierarchyNodeType
ObjectName ObjectName Object name
WrkCtrGroupHierarchyLevelValue WrkCtrGroupHierarchyLevelValue
WorkCenterGroup WorkCenterGroup
WrkCtrGrpNodeID WrkCtrGrpHierNodeOrdinalNumber
WrkCtrGrpParentNodeID WrkCtrGrpHierParNodeOrdnlNmbr
Plant Plant Valuation Area
WorkCenterText
WorkCenterCategoryCode _WorkCenter WorkCenterCategoryCode
WorkCenterCategoryName
WorkCenterGroupObjectCount

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_WorkCenterGroupSubTree.
-- 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: CWCGRPSUBTREE
-- Parameters: P_WorkCenterGroupInternalID : cr_objid

CREATE VIEW C_WorkCenterGroupSubTree AS
SELECT
  WorkCenterGroupHierarchyNode AS HierarchyNode,
  WrkCtrGroupHierarchyParentNode AS HierarchyParentNode,
  WrkCtrGroupHierarchyNodeType AS HierarchyNodeType,
  ObjectName,
  WrkCtrGroupHierarchyLevelValue,
  WorkCenterGroup,
  WrkCtrGrpHierNodeOrdinalNumber AS WrkCtrGrpNodeID,
  WrkCtrGrpHierParNodeOrdnlNmbr AS WrkCtrGrpParentNodeID,
  Plant,
  _WorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterText,
  _WorkCenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  _WorkCenter._WorkCenterCategory._Text[1:Language = $session.system_language].WorkCenterCategoryName AS WorkCenterCategoryName,
  cast (_ObjectCount.WorkCenterGroupObjectCount as int8_lew) AS WorkCenterGroupObjectCount
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON HierarchyNodeType = _WorkCenter.WorkCenterTypeCode AND HierarchyNode = _WorkCenter.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN I_WorkCenterGroupObjectCount AS _ObjectCount ON HierarchyNodeType = _ObjectCount.ObjectTypeCode AND HierarchyNode = _ObjectCount.ObjectInternalID  -- association [0..*]
;

Learn More