SAP ABAP Table S110 (OTB)

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	S110	Table Relationship Diagram
Short Description	OTB

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	SAISO	☑	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
9	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
10	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
11	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
12	WGRU2	☑	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
13	WGRU1	☑	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
14	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
15	PLGTP	☑	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
16	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
18	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
19	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
20	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
22	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
23	PRSNLS	☐	MCW_PRSNLS	WERTV10	CURR	19	2	Sales deviation during sales
24	BSTGVP	☐	MCW_BSTGVP	WERTV10	CURR	19	2	Stock at retail with tax
25	BSTMNG	☐	MCW_BSTMNG	MENGV15_3	QUAN	15	3	Stock quantity in base unit of measure
26	BSTPROZ	☐	BESTPROZ	FLTP	FLTP	16	16	Stock as % of sales volume
27	UBGVP	☐	MCW_UBGVP	WERTV10	CURR	19	2	Revaluations at sales price including tax
28	UBMNG	☐	UBMNG	MENGV15_3	QUAN	15	3	Revaluation quantity in BUn
29	UBPROZ	☐	UBPROZ	FLTP	FLTP	16	16	Revaluations as a percentage
30	BKIVP	☐	MCW_BKIVP	WERTV10	CURR	19	2	Stock adjustments: inventory difference at sales price + tax
31	BKIMNG	☐	BKIMNG	MENGV15_3	QUAN	15	3	Stock adjustments: inventory differences as base unit qty
32	BKIPROZ	☐	BKIPROZ	FLTP	FLTP	16	16	Stock adjustments: inventory differences as a %
33	SBUDGVP	☐	GLIMGVP	WERTV10	CURR	19	2	Seasonal budget at sales price including tax
34	SBUDMNG	☐	GLIMMNG	MENGV15_3	QUAN	15	3	Seasonal budget - quantity in base unit (BUn)
35	VQUOTEPROZ	☐	VERT_LIM	FLTP	FLTP	16	16	Initial purchasing quota (%)
36	VLIMGVP	☐	VBUDGVP	WERTV10	CURR	19	2	Budget already released at sales price including VAT
37	VBUDMNG	☐	VLIMMNG	MENGV15_3	QUAN	15	3	Budget Already Released - Quantity (Base Unit of Measure)
38	RLIMGVP	☐	RBUDGVP	WERTV10	CURR	19	2	Reserve budget SPwT
39	RLIMMNG	☐	RLIMMNG	MENGV15_3	QUAN	15	3	Reserve budget quantity in base unit of measure (BUn)
40	BBSGVP	☐	MCW_BBSGVP	WERTV10	CURR	19	2	On-order stock at retail with tax
41	BBSMNG	☐	MCW_BBSMNG	MENGV15_3	QUAN	15	3	On-order stock quantity in BUn
42	ULBBSGVP	☐	ULBBSGVP	WERTV10	CURR	19	2	Open stock transport orders (delivering plant) at SPw/VAT
43	ULBBSMNG	☐	ULBBSMNG	MENGV15_3	QUAN	15	3	Open stock transport order qty (supplying plant) in BUn
44	UBBSGVP	☐	UBBSGVP	WERTV10	CURR	19	2	Open stock transport orders at sales price including tax
45	UBBSMNG	☐	UBBSMNG	MENGV15_3	QUAN	15	3	Open stock transport order quantity in BUn
46	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
47	ZUGMNG	☐	MCW_ZUGMNG	MENGV15_3	QUAN	15	3	Receipts quantity in BUn
48	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
49	ABGMNG	☐	MCW_ABGMNG	MENGV15_3	QUAN	15	3	Issues quantity in BUn
50	SOTBGVP	☐	OTBSGVP	WERTV10	CURR	19	2	OTB of seasonal budget at sales price including tax
51	SOTBMNG	☐	OTBSMNG	MENGV15_3	QUAN	15	3	OTB of seasonal budget in quantity of base unit
52	VOTBGVP	☐	OTBVGVP	WERTV10	CURR	19	2	OTB of budget already released at sales price including tax
53	VOTBMNG	☐	OTBVMNG	MENGV15_3	QUAN	15	3	Open-to-buy of budget already released in qty of base unit
54	AVGVP	☐	AVGVP	WERTV10	CURR	19	2	Average price of price band at sales price with tax
55	GLIMGVO	☐	GLIMGVO	WERTV10	CURR	19	2	Seasonal budget at sales price without tax
56	GLIMGEO	☐	GLIMGEO	WERTV10	CURR	19	2	Seasonal budget at purchase price without tax
57	VBUDGVO	☐	VBUDGVO	WERTV10	CURR	19	2	Budget already released at sales price without VAT
58	VBUDGEO	☐	VBUDGEO	WERTV10	CURR	19	2	Budget already released at purchase price without VAT
59	RBUDGVO	☐	RBUDGVO	WERTV10	CURR	19	2	Reserve budget SPw/oVAT
60	RBUDGEO	☐	RBUDGEO	WERTV10	CURR	19	2	Reserve budget PPw/oVAT
61	AVGVO	☐	AVGVO	WERTV10	CURR	19	2	Average price band price at sales price without tax
62	AVGEO	☐	AVGEO	WERTV10	CURR	19	2	Average price band price at purchase price without tax
63	UBGVO	☐	MCW_UBGVO	WERTV10	CURR	19	2	Revaluations at sales price without tax
64	UBGEO	☐	MCW_UBGEO	WERTV10	CURR	19	2	Revaluation PPw/oVAT
65	BKIVO	☐	MCW_BKIVO	WERTV10	CURR	19	2	Stock adjustments: inventory difference at SPw/oVAT
66	BKIEO	☐	MCW_BKIEO	WERTV10	CURR	19	2	Stock adjustments: inventory difference at PPw/oVAT
67	SOTBGVO	☐	OTBSGVO	WERTV10	CURR	19	2	OTB of seasonal budget at sales price without tax
68	SOTBGEO	☐	OTBSGEO	WERTV10	CURR	19	2	OTB of seasonal budget at purchase price without tax
69	VOTBGVO	☐	OTBVGVO	WERTV10	CURR	19	2	OTB of budget already released at sales price without tax
70	VOTBGEO	☐	OTBVGEO	WERTV10	CURR	19	2	OTB of budget already released at purchase price without tax
71	UBBSGVO	☐	UBBSGVO	WERTV10	CURR	19	2	Open stock transport orders at sales price without tax
72	UBBSGEO	☐	UBBSGEO	WERTV10	CURR	19	2	Open stock transport orders at PPw/oVAT
73	ULBBSGVO	☐	ULBBSGVO	WERTV10	CURR	19	2	Open stock transport orders (delivering plant) at SPw/oVAT
74	ULBBSGEO	☐	ULBBSGEO	WERTV10	CURR	19	2	Open stock transport orders (delivering plant) at PPw/oVAT
75	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
76	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
77	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
78	BSTGVO	☐	MCW_BSTGVO	WERTV10	CURR	19	2	Stock at retail
79	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
80	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
81	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
82	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
83	BBSGEO	☐	MCW_BBSGEO	WERTV10	CURR	19	2	On-order stock at cost
84	BBSGVO	☐	MCW_BBSGVO	WERTV10	CURR	19	2	On-order stock at retail
85	UMSMAO	☐	MCW_UMSMAO	PRZ32V	DEC	6	2	Sales margin
86	UMSMAM	☐	MCW_UMSMAM	PRZ32V	DEC	6	2	Sales margin with tax
87	WESMAO	☐	MCW_WESMAO	PRZ32V	DEC	6	2	Goods receipt margin (vendor+GR(DC))
88	WESMAM	☐	MCW_WESMAM	PRZ32V	DEC	6	2	Goods receipt margin with tax (vendor+GR(DC))
89	JUWERT	☐	MCW_JUWERT	PRZ32V	DEC	6	2	Annual inventory turn (value)
90	JUMENG	☐	MCW_JUMENG	PRZ32V	DEC	6	2	Annual inventory turn (quantity)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S110	BASME	T006	MSEHI
2	S110	EKORG	T024E	EKORG
3	S110	HWAER	TCURC	WAERS
4	S110	MANDT	T000	MANDT
5	S110	MATKL	T023	MATKL
6	S110	PLGTP	TWPT	PLGTP
7	S110	SAISO	T6WSP	SAISO
8	S110	VKORG	TVKO	VKORG
9	S110	VTWEG	TVTW	VTWEG
10	S110	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in