In this post, I will try and describe everything you need to know about the SAP s001biws 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 S001BIWS 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 S001BIWS....Right lets get started!
Object Name: S001BIWS
Dictionary Type: Structure
Description: S001BIWS * SIS: Customer statistics
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| STORNO | STORNO | CHAR | 1(0) | Indicator: Data to Be Canceled | CHAR1_X | |||||||
| WRTTP | RSVTYPE | NUMC | 3(0) | * | Value type for Reporting | RSVTYPE | ||||||
| VRSIO | VRSIO | CHAR | 3(0) | * | Version number in the information structure | VRSIO | MCV | MCP1 | ||||
| SPMON | RSCALMONTH | NUMC | 6(0) | Calendar year / month | RSCALMONTH | |||||||
| SPTAG | RSCALDAY | DATS | 8(0) | Calendar day | DATUM | |||||||
| SPWOC | RSCALWEEK | NUMC | 6(0) | Calendar year / week | RSCALWEEK | |||||||
| SPBUP | RSFISCPER | NUMC | 7(0) | Fiscal year / period | RSFISCPER | |||||||
| KUNNR | KUNAG | CHAR | 10(0) | * | Sold-to party | KUNNR | VAG | VP | ||||
| VKORG | VKORG | CHAR | 4(0) | * | Sales Organization | VKORG | VKO | V | C_VKORG | VKORG | ||
| VTWEG | VTWEG | CHAR | 2(0) | * | Distribution Channel | VTWEG | VTW | V | C_VTWEG | VTWEG | ||
| SPART | SPART | CHAR | 2(0) | * | Division | SPART | SPA | V | C_SPART | SPART | ||
| MATNR | MATNR | CHAR | 18(0) | * | Material Number | MATNR | MAT | MG | S_MAT1 | MATNR | ||
| PERIV | PERIV | CHAR | 2(0) | * | Fiscal Year Variant | PERIV | SAP | |||||
| 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 |