C_ShopFloorItemSkippedOpActy

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_ShopFloorItemSkippedOpActy.
-- 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: CMPESFISOA

CREATE VIEW C_ShopFloorItemSkippedOpActy AS
SELECT
  ShopFloorItemStatus.ShopFloorItem AS ShopFloorItem,
  ShopFloorItemStatus.OpActyNtwkInstance AS OpActyNtwkInstance,
  ShopFloorItemStatus.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstanceOpActyNtwkElmnt.OrderInternalID AS OrderInternalID,
  OpActyInstanceOpActyNtwkElmnt.OrderOperationInternalID AS OrderOperationInternalID,
  OrderOperation.Plant AS ProductionPlant,
  OpActyInstanceOpActyNtwkElmnt.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  _OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  cast(OrderOperation.OperationText as mfgorderoperationtext preserving type) AS MfgOrderOperationText,
  SFIAtOpActyLatestSASAction.CreationDateTime AS CreationDateTime,
  SFIAtOpActyLatestSASAction.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  SFIAtOpActyLatestSASAction.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  MfgExecDocumentNote.MfgExecutionDocumentNote AS MfgExecutionDocumentNote
FROM I_ShopFloorItemStatus AS ShopFloorItemStatus
INNER JOIN I_OpActyInstceOpActyNtwkElmnt AS OpActyInstanceOpActyNtwkElmnt ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS OrderOperation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrdInternalBillOfOperations ON OrderInternalID = _OrdInternalBillOfOperations.OrderInternalBillOfOperations  -- association [1..1]
;