SAP ABAP Table S039 (Statistics: Inventory Controlling)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S039	Table Relationship Diagram
Short Description	Statistics: Inventory Controlling

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	LGORT	☑	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	DISPO	☑	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
12	DISMM	☑	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
13	MTART	☑	MTART	MTART	CHAR	4	0	Material type	T134
14	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
15	GSBER	☑	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
16	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
18	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
19	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
20	HWAER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
21	MZUBB	☐	MZUBB	MENGV15	QUAN	15	3	Valuated stock receipts quantity
22	WZUBB	☐	WZUBB	WERT15	CURR	15	2	Valuated stock receipts value
23	AZUBB	☐	AZUBB	ANZAHL	DEC	9	0	Number of times that valuated stock has been received
24	MZUKB	☐	MZUKB	MENGV15	QUAN	15	3	Consignment stock receipts quantity
25	AZUKB	☐	AZUKB	ANZAHL	DEC	9	0	Number of times that consignment stock has been received
26	MAGBB	☐	MAGBB	MENGV15	QUAN	15	3	Quantity of valuated stock issues
27	WAGBB	☐	WAGBB	WERT15	CURR	15	2	Value of valuated stock that has been issued
28	AAGBB	☐	AAGBB	ANZAHL	DEC	9	0	Number of times valuated stock has been issued
29	MAGKB	☐	MAGKB	MENGV15	QUAN	15	3	Quantity of consignment stock that has been issued
30	AAGKB	☐	AAGKB	ANZAHL	DEC	9	0	Number of times consignment stock has been issued
31	AMBWG	☐	AMBWG	ANZAHL	DEC	9	0	Number of material movements
32	MGVBR	☐	GVBRM	MENGV15	QUAN	15	3	Total usage quantity
33	WGVBR	☐	WGVBR	WERT15	CURR	15	2	Total usage value
34	AGVBR	☐	AGVBR	ANZAHL	DEC	9	0	Number of times that total usage has been updated
35	MUVBR	☐	UVBRM	MENGV15	QUAN	15	3	Unplanned usage quantity
36	WUVBR	☐	WUVBR	WERT15	CURR	15	2	Unplanned usage value
37	AUVBR	☐	AUVBR	ANZAHL	DEC	9	0	Number of times an unplanned usage has been recorded
38	ASTOR	☐	ASTOR	ANZAHL	DEC	9	0	Number of cancelation documents to date
39	BBNULL	☐	BBNULL	ANZAHL	DEC	9	0	Number of times that valuated stock was zero
40	KBNULL	☐	KBNULL	ANZAHL	DEC	9	0	Number of times that consignment stock was zero
41	GBNULL	☐	GBNULL	ANZAHL	DEC	9	0	Number of times that total stock was zero
42	.INCLUDE	☐				0	0	Additional Key Figures in Inventory Controlling
43	MBWBEST	☐	MBWBEST	MENGV15	QUAN	15	3	Quantity of valuated stock
44	WBWBEST	☐	WBWBEST	WERT15	CURR	15	2	Value of valuated stock
45	MKOBEST	☐	MKOBEST	MENGV15	QUAN	15	3	Quantity of consignment stock
46	DZUBB	☐	DZUBB	MENGV15	QUAN	15	3	Average valuated stock receipts quantity
47	DZWBB	☐	DZWBB	WERT15	CURR	15	2	Average valuated stock receipts value
48	DAGBB	☐	DAGBB	MENGV15	QUAN	15	3	Average quantity of valuated stock issues
49	DAWBB	☐	DAWBB	WERT15	CURR	15	2	Average valuated stock issues value
50	DZUKB	☐	DZUKB	MENGV15	QUAN	15	3	Average consignment stock receipts quantity
51	DAGKB	☐	DAGKB	MENGV15	QUAN	15	3	Average quantity of consignment stock that has been issued
52	DGVBR	☐	DGVBR	MENGV15	QUAN	15	3	Average consumption
53	GSBEST	☐	GSBEST	MENGV15	QUAN	15	3	Total stock
54	RWGSBEST	☐	RWGSBEST	BCSP4	DEC	7	0	Range of coverage of total stock
55	RWKOBEST	☐	RWKOBEST	BCSP4	DEC	7	0	Range of coverage of consignment stock
56	RWBEWBEST	☐	RWBEWBEST	BCSP4	DEC	7	0	Range of coverage of valuated stock
57	UHGSBEST	☐	UHGESBEST	BCSP4	DEC	7	0	Turnover of total stock
58	UHBWBEST	☐	UHBWBEST	BCSP4	DEC	7	0	Turnover of valuated stock
59	UHKOBEST	☐	UHKOBEST	BCSP4	DEC	7	0	Turnover of consignment stock
60	DBWBEST	☐	DBWBEST	MENGV15	QUAN	15	3	Average quantity of valuated stock
61	DKOBEST	☐	DKOBEST	MENGV15	QUAN	15	3	Average quantity of consignment stock
62	DGSBEST	☐	DGSBEST	MENGV15	QUAN	15	3	Average quantity of total stock
63	DWBWBEST	☐	DWBWBEST	WERT15	CURR	15	2	Average valuated stock value
64	DRWBWBEST	☐	DRWBWBEST	BCSP4	DEC	7	0	Average range of coverage of valuated stock
65	DRWKOBEST	☐	DRWKOBEST	BCSP4	DEC	7	0	Average range of coverage of consignment stock
66	DRWGSBEST	☐	DRWGSBEST	BCSP4	DEC	7	0	Average range of coverage of total stock
67	DUHBWBEST	☐	DUHBWBEST	BCSP4	DEC	7	0	Average inventory turnover of valuated stock
68	DUHKOBEST	☐	DUHKOBEST	BCSP4	DEC	7	0	Average turnover of consignment stock
69	DUHGSBEST	☐	DUHGSBEST	BCSP4	DEC	7	0	Average turnover of total stock
70	DWGVBR	☐	DWGVBR	WERT15	CURR	15	2	Value of average total usage
71	DUVBR	☐	DUVBR	MENGV15	QUAN	15	3	Average unplanned usage quantity
72	DWUVBR	☐	DWUVBR	WERT15	CURR	15	2	Average unplanned usage value
73	UHWBWBEST	☐	UHWBWBEST	BCSP4	DEC	7	0	Inventory turnover (value-based) of valuated stock
74	UHWGSBEST	☐	UHWGSBEST	BCSP4	DEC	7	0	Inventory turnover (value-based) of total stock
75	DUHWGSBEST	☐	DUHWGSBEST	BCSP4	DEC	7	0	Average turnover (value-based) of total stock
76	DUHWBWBEST	☐	DUHWBWBEST	BCSP4	DEC	7	0	Average turnover (value-based) of valuated stock
77	JUHWGSBEST	☐	JUHWGSBEST	BCSP4	DEC	7	0	Annual inventory turnover (value-based) of total stock
78	JUHWBWBEST	☐	JUHWBWBEST	BCSP4	DEC	7	0	Annual inventory turnover (value-based) of valuated stock
79	JUHGSBEST	☐	JUHGSBEST	BCSP4	DEC	7	0	Annual inventory turnover (quantity-based) of total stock
80	JUHKOBEST	☐	JUHKOBEST	BCSP4	DEC	7	0	Annual turnover (quantity-based) of consignment stock
81	JUHBWBEST	☐	JUHBWBEST	BCSP4	DEC	7	0	Annual inventory turnover of valuated stock
82	RWWGSBEST	☐	RWWGSBEST	BCSP4	DEC	7	0	Range of coverage (value-based) of total stock
83	RWWBWBEST	☐	RWWBWBEST	BCSP4	DEC	7	0	Range of coverage (value-based) of valuated stock
84	DRWWGSBEST	☐	DRWWGSBEST	BCSP4	DEC	7	0	Average range of coverage (value-based) of total stock
85	DRWWBWBEST	☐	DRWWBWBEST	BCSP4	DEC	7	0	Average range of coverage (value-based) of valuated stock
86	LETZTZUG	☐	LETZTZUG	DATS	DATS	8	0	Date: Last Receipt
87	LETZTABG	☐	LETZTABG	DATS	DATS	8	0	Date: last (i.e. most recent) goods issue
88	LETZTVER	☐	LETZTVER	DATS	DATS	8	0	Date: last (i.e. most recent) consumption
89	LETZTBEW	☐	LETZTBEW	DATS	DATS	8	0	Date: last (i.e. most recent) goods movement
90	EISBE	☐	MC_EISBE	MENGV15	QUAN	15	3	Safety stock
91	BESZUG	☐	BESZUG	MENGV15	QUAN	15	3	Stock level at goods receipt
92	WBESZUG	☐	WBESZUG	WERT15	CURR	15	2	Value of stock at goods receipt
93	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S039	BASME	T006	MSEHI
2	S039	DISMM	T438A	DISMM	KEY	1	CN
3	S039	DISPO	T024D	DISPO
4	S039	GSBER	TGSB	GSBER
5	S039	HWAER	TCURC	WAERS
6	S039	LGORT	T001L	LGORT
7	S039	MANDT	T000	MANDT
8	S039	MATKL	T023	MATKL
9	S039	MATNR	MARA	MATNR
10	S039	MTART	T134	MTART
11	S039	PERIV	T009	PERIV	KEY	1	CN
12	S039	SPART	TSPA	SPART
13	S039	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in