P_CapEvalCalcdField

@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
    private: true,
    viewType: #CONSUMPTION
}
define view entity P_CapEvalCalcdField
  as select from I_WorkCenterCapacity as WorkCenterCapacity
{
  key WorkCenterInternalID,
  key WorkCenterTypeCode,
  key CapacityCategoryAllocation,
  key CapacityInternalID,

      cast(' ' as char4)                                                    as WorkCenterEvaluationHorizon,
      //cast(' ' as char40)                  as  CapacityCategoryName,

      cast('%' as meins  )                                                  as BaseUnit,

      cast(0  as dec10_2  )                                                 as WorkCenterMaxUtilznInTimePerd,

      cast(' ' as char12)                                                   as WorkCenterCapFirstOverloadWk,

      cast('00000000' as datum)                                             as WorkCenterCapFirstOverLoadDte,
      
      cast(0 as dec10_2)                                                    as WorkCenterCapacityBacklogInHrs,

      cast(0 as dec10_2)                                                    as WorkCenterTotCapInTimePeriod,

      //cast(' ' as abap.sstring(40))               as  Capacity,


      cast(0 as dec10_2 )                                                   as WorkCenterMinUtilznInTmePeriod,

      cast(' ' as char12)                                                   as WorkCenterCapFirstCritlLoadWk,

      cast('00000000' as datum)                                             as WorkCenterCapFirstCritlLoadDte,

      cast(0 as dec10_2)                                                    as WorkCenterAvgUtilznInTimePerd,

      cast(0 as dec10_2)                                                    as WorkCenterTotAvailCapInTmePerd,

      cast(0 as dec10_2)                                                    as WorkCenterTotUtilznInTmePerd,

      cast(' ' as numc2)                                                    as CapacityEvaluationTimePeriod,

      cast('H' as meins)                                                    as WorkCenterCapacityUnit,

      cast(' ' as meins)                                                    as WorkCenterCapUnitText,

      cast(0 as dec10_2)                                                    as WorkCenterAvailableCapacity,

      cast(0 as dec10_2)                                                    as WorkCenterCapacityRequirement,

      cast('  ' as char3)                                                   as CapacityCategoryCode,

      cast(' ' as domvalue_l)                                               as CapacityRequirementOrigin,

      cast(' ' as domvalue_l)                                               as OperationPlanningStatusCode,

      cast(' ' as char5)                                                    as OrderStatusCode,

      cast(0 as abap.int1)                                                  as Criticality,

      cast(0 as abap.int1)                                                  as WorkCenterAvgUtilznCriticality,

      //cast(Concat(_WorkCenter._Plant.PlantName,Concat( ' (', Concat( _WorkCenter._Plant.Plant,')'))) as cfs_plantname) as PlantName,

      //cast(_WorkCenter._Plant.PlantName as cfs_plantname)                                                                                             as PlantName,

      WorkCenterCapacity._WorkCenter._Plant.PlantName,
      
      cast(0 as dec10_2)                                                    as WorkCenterCumltvLoadInTmePerd,

      cast(0 as dec10_2)                                                    as WorkCenterCumltvLoadInHours,

      cast(' ' as flag)                                                     as WrkCtrIsUndrMaintInTmePerd,

      cast(' ' as char3)                                                    as WorkCenterFltrCodeInTmePerd,

      cast(' ' as char10)                                                   as WrkCtrMaintOrdAvailabilityTxt,

      cast(cast( '' as abap.char(10)) as cr_hname preserving type)          as WorkCenterGroup,
      cast( cast( '' as abap.char(10)) as cr_wrkctrgrptyp preserving type ) as WorkCenterGroupType,
      cast('' as abap.char(40))                                             as WorkCenterGroupDescription,

      case
       when WorkCenterCapacity._WorkCenter._Plant._StandardOrganizationAddress.AddressTimeZone is not initial
       then
           tstmp_to_dats( tstmp_current_utctimestamp(), WorkCenterCapacity._WorkCenter._Plant._StandardOrganizationAddress.AddressTimeZone, $session.client, 'NULL' )
       else
           cast($session.system_date as abap.dats) end                      as CurrentPlantDate,
      cast ('00000000' as dats)                                                       as CapacityEvaluationHorizonDate,
      cast ('00000000' as dats)                                                       as HorizonStartDate,
      cast ('00000000' as dats)                                                       as HorizonEndDate,
      cast ('00000000' as dats)                                                       as CapEvalStartDate,
      cast(' ' as char1)                                                    as CapEvalBucketType,
      cast ('00000000' as dats)                                             as CapacityEvaluationOverdueDate,
      cast(0 as dec10_2)                                                    as RemainingAvailableCapacityDurn
//      maintainence order CIP

//      cast(0 as dec10_2)                                                    as WorkCenterCapacityRequirementM

    
}