P_MFGEXECEVENTHISTORDER
Order Execution Event History
P_MFGEXECEVENTHISTORDER is a CDS View in S/4HANA. Order Execution Event History. It contains 98 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MfgExecEventHistory | view | from | COMPOSITE | Manufacturing Execution Event History |
Fields (98)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ChangeDocDatabaseTableField | ChangeDocDatabaseTableField | 1 |
| KEY | ChangeDocument | ChangeDocument | 1 |
| KEY | InspectionCharacteristic | InspectionCharacteristic | 1 |
| KEY | InspectionSubsetInternalID | InspectionSubsetInternalID | 1 |
| KEY | InspResultValueInternalID | InspResultValueInternalID | 1 |
| KEY | ManufacturingExecutionDocument | ManufacturingExecutionDocument | 1 |
| KEY | ManufacturingOrder | ManufacturingOrder | 1 |
| KEY | MfgExecDocumentCategory | MfgExecDocumentCategory | 1 |
| KEY | MfgExecutionDocumentItem | MfgExecutionDocumentItem | 1 |
| KEY | MfgProcgExecAction | MfgProcgExecAction | 1 |
| KEY | OrderOperationInternalID | OrderOperationInternalID | 1 |
| AssembledBatch | AssembledBatch | 1 | |
| AssembledMfrSerialNumber | AssembledMfrSerialNumber | 1 | |
| AssembledSerialNumber | AssembledSerialNumber | 1 | |
| AssembledShopFloorItem | AssembledShopFloorItem | 1 | |
| BOMExplosionDate | BOMExplosionDate | 1 | |
| BusinessProcessConfirmedQty | BusinessProcessConfirmedQty | 1 | |
| ChangeDocNewFieldValue | ChangeDocNewFieldValue | 1 | |
| ChangeDocPreviousFieldValue | ChangeDocPreviousFieldValue | 1 | |
| CharacteristicAttributeCode | CharacteristicAttributeCode | 1 | |
| CompDisassemblyPermanence | CompDisassemblyPermanence | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDateTime | CreationDateTime | 1 | |
| Defect | Defect | 1 | |
| DefectInternalID | DefectInternalID | 1 | |
| DefectText | DefectText | 1 | |
| Equipment | Equipment | 1 | |
| EventDateTime | EventDateTime | 1 | |
| InspectionResultMeanValue | InspectionResultMeanValue | 1 | |
| InspectionResultMeasuredValue | InspectionResultMeasuredValue | 1 | |
| InspectionSpecificationText | InspectionSpecificationText | 1 | |
| InspectionSpecificationUnit | InspectionSpecificationUnit | 1 | |
| InspectionValuationResult | InspectionValuationResult | 1 | |
| InspSpecDecimalPlaces | InspSpecDecimalPlaces | 1 | |
| InventoryUsabilityCode | InventoryUsabilityCode | 1 | |
| ManufacturingActionReasonCode | ManufacturingActionReasonCode | 1 | |
| ManufacturingObject | ManufacturingObject | 1 | |
| ManufacturingOrderCategory | ManufacturingOrderCategory | 1 | |
| ManufacturingOrderOperation | ManufacturingOrderOperation | 1 | |
| ManufacturingOrderSequence | ManufacturingOrderSequence | 1 | |
| ManufacturingOrderText | ManufacturingOrderText | 1 | |
| ManufacturingOrderType | ManufacturingOrderType | 1 | |
| MaterialComponent | MaterialComponent | 1 | |
| MaterialComponentHasReltdComp | MaterialComponentHasReltdComp | 1 | |
| MaterialComponentName | MaterialComponentName | 1 | |
| MfgActionReasonCodeGroup | MfgActionReasonCodeGroup | 1 | |
| MfgActionReasonCodeGroupCtlg | MfgActionReasonCodeGroupCtlg | 1 | |
| MfgBuyOffAction | MfgBuyOffAction | 1 | |
| MfgBuyOffAdhocStepDescription | MfgBuyOffAdhocStepDescription | 1 | |
| MfgBuyOffCycle | MfgBuyOffCycle | 1 | |
| MfgBuyOffDescription | MfgBuyOffDescription | 1 | |
| MfgBuyOffInternalID | MfgBuyOffInternalID | 1 | |
| MfgBuyOffReferencedStep | MfgBuyOffReferencedStep | 1 | |
| MfgExecHistMsgVarblField1 | MfgExecHistMsgVarblField1 | 1 | |
| MfgExecHistMsgVarblField2 | MfgExecHistMsgVarblField2 | 1 | |
| MfgExecHistMsgVarblField3 | MfgExecHistMsgVarblField3 | 1 | |
| MfgExecHistMsgVarblField4 | MfgExecHistMsgVarblField4 | 1 | |
| MfgExecutionDocumentNote | MfgExecutionDocumentNote | 1 | |
| MfgObjectLogEventType | MfgObjectLogEventType | 1 | |
| MfgOrderOperationText | MfgOrderOperationText | 1 | |
| MfgOrderSplitChildOrder | MfgOrderSplitChildOrder | 1 | |
| MfgProcgExecAttachmentName | MfgProcgExecAttachmentName | 1 | |
| MRPController | MRPController | 1 | |
| Notification | Notification | 1 | |
| NotificationItem | NotificationItem | 1 | |
| OpActyActualDurnInSeconds | OpActyActualDurnInSeconds | 1 | |
| OpActyNtwkElement | OpActyNtwkElement | 1 | |
| OpActyNtwkElementExternalID | OpActyNtwkElementExternalID | 1 | |
| OpActyNtwkInstance | OpActyNtwkInstance | 1 | |
| OpActyNtwkSegmentType | OpActyNtwkSegmentType | 1 | |
| OpActyNtwkVersionCounter | OpActyNtwkVersionCounter | 1 | |
| OperationActivity | OperationActivity | 1 | |
| OperationActivityName | OperationActivityName | 1 | |
| OperationActivityNetwork | OperationActivityNetwork | 1 | |
| OperationActivitySFIGroup | OperationActivitySFIGroup | 1 | |
| OperationActyVersionCounter | OperationActyVersionCounter | 1 | |
| OrderInternalID | OrderInternalID | 1 | |
| PostingIsRetroactive | PostingIsRetroactive | 1 | |
| ProductionPlant | ProductionPlant | 1 | |
| ProductionSupervisor | ProductionSupervisor | 1 | |
| ProductionUnit | ProductionUnit | 1 | |
| QltyTaskFollowUpAction | QltyTaskFollowUpAction | 1 | |
| ReferenceDesignatorValue | ReferenceDesignatorValue | 1 | |
| ReplacedBatch | ReplacedBatch | 1 | |
| ReplacedSerialNumber | ReplacedSerialNumber | 1 | |
| ReplacedShopFloorItem | ReplacedShopFloorItem | 1 | |
| RespyMgmtFunction | RespyMgmtFunction | 1 | |
| RespyMgmtTeamID | RespyMgmtTeamID | 1 | |
| ShopFloorExecutionUser | ShopFloorExecutionUser | 1 | |
| ShopFloorItem | ShopFloorItem | 1 | |
| SortField | SortField | 1 | |
| StatusAndActionSchema | StatusAndActionSchema | 1 | |
| StorageLocation | StorageLocation | 1 | |
| SystemMessageIdentification | SystemMessageIdentification | 1 | |
| SystemMessageNumber | SystemMessageNumber | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 1 | |
| WorkCenterPlant | WorkCenterPlant | 1 | |
| WorkCenterTypeCode | WorkCenterTypeCode | 1 |
@AbapCatalog.sqlViewName: 'PMPEEXECHISTORD'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
define view P_MfgExecEventHistOrder
as
-- Operation History enhanced with order information
select from I_LogisticsOrder as LogisticsOrder
inner join P_MfgExecEventHistOperation as MfgExecEventHistOperation on MfgExecEventHistOperation.OrderInternalID = LogisticsOrder.OrderInternalBillOfOperations
{
key MfgExecEventHistOperation.MfgExecDocumentCategory as MfgExecDocumentCategory,
key MfgExecEventHistOperation.ManufacturingExecutionDocument as ManufacturingExecutionDocument,
key MfgExecEventHistOperation.MfgExecutionDocumentItem as MfgExecutionDocumentItem,
key MfgExecEventHistOperation.MfgProcgExecAction as MfgProcgExecAction,
key LogisticsOrder.OrderID as ManufacturingOrder,
key MfgExecEventHistOperation.OrderOperationInternalID as OrderOperationInternalID,
key cast('0000' as qmerknrp preserving type ) as InspectionCharacteristic,
key cast('000000' as qstipronr preserving type ) as InspectionSubsetInternalID,
key cast('00000000' as qdetailerg preserving type ) as InspResultValueInternalID,
key cast('' as fieldname) as ChangeDocDatabaseTableField,
key 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,
// cast('' as qdefectid) as Defect,
MfgExecEventHistOperation.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,
MfgExecEventHistOperation.MfgProcgExecAttachmentName as MfgProcgExecAttachmentName
}
where
LogisticsOrder.OrderCategory = '10'
union all
-- Oder-based events that already know order id
select from P_MfgExecEventHistOrderPrep as MfgExecEventHistOrderPrep
inner join I_LogisticsOrder as LogisticsOrder on MfgExecEventHistOrderPrep.ManufacturingOrder = LogisticsOrder.OrderID
{
key MfgExecEventHistOrderPrep.MfgExecDocumentCategory as MfgExecDocumentCategory,
key MfgExecEventHistOrderPrep.ManufacturingExecutionDocument as ManufacturingExecutionDocument,
key MfgExecEventHistOrderPrep.MfgExecutionDocumentItem as MfgExecutionDocumentItem,
key MfgExecEventHistOrderPrep.MfgProcgExecAction as MfgProcgExecAction,
key MfgExecEventHistOrderPrep.ManufacturingOrder as ManufacturingOrder,
key MfgExecEventHistOrderPrep.OrderOperationInternalID as OrderOperationInternalID,
key MfgExecEventHistOrderPrep.InspectionCharacteristic as InspectionCharacteristic,
key MfgExecEventHistOrderPrep.InspectionSubsetInternalID as InspectionSubsetInternalID,
key MfgExecEventHistOrderPrep.InspResultValueInternalID as InspResultValueInternalID,
key MfgExecEventHistOrderPrep.ChangeDocDatabaseTableField as ChangeDocDatabaseTableField,
key MfgExecEventHistOrderPrep.ChangeDocument as ChangeDocument,
cast(' ' as mpe_buyoff_action preserving type) as MfgBuyOffAction,
MfgExecEventHistOrderPrep.MfgObjectLogEventType as MfgObjectLogEventType,
@Semantics.businessDate.at: true
MfgExecEventHistOrderPrep.EventDateTime as EventDateTime,
MfgExecEventHistOrderPrep.ShopFloorExecutionUser as ShopFloorExecutionUser,
@Semantics.user.createdBy: true
MfgExecEventHistOrderPrep.CreatedByUser as CreatedByUser,
@Semantics.systemDateTime.createdAt: true
MfgExecEventHistOrderPrep.CreationDateTime as CreationDateTime,
MfgExecEventHistOrderPrep.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,
MfgExecEventHistOrderPrep.ManufacturingOrderSequence as ManufacturingOrderSequence,
MfgExecEventHistOrderPrep.ManufacturingOrderOperation as ManufacturingOrderOperation,
MfgExecEventHistOrderPrep.MfgOrderOperationText as MfgOrderOperationText,
MfgExecEventHistOrderPrep.WorkCenterInternalID as WorkCenterInternalID,
MfgExecEventHistOrderPrep.WorkCenterTypeCode as WorkCenterTypeCode,
MfgExecEventHistOrderPrep.WorkCenterPlant as WorkCenterPlant,
MfgExecEventHistOrderPrep.ShopFloorItem as ShopFloorItem,
MfgExecEventHistOrderPrep.OperationActivitySFIGroup as OperationActivitySFIGroup,
MfgExecEventHistOrderPrep.OpActyNtwkInstance as OpActyNtwkInstance,
MfgExecEventHistOrderPrep.OpActyNtwkElement as OpActyNtwkElement,
MfgExecEventHistOrderPrep.OperationActivityName as OperationActivityName,
MfgExecEventHistOrderPrep.OpActyNtwkSegmentType as OpActyNtwkSegmentType,
MfgExecEventHistOrderPrep.OperationActivityNetwork as OperationActivityNetwork,
MfgExecEventHistOrderPrep.OpActyNtwkVersionCounter as OpActyNtwkVersionCounter,
MfgExecEventHistOrderPrep.OpActyNtwkElementExternalID as OpActyNtwkElementExternalID,
MfgExecEventHistOrderPrep.OperationActivity as OperationActivity,
MfgExecEventHistOrderPrep.OperationActyVersionCounter as OperationActyVersionCounter,
MfgExecEventHistOrderPrep.StatusAndActionSchema as StatusAndActionSchema,
MfgExecEventHistOrderPrep.DefectInternalID as DefectInternalID,
MfgExecEventHistOrderPrep.Notification as Notification,
MfgExecEventHistOrderPrep.NotificationItem as NotificationItem,
MfgExecEventHistOrderPrep.MaterialComponent as MaterialComponent,
MfgExecEventHistOrderPrep.MaterialComponentName as MaterialComponentName,
MfgExecEventHistOrderPrep.AssembledShopFloorItem as AssembledShopFloorItem,
MfgExecEventHistOrderPrep.AssembledSerialNumber as AssembledSerialNumber,
MfgExecEventHistOrderPrep.AssembledMfrSerialNumber as AssembledMfrSerialNumber,
MfgExecEventHistOrderPrep.AssembledBatch as AssembledBatch,
MfgExecEventHistOrderPrep.ReplacedShopFloorItem as ReplacedShopFloorItem,
MfgExecEventHistOrderPrep.ReplacedSerialNumber as ReplacedSerialNumber,
MfgExecEventHistOrderPrep.ReplacedBatch as ReplacedBatch,
MfgExecEventHistOrderPrep.MfgOrderSplitChildOrder as MfgOrderSplitChildOrder,
MfgExecEventHistOrderPrep.BOMExplosionDate as BOMExplosionDate,
MfgExecEventHistOrderPrep.ReferenceDesignatorValue as ReferenceDesignatorValue,
cast(' ' as lgort_d preserving type) as StorageLocation,
cast('' as inventoryusabilitycode preserving type) as InventoryUsabilityCode,
cast('' as mpe_disassembly_permanence preserving type ) as CompDisassemblyPermanence,
cast('' as mpe_is_reassembly preserving type ) as MaterialComponentHasReltdComp,
MfgExecEventHistOrderPrep.Defect as Defect,
MfgExecEventHistOrderPrep.DefectText as DefectText,
MfgExecEventHistOrderPrep.QltyTaskFollowUpAction as QltyTaskFollowUpAction,
cast(0 as mpe_buyoff_step) as MfgBuyOffInternalID,
cast('' as mpe_buyoffsqnc_desc) as MfgBuyOffDescription,
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,
MfgExecEventHistOrderPrep.InspectionSpecificationText as InspectionSpecificationText,
MfgExecEventHistOrderPrep.ChangeDocPreviousFieldValue as ChangeDocPreviousFieldValue,
MfgExecEventHistOrderPrep.ChangeDocNewFieldValue as ChangeDocNewFieldValue,
MfgExecEventHistOrderPrep.InspectionResultMeanValue as InspectionResultMeanValue,
MfgExecEventHistOrderPrep.InspectionResultMeasuredValue as InspectionResultMeasuredValue,
MfgExecEventHistOrderPrep.CharacteristicAttributeCode as CharacteristicAttributeCode,
MfgExecEventHistOrderPrep.InspectionValuationResult as InspectionValuationResult,
MfgExecEventHistOrderPrep.InspectionSpecificationUnit as InspectionSpecificationUnit,
MfgExecEventHistOrderPrep.InspSpecDecimalPlaces as InspSpecDecimalPlaces,
MfgExecEventHistOrderPrep.BusinessProcessConfirmedQty as BusinessProcessConfirmedQty,
MfgExecEventHistOrderPrep.ProductionUnit as ProductionUnit,
cast(0 as mpe_actl_exec_duration) as OpActyActualDurnInSeconds,
cast('' as mpe_is_posted_retroactively preserving type) as PostingIsRetroactive,
MfgExecEventHistOrderPrep.MfgActionReasonCodeGroupCtlg as MfgActionReasonCodeGroupCtlg,
MfgExecEventHistOrderPrep.MfgActionReasonCodeGroup as MfgActionReasonCodeGroup,
MfgExecEventHistOrderPrep.ManufacturingActionReasonCode as ManufacturingActionReasonCode,
MfgExecEventHistOrderPrep.MfgExecutionDocumentNote as MfgExecutionDocumentNote,
cast('' as equnr) as Equipment,
MfgExecEventHistOrderPrep.SystemMessageNumber as SystemMessageNumber,
MfgExecEventHistOrderPrep.SystemMessageIdentification as SystemMessageIdentification,
MfgExecEventHistOrderPrep.MfgExecHistMsgVarblField1 as MfgExecHistMsgVarblField1,
MfgExecEventHistOrderPrep.MfgExecHistMsgVarblField2 as MfgExecHistMsgVarblField2,
MfgExecEventHistOrderPrep.MfgExecHistMsgVarblField3 as MfgExecHistMsgVarblField3,
MfgExecEventHistOrderPrep.MfgExecHistMsgVarblField4 as MfgExecHistMsgVarblField4,
cast('' as mpe_file_name) as MfgProcgExecAttachmentName
}
where
LogisticsOrder.OrderCategory = '10'