C_UtilsProductFactValue

Billing Fact Value for UPIL Product | view: CPSUTILFACTVALUE | Extraction: Not supported | Component: Utilities Product Integration Layer(UPIL)
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
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
UtilsProductEntryValue Entry value (installed value) for a device OPWERT
Master Data Relations Join Conditions
Rate Type
  • Client
  • Rate Type
  • C_UTILSPRODUCTFACTVALUE.MANDT == TE069.MANDT
  • C_UTILSPRODUCTFACTVALUE.UTILITIESBILLINGRATETYPE == TE069.TARIFART
Utilities Product ID
  • Client
  • Region Code
  • Utilities Product ID
Operand
  • Client
  • Operand
  • C_UTILSPRODUCTFACTVALUE.MANDT == TE221.MANDT
  • C_UTILSPRODUCTFACTVALUE.UTILSBILLINGOPERAND == TE221.OPERAND
Rate fact group
  • Client
  • Rate fact group
  • C_UTILSPRODUCTFACTVALUE.MANDT == TE067.MANDT
  • C_UTILSPRODUCTFACTVALUE.UTILSBILLINGRATEFACTGRP == TE067.KONDIGR
Utilities Product Type
  • Client
  • Utilities Product Type
Season
  • Client
  • Season
  • C_UTILSPRODUCTFACTVALUE.MANDT == TE221.MANDT
  • C_UTILSPRODUCTFACTVALUE.UTILSSEASON == TE221.OPERAND