C_UtilsBillingOrder

Utilities Billing Order | view: CECBILLGORDER | Extraction: Not supported | Component: Contract Billing
Tables used: SCAL_TT_DATE, ETRG, TE417, EUITRANS, EUIINSTLN, TFK001G, TFK002F, T001, TKA02, FKKVKP, EVER, EANLH
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
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
UtilsBillingOrderIndicator Billing Order Indicator for Errors Show values
SuppressedUtilsBillgReason Billing Reason for Suppressed Billing Order Show values
Column Name Description Domain name
CalendarMonth Scheduled Billing Month E_SCHDLDMNTH_VDM
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarYear Scheduled Billing Year E_SCHDLDYR_VDM
AuthorizationGroup Authorization Group BEGRU
NrOfUtilitiesBillingOrders Number of Billing Orders E_BILLGORDS_NMBR_VDM
Master Data Relations Join Conditions
Business Partner Number
  • Client
  • Business Partner Number
  • C_UTILSBILLINGORDER.MANDT == BUT000.CLIENT
  • C_UTILSBILLINGORDER.BUSINESSPARTNER == BUT000.PARTNER
Company Code
  • Company Code
  • Client
  • C_UTILSBILLINGORDER.COMPANYCODE == T001.BUKRS
  • C_UTILSBILLINGORDER.MANDT == T001.MANDT
Contract Account
  • Client
  • Contract Account
  • C_UTILSBILLINGORDER.MANDT == FKKVK.MANDT
  • C_UTILSBILLINGORDER.CONTRACTACCOUNT == FKKVK.VKONT
Meter Reading Unit
  • Client
  • Meter Reading Unit
  • C_UTILSBILLINGORDER.MANDT == TE422.MANDT
  • C_UTILSBILLINGORDER.METERREADINGUNIT == TE422.TERMSCHL
Account Determination Code
  • Company Code
  • Client
  • Account Determination Code
  • Division
  • C_UTILSBILLINGORDER.COMPANYCODE == TE097.BUKRS
  • C_UTILSBILLINGORDER.MANDT == TE097.MANDT
  • C_UTILSBILLINGORDER.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • C_UTILSBILLINGORDER.DIVISION == TE097.SPARTE
Billing Class
  • Client
  • Billing Class
  • C_UTILSBILLINGORDER.MANDT == EAKLASSE.MANDT
  • C_UTILSBILLINGORDER.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
Installation C_UTILSBILLINGORDER.UTILITIESINSTALLATION == EANL.MANDT
Portion
  • Client
  • Portion
  • C_UTILSBILLINGORDER.MANDT == TE420.MANDT
  • C_UTILSBILLINGORDER.UTILITIESPORTION == TE420.TERMSCHL
Rate Category
  • Client
  • Rate Category
  • C_UTILSBILLINGORDER.MANDT == ETTA.MANDT
  • C_UTILSBILLINGORDER.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Billing Block Reason
  • Client
  • Billing Block Reason
  • C_UTILSBILLINGORDER.MANDT == TE021.MANDT
  • C_UTILSBILLINGORDER.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
Release Reason
  • Client
  • Release Reason
  • C_UTILSBILLINGORDER.MANDT == TE023.MANDT
  • C_UTILSBILLINGORDER.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_UTILSBILLINGORDER.MANDT == TESPT.MANDT
  • C_UTILSBILLINGORDER.DIVISION == TESPT.SPARTE