| 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 | PLGTP | Price Band Category | nvarchar | 2 | 0 | CHAR | (N' ') | No | TWPT | PLGTP | Allow NULL? |
| 11 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 12 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 13 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 14 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 15 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 16 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERIV | Allow NULL? |
| 17 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VWDAT | Allow NULL? |
| 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WISP_PSWAE | Allow NULL? |
| 19 | PLMHT | Planned Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | WISP_PLMHT | Allow NULL? |
| 20 | UBPGVP | Revaluation at retail, plus, at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBPGVP | |
| 21 | UBMGVP | Revaluation at retail, minus, at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBMGVP | |
| 22 | UBPGVO | Revaluation at retail, plus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBPGVO | |
| 23 | UBMGVO | Revaluation at retail, minus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBMGVO | |
| 24 | UBPVPM | Revaluation at retail, plus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBPVPM | |
| 25 | UBMVPM | Revaluation at retail, minus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBMVPM | |
| 26 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_PRSNLS | |
| 27 | UMSGVP | Sales at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVP | |
| 28 | UMSGVO | Sales at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVO | |
| 29 | UMSGEO | Sales at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGEO | |
| 30 | UMSMNG | Sales quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UMSMNG | |
| 31 | WESGVP | Goods receipt (vendor) at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WESGVP | |
| 32 | WESGVO | Goods receipt (vendor) at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WESGVO | |
| 33 | WESMNG | Goods receipt (vendor) quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_WESMNG | |
| 34 | WESGEO | Goods receipt (vendor) at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WESGEO | |
| 35 | BKIMVP | Stock adjustment inventory difference minus (retail w/tax) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMVP | |
| 36 | BKIMVO | Stock adjustment inventory difference minus (retail) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMVO | |
| 37 | BKIMEO | Stock adjustment inventory difference minus (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMEO | |
| 38 | BKIMMG | Stock adjustment inventory difference minus (quantity) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BKIMMG | |
| 39 | RTEGVP | Returns to vendor at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_RTEGVP | |
| 40 | RTEGVO | Returns to vendor at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_RTEGVO | |
| 41 | RTEGEO | Returns to vendor at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_RTEGEO | |
| 42 | RTEMNG | Returns to vendor quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_RTEMNG | |
| 43 | BKSPGVP | Stock adjustment miscellaneous + retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_BKSPGVP | |
| 44 | BKSPGVO | Stock Adjustment Miscellaneous + Retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_BKSPGVO | |
| 45 | BKSPGEO | Stock adjustment miscellaneous + (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_BKSPGEO | |
| 46 | BKSPMNG | Stock Adjustment Miscellanous + Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | WISP_BKSPMNG | |
| 47 | BKSMGVP | Stock adjustment miscellaneous - retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_BKSMGVP | |
| 48 | BKSMGVO | Stock Adjustment Miscellaneous - Retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_BKSMGVO | |
| 49 | BKSMGEO | Stock adjustment miscellaneous - cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_BKSMGEO | |
| 50 | BKSMMNG | Stock Adjustment Miscellaneous - Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | WISP_BKSMMNG | |
| 51 | ZUGSGVP | Miscellaneous receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ZUGSGVP | |
| 52 | ZUGSGVO | Miscellaneous receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ZUGSGVO | |
| 53 | ZUGSGEO | Miscellaneous receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ZUGSGEO | |
| 54 | ZUGSMNG | Receipts miscellaneous quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | WISP_ZUGSMNG | |
| 55 | ABGSGVP | Misc Issues at Retail With Tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ABGSGVP | |
| 56 | ABGSGVO | Miscellaneous Issues at Retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ABGSGVO | |
| 57 | ABGSGEO | Miscellaneous Issues at Cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ABGSGEO | |
| 58 | ABGSMNG | Miscellaneous Issue Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | WISP_ABGSMNG | |
| 59 | ZUGGVP | Receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGVP | |
| 60 | ZUGGVO | Receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGVO | |
| 61 | ZUGGEO | Receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGEO | |
| 62 | ZUGMNG | Receipts quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ZUGMNG | |
| 63 | ABGGVP | Issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGVP | |
| 64 | ABGGVO | Issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGVO | |
| 65 | ABGGEO | Issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGEO | |
| 66 | ABGMNG | Issues quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ABGMNG | |
| 67 | ZUKGVP | Additional purchase at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ZUKGVP | |
| 68 | ZUKGVO | Additional purchase at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ZUKGVO | |
| 69 | ZUKGEO | Receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_ZUKGEO | |
| 70 | ZUKMNG | Additional purchase quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | WISP_ZUKMNG | |
| 71 | VEDGVP | Budget Released at Retail With Tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_VEDGVP | |
| 72 | VEDGVO | Budget Released at Retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_VEDGVO | |
| 73 | VEDGEO | Budget Released at Cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | WISP_VEDGEO | |
| 74 | VEDMNG | Budget Released as Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | WISP_VEDMNG | |
| 75 | UBMGEO | Revaluation at cost, minus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBMGEO | |
| 76 | UBPGEO | Revaluation at cost, plus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBPGEO | |