SAP Material Requirements Planning Tables
Are you looking for the right table related to SAP Material Requirements Planning 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 Material Requirements Planning (PP-MRP) module.
Top 10 tables in Material Requirements Planning
| Table | Description |
|---|---|
| MRP_REQ_NOTE | Requests and Notes for MRP Cockpit |
| PPH_CACHE_SHRTST | Cache Table Shortage Statistics |
| PPH_CACHE_PLT_TH | Time horizons of MRP buffer |
| FCDM_HEAD | Forecast Demand Head |
| PPHMRPLOG | MRP Live Log Header |
| SDM_MSH_PROF01_T | Material Shortage definition for SDM routines |
| FCDM_HEAD_LOCK | Forecast Demand Head Lock Structure |
| PPHMRPPPLOG | MRP Live Postprocessing Log Header |
| PPH_DBVM_TSTAMP | Table of last mrp-relevant changes for MRP Apps |
| PPHMRPSET | Settings for MRP Live |
List of tables in Material Requirements Planning
| Table | Description |
|---|---|
| MRP_REQ_NOTE | Requests and Notes for MRP Cockpit |
| PPH_CACHE_SHRTST | Cache Table Shortage Statistics |
| PPH_CACHE_PLT_TH | Time horizons of MRP buffer |
| FCDM_HEAD | Forecast Demand Head |
| PPHMRPLOG | MRP Live Log Header |
| SDM_MSH_PROF01_T | Material Shortage definition for SDM routines |
| FCDM_HEAD_LOCK | Forecast Demand Head Lock Structure |
| PPHMRPPPLOG | MRP Live Postprocessing Log Header |
| PPH_DBVM_TSTAMP | Table of last mrp-relevant changes for MRP Apps |
| PPHMRPSET | Settings for MRP Live |
| PPHMRPPPLOGITEM | MRP Live Postprocessing Log Item |
| PPH_PRVM | Planning File Entry, MRP Area, Make-To-Project |
| SDM_REC_PROFILE | Receipt profile for SDM routines |
| SDM_DEM_PROFILE | Demand profile for SDM routines |
| PPH_CACHE_MAT | Cache Table Material |
| SDM_DEM_PROF_T | Demand profile for SDM routines |
| SDM_MSH_PROF_T | Material Shortage profile for SDM routines |
| SDM_MSH_PROF01 | Material Shortage definition for SDM routines |
| PPHMRP_POSTPROC | MRP Live Postprocessing Processes |
| MRP_BUFFER_RUN | Buffer Run Lock table |
| PPH_MRP_ISSUES | Issues for materials created by MRP |
| PPH_DBVM | Planning File Entry, MRP Area |
| TTPFK_CUSTOMER | Functions for Customer Contact Persons |
| FCDM_HIST | Forecast Demand History |
| PPH_MRP_PERIODS | Period table for lot-sizing in MRP |
| PPH_HANA_ACTIVE | Objects in Which DB Optimization Is to Be Used |
| SDM_AOR | SDM Area of Responsibility |
| FCDM_ITEM | Forecast Demand Item |
| PPH_CACHE_SUPPL | Cache Table Supplier |
| PBED_DRAFT | Independent Requirements Data: Draft Quantity |
| SDM_REC_PROF01 | Receipt profile for SDM routines |
| SDM_DOS_PROFILE | Days of Supply Profile |
| MRP_BUFFER_RUN03 | Buffer Run Lock table |
| PPHMRP_EKET_PP | MRP Live: Schedule lines for postprocessing |
| PPH_CACHE_PLSEG | Cache Table Planning Segment |
| PPH_KBVM | Planning File Entry, MRP Area, MTO |
| PPHMRPTYPEELMNTS | MRP Element Categories considered by PPH MRP |
| PPH_PFE_CHANGE | Table for PFE changes |
| SDM_MSH_PROFILE | Material Shortage profile for SDM routines |
| PPH_CACHE_PLT_DT | Current dates of Plant |
| SDM_REC_PROF_T | Receipt profile for SDM routines |
| PPH_CACHE_MC_TOT | Supply Demand Items View Totals for Materials to Order App |
| PPH_CACHE_RUN | MRP Apps cache lock table |
| FCDM_VERS | Forecast Demand Version |
| PPHDBVMSET | PPH: additional material settings |
| MRP_REQ_LINE | Date and Quantity Values for Change Requests |
| PPH_CACHE_SDIVTO | Supply Demand Items View Totals |
| FCDM_VERS_T | Forecast Demand Version Text |
| PPH_CACHE_ITEM | Supply demand items and uncovered demand items |
| SDM_AOR_PROFILE | MRP Cockpit Area of Responsibility, assignement of profile |
| MRP_ACC_SHORTAGE | All shortages that are accepted |
| PPHMRPLOGITEM | MRP Live Log Item |
| SDM_DEM_PROF01 | Demand profile for SDM routines |
| SDM_DOS_PROF_T | Days of Supply Profile |
| TTPFK | Functions for Vendor Contact Persons |