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 from CONSUMPTION Consumption VH for Work Center Group
P_WorkCenterGroupSubTreeNode view from COMPOSITE
P_WorkCenterGroupSubTreeNode_2 view_entity from COMPOSITE Children of single Workcenter group
P_WorkCenterGroupTreeNode view from COMPOSITE
P_WorkCenterGroupTreeNode_2 view_entity from COMPOSITE Node of Workcenter Group 
@AbapCatalog.sqlViewName: 'IWRKCTRGROUP'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }
@ObjectModel.semanticKey: 'WorkCenterGroup'
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Work Center Group View'

define view 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

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERGROUPTEXT",
"I_WORKCENTERGROUPTYPETEXT",
"I_WORKCENTERHIERHEADER"
],
"ASSOCIATED":
[
"I_WORKCENTERGROUPOBJECTCOUNT",
"I_WORKCENTERGROUPTEXT",
"I_WORKCENTERGROUPTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More