SAP ABAP Table S031 (Statistics: Movements for current stocks)

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	S031	Table Relationship Diagram
Short Description	Statistics: Movements for current stocks

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	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
12	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
13	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
14	HWAER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
15	MZUBB	☐	MZUBB	MENGV15	QUAN	15	3	Valuated stock receipts quantity
16	WZUBB	☐	WZUBB	WERT15	CURR	15	2	Valuated stock receipts value
17	AZUBB	☐	AZUBB	ANZAHL	DEC	9	0	Number of times that valuated stock has been received
18	MZUKB	☐	MZUKB	MENGV15	QUAN	15	3	Consignment stock receipts quantity
19	AZUKB	☐	AZUKB	ANZAHL	DEC	9	0	Number of times that consignment stock has been received
20	MAGBB	☐	MAGBB	MENGV15	QUAN	15	3	Quantity of valuated stock issues
21	WAGBB	☐	WAGBB	WERT15	CURR	15	2	Value of valuated stock that has been issued
22	AAGBB	☐	AAGBB	ANZAHL	DEC	9	0	Number of times valuated stock has been issued
23	MAGKB	☐	MAGKB	MENGV15	QUAN	15	3	Quantity of consignment stock that has been issued
24	AAGKB	☐	AAGKB	ANZAHL	DEC	9	0	Number of times consignment stock has been issued
25	AMBWG	☐	AMBWG	ANZAHL	DEC	9	0	Number of material movements
26	MGVBR	☐	GVBRM	MENGV15	QUAN	15	3	Total usage quantity
27	WGVBR	☐	WGVBR	WERT15	CURR	15	2	Total usage value
28	AGVBR	☐	AGVBR	ANZAHL	DEC	9	0	Number of times that total usage has been updated
29	MUVBR	☐	UVBRM	MENGV15	QUAN	15	3	Unplanned usage quantity
30	WUVBR	☐	WUVBR	WERT15	CURR	15	2	Unplanned usage value
31	AUVBR	☐	AUVBR	ANZAHL	DEC	9	0	Number of times an unplanned usage has been recorded
32	ASTOR	☐	ASTOR	ANZAHL	DEC	9	0	Number of cancelation documents to date
33	BBNULL	☐	BBNULL	ANZAHL	DEC	9	0	Number of times that valuated stock was zero
34	KBNULL	☐	KBNULL	ANZAHL	DEC	9	0	Number of times that consignment stock was zero
35	GBNULL	☐	GBNULL	ANZAHL	DEC	9	0	Number of times that total stock was zero
36	BESZUG	☐	BESZUG	MENGV15	QUAN	15	3	Stock level at goods receipt
37	WBESZUG	☐	WBESZUG	WERT15	CURR	15	2	Value of stock at goods receipt

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S031	BASME	T006	MSEHI	KEY	1	CN
2	S031	HWAER	TCURC	WAERS	KEY	1	CN
3	S031	LGORT	T001L	LGORT
4	S031	MANDT	T000	MANDT	KEY	1	CN
5	S031	MATNR	MARA	MATNR
6	S031	PERIV	T009	PERIV	KEY	1	CN
7	S031	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in