I_SpprsdUtilsBillgOrdWthDets

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