S004 SAP (SIS: Product/Sales Organization/Distribution Channel) Table details

Dictionary Type: Table
Description: SIS: Product/Sales Organization/Distribution Channel




ABAP Code to SELECT data from S004
Related tables to S004
Access table S004




Table field list including key, data, relationships and ABAP select examples

S004 is a standard SAP Table which is used to store SIS: Product/Sales Organization/Distribution Channel data and is available within R/3 SAP systems depending on the version and release level.

The S004 table consists of various fields, each holding specific information or linking keys about SIS: Product/Sales Organization/Distribution Channel data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP S004 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SSOURStatistic(s) origin SSOURCHAR4SSOUR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
STWAEStatistics currency WAERS_VCUKY5TCURCWAERS
BASMEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
AENETWRNet value of incoming orders MC_AENETWRCURR19(2) WERTV10
RENETWRNet value of incoming returns MC_RENETWRCURR19(2) WERTV10
OAUWEOpen net value of orders MC_OAUWECURR19(2) WERTV10
UMNETWRNet value of invoiced sales MC_UMNETWRCURR19(2) WERTV10
GUNETWRNet value of credit memos MC_GUNETWRCURR19(2) WERTV10
AEKZWI1Incoming orders: gross MC_AEKZWI1CURR17(2) WERTV9
AEKZWI2Incoming orders: net 1 MC_AEKZWI2CURR17(2) WERTV9
AEKZWI3Incoming orders: net 2 MC_AEKZWI3CURR17(2) WERTV9
AEKZWI4Incoming orders: freight MC_AEKZWI4CURR17(2) WERTV9
AEKZWI5Incoming orders: pricing subtotal 5 MC_AEKZWI5CURR17(2) WERTV9
AEKZWI6Incoming orders: pricing subtotal 6 MC_AEKZWI6CURR17(2) WERTV9
REKZWI1Incoming returns: gross MC_REKZWI1CURR17(2) WERTV9
REKZWI2Incoming returns: net 1 MC_REKZWI2CURR17(2) WERTV9
REKZWI3Incoming returns: net 2 MC_REKZWI3CURR17(2) WERTV9
REKZWI4Incoming returns: freight MC_REKZWI4CURR17(2) WERTV9
REKZWI5Incoming returns: pricing subtotal 5 MC_REKZWI5CURR17(2) WERTV9
REKZWI6Incoming returns: pricing subtotal 6 MC_REKZWI6CURR17(2) WERTV9
UMKZWI1Invoiced sales: gross MC_UMKZWI1CURR17(2) WERTV9
UMKZWI2Invoiced sales: net 1 MC_UMKZWI2CURR17(2) WERTV9
UMKZWI3Invoiced sales: net 2 MC_UMKZWI3CURR17(2) WERTV9
UMKZWI4Invoice freight charges MC_UMKZWI4CURR17(2) WERTV9
UMKZWI5Billing document: pricing subtotal 5 MC_UMKZWI5CURR17(2) WERTV9
UMKZWI6Billing document: pricing subtotal 6 MC_UMKZWI6CURR17(2) WERTV9
GUKZWI1Credit memos: gross MC_GUKZWI1CURR17(2) WERTV9
GUKZWI2Credit memos: net 1 MC_GUKZWI2CURR17(2) WERTV9
GUKZWI3Credit memos: net 2 MC_GUKZWI3CURR17(2) WERTV9
GUKZWI4Credit memos: freight MC_GUKZWI4CURR17(2) WERTV9
GUKZWI5Credit memos: pricing subtotal 5 MC_GUKZWI5CURR17(2) WERTV9
GUKZWI6Credit memos: pricing subtotal 6 MC_GUKZWI6CURR17(2) WERTV9
ANZAUPOSNumber of order items MC_ANZAUPODEC9MCZAEHLER
ANZREPOSNo.of returns items MC_ANZREPODEC9MCZAEHLER
AEMENGEIncoming orders quantity MC_AEMENGEQUAN15(3) MENGV15_3
REMENGEReturns Quantity MC_REMENGEQUAN15(3) MENGV15_3
OAUMEOpen orders quantity in base unit of measure MC_OAUMEQUAN15(3) MENGV15_3
UMMENGESales quantity MC_UMMENGEQUAN15(3) MENGV15_3
GUMENGECredit memos quantity MC_GUMENGEQUAN15(3) MENGV15_3
AEWAVWRCost of incoming orders MC_AEWAVWRCURR19(2) WERTV10
REWAVWRIncoming returns: cost MC_REWAVWRCURR19(2) WERTV10
UMWAVWRCost of invoiced sales MC_UMWAVWRCURR19(2) WERTV10
GUWAVWRCredit memos: cost MC_GUWAVWRCURR19(2) WERTV10

Key field Non-key field



How do I retrieve data from SAP table S004 using ABAP code

The following ABAP code Example will allow you to do a basic selection on S004 to SELECT all data from the table
DATA: WA_S004 TYPE S004.

SELECT SINGLE *
FROM S004
INTO CORRESPONDING FIELDS OF WA_S004
WHERE...

How to access SAP table S004

Within an ECC or HANA version of SAP you can also view further information about S004 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!