I_WorkCenterCapPplineOp

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 I_WorkCenterCapPplineOp.
-- 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: IWCCAPPPLINEOP

CREATE VIEW I_WorkCenterCapPplineOp AS
SELECT
  WrkCtrCapPplineOp.WorkCenterInternalID AS WorkCenterInternalID,
  WrkCtrCapPplineOp.WorkCenterTypeCode AS WorkCenterTypeCode,
  WrkCtrCapPplineOp.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WrkCtrCapPplineOp.CapacityInternalID AS CapacityInternalID,
  WrkCtrCapPplineOp.OrderID AS OrderID,
  WrkCtrCapPplineOp.Operation AS Operation,
  WrkCtrCapPplineOp.CapacityRequirement AS CapacityRequirement,
  WrkCtrCapPplineOp.Material AS Material,
  WrkCtrCapPplineOp.CapacityRequirementItem AS CapacityRequirementItem,
  WrkCtrCapPplineOp.Plant AS Plant,
  WrkCtrCapPplineOp.MRPController AS MRPController,
  WrkCtrCapPplineOp.WorkCenter AS WorkCenter,
  WrkCtrCapPplineOp.WorkCenterResponsible AS WorkCenterResponsible,
  WrkCtrCapPplineOp.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WrkCtrCapPplineOp.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  WrkCtrCapPplineOp.CapacityRequirementUnit AS CapacityRequirementUnit,
  WrkCtrCapPplineOp.CapacityBaseQtyUnit AS CapacityBaseQtyUnit,
  WrkCtrCapPplineOp.OrderInternalID AS OrderInternalID,
  WrkCtrCapPplineOp.OrderType AS OrderType,
  WrkCtrCapPplineOp.OrderCategory AS OrderCategory,
  WrkCtrCapPplineOp.ProductionVersion AS ProductionVersion,
  WrkCtrCapPplineOp.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  WrkCtrCapPplineOp.BaseUnit AS BaseUnit,
  WrkCtrCapPplineOp.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  WrkCtrCapPplineOp.OperationLatestStartDate AS OperationLatestStartDate,
  WrkCtrCapPplineOp.OperationLatestStartTime AS OperationLatestStartTime,
  WrkCtrCapPplineOp.OperationLatestEndDate AS OperationLatestEndDate,
  WrkCtrCapPplineOp.OperationLatestEndTime AS OperationLatestEndTime,
  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,
  case when WrkCtrCapPplineOp.CapacityRequirementsAreDtmnd > 99999999 then fltp_to_dec(99999999.99 as abap.dec( 10,2)) else cast(round(fltp_to_dec(WrkCtrCapPplineOp.CapacityRequirementsAreDtmnd as abap.dec( 12,4)),2) as abap.dec(10,2)) end as CapacityRequirementsAreDtmnd AS dec102endasCapacityRequirementsAreDtmnd,
  WrkCtrCapPplineOp.OrderStatusCode AS OrderStatusCode,
  WrkCtrCapPplineOp.OrderFirmingStatusCode AS OrderFirmingStatusCode,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  CurrentDate,
  LtstSchedldExecStrtDteTme,
  LtstSchedldExecEndDteTme,
  WrkCtrCapPplineOp.Sequence AS Sequence,
  WrkCtrCapPplineOp.ProductConfiguration AS ProductConfiguration,
  WrkCtrCapPplineOp.PlantTimeZone AS PlantTimeZone,
  WrkCtrCapPplineOp.SalesOrder AS SalesOrder,
  WrkCtrCapPplineOp.SalesOrderItem AS SalesOrderItem
FROM P_WorkCenterCapPplineOp AS WrkCtrCapPplineOp
;