P_WRKCTRCAPOPWITHNIGHTS

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

define view P_WrkCtrCapOpWithNights 
 with parameters
    P_StartDate : datum,
    P_EndDate   : datum
       as select from P_WrkCtrCapOpDateRange( P_StartDate:$parameters.P_StartDate, P_EndDate:$parameters.P_EndDate ) as WrkCtrCapPplineOp
        inner join P_WorkCtrCapWithNightShift as CapacityPerShift 
                    on CapacityPerShift.CapacityInternalID =  WrkCtrCapPplineOp.CapacityInternalID  and 
                     (CapacityPerShift.ValidityBeginDate  <= WrkCtrCapPplineOp.OperationLatestEndDate
                      and CapacityPerShift.ValidityEndDate >= WrkCtrCapPplineOp.OperationLatestStartDate)                 
{
      key WrkCtrCapPplineOp.WorkCenterInternalID,
      key WrkCtrCapPplineOp.WorkCenterTypeCode,
      key WrkCtrCapPplineOp.CapacityCategoryAllocation,
      key WrkCtrCapPplineOp.CapacityInternalID,
      key WrkCtrCapPplineOp.OrderID,
      key  case when (CapacityPerShift.ShiftName = '' and CapacityPerShift.AvailableCapacityShift <> '') then
                concat('SH ', CapacityPerShift.AvailableCapacityShift)
                 else
                       CapacityPerShift.ShiftName  
                end as ShiftName,
      key CapacityPerShift.WeekDay,
      key 
        case when CapacityPerShift.ValidityBeginDate is null 
                       or CapacityPerShift.ValidityBeginDate < WrkCtrCapPplineOp.OperationLatestStartDate
             then WrkCtrCapPplineOp.OperationLatestStartDate
                      else CapacityPerShift.ValidityBeginDate
        end as  ValidityBeginDate,
        
     key 
       case when CapacityPerShift.ValidityEndDate is null 
                       or CapacityPerShift.ValidityEndDate > WrkCtrCapPplineOp.OperationLatestEndDate
                 then WrkCtrCapPplineOp.OperationLatestEndDate
                      else CapacityPerShift.ValidityEndDate
        end as  ValidityEndDate,
     key CapacityPerShift.AvailableCapacityShift,
     key CapacityPerShift.CapacityActiveVersion,
          WrkCtrCapPplineOp.Plant,
          WrkCtrCapPplineOp.MRPController,
          WrkCtrCapPplineOp.WorkCenter, 
          WrkCtrCapPplineOp.Material, //key

          WrkCtrCapPplineOp.CapacityRequirement, //key

          WrkCtrCapPplineOp.WorkCenterResponsible,
          WrkCtrCapPplineOp.OrderCategory,
//          @Search: null

//          WrkCtrCapPplineOp.WorkCenterDesc,

          WrkCtrCapPplineOp.WorkCenterCategoryCode,
          WrkCtrCapPplineOp.CapacityRequirementOrigin,
          WrkCtrCapPplineOp.Operation, //key

          WrkCtrCapPplineOp.CapacityRequirementUnit,
          WrkCtrCapPplineOp.OrderInternalID,        
          WrkCtrCapPplineOp.OrderType,
//          WrkCtrCapPplineOp.OrderTypeName,

          WrkCtrCapPplineOp.ProductionVersion,
          WrkCtrCapPplineOp.OrderPlannedTotalQty,
          WrkCtrCapPplineOp.BaseUnit,
          CapacityPerShift.AvailableCapacityIntervalDurn,
          CapacityPerShift.TotOperatingDurationInSeconds,
          CapacityPerShift.OperatingDurationInSeconds,
          CapacityPerShift.CapacityStartTime,
          CapacityPerShift.CapacityEndTime,
          CapacityPerShift.NightSplitDate,
          CapacityPerShift.WorkDayRule,
          CapacityPerShift.FactoryCalendar,
//          WrkCtrCapPplineOp.OperationPlanningStatusText,

          WrkCtrCapPplineOp.OperationPlanningStatusCode,
          WrkCtrCapPplineOp.OperationLatestStartDate,
          WrkCtrCapPplineOp.OperationLatestStartTime,
          WrkCtrCapPplineOp.OperationLatestEndDate,
          WrkCtrCapPplineOp.OperationLatestEndTime, 
          WrkCtrCapPplineOp.OpLtstSchedldExecStrtTme,
          WrkCtrCapPplineOp.OpLtstSchedldExecEndTme,
          WrkCtrCapPplineOp.OpLtstSchedldProcgStrtDte,
          WrkCtrCapPplineOp.OpLtstSchedldProcgStrtTme,
          WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtDte,
          WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtTme,
          WrkCtrCapPplineOp.RemainingCapReqOpSegSetupDurn,
          WrkCtrCapPplineOp.RemainingCapReqOpSegProcgDurn,
          WrkCtrCapPplineOp.RemainingCapReqOpSegTrdwnDurn,
          WrkCtrCapPplineOp.CapacityRequirementsAreDtmnd,
          WrkCtrCapPplineOp.TotRequirementInSeconds,
//          WrkCtrCapPplineOp.OrderStatusText,

          WrkCtrCapPplineOp.OrderStatusCode,
          WrkCtrCapPplineOp.OrderFirmingStatusCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WORKCTRCAPWITHNIGHTSHIFT",
"P_WRKCTRCAPOPDATERANGE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/