P_WorkCenterCalcdField

@AbapCatalog.sqlViewName: 'PWRKCTRCALFLD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
    private: true,
    viewType: #COMPOSITE
}
@AbapCatalog.preserveKey:true 
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_WorkCenterCalcdField
  as select from I_WorkCenterCapacity as WorkCenterCapacity
{
  key WorkCenterCapacity.WorkCenterInternalID,
  key WorkCenterCapacity.WorkCenterTypeCode,
  key WorkCenterCapacity.CapacityCategoryAllocation,
      
      WorkCenterCapacity.WorkCenter,
      WorkCenterCapacity.Plant,
      cast('' as co_dispo )                  as MRPController,
      WorkCenterCapacity.CapacityInternalID  as CapacityInternalID,
      @EndUserText.label: 'Person Responsible'
      WorkCenterCapacity._WorkCenter.WorkCenterResponsible,
      @EndUserText.label: 'Work Center Category'
      WorkCenterCapacity.WorkCenterCategoryCode,
      @EndUserText.label: 'Requirement Origin'
      cast('1' as capacityrequirementorigin) as CapacityRequirementOrigin,
      cast ('' as matnr)                     as Material,
      cast ('' as abap.char(12))                     as OrderID, //AUFNR

      cast ('' as vornr)                  as Operation,
      cast (' ' as kaptprog)                 as ShiftName,
      cast('' as abap.char(10))               as CapacityEvaluationTimePeriod,
      cast('' as abap.char(2))               as CapacityEvaluationTimePerdCode,
      cast('' as cr_wfcid )                  as FactoryCalendar,
      @EndUserText.label: 'Requirement Origin Unit'
      cast('' as cy_keinh)                   as CapacityRequirementUnit,
      @EndUserText.label: 'Order Type'
      cast('' as aufart)                      as OrderType,
      @EndUserText.label: 'Order Category'
      cast('' as  pph_cfs_sch_ordercategory  )                  as OrderCategory,
      @EndUserText.label: 'Order Quantity'
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast(0 as gamng)                       as OrderPlannedTotalQty,
      cast('' as meins )                     as BaseUnit,
      @EndUserText.label: 'Source Of Supply'
      cast('' as verid)                      as ProductionVersion,
      @EndUserText.label: 'Operation Planning Status Code'
      cast('' as abap.char(4))               as OperationPlanningStatusCode,
      @EndUserText.label: 'Latest Start Date'
      cast('' as sstad)                      as OperationLatestStartDate,
      @EndUserText.label: 'Latest Start Time'
      cast('' as sstau)                      as OperationLatestStartTime,
      @EndUserText.label: 'Latest End Date'
      cast('' as sendd)                      as OperationLatestEndDate,
      @EndUserText.label: 'Latest End Time'
      cast('' as sendu)                      as OperationLatestEndTime,
      @EndUserText.label: 'Order Status Code'
      cast('' as abap.char(5) )                 as OrderStatusCode,
      @EndUserText.label: 'Firming Status Code'
      cast('0' as char1)                     as OrderFirmingStatusCode,
      @EndUserText.label: 'Scheduled Start Processing Time'
      cast('' as sssbd)                      as OpLtstSchedldProcgStrtDte,
      @EndUserText.label: 'Scheduled End Processing Time'
      cast('' as sssbz)                      as OpLtstSchedldProcgStrtTme,
      @EndUserText.label: 'Scheduled Start Teardown Time'
      cast('' as sssad)                      as OpLtstSchedldTrdwnStrtDte,
      @EndUserText.label: 'Scheduled End teardown Time'
      cast('' as sssaz)                      as OpLtstSchedldTrdwnStrtTme,
      @EndUserText.label: 'Remaining Setup Duration'
//      "cy_krueres

      cast(0 as abap.dec(10,2))                  as RemainingCapReqOpSegSetupDurn, 
 //     cy_kbeares

      @EndUserText.label: 'Remaining processing Duration'
      cast(0 as abap.dec(10,2))                  as RemainingCapReqOpSegProcgDurn,
  //    cy_kabrres

      @EndUserText.label: 'Remaining Teardown Duration'
      cast(0 as abap.dec(10,2))                  as RemainingCapReqOpSegTrdwnDurn,
      @EndUserText.label: 'Order Internal ID'
      cast('' as pph_aufpl )                 as OrderInternalID, 
      @EndUserText.label:  'Capacity Start Time'
      cast(0 as  kapbegzt )                  as CapacityStartTime,
      @EndUserText.label:  'Capacity End Time'
      cast(0 as  kapendzt )                  as CapacityEndTime,
      @EndUserText.label: 'Available Capacity'
      @Semantics.quantity.unitOfMeasure: 'WorkcenterCapacityUnit'
      cast(0 as abap.fltp)                   as WorkCenterAvailableCapacity,
      @EndUserText.label: 'Consumed Capacity'
      //sum(WorkCenterCapacity.WorkCenterCapRqmtInCapUnit) as WorkCenterCapRqmtInCapUnit,

      cast(0 as abap.fltp)                   as WorkCenterCapRqmtInCapUnit,
      cast(0 as abap.fltp)                   as WrkCtrRmngCapInCapUnit,
      cast(0 as abap.fltp)                   as WorkCenterTotUtilznInTmePerd,
      @EndUserText.label: 'Work Center Capacity Unit'
      cast ('H' as meins)                    as WorkCenterCapacityUnit

}