C_WorkCenterCapOverviewTP

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 C_WorkCenterCapOverviewTP.
-- 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: CWCCAPOVWTP

CREATE VIEW C_WorkCenterCapOverviewTP AS
SELECT
  _WorkCenterOverview.WorkCenterInternalID AS WorkCenterInternalID,
  _WorkCenterOverview.WorkCenterTypeCode AS WorkCenterTypeCode,
  _WorkCenterOverview.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  _WorkCenterOverview.CapacityInternalID AS CapacityInternalID,
  _CalcdField.WorkCenterEvaluationHorizon AS WorkCenterEvaluationHorizon,
  _WorkCenter._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  _CalcdField.BaseUnit AS BaseUnit,
  _CalcdField.WorkCenterCumltvLoadInTmePerd AS WorkCenterCumltvLoadInTmePerd,
  _CalcdField.WorkCenterMaxUtilznInTimePerd AS WorkCenterMaxUtilznInTimePerd,
  _CalcdField.WorkCenterCapFirstOverloadWk AS WorkCenterCapFirstOverloadWk,
  _CalcdField.WorkCenterCapFirstOverLoadDte AS WorkCenterCapFirstOverLoadDte,
  _CalcdField.WorkCenterCapacityBacklogInHrs AS WorkCenterCapacityBacklogInHrs,
  _CalcdField.WorkCenterTotCapInTimePeriod AS WorkCenterTotCapInTimePeriod,
  _WorkCenter._Capacity._Text[1:Language=$session.system_language].CapacityText AS Capacity,
  _CalcdField.WorkCenterMinUtilznInTmePeriod AS WorkCenterMinUtilznInTmePeriod,
  _CalcdField.WorkCenterCapFirstCritlLoadWk AS WorkCenterCapFirstCritlLoadWk,
  _CalcdField.WorkCenterCapFirstCritlLoadDte AS WorkCenterCapFirstCritlLoadDte,
  _CalcdField.WorkCenterAvgUtilznInTimePerd AS WorkCenterAvgUtilznInTimePerd,
  _CalcdField.WorkCenterTotAvailCapInTmePerd AS WorkCenterTotAvailCapInTmePerd,
  _CalcdField.WorkCenterTotUtilznInTmePerd AS WorkCenterTotUtilznInTmePerd,
  _CalcdField.CapacityEvaluationTimePeriod AS CapacityEvaluationTimePeriod,
  _CalcdField.WorkCenterCapacityUnit AS WorkCenterCapacityUnit,
  _CalcdField.WorkCenterCapUnitText AS WorkCenterCapUnitText,
  _CalcdField.WorkCenterAvailableCapacity AS WorkCenterAvailableCapacity,
  _CalcdField.WorkCenterCapacityRequirement AS WorkCenterCapacityRequirement,
  _WorkCenterOverview.WorkCenter AS WorkCenter,
  _WorkCenterOverview.WorkCenterResponsible AS WorkCenterResponsible,
  _WorkCenter._Capacity.CapacityResponsiblePlanner AS CapacityResponsiblePlanner,
  _CalcdField.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  _CalcdField.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  _CalcdField.OrderStatusCode AS OrderStatusCode,
  _CalcdField.Criticality AS Criticality,
  _CalcdField.WorkCenterAvgUtilznCriticality AS WorkCenterAvgUtilznCriticality,
  _WorkCenterOverview.Plant AS Plant,
  _CalcdField.PlantName AS PlantName,
  _WorkCenterOverview.CapacityCategoryCode AS CapacityCategoryCode,
  _WorkCenter._CapacityCategory._Text[1:Language=$session.system_language].CapacityCategoryName AS CapacityCategoryName,
  _CalcdField.WrkCtrIsUndrMaintInTmePerd AS WrkCtrIsUndrMaintInTmePerd,
  _CalcdField.WrkCtrMaintOrdAvailabilityTxt AS WrkCtrMaintOrdAvailabilityTxt,
  _CalcdField.WorkCenterFltrCodeInTmePerd AS WorkCenterFltrCodeInTmePerd,
  _CalcdField.WorkCenterGroup AS WorkCenterGroup,
  _CalcdField.WorkCenterGroupType AS WorkCenterGroupType,
  _CalcdField.WorkCenterGroupDescription AS WorkCenterGroupDescription,
  _WorkCenter._Capacity.CapacityIsPooled AS CapacityIsPooled,
  _CalcdField.CurrentPlantDate AS CurrentPlantDate,
  _CalcdField.HorizonStartDate AS HorizonStartDate,
  _CalcdField.HorizonEndDate AS HorizonEndDate,
  _CalcdField.CapEvalBucketType AS CapEvalBucketType,
  _CalcdField.CapEvalStartDate AS CapEvalStartDate,
  _WorkCenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  _CalcdField.CapacityEvaluationHorizonDate AS CapacityEvaluationHorizonDate,
  _CalcdField.CapacityEvaluationOverdueDate AS CapacityEvaluationOverdueDate,
  _WorkCenterOverview.ShiftTableHasChanged AS ShiftTableHasChanged
