| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 3 | SAISO | Season Category | nvarchar | 4 | 0 | CHAR | (N' ') | No | T6WSP | SAISO | Allow NULL? |
| 4 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 5 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 6 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | VTWEG | Allow NULL? |
| 7 | WGRU2 | Material group hierarchy 2 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU2 | Allow NULL? |
| 8 | WGRU1 | Material group hierarchy 1 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU1 | Allow NULL? |
| 9 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 10 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 11 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 12 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 13 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 14 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 15 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERIV | Allow NULL? |
| 16 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VWDAT | Allow NULL? |
| 17 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WISP_PSWAE | Allow NULL? |
| 18 | PUMSGEO | Planned Business Volume | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_PUMSGEO | |
| 19 | IUMSGEO | Actual Business Volume | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_IUMSGEO | |
| 20 | PIDGEO | Planned Shrinkage | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_PIDGEO | |
| 21 | IIDGEO | Actual Shrinkage | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_IIDGEO | |
| 22 | PRETGEO | Planned Returns | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_PRETGEO | |
| 23 | IRETGEO | Actual Returns | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_IRETGEO | |
| 24 | PZUKGEO | Planned Additional Purchases | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_PZUKGEO | |
| 25 | IZUKGEO | Actual Additional Purchases | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_IZUKGEO | |
| 26 | VEDGEO | Budget Released at Cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_VEDGEO | |
| 27 | PEBSTGEO | Planned Closing Balance | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_PEBSTGEO | |
| 28 | BKSMGEO | Stock adjustment miscellaneous - cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_BKSMGEO | |
| 29 | BKSPGEO | Stock adjustment miscellaneous + (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_BKSPGEO | |
| 30 | ZUGSGEO | Miscellaneous receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ZUGSGEO | |
| 31 | ABGSGEO | Miscellaneous Issues at Cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ABGSGEO | |
| 32 | ZUGGEO | Receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGEO | |
| 33 | ABGGEO | Issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGEO | |
| 34 | IEBSTGEO | Actual Closing Balance | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_IEBSTGEO | |
| 35 | PUBMGEO | Planning Revaluation Cost Price Minus | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_PUBMGEO | |
| 36 | IUBMGEO | Actual Revaluation - Cost Price | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_IUBMGEO | |
