C_SpprsdUtilsBillgOrdWthDets

Suppressed Utilities Billing Order with Details | view: CESPPRDBIORDD | Extraction: Not supported | Component: Contract Billing
Tables used: EABL, EABLG, ETRG, TE417, EUITRANS, EUIINSTLN, TFK001G, TFK002F, T001, TKA02, FKKVKP, EVER, EANLH, ETDZ
Column Name Description
UtilitiesContract Contract
UtilitiesInstallation FK Installation
SuppressedUtilsSchedldBillgDte Prioritized Scheduled Billing Date
SuppressedUtilsBillgReason Prioritized Billing Reason Show values
Column Name Description
Column Name Description
Column Name Description
SuppressedUtilsSchedldBillgDte Prioritized Scheduled Billing Date
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
ScheduledUtilitiesBillingDate Scheduled Billing Date
ScheduledMeterReadingDate Scheduled Meter Reading Date
Column Name Description
SuppressedUtilsBillgReason Prioritized Billing Reason Show values
UtilitiesBillingReason Billing Reason Show values
UtilsContrIsActvSchedldBillg Contract is Active for Scheduled Billing Show values
MeterReadingStatusGroup Meter Reading Status Group Show values
Column Name Description Domain name
UtilsBillgOrdDetailedStatus Prioritized Billing Order Status
UtilsExternalPointOfDelivery Point of Delivery ID EXT_UI
MeterReadingReason Meter reading reason ABLESGR
NmbrOfImplausibleMtrRdngRslts null
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Client
  • C_SPPRSDUTILSBILLGORDWTHDETS.BUSINESSPARTNER == BUT000.PARTNER
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == BUT000.CLIENT
Company Code
  • Company Code
  • Client
  • C_SPPRSDUTILSBILLGORDWTHDETS.COMPANYCODE == T001.BUKRS
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == T001.MANDT
Contract Account
  • Contract Account
  • Client
  • C_SPPRSDUTILSBILLGORDWTHDETS.CONTRACTACCOUNT == FKKVK.VKONT
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == FKKVK.MANDT
Meter Reading Unit
  • Meter Reading Unit
  • Client
  • C_SPPRSDUTILSBILLGORDWTHDETS.METERREADINGUNIT == TE422.TERMSCHL
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == TE422.MANDT
Account Determination Code
  • Company Code
  • Account Determination Code
  • Client
  • Division
  • C_SPPRSDUTILSBILLGORDWTHDETS.COMPANYCODE == TE097.BUKRS
  • C_SPPRSDUTILSBILLGORDWTHDETS.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == TE097.MANDT
  • C_SPPRSDUTILSBILLGORDWTHDETS.DIVISION == TE097.SPARTE
Billing Class
  • Billing Class
  • Client
  • C_SPPRSDUTILSBILLGORDWTHDETS.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == EAKLASSE.MANDT
Installation C_SPPRSDUTILSBILLGORDWTHDETS.UTILITIESINSTALLATION == EANL.MANDT
Portion
  • Portion
  • Client
  • C_SPPRSDUTILSBILLGORDWTHDETS.UTILITIESPORTION == TE420.TERMSCHL
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == TE420.MANDT
Rate Category
  • Rate Category
  • Client
  • C_SPPRSDUTILSBILLGORDWTHDETS.UTILITIESRATECATEGORY == ETTA.TARIFTYP
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == ETTA.MANDT
Billing Block Reason
  • Billing Block Reason
  • Client
  • C_SPPRSDUTILSBILLGORDWTHDETS.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == TE021.MANDT
Release Reason
  • Release Reason
  • Client
  • C_SPPRSDUTILSBILLGORDWTHDETS.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == TE023.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_SPPRSDUTILSBILLGORDWTHDETS.MANDT == TESPT.MANDT
  • C_SPPRSDUTILSBILLGORDWTHDETS.DIVISION == TESPT.SPARTE