| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Mandant | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | SSOUR | Statistiekherkomst | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | VRSIO | Nummer van de versie in de informatiestructuur | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 4 | SPMON | Analysetijdvak - maand | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 5 | SPTAG | Analysetijdvak - datum | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 6 | SPWOC | Analysetijdvak - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 7 | SPBUP | Analysetijdvak - boekingsperiode | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 8 | HIER_ID | Hiërarchie-ID | nvarchar | 2 | 0 | CHAR | (N' ') | No | | HIER_CNT | Allow NULL? |
| 9 | CDT1 | Categorie | nvarchar | 18 | 0 | CHAR | (N' ') | No | CMMD_CDT1 | CM_CDT1 | Allow NULL? |
| 10 | CDT2 | Subcategorie | nvarchar | 18 | 0 | CHAR | (N' ') | No | CMMD_CDT2 | CM_CDT2 | Allow NULL? |
| 11 | CDT3 | Segment | nvarchar | 18 | 0 | CHAR | (N' ') | No | CMMD_CDT3 | CM_CDT3 | Allow NULL? |
| 12 | CDT4 | Subsegment | nvarchar | 18 | 0 | CHAR | (N' ') | No | CMMD_CDT4 | CM_CDT4 | Allow NULL? |
| 13 | CDT5 | Subsubsegment | nvarchar | 18 | 0 | CHAR | (N' ') | No | CMMD_CDT5 | CM_CDT5 | Allow NULL? |
| 14 | CDT6 | Productgroep | nvarchar | 18 | 0 | CHAR | (N' ') | No | CMMD_CDT6 | CM_CDT6 | Allow NULL? |
| 15 | CDT7 | Markering | nvarchar | 18 | 0 | CHAR | (N' ') | No | CMMD_CDT7 | CM_CDT7 | Allow NULL? |
| 16 | PERIV | Boekjaarvariant | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERIV | Allow NULL? |
| 17 | VWDAT | Pointer naar beheergegevens | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VWDAT | Allow NULL? |
| 18 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WISP_PSWAE | Allow NULL? |
| 19 | BASME | Basishoeveelheidseenheid | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 20 | BSTGEO | Voorraad tegen inkoopprijs | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BSTGEO | |
| 21 | UMSGVO | Omzet verkoopprijs | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVO | |
| 22 | UMSGVP | Omzet VP met BTW | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGVP | |
| 23 | UMSGEO | Omzet inkoopprijs | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_UMSGEO | |
| 24 | CM_UMMKT_E | Marktomzet (EXT) | decimal | 19 | 2 | CURR | ((0)) | Yes | | CM_UMMKT_E | |
| 25 | CM_AZPRM | Aantal artikelpromoties | decimal | 8 | 0 | DEC | ((0)) | Yes | | CM_AZPRM | |
| 26 | CM_PTRTC_E | Penetratie bij doelklanten (EXT) | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_PTRTC_E | |
| 27 | CM_PFQTC_E | Inkoopfrequentie doelklanten (EXT) | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_PFQTC_E | |
| 28 | CM_UMSVO_E | Omzet verkoopprijs (EXT) | decimal | 19 | 2 | CURR | ((0)) | Yes | | CM_UMSVO_E | |
| 29 | CM_TAVAL_E | Gemiddelde waarde boodschappenmand (EXT) | decimal | 19 | 2 | CURR | ((0)) | Yes | | CM_TAVAL_E | |
| 30 | CM_UMSTC_E | Omzet doelklanten (EXT) | decimal | 19 | 2 | CURR | ((0)) | Yes | | CM_UMSTC_E | |
| 31 | CM_PFQ_E | Inkoopfrequentie (EXT) | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_PFQ_E | |
| 32 | CM_AZART | Aantal artikelen | decimal | 11 | 3 | DEC | ((0)) | Yes | | CM_AZART | |
| 33 | CM_ABDSG_E | Marktafdekking op segmentniveau (EXT) | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_ABDSG_E | |
| 34 | CM_ABDSS_E | Marktafdekking op niveau onderliggend segment (EXT) | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_ABDSS_E | |
| 35 | CM_CLOSR_E | Afsluitingspercentage (EXT) | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_CLOSR_E | |
| 36 | CM_STREV_E | Aantal filiaalbezoeken per klant | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_STREV_E | |
| 37 | BKIMVO | Voorraadcorrectie inventarisatieverschil verk.prijs negatief | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_BKIMVO | |
| 38 | CM_SHLFSPC | Schapoppervlak | decimal | 8 | 3 | DEC | ((0)) | Yes | | CM_SHLFSPC | |
| 39 | CM_CUSTF_E | Klanttevredenheid (EXT) | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_CUSTF_E | |
| 40 | CM_AZKON_E | Aantal consumenten (EXT) | decimal | 11 | 3 | DEC | ((0)) | Yes | | CM_AZKON_E | |
| 41 | CM_AZKUN_E | Aantal klanten (EXT) | decimal | 11 | 3 | DEC | ((0)) | Yes | | CM_AZKUN_E | |
| 42 | CM_MGRWT_E | Marktgroei (EXT) | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_MGRWT_E | |
| 43 | CM_AVGPR_E | Gemiddelde prijs per artikel (EXT) | decimal | 7 | 2 | CURR | ((0)) | Yes | | CM_AVGPR_E | |
| 44 | CM_AVGUB_E | Gemiddeld aantal artikelen per inkoop (EXT) | decimal | 7 | 3 | DEC | ((0)) | Yes | | CM_AVGUB_E | |
| 45 | CM_PENTR_E | Penetratie (EXT) | decimal | 6 | 3 | DEC | ((0)) | Yes | | CM_PENTR_E | |
| 46 | AUMMNG | Actie-omzet hoeveelheid in BHE | decimal | 15 | 3 | QUAN | ((0)) | Yes | | MCW_AUMMNG | |
| 47 | AUMGVO | Actie-omzet verkoopprijs | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUMGVO | |
| 48 | AUMGEO | Actie-omzet inkoopprijs | decimal | 19 | 2 | CURR | ((0)) | Yes | | MCW_AUMGEO | |
