| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | MRP_ACC_SHORTAGE | All shortages that are accepted | 13 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 2 | MRP_BUF_DEM_ITEM | Supply demand items and uncovered demand items | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 3 | MRP_BUF_PLAN_SG1 | Buffer Table Planning Segment | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 4 | MRP_BUF_SDIV_TOT | Supply Demand Items View Totals | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 5 | MRP_BUF_SHORT_ST | Buffer Table Shortage Statistics | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 6 | MRP_BUF_SUPPLIER | Buffer Table Supplier | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 7 | MRP_REQ_NOTE | Requests and Notes for MRP Cockpit | 12 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 8 | PPH_CACHE_ITEM | Supply demand items and uncovered demand items | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 9 | PPH_CACHE_PLSEG | Cache Table Planning Segment | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 10 | PPH_CACHE_SDIVTO | Supply Demand Items View Totals | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 11 | PPH_CACHE_SHRTST | Cache Table Shortage Statistics | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
| 12 | PPH_CACHE_SUPPL | Cache Table Supplier | 6 | MRPPLANNINGSEGMENTNUMBER | Planning segment number | nvarchar | 20 | 0 | | |
