S002BIW1 - S002BIW1 * SIS: Sales office statistics
S002BIW1 * SIS: Sales office statistics information is stored in SAP table S002BIW1.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S002BIW1
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 6 | |
| VKORG | Sales Organization | X | VKORG | CHAR | 4 | TVKO |
| VKGRP | Sales group | X | VKGRP | CHAR | 3 | TVKGR |
| VKBUR | Sales office | X | VKBUR | CHAR | 4 | TVBUR |
| VTWEG | Distribution Channel | X | VTWEG | CHAR | 2 | TVTW |
| SPART | Division | X | SPART | CHAR | 2 | TSPA |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 3 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 6 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 8 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 6 | |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 4 | |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| STWAE | Statistics currency | WAERS_V | CUKY | 5 | * | |
| AENETWR | Net Value of Incoming Orders | MC_AENETWR | CURR | 10 | ||
| RENETWR | Net Value of Incoming Returns | MC_RENETWR | CURR | 10 | ||
| OAUWE | Net Value of Open Orders | MC_OAUWE | CURR | 10 | ||
| UMNETWR | Net Value of Invoiced Sales | MC_UMNETWR | CURR | 10 | ||
| GUNETWR | Net Value of Credit Memos | MC_GUNETWR | CURR | 10 | ||
| AEKZWI1 | Incoming orders: gross | MC_AEKZWI1 | CURR | 9 | ||
| AEKZWI2 | Incoming orders: net 1 | MC_AEKZWI2 | CURR | 9 | ||
| AEKZWI3 | Incoming orders: net 2 | MC_AEKZWI3 | CURR | 9 | ||
| AEKZWI4 | Incoming orders: freight | MC_AEKZWI4 | CURR | 9 | ||
| AEKZWI5 | Incoming orders: pricing subtotal 5 | MC_AEKZWI5 | CURR | 9 | ||
| AEKZWI6 | Incoming orders: pricing subtotal 6 | MC_AEKZWI6 | CURR | 9 | ||
| REKZWI1 | Incoming returns: gross | MC_REKZWI1 | CURR | 9 | ||
| REKZWI2 | Incoming returns: net 1 | MC_REKZWI2 | CURR | 9 | ||
| REKZWI3 | Incoming returns: net 2 | MC_REKZWI3 | CURR | 9 | ||
| REKZWI4 | Incoming returns: freight | MC_REKZWI4 | CURR | 9 | ||
| REKZWI5 | Incoming returns: pricing subtotal 5 | MC_REKZWI5 | CURR | 9 | ||
| REKZWI6 | Incoming returns: pricing subtotal 6 | MC_REKZWI6 | CURR | 9 | ||
| UMKZWI1 | Invoiced sales: gross | MC_UMKZWI1 | CURR | 9 | ||
| UMKZWI2 | Invoiced sales: net 1 | MC_UMKZWI2 | CURR | 9 | ||
| UMKZWI3 | Invoiced sales: net 2 | MC_UMKZWI3 | CURR | 9 | ||
| UMKZWI4 | Invoice freight charges | MC_UMKZWI4 | CURR | 9 | ||
| UMKZWI5 | Billing document: pricing subtotal 5 | MC_UMKZWI5 | CURR | 9 | ||
| UMKZWI6 | Billing document: pricing subtotal 6 | MC_UMKZWI6 | CURR | 9 | ||
| GUKZWI1 | Credit memos: gross | MC_GUKZWI1 | CURR | 9 | ||
| GUKZWI2 | Credit memos: net 1 | MC_GUKZWI2 | CURR | 9 | ||
| GUKZWI3 | Credit memos: net 2 | MC_GUKZWI3 | CURR | 9 | ||
| GUKZWI4 | Credit memos: freight | MC_GUKZWI4 | CURR | 9 | ||
| GUKZWI5 | Credit memos: pricing subtotal 5 | MC_GUKZWI5 | CURR | 9 | ||
| GUKZWI6 | Credit memos: pricing subtotal 6 | MC_GUKZWI6 | CURR | 9 | ||
| ANZAU | Number of Orders | MC_ANZAU | DEC | 5 | ||
| ANZRE | Number of returns/credit memo requests | MC_ANZRE | DEC | 5 | ||
| AEWAVWR | Cost of incoming orders | MC_AEWAVWR | CURR | 10 | ||
| REWAVWR | Incoming returns: cost | MC_REWAVWR | CURR | 10 | ||
| UMWAVWR | Cost of invoiced sales | MC_UMWAVWR | CURR | 10 | ||
| GUWAVWR | Credit memos: cost | MC_GUWAVWR | CURR | 10 |