SAP Table S001 stores SIS: Customer Statisticsdata

  

In this post, I will try and describe everything you need to know about the SAP s001 table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for S001 what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from S001....Right lets get started!


SAP S001 dictionary attributes

Object Name: S001
Dictionary Type: Transparent table
Description: SIS: Customer Statistics


S001 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
SSOURSSOURCHAR4(0) Statistic(s) originSSOURMCP1
VRSIOVRSIOCHAR3(0) *Version number in the information structureVRSIOMCVMCP1
SPMONSPMONNUMC6(0) Period to analyze - monthMCPERIODMCS
SPTAGSPTAGDATS8(0) Period to analyze - current dateDATUMMCS
SPWOCSPWOCNUMC6(0) Period to analyze - weekMCPERIODMCS
SPBUPSPBUPNUMC6(0) Period to analyze - posting periodMCPERIODMCS
KUNNRKUNAGCHAR10(0) KNA1Sold-to partyKUNNRVAGVP
VKORGVKORGCHAR4(0) TVKOSales OrganizationVKORGVKOVC_VKORGVKORG
VTWEGVTWEGCHAR2(0) TVTWDistribution ChannelVTWEGVTWVC_VTWEGVTWEG
SPARTSPARTCHAR2(0) TSPADivisionSPARTSPAVC_SPARTSPART
MATNRMATNRCHAR18(0) MARAMaterial NumberMATNRMATMGS_MAT1MATNR
PERIVPERIVCHAR2(0) T009Fiscal Year VariantPERIVSAP
VWDATVWDATNUMC10(0) Pointer to administrative dataVWDATMCP1
STWAEWAERS_VCUKY5(0) *Statistics currencyWAERSV
BASMEMEINSUNIT3(0) *Base Unit of MeasureMEINSMG
AENETWRMC_AENETWRCURR19(2) Net value of incoming ordersWERTV10MCS
UMNETWRMC_UMNETWRCURR19(2) Net value of invoiced salesWERTV10MCS
OAUWEMC_OAUWECURR19(2) Open net value of ordersWERTV10MCS
RENETWRMC_RENETWRCURR19(2) Net value of incoming returnsWERTV10MCS
GUNETWRMC_GUNETWRCURR19(2) Net value of credit memosWERTV10MCS
AEMENGEMC_AEMENGEQUAN15(3) Incoming orders quantityMENGV15_3MCS
UMMENGEMC_UMMENGEQUAN15(3) Sales quantityMENGV15_3MCS
OAUMEMC_OAUMEQUAN15(3) Open orders quantity in base unit of measureMENGV15_3MCS
REMENGEMC_REMENGEQUAN15(3) Returns QuantityMENGV15_3MCS
GUMENGEMC_GUMENGEQUAN15(3) Credit memos quantityMENGV15_3MCS
ANZAUPOSMC_ANZAUPODEC9(0) Number of order itemsMCZAEHLERMCS
ANZREPOSMC_ANZREPODEC9(0) No.of returns itemsMCZAEHLERMCS
AEWAVWRMC_AEWAVWRCURR19(2) Cost of incoming ordersWERTV10MCS
UMWAVWRMC_UMWAVWRCURR19(2) Cost of invoiced salesWERTV10MCS
REWAVWRMC_REWAVWRCURR19(2) Incoming returns: costWERTV10MCS
GUWAVWRMC_GUWAVWRCURR19(2) Credit memos: costWERTV10MCS
AEKZWI1MC_AEKZWI1CURR17(2) Incoming orders: grossWERTV9MCS
UMKZWI1MC_UMKZWI1CURR17(2) Invoiced sales: grossWERTV9MCS
REKZWI1MC_REKZWI1CURR17(2) Incoming returns: grossWERTV9MCS
GUKZWI1MC_GUKZWI1CURR17(2) Credit memos: grossWERTV9MCS
AEKZWI2MC_AEKZWI2CURR17(2) Incoming orders: net 1WERTV9MCS
UMKZWI2MC_UMKZWI2CURR17(2) Invoiced sales: net 1WERTV9MCS
REKZWI2MC_REKZWI2CURR17(2) Incoming returns: net 1WERTV9MCS
GUKZWI2MC_GUKZWI2CURR17(2) Credit memos: net 1WERTV9MCS
AEKZWI3MC_AEKZWI3CURR17(2) Incoming orders: net 2WERTV9MCS
UMKZWI3MC_UMKZWI3CURR17(2) Invoiced sales: net 2WERTV9MCS
REKZWI3MC_REKZWI3CURR17(2) Incoming returns: net 2WERTV9MCS
GUKZWI3MC_GUKZWI3CURR17(2) Credit memos: net 2WERTV9MCS
AEKZWI4MC_AEKZWI4CURR17(2) Incoming orders: freightWERTV9MCS
UMKZWI4MC_UMKZWI4CURR17(2) Invoice freight chargesWERTV9MCS
REKZWI4MC_REKZWI4CURR17(2) Incoming returns: freightWERTV9MCS
GUKZWI4MC_GUKZWI4CURR17(2) Credit memos: freightWERTV9MCS
AEKZWI5MC_AEKZWI5CURR17(2) Incoming orders: pricing subtotal 5WERTV9MCS
UMKZWI5MC_UMKZWI5CURR17(2) Billing document: pricing subtotal 5WERTV9MCS
REKZWI5MC_REKZWI5CURR17(2) Incoming returns: pricing subtotal 5WERTV9MCS
GUKZWI5MC_GUKZWI5CURR17(2) Credit memos: pricing subtotal 5WERTV9MCS
AEKZWI6MC_AEKZWI6CURR17(2) Incoming orders: pricing subtotal 6WERTV9MCS
UMKZWI6MC_UMKZWI6CURR17(2) Billing document: pricing subtotal 6WERTV9MCS
REKZWI6MC_REKZWI6CURR17(2) Incoming returns: pricing subtotal 6WERTV9MCS
GUKZWI6MC_GUKZWI6CURR17(2) Credit memos: pricing subtotal 6WERTV9MCS