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

S004 SAP SIS: Product/Sales Organization/Distribution Channel Table and data







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.

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 S004 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 S004 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
SSOURSSOURCHAR4 Statistic(s) origin
VRSIOVRSIOCHAR3
*
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
MATNRMATNRCHAR18 MARAMaterial NumberMATN1
VKORGVKORGCHAR4 TVKOSales Organization
VTWEGVTWEGCHAR2 TVTWDistribution Channel
PERIVPERIVCHAR2 T009Fiscal Year Variant
VWDATVWDATNUMC10 Pointer to administrative data
STWAEWAERS_VCUKY5 TCURCStatistics currency
BASMEMEINSUNIT3 T006Base Unit of MeasureCUNIT
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
ANZAUPOSMC_ANZAUPODEC9 Number of order items
ANZREPOSMC_ANZREPODEC9 No.of returns items
AEMENGEMC_AEMENGEQUAN15(3) Incoming orders quantity
REMENGEMC_REMENGEQUAN15(3) Returns Quantity
OAUMEMC_OAUMEQUAN15(3) Open orders quantity in base unit of measure
UMMENGEMC_UMMENGEQUAN15(3) Sales quantity
GUMENGEMC_GUMENGEQUAN15(3) Credit memos quantity
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