A_WorkCenterAllCapacity

@AbapCatalog.sqlViewName: 'AWORKCTRALLCAP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Capacity Assignment'
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@AccessControl.privilegedAssociations: ['_WorkCenterResponsible']
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
define view A_WorkCenterAllCapacity
  as select from I_WorkCenterAllCapacity          as WorkCenterCapacity
  association [0..*] to A_WorkCenterCapDayOp      as _WorkCenterTodayOp     on $projection.WorkCenterInternalID  = _WorkCenterTodayOp.WorkCenterInternalID
  association [0..*] to A_WorkCenterCapPplineOp   as _WorkCenterQueuingOp   on $projection.WorkCenterInternalID  = _WorkCenterQueuingOp.WorkCenterInternalID
  association [0..1] to A_WorkCenterResponsible   as _WorkCenterResponsible on $projection.Plant                 = _WorkCenterResponsible.Plant and
                                                                               $projection.WorkCenterResponsible = _WorkCenterResponsible.WorkCenterResponsible
  association [1..*] to A_WorkCenterCapacityInterval  as _WorkCenterInterval  on $projection.WorkCenterInternalID       = _WorkCenterInterval.WorkCenterInternalID  and
                                                                                 $projection.WorkCenterTypeCode         = _WorkCenterInterval.WorkCenterTypeCode and 
                                                                                 $projection.CapacityInternalID         = _WorkCenterInterval.CapacityInternalID and
                                                                                 $projection.CapacityCategoryAllocation = _WorkCenterInterval.CapacityCategoryAllocation
  
{
                    //General Information

  key               WorkCenterCapacity.WorkCenterInternalID,
  key               WorkCenterCapacity.WorkCenterTypeCode,
  key               WorkCenterCapacity.CapacityInternalID,
  key               WorkCenterCapacity.CapacityCategoryAllocation,
                    WorkCenterCapacity.WorkCenter,
                    WorkCenterCapacity.WorkCenterDesc,
                    WorkCenterCapacity.Plant,
                    WorkCenterCapacity.WorkCenterCategoryCode,
                    WorkCenterCapacity.WorkCenterResponsible,
                    WorkCenterCapacity.SupplyArea,
                    WorkCenterCapacity.WorkCenterUsage,
                    @Semantics.text: true
                    _WorkCenterResponsible.WorkCenterResponsibleName,
                    WorkCenterCapacity.CapacityCategoryCode,
                    _WorkCenterTodayOp,
                    _WorkCenterQueuingOp,
                    _WorkCenterResponsible,
                    _WorkCenterInterval
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_WORKCENTERRESPONSIBLE",
"I_WORKCENTERALLCAPACITY"
],
"ASSOCIATED":
[
"A_WORKCENTERCAPACITYINTERVAL",
"A_WORKCENTERCAPDAYOP",
"A_WORKCENTERCAPPPLINEOP",
"A_WORKCENTERRESPONSIBLE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/