P_WorkCenterGroupSubTreeNode_2

DDL: P_WORKCENTERGROUPSUBTREENODE_2 Type: view_entity COMPOSITE

Children of single Workcenter group

P_WorkCenterGroupSubTreeNode_2 is a Composite CDS View that provides data about "Children of single 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

Parameters (1)

NameTypeDefault
P_WorkCenterGroupInternalID cr_objid

Associations (2)

CardinalityTargetAliasCondition
[0..*] P_WorkCenterGroupSubTreeNode_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 Children of single 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: 'Children of single Workcenter group'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_WorkCenterGroupSubTreeNode_2
  with parameters
    P_WorkCenterGroupInternalID : cr_objid
  as select from I_WorkCenterGroup
  association [0..*] to P_WorkCenterGroupSubTreeNode_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
  WorkCenterGroupInternalID = $parameters.P_WorkCenterGroupInternalID
union all select from I_WorkCenterGroupStructure
association [0..*] to P_WorkCenterGroupSubTreeNode_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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERGROUP",
"I_WORKCENTERGROUPSTRUCTURE"
],
"ASSOCIATED":
[
"P_WORKCENTERGROUPSUBTREENODE_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More