C_MfgExecEventHistory

Manufacturing Execution Event History | view: CMPEEXECHIST | 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_ACTION_T, MPE_BUYOFF_CYCLE, MAKT, MPE_BUYOFFSTEPS, MPE_BUYOFF_LOG, MPE_OA_BUYOFF_T, MPE_OAN, MPE_OA_T, MPE_SAS_ACTION_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 Production 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
📏 Duration Unit of Measure (ActualDurationUnit):
ActualDuration Status Duration
Column Name Description
Column Name Description
MfgExecDocumentCategory Execution Document Category Show values
MfgObjectLogEventType Log Event Show values
MfgExecHistMsgVarblField1 Log Message Variable Show values
MfgExecHistMsgVarblField2 Log Message Variable Show values
MfgExecHistMsgVarblField3 Log Message Variable Show values
MfgExecHistMsgVarblField4 Log Message Variable Show values
MfgBuyOffAction Buy Off Action Show values
PostingIsRetroactive Retroactive Action Show values
InventoryUsabilityCode Inventory Usability Code Show values
CompDisassemblyPermanence Permanence of Disassembly Show values
MaterialComponentHasReltdComp Is Reassembly Show values
MfgExecDocReasonCodeIsExisting Boolean Variable (X = True, - = False, Space = Unknown) Show values
MfgExecDocNoteIsExisting Note exists Show values
WorkCenterTypeCode Production Resource Type Show values
ManufacturingOrderCategory Order Category Show values
OpActyNtwkSegmentType OA Segment Type (Setup, Produce, or Teardown) Show values
InspectionValuationResult Inspection Result Valuation Show values
InspSpecDecimalPlaces Number of Additional Decimal Places for Statistical Values Show values
Column Name Description Domain name
SortField Sort Order INT4
EventDateTime Date and Time at which the action was performed TZNTSTMPS
ShopFloorExecutionUser The user that performed the action USNAM
ShopFloorExecutionUserName User Description SUIDTECHDESC
CreationDateTime Date and Time of Creation TZNTSTMPL
CreatedByUser Created By USNAM
RespyMgmtTeamID Object ID HROBJID
RespyMgmtTeamName Team Name RSM_DO_TEAM_NAME
RespyMgmtTeamDescription Team Description RSM_DO_TEAM_DESCR
RespyMgmtFunction Function RSM_DO_FUNCTION
RespyMgmtFunctionDescription Function Description RSM_DO_FUNCTION_DESCR
SystemMessageNumber Message number MSGNR
SystemMessageIdentification Message identification ARBGB
SystemMessageDescription Action Message TEXT255
MfgProcgExecActionName Action Description MPE_OBJECT_DESCRIPTION_TYPE
StatusAndActionSchema Status and Action Schema MPE_OBJECT_NAME_TYPE
OpActyActualDurnInSeconds Actual Execution Time of an Operation Activity (Seconds)
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
AssembledBatchBySupplier Supplier Batch Number LICHN
ReferenceDesignatorValue Reference Designator CHAR128
StorageLocation Storage location LGORT
StorageLocationName Storage Location Name TEXT16
InventoryUsabilityCodeName Stock Type TEXT60
CompDisassemblyPermanenceName Permanence of Disassembly TEXT60
Equipment Equipment Number EQUNR
MfgActionReasonCodeGroupCtlg Catalog QKATART
MfgActionReasonCodeGroup Code Group QCODEGRP
ManufacturingActionReasonCode Reason Code for an Action QCODE
MfgActionReasonCodeName Short Text for Code QKURZTEXT
MfgExecutionDocumentNote Note
ProductionPlantName Plant Name TEXT30
WorkCenter Work Center ARBPL
WorkCenterPlant Work Center Plant WERKS
WorkCenterPlantName Plant Name TEXT30
DefectInternalID Internal Defect ID QDEFECTINTERNALID
Notification Notification Number QMNUM
NotificationItem Item Number in Item Record FELFD
ManufacturingOrderText Manufacturing Order Text TEXT40
OrderInternalID Routing number of operations in the order AUFPL
OrderMainStatusName Main Status of Order TEXT30
MaterialName Material Description TEXT40
ManufacturingOrderOperation Manufacturing Order Operation VORNR
MfgOrderOperationText Manufacturing Order Operation Text TEXT40
OrderOperationMainStatusName Main Status of Operation TEXT30
OpActyNtwkSegmentTypeText OA Segment Type Name (Setup, Produce, or Teardown) TEXT60
OpActyNtwkInstance Operation Activity Network: Instance ID
OpActyNtwkElement Internal OAN Element Number
OperationActivityNetwork Internal Object Identifier MPE_OAN_ELEMENT_ID
OpActyNtwkVersionCounter Object Version Number
OperationActivityName Operation Activity Description MPE_OAN_OBJECT_DESCRIPTION
OpActyNtwkElementExternalID Operation Activity Number MPE_OAN_ELEMENT_NUMBER_EXT
ShopFloorItem ID of Serialized Material
SerialNumber Serial Number GERNR
Defect Defect Number QDEFECTID
DefectText Defect Text TEXT40
QltyTaskFollowUpAction Follow-Up Action for Task QFOLGEAKTI
MfgBuyOffDescription Buyoff Sequence Description MPE_BUYOFFSQNC_DESC
MfgBuyOffCycle Buyoff Cycle
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
Master Data Relations Join Conditions
Order Type
  • Order Type
  • Client
  • C_MFGEXECEVENTHISTORY.MANUFACTURINGORDERTYPE == T003O.AUART
  • C_MFGEXECEVENTHISTORY.MANDT == T003O.CLIENT
Material Number for Order
  • Material Number for Order
  • Client
  • C_MFGEXECEVENTHISTORY.MATERIAL == MARA.MATNR
  • C_MFGEXECEVENTHISTORY.MANDT == MARA.MANDT
MRP Controller Group
  • MRP controller for the order
  • Production Plant
  • Client
  • C_MFGEXECEVENTHISTORY.MRPCONTROLLER == T024D.DISPO
  • C_MFGEXECEVENTHISTORY.PRODUCTIONPLANT == T024D.WERKS
  • C_MFGEXECEVENTHISTORY.MANDT == T024D.MANDT
Planning Plant for an Order
  • Planning Plant for an Order
  • Client
  • C_MFGEXECEVENTHISTORY.MRPPLANT == T001W.WERKS
  • C_MFGEXECEVENTHISTORY.MANDT == T001W.MANDT
Production Plant
  • Production Plant
  • Client
  • C_MFGEXECEVENTHISTORY.PRODUCTIONPLANT == T001W.WERKS
  • C_MFGEXECEVENTHISTORY.MANDT == T001W.MANDT
Production Supervisor
  • Production Supervisor
  • Production Plant
  • Client
  • C_MFGEXECEVENTHISTORY.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • C_MFGEXECEVENTHISTORY.PRODUCTIONPLANT == T024F.WERKS
  • C_MFGEXECEVENTHISTORY.MANDT == T024F.MANDT
Work Center Internal ID
  • ?
  • Work Center Internal ID
  • Client
  • C_MFGEXECEVENTHISTORY.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_MFGEXECEVENTHISTORY.WORKCENTERINTERNALID == CRID.OBJID
  • C_MFGEXECEVENTHISTORY.MANDT == CRID.MANDT