SAP Table S001
SIS: Customer Statistics
S001 (SIS: Customer Statistics) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link S001 to other SAP tables.
S001 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | 0 | |||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | 0 | |||
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | 0 | |||
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | 0 | |||
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | 0 | |||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | 0 | |||
| KUNNR | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 0 | ||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| PERIV | Fiscal Year Variant | PERIV | T009 | CHAR | 2 | 0 | ||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | 0 | |||
| STWAE | Statistics currency | WAERS_V | CUKY | 5 | 0 | |||
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | 0 | |||
| AENETWR | Net value of incoming orders | MC_AENETWR | CURR | 19 | 2 | |||
| UMNETWR | Net value of invoiced sales | MC_UMNETWR | CURR | 19 | 2 | |||
| OAUWE | Open net value of orders | MC_OAUWE | CURR | 19 | 2 | |||
| RENETWR | Net value of incoming returns | MC_RENETWR | CURR | 19 | 2 | |||
| GUNETWR | Net value of credit memos | MC_GUNETWR | CURR | 19 | 2 | |||
| AEMENGE | Incoming orders quantity | MC_AEMENGE | QUAN | 15 | 3 | |||
| UMMENGE | Sales quantity | MC_UMMENGE | QUAN | 15 | 3 | |||
| OAUME | Open orders quantity in base unit of measure | MC_OAUME | QUAN | 15 | 3 | |||
| REMENGE | Returns Quantity | MC_REMENGE | QUAN | 15 | 3 | |||
| GUMENGE | Credit memos quantity | MC_GUMENGE | QUAN | 15 | 3 | |||
| ANZAUPOS | Number of order items | MC_ANZAUPO | DEC | 9 | 0 | |||
| ANZREPOS | No.of returns items | MC_ANZREPO | DEC | 9 | 0 | |||
| AEWAVWR | Cost of incoming orders | MC_AEWAVWR | CURR | 19 | 2 | |||
| UMWAVWR | Cost of invoiced sales | MC_UMWAVWR | CURR | 19 | 2 | |||
| REWAVWR | Incoming returns: cost | MC_REWAVWR | CURR | 19 | 2 | |||
| GUWAVWR | Credit memos: cost | MC_GUWAVWR | CURR | 19 | 2 | |||
| AEKZWI1 | Incoming orders: gross | MC_AEKZWI1 | CURR | 17 | 2 | |||
| UMKZWI1 | Invoiced sales: gross | MC_UMKZWI1 | CURR | 17 | 2 | |||
| REKZWI1 | Incoming returns: gross | MC_REKZWI1 | CURR | 17 | 2 | |||
| GUKZWI1 | Credit memos: gross | MC_GUKZWI1 | CURR | 17 | 2 | |||
| AEKZWI2 | Incoming orders: net 1 | MC_AEKZWI2 | CURR | 17 | 2 | |||
| UMKZWI2 | Invoiced sales: net 1 | MC_UMKZWI2 | CURR | 17 | 2 | |||
| REKZWI2 | Incoming returns: net 1 | MC_REKZWI2 | CURR | 17 | 2 | |||
| GUKZWI2 | Credit memos: net 1 | MC_GUKZWI2 | CURR | 17 | 2 | |||
| AEKZWI3 | Incoming orders: net 2 | MC_AEKZWI3 | CURR | 17 | 2 | |||
| UMKZWI3 | Invoiced sales: net 2 | MC_UMKZWI3 | CURR | 17 | 2 | |||
| REKZWI3 | Incoming returns: net 2 | MC_REKZWI3 | CURR | 17 | 2 | |||
| GUKZWI3 | Credit memos: net 2 | MC_GUKZWI3 | CURR | 17 | 2 | |||
| AEKZWI4 | Incoming orders: freight | MC_AEKZWI4 | CURR | 17 | 2 | |||
| UMKZWI4 | Invoice freight charges | MC_UMKZWI4 | CURR | 17 | 2 | |||
| REKZWI4 | Incoming returns: freight | MC_REKZWI4 | CURR | 17 | 2 | |||
| GUKZWI4 | Credit memos: freight | MC_GUKZWI4 | CURR | 17 | 2 | |||
| AEKZWI5 | Incoming orders: pricing subtotal 5 | MC_AEKZWI5 | CURR | 17 | 2 | |||
| UMKZWI5 | Billing document: pricing subtotal 5 | MC_UMKZWI5 | CURR | 17 | 2 | |||
| REKZWI5 | Incoming returns: pricing subtotal 5 | MC_REKZWI5 | CURR | 17 | 2 | |||
| GUKZWI5 | Credit memos: pricing subtotal 5 | MC_GUKZWI5 | CURR | 17 | 2 | |||
| AEKZWI6 | Incoming orders: pricing subtotal 6 | MC_AEKZWI6 | CURR | 17 | 2 | |||
| UMKZWI6 | Billing document: pricing subtotal 6 | MC_UMKZWI6 | CURR | 17 | 2 | |||
| REKZWI6 | Incoming returns: pricing subtotal 6 | MC_REKZWI6 | CURR | 17 | 2 | |||
| GUKZWI6 | Credit memos: pricing subtotal 6 | MC_GUKZWI6 | CURR | 17 | 2 | |||
S001 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S001 | KUNNR | S001 | MANDT | KNA1 | General Data in Customer Master | MANDT |
| S001 | KUNNR | S001 | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| S001 | MANDT | S001 | MANDT | T000 | Clients | MANDT |
| S001 | MATNR | S001 | MANDT | MARA | General Material Data | MANDT |
| S001 | MATNR | S001 | MATNR | MARA | General Material Data | MATNR |
| S001 | PERIV | S001 | MANDT | T009 | Fiscal Year Variants | MANDT |
| S001 | PERIV | S001 | PERIV | T009 | Fiscal Year Variants | PERIV |
| S001 | SPART | S001 | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| S001 | SPART | S001 | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| S001 | VKORG | S001 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| S001 | VKORG | S001 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| S001 | VTWEG | S001 | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| S001 | VTWEG | S001 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
