I_UtilsPriceItem

Utilities Price Blocks/Items | view: IEPSPRICEITEM | Extraction: Not supported | Component: Utilities Product Integration Layer(UPIL)
Tables used: EPREIEPREIHEPREIT
Column Name Description
UtilsPriceID FK Price
UtilsPriceLevel Price level
UtilsPriceCategory Price category Show values
UtilsPriceItemEndDate Date at Which a Time Slice Expires
UtilsPriceCurrency FK Transaction Currency
UtilsPriceName Text Field
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
UtilsPriceTierType Price type Show values
UtilsTimeCategory Time category (days or months) Show values
Column Name Description Domain name
UtilsPriceToBlock To-block E_ZONE
UtilsTimeBasis Time Basis TIMBASIS
UtilitiesAuthorizationGroup Authorization Group BEGRU
UtilsPriceAmount Price amount PRSBTR
Master Data Relations Join Conditions
Division
  • Client
  • Division
  • I_UTILSPRICEITEM.MANDT == TSPA.MANDT
  • I_UTILSPRICEITEM.DIVISION == TSPA.SPART
Billing Class
  • Billing Class
  • Client
  • I_UTILSPRICEITEM.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • I_UTILSPRICEITEM.MANDT == EAKLASSE.MANDT
Unit of Measurement
  • Unit of Measurement
  • Client
  • I_UTILSPRICEITEM.UTILSMEASUREMENTUNIT == T006.MSEHI
  • I_UTILSPRICEITEM.MANDT == T006.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • I_UTILSPRICEITEM.UTILSPRICECURRENCY == TCURC.WAERS
  • I_UTILSPRICEITEM.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
EPREI
  • Price level
  • Client
  • Price
  • Price category
  • I_UTILSPRICEITEM.UTILSPRICELEVEL == EPREI.PREISTUF
  • I_UTILSPRICEITEM.MANDT == EPREI.MANDT
  • I_UTILSPRICEITEM.UTILSPRICEID == EPREI.PREIS
  • I_UTILSPRICEITEM.UTILSPRICECATEGORY == EPREI.PREISTYP