I_OpActyInstceNtwkElmntBasic

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_OpActyInstceNtwkElmntBasic.
-- 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: IMPEOAIOANIOANEB

CREATE VIEW I_OpActyInstceNtwkElmntBasic AS
SELECT
  oai.OpActyNtwkInstance AS OpActyNtwkInstance,
  oai.OpActyNtwkElement AS OpActyNtwkElement,
  oai.StatusAndActionSchema AS StatusAndActionSchema,
  oai.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  oai.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  oai.ProductionUnit AS ProductionUnit,
  oai.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  oai.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  oai.BillOfOperationsType AS BillOfOperationsType,
  oai.BillOfOperationsGroup AS BillOfOperationsGroup,
  oai.BillOfOperationsVariant AS BillOfOperationsVariant,
  oai.BOOOperationInternalID AS BOOOperationInternalID,
  oai.BillOfOperationsVersion AS BillOfOperationsVersion,
  oai.OperationActivityNetwork AS OperationActivityNetwork,
  oai.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  oai.ManufacturingOrder AS ManufacturingOrder,
  oai.OrderInternalID AS OrderInternalID,
  oai.OrderOperationInternalID AS OrderOperationInternalID,
  oai.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  oai.OpActyConfirmationIsAllowed AS OpActyConfirmationIsAllowed,
  oai.OpActyConfNotAllowedReason AS OpActyConfNotAllowedReason,
  OpActyNtwkElement.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OpActyNtwkElement.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  cast(OpActyNtwkElement.OpActyNtwkElementElement as mpe_oa_id preserving type) AS OperationActivity,
  OpActyNtwkElement.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  cast(OpActyNtwkElement.OpActyNtwkElementElmntVersCntr as mpe_oa_version_no preserving type) AS OperationActyVersionCounter,
  OpActyNtwkElement.OpActyNtwkElementType AS OpActyNtwkElementType,
  OpActyNtwkElement.OANElementDisplaySqncNumber AS OANElementDisplaySqncNumber,
  OpActyNtwkElement.CreatedByUser AS CreatedByUser,
  OpActyNtwkElement.CreationDateTime AS CreationDateTime,
  OpActyNtwkElement.ChangedBy AS ChangedBy,
  OpActyNtwkElement.LastChangeDateTime AS LastChangeDateTime,
  oai._OpActyInstanceStatusBasic AS _OpActyInstanceStatusBasic,
  oai._OpActyNtwkInstance AS _OpActyNtwkInstance,
  oai._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  oai._SASSchema AS _SASSchema,
  oai._UnitOfMeasure AS _UnitOfMeasure,
  oai._MfgOrder AS _MfgOrder,
  oai._ManufacturingOrder AS _ManufacturingOrder,
  oai._MfgOrderOperation AS _MfgOrderOperation,
  oai._OrderOperation AS _OrderOperation,
  oai._OrderOperationBasic AS _OrderOperationBasic,
  oai._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  oai._OperationActivityNetwork AS _OperationActivityNetwork,
  oai._OrderInternalID AS _OrderInternalID,
  OpActyNtwkElement._EventText AS _EventText,
  OpActyNtwkElement._OperationActivity AS _OperationActivity,
  OpActyNtwkElement._OperationActivityNtwkEvent AS _OperationActivityNtwkEvent,
  OpActyNtwkElement._OperationActivityText AS _OperationActivityText
FROM P_OperationActivityInstanceBsc AS oai
INNER JOIN I_OpActyNtwkElement AS OpActyNtwkElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [0..1]
;