SAP ABAP Table S085 (Material: Movements + Stock)

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	S085	Table Relationship Diagram
Short Description	Material: Movements + Stock

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	BTRKZ	☑	VLFKZ	VLFKZ	CHAR	1	0	Plant category
10	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
11	WGRU2	☑	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
12	WGRU1	☑	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
13	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
14	SAISO	☑	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
15	PLGTP	☑	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
16	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
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	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
21	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
22	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
23	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
24	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
25	PRSNLS	☐	MCW_PRSNLS	WERTV10	CURR	19	2	Sales deviation during sales
26	WESMNG	☐	MCW_WESMNG	MENGV15_3	QUAN	15	3	Goods receipt (vendor) quantity in BUn
27	WESGEO	☐	MCW_WESGEO	WERTV10	CURR	19	2	Goods receipt (vendor) at cost
28	WESGVO	☐	MCW_WESGVO	WERTV10	CURR	19	2	Goods receipt (vendor) at retail
29	WESGVP	☐	MCW_WESGVP	WERTV10	CURR	19	2	Goods receipt (vendor) at retail with tax
30	WESANZ	☐	MCW_WESANZ	MCZAEHLINT	INT4	10	0	Goods receipt (vendor) number of transactions
31	KMEMNG	☐	MCW_KMEMNG	MENGV15_3	QUAN	15	3	Goods receipt (distribution center) quantity in BUn
32	KMEGEO	☐	MCW_KMEGEO	WERTV10	CURR	19	2	Goods receipt (DC) at cost
33	KMEGVO	☐	MCW_KMEGVO	WERTV10	CURR	19	2	Goods receipt (DC) at retail
34	KMEGVP	☐	MCW_KMEGVP	WERTV10	CURR	19	2	Goods receipt (dist. center) at retail with tax
35	KMEANZ	☐	MCW_KMEANZ	MCZAEHLINT	INT4	10	0	Goods receipt (distribution center), no. of transactions
36	KMAMNG	☐	MCW_KMAMNG	MENGV15_3	QUAN	15	3	Goods issue (distribution center) quantity in BUn
37	KMAGEO	☐	MCW_KMAGEO	WERTV10	CURR	19	2	Goods issue (DC) at cost
38	KMAGVO	☐	MCW_KMAGVO	WERTV10	CURR	19	2	Goods issue (DC) at retail
39	KMAGVP	☐	MCW_KMAGVP	WERTV10	CURR	19	2	Goods issue (dist. center) at retail with tax
40	KMAANZ	☐	MCW_KMAANZ	MCZAEHLINT	INT4	10	0	Goods issue (distribution center), no. of transactions
41	BVLMNG	☐	MCW_BVLMNG	MENGV15_3	QUAN	15	3	Order volume quantity Retail
42	BVLGEO	☐	MCW_BVLGEO	WERTV10	CURR	19	2	Order volume at cost
43	BVLGVO	☐	MCW_BVLGVO	WERTV10	CURR	19	2	Order volume at retail
44	BVLGVP	☐	MCW_BVLGVP	WERTV10	CURR	19	2	Order volume at retail with tax
45	BVLANZ	☐	MCW_BVLANZ	MCZAEHLINT	INT4	10	0	Order volume, number of transactions
46	BSTMNG	☐	MCW_BSTMNG	MENGV15_3	QUAN	15	3	Stock quantity in base unit of measure
47	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
48	BSTGVO	☐	MCW_BSTGVO	WERTV10	CURR	19	2	Stock at retail
49	BSTGVP	☐	MCW_BSTGVP	WERTV10	CURR	19	2	Stock at retail with tax
50	UBPVPM	☐	MCW_UBPVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, plus, quantity
51	UBPGVO	☐	MCW_UBPGVO	WERTV10	CURR	19	2	Revaluation at retail, plus
52	UBPGVP	☐	MCW_UBPGVP	WERTV10	CURR	19	2	Revaluation at retail, plus, at retail with tax
53	UBPVAZ	☐	MCW_UBPVAZ	MCZAEHLINT	INT4	10	0	Revaluation at retail, plus, no. of transactions
54	UBMVPM	☐	MCW_UBMVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, minus, quantity
55	UBMGVO	☐	MCW_UBMGVO	WERTV10	CURR	19	2	Revaluation at retail, minus
56	UBMGVP	☐	MCW_UBMGVP	WERTV10	CURR	19	2	Revaluation at retail, minus, at retail with tax
57	UBMVAZ	☐	MCW_UBMVAZ	MCZAEHLINT	INT4	10	0	Revaluation at retail, minus, no. of transactions
58	ZUGMNG	☐	MCW_ZUGMNG	MENGV15_3	QUAN	15	3	Receipts quantity in BUn
59	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
60	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
61	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
62	ABGMNG	☐	MCW_ABGMNG	MENGV15_3	QUAN	15	3	Issues quantity in BUn
63	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
64	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
65	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
66	WESMAO	☐	MCW_WESMAO	PRZ32V	DEC	6	2	Goods receipt margin (vendor+GR(DC))
67	WESMAM	☐	MCW_WESMAM	PRZ32V	DEC	6	2	Goods receipt margin with tax (vendor+GR(DC))
68	UMSMAO	☐	MCW_UMSMAO	PRZ32V	DEC	6	2	Sales margin
69	UMSMAM	☐	MCW_UMSMAM	PRZ32V	DEC	6	2	Sales margin with tax
70	BVLMAO	☐	MCW_BVLMAO	PRZ32V	DEC	6	2	Order volume margin
71	BVLMAM	☐	MCW_BVLMAM	PRZ32V	DEC	6	2	Order volume margin with tax
72	BSTMAO	☐	MCW_BSTMAO	PRZ32V	DEC	6	2	Stock margin
73	BSTMAM	☐	MCW_BSTMAM	PRZ32V	DEC	6	2	Stock margin including tax
74	RWMENG	☐	MCW_RWMENG	BCSP4	DEC	7	0	Range of coverage in days (quantity)
75	RWWERT	☐	MCW_RWWERT	BCSP4	DEC	7	0	Range of coverage in days (value)
76	UHMENG	☐	MCW_UHMENG	PRZ32V	DEC	6	2	Inventory turn (quantity)
77	UHWERT	☐	MCW_UHWERT	PRZ32V	DEC	6	2	Inventory turn (value)
78	JUMENG	☐	MCW_JUMENG	PRZ32V	DEC	6	2	Annual inventory turn (quantity)
79	JUWERT	☐	MCW_JUWERT	PRZ32V	DEC	6	2	Annual inventory turn (value)
80	GMROIO	☐	MCW_GMROIO	PRZ32V	DEC	6	2	Gross margin return on inventory investment
81	GMROIM	☐	MCW_GMROIM	PRZ32V	DEC	6	2	Gross margin return on inventory investment with tax

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S085	BASME	T006	MSEHI
2	S085	HWAER	TCURC	WAERS
3	S085	LIFNR	LFA1	LIFNR
4	S085	MANDT	T000	MANDT
5	S085	MATKL	T023	MATKL
6	S085	MATNR	MARA	MATNR
7	S085	PLGTP	TWPT	PLGTP
8	S085	SAISO	T6WSP	SAISO
9	S085	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in