P_WorkCenterGroupSubTreeNode

DDL: P_WORKCENTERGROUPSUBTREENODE SQL: PWRKCTRGRPSTN Type: view COMPOSITE

P_WorkCenterGroupSubTreeNode 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

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

NameValueLevelField
AbapCatalog.sqlViewName PWRKCTRGRPSTN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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: 'PWRKCTRGRPSTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Tree Structure for Single Work Center Group'

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

Learn More