SAP Table S004
SIS: Product/Sales Organization/Distribution Channel
S004 (SIS: Product/Sales Organization/Distribution Channel) 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 S004 to other SAP tables.
S004 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
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 | ||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |
|
VTWEG
Distribution Channel
|
VTWEG | TVTW |
CHAR
|
2 | 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 | ||
|
OAUWE
Open net value of orders
|
MC_OAUWE |
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 | ||
|
OAUME
Open orders quantity in base unit of measure
|
MC_OAUME |
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 |
S004 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| S004 | BASME | S004 | MANDT |
T006
Units of Measurement
|
MANDT |
| S004 | BASME | S004 | BASME |
T006
Units of Measurement
|
MSEHI |
| S004 | MANDT | S004 | MANDT |
T000
Clients
|
MANDT |
| S004 | MATNR | S004 | MANDT |
MARA
General Material Data
|
MANDT |
| S004 | MATNR | S004 | MATNR |
MARA
General Material Data
|
MATNR |
| S004 | PERIV | S004 | PERIV |
T009
Fiscal Year Variants
|
PERIV |
| S004 | PERIV | S004 | MANDT |
T009
Fiscal Year Variants
|
MANDT |
| S004 | STWAE | S004 | MANDT |
TCURC
Currency Codes
|
MANDT |
| S004 | STWAE | S004 | STWAE |
TCURC
Currency Codes
|
WAERS |
| S004 | VKORG | S004 | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| S004 | VKORG | S004 | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| S004 | VTWEG | S004 | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| S004 | VTWEG | S004 | VTWEG |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |