C_MisgUtilsBillingOrderWthDets

Missing Utilities Billing Order with Details | view: CEMISGBILLGORD | Extraction: Not supported | Component: Contract Billing
Tables used: TE418, ERCH, ETRG, TE417, EUITRANS, EUIINSTLN, TFK001G, TFK002F, T001, TKA02, FKKVKP, TE422, EVER, EANLH
Column Name Description
UtilitiesContract Contract
UtilitiesPortion Portion
ScheduledUtilitiesBillingDate Scheduled Billing Date
ScheduledMeterReadingDate Scheduled Meter Reading Date
Column Name Description
Column Name Description
Column Name Description
ScheduledUtilitiesBillingDate Scheduled Billing Date
ScheduledMeterReadingDate Scheduled Meter Reading Date
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
Column Name Description
LatestUtilitiesBillingReason Reason for Last Billing Show values
Column Name Description Domain name
MeterReadingReason Meter reading reason ABLESGR
UtilsExternalPointOfDelivery Point of Delivery ID EXT_UI
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Client
  • C_MISGUTILSBILLINGORDERWTHDETS.BUSINESSPARTNER == BUT000.PARTNER
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == BUT000.CLIENT
Company Code
  • Client
  • Company Code
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == T001.MANDT
  • C_MISGUTILSBILLINGORDERWTHDETS.COMPANYCODE == T001.BUKRS
Contract Account
  • Client
  • Contract Account
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == FKKVK.MANDT
  • C_MISGUTILSBILLINGORDERWTHDETS.CONTRACTACCOUNT == FKKVK.VKONT
Meter Reading Unit
  • Client
  • Meter Reading Unit
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == TE422.MANDT
  • C_MISGUTILSBILLINGORDERWTHDETS.METERREADINGUNIT == TE422.TERMSCHL
Account Determination Code
  • Client
  • Account Determination Code
  • Company Code
  • Division
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == TE097.MANDT
  • C_MISGUTILSBILLINGORDERWTHDETS.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • C_MISGUTILSBILLINGORDERWTHDETS.COMPANYCODE == TE097.BUKRS
  • C_MISGUTILSBILLINGORDERWTHDETS.DIVISION == TE097.SPARTE
Billing Class
  • Client
  • Billing Class
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == EAKLASSE.MANDT
  • C_MISGUTILSBILLINGORDERWTHDETS.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
Rate Category
  • Client
  • Rate Category
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == ETTA.MANDT
  • C_MISGUTILSBILLINGORDERWTHDETS.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Billing Block Reason
  • Billing Block Reason
  • Client
  • C_MISGUTILSBILLINGORDERWTHDETS.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == TE021.MANDT
Release Reason
  • Client
  • Release Reason
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == TE023.MANDT
  • C_MISGUTILSBILLINGORDERWTHDETS.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_MISGUTILSBILLINGORDERWTHDETS.MANDT == TESPT.MANDT
  • C_MISGUTILSBILLINGORDERWTHDETS.DIVISION == TESPT.SPARTE