| 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 | BWBELN | BW: Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | MCBW_BELN | Allow NULL? |
| 9 | BWBLPOS | BW: Document Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | VBUP | MCBW_BLPOS | Allow NULL? |
| 10 | BWEINT | BW: Document Schedule | nvarchar | 4 | 0 | NUMC | (N'0000') | No | VBEP | MCBW_EINT | Allow NULL? |
| 11 | BWVORG | BW: Transaction Key SAP BW | nvarchar | 3 | 0 | NUMC | (N'000') | No | | MCBW_VORG | Allow NULL? |
| 12 | BWSUPKZ | Auxiliary statistics update indicator | char | 1 | 0 | CHAR | (N' ') | No | | MCBW_SUPKZ | Allow NULL? |
| 13 | ERZET | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | ERZET | Allow NULL? |
| 14 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 15 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VWDAT | Allow NULL? |
| 16 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 17 | WAERK | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERK | Allow NULL? |
| 18 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 19 | BWMVE | BW: Quantity in Sales Unit | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCBW_MVE | |
| 20 | BWANZ | BW: Number of Transactions | int | 10 | 0 | INT4 | ((0)) | Yes | | MCBW_ANZ | Allow NULL? |
| 21 | KZWI1 | Subtotal 1 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI1 | |
| 22 | KZWI2 | Subtotal 2 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI2 | |
| 23 | KZWI3 | Subtotal 3 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI3 | |
| 24 | KZWI4 | Subtotal 4 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI4 | |
| 25 | KZWI5 | Subtotal 5 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI5 | |
| 26 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI6 | |
| 27 | PKUNAG | Sold-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNAG | Allow NULL? |
| 28 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | EWERK | Allow NULL? |
| 29 | AKTNR | Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | WAKH | WAKTION | Allow NULL? |
| 30 | WMINR | Product Catalog Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | MCBW_WMINR | Allow NULL? |
| 31 | MATWA | Material entered | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATWA | Allow NULL? |
| 32 | VOGRU | BW: Reason for Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | MCBW_VOGRU | Allow NULL? |
| 33 | ABGRU | Reason for rejection of quotations and sales orders | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVAG | ABGRU_VA | Allow NULL? |
| 34 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 35 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVKOV | VTWEG | Allow NULL? |
| 36 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTA | SPART | Allow NULL? |
| 37 | VKBUR | Sales Office | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKBZ | VKBUR | Allow NULL? |
| 38 | VKGRP | Sales Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TVBVK | VKGRP | Allow NULL? |
| 39 | PKUNWE | Ship-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNWE | Allow NULL? |
| 40 | BWBLTYP | BW: Document Category | char | 1 | 0 | CHAR | (N' ') | Yes | | MCBW_BLTYP | Allow NULL? |
| 41 | BWBLART | BW: Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVAK | MCBW_BLART | Allow NULL? |
| 42 | BWBTYP | BW: Item Category Document | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | MCBW_BPTYP | Allow NULL? |
| 43 | KNUMA_AG | Sales deal | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KONA | KNUMA_AG | Allow NULL? |
| 44 | BWAPPLNM | Application Component | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | RSAPPLNM | Allow NULL? |
| 45 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 46 | BWGEOD | BW: Cost Value in Document Currency | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCBW_GEOD | |
| 47 | BWGVOD | BW: Retail Value in Document Currency | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCBW_GVOD | |
| 48 | BWGVPD | BW: Retail Value with Tax in Document Currency | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCBW_GVPD | |
| 49 | BWPNLD | BW: Price Reduction in Document Currency | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCBW_PNLD | |
| 50 | BWOAUWD | BW: Net Open Sales Order Value in Document Currency | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCBW_OAUWD | |
| 51 | KURSK_DAT | Translation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WWERT_D | Allow NULL? |
| 52 | KURSK | Exchange Rate for Price Determination | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSK | |
| 53 | WAERS | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 54 | UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMVKZ | |
| 55 | UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMVKN | |
| 56 | BWOAUMV | BW: Open Order Quantity in Base Unit of Measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCBW_OAUMB | |
| 57 | APERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 58 | BWMNG | BW: Quantity in Base Unit of Measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCBW_MNG | |
