P_MfgExecEventHistOrder

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_MfgExecEventHistOrder.
-- 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: PMPEEXECHISTORD

CREATE VIEW P_MfgExecEventHistOrder AS
SELECT
  MfgExecEventHistOperation.MfgExecDocumentCategory AS MfgExecDocumentCategory,
  MfgExecEventHistOperation.ManufacturingExecutionDocument AS ManufacturingExecutionDocument,
  MfgExecEventHistOperation.MfgExecutionDocumentItem AS MfgExecutionDocumentItem,
  MfgExecEventHistOperation.MfgProcgExecAction AS MfgProcgExecAction,
  LogisticsOrder.OrderID AS ManufacturingOrder,
  MfgExecEventHistOperation.OrderOperationInternalID AS OrderOperationInternalID,
  cast('0000' as qmerknrp preserving type ) AS InspectionCharacteristic,
  cast('000000' as qstipronr preserving type ) AS InspectionSubsetInternalID,
  cast('00000000' as qdetailerg preserving type ) AS InspResultValueInternalID,
  cast('' as fieldname) AS ChangeDocDatabaseTableField,
  cast('' as cdchangenr) AS ChangeDocument,
  MfgExecEventHistOperation.MfgBuyOffAction AS MfgBuyOffAction,
  MfgExecEventHistOperation.MfgObjectLogEventType AS MfgObjectLogEventType,
  MfgExecEventHistOperation.EventDateTime AS EventDateTime,
  MfgExecEventHistOperation.ShopFloorExecutionUser AS ShopFloorExecutionUser,
  MfgExecEventHistOperation.CreatedByUser AS CreatedByUser,
  MfgExecEventHistOperation.CreationDateTime AS CreationDateTime,
  MfgExecEventHistOperation.SortField AS SortField,
  cast(LogisticsOrder.OrderDescription as manufacturingordertext preserving type) AS ManufacturingOrderText,
  LogisticsOrder.OrderType AS ManufacturingOrderType,
  LogisticsOrder.OrderCategory AS ManufacturingOrderCategory,
  cast(LogisticsOrder.Plant as pwwrk preserving type) AS ProductionPlant,
  LogisticsOrder.ProductionSupervisor AS ProductionSupervisor,
  LogisticsOrder.MRPController AS MRPController,
  cast(LogisticsOrder.ObjectInternalID as pph_objnr preserving type) AS ManufacturingObject,
  LogisticsOrder.OrderInternalBillOfOperations AS OrderInternalID,
  MfgExecEventHistOperation.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  MfgExecEventHistOperation.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  MfgExecEventHistOperation.MfgOrderOperationText AS MfgOrderOperationText,
  MfgExecEventHistOperation.WorkCenterInternalID AS WorkCenterInternalID,
  cast(MfgExecEventHistOperation.WorkCenterTypeCode as productionresourcetype) AS WorkCenterTypeCode,
  MfgExecEventHistOperation.WorkCenterPlant AS WorkCenterPlant,
  MfgExecEventHistOperation.ShopFloorItem AS ShopFloorItem,
  MfgExecEventHistOperation.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  MfgExecEventHistOperation.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgExecEventHistOperation.OpActyNtwkElement AS OpActyNtwkElement,
  MfgExecEventHistOperation.OperationActivityName AS OperationActivityName,
  MfgExecEventHistOperation.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  MfgExecEventHistOperation.OperationActivityNetwork AS OperationActivityNetwork,
  MfgExecEventHistOperation.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  MfgExecEventHistOperation.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  MfgExecEventHistOperation.OperationActivity AS OperationActivity,
  MfgExecEventHistOperation.OperationActyVersionCounter AS OperationActyVersionCounter,
  MfgExecEventHistOperation.StatusAndActionSchema AS StatusAndActionSchema,
  MfgExecEventHistOperation.DefectInternalID AS DefectInternalID,
  MfgExecEventHistOperation.Notification AS Notification,
  MfgExecEventHistOperation.NotificationItem AS NotificationItem,
  MfgExecEventHistOperation.MaterialComponent AS MaterialComponent,
  MfgExecEventHistOperation.MaterialComponentName AS MaterialComponentName,
  MfgExecEventHistOperation.AssembledShopFloorItem AS AssembledShopFloorItem,
  MfgExecEventHistOperation.AssembledSerialNumber AS AssembledSerialNumber,
  MfgExecEventHistOperation.AssembledMfrSerialNumber AS AssembledMfrSerialNumber,
  MfgExecEventHistOperation.AssembledBatch AS AssembledBatch,
  cast(0 as mpe_assembled_sfi_id) AS ReplacedShopFloorItem,
  cast('' as mpe_replaced_sernr) AS ReplacedSerialNumber,
  cast('' as mpe_replaced_batch) AS ReplacedBatch,
  cast('' as split_caufnr) AS MfgOrderSplitChildOrder,
  cast('00000000' as co_aufld) AS BOMExplosionDate,
  MfgExecEventHistOperation.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  MfgExecEventHistOperation.StorageLocation AS StorageLocation,
  MfgExecEventHistOperation.InventoryUsabilityCode AS InventoryUsabilityCode,
  MfgExecEventHistOperation.CompDisassemblyPermanence AS CompDisassemblyPermanence,
  MfgExecEventHistOperation.MaterialComponentHasReltdComp AS MaterialComponentHasReltdComp,
  MfgExecEventHistOperation.Defect AS Defect,
  cast('' as vdm_qfetxt) AS DefectText,
  cast('' as qmfolact) AS QltyTaskFollowUpAction,
  MfgExecEventHistOperation.MfgBuyOffInternalID AS MfgBuyOffInternalID,
  MfgExecEventHistOperation.MfgBuyOffDescription AS MfgBuyOffDescription,
  MfgExecEventHistOperation.MfgBuyOffReferencedStep AS MfgBuyOffReferencedStep,
  MfgExecEventHistOperation.MfgBuyOffAdhocStepDescription AS MfgBuyOffAdhocStepDescription,
  MfgExecEventHistOperation.MfgBuyOffCycle AS MfgBuyOffCycle,
  MfgExecEventHistOperation.RespyMgmtTeamID AS RespyMgmtTeamID,
  MfgExecEventHistOperation.RespyMgmtFunction AS RespyMgmtFunction,
  cast('' as vdm_qmkkurztxt) AS InspectionSpecificationText,
  cast('' as cdfldvalo) AS ChangeDocPreviousFieldValue,
  cast('' as cdfldvaln ) AS ChangeDocNewFieldValue,
  cast(0 as qmittelwrt) AS InspectionResultMeanValue,
  cast(0 as qmesswert) AS InspectionResultMeasuredValue,
  cast(' ' as qcode preserving type ) AS CharacteristicAttributeCode,
  cast('' as qmbewertg preserving type ) AS InspectionValuationResult,
  cast('' as qmasseh ) AS InspectionSpecificationUnit,
  cast(0 as qnkstellof preserving type ) AS InspSpecDecimalPlaces,
  MfgExecEventHistOperation.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  MfgExecEventHistOperation.ProductionUnit AS ProductionUnit,
  MfgExecEventHistOperation.OpActyActualDurnInSeconds AS OpActyActualDurnInSeconds,
  MfgExecEventHistOperation.PostingIsRetroactive AS PostingIsRetroactive,
  MfgExecEventHistOperation.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  MfgExecEventHistOperation.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  MfgExecEventHistOperation.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  MfgExecEventHistOperation.MfgExecutionDocumentNote AS MfgExecutionDocumentNote,
  MfgExecEventHistOperation.Equipment AS Equipment,
  MfgExecEventHistOperation.SystemMessageNumber AS SystemMessageNumber,
  MfgExecEventHistOperation.SystemMessageIdentification AS SystemMessageIdentification,
  MfgExecEventHistOperation.MfgExecHistMsgVarblField1 AS MfgExecHistMsgVarblField1,
  MfgExecEventHistOperation.MfgExecHistMsgVarblField2 AS MfgExecHistMsgVarblField2,
  MfgExecEventHistOperation.MfgExecHistMsgVarblField3 AS MfgExecHistMsgVarblField3,
  MfgExecEventHistOperation.MfgExecHistMsgVarblField4 AS MfgExecHistMsgVarblField4,
  cast('' as mpe_file_name) AS MfgProcgExecAttachmentName
FROM I_LogisticsOrder AS LogisticsOrder
INNER JOIN P_MfgExecEventHistOperation AS MfgExecEventHistOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrder AS LogisticsOrder ON /* join condition not captured in parsed metadata */
;