| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | MTART | MRP Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | BANER | Creation Indicator for Purchase Requisitions | char | 1 | 0 | | | | Allow NULL? |
| 5 | DISER | Creation Indicator for MRP Lists | char | 1 | 0 | | | | Allow NULL? |
| 6 | UMTHZ | Rescheduling horizon | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | FIXHZ | Planning time fence | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | PLAHZ | Planning horizon | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | SBDIS | Share of safety stock which can be used for planning | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | LIFKZ | Automatic Schedule Lines (Scheduling Agreements) | char | 1 | 0 | | | | Allow NULL? |
| 11 | GTERM | Scheduling according to purchasing info record or agreement | char | 1 | 0 | | | | Allow NULL? |
| 12 | KZDRB | Indicator: direct procurement/production MRP | char | 1 | 0 | | | | Allow NULL? |
| 13 | XFAT1 | Firm Only Schedule Lines Transmitted to Vendor by Purchasing | char | 1 | 0 | | | | Allow NULL? |
| 14 | XFAT2 | Fant. 2 | char | 1 | 0 | | | | Allow NULL? |
| 15 | VWVOR | Tolerance value for bringing forward receipt elements | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | VWVER | Tolerance value for displacement in the future | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | PRREG | Checking Rule for Availability Check | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | VRMOD | Consumption mode | char | 1 | 0 | | | | Allow NULL? |
| 19 | VINT1 | Consumption period: backward | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | VINT2 | Consumption period: forward | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | STRGR | Planning strategy group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | RESHZ | Roll forward period for the master plan | decimal | 2 | 0 | | | | |
| 23 | ANDIS | Number of Days After Which the Material Must Be Planned | smallint | 5 | 0 | | | | |
| 24 | AUART | Order Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | AUAR2 | Order type for process order | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | PLSEL | Issue Storage Location Selection | char | 1 | 0 | | | | Allow NULL? |
| 27 | RVPKZ | Adjustment of Planned Independent Requirements | char | 1 | 0 | | | | Allow NULL? |
| 28 | RESVP | Period of adjustment for planned independent requirements | decimal | 3 | 0 | | | | |
| 29 | SHFLG | Safety time indicator (with or without safety time) | char | 1 | 0 | | | | Allow NULL? |
| 30 | SHZET | Safety time (in workdays) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | MDACH | Action control: planned order processing | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | PRASTA | Period split | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | EXSGT | Do not explode bulk material items | char | 1 | 0 | | | | Allow NULL? |
| 34 | BESAL | Determination of explosion date for BOM and routing | char | 1 | 0 | | | | Allow NULL? |
| 35 | BSART | MRP:doc.type purchase requisitions for standard purchase ord | nvarchar | 4 | 0 | | | | Allow NULL? |
| 36 | BARTL | MRP: Document type purchase requisition for subcontracting | nvarchar | 4 | 0 | | | | Allow NULL? |
| 37 | BARTU | MRP: purchase requisition for stock transfer - document type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 38 | GRREL | Relevant for requirements grouping for project stock | char | 1 | 0 | | | | Allow NULL? |
| 39 | VERTR | Start date of order proposals allowed in the past | char | 1 | 0 | | | | Allow NULL? |
| 40 | FKOBS | ATP check by full confirmation logic | char | 1 | 0 | | | | Allow NULL? |
| 41 | EVAPR | Evaluation Profile for Range-of-Coverage Data | nvarchar | 3 | 0 | | | | Allow NULL? |
