P_WorkCenterGroupTreeNode

DDL: P_WORKCENTERGROUPTREENODE Type: view_entity COMPOSITE Package: VDM_PP_WORKCENTER_GROUP

Node of Work Center Group

P_WorkCenterGroupTreeNode is a Composite CDS View that provides data about "Node of Work Center Group" in SAP S/4HANA. It reads from 2 data sources (I_WorkCenterGroup, I_WorkCenterGroupStructure) and exposes 12 fields with key fields ParentNodeID, NodeID, NodeID. It has 2 associations to related views. Part of development package VDM_PP_WORKCENTER_GROUP.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkCenterGroup I_WorkCenterGroup from
I_WorkCenterGroupStructure I_WorkCenterGroupStructure union_all

Associations (2)

CardinalityTargetAliasCondition
[0..*] P_WorkCenterGroupTreeNode _Parent $projection.ParentNodeID = _Parent.NodeID
[0..1] I_WorkCenterGroup _WrkCtrGrp $projection.ParentNodeID = _WrkCtrGrp.WorkCenterGroupInternalID

Annotations (3)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ParentNodeID
KEY NodeID WorkCenterGroupInternalID
NodeType
ParentName
ChildName WorkCenterGroup
Plant Plant
KEY NodeID ObjectInternalID
NodeType ObjectTypeCode
ParentName _WrkCtrGrp WorkCenterGroup
ChildName ObjectName
Plant Plant
_Parent _Parent 
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_WorkCenterGroupTreeNode
  as select from I_WorkCenterGroup
  association [0..*] to P_WorkCenterGroupTreeNode as _Parent on $projection.ParentNodeID = _Parent.NodeID
{
  key cast( '00000000' as cr_objid)                                           as ParentNodeID,
  key WorkCenterGroupInternalID                                               as NodeID,
      'G'                                                                     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 as _Parent    on $projection.ParentNodeID = _Parent.NodeID
association [0..1] to I_WorkCenterGroup         as _WrkCtrGrp on $projection.ParentNodeID = _WrkCtrGrp.WorkCenterGroupInternalID
{
  key WorkCenterGroupInternalID                                               as ParentNodeID,
  key ObjectInternalID                                                        as NodeID,
      ObjectTypeCode                                                          as NodeType,
      _WrkCtrGrp.WorkCenterGroup                                              as ParentName,
      ObjectName                                                              as ChildName,
      Plant,
      _Parent
}
where
  _WrkCtrGrp.IsDeleted = ''

Learn More