P_MfgExecEventHistOperation

Operation Execution Event History | view: PMPEEXECHISTOP | TRAN | Extraction: Not supported | Component: Shop Floor Execution
Tables used: QAPP, AFKO, MPE_EXEC_NOTE, MPE_COMP_ASSY_IN, MPE_COMP_ASSEMBL, QMEL, QMFE, MPE_CMP_OAI_INST, MPE_COMP_OAI, MPE_OAC, MPE_OAC_ACTION, MPE_OAI_EQUI_REG, MPE_OAI_LBR_ACTN, MPE_OAN_INSTANCE, MPE_OA_INSTANCE, AFVC, MPE_EXEC_HOLD_A, MPE_EXEC_HOLD, MPE_SFI_RWRK_OP, MPE_SFI_CONFIRM, DMUTMX_META, EQUI, EQUZ, MPE_BUYOFF_CYCLE, MAKT, MPE_BUYOFFSTEPS, MPE_BUYOFF_LOG, MPE_OA_BUYOFF_T, MPE_OAN, MPE_OA_T, MPE_SFI, USR21, CRHD, MPE_OAN_ELEMENT
Column Name Description
MfgExecDocumentCategory Execution Document Category Show values
ManufacturingExecutionDocument SFI Confirmation - Document Number
MfgExecutionDocumentItem Document Item Number
MfgProcgExecAction Action of a Status and Action Schema
Column Name Description
Column Name Description
BusinessProcessConfirmedQty Confirmed Quantity/Activity for Business Process
Column Name Description
Column Name Description
MfgExecDocumentCategory Execution Document Category Show values
MfgBuyOffAction Buy Off Action Show values
MfgObjectLogEventType Log Event Show values
OpActyNtwkSegmentType OA Segment Type (Setup, Produce, or Teardown) Show values
InventoryUsabilityCode Inventory Usability Code Show values
CompDisassemblyPermanence Permanence of Disassembly Show values
MaterialComponentHasReltdComp Is Reassembly Show values
PostingIsRetroactive Retroactive Action Show values
Column Name Description Domain name
ManufacturingOrder Order number AUFNR
EventDateTime Date and Time at which the action was performed TZNTSTMPS
ShopFloorExecutionUser The user that performed the action USNAM
CreatedByUser Created By USNAM
CreationDateTime Date and Time of Creation TZNTSTMPL
SortField Sort Order INT4
OrderInternalID Routing number of operations in the order AUFPL
OrderOperationInternalID General counter for order CO_APLZL
ManufacturingOrderSequence Manufacturing Order Sequence PLNFOLGE
ManufacturingOrderOperation Manufacturing Order Operation VORNR
MfgOrderOperationText Manufacturing Order Operation Text TEXT40
WorkCenterTypeCode null
WorkCenterPlant Work Center Plant WERKS
ShopFloorItem ID of Serialized Material
OpActyNtwkInstance Operation Activity Network: Instance ID
OpActyNtwkElement Internal OAN Element Number
OperationActivityName Operation Activity Description MPE_OAN_OBJECT_DESCRIPTION
OpActyNtwkVersionCounter Object Version Number
OpActyNtwkElementExternalID Element Number MPE_OAN_ELEMENT_NUMBER_EXT
OperationActivity Identifies an Operation Activity MPE_OAN_ELEMENT_ID
OperationActyVersionCounter Number of an Operation Actiivity Version
StatusAndActionSchema Status and Action Schema MPE_OBJECT_NAME_TYPE
DefectInternalID Internal Defect ID QDEFECTINTERNALID
Notification Notification Number QMNUM
NotificationItem Item Number in Item Record FELFD
MaterialComponent Material Number of Component MATNR
MaterialComponentName Material Description TEXT40
AssembledShopFloorItem ID of Assembled Serialized Material
AssembledSerialNumber Serial Number of Assembled Component GERNR
AssembledMfrSerialNumber Manufacturer's Serial Number of Assembled Component CHAR30
AssembledBatch Batch Number of Assembled Component CHARG
ReferenceDesignatorValue Reference Designator CHAR128
StorageLocation Storage location LGORT
MfgBuyOffInternalID Buyoff Step MPE_BUYOFF_STEP
MfgBuyOffDescription Buyoff Sequence Description MPE_BUYOFFSQNC_DESC
MfgBuyOffReferencedStep Buyoff Step MPE_BUYOFF_STEP
MfgBuyOffAdhocStepDescription Buyoff Sequence Description MPE_BUYOFFSQNC_DESC
MfgBuyOffCycle Buyoff Cycle
RespyMgmtTeamID Object ID HROBJID
RespyMgmtFunction Function RSM_DO_FUNCTION
OpActyActualDurnInSeconds Actual Execution Time of an Operation Activity (Seconds)
MfgActionReasonCodeGroupCtlg Catalog QKATART
MfgActionReasonCodeGroup Code Group QCODEGRP
ManufacturingActionReasonCode Reason Code for an Action QCODE
MfgExecutionDocumentNote Note
Equipment Equipment Number EQUNR
SystemMessageNumber Message number MSGNR
SystemMessageIdentification Message identification ARBGB
MfgExecHistMsgVarblField1 null
MfgExecHistMsgVarblField2 null
MfgExecHistMsgVarblField3 null
MfgExecHistMsgVarblField4 null
Defect Defect Number QDEFECTID
Master Data Relations Join Conditions
Internal Object Identifier
  • Internal Object Identifier
  • Client
  • Object Version Number
  • P_MFGEXECEVENTHISTOPERATION.OPERATIONACTIVITYNETWORK == MPE_OAN.ID
  • P_MFGEXECEVENTHISTOPERATION.MANDT == MPE_OAN.MANDT
  • P_MFGEXECEVENTHISTOPERATION.OPACTYNTWKVERSIONCOUNTER == MPE_OAN.VERSION_NO
Work Center Internal ID
  • Client
  • ?
  • Work Center Internal ID
  • P_MFGEXECEVENTHISTOPERATION.MANDT == CRID.MANDT
  • P_MFGEXECEVENTHISTOPERATION.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_MFGEXECEVENTHISTOPERATION.WORKCENTERINTERNALID == CRID.OBJID