S002 SAP (SIS: Sales Office Statistics) Table details

Dictionary Type: Table
Description: SIS: Sales Office Statistics




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




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

S002 is a standard SAP Table which is used to store SIS: Sales Office Statistics data and is available within R/3 SAP systems depending on the version and release level.

The S002 table consists of various fields, each holding specific information or linking keys about SIS: Sales Office Statistics 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 S002 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
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VKGRPSales Group VKGRPCHAR3TVKGRVKGRPVKG
VKBURSales Office VKBURCHAR4TVBURVKBURVKB
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
STWAEStatistics currency WAERS_VCUKY5Assigned to domainWAERS
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
ANZAUNumber of orders MC_ANZAUDEC9MCZAEHLER
ANZRENumber of returns/credit memo requests MC_ANZREDEC9MCZAEHLER
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 S002 using ABAP code

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

SELECT SINGLE *
FROM S002
INTO CORRESPONDING FIELDS OF WA_S002
WHERE...

How to access SAP table S002

Within an ECC or HANA version of SAP you can also view further information about S002 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!