P_WrkCtrCapOpWithNights

DDL: P_WRKCTRCAPOPWITHNIGHTS SQL: PWCCAPOPNIGHTS Type: view COMPOSITE
53 Fields 2 Data Sources

P_WrkCtrCapOpWithNights is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_WorkCtrCapWithNightShift, P_WrkCtrCapOpDateRange) and exposes 53 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, OrderID.

Data Sources (2)

SourceAliasJoin Type
P_WorkCtrCapWithNightShift CapacityPerShift inner
P_WrkCtrCapOpDateRange P_WrkCtrCapOpDateRange from

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PWCCAPOPNIGHTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WrkCtrCapPplineOp WorkCenterInternalID Work Center
KEY WorkCenterTypeCode WrkCtrCapPplineOp WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation WrkCtrCapPplineOp CapacityCategoryAllocation
KEY CapacityInternalID WrkCtrCapPplineOp CapacityInternalID Capacity ID
KEY OrderID WrkCtrCapPplineOp OrderID Order ID
KEY ShiftNameendasShiftName
KEY WeekDay P_WorkCtrCapWithNightShift WeekDay Weekdays
KEY ValidityBeginDateendasValidityBeginDate
KEY ValidityEndDateendasValidityEndDate
KEY AvailableCapacityShift P_WorkCtrCapWithNightShift AvailableCapacityShift Capacity Shift
KEY CapacityActiveVersion P_WorkCtrCapWithNightShift CapacityActiveVersion
Plant WrkCtrCapPplineOp Plant Valuation Area
MRPController WrkCtrCapPplineOp MRPController MRP Controller
WorkCenter WrkCtrCapPplineOp WorkCenter Work Center
Material WrkCtrCapPplineOp Material Vehicle Model
CapacityRequirement WrkCtrCapPplineOp CapacityRequirement
WorkCenterResponsible WrkCtrCapPplineOp WorkCenterResponsible
OrderCategory WrkCtrCapPplineOp OrderCategory Order Category
WorkCenterCategoryCode WrkCtrCapPplineOp WorkCenterCategoryCode
CapacityRequirementOrigin WrkCtrCapPplineOp CapacityRequirementOrigin
Operation WrkCtrCapPplineOp Operation Transaction
CapacityRequirementUnit WrkCtrCapPplineOp CapacityRequirementUnit
OrderInternalID WrkCtrCapPplineOp OrderInternalID Plan No.f.Oper.
OrderType WrkCtrCapPplineOp OrderType Order Type
ProductionVersion WrkCtrCapPplineOp ProductionVersion Version ID
OrderPlannedTotalQty WrkCtrCapPplineOp OrderPlannedTotalQty
BaseUnit WrkCtrCapPplineOp BaseUnit Unit of Measure
AvailableCapacityIntervalDurn P_WorkCtrCapWithNightShift AvailableCapacityIntervalDurn
TotOperatingDurationInSeconds P_WorkCtrCapWithNightShift TotOperatingDurationInSeconds
OperatingDurationInSeconds P_WorkCtrCapWithNightShift OperatingDurationInSeconds
CapacityStartTime P_WorkCtrCapWithNightShift CapacityStartTime
CapacityEndTime P_WorkCtrCapWithNightShift CapacityEndTime
NightSplitDate P_WorkCtrCapWithNightShift NightSplitDate
WorkDayRule P_WorkCtrCapWithNightShift WorkDayRule Recurrence Weekdays
FactoryCalendar P_WorkCtrCapWithNightShift FactoryCalendar Factory Calendar
OperationPlanningStatusCode WrkCtrCapPplineOp OperationPlanningStatusCode
OperationLatestStartDate WrkCtrCapPplineOp OperationLatestStartDate
OperationLatestStartTime WrkCtrCapPplineOp OperationLatestStartTime
OperationLatestEndDate WrkCtrCapPplineOp OperationLatestEndDate
OperationLatestEndTime WrkCtrCapPplineOp OperationLatestEndTime
OpLtstSchedldExecStrtTme WrkCtrCapPplineOp OpLtstSchedldExecStrtTme
OpLtstSchedldExecEndTme WrkCtrCapPplineOp OpLtstSchedldExecEndTme
OpLtstSchedldProcgStrtDte WrkCtrCapPplineOp OpLtstSchedldProcgStrtDte
OpLtstSchedldProcgStrtTme WrkCtrCapPplineOp OpLtstSchedldProcgStrtTme
OpLtstSchedldTrdwnStrtDte WrkCtrCapPplineOp OpLtstSchedldTrdwnStrtDte
OpLtstSchedldTrdwnStrtTme WrkCtrCapPplineOp OpLtstSchedldTrdwnStrtTme
RemainingCapReqOpSegSetupDurn WrkCtrCapPplineOp RemainingCapReqOpSegSetupDurn
RemainingCapReqOpSegProcgDurn WrkCtrCapPplineOp RemainingCapReqOpSegProcgDurn
RemainingCapReqOpSegTrdwnDurn WrkCtrCapPplineOp RemainingCapReqOpSegTrdwnDurn
CapacityRequirementsAreDtmnd WrkCtrCapPplineOp CapacityRequirementsAreDtmnd
TotRequirementInSeconds WrkCtrCapPplineOp TotRequirementInSeconds
OrderStatusCode WrkCtrCapPplineOp OrderStatusCode
OrderFirmingStatusCode WrkCtrCapPplineOp OrderFirmingStatusCode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_WrkCtrCapOpWithNights.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PWCCAPOPNIGHTS
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_WrkCtrCapOpWithNights AS
SELECT
  WrkCtrCapPplineOp.WorkCenterInternalID AS WorkCenterInternalID,
  WrkCtrCapPplineOp.WorkCenterTypeCode AS WorkCenterTypeCode,
  WrkCtrCapPplineOp.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WrkCtrCapPplineOp.CapacityInternalID AS CapacityInternalID,
  WrkCtrCapPplineOp.OrderID AS OrderID,
  case when (CapacityPerShift.ShiftName = '' and CapacityPerShift.AvailableCapacityShift <> '') then concat('SH ', CapacityPerShift.AvailableCapacityShift) else CapacityPerShift.ShiftName end as ShiftName AS ShiftNameendasShiftName,
  CapacityPerShift.WeekDay AS WeekDay,
  case when CapacityPerShift.ValidityBeginDate is null or CapacityPerShift.ValidityBeginDate < WrkCtrCapPplineOp.OperationLatestStartDate then WrkCtrCapPplineOp.OperationLatestStartDate else CapacityPerShift.ValidityBeginDate end as ValidityBeginDate AS ValidityBeginDateendasValidityBeginDate,
  case when CapacityPerShift.ValidityEndDate is null or CapacityPerShift.ValidityEndDate > WrkCtrCapPplineOp.OperationLatestEndDate then WrkCtrCapPplineOp.OperationLatestEndDate else CapacityPerShift.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  CapacityPerShift.AvailableCapacityShift AS AvailableCapacityShift,
  CapacityPerShift.CapacityActiveVersion AS CapacityActiveVersion,
  WrkCtrCapPplineOp.Plant AS Plant,
  WrkCtrCapPplineOp.MRPController AS MRPController,
  WrkCtrCapPplineOp.WorkCenter AS WorkCenter,
  WrkCtrCapPplineOp.Material AS Material,
  WrkCtrCapPplineOp.CapacityRequirement AS CapacityRequirement,
  WrkCtrCapPplineOp.WorkCenterResponsible AS WorkCenterResponsible,
  WrkCtrCapPplineOp.OrderCategory AS OrderCategory,
  WrkCtrCapPplineOp.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WrkCtrCapPplineOp.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  WrkCtrCapPplineOp.Operation AS Operation,
  WrkCtrCapPplineOp.CapacityRequirementUnit AS CapacityRequirementUnit,
  WrkCtrCapPplineOp.OrderInternalID AS OrderInternalID,
  WrkCtrCapPplineOp.OrderType AS OrderType,
  WrkCtrCapPplineOp.ProductionVersion AS ProductionVersion,
  WrkCtrCapPplineOp.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  WrkCtrCapPplineOp.BaseUnit AS BaseUnit,
  CapacityPerShift.AvailableCapacityIntervalDurn AS AvailableCapacityIntervalDurn,
  CapacityPerShift.TotOperatingDurationInSeconds AS TotOperatingDurationInSeconds,
  CapacityPerShift.OperatingDurationInSeconds AS OperatingDurationInSeconds,
  CapacityPerShift.CapacityStartTime AS CapacityStartTime,
  CapacityPerShift.CapacityEndTime AS CapacityEndTime,
  CapacityPerShift.NightSplitDate AS NightSplitDate,
  CapacityPerShift.WorkDayRule AS WorkDayRule,
  CapacityPerShift.FactoryCalendar AS FactoryCalendar,
  WrkCtrCapPplineOp.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  WrkCtrCapPplineOp.OperationLatestStartDate AS OperationLatestStartDate,
  WrkCtrCapPplineOp.OperationLatestStartTime AS OperationLatestStartTime,
  WrkCtrCapPplineOp.OperationLatestEndDate AS OperationLatestEndDate,
  WrkCtrCapPplineOp.OperationLatestEndTime AS OperationLatestEndTime,
  WrkCtrCapPplineOp.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  WrkCtrCapPplineOp.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  WrkCtrCapPplineOp.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  WrkCtrCapPplineOp.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  WrkCtrCapPplineOp.RemainingCapReqOpSegSetupDurn AS RemainingCapReqOpSegSetupDurn,
  WrkCtrCapPplineOp.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  WrkCtrCapPplineOp.RemainingCapReqOpSegTrdwnDurn AS RemainingCapReqOpSegTrdwnDurn,
  WrkCtrCapPplineOp.CapacityRequirementsAreDtmnd AS CapacityRequirementsAreDtmnd,
  WrkCtrCapPplineOp.TotRequirementInSeconds AS TotRequirementInSeconds,
  WrkCtrCapPplineOp.OrderStatusCode AS OrderStatusCode,
  WrkCtrCapPplineOp.OrderFirmingStatusCode AS OrderFirmingStatusCode
FROM P_WrkCtrCapOpDateRange
INNER JOIN P_WorkCtrCapWithNightShift AS CapacityPerShift ON /* join condition not captured in parsed metadata */
;

Learn More