I_MfgExecEventHistory

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_MfgExecEventHistory.
-- 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: IMPEEXECHIST

CREATE VIEW I_MfgExecEventHistory AS
SELECT
  h.MfgExecDocumentCategory AS MfgExecDocumentCategory,
  h.ManufacturingExecutionDocument AS ManufacturingExecutionDocument,
  h.MfgExecutionDocumentItem AS MfgExecutionDocumentItem,
  h.MfgProcgExecAction AS MfgProcgExecAction,
  h.ManufacturingOrder 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.Equipment AS Equipment,
  h.MfgObjectLogEventType AS MfgObjectLogEventType,
  h.EventDateTime AS EventDateTime,
  h.ShopFloorExecutionUser AS ShopFloorExecutionUser,
  h.CreatedByUser AS CreatedByUser,
  h.CreationDateTime AS CreationDateTime,
  h.ManufacturingOrderText AS ManufacturingOrderText,
  h.ManufacturingOrderType AS ManufacturingOrderType,
  h.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  h.ProductionPlant AS ProductionPlant,
  OrderItem.MRPPlant AS MRPPlant,
  h.OrderInternalID AS OrderInternalID,
  OrderItem.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  h.ProductionSupervisor AS ProductionSupervisor,
  h.MRPController AS MRPController,
  h.ManufacturingObject AS ManufacturingObject,
  h.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  h.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  h.MfgOrderOperationText AS MfgOrderOperationText,
  h.WorkCenterInternalID AS WorkCenterInternalID,
  h.WorkCenterTypeCode AS WorkCenterTypeCode,
  h.WorkCenterPlant AS WorkCenterPlant,
  h.SortField AS SortField,
  h.ShopFloorItem AS ShopFloorItem,
  h.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  h.OpActyNtwkInstance AS OpActyNtwkInstance,
  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.StatusAndActionSchema AS StatusAndActionSchema,
  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.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  h.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  h.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  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.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  h.ProductionUnit AS ProductionUnit,
  h.OpActyActualDurnInSeconds AS OpActyActualDurnInSeconds,
  h.PostingIsRetroactive AS PostingIsRetroactive,
  h.MfgExecutionDocumentNote AS MfgExecutionDocumentNote,
  h.SystemMessageNumber AS SystemMessageNumber,
  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 P_MfgExecEventHistOrder AS h
INNER JOIN I_OrderItem AS OrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperation AS _MfgOrderOperation ON OrderInternalID = _MfgOrderOperation.OrderInternalBillOfOperations AND OrderOperationInternalID = _MfgOrderOperation.OrderIntBillOfOperationsItem  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderOperationBasic AS _MfgOrderOperationBasic ON OrderInternalID = _MfgOrderOperationBasic.OrderInternalBillOfOperations AND OrderOperationInternalID = _MfgOrderOperationBasic.OrderIntBillOfOperationsItem  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _OrderOperationBasic ON OrderInternalID = _OrderOperationBasic.OrderInternalID AND OrderOperationInternalID = _OrderOperationBasic.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _MRPPlant ON MRPPlant = _MRPPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON ProductionPlant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON MRPPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON ProductionPlant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_Defect AS _Defect ON DefectInternalID = _Defect.DefectInternalID  -- association [0..1]
LEFT OUTER JOIN I_Notification AS _Notification ON Notification = _Notification.Notification  -- association [0..1]
LEFT OUTER JOIN I_NotificationItem AS _NotificationItem ON Notification = _NotificationItem.Notification AND NotificationItem = _NotificationItem.NotificationItem  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Material AS _MaterialComponent ON MaterialComponent = _MaterialComponent.Material  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [0..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [0..1]
LEFT OUTER JOIN I_OperationActivitySFIGroup AS _OperationActivitySFIGroup ON OperationActivitySFIGroup = _OperationActivitySFIGroup.OperationActivitySFIGroup  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _AssembledShopFloorItem ON AssembledShopFloorItem = _AssembledShopFloorItem.ShopFloorItem  -- association [0..1]
LEFT OUTER JOIN I_MfgProcgExecAction AS _MfgProcgExecAction ON MfgProcgExecAction = _MfgProcgExecAction.MfgProcgExecAction  -- association [0..1]
LEFT OUTER JOIN I_MfgObjectLogEventType AS _MfgObjectLogEventType ON MfgObjectLogEventType = _MfgObjectLogEventType.MfgObjectLogEventType  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _MfgActionReasonCodeGroupCtlg ON MfgActionReasonCodeGroupCtlg = _MfgActionReasonCodeGroupCtlg.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_MfgActionReasonCodeGroup AS _MfgActionReasonCodeGroup ON MfgActionReasonCodeGroupCtlg = _MfgActionReasonCodeGroup.MfgActionReasonCodeGroupCtlg AND MfgActionReasonCodeGroup = _MfgActionReasonCodeGroup.MfgActionReasonCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_MfgActionReasonCode AS _MfgActionReasonCode ON MfgActionReasonCodeGroupCtlg = _MfgActionReasonCode.MfgActionReasonCodeGroupCtlg AND MfgActionReasonCodeGroup = _MfgActionReasonCode.MfgActionReasonCodeGroup AND ManufacturingActionReasonCode = _MfgActionReasonCode.ManufacturingActionReasonCode AND _MfgActionReasonCode.Version = '000001'  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingObjectLog AS _ManufacturingObjectLog ON MfgExecDocumentCategory = 9 AND ManufacturingExecutionDocument = _ManufacturingObjectLog.ManufacturingObjectLog  -- association [0..1]
LEFT OUTER JOIN I_OpActyConfirmationAction AS _OpActyConfirmationAction ON MfgExecDocumentCategory = 1 AND ManufacturingExecutionDocument = _OpActyConfirmationAction.OperationActivityConfirmation AND MfgProcgExecAction = _OpActyConfirmationAction.MfgProcgExecAction  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkSegmentType AS _OpActyNtwkSegmentType ON OpActyNtwkSegmentType = _OpActyNtwkSegmentType.OpActyNtwkSegmentType  -- association [0..1]
LEFT OUTER JOIN I_SASSchema AS _SASSchema ON StatusAndActionSchema = _SASSchema.StatusAndActionSchema  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItemConfirmation AS _ShopFloorItemConfirmation ON MfgExecDocumentCategory = 2 AND ManufacturingExecutionDocument = _ShopFloorItemConfirmation.ShopFloorItemStatusChangeDoc  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderComponentAssembly AS _MfgOrderComponentAssembly ON MfgExecDocumentCategory = 3 AND ManufacturingExecutionDocument = _MfgOrderComponentAssembly.AssemblyDocument AND MfgExecutionDocumentItem = _MfgOrderComponentAssembly.AssemblyDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductionUnit ON ProductionUnit = _ProductionUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PlannedInvtryUsblyCodeText AS _PlannedInvtryUsblyCodeText ON MfgExecDocumentCategory = 3 AND InventoryUsabilityCode = _PlannedInvtryUsblyCodeText.PlannedInventoryUsabilityCode  -- association [0..*]
;