P_WorkCenterCalcdField

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_WorkCenterCalcdField.
-- 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: PWRKCTRCALFLD

CREATE VIEW P_WorkCenterCalcdField AS
SELECT
  WorkCenterCapacity.WorkCenterInternalID AS WorkCenterInternalID,
  WorkCenterCapacity.WorkCenterTypeCode AS WorkCenterTypeCode,
  WorkCenterCapacity.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WorkCenterCapacity.WorkCenter AS WorkCenter,
  WorkCenterCapacity.Plant AS Plant,
  cast('' as co_dispo ) AS MRPController,
  WorkCenterCapacity.CapacityInternalID AS CapacityInternalID,
  WorkCenterCapacity._WorkCenter.WorkCenterResponsible AS WorkCenterResponsible,
  WorkCenterCapacity.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  cast('1' as capacityrequirementorigin) AS CapacityRequirementOrigin,
  cast ('' as matnr) AS Material,
  cast ('' as abap.char(12)) AS OrderID,
  cast ('' as vornr) AS Operation,
  cast (' ' as kaptprog) AS ShiftName,
  cast('' as abap.char(10)) AS CapacityEvaluationTimePeriod,
  cast('' as abap.char(2)) AS CapacityEvaluationTimePerdCode,
  cast('' as cr_wfcid ) AS FactoryCalendar,
  cast('' as cy_keinh) AS CapacityRequirementUnit,
  cast('' as aufart) AS OrderType,
  cast('' as pph_cfs_sch_ordercategory ) AS OrderCategory,
  cast(0 as gamng) AS OrderPlannedTotalQty,
  cast('' as meins ) AS BaseUnit,
  cast('' as verid) AS ProductionVersion,
  cast('' as abap.char(4)) AS OperationPlanningStatusCode,
  cast('' as sstad) AS OperationLatestStartDate,
  cast('' as sstau) AS OperationLatestStartTime,
  cast('' as sendd) AS OperationLatestEndDate,
  cast('' as sendu) AS OperationLatestEndTime,
  cast('' as abap.char(5) ) AS OrderStatusCode,
  cast('0' as char1) AS OrderFirmingStatusCode,
  cast('' as sssbd) AS OpLtstSchedldProcgStrtDte,
  cast('' as sssbz) AS OpLtstSchedldProcgStrtTme,
  cast('' as sssad) AS OpLtstSchedldTrdwnStrtDte,
  cast('' as sssaz) AS OpLtstSchedldTrdwnStrtTme,
  cast(0 as abap.dec(10,2)) AS RemainingCapReqOpSegSetupDurn,
  cast(0 as abap.dec(10,2)) AS RemainingCapReqOpSegProcgDurn,
  cast(0 as abap.dec(10,2)) AS RemainingCapReqOpSegTrdwnDurn,
  cast('' as pph_aufpl ) AS OrderInternalID,
  cast(0 as kapbegzt ) AS CapacityStartTime,
  cast(0 as kapendzt ) AS CapacityEndTime,
  cast(0 as abap.fltp) AS WorkCenterAvailableCapacity,
  cast(0 as abap.fltp) AS WorkCenterCapRqmtInCapUnit,
  cast(0 as abap.fltp) AS WrkCtrRmngCapInCapUnit,
  cast(0 as abap.fltp) AS WorkCenterTotUtilznInTmePerd,
  cast ('H' as meins) AS WorkCenterCapacityUnit
FROM I_WorkCenterCapacity AS WorkCenterCapacity
;