ORIG_PR_MBEW

Sales Price Origin of Last Total Revaluation at Retail | #masterdata | Component: Sales Price Valuation
Column Name Description
MANDT FK Client
MATNR FK Material Number
BWKEY FK Valuation area
BWTAR Valuation Type
Column Name Description
💲 Sales currency (VWAER):
VPNEU New retail price
💲 Sales currency (VWAER_NP):
VPNEU_NP New retail price
Column Name Description
Column Name Description
VPDAT Date of retail price change
BUDAT Posting Date in the Document
VPDAT_NP Date of retail price change
VPDAT_CHG Date of retail price change
Column Name Description
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
VKPU_VORGA Indicates the transaction triggering revaluation at retail Show values
MOD_COST_VAL Cost Value Changed By Show values
UAKT_CHG Change Category of Sales Price Origin from Old to New Price Show values
SIGN_CHG Sign of Sales Value Change Show values
Column Name Description Domain name
VRKPE Sales price unit DEC5
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
VRKPE_NP Sales price unit DEC5
TIMESTAMP_NP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Valuation area
  • Valuation area
  • Client
  • ORIG_PR_MBEW.BWKEY == T001K.BWKEY
  • ORIG_PR_MBEW.MANDT == T001K.MANDT
Client ORIG_PR_MBEW.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • ORIG_PR_MBEW.MATNR == MARA.MATNR
  • ORIG_PR_MBEW.MANDT == MARA.MANDT
Sales unit
  • ORIG_PR_MBEW.MANDT == T006.MANDT
  • ORIG_PR_MBEW.VRKME == T006.MSEHI
Sales currency
  • ORIG_PR_MBEW.MANDT == TCURC.MANDT
  • ORIG_PR_MBEW.VWAER == TCURC.WAERS
Plant
  • ORIG_PR_MBEW.MANDT == T001W.MANDT
  • ORIG_PR_MBEW.WERKS == T001W.WERKS