I_WORKCENTERGROUPSTRUCTURE

CDS View

Work Center Group Structure View

I_WORKCENTERGROUPSTRUCTURE is a CDS View in S/4HANA. Work Center Group Structure View. 8 CDS views read from this table.

Used by 8 CDS view(s)

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_CapEvalWorkCenterGroup view_entity from CONSUMPTION Work Center Monitor Work Center Group
C_SchedProdnWorkCenterGroup view_entity from CONSUMPTION WorkCenter Group for given WorkCenter in Scheduled Prod
C_WorkCenterGroupStructure view_entity from CONSUMPTION Work Center Group Structure
I_WorkCenterGroupObjectCount view_entity from COMPOSITE Count of objects per work center group
P_WorkCenterGroupSubTreeNode view_entity union_all COMPOSITE Tree Structure for Single Work Center Group
P_WorkCenterGroupSubTreeNode_2 view_entity union_all COMPOSITE Children of single Workcenter group
P_WorkCenterGroupTreeNode view_entity union_all COMPOSITE Node of Work Center Group
P_WorkCenterGroupTreeNode_2 view_entity union_all COMPOSITE Node of Workcenter Group 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }
@EndUserText.label: 'Work Center Group Structure View'
define view entity I_WorkCenterGroupStructure
  as select from I_WorkCenterHierStructure
  association [0..1] to I_WorkCenter      as _WorkCenter      on  $projection.ObjectTypeCode   = _WorkCenter.WorkCenterTypeCode
                                                              and $projection.ObjectInternalID = _WorkCenter.WorkCenterInternalID
  association [0..1] to I_WorkCenterGroup as _WorkCenterGroup on  $projection.ObjectTypeCode   = _WorkCenterGroup.WorkCenterGroupTypeCode
                                                              and $projection.ObjectInternalID = _WorkCenterGroup.WorkCenterGroupInternalID
  association [0..1] to I_WorkCenterGroup as _WrkCtrGrp       on  $projection.WorkCenterGroupTypeCode   = _WrkCtrGrp.WorkCenterGroupTypeCode
                                                              and $projection.WorkCenterGroupInternalID = _WrkCtrGrp.WorkCenterGroupInternalID
  association [1..1] to I_ProductionResourceTypeText as _ObjectType on $projection.ObjectTypeCode =  _ObjectType.ProductionResourceType

{
      //crhs

  key WrkCtrHierParentType as WorkCenterGroupTypeCode,

  key WrkCtrHierParentID as WorkCenterGroupInternalID,

  key WrkCtrHierChildType as ObjectTypeCode,

  key WrkCtrHierChildID as ObjectInternalID,

      //this may never be used but since in the table this is key need to expose, keeping alias as WorkCenterTypeCode

  key WrkCtrHierUpObjType as WorkCenterTypeCode,

      //this may never be used but since in the table this is key need to expose, keeping alias as WorkCenterInternalID

  key WrkCtrHierUpObjID as WorkCenterInternalID,

      _WrkCtrGrp.WorkCenterGroup            as WorkCenterGroup,

      _WrkCtrGrp.WorkCenterGroupDescription as WorkCenterGroupDescription,
      
      _WrkCtrGrp.WorkCenterGroupType,
      
      _WrkCtrGrp.WorkCenterGroupTypeDescription,

      case
      when WrkCtrHierChildType = 'A'
      then _WorkCenter.WorkCenter
      else
      _WorkCenterGroup.WorkCenterGroup
      end                                   as ObjectName,

      case
      when WrkCtrHierChildType = 'A'
      then _WorkCenter.Plant
      else
      _WorkCenterGroup.Plant
      end                                   as Plant,

      case
      when WrkCtrHierChildType = 'A'
      then _WorkCenter._Text[1:Language = $session.system_language].WorkCenterText
      else
      _WorkCenterGroup.WorkCenterGroupDescription
      end                                   as ObjectDescription,
      
      _ObjectType[1:Language = $session.system_language].ProductionResourceTypeName as ObjectTypeText
}
where
  WrkCtrHierParentType = 'G'; //only Work Center Groups

Learn More