SAP table S004 (SIS: Product/Sales Organization/Distribution Channel)
SAP table S004 has 10 primary key fields being MANDT,SSOUR,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,MATNR,VKORG,VTWEG.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SSOUR | Statistic(s) origin | CHAR | 4 | 0 | SSOUR | ||
| VRSIO | Version number in the information structure | CHAR | 3 | 0 | * | VRSIO | |
| SPMON | Period to analyze - month | NUMC | 6 | 0 | SPMON | ||
| SPTAG | Period to analyze - current date | DATS | 8 | 0 | SPTAG | ||
| SPWOC | Period to analyze - week | NUMC | 6 | 0 | SPWOC | ||
| SPBUP | Period to analyze - posting period | NUMC | 6 | 0 | SPBUP | ||
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |
| VTWEG | Distribution Channel | CHAR | 2 | 0 | TVTW | VTWEG | |
| PERIV | Fiscal Year Variant | CHAR | 2 | 0 | T009 | PERIV | |
| VWDAT | Pointer to administrative data | NUMC | 10 | 0 | VWDAT | ||
| STWAE | Statistics currency | CUKY | 5 | 0 | TCURC | WAERS_V | |
| BASME | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |
| AENETWR | Net Value of Incoming Orders | CURR | 19 | 2 | MC_AENETWR | ||
| RENETWR | Net Value of Incoming Returns | CURR | 19 | 2 | MC_RENETWR | ||
| OAUWE | Net Value of Open Orders | CURR | 19 | 2 | MC_OAUWE | ||
| UMNETWR | Net Value of Invoiced Sales | CURR | 19 | 2 | MC_UMNETWR | ||
| GUNETWR | Net Value of Credit Memos | CURR | 19 | 2 | MC_GUNETWR | ||
| AEKZWI1 | Incoming orders: gross | CURR | 17 | 2 | MC_AEKZWI1 | ||
| AEKZWI2 | Incoming orders: net 1 | CURR | 17 | 2 | MC_AEKZWI2 | ||
| AEKZWI3 | Incoming orders: net 2 | CURR | 17 | 2 | MC_AEKZWI3 | ||
| AEKZWI4 | Incoming orders: freight | CURR | 17 | 2 | MC_AEKZWI4 | ||
| AEKZWI5 | Incoming orders: pricing subtotal 5 | CURR | 17 | 2 | MC_AEKZWI5 | ||
| AEKZWI6 | Incoming orders: pricing subtotal 6 | CURR | 17 | 2 | MC_AEKZWI6 | ||
| REKZWI1 | Incoming returns: gross | CURR | 17 | 2 | MC_REKZWI1 | ||
| REKZWI2 | Incoming returns: net 1 | CURR | 17 | 2 | MC_REKZWI2 | ||
| REKZWI3 | Incoming returns: net 2 | CURR | 17 | 2 | MC_REKZWI3 | ||
| REKZWI4 | Incoming returns: freight | CURR | 17 | 2 | MC_REKZWI4 | ||
| REKZWI5 | Incoming returns: pricing subtotal 5 | CURR | 17 | 2 | MC_REKZWI5 | ||
| REKZWI6 | Incoming returns: pricing subtotal 6 | CURR | 17 | 2 | MC_REKZWI6 | ||
| UMKZWI1 | Invoiced sales: gross | CURR | 17 | 2 | MC_UMKZWI1 | ||
| UMKZWI2 | Invoiced sales: net 1 | CURR | 17 | 2 | MC_UMKZWI2 | ||
| UMKZWI3 | Invoiced sales: net 2 | CURR | 17 | 2 | MC_UMKZWI3 | ||
| UMKZWI4 | Invoice freight charges | CURR | 17 | 2 | MC_UMKZWI4 | ||
| UMKZWI5 | Billing document: pricing subtotal 5 | CURR | 17 | 2 | MC_UMKZWI5 | ||
| UMKZWI6 | Billing document: pricing subtotal 6 | CURR | 17 | 2 | MC_UMKZWI6 | ||
| GUKZWI1 | Credit memos: gross | CURR | 17 | 2 | MC_GUKZWI1 | ||
| GUKZWI2 | Credit memos: net 1 | CURR | 17 | 2 | MC_GUKZWI2 | ||
| GUKZWI3 | Credit memos: net 2 | CURR | 17 | 2 | MC_GUKZWI3 | ||
| GUKZWI4 | Credit memos: freight | CURR | 17 | 2 | MC_GUKZWI4 | ||
| GUKZWI5 | Credit memos: pricing subtotal 5 | CURR | 17 | 2 | MC_GUKZWI5 | ||
| GUKZWI6 | Credit memos: pricing subtotal 6 | CURR | 17 | 2 | MC_GUKZWI6 | ||
| ANZAUPOS | Number of Order Items | DEC | 9 | 0 | MC_ANZAUPO | ||
| ANZREPOS | No.of returns items | DEC | 9 | 0 | MC_ANZREPO | ||
| AEMENGE | Incoming Orders Quantity | QUAN | 15 | 3 | MC_AEMENGE | ||
| REMENGE | Quantity of Returns | QUAN | 15 | 3 | MC_REMENGE | ||
| OAUME | Open orders quantity in base unit of measure | QUAN | 15 | 3 | MC_OAUME | ||
| UMMENGE | Sales Volume Quantity | QUAN | 15 | 3 | MC_UMMENGE | ||
| GUMENGE | Quantity of Credit Memos | QUAN | 15 | 3 | MC_GUMENGE | ||
| AEWAVWR | Cost of incoming orders | CURR | 19 | 2 | MC_AEWAVWR | ||
| REWAVWR | Incoming returns: cost | CURR | 19 | 2 | MC_REWAVWR | ||
| UMWAVWR | Cost of invoiced sales | CURR | 19 | 2 | MC_UMWAVWR | ||
| GUWAVWR | Credit memos: cost | CURR | 19 | 2 | MC_GUWAVWR |
S004 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 S004 | BASME | T006 | Units of Measurement | MANDT |
| 1 S004 | MATNR | MARA | General Material Data | MANDT |
| 1 S004 | MATNR | MARA | General Material Data | MATNR |
| 0 S004 | PERIV | T009 | Fiscal Year Variants | MANDT |
| 0 S004 | PERIV | T009 | Fiscal Year Variants | PERIV |
| 1 S004 | STWAE | TCURC | Currency Codes | MANDT |
| 1 S004 | STWAE | TCURC | Currency Codes | WAERS |
| 0 S004 | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| 0 S004 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| 1 S004 | VTWEG | TVTW | Organizational Unit: Distribution Channels | MANDT |
| 1 S004 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |