| 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 | VKBUR | Sales Office | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVBUR | VKBUR | Allow NULL? |
| 9 | VKGRP | Sales Group | nvarchar | 3 | 0 | CHAR | (N' ') | No | TVKGR | VKGRP | Allow NULL? |
| 10 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 11 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | VTWEG | Allow NULL? |
| 12 | SPART | Division for order header | nvarchar | 2 | 0 | CHAR | (N' ') | No | TSPA | SPART_AK | Allow NULL? |
| 13 | DRERZ | Publication | nvarchar | 8 | 0 | CHAR | (N' ') | No | JDTDRER | DRERZ | Allow NULL? |
| 14 | PVA | Edition | nvarchar | 8 | 0 | CHAR | (N' ') | No | JDTPVA | PVA | Allow NULL? |
| 15 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 16 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 17 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ETMEINS | Allow NULL? |
| 18 | STWAE | Statistics currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | STWAE | Allow NULL? |
| 19 | LFMNGAU | Quantity delivered (for order schedule line) | decimal | 15 | 0 | QUAN | ((0)) | Yes | | JMC_LFMNGZ | |
| 20 | REMMENGE | Quantity returned | decimal | 14 | 0 | QUAN | ((0)) | Yes | | JMC_REMMNG | |
| 21 | ANZREM | Number of returns | decimal | 9 | 0 | DEC | ((0)) | Yes | | JMC_ANZREM | |
| 22 | ANZREMPOS | Number of return items | decimal | 9 | 0 | DEC | ((0)) | Yes | | JMC_ANZREP | |
| 23 | REKMENGE | Complaint quantity | decimal | 14 | 0 | QUAN | ((0)) | Yes | | JMC_REKMNG | |
| 24 | NLMENGE | Subsequent delivery quantity | decimal | 14 | 0 | QUAN | ((0)) | Yes | | JMC_NLMENG | |
| 25 | BEZMENGE | Quantity purchased for complaint | decimal | 14 | 0 | QUAN | ((0)) | Yes | | JMC_BEZOGM | |
| 26 | ANZREK | Number of complaints | decimal | 9 | 0 | DEC | ((0)) | Yes | | JMC_ANZREK | |
| 27 | ANZREKPOS | Number of complaint items | decimal | 9 | 0 | DEC | ((0)) | Yes | | JMC_ANZRKP | |
| 28 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_UMNETWR | |
| 29 | UMBRTWR | Gross sales volume | decimal | 19 | 2 | CURR | ((0)) | Yes | | JMC_UMBR | |
| 30 | GUNETWR | Net value of credit memos | decimal | 19 | 2 | CURR | ((0)) | Yes | | MC_GUNETWR | |
| 31 | GUBRTWR | Gross credit memo value | decimal | 19 | 2 | CURR | ((0)) | Yes | | JMC_GUBR | |
| 32 | UMKZWI1 | Sales volume pricing subtotal 1 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_UMKZW1 | |
| 33 | UMKZWI2 | Sales volume pricing subtotal 2 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_UMKZW2 | |
| 34 | UMKZWI3 | Sales volume pricing subtotal | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_UMKZW3 | |
| 35 | UMKZWI4 | Sales volume pricing subtotal 4 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_UMKZW4 | |
| 36 | UMKZWI5 | Sales volume pricing subtotal 5 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_UMKZW5 | |
| 37 | UMKZWI6 | Sales volume pricing subtotal 6 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_UMKZW6 | |
| 38 | GUKZWI1 | Credit memo pricing subtotal 1 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_GUKZW1 | |
| 39 | GUKZWI2 | Credit memo pricing subtotal 2 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_GUKZW2 | |
| 40 | GUKZWI3 | Credit memo pricing subtotal 3 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_GUKZW3 | |
| 41 | GUKZWI4 | Credit memo pricing subtotal 4 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_GUKZW4 | |
| 42 | GUKZWI5 | Credit memo pricing subtotal 5 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_GUKZW5 | |
| 43 | GUKZWI6 | Credit memo pricing subtotal 6 | decimal | 17 | 2 | CURR | ((0)) | Yes | | JMC_GUKZW6 | |
