C_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 C_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: CMPEEXECHIST

CREATE VIEW C_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.SortField AS SortField,
  h.EventDateTime AS EventDateTime,
  cast('' as vdm_userdescription) AS ShopFloorExecutionUserName,
  h.CreationDateTime AS CreationDateTime,
  h.CreatedByUser AS CreatedByUser,
  cast('' as vdm_userdescription) AS CreatedByUserName,
  h.RespyMgmtTeamID AS RespyMgmtTeamID,
  cast('' as mpe_buyoff_team_name) AS RespyMgmtTeamName,
  cast('' as rsm_de_team_descr) AS RespyMgmtTeamDescription,
  h.RespyMgmtFunction AS RespyMgmtFunction,
  cast('' as rsm_de_function_descr) AS RespyMgmtFunctionDescription,
  h.SystemMessageIdentification AS SystemMessageIdentification,
  cast(h.MfgExecHistMsgVarblField1 as mpe_log_variable1 preserving type ) AS MfgExecHistMsgVarblField1,
  cast(h.MfgExecHistMsgVarblField2 as mpe_log_variable2 preserving type ) AS MfgExecHistMsgVarblField2,
  cast(h.MfgExecHistMsgVarblField3 as mpe_log_variable3 preserving type ) AS MfgExecHistMsgVarblField3,
  cast(h.MfgExecHistMsgVarblField4 as mpe_log_variable4 preserving type ) AS MfgExecHistMsgVarblField4,
  h.MfgProcgExecAttachmentName AS MfgProcgExecAttachmentName,
  cast( '' as mpe_action_message_description ) AS SystemMessageDescription,
  h.MfgBuyOffAction AS MfgBuyOffAction,
  h.StatusAndActionSchema AS StatusAndActionSchema,
  h.PostingIsRetroactive AS PostingIsRetroactive,
  cast(0 as mpe_status_duration_quan) AS ActualDuration,
  cast('' as durationunit) AS ActualDurationUnit,
  h.MaterialComponentName AS MaterialComponentName,
  h.SubstitutedProduct AS SubstitutedProduct,
  h.SubstitutedProductName AS SubstitutedProductName,
  h.AlternativeItemGroup AS AlternativeItemGroup,
  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.SuccessorManufacturingOrder AS SuccessorManufacturingOrder,
  h.BOMExplosionDate AS BOMExplosionDate,
  cast(' ' as lichn preserving type ) AS AssembledBatchBySupplier,
  h.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  h.StorageLocation AS StorageLocation,
  cast('' as lgort_name) AS StorageLocationName,
  h.InventoryUsabilityCode AS InventoryUsabilityCode,
  cast('' as mpe_insmk_name) AS InventoryUsabilityCodeName,
  h.CompDisassemblyPermanence AS CompDisassemblyPermanence,
  cast('' as mpe_disassembly_permanence_nam) AS CompDisassemblyPermanenceName,
  h.MaterialComponentHasReltdComp AS MaterialComponentHasReltdComp,
  cast('' as qtxt_code) AS MfgActionReasonCodeName,
  cast(h.MfgExecDocReasonCodeIsExisting as boolean preserving type ) AS MfgExecDocReasonCodeIsExisting,
  h.MfgExecutionDocumentNote AS MfgExecutionDocumentNote,
  h._OperationActivitySFIGroup.OpActySFIGroupName AS OpActySFIGroupName,
  cast('' as werks_name) AS ProductionPlantName,
  h.WorkCenterTypeCode AS WorkCenterTypeCode,
  cast('' as werks_name) AS WorkCenterPlantName,
  h.DefectInternalID AS DefectInternalID,
  h.Notification AS Notification,
  h.NotificationItem AS NotificationItem,
  h.ManufacturingOrderType AS ManufacturingOrderType,
  h.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  h.OrderInternalID AS OrderInternalID,
  h.MaterialName AS MaterialName,
  cast('' as mpe_oan_segment_type_name) AS OpActyNtwkSegmentTypeText,
  h.OpActyNtwkInstance AS OpActyNtwkInstance,
  h.OpActyNtwkElement AS OpActyNtwkElement,
  h.OperationActivityNetwork AS OperationActivityNetwork,
  h.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter
FROM P_MfgExecEventHistoryCnsmpn AS h
LEFT OUTER JOIN I_Plant AS _WorkCenterPlant ON WorkCenterPlant = _WorkCenterPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON WorkCenterPlant = _WorkCenterBySemanticKey.Plant AND WorkCenter = _WorkCenterBySemanticKey.WorkCenter  -- association [0..1]
LEFT OUTER JOIN I_MfgProcgExecActionText AS _MfgProcgExecActionText ON MfgProcgExecAction = _MfgProcgExecActionText.MfgProcgExecAction  -- association [0..*]
LEFT OUTER JOIN I_OpActyNtwkInternalID AS _OpActyNtwkInternalId ON OperationActivityNetwork = _OpActyNtwkInternalId.OperationActivityNetwork  -- association [0..1]
LEFT OUTER JOIN I_OperationActivityNetwork AS _OperationActivityNetwork ON OperationActivityNetwork = _OperationActivityNetwork.OperationActivityNetwork AND OpActyNtwkVersionCounter = _OperationActivityNetwork.OpActyNtwkVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkSegmentTypeText AS _OpActyNtwkSegmentTypeText ON OpActyNtwkSegmentType = _OpActyNtwkSegmentTypeText.OpActyNtwkSegmentType AND _OpActyNtwkSegmentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SASSchemaText AS _SASSchemaText ON StatusAndActionSchema = _SASSchemaText.StatusAndActionSchema  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ExecutionUserContactCard ON ShopFloorExecutionUser = _ExecutionUserContactCard.ContactCardID  -- association [0..1]
;