I_UtilsProductFactValue

Billing Fact values for UPIL Product | view: IEPSPRODFACTVAL | Extraction: Not supported | Component: Utilities Product Integration Layer(UPIL)
Tables used: ISUD_PS_PRODFACT
Column Name Description
UtilitiesProduct FK Utilities Product ID
UtilsProductRegion Region Code
UtilsBillingOperand FK Operand
UtilsSeason FK Season
Column Name Description
💲 Currency Key (UtilsProductFactCurrency):
UtilsProductFactAmount Currency-dependent amount
Column Name Description
Column Name Description
UtilsProductFactStartDate Date from which time slice is valid
UtilsProductFactEndDate Date at Which a Time Slice Expires
Column Name Description
Column Name Description Domain name
UtilsProductEntryValue Entry value (installed value) for a device OPWERT
UtilsProductBillingValue Value to be billed OPWERT
UtilsBillingFactKey1 First Key Field for Operand Value CHAR10
UtilsBillingFactKey2 Second key field for operand value CHAR10
UtilsBillingFactKey3 Third key field for operand value CHAR1
UtilsBillingFactKey4 Fourth key field for operand value CHAR1
Master Data Relations Join Conditions
Rate Type
  • Rate Type
  • Client
  • I_UTILSPRODUCTFACTVALUE.UTILITIESBILLINGRATETYPE == TE069.TARIFART
  • I_UTILSPRODUCTFACTVALUE.MANDT == TE069.MANDT
Utilities Product ID
  • Region Code
  • Utilities Product ID
  • Client
Operand
  • Operand
  • Client
  • I_UTILSPRODUCTFACTVALUE.UTILSBILLINGOPERAND == TE221.OPERAND
  • I_UTILSPRODUCTFACTVALUE.MANDT == TE221.MANDT
Rate fact group
  • Rate fact group
  • Client
  • I_UTILSPRODUCTFACTVALUE.UTILSBILLINGRATEFACTGRP == TE067.KONDIGR
  • I_UTILSPRODUCTFACTVALUE.MANDT == TE067.MANDT
Season
  • Season
  • Client
  • I_UTILSPRODUCTFACTVALUE.UTILSSEASON == TE221.OPERAND
  • I_UTILSPRODUCTFACTVALUE.MANDT == TE221.MANDT