I_OpActyConfirmation

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_OpActyConfirmation.
-- 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: IMPEOACONF

CREATE VIEW I_OpActyConfirmation AS
SELECT
  conf.doc_nmbr AS OperationActivityConfirmation,
  conf.oan_instance_id AS OpActyNtwkInstance,
  conf.oan_element_number AS OpActyNtwkElement,
  conf.oac_type AS OpActyConfirmationType,
  conf.sas_action_name AS StatusAndActionSchemaAction,
  conf.action_time AS OpActyConfirmationDateTime,
  conf.crtn_time AS CreationDateTime,
  conf.crtn_user AS CreatedByUser,
  conf.yield AS ConfirmationYieldQuantity,
  conf.scrap AS ConfirmationScrapQuantity,
  conf.scrap_bfr_strt AS ConfirmationScrapBfrProcgQty,
  conf.skip_qty AS ConfirmationSkippedQuantity,
  conf.umren AS QuantityDenominator,
  conf.umrez AS QuantityNumerator,
  conf.uom AS ConfirmationQuantityUnit,
  cast(conf.pdsnr as vdm_pdsnr preserving type ) AS SequentialPlantDataCollection,
  conf.trggrd_by_doc_nmbr AS TriggeredByMfgExecDocument,
  conf.gross_duration AS OpActyStatusDurnInSeconds,
  conf.net_calendar_duration AS CalendarBasedNetDurnInSeconds,
  conf.net_work_center_duration AS WorkCenterBsdNetDurnInSeconds,
  conf.actl_exec_duration AS OpActyActualDurnInSeconds,
  conf.is_posted_retroactively AS PostingIsRetroactive,
  conf.auto_creation_code AS OpActyConfCreationType
FROM mpe_oac AS conf
LEFT OUTER JOIN I_OpActyConfirmationAction AS _OpActyConfirmationAction ON OperationActivityConfirmation = _OpActyConfirmationAction.OperationActivityConfirmation  -- association [1..*]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic ON OpActyNtwkInstance = _OpActyNtwkInstanceBasic.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_OpActyConfirmationType AS _OpActyConfirmationType ON OpActyConfirmationType = _OpActyConfirmationType.OpActyConfirmationType  -- association [1..1]
LEFT OUTER JOIN I_SASAction AS _SASAction ON StatusAndActionSchemaAction = _SASAction.StatusAndActionSchemaAction  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfirmationQuantityUnit ON ConfirmationQuantityUnit = _ConfirmationQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_OpActyConfCreationType AS _OpActyConfCreationType ON OpActyConfCreationType = _OpActyConfCreationType.OpActyConfCreationType  -- association [1..1]
;