SAP ABAP Table S079 (STRPS: 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	S079	Table Relationship Diagram
Short Description	STRPS: 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	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
9	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
11	BZIRK	☑	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
12	BTRKZ	☑	VLFKZ	VLFKZ	CHAR	1	0	Plant category
13	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
14	WGRU2	☑	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
15	WGRU1	☑	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
16	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
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	AUMMNG	☐	MCW_AUMMNG	MENGV15_3	QUAN	15	3	Promotion sales quantity in BUn
27	AUMGEO	☐	MCW_AUMGEO	WERTV10	CURR	19	2	Promotion sales at cost
28	AUMGVO	☐	MCW_AUMGVO	WERTV10	CURR	19	2	Promotion sales at retail
29	AUMGVP	☐	MCW_AUMGVP	WERTV10	CURR	19	2	Promotion sales at retail with tax
30	WESMNG	☐	MCW_WESMNG	MENGV15_3	QUAN	15	3	Goods receipt (vendor) quantity in BUn
31	WESGEO	☐	MCW_WESGEO	WERTV10	CURR	19	2	Goods receipt (vendor) at cost
32	WESGVO	☐	MCW_WESGVO	WERTV10	CURR	19	2	Goods receipt (vendor) at retail
33	WESGVP	☐	MCW_WESGVP	WERTV10	CURR	19	2	Goods receipt (vendor) at retail with tax
34	WESANZ	☐	MCW_WESANZ	MCZAEHLINT	INT4	10	0	Goods receipt (vendor) number of transactions
35	RTEMNG	☐	MCW_RTEMNG	MENGV15_3	QUAN	15	3	Returns to vendor quantity in base unit of measure
36	RTEGEO	☐	MCW_RTEGEO	WERTV10	CURR	19	2	Returns to vendor at cost
37	RTEGVO	☐	MCW_RTEGVO	WERTV10	CURR	19	2	Returns to vendor at retail
38	RTEGVP	☐	MCW_RTEGVP	WERTV10	CURR	19	2	Returns to vendor at retail with tax
39	RTEANZ	☐	MCW_RTEANZ	MCZAEHLINT	INT4	10	0	Returns to vendor, no. of transactions
40	KMEMNG	☐	MCW_KMEMNG	MENGV15_3	QUAN	15	3	Goods receipt (distribution center) quantity in BUn
41	KMEGEO	☐	MCW_KMEGEO	WERTV10	CURR	19	2	Goods receipt (DC) at cost
42	KMEGVO	☐	MCW_KMEGVO	WERTV10	CURR	19	2	Goods receipt (DC) at retail
43	KMEGVP	☐	MCW_KMEGVP	WERTV10	CURR	19	2	Goods receipt (dist. center) at retail with tax
44	KMEANZ	☐	MCW_KMEANZ	MCZAEHLINT	INT4	10	0	Goods receipt (distribution center), no. of transactions
45	KMAMNG	☐	MCW_KMAMNG	MENGV15_3	QUAN	15	3	Goods issue (distribution center) quantity in BUn
46	KMAGEO	☐	MCW_KMAGEO	WERTV10	CURR	19	2	Goods issue (DC) at cost
47	KMAGVO	☐	MCW_KMAGVO	WERTV10	CURR	19	2	Goods issue (DC) at retail
48	KMAGVP	☐	MCW_KMAGVP	WERTV10	CURR	19	2	Goods issue (dist. center) at retail with tax
49	KMAANZ	☐	MCW_KMAANZ	MCZAEHLINT	INT4	10	0	Goods issue (distribution center), no. of transactions
50	ULEMNG	☐	MCW_ULEMNG	MENGV15_3	QUAN	15	3	Goods clearing: receipts quantity in BUn
51	ULEGEO	☐	MCW_ULEGEO	WERTV10	CURR	19	2	Goods clearing: receipts at cost
52	ULEGVO	☐	MCW_ULEGVO	WERTV10	CURR	19	2	Goods clearing: receipts at retail
53	ULEGVP	☐	MCW_ULEGVP	WERTV10	CURR	19	2	Goods clearing: receipts at retail with tax
54	ULEANZ	☐	MCW_ULEANZ	MCZAEHLINT	INT4	10	0	Goods clearing: receipts, no. of transactions
55	ULAMNG	☐	MCW_ULAMNG	MENGV15_3	QUAN	15	3	Goods clearing: issues quantity in BUn
56	ULAGEO	☐	MCW_ULAGEO	WERTV10	CURR	19	2	Goods clearing: issues at cost
57	ULAGVO	☐	MCW_ULAGVO	WERTV10	CURR	19	2	Goods clearing: issues at retail
58	ULAGVP	☐	MCW_ULAGVP	WERTV10	CURR	19	2	Goods clearing: issues at retail with tax
59	ULAANZ	☐	MCW_ULAANZ	MCZAEHLINT	INT4	10	0	Goods clearing: issues, no. of transactions
60	AUEMNG	☐	MCW_AUEMNG	MENGV15_3	QUAN	15	3	Material transfer: receipts quantity BUn
61	AUEGEO	☐	MCW_AUEGEO	WERTV10	CURR	19	2	Material transfer: receipts at cost
62	AUEGVO	☐	MCW_AUEGVO	WERTV10	CURR	19	2	Material transfer: receipts at retail
63	AUEGVP	☐	MCW_AUEGVP	WERTV10	CURR	19	2	Material transfer: receipts at retail with tax
64	AUEANZ	☐	MCW_AUEANZ	MCZAEHLINT	INT4	10	0	Material transfer: receipts, no. transactions
65	AUAMNG	☐	MCW_AUAMNG	MENGV15_3	QUAN	15	3	Material transfer: issues quantity BUn
66	AUAGEO	☐	MCW_AUAGEO	WERTV10	CURR	19	2	Material transfer: issues at cost
67	AUAGVO	☐	MCW_AUAGVO	WERTV10	CURR	19	2	Material transfer: issues at retail
68	AUAGVP	☐	MCW_AUAGVP	WERTV10	CURR	19	2	Material transfer: issues at retail with tax
69	AUAANZ	☐	MCW_AUAANZ	MCZAEHLINT	INT4	10	0	Material transfer: issues, no. of transactions
70	BKIPMG	☐	MCW_BKIPMG	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference plus (quantity)
71	BKIPEO	☐	MCW_BKIPEO	WERTV10	CURR	19	2	Stock adjustment inventory difference plus (cost)
72	BKIPVO	☐	MCW_BKIPVO	WERTV10	CURR	19	2	Stock adjustment inventory difference plus (retail)
73	BKIPVP	☐	MCW_BKIPVP	WERTV10	CURR	19	2	Stock adjustment inventory difference plus (at retail w/tax)
74	BKIPAZ	☐	MCW_BKIPAZ	MCZAEHLINT	INT4	10	0	Stock adjustment inv. difference plus (no. of transactions)
75	BKIMMG	☐	MCW_BKIMMG	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference minus (quantity)
76	BKIMEO	☐	MCW_BKIMEO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (cost)
77	BKIMVO	☐	MCW_BKIMVO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail)
78	BKIMVP	☐	MCW_BKIMVP	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail w/tax)
79	BKIMAZ	☐	MCW_BKIMAZ	MCZAEHLINT	INT4	10	0	Stock adjustment inv. difference minus (no. of transactions)
80	BKSPMG	☐	MCW_BKSPMG	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous plus (quantity)
81	BKSPEO	☐	MCW_BKSPEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous plus (cost)
82	BKSPVO	☐	MCW_BKSPVO	WERTV10	CURR	19	2	Stock adjustment miscellaneous plus (retail)
83	BKSPVP	☐	MCW_BKSPVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous plus (retail with tax)
84	BKSPAZ	☐	MCW_BKSPAZ	MCZAEHLINT	INT4	10	0	Stock adjustment miscellaneous plus (no. of transactions)
85	BKSMMG	☐	MCW_BKSMMG	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous minus (quantity)
86	BKSMEO	☐	MCW_BKSMEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (cost)
87	BKSMVO	☐	MCW_BKSMVO	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (retail)
88	BKSMVP	☐	MCW_BKSMVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (retail with tax)
89	BKSMAZ	☐	MCW_BKSMAZ	MCZAEHLINT	INT4	10	0	Stock adjustment miscellaneous minus (no. of transactions)
90	BVLMNG	☐	MCW_BVLMNG	MENGV15_3	QUAN	15	3	Order volume quantity Retail
91	BVLGEO	☐	MCW_BVLGEO	WERTV10	CURR	19	2	Order volume at cost
92	BVLGVO	☐	MCW_BVLGVO	WERTV10	CURR	19	2	Order volume at retail
93	BVLGVP	☐	MCW_BVLGVP	WERTV10	CURR	19	2	Order volume at retail with tax
94	BVLANZ	☐	MCW_BVLANZ	MCZAEHLINT	INT4	10	0	Order volume, number of transactions
95	UBPEPM	☐	MCW_UBPEPM	MENGV15_3	QUAN	15	3	Revaluation at cost, plus, quantity
96	UBPGEO	☐	MCW_UBPGEO	WERTV10	CURR	19	2	Revaluation at cost, plus
97	UBPEAZ	☐	MCW_UBPEAZ	MCZAEHLINT	INT4	10	0	Revaluation at cost plus, no. of transactions
98	UBMEPM	☐	MCW_UBMEPM	MENGV15_3	QUAN	15	3	Revaluation at cost minus, quantity
99	UBMGEO	☐	MCW_UBMGEO	WERTV10	CURR	19	2	Revaluation at cost, minus
100	UBMEAZ	☐	MCW_UBMEAZ	MCZAEHLINT	INT4	10	0	Revaluation at cost minus, no. of transactions
101	UBPVPM	☐	MCW_UBPVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, plus, quantity
102	UBPGVO	☐	MCW_UBPGVO	WERTV10	CURR	19	2	Revaluation at retail, plus
103	UBPGVP	☐	MCW_UBPGVP	WERTV10	CURR	19	2	Revaluation at retail, plus, at retail with tax
104	UBPVAZ	☐	MCW_UBPVAZ	MCZAEHLINT	INT4	10	0	Revaluation at retail, plus, no. of transactions
105	UBMVPM	☐	MCW_UBMVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, minus, quantity
106	UBMGVO	☐	MCW_UBMGVO	WERTV10	CURR	19	2	Revaluation at retail, minus
107	UBMGVP	☐	MCW_UBMGVP	WERTV10	CURR	19	2	Revaluation at retail, minus, at retail with tax
108	UBMVAZ	☐	MCW_UBMVAZ	MCZAEHLINT	INT4	10	0	Revaluation at retail, minus, no. of transactions
109	BSTMNG	☐	MCW_BSTMNG	MENGV15_3	QUAN	15	3	Stock quantity in base unit of measure
110	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
111	BSTGVO	☐	MCW_BSTGVO	WERTV10	CURR	19	2	Stock at retail
112	BSTGVP	☐	MCW_BSTGVP	WERTV10	CURR	19	2	Stock at retail with tax
113	WESMAO	☐	MCW_WESMAO	PRZ32V	DEC	6	2	Goods receipt margin (vendor+GR(DC))
114	WESMAM	☐	MCW_WESMAM	PRZ32V	DEC	6	2	Goods receipt margin with tax (vendor+GR(DC))
115	UMSMAO	☐	MCW_UMSMAO	PRZ32V	DEC	6	2	Sales margin
116	UMSMAM	☐	MCW_UMSMAM	PRZ32V	DEC	6	2	Sales margin with tax
117	AUMMAO	☐	MCW_AUMMAO	PRZ32V	DEC	6	2	Promotion sales margin
118	AUMMAM	☐	MCW_AUMMAM	PRZ32V	DEC	6	2	Promotion sales margin with tax
119	BVLMAO	☐	MCW_BVLMAO	PRZ32V	DEC	6	2	Order volume margin
120	BVLMAM	☐	MCW_BVLMAM	PRZ32V	DEC	6	2	Order volume margin with tax
121	BSTMAO	☐	MCW_BSTMAO	PRZ32V	DEC	6	2	Stock margin
122	BSTMAM	☐	MCW_BSTMAM	PRZ32V	DEC	6	2	Stock margin including tax
123	ZUGMNG	☐	MCW_ZUGMNG	MENGV15_3	QUAN	15	3	Receipts quantity in BUn
124	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
125	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
126	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
127	ABGMNG	☐	MCW_ABGMNG	MENGV15_3	QUAN	15	3	Issues quantity in BUn
128	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
129	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
130	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
131	RWMENG	☐	MCW_RWMENG	BCSP4	DEC	7	0	Range of coverage in days (quantity)
132	RWWERT	☐	MCW_RWWERT	BCSP4	DEC	7	0	Range of coverage in days (value)
133	UHMENG	☐	MCW_UHMENG	PRZ32V	DEC	6	2	Inventory turn (quantity)
134	UHWERT	☐	MCW_UHWERT	PRZ32V	DEC	6	2	Inventory turn (value)
135	JUMENG	☐	MCW_JUMENG	PRZ32V	DEC	6	2	Annual inventory turn (quantity)
136	JUWERT	☐	MCW_JUWERT	PRZ32V	DEC	6	2	Annual inventory turn (value)
137	GMROIO	☐	MCW_GMROIO	PRZ32V	DEC	6	2	Gross margin return on inventory investment
138	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	S079	BASME	T006	MSEHI
2	S079	BZIRK	T171	BZIRK
3	S079	EKORG	T024E	EKORG
4	S079	HWAER	TCURC	WAERS
5	S079	MANDT	T000	MANDT
6	S079	MATKL	T023	MATKL
7	S079	VKORG	TVKO	VKORG
8	S079	VTWEG	TVTW	VTWEG
9	S079	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in