SAP TABLES | Logistics - General | Logistics Information System (LIS) | Data Collection(LO-LIS-DC) SAP LO

S002 SAP SIS: Sales Office Statistics Table and data

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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP S002 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Cannot Be Enhanced
See here for more information about this and other SAP enhancement categories

SAP S002 Table fields within data Dictionary

FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
SSOURSSOURCHAR4 Statistic(s) origin
Version number in the information structure
SPMONSPMONNUMC6 Period to analyze - monthPERI
SPTAGSPTAGDATS8 Period to analyze - current date
SPWOCSPWOCNUMC6 Period to analyze - weekPERI
SPBUPSPBUPNUMC6 Period to analyze - posting periodPERI
VTWEGVTWEGCHAR2 TVTWDistribution Channel
PERIVPERIVCHAR2 T009Fiscal Year Variant
VWDATVWDATNUMC10 Pointer to administrative data
Statistics currency
AENETWRMC_AENETWRCURR19(2) Net value of incoming orders
RENETWRMC_RENETWRCURR19(2) Net value of incoming returns
OAUWEMC_OAUWECURR19(2) Open net value of orders
UMNETWRMC_UMNETWRCURR19(2) Net value of invoiced sales
GUNETWRMC_GUNETWRCURR19(2) Net value of credit memos
AEKZWI1MC_AEKZWI1CURR17(2) Incoming orders: gross
AEKZWI2MC_AEKZWI2CURR17(2) Incoming orders: net 1
AEKZWI3MC_AEKZWI3CURR17(2) Incoming orders: net 2
AEKZWI4MC_AEKZWI4CURR17(2) Incoming orders: freight
AEKZWI5MC_AEKZWI5CURR17(2) Incoming orders: pricing subtotal 5
AEKZWI6MC_AEKZWI6CURR17(2) Incoming orders: pricing subtotal 6
REKZWI1MC_REKZWI1CURR17(2) Incoming returns: gross
REKZWI2MC_REKZWI2CURR17(2) Incoming returns: net 1
REKZWI3MC_REKZWI3CURR17(2) Incoming returns: net 2
REKZWI4MC_REKZWI4CURR17(2) Incoming returns: freight
REKZWI5MC_REKZWI5CURR17(2) Incoming returns: pricing subtotal 5
REKZWI6MC_REKZWI6CURR17(2) Incoming returns: pricing subtotal 6
UMKZWI1MC_UMKZWI1CURR17(2) Invoiced sales: gross
UMKZWI2MC_UMKZWI2CURR17(2) Invoiced sales: net 1
UMKZWI3MC_UMKZWI3CURR17(2) Invoiced sales: net 2
UMKZWI4MC_UMKZWI4CURR17(2) Invoice freight charges
UMKZWI5MC_UMKZWI5CURR17(2) Billing document: pricing subtotal 5
UMKZWI6MC_UMKZWI6CURR17(2) Billing document: pricing subtotal 6
GUKZWI1MC_GUKZWI1CURR17(2) Credit memos: gross

GUKZWI2MC_GUKZWI2CURR17(2) Credit memos: net 1
GUKZWI3MC_GUKZWI3CURR17(2) Credit memos: net 2
GUKZWI4MC_GUKZWI4CURR17(2) Credit memos: freight
GUKZWI5MC_GUKZWI5CURR17(2) Credit memos: pricing subtotal 5
GUKZWI6MC_GUKZWI6CURR17(2) Credit memos: pricing subtotal 6
ANZAUMC_ANZAUDEC9 Number of orders
ANZREMC_ANZREDEC9 Number of returns/credit memo requests
AEWAVWRMC_AEWAVWRCURR19(2) Cost of incoming orders
REWAVWRMC_REWAVWRCURR19(2) Incoming returns: cost
UMWAVWRMC_UMWAVWRCURR19(2) Cost of invoiced sales
GUWAVWRMC_GUWAVWRCURR19(2) Credit memos: cost

Key field
Non-key field