USEG

Retail Revaluation Document: Revaluation Segment | #transactional | Component: Sales Price Valuation
Column Name Description
MANDT FK Client
UBLNR Retail revaluation document number
UBJAHR Retail revaluation: document year
UZEIL Item number in retail revaluation document
Column Name Description
💲 Sales currency (VWAER):
ENDPR Final price
VPNEU New retail price
VPALT Old retail price
💲 Local Currency (HWAER):
VKLAB_OLD Stock value of a value-only material at sales price
VKLABN_OLD Stock value of a value-only material at retail w/o tax
VKSAL_OLD Value of Total Valuated Stock at Sales Price
VKSALN_OLD Total inventory value at retail without tax
VKSAD Difference Between New and Previous Stock Value
VKSADN Difference in retail value without tax
EKPA Old cost price
EKPN New Price
WRBTR Amount in Document Currency
SALK3_OLD Value of Total Valuated Stock
Column Name Description
📏 Sales unit (VRKME):
ERFMG Quantity in unit of entry for revaluation at retail
📏 Base Unit of Measure (MEINS):
MENGE Quantity with +/- sign in base unit of measure
LBKUM Total Valuated Stock
Column Name Description
VPDAT Date of retail price change
Column Name Description
UPSTA Item status of retail revaluation document Show values
SPANN Flag: not affecting margins Show values
XIVNE Indicates that change in retail value does not affect stock Show values
SHKZG Debit/Credit Indicator Show values
UAKT Change Category of Sales Price Origin from Old to New Price Show values
SALES_VAL_SIGN Sign of Sales Value Change Show values
AFFECT_COST_VAL Adjust Cost Value (Result) Show values
VORGA_CREATE Indicates the transaction triggering revaluation at retail Show values
MOD_CREATE Cost Value Changed By Show values
VORGA_CHANGE Indicates the transaction triggering revaluation at retail Show values
MOD_CHANGE Cost Value Changed By Show values
Column Name Description Domain name
VRKPE Sales price unit DEC5
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
TIME_CREATE UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
TIME_CHANGE UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • USEG.AKTNR == WAKH.AKTNR
  • USEG.MANDT == WAKH.MANDT
Company Code
  • USEG.MANDT == T001.MANDT
  • USEG.BUKRS == T001.BUKRS
Valuation area
  • Valuation area
  • Client
  • USEG.BWKEY == T001K.BWKEY
  • USEG.MANDT == T001K.MANDT
Valuation Type
  • Material Number
  • Valuation area
  • Valuation Type
  • USEG.MANDT == MBEW.MANDT
  • USEG.MATNR == MBEW.MATNR
  • USEG.BWKEY == MBEW.BWKEY
  • USEG.BWTAR == MBEW.BWTAR
Local Currency
  • USEG.MANDT == TCURC.MANDT
  • USEG.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • USEG.LGORT == T001L.LGORT
  • USEG.MANDT == T001L.MANDT
  • USEG.WERKS == T001L.WERKS
Client USEG.MANDT == T000.MANDT
Material in Respect of Which Stock is Managed
  • Material in Respect of Which Stock is Managed
  • Client
  • USEG.MATBF == MARA.MATNR
  • USEG.MANDT == MARA.MANDT
Material Number
  • Material Number
  • Client
  • USEG.MATNR == MARA.MATNR
  • USEG.MANDT == MARA.MANDT
Base Unit of Measure
  • USEG.MANDT == T006.MANDT
  • USEG.MEINS == T006.MSEHI
Reason for retail price change
  • USEG.MANDT == TWBN.MANDT
  • USEG.PV_GRUND == TWBN.PV_GRUND
Sales unit
  • USEG.MANDT == T006.MANDT
  • USEG.VRKME == T006.MSEHI
Sales Currency
  • USEG.MANDT == TCURC.MANDT
  • USEG.VWAER == TCURC.WAERS
Plant
  • USEG.MANDT == T001W.MANDT
  • USEG.WERKS == T001W.WERKS