| MANDT |
Client |
CLNT |
3 |
0 |
T000
|
MANDT
|
|
| UBLNR |
Retail revaluation document number |
CHAR |
10 |
0 |
*
|
UBLNR
|
|
| UBJAHR |
Retail revaluation: document year |
NUMC |
4 |
0 |
|
UBJAHR
|
|
| UZEIL |
Item number in retail revaluation document |
NUMC |
4 |
0 |
|
UZEIL
|
|
| UPSTA |
Item status of retail revaluation document |
CHAR |
1 |
0 |
|
UPSTA
|
| A |
Count still to be carried out |
| B |
Count complete, revaluation not yet taken place |
| C |
Revaluation carried out |
| D |
Items with errors, marked for deletion |
|
| BUKRS |
Company Code |
CHAR |
4 |
0 |
T001
|
BUKRS
|
|
| BWKEY |
Valuation area |
CHAR |
4 |
0 |
T001K
|
BWKEY
|
|
| WERKS |
Plant |
CHAR |
4 |
0 |
T001W
|
WERKS_D
|
|
| LGORT |
Storage location |
CHAR |
4 |
0 |
T001L
|
LGORT_D
|
|
| MATNR |
Material Number |
CHAR |
40 |
0 |
MARA
|
MATNR
|
|
| MATBF |
Material in Respect of Which Stock is Managed |
CHAR |
40 |
0 |
MARA
|
MATBF
|
|
| PV_GRUND |
Reason for retail price change |
CHAR |
4 |
0 |
TWBN
|
PV_GRUND
|
|
| BWTAR |
Valuation Type |
CHAR |
10 |
0 |
MBEW
|
BWTAR_D
|
|
| VPDAT |
Date of retail price change |
DATS |
8 |
0 |
|
VPDAT_D
|
|
| ENDPR |
Final price |
CURR |
11 |
2 |
|
ENDPR
|
|
| VPNEU |
New retail price |
CURR |
11 |
2 |
|
VPNEU
|
|
| VPALT |
Old retail price |
CURR |
11 |
2 |
|
VPALT
|
|
| VRKPE |
Sales price unit |
DEC |
5 |
0 |
|
VRKPE
|
|
| VRKME |
Sales unit |
UNIT |
3 |
0 |
T006
|
VRKME
|
|
| VWAER |
Sales currency |
CUKY |
5 |
0 |
TCURC
|
VWAER
|
|
| AKTNR |
Promotion |
CHAR |
10 |
0 |
WAKH
|
WAKTION
|
|
| VKLAB_OLD |
Stock value of a value-only material at sales price |
CURR |
13 |
2 |
|
VKLAB
|
|
| VKLABN_OLD |
Stock value of a value-only material at retail w/o tax |
CURR |
13 |
2 |
|
VKLAB_NET
|
|
| VKSAL_OLD |
Value of Total Valuated Stock at Sales Price |
CURR |
13 |
2 |
|
VKSAL
|
|
| VKSALN_OLD |
Total inventory value at retail without tax |
CURR |
13 |
2 |
|
VKSAL_NET
|
|
| VKSAD |
Difference Between New and Previous Stock Value |
CURR |
13 |
2 |
|
VKSALD
|
|
| VKSADN |
Difference in retail value without tax |
CURR |
13 |
2 |
|
VKSALD_NET
|
|
| HWAER |
Local Currency |
CUKY |
5 |
0 |
TCURC
|
HWAER
|
|
| ERFMG |
Quantity in unit of entry for revaluation at retail |
QUAN |
13 |
3 |
|
VKUMG
|
|
| MENGE |
Quantity with +/- sign in base unit of measure |
QUAN |
13 |
3 |
|
MENGV
|
|
| LBKUM |
Total Valuated Stock |
QUAN |
13 |
3 |
|
LBKUM
|
|
| MEINS |
Base Unit of Measure |
UNIT |
3 |
0 |
T006
|
MEINS
|
|
| UMVKZ |
Numerator (factor) for conversion of sales quantity into SKU |
DEC |
5 |
0 |
|
UMVKZ
|
|
| UMVKN |
Denominator (divisor) for conversion of sales Qty into SKU |
DEC |
5 |
0 |
|
UMVKN
|
|
| SPANN |
Flag: not affecting margins |
CHAR |
1 |
0 |
|
SPANN
|
|
| EKPA |
Old cost price |
CURR |
11 |
2 |
|
EKPA_D
|
|
| EKPN |
New Price |
CURR |
11 |
2 |
|
NPREI
|
|
| WRBTR |
Amount in Document Currency |
CURR |
13 |
2 |
|
WRBTR_CS
|
|
| SALK3_OLD |
Value of Total Valuated Stock |
CURR |
13 |
2 |
|
SALK3
|
|
| XIVNE |
Indicates that change in retail value does not affect stock |
CHAR |
1 |
0 |
|
XIVNE
|
|
| SHKZG |
Debit/Credit Indicator |
CHAR |
1 |
0 |
|
SHKZG
|
|
| UAKT |
Change Category of Sales Price Origin from Old to New Price |
CHAR |
2 |
0 |
|
UAKT
|
|
| SALES_VAL_SIGN |
Sign of Sales Value Change |
CHAR |
1 |
0 |
|
VALUE_CHANGE_SIGN
|
| + |
Increase in Sales Value |
| - |
Decrease in Sales Value |
| 0 |
No Change to Sales Value |
|
| AFFECT_COST_VAL |
Adjust Cost Value (Result) |
CHAR |
1 |
0 |
|
AFFECT_COST_VAL_RESULT
|
|
Undefined |
| 1 |
Purchase Value Change (Profile) |
| 2 |
Purchase Value Change (Partial Revaluation) |
| 3 |
Purchase Value Change (No Profile) |
| 4 |
Purchase Value Change (No Activation of Value-Only Material) |
| 5 |
No Purchase Value Change (Affecting Margins) |
| 6 |
No Purchase Value Change (Profile) |
| 7 |
No Purchase Value Change (Zero Count) |
| 8 |
No Purchase Value Change (BAdI) |
| 9 |
Purchase Value Change (BAdI) |
|
| VORGA_CREATE |
Indicates the transaction triggering revaluation at retail |
CHAR |
1 |
0 |
|
VKPU_VORGA
|
| 1 |
Call revaluation at retail from report RWVKU001 |
| 2 |
Call revaluation at retail from dialog transaction |
| 3 |
Call revaluation at retail via POS inbound |
| 4 |
Call revaluation at retail via SAP Retail Store |
| 5 |
Call revaluation at retail for status changes from B to C |
|
| MOD_CREATE |
Cost Value Changed By |
CHAR |
1 |
0 |
|
MODIFIER_COST_VAL
|
|
Undefined |
| 1 |
Automatic Total Revaluation |
| 2 |
Total Revaluation Screen |
| 3 |
Partial Revaluation Screen |
| 4 |
Initialization/Correction of Sales Price Valuation |
| 5 |
Stock Counting |
| 6 |
Automatic Total Revaluation (No Stock) |
| 7 |
Total Revaluation (Price Origin Change) |
|
| TIME_CREATE |
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
DEC |
15 |
0 |
|
TIMESTAMP
|
|
| VORGA_CHANGE |
Indicates the transaction triggering revaluation at retail |
CHAR |
1 |
0 |
|
VKPU_VORGA
|
| 1 |
Call revaluation at retail from report RWVKU001 |
| 2 |
Call revaluation at retail from dialog transaction |
| 3 |
Call revaluation at retail via POS inbound |
| 4 |
Call revaluation at retail via SAP Retail Store |
| 5 |
Call revaluation at retail for status changes from B to C |
|
| MOD_CHANGE |
Cost Value Changed By |
CHAR |
1 |
0 |
|
MODIFIER_COST_VAL
|
|
Undefined |
| 1 |
Automatic Total Revaluation |
| 2 |
Total Revaluation Screen |
| 3 |
Partial Revaluation Screen |
| 4 |
Initialization/Correction of Sales Price Valuation |
| 5 |
Stock Counting |
| 6 |
Automatic Total Revaluation (No Stock) |
| 7 |
Total Revaluation (Price Origin Change) |
|
| TIME_CHANGE |
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
DEC |
15 |
0 |
|
TIMESTAMP
|
|
| EKORG |
Purchasing organization |
CHAR |
4 |
0 |
T024E
|
EKORG
|
|
| VKORG |
Sales Organization |
CHAR |
4 |
0 |
TVKO
|
VKORG
|
|
| VTWEG |
Distribution Channel |
CHAR |
2 |
0 |
TVTW
|
VTWEG
|
|
| BZIRK |
Sales District |
CHAR |
6 |
0 |
T171
|
BZIRK
|
|
| EKSGB |
Purchasing area |
CHAR |
4 |
0 |
T026
|
EKSGB
|
|
| EKGRP |
Purchasing Group |
CHAR |
3 |
0 |
T024
|
EKGRP
|
|
| DISPO |
MRP Controller |
CHAR |
3 |
0 |
T024D
|
DISPO
|
|
| LTSNR |
Supplier Subrange |
CHAR |
6 |
0 |
WYT1
|
LTSNR
|
|
| BTRKZ |
Plant category |
CHAR |
1 |
0 |
|
VLFKZ
|
| A |
Store |
| B |
Distribution Center |
|
| ABTNR |
Department number |
CHAR |
4 |
0 |
TSAB
|
ABTNR
|
|
| WGRU2 |
Material group hierarchy 2 |
CHAR |
18 |
0 |
|
MCW_WGRU2
|
|
| WGRU1 |
Material group hierarchy 1 |
CHAR |
18 |
0 |
|
MCW_WGRU1
|
|
| MATKL |
Material Group |
CHAR |
9 |
0 |
T023
|
MATKL
|
|
| PRDHA |
Product hierarchy |
CHAR |
18 |
0 |
T179
|
PRODH_D
|
|
| SATNR |
Cross-Plant Configurable Material |
CHAR |
40 |
0 |
MARA
|
SATNR
|
|
| MERK1 |
Characteristic 1 |
CHAR |
70 |
0 |
|
MCW_MERK1
|
|
| MERK2 |
Characteristic 2 |
CHAR |
70 |
0 |
|
MCW_MERK2
|
|
| MERK3 |
Characteristic 3 |
CHAR |
70 |
0 |
|
MCW_MERK3
|
|
| AKTYP |
Promotion Category |
CHAR |
4 |
0 |
TWTY
|
W_AKTYP
|
|
| AKTHE |
Promotion theme |
CHAR |
4 |
0 |
TWAT
|
W_AKTHE
|
|
| PLGTP |
Price Band Category |
CHAR |
2 |
0 |
TWPT
|
PLGTP
|
|
| SAISO |
Season Category |
CHAR |
4 |
0 |
T6WSP
|
SAISO
|
|
| SAISJ |
Season Year |
CHAR |
4 |
0 |
|
SAISJ
|
|
| BWVOR |
Procurement rule |
CHAR |
1 |
0 |
T6WP1
|
BWVOR
|
|
| BWSCL |
Source of Supply |
CHAR |
1 |
0 |
T6WP2
|
BWSCL
|
|
| SERVG |
IS-R service level |
CHAR |
1 |
0 |
TWSG
|
W_SERVGRD
|
|
| BRGEW |
Gross weight |
QUAN |
13 |
3 |
|
BRGEW
|
|
| NTGEW |
Net weight |
QUAN |
13 |
3 |
|
NTGEW
|
|
| GEWEI |
Weight Unit |
UNIT |
3 |
0 |
T006
|
GEWEI
|
|
| VOLUM |
Volume |
QUAN |
13 |
3 |
|
VOLUM
|
|
| VOLEH |
Volume unit |
UNIT |
3 |
0 |
T006
|
VOLEH
|
|
| LIFNR |
Account number of regular vendor |
CHAR |
10 |
0 |
LFA1
|
MCW_RLIFN
|
|
| LAND1 |
Country/Region of regular vendor |
CHAR |
3 |
0 |
T005
|
MCW_LANDRL
|
|
| MTART |
Material type |
CHAR |
4 |
0 |
T134
|
MTART
|
|
| WMAKG |
Material Type ID |
CHAR |
1 |
0 |
|
WMAK
|
|
General material type |
| 1 |
Material type for value-only materials |
| 2 |
Material type for empties |
| 3 |
Material type for catalog variants |
| 4 |
Material type for perishables |
| 5 |
Material type for additionals |
| 6 |
Material type for coupons |
|
| WRKGR2 |
Plant group hierarchy 2 |
CHAR |
18 |
0 |
|
MCW_WRKGR2
|
|
| WRKGR1 |
Plant group hierarchy 1 |
CHAR |
18 |
0 |
|
MCW_WRKGR1
|
|
| EAN11 |
International Article Number (EAN/UPC) |
CHAR |
18 |
0 |
|
EAN11
|
|
| IDNLF |
Material Number Used by Supplier |
CHAR |
35 |
0 |
|
IDNLF
|
|
| KOLIF |
Prior Supplier |
CHAR |
10 |
0 |
LFA1
|
KOLIF
|
|
| ATINM1 |
Internal characteristic number, characteristic 1 |
NUMC |
10 |
0 |
*
|
MCW_ATINM1
|
|
| ATINM2 |
Internal characteristic number, characteristic 2 |
NUMC |
10 |
0 |
*
|
MCW_ATINM2
|
|
| ATINM3 |
Internal characteristic number, characteristic 3 |
NUMC |
10 |
0 |
*
|
MCW_ATINM3
|
|
| ATTYP |
Material Category |
CHAR |
2 |
0 |
|
ATTYP
|
|
Product |
| 00 |
Single material |
| 01 |
Generic material |
| 02 |
Variant |
| 10 |
Sales set |
| 11 |
Prepack |
| 12 |
Display |
| 20 |
Material group material |
| 21 |
Hierarchy material |
| 22 |
Group material |
| 30 |
Material group reference material |
|
| STRNR |
Structured material |
CHAR |
40 |
0 |
MARA
|
STRNR
|
|
| UBPEPM |
Revaluation at cost, plus, quantity |
QUAN |
15 |
3 |
|
MCW_UBPEPM
|
|
| UBPGEO |
Revaluation at cost, plus |
CURR |
19 |
2 |
|
MCW_UBPGEO
|
|
| UBMEPM |
Revaluation at cost minus, quantity |
QUAN |
15 |
3 |
|
MCW_UBMEPM
|
|
| UBMGEO |
Revaluation at cost, minus |
CURR |
19 |
2 |
|
MCW_UBMGEO
|
|
| UBPVPM |
Revaluation at retail, plus, quantity |
QUAN |
15 |
3 |
|
MCW_UBPVPM
|
|
| UBPGVO |
Revaluation at retail, plus |
CURR |
19 |
2 |
|
MCW_UBPGVO
|
|
| UBPGVP |
Revaluation at retail, plus, at retail with tax |
CURR |
19 |
2 |
|
MCW_UBPGVP
|
|
| UBMVPM |
Revaluation at retail, minus, quantity |
QUAN |
15 |
3 |
|
MCW_UBMVPM
|
|
| UBMGVO |
Revaluation at retail, minus |
CURR |
19 |
2 |
|
MCW_UBMGVO
|
|
| UBMGVP |
Revaluation at retail, minus, at retail with tax |
CURR |
19 |
2 |
|
MCW_UBMGVP
|
|
| ABGGEO |
Issues at cost |
CURR |
19 |
2 |
|
MCW_ABGGEO
|
|
| ABGGVO |
Issues at retail |
CURR |
19 |
2 |
|
MCW_ABGGVO
|
|
| ABGGVP |
Issues at retail with tax |
CURR |
19 |
2 |
|
MCW_ABGGVP
|
|
| ZUGGEO |
Receipts at cost |
CURR |
19 |
2 |
|
MCW_ZUGGEO
|
|
| ZUGGVO |
Receipts at retail |
CURR |
19 |
2 |
|
MCW_ZUGGVO
|
|
| ZUGGVP |
Receipts at retail with tax |
CURR |
19 |
2 |
|
MCW_ZUGGVP
|
|
| DPFLG |
Indicator: duplicated record |
CHAR |
1 |
0 |
|
MCW_DPFLAG
|
|
| ERFME |
Unit of entry |
UNIT |
3 |
0 |
T006
|
ERFME
|
|
| WKUNNR |
Customer Number of Plant |
CHAR |
10 |
0 |
KNA1
|
KUNNR_WK
|
|
| BIWMNG |
RIS/Reporting Server - Transfer base quantity |
QUAN |
15 |
3 |
|
MCW_BIWMNG
|
|
| BIWMVE |
RIS/Reporting Server - Transfer quantity sold |
QUAN |
15 |
3 |
|
MCW_BIWMVE
|
|
| BIWGEO |
RIS/Reporting Server - Transfer cost price |
CURR |
19 |
2 |
|
MCW_BIWGEO
|
|
| BIWGVO |
RIS/Reporting Server - Transfer retail price |
CURR |
19 |
2 |
|
MCW_BIWGVO
|
|
| BIWGVP |
RIS/Reporting Server - Transfer retail price with tax |
CURR |
19 |
2 |
|
MCW_BIWGVP
|
|
| BRELEV |
RIS/Reporting Server - stock relevance |
CHAR |
1 |
0 |
|
MCW_BRELEV
|
|
| NEUAUF_BEW |
Indicator: Statistical setup - Inventory Controlling |
CHAR |
1 |
0 |
|
NEUAUF_BEW
|
|
| BWVORG |
SAP BW transaction key |
NUMC |
3 |
0 |
|
MCW_BWVORG
|
|
| FILGRP |
Store Group |
NUMC |
2 |
0 |
TWISPC_FILGRP
|
WISP_FILGRP
|
|
| PSWAE |
Database Currency for Planning Data in a Planning Scenario |
CUKY |
5 |
0 |
TCURC
|
WISP_PSWAE
|
|
| PLMHT |
Planned Unit of Measure |
UNIT |
3 |
0 |
T006
|
WISP_PLMHT
|
|
| ASORT |
Assortment |
CHAR |
10 |
0 |
WRS1
|
ASORT
|
|
| AVGW1 |
Memory Currency 1 in Currency Fields for Average Retail |
CUKY |
5 |
0 |
TCURC
|
WISP_AVGW1
|
|
| AVGW2 |
Memory Currency 2 for Currency Fields for Average Retail |
CUKY |
5 |
0 |
TCURC
|
WISP_AVGW2
|
|
| DUMMY |
Dummy function in length 1 |
CHAR |
1 |
0 |
|
DUMMY
|
|
| BWMNG |
BW: Quantity in Base Unit of Measure |
QUAN |
15 |
3 |
|
MCBW_MNG
|
|
| BWMVE |
BW: Quantity in Sales Unit |
QUAN |
15 |
3 |
|
MCBW_MVE
|
|
| BWGEO |
BW: Cost Value in Local Currency |
CURR |
19 |
2 |
|
MCBW_GEO
|
|
| BWGVO |
BW: Retail Value in Local Currency |
CURR |
19 |
2 |
|
MCBW_GVO
|
|
| BWGVP |
BW: Retail Value with Tax in Local Currency |
CURR |
19 |
2 |
|
MCBW_GVP
|
|
| BWBREL |
BW: Stock Relevance |
CHAR |
1 |
0 |
|
MCBW_BREL
|
|
| BWAPPLNM |
Application Component |
CHAR |
30 |
0 |
|
RSAPPLNM
|
|
| BWEXT_REL |
Relevant Valuation Method |
CHAR |
1 |
0 |
|
WRMA_BWEXT_REL
|
|
All Valuation Methods |
| C |
Valuation at Cost Price |
| R |
Traditional Retail Valuation Method |
|