| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DISPR | Material: MRP profile | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | DISMM | MRP Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | DISPO | MRP Controller (Materials Planner) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | KZDIE | Indicator: MRP controller is buyer (deactivated) | char | 1 | 0 | | | | Allow NULL? |
| 6 | MAABC | ABC Indicator | char | 1 | 0 | | | | Allow NULL? |
| 7 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | | | |
| 8 | DZEIT | In-house production time | decimal | 3 | 0 | | | | |
| 9 | FHORI | Scheduling Margin Key for Floats | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | SBDKZ | Dependent requirements ind. for individual and coll. reqmts | char | 1 | 0 | | | | Allow NULL? |
| 11 | KZBED | Indicator for Requirements Grouping | char | 1 | 0 | | | | Allow NULL? |
| 12 | EISBE | Safety Stock | decimal | 13 | 3 | | | | |
| 13 | MINBE | Reorder Point | decimal | 13 | 3 | | | | |
| 14 | DISLS | Lot size (materials planning) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | BSTRF | Rounding value for purchase order quantity | decimal | 13 | 3 | | | | |
| 16 | BSTMI | Minimum Lot Size | decimal | 13 | 3 | | | | |
| 17 | BSTMA | Maximum Lot Size | decimal | 13 | 3 | | | | |
| 18 | BSTFE | Fixed lot size | decimal | 13 | 3 | | | | |
| 19 | MABST | Maximum stock level | decimal | 13 | 3 | | | | |
| 20 | AUSSS | Assembly scrap in percent | decimal | 5 | 2 | | | | |
| 21 | LOSFX | Ordering costs | decimal | 11 | 2 | | | | |
| 22 | LAGPR | Storage costs indicator | char | 1 | 0 | | | | Allow NULL? |
| 23 | AUFTL | Splitting Indicator | char | 1 | 0 | | | | Allow NULL? |
| 24 | LGRAD | Service level | decimal | 3 | 1 | | | | |
| 25 | WEBAZ | Goods Receipt Processing Time in Days | decimal | 3 | 0 | | | | |
| 26 | USEQU | Quota arrangement usage | char | 1 | 0 | | | | Allow NULL? |
| 27 | PERKZ | Period Indicator | char | 1 | 0 | | | | Allow NULL? |
| 28 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | MRPPP | PPC planning calendar | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | SAUFT | Ind.: Repetitive mfg allowed | char | 1 | 0 | | | | Allow NULL? |
| 32 | SFEPR | Repetitive manufacturing profile | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | FXHOR | Planning time fence | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | VRMOD | Consumption mode | char | 1 | 0 | | | | Allow NULL? |
| 35 | VINT1 | Consumption period: backward | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | VINT2 | Consumption period: forward | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | DISGR | MRP Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 38 | KAUSF | Component scrap in percent | decimal | 5 | 2 | | | | |
| 39 | ALTSL | Method for Selecting Alternative Bills of Material | char | 1 | 0 | | | | Allow NULL? |
| 40 | MISKZ | Mixed MRP indicator | char | 1 | 0 | | | | Allow NULL? |
| 41 | WZEIT | Total replenishment lead time (in workdays) | decimal | 3 | 0 | | | | |
| 42 | VPMAT | Planning material | nvarchar | 18 | 0 | | | | Allow NULL? |
| 43 | VPWRK | Planning plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 44 | VPREF | Conv. factor f. plng material | nvarchar | 10 | 0 | | | | Allow NULL? |
| 45 | TAKZT | Takt time | decimal | 3 | 0 | | | | |
| 46 | RWPRO | Range of coverage profile | nvarchar | 3 | 0 | | | | Allow NULL? |
| 47 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | | | Allow NULL? |
| 48 | RDPRF | Rounding Profile | nvarchar | 4 | 0 | | | | Allow NULL? |
| 49 | STRGR | Planning strategy group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 50 | SOBSL | Special procurement type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 51 | RGEKZ | Indicator: Backflush | char | 1 | 0 | | | | Allow NULL? |
| 52 | SCHGT | Indicator: Bulk Material | char | 1 | 0 | | | | Allow NULL? |
| 53 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 54 | SHFLG | Safety time indicator (with or without safety time) | char | 1 | 0 | | | | Allow NULL? |
| 55 | SHZET | Safety time (in workdays) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 56 | MDACH | Action control: planned order processing | nvarchar | 2 | 0 | | | | Allow NULL? |
| 57 | LGPRO | Issue Storage Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 58 | MTVFP | Checking Group for Availability Check | nvarchar | 2 | 0 | | | | Allow NULL? |
| 59 | BESKZ | Procurement Type | char | 1 | 0 | | | | Allow NULL? |
| 60 | KZECH | Determination of batch entry in the production/process order | char | 1 | 0 | | | | Allow NULL? |
| 61 | EISLO | Minimum Safety Stock | decimal | 13 | 3 | | | | |
| 62 | PLIFZX | Consider Planned Delivery Time of the MRP Area | char | 1 | 0 | | | | Allow NULL? |
| 63 | LGFSB | Default storage location for external procurement | nvarchar | 4 | 0 | | | | Allow NULL? |
