C_ShopFloorOrderOperationActy

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_ShopFloorOrderOperationActy.
-- 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: CMPESFOOA

CREATE VIEW C_ShopFloorOrderOperationActy AS
SELECT
  OpActyInstanceOpActyNtwkElmnt.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstanceOpActyNtwkElmnt.OrderInternalID AS OrderInternalID,
  OpActyInstanceOpActyNtwkElmnt.OrderOperationInternalID AS OrderOperationInternalID,
  OpActyInstanceOpActyNtwkElmnt.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  OrderOperation.Plant AS ProductionPlant,
  OpActyInstanceOpActyNtwkElmnt.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstanceOpActyNtwkElmnt._MfgOrder.Material AS Material,
  OpActyInstanceOpActyNtwkElmnt._MfgOrder._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  cast(OrderOperation.Operation as mpe_vornr_char preserving type) AS ManufacturingOrderOperation,
  cast(OrderOperation.OperationText as mfgorderoperationtext preserving type) AS MfgOrderOperationText,
  cast(OpActyInstanceOpActyNtwkElmnt.OpActyNtwkElementExternalID as mpe_oa_number_ext preserving type) AS OpActyNtwkElementExternalID,
  OpActyInstanceOpActyNtwkElmnt._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  OpActyNtwkGroupElement.OpActyNtwkElementElmntVersCntr AS OpActyNtwkGroupVersionCounter,
  cast(OpActyNtwkGroupElement.OpActyNtwkElementExternalID as mpe_group_number_ext preserving type) AS OpActyNtwkGroupExternalID,
  OpActyInstanceStatusBasic._SASStatus.SASStatusCategory AS SASStatusCategory,
  OpActyInstanceOpActyNtwkElmnt.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  cast(OpActyInstanceOpActyNtwkElmnt.OpPlannedYieldQuantity + OpActyInstanceOpActyNtwkElmnt.OpPlannedScrapQuantity as mpe_oa_planned_qty) AS PlannedQuantity,
  cast( 0 as xmnga ) AS ConfirmationScrapQuantity,
  cast( 0 as mpe_skipped_qty ) AS ConfirmationSkippedQuantity,
  OpActyWorkInstructionAssgmt.WorkInstruction AS WorkInstruction,
  OpActyWorkInstructionAssgmt.WorkInstructionVersionCounter AS WorkInstructionVersionCounter,
  _MfgWorkInstructionVersion.MfgWorkInstructionContent AS MfgWorkInstructionContent,
  _MfgWorkInstruction.MfgWorkInstructionMode AS MfgWorkInstructionMode,
  OpActyInstanceOpActyNtwkElmnt._MfgOrder AS _MfgOrder,
  OpActyInstanceOpActyNtwkElmnt._MfgOrder._Material AS _Material,
  OpActyInstanceStatusBasic._SASStatus AS _SASStatus,
  OpActyInstanceStatusBasic._SASStatus._SASStatusCategory AS _SASStatusCategory,
  OpActyWorkInstructionAssgmt._WorkInstructionInternalId AS _WorkInstructionInternalId,
  OpActyWorkInstructionAssgmt._WorkInstruction AS _WorkInstruction,
  OpActyInstanceOpActyNtwkElmnt._OANSegmentType AS _OANSegmentType,
  OpActyInstanceOpActyNtwkElmnt._OpActyNtwkInstance AS _OpActyNtwkInstance
