WRF_ORGPR_HIST

History: Original Price Change | #masterdata | Component: Article
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
DATAB Validity start date of the condition record
TIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Column Name Description
💲 Sales currency (VWAER_BT):
VPR_BT Gross Price
💲 Sales currency (VWAER_NT):
VPR_NT Net Price
Column Name Description
Column Name Description
DATAB Validity start date of the condition record
DATBI Validity end date of the condition record
VPDAT Date of retail price change
Column Name Description
ORIGIN Origin of Original Price Show values
Column Name Description Domain name
VRKPE_BT Sales price unit DEC5
VRKPE_NT Sales price unit DEC5
FREE_TXT Free Text for Original Price Change TEXT50
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Client WRF_ORGPR_HIST.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • WRF_ORGPR_HIST.MATNR == MARA.MATNR
  • WRF_ORGPR_HIST.MANDT == MARA.MANDT
Reason for Original Price Change
Sales unit
  • WRF_ORGPR_HIST.MANDT == T006.MANDT
  • WRF_ORGPR_HIST.VKMEIN_BT == T006.MSEHI
Sales unit
  • WRF_ORGPR_HIST.MANDT == T006.MANDT
  • WRF_ORGPR_HIST.VKMEIN_NT == T006.MSEHI
Sales currency
  • WRF_ORGPR_HIST.MANDT == TCURC.MANDT
  • WRF_ORGPR_HIST.VWAER_BT == TCURC.WAERS
Sales currency
  • WRF_ORGPR_HIST.MANDT == TCURC.MANDT
  • WRF_ORGPR_HIST.VWAER_NT == TCURC.WAERS
Plant
  • WRF_ORGPR_HIST.MANDT == T001W.MANDT
  • WRF_ORGPR_HIST.WERKS == T001W.WERKS