I_OpenUtilsBillgDocAndOrd

Open Utilities Billing Document and Order | view: IEOPENBILLGS | TRAN | Extraction: Not supported | Component: Contract Billing
Tables used: EABL, EABLG, ERCH, ETRG, TE417, EUITRANS, EUIINSTLN, TFK001G, TFK002F, T001, TKA02, FKKVKP, EVER, EANL, 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
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
Column Name Description
UtilitiesBillingReason Billing Reason Show values
OpnUtilsBillgDocAndOrdType Billing Status Show values
MeterReadingStatusGroup Meter Reading Status Group Show values
Column Name Description Domain name
MeterReadingReason Meter reading reason ABLESGR
NmbrOfImplausibleMtrRdngRslts null
AuthorizationGroup Authorization Group BEGRU
NrOfOpenUtilsBillgDocsAndOrds Number of Open Billing Documents and Orders E_OPBBILLGDOCSANDORDS_NMBR_VDM
NmbrOfUtilsContrBlkdForBillg Number of Contracts
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Client
  • I_OPENUTILSBILLGDOCANDORD.BUSINESSPARTNER == BUT000.PARTNER
  • I_OPENUTILSBILLGDOCANDORD.MANDT == BUT000.CLIENT
Company Code
  • Client
  • Company Code
  • I_OPENUTILSBILLGDOCANDORD.MANDT == T001.MANDT
  • I_OPENUTILSBILLGDOCANDORD.COMPANYCODE == T001.BUKRS
Contract Account
  • Client
  • Contract Account
  • I_OPENUTILSBILLGDOCANDORD.MANDT == FKKVK.MANDT
  • I_OPENUTILSBILLGDOCANDORD.CONTRACTACCOUNT == FKKVK.VKONT
Meter Reading Unit
  • Meter Reading Unit
  • Client
  • I_OPENUTILSBILLGDOCANDORD.METERREADINGUNIT == TE422.TERMSCHL
  • I_OPENUTILSBILLGDOCANDORD.MANDT == TE422.MANDT
Account Determination Code
  • Account Determination Code
  • Client
  • Company Code
  • Division
  • I_OPENUTILSBILLGDOCANDORD.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • I_OPENUTILSBILLGDOCANDORD.MANDT == TE097.MANDT
  • I_OPENUTILSBILLGDOCANDORD.COMPANYCODE == TE097.BUKRS
  • I_OPENUTILSBILLGDOCANDORD.DIVISION == TE097.SPARTE
Billing Class
  • Billing Class
  • Client
  • I_OPENUTILSBILLGDOCANDORD.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • I_OPENUTILSBILLGDOCANDORD.MANDT == EAKLASSE.MANDT
Installation I_OPENUTILSBILLGDOCANDORD.UTILITIESINSTALLATION == EANL.MANDT
Portion
  • Portion
  • Client
  • I_OPENUTILSBILLGDOCANDORD.UTILITIESPORTION == TE420.TERMSCHL
  • I_OPENUTILSBILLGDOCANDORD.MANDT == TE420.MANDT
Rate Category
  • Client
  • Rate Category
  • I_OPENUTILSBILLGDOCANDORD.MANDT == ETTA.MANDT
  • I_OPENUTILSBILLGDOCANDORD.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Billing Block Reason
  • Billing Block Reason
  • Client
  • I_OPENUTILSBILLGDOCANDORD.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
  • I_OPENUTILSBILLGDOCANDORD.MANDT == TE021.MANDT
Release Reason
  • Release Reason
  • Client
  • I_OPENUTILSBILLGDOCANDORD.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
  • I_OPENUTILSBILLGDOCANDORD.MANDT == TE023.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • I_OPENUTILSBILLGDOCANDORD.MANDT == TESPT.MANDT
  • I_OPENUTILSBILLGDOCANDORD.DIVISION == TESPT.SPARTE