I_ProductionOrderTriggerPoint

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_ProductionOrderTriggerPoint.
-- 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.

CREATE VIEW I_ProductionOrderTriggerPoint AS
SELECT
  cast(mlst.ProjectMilestone as pph_mlst_zaehl preserving type) AS TriggerPointNumber,
  cast(mlst.MilestoneDescription as pph_mlst_ktext preserving type) AS TriggerPointName,
  oper.OrderInternalBillOfOperations AS OrderInternalID,
  oper.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  cast(mlst.ProjectMilestoneInternalID as pph_mlst_intid preserving type) AS TriggerPointInternalID,
  mlst.IsDeleted AS IsMarkedForDeletion,
  mlst.UsageCode AS TriggerPointUsage,
  mlst.CreationDate AS CreationDate,
  mlst.LastChangeDate AS LastChangeDate,
  mlst.CreatedByUser AS CreatedByUser,
  mlst.LastChangedByUser AS LastChangedByUser,
  cast(oper.ManufacturingOrder as vdm_manufacturingorder preserving type) AS ProductionOrder,
  cast(oper.ManufacturingOrderType as vdm_prodnordertype preserving type) AS ProductionOrderType,
  cast(oper.ManufacturingOrderSequence as vdm_prodnordersequence preserving type) AS ProductionOrderSequence,
  cast(oper.ManufacturingOrderOperation_2 as vdm_prodnorderoperation preserving type) AS ProductionOrderOperation,
  oper.ProductionPlant AS ProductionPlant,
  oper.WorkCenterTypeCode_2 AS WorkCenterType,
  oper.WorkCenterInternalID AS WorkCenterInternalID,
  cast(oper.OperationControlProfile as pph_steus preserving type) AS OperationControlProfile,
  mlst.ScheduledBasicDate AS ScheduledBasicDate,
  mlst.FixedBasicDate AS FixedBasicDate,
  mlst.ActualEndDate AS ActualEndDate,
  mlst.MlstnReleaseStopIsActive AS TrggrPtReleaseStopIsActive,
  cast(mlst.MlstnIsUsedforMlstnFunc as vdm_pp_wflow preserving type) AS TrggrPtIsUsedForTrggrPtFunc,
  cast(mlst.MlstnIsMarkedForCreateNtwk as vdm_pp_incnw preserving type) AS TrggrPtIsMarkedForCreateOrder,
  cast(mlst.MlstnIsMarkedForIncludeSubNtwk as vdm_pp_incpn preserving type) AS TrggrPtIsMarkedForInsertRefOp,
  cast(mlst.MlstnIsMarkedForCreateSubNtwk as vdm_pp_incsn preserving type) AS TrggrPtIsMarkedForRelPrevOp,
  cast(mlst.MlstnIsMarkedForRelFllwngActy as vdm_pp_relsu preserving type) AS TrggrPtIsMarkedForRelFllwngOp,
  mlst.MlstnIsMarkedForRelUptoStopInd AS TrggrPtIsMarkedForRelUpToStop,
  mlst.MlstnIsMarkedForStrtWrkflwTsk AS TrggrPtIsMrkdForStartWrkflwTsk,
  oper._ProductionPlant AS _ProductionPlant,
  oper._OperationControlProfile AS _OperationControlProfile
FROM I_Projectmilestone AS mlst
INNER JOIN I_MfgOrderOperationBasic AS oper ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrderType AS _ProductionOrderType ON ProductionOrderType = _ProductionOrderType.ProductionOrderType  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterType = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterType = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_TriggerPointUsage AS _TriggerPointUsage ON TriggerPointUsage = _TriggerPointUsage.TriggerPointUsage  -- association [0..1]
LEFT OUTER JOIN I_TriggerPointText AS _TriggerPointText ON TriggerPointNumber = _TriggerPointText.TriggerPointNumber  -- association [0..*]
LEFT OUTER JOIN I_ProductionOrder AS _ProductionOrderHeader ON ProductionOrder = _ProductionOrderHeader.ProductionOrder  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrderSequence AS _ProductionOrderSequence ON ProductionOrder = _ProductionOrderSequence.ProductionOrder AND ProductionOrderSequence = _ProductionOrderSequence.ProductionOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlantText ON ProductionPlant = _ProductionPlantText.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrder AS _ProductionOrderText ON ProductionOrder = _ProductionOrderText.ProductionOrder  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID AND WorkCenterType = _WorkCenterText.WorkCenterTypeCode  -- association [0..*]
;