| 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 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 8 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 9 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 10 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | VTWEG | Allow NULL? |
| 11 | BZIRK | Sales district | nvarchar | 6 | 0 | CHAR | (N' ') | No | T171 | BZIRK | Allow NULL? |
| 12 | BTRKZ | Plant category | char | 1 | 0 | CHAR | (N' ') | No | | VLFKZ | Allow NULL? |
| 13 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 14 | WGRU2 | Material group hierarchy 2 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU2 | Allow NULL? |
| 15 | WGRU1 | Material group hierarchy 1 | nvarchar | 18 | 0 | CHAR | (N' ') | No | | MCW_WGRU1 | Allow NULL? |
| 16 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 17 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 18 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 19 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 20 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 21 | UMSMNG | Sales quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UMSMNG | |
| 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGEO | |
| 23 | UMSGVO | Sales at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVO | |
| 24 | UMSGVP | Sales at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVP | |
| 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_PRSNLS | |
| 26 | AUMMNG | Promotion sales quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_AUMMNG | |
| 27 | AUMGEO | Promotion sales at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUMGEO | |
| 28 | AUMGVO | Promotion sales at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUMGVO | |
| 29 | AUMGVP | Promotion sales at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUMGVP | |
| 30 | WESMNG | Goods receipt (vendor) quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_WESMNG | |
| 31 | WESGEO | Goods receipt (vendor) at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WESGEO | |
| 32 | WESGVO | Goods receipt (vendor) at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WESGVO | |
| 33 | WESGVP | Goods receipt (vendor) at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WESGVP | |
| 34 | WESANZ | Goods receipt (vendor) number of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_WESANZ | Allow NULL? |
| 35 | RTEMNG | Returns to vendor quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_RTEMNG | |
| 36 | RTEGEO | Returns to vendor at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_RTEGEO | |
| 37 | RTEGVO | Returns to vendor at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_RTEGVO | |
| 38 | RTEGVP | Returns to vendor at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_RTEGVP | |
| 39 | RTEANZ | Returns to vendor, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_RTEANZ | Allow NULL? |
| 40 | KMEMNG | Goods receipt (distribution center) quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_KMEMNG | |
| 41 | KMEGEO | Goods receipt (DC) at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMEGEO | |
| 42 | KMEGVO | Goods receipt (DC) at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMEGVO | |
| 43 | KMEGVP | Goods receipt (dist. center) at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMEGVP | |
| 44 | KMEANZ | Goods receipt (distribution center), no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_KMEANZ | Allow NULL? |
| 45 | KMAMNG | Goods issue (distribution center) quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_KMAMNG | |
| 46 | KMAGEO | Goods issue (DC) at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMAGEO | |
| 47 | KMAGVO | Goods issue (DC) at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMAGVO | |
| 48 | KMAGVP | Goods issue (dist. center) at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_KMAGVP | |
| 49 | KMAANZ | Goods issue (distribution center), no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_KMAANZ | Allow NULL? |
| 50 | ULEMNG | Goods clearing: receipts quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ULEMNG | |
| 51 | ULEGEO | Goods clearing: receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULEGEO | |
| 52 | ULEGVO | Goods clearing: receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULEGVO | |
| 53 | ULEGVP | Goods clearing: receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULEGVP | |
| 54 | ULEANZ | Goods clearing: receipts, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ULEANZ | Allow NULL? |
| 55 | ULAMNG | Goods clearing: issues quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ULAMNG | |
| 56 | ULAGEO | Goods clearing: issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULAGEO | |
| 57 | ULAGVO | Goods clearing: issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULAGVO | |
| 58 | ULAGVP | Goods clearing: issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ULAGVP | |
| 59 | ULAANZ | Goods clearing: issues, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ULAANZ | Allow NULL? |
| 60 | AUEMNG | Material transfer: receipts quantity BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_AUEMNG | |
| 61 | AUEGEO | Material transfer: receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUEGEO | |
| 62 | AUEGVO | Material transfer: receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUEGVO | |
| 63 | AUEGVP | Material transfer: receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUEGVP | |
| 64 | AUEANZ | Material transfer: receipts, no. transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_AUEANZ | Allow NULL? |
| 65 | AUAMNG | Material transfer: issues quantity BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_AUAMNG | |
| 66 | AUAGEO | Material transfer: issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUAGEO | |
| 67 | AUAGVO | Material transfer: issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUAGVO | |
| 68 | AUAGVP | Material transfer: issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUAGVP | |
| 69 | AUAANZ | Material transfer: issues, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_AUAANZ | Allow NULL? |
| 70 | BKIPMG | Stock adjustment inventory difference plus (quantity) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BKIPMG | |
| 71 | BKIPEO | Stock adjustment inventory difference plus (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIPEO | |
| 72 | BKIPVO | Stock adjustment inventory difference plus (retail) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIPVO | |
| 73 | BKIPVP | Stock adjustment inventory difference plus (at retail w/tax) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIPVP | |
| 74 | BKIPAZ | Stock adjustment inv. difference plus (no. of transactions) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BKIPAZ | Allow NULL? |
| 75 | BKIMMG | Stock adjustment inventory difference minus (quantity) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BKIMMG | |
| 76 | BKIMEO | Stock adjustment inventory difference minus (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMEO | |
| 77 | BKIMVO | Stock adjustment inventory difference minus (retail) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMVO | |
| 78 | BKIMVP | Stock adjustment inventory difference minus (retail w/tax) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMVP | |
| 79 | BKIMAZ | Stock adjustment inv. difference minus (no. of transactions) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BKIMAZ | Allow NULL? |
| 80 | BKSPMG | Stock adjustment miscellaneous plus (quantity) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BKSPMG | |
| 81 | BKSPEO | Stock adjustment miscellaneous plus (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSPEO | |
| 82 | BKSPVO | Stock adjustment miscellaneous plus (retail) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSPVO | |
| 83 | BKSPVP | Stock adjustment miscellaneous plus (retail with tax) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSPVP | |
| 84 | BKSPAZ | Stock adjustment miscellaneous plus (no. of transactions) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BKSPAZ | Allow NULL? |
| 85 | BKSMMG | Stock adjustment miscellaneous minus (quantity) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BKSMMG | |
| 86 | BKSMEO | Stock adjustment miscellaneous minus (cost) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSMEO | |
| 87 | BKSMVO | Stock adjustment miscellaneous minus (retail) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSMVO | |
| 88 | BKSMVP | Stock adjustment miscellaneous minus (retail with tax) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKSMVP | |
| 89 | BKSMAZ | Stock adjustment miscellaneous minus (no. of transactions) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BKSMAZ | Allow NULL? |
| 90 | BVLMNG | Order volume quantity Retail | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BVLMNG | |
| 91 | BVLGEO | Order volume at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BVLGEO | |
| 92 | BVLGVO | Order volume at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BVLGVO | |
| 93 | BVLGVP | Order volume at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BVLGVP | |
| 94 | BVLANZ | Order volume, number of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BVLANZ | Allow NULL? |
| 95 | UBPEPM | Revaluation at cost, plus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBPEPM | |
| 96 | UBPGEO | Revaluation at cost, plus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBPGEO | |
| 97 | UBPEAZ | Revaluation at cost plus, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_UBPEAZ | Allow NULL? |
| 98 | UBMEPM | Revaluation at cost minus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBMEPM | |
| 99 | UBMGEO | Revaluation at cost, minus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBMGEO | |
| 100 | UBMEAZ | Revaluation at cost minus, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_UBMEAZ | Allow NULL? |
| 101 | UBPVPM | Revaluation at retail, plus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBPVPM | |
| 102 | UBPGVO | Revaluation at retail, plus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBPGVO | |
| 103 | UBPGVP | Revaluation at retail, plus, at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBPGVP | |
| 104 | UBPVAZ | Revaluation at retail, plus, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_UBPVAZ | Allow NULL? |
| 105 | UBMVPM | Revaluation at retail, minus, quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_UBMVPM | |
| 106 | UBMGVO | Revaluation at retail, minus | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBMGVO | |
| 107 | UBMGVP | Revaluation at retail, minus, at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UBMGVP | |
| 108 | UBMVAZ | Revaluation at retail, minus, no. of transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_UBMVAZ | Allow NULL? |
| 109 | BSTMNG | Stock quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BSTMNG | |
| 110 | BSTGEO | Stock at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BSTGEO | |
| 111 | BSTGVO | Stock at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BSTGVO | |
| 112 | BSTGVP | Stock at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BSTGVP | |
| 113 | WESMAO | Goods receipt margin (vendor+GR(DC)) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_WESMAO | |
| 114 | WESMAM | Goods receipt margin with tax (vendor+GR(DC)) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_WESMAM | |
| 115 | UMSMAO | Sales margin | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_UMSMAO | |
| 116 | UMSMAM | Sales margin with tax | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_UMSMAM | |
| 117 | AUMMAO | Promotion sales margin | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_AUMMAO | |
| 118 | AUMMAM | Promotion sales margin with tax | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_AUMMAM | |
| 119 | BVLMAO | Order volume margin | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_BVLMAO | |
| 120 | BVLMAM | Order volume margin with tax | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_BVLMAM | |
| 121 | BSTMAO | Stock margin | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_BSTMAO | |
| 122 | BSTMAM | Stock margin including tax | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_BSTMAM | |
| 123 | ZUGMNG | Receipts quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ZUGMNG | |
| 124 | ZUGGEO | Receipts at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGEO | |
| 125 | ZUGGVO | Receipts at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGVO | |
| 126 | ZUGGVP | Receipts at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ZUGGVP | |
| 127 | ABGMNG | Issues quantity in BUn | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_ABGMNG | |
| 128 | ABGGEO | Issues at cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGEO | |
| 129 | ABGGVO | Issues at retail | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGVO | |
| 130 | ABGGVP | Issues at retail with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_ABGGVP | |
| 131 | RWMENG | Range of coverage in days (quantity) | decimal | 7 | 0 | DEC | ((0)) | Yes | | MCW_RWMENG | |
| 132 | RWWERT | Range of coverage in days (value) | decimal | 7 | 0 | DEC | ((0)) | Yes | | MCW_RWWERT | |
| 133 | UHMENG | Inventory turn (quantity) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_UHMENG | |
| 134 | UHWERT | Inventory turn (value) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_UHWERT | |
| 135 | JUMENG | Annual inventory turn (quantity) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_JUMENG | |
| 136 | JUWERT | Annual inventory turn (value) | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_JUWERT | |
| 137 | GMROIO | Gross margin return on inventory investment | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_GMROIO | |
| 138 | GMROIM | Gross margin return on inventory investment with tax | decimal | 6 | 2 | DEC | ((0)) | Yes | | MCW_GMROIM | |