SAP Table S006
SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product
S006 (SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product) 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 S006 to other SAP tables.
S006 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 | |||
| VRTNR | Sales employee | VRTNR | NUMC | 8 | 0 | |||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||
| KUNNR | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 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 | TCURC | CUKY | 5 | 0 | ||
| BASME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||
| AENETWR | Net value of incoming orders | MC_AENETWR | CURR | 19 | 2 | |||
| RENETWR | Net value of incoming returns | MC_RENETWR | CURR | 19 | 2 | |||
| UMNETWR | Net value of invoiced sales | MC_UMNETWR | CURR | 19 | 2 | |||
| GUNETWR | Net value of credit memos | MC_GUNETWR | CURR | 19 | 2 | |||
| AEKZWI1 | Incoming orders: gross | MC_AEKZWI1 | CURR | 17 | 2 | |||
| AEKZWI2 | Incoming orders: net 1 | MC_AEKZWI2 | CURR | 17 | 2 | |||
| AEKZWI3 | Incoming orders: net 2 | MC_AEKZWI3 | CURR | 17 | 2 | |||
| AEKZWI4 | Incoming orders: freight | MC_AEKZWI4 | CURR | 17 | 2 | |||
| AEKZWI5 | Incoming orders: pricing subtotal 5 | MC_AEKZWI5 | CURR | 17 | 2 | |||
| AEKZWI6 | Incoming orders: pricing subtotal 6 | MC_AEKZWI6 | CURR | 17 | 2 | |||
| REKZWI1 | Incoming returns: gross | MC_REKZWI1 | CURR | 17 | 2 | |||
| REKZWI2 | Incoming returns: net 1 | MC_REKZWI2 | CURR | 17 | 2 | |||
| REKZWI3 | Incoming returns: net 2 | MC_REKZWI3 | CURR | 17 | 2 | |||
| REKZWI4 | Incoming returns: freight | MC_REKZWI4 | CURR | 17 | 2 | |||
| REKZWI5 | Incoming returns: pricing subtotal 5 | MC_REKZWI5 | CURR | 17 | 2 | |||
| REKZWI6 | Incoming returns: pricing subtotal 6 | MC_REKZWI6 | CURR | 17 | 2 | |||
| UMKZWI1 | Invoiced sales: gross | MC_UMKZWI1 | CURR | 17 | 2 | |||
| UMKZWI2 | Invoiced sales: net 1 | MC_UMKZWI2 | CURR | 17 | 2 | |||
| UMKZWI3 | Invoiced sales: net 2 | MC_UMKZWI3 | CURR | 17 | 2 | |||
| UMKZWI4 | Invoice freight charges | MC_UMKZWI4 | CURR | 17 | 2 | |||
| UMKZWI5 | Billing document: pricing subtotal 5 | MC_UMKZWI5 | CURR | 17 | 2 | |||
| UMKZWI6 | Billing document: pricing subtotal 6 | MC_UMKZWI6 | CURR | 17 | 2 | |||
| GUKZWI1 | Credit memos: gross | MC_GUKZWI1 | CURR | 17 | 2 | |||
| GUKZWI2 | Credit memos: net 1 | MC_GUKZWI2 | CURR | 17 | 2 | |||
| GUKZWI3 | Credit memos: net 2 | MC_GUKZWI3 | CURR | 17 | 2 | |||
| GUKZWI4 | Credit memos: freight | MC_GUKZWI4 | CURR | 17 | 2 | |||
| GUKZWI5 | Credit memos: pricing subtotal 5 | MC_GUKZWI5 | CURR | 17 | 2 | |||
| GUKZWI6 | Credit memos: pricing subtotal 6 | MC_GUKZWI6 | CURR | 17 | 2 | |||
| ANZAUPOS | Number of order items | MC_ANZAUPO | DEC | 9 | 0 | |||
| ANZREPOS | No.of returns items | MC_ANZREPO | DEC | 9 | 0 | |||
| AEMENGE | Incoming orders quantity | MC_AEMENGE | QUAN | 15 | 3 | |||
| REMENGE | Returns Quantity | MC_REMENGE | QUAN | 15 | 3 | |||
| UMMENGE | Sales quantity | MC_UMMENGE | QUAN | 15 | 3 | |||
| GUMENGE | Credit memos quantity | MC_GUMENGE | QUAN | 15 | 3 | |||
| AEWAVWR | Cost of incoming orders | MC_AEWAVWR | CURR | 19 | 2 | |||
| REWAVWR | Incoming returns: cost | MC_REWAVWR | CURR | 19 | 2 | |||
| UMWAVWR | Cost of invoiced sales | MC_UMWAVWR | CURR | 19 | 2 | |||
| GUWAVWR | Credit memos: cost | MC_GUWAVWR | CURR | 19 | 2 | |||
S006 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S006 | BASME | S006 | MANDT | T006 | Units of Measurement | MANDT |
| S006 | BASME | S006 | BASME | T006 | Units of Measurement | MSEHI |
| S006 | KUNNR | S006 | MANDT | KNA1 | General Data in Customer Master | MANDT |
| S006 | KUNNR | S006 | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| S006 | MANDT | S006 | MANDT | T000 | Clients | MANDT |
| S006 | MATNR | S006 | MANDT | MARA | General Material Data | MANDT |
| S006 | MATNR | S006 | MATNR | MARA | General Material Data | MATNR |
| S006 | PERIV | S006 | PERIV | T009 | Fiscal Year Variants | PERIV |
| S006 | PERIV | S006 | MANDT | T009 | Fiscal Year Variants | MANDT |
| S006 | SPART | S006 | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| S006 | SPART | S006 | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| S006 | STWAE | S006 | MANDT | TCURC | Currency Codes | MANDT |
| S006 | STWAE | S006 | STWAE | TCURC | Currency Codes | WAERS |
| S006 | VKORG | S006 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| S006 | VKORG | S006 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| S006 | VTWEG | S006 | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| S006 | VTWEG | S006 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
