C_CapEvalWorkCenterOverView

@AbapCatalog.sqlViewName: 'CCAPEVALWCOVW'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@ObjectModel.semanticKey:  [ 'WorkCenterDesc' ]
@Search.searchable: false
@UI.lineItem.criticality: 'Criticality'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_CapEvalWorkCenterOverView
  with parameters
    P_WorkCenterEvaluationHorizon : char4
  as select from I_WorkCenter as WorkCenter
  association [1..*] to C_CapEvalWcUtilznInEvalHorzn as _WorkCenterUtilization on  $projection.WorkCenterInternalID = _WorkCenterUtilization.WorkCenterInternalID
                                                                               and $projection.CapacityInternalID   = _WorkCenterUtilization.CapacityInternalID
{

      @UI.hidden: true

  key WorkCenterInternalID,  

      @UI.hidden: true
  key CapacityInternalID,

      
      @Consumption.filter.hidden
      @UI.lineItem: {
            label: 'Work Center',
            position: 10,
            importance: #HIGH
        }
      @UI.textArrangement: #TEXT_LAST

      @ObjectModel:{
        text.element:  [ 'WorkCenter' ],
        readOnly: true
      }
      @EndUserText.label: 'Work Center'
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
      WorkCenter._Text[1:Language=$session.system_language].WorkCenterText as WorkCenterDesc,
      
      @UI.lineItem: [{
          label: 'Capacity Category',
          position: 20,
          importance:#HIGH
      }]
      @Consumption.filter.hidden: true
      @EndUserText.label: 'Capacity Category'
      cast(' ' as abap.char(40))                  as  CapacityCategoryName,

      @ObjectModel.readOnly: true
      @UI.hidden: true
      @Semantics.unitOfMeasure: true
      @Consumption.filter.hidden: true
      @EndUserText.label: '%'
      cast('%' as meins)                          as  BaseUnit,

      @ObjectModel.readOnly: true
      @UI:{
        lineItem:[{
          label: 'Max. Load',
          position: 30,
          importance:#HIGH}]
      }
      @Consumption.filter.hidden: true
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @EndUserText.label: 'Max. Load'
      cast(0 as abap.dec(10,2))                   as  WorkCenterMaxUtilznInTimePerd,


      @UI.lineItem:[{
          label: 'First Overload',
          position: 40,
          importance:#HIGH
       }]
      @Consumption.filter.hidden: true
      @EndUserText.label: 'First Overload'
      cast(' ' as abap.char(12))                  as  WorkCenterCapFirstOverLoadDte,

      @UI.lineItem:[{
          label: 'Backlog',
          position: 50,
          importance:#HIGH
       }]
     
      @Consumption.filter.hidden: true
      @EndUserText.label: 'Backlog'
      @Semantics.quantity.unitOfMeasure: 'WorkCenterCapacityUnit'
      cast(0 as abap.dec(10,2))                   as  WorkCenterCapacityBacklogInHrs,

      @UI.lineItem:[{
          label: 'Total Capacity Requirement',
          position: 60,
          importance:#HIGH
       }]
      @Consumption.filter.hidden: true
      @EndUserText.label: 'Total Capacity Requirement'
      @Semantics.quantity.unitOfMeasure: 'WorkCenterCapacityUnit'
      cast(0 as abap.dec(10,2))                   as  WorkCenterTotCapInTimePeriod,

      @EndUserText.label: 'Capacity Name'
      @Consumption.filter.hidden: true
      cast(' ' as abap.sstring(40))               as  Capacity,

      @EndUserText.label: 'Min. Load'
      @Consumption.filter.hidden: true
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast(0 as abap.dec(10,2) )                  as  WorkCenterMinUtilznInTmePeriod,

      @EndUserText.label: 'First Critical Load'
      @Consumption.filter.hidden: true
      cast(' ' as abap.char(12))                  as  WorkCenterCapFirstCritlLoadDte,

      @EndUserText.label: 'Avg. Load'
      @Consumption.filter.hidden: true
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast(0 as abap.dec(10,2))                   as  WorkCenterAvgUtilznInTimePerd,

      @EndUserText.label: 'Total Available Capacity'
      @Consumption.filter.hidden: true
      @Semantics.quantity.unitOfMeasure: 'WorkCenterCapacityUnit'
      cast(0 as abap.dec(10,2))                   as  WorkCenterTotAvailCapInTmePerd,

      @EndUserText.label: 'Overall Percentage Load'
      @Consumption.filter.hidden: true
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast(0 as abap.dec(10,2))                   as  WorkCenterTotUtilznInTmePerd,

      @UI.hidden: true
      cast(' ' as abap.numc(2))                  as  CapacityEvaluationTimePeriod,
     
      @UI.hidden: true
      @Semantics.unitOfMeasure: true
      cast(' ' as meins)                         as  WorkCenterCapacityUnit,

      @UI.hidden: true
      cast(' ' as meins)                         as  WorkCenterCapUnitText,
      
      @UI.hidden: true
      cast(0 as abap.dec(10,2))                   as  WorkCenterAvailableCapacity,

      @UI.hidden: true
      cast(0 as abap.dec(10,2))                   as  WorkCenterCapacityRequirement,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      cast('  ' as abap.char(3))                  as  CapacityCategoryCode,

      @UI.selectionField: [{position: 10 }]
      @Consumption.valueHelpDefinition:[{entity:{name:'C_CapEvalWorkCenterVH' , element: 'WorkCenter'}}]
      @EndUserText.label: 'Work Center'
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
      WorkCenter,

      @UI.fieldGroup: [{
      label: 'Person Responsible',
      groupLabel: 'Master Data',
      qualifier: 'MD',
      position: 10 }]
      @UI.lineItem: [{
          exclude: true
      }]
      @Consumption.valueHelpDefinition:[{entity:{name:'C_CapEvalWorkCenterPersRespVH' , element: 'WorkCenterResponsible'}}]
      @EndUserText.label: 'Person Responsible'
      WorkCenterResponsible                       as  WorkCenterResponsible,

      @UI.fieldGroup: [{
      label: 'Capacity Planner Group',
      groupLabel: 'Master Data',
      qualifier: 'MD',
      position: 20}]
      @UI.lineItem.exclude: true
      @Consumption.valueHelpDefinition:[{entity:{name:'C_CapEvalCapacityRespPlannerVH' , element: 'CapacityResponsiblePlanner'}}]
      @EndUserText.label: 'Capacity Planner Group'
      @EndUserText.quickInfo: 'Capacity Planner Group'
      WorkCenter._Capacity.CapacityResponsiblePlanner as  CapacityResponsiblePlanner,
      
      @UI.fieldGroup: [{
      label: 'Order Category',
      groupLabel: 'Others',
      qualifier: 'OT',
      position: 10 }]
      @Consumption.valueHelpDefinition:[{entity:{name:'C_CapEvalOrderCategoryVH' , element: 'OrderCategory'}}]
      @UI.lineItem.exclude: true
      @EndUserText.label: 'Order Category'
      @EndUserText.quickInfo: 'Order Category'
      cast(' ' as domvalue_l)                     as  CapacityRequirementOrigin,

      @UI.lineItem.exclude: true
      @UI.fieldGroup: [{
      label: 'Capacity Requirement Status',
      groupLabel: 'Others',
      qualifier: 'OT',
      position: 20 }]
      @Consumption.valueHelpDefinition:[{entity:{name:'C_CapEvalCapRqmtStsVH' , element: 'CapacityRequirementStatusCode'}}]
      @EndUserText.label: 'Capacity Requirement Status'
      @EndUserText.quickInfo: 'Capacity Requirement Status'
      cast(' ' as domvalue_l)                     as  OperationPlanningStatusCode,
      
      @UI.fieldGroup: [{
      groupLabel: 'Others',
      label: 'Operation Status',
      qualifier: 'OT',
      position: 30 }]
      @UI.lineItem.exclude: true
      @Consumption.valueHelpDefinition:[{entity:{name:'C_CapEvalOrderStatusVH' , element: 'SystemStatusShortName'}}]
      @EndUserText.label: 'Operation Status'
      @EndUserText.quickInfo: 'Operation Status'
      cast(' ' as j_txt04)                        as  OrderStatusCode,

      @UI.lineItem: [{
          exclude: true
      }]
      @ObjectModel.readOnly: true
      @Consumption.filter.hidden: true      
      cast(0 as abap.int1)     as Criticality,


      _WorkCenterUtilization


}