| 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 | BWBELN | Document number for Retail transfer structures | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | MCW_BWBELN | Allow NULL? |
| 4 | BELPOS | Item number for Retail transfer structures | nvarchar | 6 | 0 | NUMC | (N'000000') | No | VBUP | MCW_BELPOS | Allow NULL? |
| 5 | TRJAHR | Transfer document year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | MCW_TRJAHR | Allow NULL? |
| 6 | BWVORG | SAP BW transaction key | nvarchar | 3 | 0 | NUMC | (N'000') | No | | MCW_BWVORG | Allow NULL? |
| 7 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 8 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 9 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 10 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 11 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 12 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERIV | Allow NULL? |
| 13 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VWDAT | Allow NULL? |
| 14 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 15 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 16 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 17 | BIWMNG | RIS/Reporting Server - Transfer base quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BIWMNG | |
| 18 | BIWMVE | RIS/Reporting Server - Transfer quantity sold | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_BIWMVE | |
| 19 | BIWGEO | RIS/Reporting Server - Transfer cost price | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BIWGEO | |
| 20 | BIWGVO | RIS/Reporting Server - Transfer retail price | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BIWGVO | |
| 21 | BIWGVP | RIS/Reporting Server - Transfer retail price with tax | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BIWGVP | |
| 22 | BIWANZ | RIS/Reporting Server - Transfer number of activities | int | 10 | 0 | INT4 | ((0)) | Yes | | MCW_BIWANZ | Allow NULL? |
| 23 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 24 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 25 | AKTNR | Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | WAKH | WAKTION | Allow NULL? |
| 26 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 27 | GRUND | Reason for goods movment | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | MB_GRUND | Allow NULL? |
| 28 | BRELEV | RIS/Reporting Server - stock relevance | char | 1 | 0 | CHAR | (N' ') | Yes | | MCW_BRELEV | Allow NULL? |
| 29 | SPANN | Flag: not affecting margins | char | 1 | 0 | CHAR | (N' ') | Yes | | SPANN | Allow NULL? |
