@AbapCatalog.sqlViewName: 'PMPEEXECHISTC'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
define view P_MfgExecEventHistoryCnsmpn
as select from I_MfgExecEventHistory as h
association [1..1] to I_MfgOrderSequence as _MfgOrderSequence on $projection.ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder
and $projection.ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence
association [0..1] to I_OpActyNtwkElement as _OpActyNtwkElement on $projection.OperationActivityNetwork = _OpActyNtwkElement.OperationActivityNetwork
and $projection.OpActyNtwkVersionCounter = _OpActyNtwkElement.OpActyNtwkVersionCounter
and $projection.OpActyNtwkElement = _OpActyNtwkElement.OpActyNtwkElement
association [1..1] to I_User as _CreatedByUser on $projection.CreatedByUser = _CreatedByUser.UserID
association [1..1] to I_User as _ExecutionUser on $projection.ShopFloorExecutionUser = _ExecutionUser.UserID
association [0..1] to I_WorkCenterType as _WorkCenterType on $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode
association [0..1] to I_WorkCenter as _WorkCenter on $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode
and $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
{
key h.MfgExecDocumentCategory as MfgExecDocumentCategory,
key h.ManufacturingExecutionDocument as ManufacturingExecutionDocument,
key h.MfgExecutionDocumentItem as MfgExecutionDocumentItem,
key h.MfgProcgExecAction as MfgProcgExecAction,
key cast(h.ManufacturingOrder as mpe_production_order preserving type ) as ManufacturingOrder,
key h.OrderOperationInternalID as OrderOperationInternalID,
key h.InspectionCharacteristic as InspectionCharacteristic,
key h.InspectionSubsetInternalID as InspectionSubsetInternalID,
key h.InspResultValueInternalID as InspResultValueInternalID,
key h.ChangeDocDatabaseTableField as ChangeDocDatabaseTableField,
key h.ChangeDocument as ChangeDocument,
h.MfgBuyOffAction as MfgBuyOffAction,
cast(case MfgExecDocumentCategory
when 252 then 5 --Workaround: Use text for Order Create as text for SFI Create, too
else h.MfgObjectLogEventType
end as mpe_log_event preserving type ) as MfgObjectLogEventType,
h.EventDateTime as EventDateTime,
h.ShopFloorExecutionUser as ShopFloorExecutionUser,
_ExecutionUser.UserDescription as ShopFloorExecutionUserName,
h.CreatedByUser as CreatedByUser,
h.Equipment as Equipment,
-- _CreatedByUser.UserDescription as CreatedByUserDescription,
h.CreationDateTime as CreationDateTime,
h.SortField as SortField,
-- Order data ------------------------------------------------------------
h.ManufacturingOrderText as ManufacturingOrderText,
h.OrderInternalID as OrderInternalID,
h.Material as Material,
h.MaterialName as MaterialName,
h.ProductionSupervisor as ProductionSupervisor,
h.MRPController as MRPController,
h.ManufacturingObject as MfgOrderObjectInternalID,
-- Operation Data --------------------------------------------------------
h.ManufacturingOrderSequence as ManufacturingOrderSequence,
h.ManufacturingOrderOperation as ManufacturingOrderOperation,
h.MfgOrderOperationText as MfgOrderOperationText,
h.ManufacturingOrderType as ManufacturingOrderType,
h.ManufacturingOrderCategory as ManufacturingOrderCategory,
h.ProductionPlant as ProductionPlant,
h.MRPPlant as MRPPlant,
h.WorkCenterInternalID as WorkCenterInternalID,
h.WorkCenterTypeCode as WorkCenterTypeCode,
h.WorkCenterPlant as WorkCenterPlant,
-- _OrderOperationBasic.ManufacturingObject as MfgOrderOperObjectInternalID,
-- SFI Data --------------------------------------------------------------
h.ShopFloorItem as ShopFloorItem,
h.OperationActivitySFIGroup as OperationActivitySFIGroup,
-- OA(N) Data ------------------------------------------------------------
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,
-- Document Data ---------------------------------------------------------
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.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.MfgActionReasonCodeGroupCtlg as MfgActionReasonCodeGroupCtlg,
h.MfgActionReasonCodeGroup as MfgActionReasonCodeGroup,
h.ManufacturingActionReasonCode as ManufacturingActionReasonCode,
case when h.ManufacturingActionReasonCode = '' then '' else 'X' end as MfgExecDocReasonCodeIsExisting,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
h.BusinessProcessConfirmedQty as BusinessProcessConfirmedQty,
@Semantics.unitOfMeasure: true
h.ProductionUnit as ProductionUnit,
h.OpActyActualDurnInSeconds as OpActyActualDurnInSeconds,
h.PostingIsRetroactive as PostingIsRetroactive,
h.MfgExecutionDocumentNote as MfgExecutionDocumentNote,
-- Message Data ----------------------------------------------------------
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,
_CreatedByUser,
_ExecutionUser,
_MfgOrder,
_MfgOrderType,
_MfgOrderCategory,
_MfgOrderOperation,
_MfgOrderOperationBasic,
_OrderOperationBasic,
_OpActyNtwkInstance,
_OperationActivityInstance,
_ShopFloorItem,
_OperationActivitySFIGroup,
_AssembledShopFloorItem,
_MfgProcgExecAction,
_ProductionUnit,
_MfgActionReasonCodeGroupCtlg,
_MfgActionReasonCodeGroup,
_MfgActionReasonCode,
_ManufacturingObjectLog,
_OpActyConfirmationAction,
_OpActyNtwkSegmentType,
_SASSchema,
_ShopFloorItemConfirmation,
_MfgOrderComponentAssembly,
_OpActyNtwkElement,
_MfgOrderSequence,
_ProductionPlant,
_MRPPlant,
_StorageLocation,
_MRPController,
_ProductionSupervisor,
_Material,
_MaterialText,
_Defect,
_Notification,
_NotificationItem,
_MaterialComponent,
_WorkCenter,
_WorkCenterType,
_PlannedInvtryUsblyCodeText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGEXECEVENTHISTORY",
"I_USER"
],
"ASSOCIATED":
[
"I_DEFECT",
"I_INSPECTIONCATALOG",
"I_MANUFACTURINGOBJECTLOG",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_MFGACTIONREASONCODE",
"I_MFGACTIONREASONCODEGROUP",
"I_MFGORDER",
"I_MFGORDERCATEGORY",
"I_MFGORDERCOMPONENTASSEMBLY",
"I_MFGORDEROPERATION",
"I_MFGORDEROPERATIONBASIC",
"I_MFGORDERSEQUENCE",
"I_MFGORDERTYPE",
"I_MFGPROCGEXECACTION",
"I_MRPCONTROLLER",
"I_NOTIFICATION",
"I_NOTIFICATIONITEM",
"I_OPACTYCONFIRMATIONACTION",
"I_OPACTYNTWKELEMENT",
"I_OPACTYNTWKINSTANCE",
"I_OPACTYNTWKSEGMENTTYPE",
"I_OPERATIONACTIVITYINSTANCE",
"I_OPERATIONACTIVITYSFIGROUP",
"I_ORDEROPERATIONBASIC",
"I_PLANNEDINVTRYUSBLYCODETEXT",
"I_PLANT",
"I_PRODUCTIONSUPERVISOR",
"I_SASSCHEMA",
"I_SHOPFLOORITEM",
"I_SHOPFLOORITEMCONFIRMATION",
"I_STORAGELOCATION",
"I_UNITOFMEASURE",
"I_USER",
"I_WORKCENTER",
"I_WORKCENTERTYPE"
],
"BASE":
[
"I_MFGEXECEVENTHISTORY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/