SAP ABAP Table VPMMS110 (Include Structure for STA: SPw/VAT)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCP2 (Package) R/3 application development: Sales & Operations Planning

Basic Data

Table Category	INTTAB	Structure
Structure	VPMMS110	Table Relationship Diagram
Short Description	Include Structure for STA: SPw/VAT

Delivery and Maintenance

Pool/cluster
Delivery Class
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	*
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	*
9	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
10	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
11	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
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	*
15	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	*
16	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
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	*
20	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
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	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
24	UMSMAM	☐	MCW_UMSMAM	PRZ32V	DEC	6	2	Sales margin with tax
25	PRSNLS	☐	MCW_PRSNLS	WERTV10	CURR	19	2	Sales deviation during sales
26	BSTGVP	☐	MCW_BSTGVP	WERTV10	CURR	19	2	Stock at retail with tax
27	BSTMNG	☐	MCW_BSTMNG	MENGV15_3	QUAN	15	3	Stock quantity in base unit of measure
28	BSTPROZ	☐	BESTPROZ	FLTP	FLTP	16	16	Stock as % of sales volume
29	UBGVP	☐	MCW_UBGVP	WERTV10	CURR	19	2	Revaluations at sales price including tax
30	UBMNG	☐	UBMNG	MENGV15_3	QUAN	15	3	Revaluation quantity in BUn
31	UBPROZ	☐	UBPROZ	FLTP	FLTP	16	16	Revaluations as a percentage
32	BKIVP	☐	MCW_BKIVP	WERTV10	CURR	19	2	Stock adjustments: inventory difference at sales price + tax
33	BKIMNG	☐	BKIMNG	MENGV15_3	QUAN	15	3	Stock adjustments: inventory differences as base unit qty
34	BKIPROZ	☐	BKIPROZ	FLTP	FLTP	16	16	Stock adjustments: inventory differences as a %
35	SBUDGVP	☐	GLIMGVP	WERTV10	CURR	19	2	Seasonal budget at sales price including tax
36	SBUDMNG	☐	GLIMMNG	MENGV15_3	QUAN	15	3	Seasonal budget - quantity in base unit (BUn)
37	VQUOTEPROZ	☐	VERT_LIM	FLTP	FLTP	16	16	Initial purchasing quota (%)
38	VLIMGVP	☐	VBUDGVP	WERTV10	CURR	19	2	Budget already released at sales price including VAT
39	VBUDMNG	☐	VLIMMNG	MENGV15_3	QUAN	15	3	Budget Already Released - Quantity (Base Unit of Measure)
40	RLIMGVP	☐	RBUDGVP	WERTV10	CURR	19	2	Reserve budget SPwT
41	RLIMMNG	☐	RLIMMNG	MENGV15_3	QUAN	15	3	Reserve budget quantity in base unit of measure (BUn)
42	BBSGVP	☐	MCW_BBSGVP	WERTV10	CURR	19	2	On-order stock at retail with tax
43	BBSMNG	☐	MCW_BBSMNG	MENGV15_3	QUAN	15	3	On-order stock quantity in BUn
44	ULBBSGVP	☐	ULBBSGVP	WERTV10	CURR	19	2	Open stock transport orders (delivering plant) at SPw/VAT
45	ULBBSMNG	☐	ULBBSMNG	MENGV15_3	QUAN	15	3	Open stock transport order qty (supplying plant) in BUn
46	UBBSGVP	☐	UBBSGVP	WERTV10	CURR	19	2	Open stock transport orders at sales price including tax
47	UBBSMNG	☐	UBBSMNG	MENGV15_3	QUAN	15	3	Open stock transport order quantity in BUn
48	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
49	ZUGMNG	☐	MCW_ZUGMNG	MENGV15_3	QUAN	15	3	Receipts quantity in BUn
50	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
51	ABGMNG	☐	MCW_ABGMNG	MENGV15_3	QUAN	15	3	Issues quantity in BUn
52	SOTBGVP	☐	OTBSGVP	WERTV10	CURR	19	2	OTB of seasonal budget at sales price including tax
53	SOTBMNG	☐	OTBSMNG	MENGV15_3	QUAN	15	3	OTB of seasonal budget in quantity of base unit
54	VOTBGVP	☐	OTBVGVP	WERTV10	CURR	19	2	OTB of budget already released at sales price including tax
55	VOTBMNG	☐	OTBVMNG	MENGV15_3	QUAN	15	3	Open-to-buy of budget already released in qty of base unit
56	AVGVP	☐	AVGVP	WERTV10	CURR	19	2	Average price of price band at sales price with tax

History

Last changed by/on	SAP	20050411
SAP Release Created in