P_WRKCTRSHIFTWITHREQ

CDS View

WorkCenter available Capacity with operations

P_WRKCTRSHIFTWITHREQ is a CDS View in S/4HANA. WorkCenter available Capacity with operations. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_WORKCENTERCAPACITYEVAL view left_outer COMPOSITE WorkCenter - Capacity Evaluation 
@AbapCatalog.sqlViewName: 'PWCCAPWITHREQ'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM: {
  private: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE

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

          WrkCtrCapPplineOp.WorkCenterResponsible,
//          @Search: null

//          WrkCtrCapPplineOp.WorkCenterDesc,

          WrkCtrCapPplineOp.WorkCenterCategoryCode,
          WrkCtrCapPplineOp.CapacityRequirementOrigin,
          WrkCtrCapPplineOp.Operation,
          WrkCtrCapPplineOp.CapacityRequirementUnit,
          WrkCtrCapPplineOp.OrderInternalID,        
          WrkCtrCapPplineOp.OrderType,
//          WrkCtrCapPplineOp.OrderTypeName,

          WrkCtrCapPplineOp.ProductionVersion,
          WrkCtrCapPplineOp.OrderPlannedTotalQty,
          WrkCtrCapPplineOp.BaseUnit,
          CapacityPerShift.AvailableCapacityShift,    
          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.OrderStatusText,

          WrkCtrCapPplineOp.OrderStatusCode,
          WrkCtrCapPplineOp.OrderFirmingStatusCode,
          WrkCtrCapPplineOp.OrderCategory
}

Learn More