| 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 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 3 | BONNR | Transaction number (till receipt) | nvarchar | 15 | 0 | NUMC | (N'000000000000000') | No | | W_BONNR | Allow NULL? |
| 4 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 5 | AFLAG | Promotion indicator | char | 1 | 0 | NUMC | (N'0') | No | | MCW_AFLAG | Allow NULL? |
| 6 | KALWOC | Calendar week | nvarchar | 2 | 0 | NUMC | (N'00') | No | | MCW_KALWOC | Allow NULL? |
| 7 | WOCHTG | Weekday | char | 1 | 0 | NUMC | (N'0') | No | | MCW_WOCHTG | Allow NULL? |
| 8 | TGZTKL | Time of day class | nvarchar | 4 | 0 | CHAR | (N' ') | No | TMCWW | MCW_TGZTKL | Allow NULL? |
| 9 | VKSTD | Hour of sale | nvarchar | 2 | 0 | NUMC | (N'00') | No | | W_VKSTD | Allow NULL? |
| 10 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 11 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | 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 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 18 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 19 | WAERK | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERK | Allow NULL? |
| 20 | KUNDK | Customer ID | char | 1 | 0 | CHAR | (N' ') | Yes | | W_KUNDK | Allow NULL? |
| 21 | KUNNR | Customer number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUND1 | Allow NULL? |
| 22 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | * | CCNUM | Allow NULL? |
| 23 | UMSMNG | Transaction sales - quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | W_UMSMNG | |
| 24 | VKMNG | Transaction sales - quantity in sales unit | decimal | 15 | 3 | QUAN | ((0)) | Yes | | W_VKMNG | |
| 25 | UMSATZ | Sales POS | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSATZ | |
| 26 | WERTUM | Sales value POS (exact value) | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_WERTUM | |
| 27 | ANZBON | Number of transactions (till receipts) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ANZBON | Allow NULL? |
| 28 | ANZPOS | Number of transaction items (till receipts) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ANZPOS | Allow NULL? |
| 29 | ANZWGR | Number of material groups in transaction (till receipt) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ANZWGR | Allow NULL? |
| 30 | PRSNLS | Price reduction from sales as per receipts/aggregated sales | decimal | 19 | 2 | CURR | ((0)) | Yes | | W_PRSNLS | |
| 31 | ANZAAR | Number of promotion items | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ANZAAR | Allow NULL? |
| 32 | ANZBKK | Number of known customers | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ANZBKK | Allow NULL? |
| 33 | ANZAKM | Number of anonymous customers (with payment card) | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ANZAKM | Allow NULL? |
| 34 | ANZAKO | Number of anonymous customers | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_ANZAKO | Allow NULL? |
| 35 | UHZEIT | Time sale was entered | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | MCW_UHZEIT | Allow NULL? |
| 36 | KMONAT | Calendar month | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MCW_MONAT | Allow NULL? |
| 37 | QUARTAL | Quarter | char | 1 | 0 | NUMC | (N'0') | Yes | | MCW_QUARTL | Allow NULL? |
| 38 | JAHR | Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | MCJAHR | Allow NULL? |
