P_WorkCenterGroupTreeNode

DDL: P_WORKCENTERGROUPTREENODE SQL: PWRKCTRGRPND Type: view COMPOSITE

P_WorkCenterGroupTreeNode is a Composite CDS View 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.

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 (6)

NameValueLevelField
AbapCatalog.sqlViewName PWRKCTRGRPND view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE 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 
@AbapCatalog.sqlViewName: 'PWRKCTRGRPND'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
//@EndUserText.label: 'Node of Work Center Group'

@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view 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 = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERGROUP",
"I_WORKCENTERGROUPSTRUCTURE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More