| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | MRP_ACC_SHORTAGE | All shortages that are accepted | 7 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 2 | MRP_BUF_DEM_ITEM | Supply demand items and uncovered demand items | 11 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 3 | MRP_BUF_SDIV_TOT | Supply Demand Items View Totals | 7 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 4 | MRP_BUF_SHORT_ST | Buffer Table Shortage Statistics | 7 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 5 | PPH_CACHE_ITEM | Supply demand items and uncovered demand items | 11 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 6 | PPH_CACHE_PLSEG | Cache Table Planning Segment | 7 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 7 | PPH_CACHE_SDIVTO | Supply Demand Items View Totals | 7 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 8 | PPH_CACHE_SHRTST | Cache Table Shortage Statistics | 7 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 9 | SDM_MSH_PROF01 | Material Shortage definition for SDM routines | 2 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 10 | SDM_MSH_PROF01_T | Material Shortage definition for SDM routines | 3 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 11 | SDM_MSH_PROFILE | Material Shortage profile for SDM routines | 2 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
| 12 | SDM_MSH_PROF_T | Material Shortage profile for SDM routines | 3 | MATERIALSHORTAGEPROFILE | Material Shortage Profile | nvarchar | 12 | 0 | | |
