| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | HIST_ID | Document ID for Pegging History | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 5 | GRPNR | Grouping WBS element | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | REPOBJ | Object Number Replenishment Element | nvarchar | 22 | 0 | | | | Allow NULL? |
| 7 | ASS_PSPNR | Assigned WBS Element | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | INSTK | Assigned Quantity is in Stock | char | 1 | 0 | | | | Allow NULL? |
| 9 | BRK_OBJNR | Object Number for Breakpoint | nvarchar | 22 | 0 | | | | Allow NULL? |
| 10 | TOPDAT | Requirements Date for Causing Requirement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | ASQTY | Allocated Quantity | decimal | 13 | 3 | | | | |
| 12 | XSSQTY | Assigned Surplus Quantity | decimal | 13 | 3 | | | | |
| 13 | SCPQTY | Assigned Scrap Quantity | decimal | 13 | 3 | | | | |
| 14 | LQTY | Assigned, Missing Quantity | decimal | 13 | 3 | | | | |
| 15 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | GAMNG | Total Order Quantity | decimal | 13 | 3 | | | | |
| 17 | EXCESS | Assignment of Surplus | char | 1 | 0 | | | | Allow NULL? |
| 18 | SCRAP | Assignment of Scrap | char | 1 | 0 | | | | Allow NULL? |
| 19 | LOST | Assignment of Stock Differences | char | 1 | 0 | | | | Allow NULL? |
| 20 | RESDT | Withdrawal data from MRP-WBS element stock | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | LOEVM | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 22 | CPUDT | Date Document Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | TIMESTMP | Time created (Greenwich Meantime) | decimal | 16 | 0 | | | | |