I_SchedProdnWrkCtrSqncVH

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_SchedProdnWrkCtrSqncVH.
-- 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: ISHEDPDWCSQNCVH

CREATE VIEW I_SchedProdnWrkCtrSqncVH AS
SELECT
  cast (_LogisticsOrder.OrderID as pph_cfs_ordernumber) AS OrderID,
  cast (_LogisticsOrder.OrderCategory as pph_cfs_sch_ordercategory) AS OrderCategory,
  _prodvers.Material AS Product,
  _prodvers.Plant AS Plant,
  _prodvers.ProductionVersion AS ProductionVersion,
  _prodvers.ProductionLine AS WorkCenter,
  _WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  _WorkCenterText[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  BOOExplosionDate,
  BOMExplosionDate,
  cast('00000000' as psttr ) AS PlndOrderPlannedStartDate,
  PlndOrderPlannedEndDate
FROM I_ProductionVersion AS _prodvers
INNER JOIN I_WorkCenter AS _WorkCenter ON /* join condition not captured in parsed metadata */
INNER JOIN I_Capacity AS _Capacity ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrder AS _LogisticsOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_PlannedOrder AS _PlannedOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID  -- association [0..*]
-- UNION ALL with additional select branch(es): I_ProductionVersion
;