| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | PSACT | Planning scenario status | char | 1 | 0 | | | | Allow NULL? |
| 4 | PLSCT | Planning scenario description | nvarchar | 40 | 0 | | | | Allow NULL? |
| 5 | PDAT1 | Start of the planning period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | PDAT2 | End of planning period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | MDATE | Plng scenario: key date for chnge status of material master | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SBFLG | Long-term plnng: depend.reqmts for reorder point materials | char | 1 | 0 | | | | Allow NULL? |
| 9 | SSTCK | Opening stock for long-term planning | char | 1 | 0 | | | | Allow NULL? |
| 10 | SSTFL | Long term planning: average plant stock compiled | char | 1 | 0 | | | | Allow NULL? |
| 11 | VERSA | Active version of available capacity | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | FIXEL | Long-term planning: include firmed issues and receipts | char | 1 | 0 | | | | Allow NULL? |
| 13 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | EISDT | Date of last data transfer to the purchasing info system | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | VSBCO | Inventory controlling version | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | BCODT | Date of last data transfer to inventory controlling | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | FIXLO | Long-term planning: switch off planning time fence | char | 1 | 0 | | | | Allow NULL? |
| 18 | EINPL | Long-term planning: single-item planning in scenario on/off | char | 1 | 0 | | | | Allow NULL? |
| 19 | KDAKZ | Long-term planning: Consider sales orders? Yes/No | char | 1 | 0 | | | | Allow NULL? |
| 20 | FBAKZ | Long-term planning:include firm purchase requisitions yes/no | char | 1 | 0 | | | | Allow NULL? |
| 21 | FPAKZ | Long-term planning: Include firm planned orders yes/no | char | 1 | 0 | | | | Allow NULL? |
| 22 | DIRKZ | Long-term planning: Use direct production | char | 1 | 0 | | | | Allow NULL? |
| 23 | AVMKZ | Long-term planning: Do not calculate scrap quantity | char | 1 | 0 | | | | Allow NULL? |
| 24 | LLSKZ | Long-term planning: Use gross lot size | char | 1 | 0 | | | | Allow NULL? |
| 25 | LTPLS | Long-term planning lot size procedure (gross) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | LTPID | Long-term planning: Selection ID for BOMs | nvarchar | 2 | 0 | | | | Allow NULL? |
