C_ShopFloorOrderOperation

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 C_ShopFloorOrderOperation.
-- 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: CMPESFOOPER

CREATE VIEW C_ShopFloorOrderOperation AS
SELECT
  MfgOrderOperation.OrderInternalBillOfOperations AS OrderInternalID,
  MfgOrderOperation.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  MfgOrderOperation.MfgOrderOperationText AS MfgOrderOperationText,
  MfgOrderOperation._MfgOrder._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  MfgOrderOperation.OperationControlProfile AS OperationControlProfile,
  MfgOrderOperation._OperationControlProfile._Text[1: Language=$session.system_language].OperationControlProfileName AS OperationControlProfileName,
  MfgOrderOperation.WorkCenterInternalID AS WorkCenterInternalID,
  cast(MfgOrderOperation.WorkCenterTypeCode as pph_objty) AS WorkCenterTypeCode,
  MfgOrderOperation._WorkCenter.WorkCenter AS WorkCenter,
  MfgOrderOperation.ProduceOpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderOperation.ProductionPlant AS ProductionPlant,
  MfgOrderOperation._OperationControlProfile AS _OperationControlProfile,
  MfgOrderOperation._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  MfgOrderOperation._MfgOrder AS _MfgOrder,
  MfgOrderOperation._MfgOrder._Material AS _Material,
  MfgOrderOperation._ProductionPlant AS _ProductionPlant
FROM I_MfgOrderOperation AS MfgOrderOperation
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOpDocInfoRecdObjLink AS _MfgOrderOpDocInfoRecdObjLink ON ManufacturingOrder = _MfgOrderOpDocInfoRecdObjLink.ManufacturingOrder AND OrderOperationInternalID = _MfgOrderOpDocInfoRecdObjLink.OrderOperationInternalID  -- association [0..*]
;