SAP ABAP Table PVAEN (Revaluation for Retail Price Changes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WBEF (Package) IS-R: Inventory Management

Basic Data

Table Category	INTTAB	Structure
Structure	PVAEN	Table Relationship Diagram
Short Description	Revaluation for Retail Price Changes

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	.INCLUDE	☐				0	0	Retail Revaluation Document: Revaluation Segment
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	UBLNR	☐	UBLNR	UBLNR	CHAR	10	0	Retail revaluation document number	*
4	UBJAHR	☐	UBJAHR	GJAHR	NUMC	4	0	Retail revaluation: document year
5	UZEIL	☐	UZEIL	UZEIL	NUMC	4	0	Item number in retail revaluation document
6	UPSTA	☐	UPSTA	UPSTA	CHAR	1	0	Item status of retail revaluation document
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	MATBF	☐	MATBF	MATNR	CHAR	18	0	Material in Respect of Which Stock is Managed	MARA
13	PV_GRUND	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	TWBN
14	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
15	VPDAT	☐	VPDAT_D	DATUM	DATS	8	0	Date of retail price change
16	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
17	VPNEU	☐	VPNEU	WERTV6	CURR	11	2	New retail price
18	VPALT	☐	VPALT	WERTV6	CURR	11	2	Old retail price
19	VRKPE	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
20	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
21	VWAER	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
22	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
23	VKLAB_OLD	☐	VKLAB	WERT13N	CURR	13	2	Stock value of a value-only material at sales price
24	VKLABN_OLD	☐	VKLAB_NET	WERT13N	CURR	13	2	Stock value of a value-only material at retail w/o tax
25	VKSAL_OLD	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
26	VKSALN_OLD	☐	VKSAL_NET	WERT13N	CURR	13	2	Total inventory value at retail without tax
27	VKSAD	☐	VKSALD	WERT13N	CURR	13	2	Difference Between New and Previous Stock Value
28	VKSADN	☐	VKSALD_NET	WERT13N	CURR	13	2	Difference in retail value without tax
29	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
30	ERFMG	☐	VKUMG	MENG13V	QUAN	13	3	Quantity in unit of entry for revaluation at retail
31	MENGE	☐	MENGV	MENG13V	QUAN	13	3	Quantity with +/- sign in base unit of measure
32	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
33	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
34	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
35	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
36	SPANN	☐	SPANN	XFELD	CHAR	1	0	Flag: not affecting margins
37	EKPA	☐	EKPA_D	WERT11	CURR	11	2	Old cost price
38	EKPN	☐	NPREI	WERT11	CURR	11	2	New Price
39	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
40	SALK3_OLD	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
41	XIVNE	☐	XIVNE	XFELD	CHAR	1	0	Indicates that change in retail value does not affect stock
42	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
43	.INCLU--AP	☐				0	0	Data for Hybrid Method
44	.INCLUDE	☐				0	0	Data for Hybrid Method for Table USEG (Append)
45	.INCLUDE	☐				0	0	Result & Valuation Parameters for Purchase Val. Chg Profile
46	UAKT	☐	UAKT	PRICE_ORIG_CHG_TYPE	CHAR	2	0	Change Category of Sales Price Origin from Old to New Price
47	SALES_VAL_SIGN	☐	VALUE_CHANGE_SIGN	VALUE_CHANGE_SIGN	CHAR	1	0	Sign of Sales Value Change
48	AFFECT_COST_VAL	☐	AFFECT_COST_VAL_RESULT	AFFECT_COST_VAL_RESULT	CHAR	1	0	Adjust Cost Value (Result)
49	.INCLUDE	☐				0	0	History of Revaluation Document
50	VORGA_CREATE	☐	VKPU_VORGA	VKPU_VORGA	CHAR	1	0	Indicates the transaction triggering revaluation at retail
51	MOD_CREATE	☐	MODIFIER_COST_VAL	MODIFIER_COST_VAL	CHAR	1	0	Cost Value Changed By
52	TIME_CREATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
53	VORGA_CHANGE	☐	VKPU_VORGA	VKPU_VORGA	CHAR	1	0	Indicates the transaction triggering revaluation at retail
54	MOD_CHANGE	☐	MODIFIER_COST_VAL	MODIFIER_COST_VAL	CHAR	1	0	Cost Value Changed By
55	TIME_CHANGE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
56	ZEILE	☐	UBLPO	MBLPO	NUMC	4	0	Revaluation document item
57	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
58	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
59	VKKBI	☐	VKKBI	DATUM	DATS	8	0	Sales conditions valid to
60	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
61	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
62	WGBEZ	☐	WGBEZ	TEXT20	CHAR	20	0	Material Group Description
63	BMAKT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
64	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
65	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
66	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
67	LGOBE	☐	LGOBE	TEXT16	CHAR	16	0	Description of Storage Location
68	BWKRS	☐	BWKRS	BWKRS	CHAR	4	0	Field for entering valuation area
69	WNAME	☐	NAME1	TEXT30	CHAR	30	0	Name
70	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
71	VKPE0	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
72	VKPE1	☐	VRKPE	DEC5	DEC	5	0	Sales price unit
73	VKME1	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
74	VKME3	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
75	VKSALA	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
76	VKSALN	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
77	VKSALNN	☐	VKSAL	WERT13N	CURR	13	2	Value of Total Valuated Stock at Sales Price
78	VKLABA	☐	VKLAB	WERT13N	CURR	13	2	Stock value of a value-only material at sales price
79	VKLABN	☐	VKLAB	WERT13N	CURR	13	2	Stock value of a value-only material at sales price
80	VKUMC	☐	VKUMC	WERT13N	CURR	13	2	Stock transfer sales value (plant to plant) for VO material
81	VKUML	☐	VKUML	WERT13N	CURR	13	2	Sales value in stock transfer (SLOc to SLoc)
82	VKTRW	☐	VKTRW	WERT13N	CURR	13	2	Transit value at sales price for value-only material
83	SALK3	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
84	GLDVK	☐	GLDVK	WERTV6	CURR	11	2	Moving average retail price
85	DATAM	☐	DATAM	DATUM	DATS	8	0	Valid on
86	PDIFF	☐	PREISD	WERTV6	CURR	11	2	Price difference
87	HWAE1	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
88	HWAE2	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
89	HWAE3	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
90	VWAE1	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
91	VWAE2	☐	VWAER	WAERS	CUKY	5	0	Sales currency	TCURC
92	KMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
93	PV_GRTXT	☐	BEZEI30	TEXT30	CHAR	30	0	Description
94	BELNR	☐	CDCHANGENR	CDCHANGENR	CHAR	10	0	Document change number
95	WAART	☐	WAART	XFELD	CHAR	1	0	Indicates that material is a value-only material
96	PMATA	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
97	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
98	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
99	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
100	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
101	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
102	KALN1	☐	CK_KALNR1	CK_KALNR	NUMC	12	0	Cost Estimate Number - Product Costing	*
103	PRBLNR	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
104	KJAHR	☐	CK_KJAHR	GJAHR	NUMC	4	0	Material Ledger Document/Price Change Document: Storage Year
105	LOKAB	☐	LOKAB	XFELD	CHAR	1	0	Indicates revaluation at retail for local markdowns
106	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
107	PBIND	☐	PBIND	PBIND	CHAR	1	0	Indicator for price fixing
108	VPDAT_TXT	☐	VPDAT_TXT		CHAR	25	0	Text for price change date field
109	VKSAD_TXT	☐	VKSAD_TXT		CHAR	25	0	Text for stock value difference field
110	UPSTA_TXT	☐	UPSTA_TXT	BEZEI80	CHAR	80	0	Short text for status of a retail revaluation doc. item
111	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
112	AUCHECK	☐	AUCHECK	AUCHECK	INT1	3	0	Field for saving an activity for authorization object
113	VORLAGE	☐	VORLAGE_VKP	XFELD	CHAR	1	0	Indicates if item originates from rtl reval. doc. template
114	XBKNG	☐	XBKNG	XFELD	CHAR	1	0	Negative stocks in valuation area allowed
115	XLONG	☐	XLONG	XFELD	CHAR	1	0	Negative stocks allowed in storage location
116	XMCNG	☐	XMCNG	XFELD	CHAR	1	0	Negative stocks allowed in plant
117	VLGFI	☐	VLGFI	WERKS	CHAR	4	0	Reference Plant of the Category "Store" (Material Master)	*
118	VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
119	VKKAB	☐	VKKAB	DATUM	DATS	8	0	Sales conditions valid from
120	ENDPR_ALT	☐	ENDPR_ALT	WERTV6	CURR	11	2	Final Price According to Previous Conditions
121	XZERO_COUNT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
122	.INCLU--AP	☐				0	0	Price Origin and Purchase Value Change Profile
123	.INCLUDE	☐				0	0	Price Origin and Purchase Value Change Profile
124	PROF_COST_VAL	☐	PROF_COST_VAL	PROF_COST_VAL	CHAR	4	0	Cost Value Change Profile	*
125	PR_ORIG_VPNEU	☐	PRICE_ORIGIN	PRICE_ORIGIN	CHAR	1	0	Origin and Type of Sales Price
126	PR_ORIG_VPALT	☐	PRICE_ORIGIN	PRICE_ORIGIN	CHAR	1	0	Origin and Type of Sales Price
127	PR_ORIG_DET_NEW	☐	PRICE_ORIGIN	PRICE_ORIGIN	CHAR	1	0	Origin and Type of Sales Price
128	PR_ORIG_DET_OLD	☐	PRICE_ORIGIN	PRICE_ORIGIN	CHAR	1	0	Origin and Type of Sales Price

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PVAEN	AKTNR	WAKH	AKTNR
2	PVAEN	BUKRS	T001	BUKRS
3	PVAEN	BWKEY	T001K	BWKEY
4	PVAEN	BWTAR	MBEW	BWTAR
5	PVAEN	BWTTY	T149C	BWTTY
6	PVAEN	HWAE2	TCURC	WAERS
7	PVAEN	HWAER	TCURC	WAERS
8	PVAEN	KMEIN	T006	MSEHI
9	PVAEN	LGORT	T001L	LGORT
10	PVAEN	MANDT	T000	MANDT
11	PVAEN	MATBF	MARA	MATNR
12	PVAEN	MATNR	MARA	MATNR
13	PVAEN	MEINS	T006	MSEHI
14	PVAEN	PV_GRUND	TWBN	PV_GRUND
15	PVAEN	VKORG	TVKO	VKORG
16	PVAEN	VRKME	T006	MSEHI
17	PVAEN	VTWEG	TVTW	VTWEG
18	PVAEN	VWAE1	TCURC	WAERS
19	PVAEN	VWAE2	TCURC	WAERS
20	PVAEN	VWAER	TCURC	WAERS	REF	1	CN
21	PVAEN	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in