P_MfgExecEventHistOpActy2

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 P_MfgExecEventHistOpActy2.
-- 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: PMPEEXECHISTOA2

CREATE VIEW P_MfgExecEventHistOpActy2 AS
SELECT
  u.MfgExecDocumentCategory AS MfgExecDocumentCategory,
  u.ManufacturingExecutionDocument AS ManufacturingExecutionDocument,
  u.MfgExecutionDocumentItem AS MfgExecutionDocumentItem,
  u.MfgProcgExecAction AS MfgProcgExecAction,
  u.ActionIsSASAction AS ActionIsSASAction,
  cast(' ' as mpe_buyoff_action preserving type) AS MfgBuyOffAction,
  u.MfgObjectLogEventType AS MfgObjectLogEventType,
  u.EventDateTime AS EventDateTime,
  u.ShopFloorExecutionUser AS ShopFloorExecutionUser,
  u.CreatedByUser AS CreatedByUser,
  u.CreationDateTime AS CreationDateTime,
  u.SortField AS SortField,
  u.ShopFloorItem AS ShopFloorItem,
  u.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  u.OpActyNtwkInstance AS OpActyNtwkInstance,
  u.OpActyNtwkElement AS OpActyNtwkElement,
  u.StatusAndActionSchema AS StatusAndActionSchema,
  u.DefectInternalID AS DefectInternalID,
  u.Notification AS Notification,
  u.NotificationItem AS NotificationItem,
  u.MaterialComponent AS MaterialComponent,
  u.MaterialComponentName AS MaterialComponentName,
  u.AssembledShopFloorItem AS AssembledShopFloorItem,
  u.AssembledSerialNumber AS AssembledSerialNumber,
  u.AssembledMfrSerialNumber AS AssembledMfrSerialNumber,
  u.AssembledBatch AS AssembledBatch,
  u.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  u.ReplacedShopFloorItem AS ReplacedShopFloorItem,
  u.ReplacedSerialNumber AS ReplacedSerialNumber,
  u.ReplacedBatch AS ReplacedBatch,
  cast('' as mpe_exchanged_material) AS SubstitutedProduct,
  cast('' as maktx) AS SubstitutedProductName,
  u.AlternativeItemGroup AS AlternativeItemGroup,
  u.StorageLocation AS StorageLocation,
  u.InventoryUsabilityCode AS InventoryUsabilityCode,
  u.CompDisassemblyPermanence AS CompDisassemblyPermanence,
  u.MaterialComponentHasReltdComp AS MaterialComponentHasReltdComp,
  cast(0 as mpe_buyoff_step) AS MfgBuyOffInternalID,
  cast(0 as mpe_buyoff_step) AS MfgBuyOffReferencedStep,
  cast('' as mpe_buyoffsqnc_desc) AS MfgBuyOffAdhocStepDescription,
  cast('000000000000000' as mpe_buyoff_cycle_id preserving type) AS MfgBuyOffCycle,
  cast('00000000' as hrobjid preserving type) AS RespyMgmtTeamID,
  cast('' as rsm_de_function) AS RespyMgmtFunction,
  u.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  u.ProductionUnit AS ProductionUnit,
  u.OpActyActualDurnInSeconds AS OpActyActualDurnInSeconds,
  u.PostingIsRetroactive AS PostingIsRetroactive,
  u.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  u.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  u.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  note.MfgExecutionDocumentNote AS MfgExecutionDocumentNote,
  u.Equipment AS Equipment,
  u.SystemMessageNumber AS SystemMessageNumber,
  u.SystemMessageIdentification AS SystemMessageIdentification,
  u.MfgExecHistMsgVarblField1 AS MfgExecHistMsgVarblField1,
  u.MfgExecHistMsgVarblField2 AS MfgExecHistMsgVarblField2,
  u.MfgExecHistMsgVarblField3 AS MfgExecHistMsgVarblField3,
  u.MfgExecHistMsgVarblField4 AS MfgExecHistMsgVarblField4,
  cast('' as qdefectid) AS Defect,
  cast('' as mpe_file_name) AS MfgProcgExecAttachmentName,
  dats_tims_to_tstmp(Defect.CreationDate,Defect.CreationTime,abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as EventDateTime AS clientNULLasEventDateTime,
  dats_tims_to_tstmp(Defect.CreationDate,Defect.CreationTime,abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CreationDateTime AS clientNULLasCreationDateTime,
  cast('' as mpe_buyoffsqnc_desc ) AS MfgBuyoffDescription
FROM P_MfgExecEventHistOpActy AS u
-- UNION ALL with additional select branch(es): I_MfgBuyOffActionHistory
;