P_WorkCenterGroupSubTreeNode

DDL: P_WORKCENTERGROUPSUBTREENODE Type: view_entity COMPOSITE Package: VDM_PP_WORKCENTER_GROUP

Tree Structure for Single Work Center Group

P_WorkCenterGroupSubTreeNode is a Composite CDS View that provides data about "Tree Structure for Single 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

Parameters (1)

NameTypeDefault
P_WorkCenterGroupInternalID cr_objid

Associations (2)

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

Annotations (4)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK 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
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Tree Structure for Single Work Center Group'

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_WorkCenterGroupSubTreeNode
  with parameters
    P_WorkCenterGroupInternalID : cr_objid
  as select from I_WorkCenterGroup
  association [0..*] to P_WorkCenterGroupSubTreeNode 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
  WorkCenterGroupInternalID = $parameters.P_WorkCenterGroupInternalID
union all select from I_WorkCenterGroupStructure
association [0..*] to P_WorkCenterGroupSubTreeNode 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
}

Learn More