| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MATERIAL | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 3 | MRPAREA | MRP Area | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | MRPPLANT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | MRPGROUP | MRP Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | MRPCONTROLLER | MRP Controller (Materials Planner) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | MRPTYPE | MRP Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | MATERIALPROCUREMENTPROFILE | Special procurement type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | MATERIALPROCUREMENTCATEGORY | Procurement Type | char | 1 | 0 | | | | Allow NULL? |
| 10 | MATERIALPLANNEDDELIVERYDURN | Planned Delivery Time in Days | decimal | 3 | 0 | | | | |
| 11 | MATERIALPLANNEDPRODUCTIONDURN | In-house production time | decimal | 3 | 0 | | | | |
| 12 | MRPSAFETYDURATION | Safety time (in workdays) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | PLANNINGTIMEFENCEINDAYS | Planning time fence | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | PURCHASINGGROUP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | MATERIALGOODSRECEIPTDURATION | Goods Receipt Processing Time in Days | decimal | 3 | 0 | | | | |
| 16 | MATERIALSAFETYSTOCKQTY | DEC 20 3 | decimal | 20 | 3 | | | | |
| 17 | MATERIALBASEUNIT | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | MATERIALABCCLASSIFICATION | ABC Indicator | char | 1 | 0 | | | | Allow NULL? |
| 19 | MATERIALUSABILITYPROFILE | Plant-Specific Material Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | TOTALREPLENISHMENTLEADDURATION | Total replenishment lead time (in workdays) | decimal | 3 | 0 | | | | |
| 21 | MATERIALGROUP | Material Group | nvarchar | 9 | 0 | | | | Allow NULL? |
| 22 | MATERIALTYPE | Material Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | FACTORYCALENDARID | Factory calendar key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | PRODUCTIONSUPERVISOR | Production Supervisor | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | MATERIALREPLNMTLEADDURNENDDATE | Field of type DATS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | TOTALREPLNMTLEADDURNENDDATE | Field of type DATS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | MANUALPLANNINGHORIZONENDDATE | Field of type DATS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | MRPSAFETYDURATIONENDDATE | Field of type DATS | nvarchar | 8 | 0 | | | | Allow NULL? |
