| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | CHAR | (N' ') | No | TWISPC_PLHVS | WISP_PLHVS | Allow NULL? |
| 2 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | EKORG | Allow NULL? |
| 3 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | VKORG | Allow NULL? |
| 4 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | VTWEG | Allow NULL? |
| 5 | WGRU2 | Material group hierarchy 2 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU2 | Allow NULL? |
| 6 | WGRU1 | Material group hierarchy 1 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU1 | Allow NULL? |
| 7 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | * | MATKL | Allow NULL? |
| 8 | FILGRP | Store Group | nvarchar | 2 | 0 | NUMC | (N'00') | No | * | WISP_FILGRP | Allow NULL? |
| 9 | RELEF1 | Relative Proportional Factor 1 | decimal | 8 | 2 | DEC | ((0)) | Yes | | WISP_RELEF1 | |
| 10 | RELEF2 | Relative Proportional Factor 2 | decimal | 8 | 2 | DEC | ((0)) | Yes | | WISP_RELEF2 | |
| 11 | RELEF3 | Relative Proportional Factor 3 | decimal | 8 | 2 | DEC | ((0)) | Yes | | WISP_RELEF3 | |
| 12 | PRODF1 | Hierarchy Maintenance: Absolute Prop. Factor 1 (for Updates) | float | 15 | 16 | FLTP | ((0)) | Yes | | WISP_PRODF1 | |
| 13 | PRODF2 | Hierarchy Maintenance: Absolute Prop. Factor 2 (for Updates) | float | 15 | 16 | FLTP | ((0)) | Yes | | WISP_PRODF2 | |
| 14 | PRODF3 | Hierarchy Maintenance: Absolute Prop. Factor 3 (for Updates) | float | 15 | 16 | FLTP | ((0)) | Yes | | WISP_PRODF3 | |
| 15 | PLMHT | Planned Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | WISP_PLMHT | Allow NULL? |
| 16 | SPRED_3 | Default Distribution Key for a Period Without a Fiscal Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T821S | WISP_DVSPRED_3 | Allow NULL? |
| 17 | SPRED_7 | Default Distribution Key for a Period With a Fiscal Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T821S | WISP_DVSPRED_7 | Allow NULL? |
| 18 | FLGBASME | Planning Units and Base Units of Measure Are Different | char | 1 | 0 | CHAR | (N' ') | Yes | | WISP_FLGBASME | Allow NULL? |
| 19 | BASME | Base Unit of Measure for Planned Figures | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | WISP_BASME | Allow NULL? |
| 20 | FACTOR | Average Number of Low-Level Base Units of Measure | decimal | 8 | 3 | DEC | ((0)) | Yes | | WISP_FACTOR | |
