In this post, I will try and describe everything you need to know about the SAP s001 table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for S001 what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from S001....Right lets get started!
Object Name: S001
Dictionary Type: Transparent table
Description: SIS: Customer Statistics
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
MANDT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | |||||
SSOUR | SSOUR | CHAR | 4(0) | Statistic(s) origin | SSOUR | MCP1 | ||||||
VRSIO | VRSIO | CHAR | 3(0) | * | Version number in the information structure | VRSIO | MCV | MCP1 | ||||
SPMON | SPMON | NUMC | 6(0) | Period to analyze - month | MCPERIOD | MCS | ||||||
SPTAG | SPTAG | DATS | 8(0) | Period to analyze - current date | DATUM | MCS | ||||||
SPWOC | SPWOC | NUMC | 6(0) | Period to analyze - week | MCPERIOD | MCS | ||||||
SPBUP | SPBUP | NUMC | 6(0) | Period to analyze - posting period | MCPERIOD | MCS | ||||||
KUNNR | KUNAG | CHAR | 10(0) | KNA1 | Sold-to party | KUNNR | VAG | VP | ||||
VKORG | VKORG | CHAR | 4(0) | TVKO | Sales Organization | VKORG | VKO | V | C_VKORG | VKORG | ||
VTWEG | VTWEG | CHAR | 2(0) | TVTW | Distribution Channel | VTWEG | VTW | V | C_VTWEG | VTWEG | ||
SPART | SPART | CHAR | 2(0) | TSPA | Division | SPART | SPA | V | C_SPART | SPART | ||
MATNR | MATNR | CHAR | 18(0) | MARA | Material Number | MATNR | MAT | MG | S_MAT1 | MATNR | ||
PERIV | PERIV | CHAR | 2(0) | T009 | Fiscal Year Variant | PERIV | SAP | |||||
VWDAT | VWDAT | NUMC | 10(0) | Pointer to administrative data | VWDAT | MCP1 | ||||||
STWAE | WAERS_V | CUKY | 5(0) | * | Statistics currency | WAERS | V | |||||
BASME | MEINS | UNIT | 3(0) | * | Base Unit of Measure | MEINS | MG | |||||
AENETWR | MC_AENETWR | CURR | 19(2) | Net value of incoming orders | WERTV10 | MCS | ||||||
UMNETWR | MC_UMNETWR | CURR | 19(2) | Net value of invoiced sales | WERTV10 | MCS | ||||||
OAUWE | MC_OAUWE | CURR | 19(2) | Open net value of orders | WERTV10 | MCS | ||||||
RENETWR | MC_RENETWR | CURR | 19(2) | Net value of incoming returns | WERTV10 | MCS | ||||||
GUNETWR | MC_GUNETWR | CURR | 19(2) | Net value of credit memos | WERTV10 | MCS | ||||||
AEMENGE | MC_AEMENGE | QUAN | 15(3) | Incoming orders quantity | MENGV15_3 | MCS | ||||||
UMMENGE | MC_UMMENGE | QUAN | 15(3) | Sales quantity | MENGV15_3 | MCS | ||||||
OAUME | MC_OAUME | QUAN | 15(3) | Open orders quantity in base unit of measure | MENGV15_3 | MCS | ||||||
REMENGE | MC_REMENGE | QUAN | 15(3) | Returns Quantity | MENGV15_3 | MCS | ||||||
GUMENGE | MC_GUMENGE | QUAN | 15(3) | Credit memos quantity | MENGV15_3 | MCS | ||||||
ANZAUPOS | MC_ANZAUPO | DEC | 9(0) | Number of order items | MCZAEHLER | MCS | ||||||
ANZREPOS | MC_ANZREPO | DEC | 9(0) | No.of returns items | MCZAEHLER | MCS | ||||||
AEWAVWR | MC_AEWAVWR | CURR | 19(2) | Cost of incoming orders | WERTV10 | MCS | ||||||
UMWAVWR | MC_UMWAVWR | CURR | 19(2) | Cost of invoiced sales | WERTV10 | MCS | ||||||
REWAVWR | MC_REWAVWR | CURR | 19(2) | Incoming returns: cost | WERTV10 | MCS | ||||||
GUWAVWR | MC_GUWAVWR | CURR | 19(2) | Credit memos: cost | WERTV10 | MCS | ||||||
AEKZWI1 | MC_AEKZWI1 | CURR | 17(2) | Incoming orders: gross | WERTV9 | MCS | ||||||
UMKZWI1 | MC_UMKZWI1 | CURR | 17(2) | Invoiced sales: gross | WERTV9 | MCS | ||||||
REKZWI1 | MC_REKZWI1 | CURR | 17(2) | Incoming returns: gross | WERTV9 | MCS | ||||||
GUKZWI1 | MC_GUKZWI1 | CURR | 17(2) | Credit memos: gross | WERTV9 | MCS | ||||||
AEKZWI2 | MC_AEKZWI2 | CURR | 17(2) | Incoming orders: net 1 | WERTV9 | MCS | ||||||
UMKZWI2 | MC_UMKZWI2 | CURR | 17(2) | Invoiced sales: net 1 | WERTV9 | MCS | ||||||
REKZWI2 | MC_REKZWI2 | CURR | 17(2) | Incoming returns: net 1 | WERTV9 | MCS | ||||||
GUKZWI2 | MC_GUKZWI2 | CURR | 17(2) | Credit memos: net 1 | WERTV9 | MCS | ||||||
AEKZWI3 | MC_AEKZWI3 | CURR | 17(2) | Incoming orders: net 2 | WERTV9 | MCS | ||||||
UMKZWI3 | MC_UMKZWI3 | CURR | 17(2) | Invoiced sales: net 2 | WERTV9 | MCS | ||||||
REKZWI3 | MC_REKZWI3 | CURR | 17(2) | Incoming returns: net 2 | WERTV9 | MCS | ||||||
GUKZWI3 | MC_GUKZWI3 | CURR | 17(2) | Credit memos: net 2 | WERTV9 | MCS | ||||||
AEKZWI4 | MC_AEKZWI4 | CURR | 17(2) | Incoming orders: freight | WERTV9 | MCS | ||||||
UMKZWI4 | MC_UMKZWI4 | CURR | 17(2) | Invoice freight charges | WERTV9 | MCS | ||||||
REKZWI4 | MC_REKZWI4 | CURR | 17(2) | Incoming returns: freight | WERTV9 | MCS | ||||||
GUKZWI4 | MC_GUKZWI4 | CURR | 17(2) | Credit memos: freight | WERTV9 | MCS | ||||||
AEKZWI5 | MC_AEKZWI5 | CURR | 17(2) | Incoming orders: pricing subtotal 5 | WERTV9 | MCS | ||||||
UMKZWI5 | MC_UMKZWI5 | CURR | 17(2) | Billing document: pricing subtotal 5 | WERTV9 | MCS | ||||||
REKZWI5 | MC_REKZWI5 | CURR | 17(2) | Incoming returns: pricing subtotal 5 | WERTV9 | MCS | ||||||
GUKZWI5 | MC_GUKZWI5 | CURR | 17(2) | Credit memos: pricing subtotal 5 | WERTV9 | MCS | ||||||
AEKZWI6 | MC_AEKZWI6 | CURR | 17(2) | Incoming orders: pricing subtotal 6 | WERTV9 | MCS | ||||||
UMKZWI6 | MC_UMKZWI6 | CURR | 17(2) | Billing document: pricing subtotal 6 | WERTV9 | MCS | ||||||
REKZWI6 | MC_REKZWI6 | CURR | 17(2) | Incoming returns: pricing subtotal 6 | WERTV9 | MCS | ||||||
GUKZWI6 | MC_GUKZWI6 | CURR | 17(2) | Credit memos: pricing subtotal 6 | WERTV9 | MCS |