SAP ABAP Table S107 (Season: 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	S107	Table Relationship Diagram
Short Description	Season: 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	EKGRP	☑	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
9	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
11	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
12	SATNR	☑	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
13	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	SAISJ	☑	SAISJ	CJAHR	CHAR	4	0	Season Year
15	SAISO	☑	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
16	PLGTP	☑	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
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	UBPVPM	☐	MCW_UBPVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, plus, quantity
31	UBPGVO	☐	MCW_UBPGVO	WERTV10	CURR	19	2	Revaluation at retail, plus
32	UBPGVP	☐	MCW_UBPGVP	WERTV10	CURR	19	2	Revaluation at retail, plus, at retail with tax
33	UBPVAZ	☐	MCW_UBPVAZ	MCZAEHLINT	INT4	10	0	Revaluation at retail, plus, no. of transactions
34	UBMVPM	☐	MCW_UBMVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, minus, quantity
35	UBMGVO	☐	MCW_UBMGVO	WERTV10	CURR	19	2	Revaluation at retail, minus
36	UBMGVP	☐	MCW_UBMGVP	WERTV10	CURR	19	2	Revaluation at retail, minus, at retail with tax
37	UBMVAZ	☐	MCW_UBMVAZ	MCZAEHLINT	INT4	10	0	Revaluation at retail, minus, no. of transactions
38	ZUGMNG	☐	MCW_ZUGMNG	MENGV15_3	QUAN	15	3	Receipts quantity in BUn
39	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
40	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
41	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
42	ABGMNG	☐	MCW_ABGMNG	MENGV15_3	QUAN	15	3	Issues quantity in BUn
43	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
44	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
45	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
46	BBZMNG	☐	MCW_BBZMNG	MENGV15_3	QUAN	15	3	Order stock receipts quantity in BUn
47	BBZGEO	☐	MCW_BBZGEO	WERTV10	CURR	19	2	Order stock receipts at cost
48	BBZGVO	☐	MCW_BBZGVO	WERTV10	CURR	19	2	Order stock receipts at retail
49	BBZGVP	☐	MCW_BBZGVP	WERTV10	CURR	19	2	Order stock receipts at retail with tax
50	BBAMNG	☐	MCW_BBAMNG	MENGV15_3	QUAN	15	3	Order stock issues quantity in BUn
51	BBAGEO	☐	MCW_BBAGEO	WERTV10	CURR	19	2	Order stock issues at cost
52	BBAGVO	☐	MCW_BBAGVO	WERTV10	CURR	19	2	Order stock issues at retail
53	BBAGVP	☐	MCW_BBAGVP	WERTV10	CURR	19	2	Order stock issues at retail with tax
54	KMAMNG	☐	MCW_KMAMNG	MENGV15_3	QUAN	15	3	Goods issue (distribution center) quantity in BUn
55	KMAGEO	☐	MCW_KMAGEO	WERTV10	CURR	19	2	Goods issue (DC) at cost
56	KMAGVO	☐	MCW_KMAGVO	WERTV10	CURR	19	2	Goods issue (DC) at retail
57	KMAGVP	☐	MCW_KMAGVP	WERTV10	CURR	19	2	Goods issue (dist. center) at retail with tax
58	KMAANZ	☐	MCW_KMAANZ	MCZAEHLINT	INT4	10	0	Goods issue (distribution center), no. of transactions
59	ULEMNG	☐	MCW_ULEMNG	MENGV15_3	QUAN	15	3	Goods clearing: receipts quantity in BUn
60	ULEGEO	☐	MCW_ULEGEO	WERTV10	CURR	19	2	Goods clearing: receipts at cost
61	ULEGVO	☐	MCW_ULEGVO	WERTV10	CURR	19	2	Goods clearing: receipts at retail
62	ULEGVP	☐	MCW_ULEGVP	WERTV10	CURR	19	2	Goods clearing: receipts at retail with tax
63	ULEANZ	☐	MCW_ULEANZ	MCZAEHLINT	INT4	10	0	Goods clearing: receipts, no. of transactions
64	ULAMNG	☐	MCW_ULAMNG	MENGV15_3	QUAN	15	3	Goods clearing: issues quantity in BUn
65	ULAGEO	☐	MCW_ULAGEO	WERTV10	CURR	19	2	Goods clearing: issues at cost
66	ULAGVO	☐	MCW_ULAGVO	WERTV10	CURR	19	2	Goods clearing: issues at retail
67	ULAGVP	☐	MCW_ULAGVP	WERTV10	CURR	19	2	Goods clearing: issues at retail with tax
68	ULAANZ	☐	MCW_ULAANZ	MCZAEHLINT	INT4	10	0	Goods clearing: issues, no. of transactions
69	BSTMNG	☐	MCW_BSTMNG	MENGV15_3	QUAN	15	3	Stock quantity in base unit of measure
70	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
71	BSTGVO	☐	MCW_BSTGVO	WERTV10	CURR	19	2	Stock at retail
72	BSTGVP	☐	MCW_BSTGVP	WERTV10	CURR	19	2	Stock at retail with tax
73	BBSMNG	☐	MCW_BBSMNG	MENGV15_3	QUAN	15	3	On-order stock quantity in BUn
74	BBSGEO	☐	MCW_BBSGEO	WERTV10	CURR	19	2	On-order stock at cost
75	BBSGVO	☐	MCW_BBSGVO	WERTV10	CURR	19	2	On-order stock at retail
76	BBSGVP	☐	MCW_BBSGVP	WERTV10	CURR	19	2	On-order stock at retail with tax
77	ERSTZU	☐	MCW_ERSTZU	DATS	DATS	8	0	First receipt
78	TAGEIV	☐	MCW_TAGEIV	MCZAEHLINT	INT4	10	0	Days on sale, no. of
79	URSPVP	☐	MCW_URSPVP	WERTV6	CURR	11	2	Original retail price
80	AQMENG	☐	MCW_AQMENG	PRZ32V	DEC	6	2	Sales quota (quantity)
81	AQWERT	☐	MCW_AQWERT	PRZ32V	DEC	6	2	Sales quota (value)
82	FUMGVP	☐	MCW_FUMGVP	WERTV10	CURR	19	2	Fictitious sales at retail with tax
83	FBSGVP	☐	MCW_FBSGVP	WERTV10	CURR	19	2	Fictitious stock at retail with tax
84	UMSMAO	☐	MCW_UMSMAO	PRZ32V	DEC	6	2	Sales margin
85	UMSMAM	☐	MCW_UMSMAM	PRZ32V	DEC	6	2	Sales margin with tax
86	AUMMAO	☐	MCW_AUMMAO	PRZ32V	DEC	6	2	Promotion sales margin
87	AUMMAM	☐	MCW_AUMMAM	PRZ32V	DEC	6	2	Promotion sales margin with tax
88	BSTMAO	☐	MCW_BSTMAO	PRZ32V	DEC	6	2	Stock margin
89	BSTMAM	☐	MCW_BSTMAM	PRZ32V	DEC	6	2	Stock margin including tax
90	BBSMAO	☐	MCW_BBSMAO	PRZ32V	DEC	6	2	On-order stock margin
91	BBSMAM	☐	MCW_BBSMAM	PRZ32V	DEC	6	2	On-order stock margin with tax
92	UHMENG	☐	MCW_UHMENG	PRZ32V	DEC	6	2	Inventory turn (quantity)
93	UHWERT	☐	MCW_UHWERT	PRZ32V	DEC	6	2	Inventory turn (value)
94	JUMENG	☐	MCW_JUMENG	PRZ32V	DEC	6	2	Annual inventory turn (quantity)
95	JUWERT	☐	MCW_JUWERT	PRZ32V	DEC	6	2	Annual inventory turn (value)
96	GMROIO	☐	MCW_GMROIO	PRZ32V	DEC	6	2	Gross margin return on inventory investment
97	GMROIM	☐	MCW_GMROIM	PRZ32V	DEC	6	2	Gross margin return on inventory investment with tax
98	RWMENG	☐	MCW_RWMENG	BCSP4	DEC	7	0	Range of coverage in days (quantity)
99	RWWERT	☐	MCW_RWWERT	BCSP4	DEC	7	0	Range of coverage in days (value)
100	SBSMNG	☐	MCW_SBSMNG	MENGV15_3	QUAN	15	3	End of season stock quantity in BUn
101	SBSGEO	☐	MCW_SBSGEO	WERTV10	CURR	19	2	End of season stock at cost
102	SBSGVO	☐	MCW_SBSGVO	WERTV10	CURR	19	2	End of season stock at retail
103	SBSGVP	☐	MCW_SBSGVP	WERTV10	CURR	19	2	End of season stock at retail with tax
104	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
105	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
106	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
107	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
108	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
109	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
110	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
111	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in