FROM I_OpActyInstceOpActyNtwkElmnt AS OpActyInstanceOpActyNtwkElmnt
INNER JOIN I_OpActyInstanceStatusBasic AS OpActyInstanceStatusBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperation AS OrderOperation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_OperationActyPRTAssignment AS _OperationActyPRTAssignment ON OpActyNtwkInstance = _OperationActyPRTAssignment.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActyPRTAssignment.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_SFOAssldTraceableComponent AS _SFOAssldTraceableComponent ON OpActyNtwkInstance = _SFOAssldTraceableComponent.OpActyNtwkInstance AND OpActyNtwkElement = _SFOAssldTraceableComponent.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_SFOAssldNonTrcblComponent AS _SFOAssldNonTrcblComponent ON OpActyNtwkInstance = _SFOAssldNonTrcblComponent.OpActyNtwkInstance AND OpActyNtwkElement = _SFOAssldNonTrcblComponent.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_MfgExecEventHistory AS _MfgExecEventHistory ON OpActyNtwkInstance = _MfgExecEventHistory.OpActyNtwkInstance AND OpActyNtwkElement = _MfgExecEventHistory.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN P_OpActyProdnRsceToolAssAgg2 AS _OpActyProdnRsceToolAssAgg ON OpActyNtwkInstance = _OpActyProdnRsceToolAssAgg.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyProdnRsceToolAssAgg.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN I_OpActyInstanceStatusBasic AS _OpActyInstanceStatusBasic ON OpActyNtwkInstance = _OpActyInstanceStatusBasic.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyInstanceStatusBasic.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN I_SASStatusText AS _SASStatusText ON StatusAndActionSchemaStatus = _SASStatusText.StatusAndActionSchemaStatus  -- association [0..*]
LEFT OUTER JOIN I_OANSegmentTypeText AS _OANSegmentTypeText ON OpActyNtwkSegmentType = _OANSegmentTypeText.OpActyNtwkSegmentType  -- association [0..*]
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrdInternalBillOfOperations ON OrderInternalID = _OrdInternalBillOfOperations.OrderInternalBillOfOperations  -- association [1..1]
LEFT OUTER JOIN I_MfgWorkInstruction AS _MfgWorkInstruction ON WorkInstruction = _MfgWorkInstruction.MfgWorkInstruction AND WorkInstructionVersionCounter = _MfgWorkInstruction.MfgWorkInstructionVersCounter  -- association [0..1]
LEFT OUTER JOIN I_MfgWorkInstructionVersion AS _MfgWorkInstructionVersion ON WorkInstruction = _MfgWorkInstructionVersion.MfgWorkInstruction AND WorkInstructionVersionCounter = _MfgWorkInstructionVersion.MfgWorkInstructionVersCounter AND _MfgWorkInstructionVersion.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderOpActyInspCharcs AS _MfgOrderOpActyInspCharcs ON OrderOperationInternalID = _MfgOrderOpActyInspCharcs.OrderOperationInternalID AND OpActyNtwkInstance = _MfgOrderOpActyInspCharcs.OpActyNtwkInstance AND OpActyNtwkElement = _MfgOrderOpActyInspCharcs.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _SkippedByUserContactCard ON CreatedByUserName = _SkippedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderOpDocInfoRecdObjLink AS _MfgOrderOpDocInfoRecdObjLink ON ManufacturingOrder = _MfgOrderOpDocInfoRecdObjLink.ManufacturingOrder AND OrderOperationInternalID = _MfgOrderOpDocInfoRecdObjLink.OrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderDocInfoRecdObjLink AS _MfgOrderDocInfoRecdObjLink ON ManufacturingOrder = _MfgOrderDocInfoRecdObjLink.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN C_MfgQualifnOpActyAssgmt AS _MfgQualifnOpActyAssgmt ON OpActyNtwkInstance = _MfgQualifnOpActyAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _MfgQualifnOpActyAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_SFOOpActyTrcblUsedPRT AS _SFOOpActyTrcblUsedPRT ON OrderInternalID = _SFOOpActyTrcblUsedPRT.OrderInternalID AND OpActyNtwkInstance = _SFOOpActyTrcblUsedPRT.OpActyNtwkInstance AND OpActyNtwkElement = _SFOOpActyTrcblUsedPRT.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_SFOOpActyNonTrcblUsedPRT AS _SFOOpActyNonTrcblUsedPRT ON OrderInternalID = _SFOOpActyNonTrcblUsedPRT.OrderInternalID AND OpActyNtwkInstance = _SFOOpActyNonTrcblUsedPRT.OpActyNtwkInstance AND OpActyNtwkElement = _SFOOpActyNonTrcblUsedPRT.OpActyNtwkElement  -- association [0..*]
;