P_MfgExecEventHistOrder

@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
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,
      MfgExecEventHistOrderPrep.OpActyActualDurnInSeconds                             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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER",
"P_MFGEXECEVENTHISTOPERATION",
"P_MFGEXECEVENTHISTORDERPREP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/