| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | UNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | DISPO | MRP Controller (Materials Planner) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | DTDFV | Numc3, internal use | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | DTDFB | Numc3, internal use | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | BESKZ | Procurement Type | char | 1 | 0 | | | | Allow NULL? |
| 8 | SOBSL | Special procurement type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | SLKZ1 | Selection indicator for exception groups | char | 1 | 0 | | | | Allow NULL? |
| 10 | SLKZ2 | Selection indicator for exception groups | char | 1 | 0 | | | | Allow NULL? |
| 11 | SLKZ3 | Selection indicator for exception groups | char | 1 | 0 | | | | Allow NULL? |
| 12 | SLKZ4 | Selection indicator for exception groups | char | 1 | 0 | | | | Allow NULL? |
| 13 | SLKZ5 | Selection indicator for exception groups | char | 1 | 0 | | | | Allow NULL? |
| 14 | SLKZ6 | Selection indicator for exception groups | char | 1 | 0 | | | | Allow NULL? |
| 15 | SLKZ7 | Selection indicator for exception groups | char | 1 | 0 | | | | Allow NULL? |
| 16 | SLKZ8 | Selection indicator for exception groups | char | 1 | 0 | | | | Allow NULL? |
| 17 | JBEKZ | Selection indicator for processed MRP lists | char | 1 | 0 | | | | Allow NULL? |
| 18 | NBEKZ | Selection indicator for processed MRP lists | char | 1 | 0 | | | | Allow NULL? |
| 19 | SCUEB | Overview screen | char | 1 | 0 | | | | Allow NULL? |
| 20 | INPER | Internal period indicator | char | 1 | 0 | | | | Allow NULL? |
| 21 | WRT05 | Output in multi-function column 05 | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | BERW1 | Stock Days' Supply Without Receipts | decimal | 4 | 1 | | | | |
| 23 | BERW2 | First Receipt Days' Supply | decimal | 4 | 1 | | | | |
| 24 | SMEKZ | Standard unit of measure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | NAUKZ | Selection: all MRP lists with new exceptions | char | 1 | 0 | | | | Allow NULL? |
| 26 | DTDBV | Numc3, internal use | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | DTDBB | Numc3, internal use | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | MRPPP | PPC planning calendar | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | PRAST | Period split | nvarchar | 5 | 0 | | | | Allow NULL? |
| 30 | MAABC | ABC Indicator | char | 1 | 0 | | | | Allow NULL? |
| 31 | KDSRT | Sort individual customer segments in MRP lists | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | BERID | MRP Area | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | DBRKZ | Radio button for MRP area | char | 1 | 0 | | | | Allow NULL? |
| 34 | BERW4 | Second Receipt Days' Supply | decimal | 4 | 1 | | | | |
| 35 | WZFLG | Display end of total replenishment lead time | char | 1 | 0 | | | | Allow NULL? |
| 36 | MTREE | Display Overview Tree | char | 1 | 0 | | | | Allow NULL? |
| 37 | ATREE | Hide/show planning segment tree at number of segments | int | 10 | 0 | | | | Allow NULL? |
| 38 | BEDVL | New Input Values | char | 1 | 0 | | | | Allow NULL? |
| 39 | VRFWE | ID: Requirement/receipt date - availability/goods receipt | char | 1 | 0 | | | | Allow NULL? |
| 40 | NAVPR | Navigation profile | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | DFILT | Activate display filter and selection rule | char | 1 | 0 | | | | Allow NULL? |
| 42 | PRREG | Checking Rule for Availability Check | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | ERGBZ | Selection rule | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | FILBZ | Name of display filter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 45 | SBZKZ | Changes to grouping of dependent requirements | char | 1 | 0 | | | | Allow NULL? |
| 46 | ADBKZ | Selection independent of processing indicator | char | 1 | 0 | | | | Allow NULL? |
| 47 | DTLFV | Start of delivery date interval | decimal | 4 | 0 | | | | |
| 48 | DTLFB | End of delivery date interval | decimal | 4 | 0 | | | | |
| 49 | MEMFL | Read Order Report from Buffer | char | 1 | 0 | | | | Allow NULL? |
| 50 | DISMM | MRP Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 51 | MTRPO | Position of the Overview Tree | char | 1 | 0 | | | | Allow NULL? |
| 52 | MTRSZ | Size of Overview Tree | nvarchar | 2 | 0 | | | | Allow NULL? |
| 53 | ORDPR | Profile for Order Report | nvarchar | 12 | 0 | | | | Allow NULL? |
| 54 | MTART | Material Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 55 | MDATS | Display Tab Pages for Material Groupings | char | 1 | 0 | | | | Allow NULL? |
| 56 | MDNVM | Do Not Aggregate Quantity of Material Groupings | char | 1 | 0 | | | | Allow NULL? |
| 57 | MDKUM | No Stock Transfers in Cross-Plant View | char | 1 | 0 | | | | Allow NULL? |
| 58 | BERWV1 | Stock Days' Supply Without Receipts | decimal | 4 | 1 | | | | |
| 59 | BERWV2 | First Receipt Days' Supply | decimal | 4 | 1 | | | | |
| 60 | BERWV4 | Second Receipt Days' Supply | decimal | 4 | 1 | | | | |
