P_WorkCenterGroupTreeNode_2

DDL: P_WORKCENTERGROUPTREENODE_2 Type: view_entity COMPOSITE

Node of Workcenter Group

P_WorkCenterGroupTreeNode_2 is a Composite CDS View that provides data about "Node of Workcenter Group" in SAP S/4HANA. It reads from 2 data sources (I_WorkCenterGroup, I_WorkCenterGroupStructure) and exposes 14 fields with key fields ParentNodeID, ParentNodeType, NodeID, NodeType, ParentNodeType. It has 2 associations to related views.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkCenterGroup I_WorkCenterGroup from
I_WorkCenterGroupStructure I_WorkCenterGroupStructure union_all

Associations (2)

CardinalityTargetAliasCondition
[0..*] P_WorkCenterGroupTreeNode_2 _Parent $projection.ParentNodeID = _Parent.NodeID and $projection.ParentNodeType = _Parent.NodeType
[0..1] I_WorkCenterGroup _WrkCtrGrp $projection.ParentNodeID = _WrkCtrGrp.WorkCenterGroupInternalID and $projection.ParentNodeType = _WrkCtrGrp.WorkCenterGroupTypeCode

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Node of Workcenter Group view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ParentNodeID
KEY ParentNodeType
KEY NodeID WorkCenterGroupInternalID
KEY NodeType
ParentName
ChildName WorkCenterGroup
Plant Plant
KEY ParentNodeType WorkCenterGroupTypeCode
KEY NodeID ObjectInternalID
KEY NodeType ObjectTypeCode
ParentName _WrkCtrGrp WorkCenterGroup
ChildName ObjectName
Plant Plant
_Parent _Parent 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Node of Workcenter Group'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_WorkCenterGroupTreeNode_2
  as select from I_WorkCenterGroup
  association [0..*] to P_WorkCenterGroupTreeNode_2 as _Parent on  $projection.ParentNodeID   = _Parent.NodeID
                                                               and $projection.ParentNodeType = _Parent.NodeType
{
  key cast( '00000000' as cr_objid) as ParentNodeID,
  key cast('' as cr_objty)          as ParentNodeType,
  key WorkCenterGroupInternalID     as NodeID,
  key cast('G' as cr_objty)         as NodeType,
      cast('' as cr_hname)          as ParentName,
      WorkCenterGroup               as ChildName,
      Plant,
      _Parent
}
where
  IsDeleted = ''
union all select from I_WorkCenterGroupStructure
association [0..*] to P_WorkCenterGroupTreeNode_2 as _Parent    on  $projection.ParentNodeID   = _Parent.NodeID
                                                                and $projection.ParentNodeType = _Parent.NodeType
association [0..1] to I_WorkCenterGroup           as _WrkCtrGrp on  $projection.ParentNodeID   = _WrkCtrGrp.WorkCenterGroupInternalID
                                                                and $projection.ParentNodeType = _WrkCtrGrp.WorkCenterGroupTypeCode
{
  key WorkCenterGroupInternalID  as ParentNodeID,
  key WorkCenterGroupTypeCode    as ParentNodeType,
  key ObjectInternalID           as NodeID,
  key ObjectTypeCode             as NodeType,
      _WrkCtrGrp.WorkCenterGroup as ParentName,
      ObjectName                 as ChildName,
      Plant,
      _Parent
}
where
  _WrkCtrGrp.IsDeleted = ''

Learn More