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