S039 - Statistics: Inventory Controlling

Statistics: Inventory Controlling information is stored in SAP table S039.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".

Fields for table S039

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
VRSIO	Version number in the information structure	X	VRSIO	CHAR	6	*
SPMON	Period to analyze - month	X	SPMON	NUMC	12
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
SPWOC	Period to analyze - week	X	SPWOC	NUMC	12
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	12
WERKS	Plant	X	WERKS_D	CHAR	8	T001W
MATNR	Material Number	X	MATNR	CHAR	80	MARA
LGORT	Storage location	X	LGORT_D	CHAR	8	T001L
DISPO	MRP Controller	X	DISPO	CHAR	6	T024D
DISMM	MRP Type	X	DISMM	CHAR	4	T438A
MTART	Material type	X	MTART	CHAR	8	T134
MATKL	Material Group	X	MATKL	CHAR	18	T023
GSBER	Business Area	X	GSBER	CHAR	8	TGSB
SPART	Division	X	SPART	CHAR	4	TSPA
PERIV	Fiscal Year Variant		PERIV	CHAR	4	T009
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
BASME	Base Unit of Measure		MEINS	UNIT	6	T006
HWAER	Currency Key		WAERS	CUKY	10	TCURC
MZUBB	Valuated stock receipts quantity		MZUBB	QUAN	8
WZUBB	Valuated stock receipts value		WZUBB	CURR	8
AZUBB	Number of times that valuated stock has been received		AZUBB	DEC	5
MZUKB	Consignment stock receipts quantity		MZUKB	QUAN	8
AZUKB	Number of times that consignment stock has been received		AZUKB	DEC	5
MAGBB	Quantity of valuated stock issues		MAGBB	QUAN	8
WAGBB	Value of valuated stock that has been issued		WAGBB	CURR	8
AAGBB	Number of times valuated stock has been issued		AAGBB	DEC	5
MAGKB	Quantity of consignment stock that has been issued		MAGKB	QUAN	8
AAGKB	Number of times consignment stock has been issued		AAGKB	DEC	5
AMBWG	Number of material movements		AMBWG	DEC	5
MGVBR	Total usage quantity		GVBRM	QUAN	8
WGVBR	Total usage value		WGVBR	CURR	8
AGVBR	Number of times that total usage has been updated		AGVBR	DEC	5
MUVBR	Unplanned usage quantity		UVBRM	QUAN	8
WUVBR	Unplanned usage value		WUVBR	CURR	8
AUVBR	Number of times an unplanned usage has been recorded		AUVBR	DEC	5
ASTOR	Number of cancelation documents to date		ASTOR	DEC	5
BBNULL	Number of times that valuated stock was zero		BBNULL	DEC	5
KBNULL	Number of times that consignment stock was zero		KBNULL	DEC	5
GBNULL	Number of times that total stock was zero		GBNULL	DEC	5
.INCLUDE				MCBKENN	0
MBWBEST	Quantity of valuated stock		MBWBEST	QUAN	8
WBWBEST	Value of valuated stock		WBWBEST	CURR	8
MKOBEST	Quantity of consignment stock		MKOBEST	QUAN	8
DZUBB	Average valuated stock receipts quantity		DZUBB	QUAN	8
DZWBB	Average valuated stock receipts value		DZWBB	CURR	8
DAGBB	Average quantity of valuated stock issues		DAGBB	QUAN	8
DAWBB	Average valuated stock issues value		DAWBB	CURR	8
DZUKB	Average consignment stock receipts quantity		DZUKB	QUAN	8
DAGKB	Average quantity of consignment stock that has been issued		DAGKB	QUAN	8
DGVBR	Average consumption		DGVBR	QUAN	8
GSBEST	Total stock		GSBEST	QUAN	8
RWGSBEST	Range of coverage of total stock		RWGSBEST	DEC	4
RWKOBEST	Range of coverage of consignment stock		RWKOBEST	DEC	4
RWBEWBEST	Range of coverage of valuated stock		RWBEWBEST	DEC	4
UHGSBEST	Turnover of total stock		UHGESBEST	DEC	4
UHBWBEST	Turnover of valuated stock		UHBWBEST	DEC	4
UHKOBEST	Turnover of consignment stock		UHKOBEST	DEC	4
DBWBEST	Average quantity of valuated stock		DBWBEST	QUAN	8
DKOBEST	Average quantity of consignment stock		DKOBEST	QUAN	8
DGSBEST	Average quantity of total stock		DGSBEST	QUAN	8
DWBWBEST	Average valuated stock value		DWBWBEST	CURR	8
DRWBWBEST	Average range of coverage of valuated stock		DRWBWBEST	DEC	4
DRWKOBEST	Average range of coverage of consignment stock		DRWKOBEST	DEC	4
DRWGSBEST	Average range of coverage of total stock		DRWGSBEST	DEC	4
DUHBWBEST	Average inventory turnover of valuated stock		DUHBWBEST	DEC	4
DUHKOBEST	Average turnover of consignment stock		DUHKOBEST	DEC	4
DUHGSBEST	Average turnover of total stock		DUHGSBEST	DEC	4
DWGVBR	Value of average total usage		DWGVBR	CURR	8
DUVBR	Average unplanned usage quantity		DUVBR	QUAN	8
DWUVBR	Average unplanned usage value		DWUVBR	CURR	8
UHWBWBEST	Inventory turnover (value-based) of valuated stock		UHWBWBEST	DEC	4
UHWGSBEST	Inventory turnover (value-based) of total stock		UHWGSBEST	DEC	4
DUHWGSBEST	Average turnover (value-based) of total stock		DUHWGSBEST	DEC	4
DUHWBWBEST	Average turnover (value-based) of valuated stock		DUHWBWBEST	DEC	4
JUHWGSBEST	Annual inventory turnover (value-based) of total stock		JUHWGSBEST	DEC	4
JUHWBWBEST	Annual inventory turnover (value-based) of valuated stock		JUHWBWBEST	DEC	4
JUHGSBEST	Annual inventory turnover (quantity-based) of total stock		JUHGSBEST	DEC	4
JUHKOBEST	Annual turnover (quantity-based) of consignment stock		JUHKOBEST	DEC	4
JUHBWBEST	Annual inventory turnover of valuated stock		JUHBWBEST	DEC	4
RWWGSBEST	Range of coverage (value-based) of total stock		RWWGSBEST	DEC	4
RWWBWBEST	Range of coverage (value-based) of valuated stock		RWWBWBEST	DEC	4
DRWWGSBEST	Average range of coverage (value-based) of total stock		DRWWGSBEST	DEC	4
DRWWBWBEST	Average range of coverage (value-based) of valuated stock		DRWWBWBEST	DEC	4
LETZTZUG	Date: Last Receipt		LETZTZUG	DATS	16
LETZTABG	Date: last (i.e. most recent) goods issue		LETZTABG	DATS	16
LETZTVER	Date: last (i.e. most recent) consumption		LETZTVER	DATS	16
LETZTBEW	Date: last (i.e. most recent) goods movement		LETZTBEW	DATS	16
EISBE	Safety stock		MC_EISBE	QUAN	8
BESZUG	Stock level at goods receipt		BESZUG	QUAN	8
WBESZUG	Value of stock at goods receipt		WBESZUG	CURR	8
BKLAS	Valuation Class		BKLAS	CHAR	8	*