0RT_MBEW_PRICE_ATTR

Sales Price Origin of Last Total Revaluation at Retail | #ATTR | Extraction method: V | Delta: NEWE | Component: Master Data Retail
Tables used: ORIG_PR_MBEW → show details
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
  • 0RT_MBEW_PRICE_ATTR.BWKEY == T001K.BWKEY
  • 0RT_MBEW_PRICE_ATTR.MANDT == T001K.MANDT
Client 0RT_MBEW_PRICE_ATTR.MANDT == T000.MANDT
Material Number
  • 0RT_MBEW_PRICE_ATTR.MANDT == MARA.MANDT
  • 0RT_MBEW_PRICE_ATTR.MATNR == MARA.MATNR
Plant
  • 0RT_MBEW_PRICE_ATTR.MANDT == T001W.MANDT
  • 0RT_MBEW_PRICE_ATTR.WERKS == T001W.WERKS