FROM I_WorkCenterCapOverviewTP AS _WorkCenterOverview
LEFT OUTER JOIN P_CapEvalCalcdField AS _CalcdField ON WorkCenterInternalID = _CalcdField.WorkCenterInternalID AND WorkCenterTypeCode = _CalcdField.WorkCenterTypeCode AND CapacityCategoryAllocation = _CalcdField.CapacityCategoryAllocation AND CapacityInternalID = _CalcdField.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterCapacity AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND CapacityCategoryAllocation = _WorkCenter.CapacityCategoryAllocation AND CapacityInternalID = _WorkCenter.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN C_CapEvalWcUtilznInEvalHorzn AS _WorkCenterUtilization ON WorkCenterInternalID = _WorkCenterUtilization.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterUtilization.WorkCenterTypeCode AND CapacityCategoryAllocation = _WorkCenterUtilization.CapacityCategoryAllocation AND CapacityInternalID = _WorkCenterUtilization.CapacityInternalID  -- association [1..*]
LEFT OUTER JOIN C_CapEvalPplineOp AS _WorkCenterOperation ON WorkCenterInternalID = _WorkCenterOperation.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterOperation.WorkCenterTypeCode AND CapacityCategoryAllocation = _WorkCenterOperation.CapacityCategoryAllocation AND CapacityInternalID = _WorkCenterOperation.CapacityInternalID  -- association [1..*]
LEFT OUTER JOIN C_CapEvalPooledCapacityOps AS _PooledWrkCtrOperation ON WorkCenterTypeCode = _PooledWrkCtrOperation.WorkCenterTypeCode AND CapacityCategoryAllocation = _PooledWrkCtrOperation.CapacityCategoryAllocation AND CapacityInternalID = _PooledWrkCtrOperation.CapacityInternalID  -- association [1..*]
LEFT OUTER JOIN C_WrkCtrAvailableCapacityTP AS _availableCapacity ON WorkCenterInternalID = _availableCapacity.WorkCenterInternalID AND WorkCenterTypeCode = _availableCapacity.WorkCenterTypeCode AND CapacityCategoryAllocation = _availableCapacity.CapacityCategoryAllocation AND CapacityInternalID = _availableCapacity.CapacityInternalID  -- association [1..*]
LEFT OUTER JOIN C_WrkCtrCapShiftIntervalTP AS _availableInterval ON WorkCenterInternalID = _availableInterval.WorkCenterInternalID AND WorkCenterTypeCode = _availableInterval.WorkCenterTypeCode AND CapacityCategoryAllocation = _availableInterval.CapacityCategoryAllocation AND CapacityInternalID = _availableInterval.CapacityInternalID  -- association [1..*]
LEFT OUTER JOIN C_CapEvalOrderStatusFltr AS _OrderStatusFilter ON CapacityInternalID = _OrderStatusFilter.CapacityInternalID AND WorkCenterTypeCode = _OrderStatusFilter.WorkCenterTypeCode AND CapacityCategoryAllocation = _OrderStatusFilter.CapacityCategoryAllocation AND WorkCenterInternalID = _OrderStatusFilter.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN C_CapEvalCapRqmtStsFltr AS _planningStatusFilter ON CapacityInternalID = _planningStatusFilter.CapacityInternalID AND WorkCenterTypeCode = _planningStatusFilter.WorkCenterTypeCode AND CapacityCategoryAllocation = _planningStatusFilter.CapacityCategoryAllocation AND WorkCenterInternalID = _planningStatusFilter.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN C_CapEvalHorizonFltr AS _horizonFilter ON CapacityInternalID = _horizonFilter.CapacityInternalID AND WorkCenterTypeCode = _horizonFilter.WorkCenterTypeCode AND CapacityCategoryAllocation = _horizonFilter.CapacityCategoryAllocation AND WorkCenterInternalID = _horizonFilter.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN C_CapEvalOrderCategoryFltr AS _capRequirementFilter ON CapacityInternalID = _capRequirementFilter.CapacityInternalID AND WorkCenterTypeCode = _capRequirementFilter.WorkCenterTypeCode AND CapacityCategoryAllocation = _capRequirementFilter.CapacityCategoryAllocation AND WorkCenterInternalID = _capRequirementFilter.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN C_CapEvalShiftDefVH AS _shiftDefVH ON CapacityInternalID = _shiftDefVH.CapacityInternalID AND WorkCenterTypeCode = _shiftDefVH.WorkCenterTypeCode AND CapacityCategoryAllocation = _shiftDefVH.CapacityCategoryAllocation AND WorkCenterInternalID = _shiftDefVH.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN C_CapEvalShiftSequenceVH AS _shiftSeqVH ON CapacityInternalID = _shiftSeqVH.CapacityInternalID AND WorkCenterTypeCode = _shiftSeqVH.WorkCenterTypeCode AND CapacityCategoryAllocation = _shiftSeqVH.CapacityCategoryAllocation AND WorkCenterInternalID = _shiftSeqVH.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN C_WrkCntrAssociatedCapForPlnr AS _WrkCntrAssociatedCapForPlnr ON CapacityInternalID = _WrkCntrAssociatedCapForPlnr.CapacityInternalID AND WorkCenterTypeCode = _WrkCntrAssociatedCapForPlnr.WorkCenterTypeCode AND CapacityCategoryAllocation = _WrkCntrAssociatedCapForPlnr.CapacityCategoryAllocation AND WorkCenterInternalID = _WrkCntrAssociatedCapForPlnr.WorkCenterInternalID AND CapacityResponsiblePlanner = _WrkCntrAssociatedCapForPlnr.CapacityResponsiblePlanner  -- association [0..*]
LEFT OUTER JOIN C_CapEvalWorkCenterGroup AS _WrkCntrGroup ON WorkCenter = _WrkCntrGroup.WorkCenter AND Plant = _WrkCntrGroup.Plant  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
;