| 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 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 3 | KUNNR | Sold-to party | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | KUNAG | Allow NULL? |
| 4 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 5 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | VTWEG | Allow NULL? |
| 6 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | TSPA | SPART | Allow NULL? |
| 7 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 8 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 9 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 10 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 11 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 12 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 13 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T009 | PERIV | Allow NULL? |
| 14 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 15 | STWAE | Statistics currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS_V | Allow NULL? |
| 16 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 17 | AENETWR | Net value of incoming orders | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_AENETWR | |
| 18 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_UMNETWR | |
| 19 | OAUWE | Open net value of orders | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_OAUWE | |
| 20 | RENETWR | Net value of incoming returns | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_RENETWR | |
| 21 | GUNETWR | Net value of credit memos | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_GUNETWR | |
| 22 | AEMENGE | Incoming orders quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_AEMENGE | |
| 23 | UMMENGE | Sales quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_UMMENGE | |
| 24 | OAUME | Open orders quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_OAUME | |
| 25 | REMENGE | Returns Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_REMENGE | |
| 26 | GUMENGE | Credit memos quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MC_GUMENGE | |
| 27 | ANZAUPOS | Number of order items | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ANZAUPO | |
| 28 | ANZREPOS | No.of returns items | decimal | 9 | 0 | DEC | ((0)) | Yes | | MC_ANZREPO | |
| 29 | AEWAVWR | Cost of incoming orders | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_AEWAVWR | |
| 30 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_UMWAVWR | |
| 31 | REWAVWR | Incoming returns: cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_REWAVWR | |
| 32 | GUWAVWR | Credit memos: cost | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_GUWAVWR | |
| 33 | AEKZWI1 | Incoming orders: gross | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_AEKZWI1 | |
| 34 | UMKZWI1 | Invoiced sales: gross | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_UMKZWI1 | |
| 35 | REKZWI1 | Incoming returns: gross | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_REKZWI1 | |
| 36 | GUKZWI1 | Credit memos: gross | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_GUKZWI1 | |
| 37 | AEKZWI2 | Incoming orders: net 1 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_AEKZWI2 | |
| 38 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_UMKZWI2 | |
| 39 | REKZWI2 | Incoming returns: net 1 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_REKZWI2 | |
| 40 | GUKZWI2 | Credit memos: net 1 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_GUKZWI2 | |
| 41 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_AEKZWI3 | |
| 42 | UMKZWI3 | Invoiced sales: net 2 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_UMKZWI3 | |
| 43 | REKZWI3 | Incoming returns: net 2 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_REKZWI3 | |
| 44 | GUKZWI3 | Credit memos: net 2 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_GUKZWI3 | |
| 45 | AEKZWI4 | Incoming orders: freight | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_AEKZWI4 | |
| 46 | UMKZWI4 | Invoice freight charges | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_UMKZWI4 | |
| 47 | REKZWI4 | Incoming returns: freight | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_REKZWI4 | |
| 48 | GUKZWI4 | Credit memos: freight | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_GUKZWI4 | |
| 49 | AEKZWI5 | Incoming orders: pricing subtotal 5 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_AEKZWI5 | |
| 50 | UMKZWI5 | Billing document: pricing subtotal 5 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_UMKZWI5 | |
| 51 | REKZWI5 | Incoming returns: pricing subtotal 5 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_REKZWI5 | |
| 52 | GUKZWI5 | Credit memos: pricing subtotal 5 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_GUKZWI5 | |
| 53 | AEKZWI6 | Incoming orders: pricing subtotal 6 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_AEKZWI6 | |
| 54 | UMKZWI6 | Billing document: pricing subtotal 6 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_UMKZWI6 | |
| 55 | REKZWI6 | Incoming returns: pricing subtotal 6 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_REKZWI6 | |
| 56 | GUKZWI6 | Credit memos: pricing subtotal 6 | decimal | 17 | 2 | CURR | ((0)) | Yes | | MC_GUKZWI6 | |
