I_MfgOrderOperationBySemKey

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_MfgOrderOperationBySemKey.
-- 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: IMFGORDOPBYSEMK

CREATE VIEW I_MfgOrderOperationBySemKey AS
SELECT
  afvc.ManufacturingOrder AS ManufacturingOrder,
  afvc.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  afvc.ManufacturingOrderOperation_2 AS ManufacturingOrderOperation,
  afvc.OperationIsSubOperation AS OperationIsSubOperation,
  afvc.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  afvc.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  afvc.ManufacturingOrderType AS ManufacturingOrderType,
  afvc.ProductionPlant AS ProductionPlant,
  cast(afvc.MfgOrderOperationText as mfgorderoperationtext preserving type) AS MfgOrderOperationText,
  afvc.Language AS LongTextLanguage,
  afvc.OrderInternalBillOfOperations AS OrderInternalID,
  afvc.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  afvc.OperationConfirmation AS OperationConfirmation,
  afvc.NumberOfOperationConfirmations AS NumberOfOperationConfirmations
FROM I_MfgOrderOperationBasic AS afvc
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguage = _LongTextLanguage.Language  -- association [0..1]
;