SAP Shop Floor Execution Tables
Are you looking for the right table related to SAP Shop Floor Execution Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Shop Floor Execution (PP-PEO-SFE) module.
Top 10 tables in Shop Floor Execution
| Table | Description |
|---|---|
| MPE_NC_DCSN | Table for defect decision |
| MPE_SAS_S_H_GPM | Status and Action Schema Hierarchy Consistency Group Members |
| MPE_EVENT_T | Text table for OAN Event |
| MPE_SAS_SCHEMA | Status and Action Schema (SAS) |
| MPE_OAN | Operation Activity Network |
| MPE_OA_COMP_INST | Component Instance assignment to operation activity |
| MPE_S_OBJECT_TYT | Object Type Text |
| MPE_OAI_EQUI_REG | Equipment Registration during OA Execution |
| MPE_SAS_S_H_GP | Status and Action Schema Hierarchy Consistency Group |
| MPE_OAI_LBR_ACTN | Labor action of users during OA execution |
List of tables in Shop Floor Execution
| Table | Description |
|---|---|
| MPE_NC_DCSN | Table for defect decision |
| MPE_SAS_S_H_GPM | Status and Action Schema Hierarchy Consistency Group Members |
| MPE_EVENT_T | Text table for OAN Event |
| MPE_SAS_SCHEMA | Status and Action Schema (SAS) |
| MPE_OAN | Operation Activity Network |
| MPE_OA_COMP_INST | Component Instance assignment to operation activity |
| MPE_S_OBJECT_TYT | Object Type Text |
| MPE_OAI_EQUI_REG | Equipment Registration during OA Execution |
| MPE_SAS_S_H_GP | Status and Action Schema Hierarchy Consistency Group |
| MPE_OAI_LBR_ACTN | Labor action of users during OA execution |
| MPE_SAS_S_AS_STA | SAS Status Assignment |
| MPE_NF_PROFILE_T | Number Format Profile - Description |
| MPE_SAS_AS_ACT | SAS Action Assignment (Status Transition Assignment) |
| MPE_REASON_CAT_T | MPE Reason Code Categories - Text Table |
| MPE_EVENT | OAN Event |
| MPE_AHF_C_THPA_T | SAP Type Handler Parameter Text Table |
| MPE_VSOA_INST | Operation Activity Instance |
| MPE_SAS_ACTION | SAS Actions (Transitions) |
| MPE_SAS_S_ST_CAT | SAS Status to Status Category Assignment |
| MPE_OA_COMP | Component Assignment to Operation Activities |
| IMPEARCGCADRAFT | I_MFGACTIONREASONCODEGROUPTP I_MFGACTIONREASONCODETOGROUPTP |
| MPE_SAS_S_AS_ACT | SAS Action Assignment (Status Transition) |
| MPE_EXEC_JOB_ST | Control Background Processes for Production Operations |
| IMFGARCGTPDRAFT | I_MFGACTIONREASONCODEGROUPTP I_MFGACTIONREASONCODEGROUPTP |
| MPE_OA_CAMERA | Camera views of an Operation Activity |
| MPE_SAS_C_STAT | SAS Status (Customer) |
| MPE_CA_FLD_CONF | MPE Compare-Field Level Comparison |
| MPE_SAS_S_MATCH | MPE SAS Status Matching Exceptions |
| MPE_OAN_GROUP_EL | OAN Elements |
| MPE_CA_ACT_CONF | MPE Compare-Field Level Comparison |
| MPE_WI_D | I_MFGWORKINSTRUCTIONTP I_MFGWORKINSTRUCTIONTP |
| MPE_SAS_S_SCHE_T | Status and Action Schema (SAS) - Text Table |
| MPE_OA_DEPEND | Cross-operation Dependencies Between Operation Activities |
| MPE_OA | Operation Activity |
| MPE_AHF_THSEQN | Type Handler Sequence |
| MPE_REASON_CAT | MPE Reason Code Categories |
| IMPEPHTPDRAFT | I_PRODUCTIONHOLDTP I_PRODUCTIONHOLDTP |
| MPE_S_OBJECT_TYP | MPE Object Types |
| MPE_COMP_OA | Component Assignment to Operation Activities |
| MPE_SAS_C_ACT | SAS Actions (Customer) |
| MPE_OA_WI_ST | Snapshot Of Work Instructions on Production Release |
| MPE_COMP_ASSY_IN | Instance assignment to component assemblies |
| MPE_VAR_ATTR | Variable Attributes |
| MPE_COMP_OAI | Component Assignment to Operation Activity Instances |
| MPE_SAS_S_SCHE | Status and Action Schema (SAS) |
| MPE_VSCMP_OAI_IN | Instances for Components at Operation Activity Instances |
| MPE_ACTION_T | MPE non-SAS Actions - Text Table |
| MPEASTPDRAFT | I_MFGACTIONSETTINGTP I_MFGACTIONSETTINGTP |
| MPE_AHF_S_STRUC | Structures identifying ATH Assignments |
| MPE_EXEC_HOLD_A | Actions on Production Hold |
| MPE_SAS_C_STAT_T | SAS Status (Customer) - Text Table |
| IMFGARCGCADRAFT | I_MFGACTIONREASONCODEGROUPTP I_MFGACTNRSNCODEGROUPCODEASSTP |
| MPE_STARTVARIANT | Start Variant for Reports |
| MPE_WI_PH | Work Instruction Place Holders |
| MPE_VSOAN_INST | Operation Activity Network Instance |
| MPE_AHF_THPARM | Type Handler Parameter |
| MPE_GROUP | OAN Group |
| MPE_OAI_ASS_USR | Shop Floor User to Operation Activity Instance Assignment |
| MPE_GROUP_T | Text table for OAN Group |
| MPE_OA_CER | Certificate Assignment to Operation Activities |
| IMFGRCGQMTPDRAFT | I_MFGACTIONREASONCODEGROUPQMTPI_MFGACTIONREASONCODEGROUPQMTP |
| MPE_CA_COMP_CONF | Operation activity comparison field configuration |
| IMFGARCQMTPDRAFT | I_MFGACTIONREASONCODEQMTP I_MFGACTIONREASONCODEQMTP |
| MPE_SAS_C_ST_CAT | SAS Status to Status Category Assignment (Customer) |
| MPE_COMP_ASSEMBL | Component Assignment for Assembly Activities |
| MPE_CA_ACK_LOG | Change Alert Acknowledgement Log Table |
| MPE_OA_WI | Work Instruction Assignment to Operation Activities |
| MPE_AHF_S_OBJ | Object Types supported by AHF |
| MPE_SAS_C_SCHE_T | Status and Action Schema (SAS) Customer - Text Table |
| MPE_AHF_C_THAN | Type Handler Master Data |
| MPE_CMP_OAI_INST | Instances for Components at Operation Activity Instances |
| MPE_WI_VARBL | Work Instruction Variable |
| IMFGARCGATPDRAFT | I_MFGACTIONREASONCODETP I_MFGACTNREASONCODEGROUPASSTP |
| MPE_AUART_PARM | PEO Execution Parameters dependent on Order Type & Plant |
| MPE_ACTION_SETT | MPE Action Settings |
| MPE_SAS_C_AS_STA | Status and Action Schema - Status Assignment |
| MPE_OA_INSTANCE | Operation Activity Instance |
| MPE_AFFW_SERNR | Assginment of Serial Numbers to Failed Goods Movements |
| MPE_OA_BUYOFF_D | I_OPACTYBUYOFFTP I_OPACTYBUYOFFTP |
| MPE_OA_I_SAS_STS | Operation Activity Instance Status |
| MPE_NC_DCSN_D | Draft table for defect decision |
| MPE_VSCOMP_OAI | Component Assignment to Operation Activity Instances |
| MPE_WI_VAR | Obsolete. New table: MPE_WI_VARBL |
| MPE_TT_CLAIM_WC | Tool Tracking: Work Center |
| MPE_ACTION | MPE non-SAS Actions |
| MPE_WI_VAR_ATTR | Obsolete. New table: MPE_WI_ph |
| MPE_OAC_ACTION | Actions triggered by Operation Activity Confirmation |
| MPE_SAS_STATUS | SAS Status |
| MPE_C_OBJECT_TYP | MPE Object Types |
| MPE_SAS_C_AS_ACT | SAS Action Assignment (Status Transition) Customer |
| MPE_AHF_ATH1 | Type Handlers assigned to Segment Type in a Plant |
| MPE_OA_LCOMP | Logical Component mapping table with Operation Activity |
| MPE_C_OBJECT_TYT | MPE Object Type Text |
| MPE_SAS_S_ACT_T | SAS Actions - Text Table |
| MPE_EXEC_HOLD | Production Hold |
| MPE_FEATURET | Manufacturing Features to be acknowledged |
| IMFGARCTPDRAFT | I_MFGACTIONREASONCODETP I_MFGACTIONREASONCODETP |
| MPE_DATA_INFO | Data Subject Information |
| MPE_EXEC_NOTE | Note of document |
| MPE_SFI_RWRK_OP | Rework Operation to be executed for a shop floor item |
| MPE_OA_CA | Summary of acknowledged Change Alerts |
| MPE_SAS_C_H_GP_T | Status and Action Schema Hierarchy Consistency Group Text |
| MPE_OA_QUAL | HR Qualification Assignment to Operation Activities |
| MPE_OAN_ELEM_DEP | Cross-operation Dependencies Between OAN Elements |
| MPET_OAN_ELEM_DP | Cross-operation Dependencies Between OAN Elements |
| MPE_SAS_S_ACT_LI | SAS Action: Status Category Transition Limitation |
| MPE_SAS_S_AL_CAT | Allowed Status Catergories for SAS Types |
| IMPEAAHTASDRAFT | I_MFGACTIONSETTINGTP I_MFGACTNHANDLERTOACTNSTTGTP |
| MPE_AHF_C_THPA | Type Handler specific Default Parameter |
| MPE_OA_MAT | Reference Material Assignment to Operation Activities |
| MPE_SFI_CONFIRM | MPE SFI Confirmations (History of SFI Execution) |
| MPE_SAS_STATUS_T | SAS Status (Customer) - Text Table |
| MPE_NF_PROF01 | Number Format Profile - Settings |
| MPE_OA_T | Text table for Operation Activity |
| MPE_AHF_S_ASGMT | Type Handler Assignments supported by Object Types |
| MPE_SAS_C_SCHE | Status and Action Schema (SAS) Customer |
| MPE_SAS_ACTION_T | SAS Actions - Text Table |
| MPE_OAC_UR | Update Request from Operation Activity Confirmation |
| MPE_EXEC_HOLD_SO | SFI@OA affected when a Production Hold was applied |
| MPE_AHF_TH_ACT | Type Handler Assignment to Actions |
| MPE_TT_CLAIM_OA | Tool Tracking: OAs |
| MPE_FEATURACTIV | Active Features |
| MPE_SAS_S_ACT | SAS Actions |
| MPE_SAS_C_ACT_T | SAS Actions (Customer) - Text Table |
| MPEIASTPDRAFT | I_MFGACTIONSETTINGSTP I_MFGACTIONSETTINGSTP |
| MPE_AHF_KEYS | Mapping of AFH Object Type specific Key to a generic Key |
| MPE_OA_PRT | Production Resources/Tools Assignment to Operation Act. |
| MPE_FEATURES | Features List |
| MPE_AHF_ATH2 | Type Handlers assigned to Operation Activities |
| MPE_SAS_SCHEMA_T | Status and Action Schema (SAS) - Text Table |
| MPEGMETPDRAFT | I_MFGGOODSMOVEMENTEXCPTNTP I_MFGGOODSMOVEMENTEXCPTNTP |
| MPE_OBJECT_LOG | Log for Buisness Objects |
| IMPERCGATPDRAFT | I_MFGACTIONREASONCODETP I_MFGACTIONREASONGROUPTOCODETP |
| MPE_NF_PROFILE | Number Format Profile |
| MPE_PRT_OAI | Production Resources/Tools Assignment to Oper. Act. Instance |
| MPE_OAC | Operation Activity Confirmation |
| MPE_WI_VERSION_D | I_MFGWORKINSTRUCTIONTP I_MFGWORKINSTRUCTIONVERSIONTP |
| MPE_OAN_T | Text table for Operation Activity Network |
| MPE_OA_PIC | Inspection Characteristic Assignment to Operation Activities |
| MPE_SFI | Shop Floor Item |
| MPE_SFI_STATUS | MPE SFI Status on OAN |
| MPE_OAN_ELEM_REL | OAN Elements Relations |
| MPE_OAN_ELEMENT | OAN Elements |
| MPE_SAS_C_AL_CAT | Allowed Status Catergories for SAS Types (Customer) |
| MPE_SAS_S_STAT_T | SAS Status - Text Table |
| MPE_AHF_C_THAN_T | Type Handler Text Table |
| MPE_OPER_DETAILS | MPE Data for Operations |
| MPE_SAS_S_H_GP_T | Status and Action Schema Hierarchy Consistency Group Text |
| MPE_TT_CLAIM_USR | Tool Tracking: User |
| MPE_SAS_C_H_GP | Status and Action Schema Hierarchy Consistency Group Text |
| MPE_WI_ST_REF | Work Instruction and standard text reference table |
| MPE_SAS_S_STAT | SAS Status |
| MPE_TT_CLAIM_HST | Tool Tracking: Claim history for equipment |
| MPE_VSPRT_OAI | Production Resources/Tools Assignment to Oper. Act. Instance |
| MPE_WI | Work Instruction Table |
| MPE_WI_VERSION | Work Instruction Version Table |
| MPE_UPGRADE | MPE Upgrade Features |
| MPE_WI_CONTENT | Work Instruction Content Table |
| MPE_SAS_C_H_GPM | Status and Action Schema Hierarchy Consistency Group Members |
| MPE_OAN_INSTANCE | Operation Activity Network Instance |