P_MfgExecEventHistoryCnsmpn

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_MfgExecEventHistoryCnsmpn.
-- 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: PMPEEXECHISTC

CREATE VIEW P_MfgExecEventHistoryCnsmpn AS
SELECT
  h.MfgExecDocumentCategory AS MfgExecDocumentCategory,
  h.ManufacturingExecutionDocument AS ManufacturingExecutionDocument,
  h.MfgExecutionDocumentItem AS MfgExecutionDocumentItem,
  h.MfgProcgExecAction AS MfgProcgExecAction,
  cast(h.ManufacturingOrder as mpe_production_order preserving type ) AS ManufacturingOrder,
  h.OrderOperationInternalID AS OrderOperationInternalID,
  h.InspectionCharacteristic AS InspectionCharacteristic,
  h.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  h.InspResultValueInternalID AS InspResultValueInternalID,
  h.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  h.ChangeDocument AS ChangeDocument,
  h.MfgBuyOffAction AS MfgBuyOffAction,
  h.EventDateTime AS EventDateTime,
  h.ShopFloorExecutionUser AS ShopFloorExecutionUser,
  _ExecutionUser.UserDescription AS ShopFloorExecutionUserName,
  h.CreatedByUser AS CreatedByUser,
  h.Equipment AS Equipment,
  h.CreationDateTime AS CreationDateTime,
  h.SortField AS SortField,
  h.OrderInternalID AS OrderInternalID,
  h.Material AS Material,
  h.MaterialName AS MaterialName,
  h.ProductionSupervisor AS ProductionSupervisor,
  h.MRPController AS MRPController,
  h.ManufacturingObject AS MfgOrderObjectInternalID,
  h.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  h.MfgOrderOperationText AS MfgOrderOperationText,
  h.ManufacturingOrderType AS ManufacturingOrderType,
  h.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  h.ProductionPlant AS ProductionPlant,
  h.MRPPlant AS MRPPlant,
  h.WorkCenterInternalID AS WorkCenterInternalID,
  h.WorkCenterTypeCode AS WorkCenterTypeCode,
  h.WorkCenterPlant AS WorkCenterPlant,
  h.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  h.OpActyNtwkElement AS OpActyNtwkElement,
  h.OperationActivityName AS OperationActivityName,
  h.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  h.OperationActivityNetwork AS OperationActivityNetwork,
  h.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  h.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  h.OperationActivity AS OperationActivity,
  h.OperationActyVersionCounter AS OperationActyVersionCounter,
  h.DefectInternalID AS DefectInternalID,
  h.Notification AS Notification,
  h.NotificationItem AS NotificationItem,
  h.MaterialComponent AS MaterialComponent,
  h.MaterialComponentName AS MaterialComponentName,
  h.AssembledShopFloorItem AS AssembledShopFloorItem,
  h.AssembledSerialNumber AS AssembledSerialNumber,
  h.AssembledMfrSerialNumber AS AssembledMfrSerialNumber,
  h.AssembledBatch AS AssembledBatch,
  h.ReplacedShopFloorItem AS ReplacedShopFloorItem,
  h.ReplacedSerialNumber AS ReplacedSerialNumber,
  h.ReplacedBatch AS ReplacedBatch,
  h.MfgOrderSplitChildOrder AS MfgOrderSplitChildOrder,
  h.BOMExplosionDate AS BOMExplosionDate,
  h.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  h.StorageLocation AS StorageLocation,
  h.InventoryUsabilityCode AS InventoryUsabilityCode,
  h.CompDisassemblyPermanence AS CompDisassemblyPermanence,
  h.MaterialComponentHasReltdComp AS MaterialComponentHasReltdComp,
  h.Defect AS Defect,
  h.DefectText AS DefectText,
  h.QltyTaskFollowUpAction AS QltyTaskFollowUpAction,
  h.MfgBuyOffInternalID AS MfgBuyOffInternalID,
  h.MfgBuyOffDescription AS MfgBuyOffDescription,
  h.MfgBuyOffReferencedStep AS MfgBuyOffReferencedStep,
  h.MfgBuyOffAdhocStepDescription AS MfgBuyOffAdhocStepDescription,
  h.MfgBuyOffCycle AS MfgBuyOffCycle,
  h.RespyMgmtTeamID AS RespyMgmtTeamID,
  h.RespyMgmtFunction AS RespyMgmtFunction,
  h.InspectionSpecificationText AS InspectionSpecificationText,
  h.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  h.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  h.InspectionResultMeanValue AS InspectionResultMeanValue,
  h.InspectionResultMeasuredValue AS InspectionResultMeasuredValue,
  h.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  h.InspectionValuationResult AS InspectionValuationResult,
  h.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  h.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  h.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  h.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  h.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  case when h.ManufacturingActionReasonCode = '' then '' else 'X' end AS MfgExecDocReasonCodeIsExisting,
  h.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  h.ProductionUnit AS ProductionUnit,
  h.OpActyActualDurnInSeconds AS OpActyActualDurnInSeconds,
  h.PostingIsRetroactive AS PostingIsRetroactive,
  h.MfgExecutionDocumentNote AS MfgExecutionDocumentNote,
  h.SystemMessageIdentification AS SystemMessageIdentification,
  h.MfgExecHistMsgVarblField1 AS MfgExecHistMsgVarblField1,
  h.MfgExecHistMsgVarblField2 AS MfgExecHistMsgVarblField2,
  h.MfgExecHistMsgVarblField3 AS MfgExecHistMsgVarblField3,
  h.MfgExecHistMsgVarblField4 AS MfgExecHistMsgVarblField4,
  h.MfgProcgExecAttachmentName AS MfgProcgExecAttachmentName
FROM I_MfgExecEventHistory AS h
LEFT OUTER JOIN I_MfgOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_OpActyNtwkElement AS _OpActyNtwkElement ON OperationActivityNetwork = _OpActyNtwkElement.OperationActivityNetwork AND OpActyNtwkVersionCounter = _OpActyNtwkElement.OpActyNtwkVersionCounter AND OpActyNtwkElement = _OpActyNtwkElement.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ExecutionUser ON ShopFloorExecutionUser = _ExecutionUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
;