I_UtilsPriceItemHistory

Utilities Price Blocks/Items History | view: IEUILPRICEITEM | Extraction: Not supported | Component: Utilities Product Integration Layer(UPIL)
Tables used: EPREIEPREIH
Column Name Description
UtilsPriceID FK Price
UtilsPriceCategory Price category Show values
UtilsPriceItemEndDate Date at Which a Time Slice Expires
UtilsPriceCurrency FK Transaction Currency
UtilsPriceFromBlock From-block
Column Name Description
Column Name Description
Column Name Description
UtilsPriceItemEndDate Date at Which a Time Slice Expires
UtilsPriceItemStartDate Date from which time slice is valid
Column Name Description
UtilsPriceCategory Price category Show values
Column Name Description Domain name
UtilsPriceToBlock To-block E_ZONE
UtilitiesBaseQuantity Long quantity base for amount MENGENBAS
UtilsPriceAmount Price amount PRSBTR
UtilitiesAuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Division
  • Client
  • Division
  • I_UTILSPRICEITEMHISTORY.MANDT == TSPA.MANDT
  • I_UTILSPRICEITEMHISTORY.DIVISION == TSPA.SPART
Billing Class
  • Billing Class
  • Client
  • I_UTILSPRICEITEMHISTORY.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • I_UTILSPRICEITEMHISTORY.MANDT == EAKLASSE.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • I_UTILSPRICEITEMHISTORY.MANDT == TCURC.MANDT
  • I_UTILSPRICEITEMHISTORY.UTILSPRICECURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
EPREI
  • ?
  • Client
  • Price category
  • Price
  • I_UTILSPRICEITEMHISTORY.[column in domain "PREISTUF"] == EPREI.PREISTUF
  • I_UTILSPRICEITEMHISTORY.MANDT == EPREI.MANDT
  • I_UTILSPRICEITEMHISTORY.UTILSPRICECATEGORY == EPREI.PREISTYP
  • I_UTILSPRICEITEMHISTORY.UTILSPRICEID == EPREI.PREIS