P_CapEvalCalcdField

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

define view 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,

      _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 _WorkCenter._Plant._Address.AddressTimeZone is not initial
       then
           tstmp_to_dats( tstmp_current_utctimestamp(), _WorkCenter._Plant._Address.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
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_PLANT",
"I_WORKCENTER",
"I_WORKCENTERCAPACITY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/