I_MfgExecEventHistory

Manufacturing Execution Event History | view: IMPEEXECHIST | Extraction: Not supported | Component: Shop Floor Execution
Tables used: CDHDR, QAMV, QALS, AFVC, QAOP, QAMR, QASE, QAPP, QASV, QASR, AFKO, AFKO, MPE_OBJECT_LOG, MPE_EXEC_NOTE, MPE_ASSY_CRRTN, 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, AFPO, AFVC, MPE_EXEC_HOLD_A, MPE_EXEC_HOLD, MPE_SFI_RWRK_OP, MPE_SFI_CONFIRM, QMSM, DMUTMX_META, EQUI, EQUZ, AUFK, MPE_BUYOFF_CYCLE, MAKT, MPE_BUYOFFSTEPS, MPE_BUYOFF_LOG, MPE_OA_BUYOFF_T, MPE_OAN, MPE_OA_T, MPE_SFI, USR21, CRHD, CDPOS, 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
ManufacturingOrder Order Number
OrderOperationInternalID General counter for order
InspectionCharacteristic Inspection Characteristic Number
InspectionSubsetInternalID Number of Partial Sample
InspResultValueInternalID Number of Individual Result
ChangeDocDatabaseTableField Field Name
ChangeDocument Change Number of Document
Column Name Description
Column Name Description
📏 Log Unit of Measure (ProductionUnit):
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
ManufacturingOrderCategory Order Category Show values
WorkCenterTypeCode Production Resource Type 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
InspectionValuationResult Inspection Result Valuation Show values
InspSpecDecimalPlaces Number of Additional Decimal Places for Statistical Values Show values
PostingIsRetroactive Retroactive Action Show values
Column Name Description Domain name
Equipment Equipment Number EQUNR
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
ManufacturingOrderText Manufacturing Order Text TEXT40
OrderInternalID Routing number of operations in the order AUFPL
MaterialName Material Description TEXT40
ManufacturingOrderSequence Manufacturing Order Sequence PLNFOLGE
ManufacturingOrderOperation Manufacturing Order Operation VORNR
MfgOrderOperationText Manufacturing Order Operation Text TEXT40
WorkCenterPlant Work Center Plant WERKS
SortField Sort Order INT4
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
ReplacedShopFloorItem ID of Assembled Serialized Material
ReplacedSerialNumber Replaced Serial Number GERNR
ReplacedBatch Replaced Batch CHARG
MfgOrderSplitChildOrder Child Order of a Split Hierarchy AUFNR
ReferenceDesignatorValue Reference Designator CHAR128
StorageLocation Storage location LGORT
Defect Defect Number QDEFECTID
DefectText Defect Text TEXT40
QltyTaskFollowUpAction Follow-Up Action for Task QFOLGEAKTI
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
MfgActionReasonCodeGroupCtlg Catalog QKATART
MfgActionReasonCodeGroup Code Group QCODEGRP
ManufacturingActionReasonCode Reason Code for an Action QCODE
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
ChangeDocPreviousFieldValue Old contents of changed field FIELDVAL
ChangeDocNewFieldValue New contents of changed field FIELDVAL
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspectionResultMeasuredValue Measured Value for a Sample Unit QURWERT
CharacteristicAttributeCode Code QCODE
OpActyActualDurnInSeconds Actual Execution Time of an Operation Activity (Seconds)
MfgExecutionDocumentNote Note
SystemMessageNumber Message number MSGNR
SystemMessageIdentification Message identification ARBGB
MfgExecHistMsgVarblField1 null
MfgExecHistMsgVarblField2 null
MfgExecHistMsgVarblField3 null
MfgExecHistMsgVarblField4 null
Master Data Relations Join Conditions
Order Type
  • Client
  • Order Type
  • I_MFGEXECEVENTHISTORY.MANDT == T003O.CLIENT
  • I_MFGEXECEVENTHISTORY.MANUFACTURINGORDERTYPE == T003O.AUART
Material Number for Order
  • Client
  • Material Number for Order
  • I_MFGEXECEVENTHISTORY.MANDT == MARA.MANDT
  • I_MFGEXECEVENTHISTORY.MATERIAL == MARA.MATNR
MRP Controller Group
  • Client
  • MRP controller for the order
  • Production Plant
  • I_MFGEXECEVENTHISTORY.MANDT == T024D.MANDT
  • I_MFGEXECEVENTHISTORY.MRPCONTROLLER == T024D.DISPO
  • I_MFGEXECEVENTHISTORY.PRODUCTIONPLANT == T024D.WERKS
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • I_MFGEXECEVENTHISTORY.MANDT == T001W.MANDT
  • I_MFGEXECEVENTHISTORY.MRPPLANT == T001W.WERKS
Internal Object Identifier
  • Client
  • Object Version Number
  • Internal Object Identifier
  • I_MFGEXECEVENTHISTORY.MANDT == MPE_OAN.MANDT
  • I_MFGEXECEVENTHISTORY.OPACTYNTWKVERSIONCOUNTER == MPE_OAN.VERSION_NO
  • I_MFGEXECEVENTHISTORY.OPERATIONACTIVITYNETWORK == MPE_OAN.ID
Production Plant
  • Client
  • Production Plant
  • I_MFGEXECEVENTHISTORY.MANDT == T001W.MANDT
  • I_MFGEXECEVENTHISTORY.PRODUCTIONPLANT == T001W.WERKS
Production Supervisor
  • Client
  • Production Supervisor
  • Production Plant
  • I_MFGEXECEVENTHISTORY.MANDT == T024F.MANDT
  • I_MFGEXECEVENTHISTORY.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • I_MFGEXECEVENTHISTORY.PRODUCTIONPLANT == T024F.WERKS
Work Center Internal ID
  • Client
  • Work Center Internal ID
  • ?
  • I_MFGEXECEVENTHISTORY.MANDT == CRID.MANDT
  • I_MFGEXECEVENTHISTORY.WORKCENTERINTERNALID == CRID.OBJID
  • I_MFGEXECEVENTHISTORY.[column in domain "CR_OBJTY"] == CRID.OBJTY