SAP Table S001BIWS stores S001BIWS * SIS: Customer statisticsdata

  

In this post, I will try and describe everything you need to know about the SAP s001biws 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 S001BIWS 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 S001BIWS....Right lets get started!


SAP S001BIWS dictionary attributes

Object Name: S001BIWS
Dictionary Type: Structure
Description: S001BIWS * SIS: Customer statistics


S001BIWS field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
STORNOSTORNOCHAR1(0) Indicator: Data to Be CanceledCHAR1_X
WRTTPRSVTYPENUMC3(0) *Value type for ReportingRSVTYPE
VRSIOVRSIOCHAR3(0) *Version number in the information structureVRSIOMCVMCP1
SPMONRSCALMONTHNUMC6(0) Calendar year / monthRSCALMONTH
SPTAGRSCALDAYDATS8(0) Calendar dayDATUM
SPWOCRSCALWEEKNUMC6(0) Calendar year / weekRSCALWEEK
SPBUPRSFISCPERNUMC7(0) Fiscal year / periodRSFISCPER
KUNNRKUNAGCHAR10(0) *Sold-to partyKUNNRVAGVP
VKORGVKORGCHAR4(0) *Sales OrganizationVKORGVKOVC_VKORGVKORG
VTWEGVTWEGCHAR2(0) *Distribution ChannelVTWEGVTWVC_VTWEGVTWEG
SPARTSPARTCHAR2(0) *DivisionSPARTSPAVC_SPARTSPART
MATNRMATNRCHAR18(0) *Material NumberMATNRMATMGS_MAT1MATNR
PERIVPERIVCHAR2(0) *Fiscal Year VariantPERIVSAP
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