I_WORKCENTERGROUP

CDS View

Work Center Group View

I_WORKCENTERGROUP is a CDS View in S/4HANA. Work Center Group View. 6 CDS views read from this table.

Used by 6 CDS view(s)

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_ResourceGroupVH view_entity from CONSUMPTION Resource Group
C_WorkCenterGroupVH view_entity from CONSUMPTION Consumption VH for Work Center Group
P_WorkCenterGroupSubTreeNode view_entity from COMPOSITE Tree Structure for Single Work Center Group
P_WorkCenterGroupSubTreeNode_2 view_entity from COMPOSITE Children of single Workcenter group
P_WorkCenterGroupTreeNode view_entity from COMPOSITE Node of Work Center Group
P_WorkCenterGroupTreeNode_2 view_entity from COMPOSITE Node of Workcenter Group 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }
@ObjectModel.semanticKey: [ 'WorkCenterGroup']
@EndUserText.label: 'Work Center Group View'

define view entity I_WorkCenterGroup
  as select from I_WorkCenterHierHeader as crhh
  association [0..*] to I_WorkCenterGroupText        as _Text               on  $projection.WorkCenterGroupTypeCode   = _Text.WorkCenterGroupTypeCode
                                                                            and $projection.WorkCenterGroupInternalID = _Text.WorkCenterGroupInternalID
  association [0..1] to I_WorkCenterGroupTypeText    as _WorkCenterTypeText on  $projection.WorkCenterGroupType = _WorkCenterTypeText.WorkCenterGroupType
  association [0..1] to I_WorkCenterGroupObjectCount as _ObjectCount        on  $projection.WorkCenterGroupTypeCode   = _ObjectCount.ObjectTypeCode
                                                                            and $projection.WorkCenterGroupInternalID = _ObjectCount.ObjectInternalID
{
      //crhh

  key WrkCtrHierObjType                                                       as WorkCenterGroupTypeCode,
      @ObjectModel.text.association: '_Text'
      //@ObjectModel.foreignKey.association: null

  key WrkCtrHierObjID                                                         as WorkCenterGroupInternalID,

      WrkCtrHierName                                                          as WorkCenterGroup,

      _Text[1:Language = $session.system_language].WorkCenterGroupDescription as WorkCenterGroupDescription,

      WrkCtrHierPlant                                                         as Plant,

      WorkCenterGroupType,

      _WorkCenterTypeText[1:Language = $session.system_language].WorkCenterGroupTypeDescription,

      IsDeleted,

      _Text,

      _ObjectCount,

      ShiftNoteType,
      ShiftReportType
}
where
  WrkCtrHierObjType = 'G'; //only Work Center Groups

Learn More