SAP ABAP Table WRMA_S_PVAEN (Revaluation for Retail Price Changes)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-IM (Application Component) Inventory Management
     ⤷ WRMA_PI (Package) Enhancements for Data Derivation for RMA Engine (Retail)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRMA_S_PVAEN	AKTNR	WAKH	AKTNR
2	WRMA_S_PVAEN	BUKRS	T001	BUKRS
3	WRMA_S_PVAEN	BWKEY	T001K	BWKEY
4	WRMA_S_PVAEN	BWTAR	MBEW	BWTAR
5	WRMA_S_PVAEN	HWAER	TCURC	WAERS
6	WRMA_S_PVAEN	LGORT	T001L	LGORT
7	WRMA_S_PVAEN	MANDT	T000	MANDT
8	WRMA_S_PVAEN	MATBF	MARA	MATNR
9	WRMA_S_PVAEN	MATNR	MARA	MATNR
10	WRMA_S_PVAEN	MEINS	T006	MSEHI
11	WRMA_S_PVAEN	PV_GRUND	TWBN	PV_GRUND
12	WRMA_S_PVAEN	VRKME	T006	MSEHI
13	WRMA_S_PVAEN	VWAER	TCURC	WAERS	REF	1	CN
14	WRMA_S_PVAEN	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in	1999_1_46C