I_WorkCenterGroup

DDL: I_WORKCENTERGROUP SQL: IWRKCTRGROUP Type: view COMPOSITE

Work Center Group View

I_WorkCenterGroup is a Composite CDS View that provides data about "Work Center Group View" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterHierHeader) and exposes 12 fields with key fields WorkCenterGroupTypeCode, WorkCenterGroupInternalID. It has 3 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterHierHeader crhh from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_WorkCenterGroupText _Text $projection.WorkCenterGroupTypeCode = _Text.WorkCenterGroupTypeCode and $projection.WorkCenterGroupInternalID = _Text.WorkCenterGroupInternalID
[0..1] I_WorkCenterGroupTypeText _WorkCenterTypeText $projection.WorkCenterGroupType = _WorkCenterTypeText.WorkCenterGroupType
[0..1] I_WorkCenterGroupObjectCount _ObjectCount $projection.WorkCenterGroupTypeCode = _ObjectCount.ObjectTypeCode and $projection.WorkCenterGroupInternalID = _ObjectCount.ObjectInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWRKCTRGROUP view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.semanticKey WorkCenterGroup view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Work Center Group View view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterGroupTypeCode WrkCtrHierObjType
KEY WorkCenterGroupInternalID WrkCtrHierObjID
WorkCenterGroup WrkCtrHierName
WorkCenterGroupDescription
Plant WrkCtrHierPlant
WorkCenterGroupType WorkCenterGroupType
WorkCenterGroupTypeDescription
IsDeleted IsDeleted
_Text _Text
_ObjectCount _ObjectCount
ShiftNoteType ShiftNoteType
ShiftReportType ShiftReportType 
@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

Learn More