| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 3 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | BEDAE | Requirements type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | VERSB | Version number for independent requirements | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | PBDNR | Requirements Plan Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | BDZEI | Independent requirements pointer | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | ZUVKZ | Consumption indicator | char | 1 | 0 | | | | Allow NULL? |
| 9 | VERVS | Indicator: Version Active | char | 1 | 0 | | | | Allow NULL? |
| 10 | VERKZ | Consumption indicator for planning requirements | char | 1 | 0 | | | | Allow NULL? |
| 11 | ZUOKR | Criterion for allocation | nvarchar | 16 | 0 | | | | Allow NULL? |
| 12 | PLNKZ | Planning Indicator | char | 1 | 0 | | | | Allow NULL? |
| 13 | TXTKZ | Indicator: long text exists | char | 1 | 0 | | | | Allow NULL? |
| 14 | LOEVR | Deletion indicator | char | 1 | 0 | | | | Allow NULL? |
| 15 | UEBKZ | Indicator: data copied | char | 1 | 0 | | | | Allow NULL? |
| 16 | DATLP | Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | UHRLP | Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | AGGPB | Aggregation indicator for planned independent requirements | char | 1 | 0 | | | | Allow NULL? |
| 19 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | MCINF | Name of information structure | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | STFNA | Field name in the generated DDIC structure | nvarchar | 30 | 0 | | | | Allow NULL? |
| 23 | OPLKZ | With no MRP | char | 1 | 0 | | | | Allow NULL? |
| 24 | MCINC | Name of info structure - characteristic values | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | VRSIC | Version number in the information structure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | KNTTP | Account Assignment Category | char | 1 | 0 | | | | Allow NULL? |
| 27 | SOBKZ | Special Stock Indicator | char | 1 | 0 | | | | Allow NULL? |
| 28 | KZVBR | Consumption Posting | char | 1 | 0 | | | | Allow NULL? |
| 29 | PSPEL | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | PROFILID | Name of planning profile | nvarchar | 12 | 0 | | | | Allow NULL? |
| 33 | KZBWS | Valuation of Special Stock | char | 1 | 0 | | | | Allow NULL? |
| 34 | PBDNR_EXT | External Requirements Plan ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | SGT_RCAT | Requirement Segment | nvarchar | 16 | 0 | | | | Allow NULL? |
