I_OpenUtilsBillgDocAndOrdData

Open Utilities Billing Document and Order Data | view: IEOPENBILLGSU | TRAN | Extraction: Not supported | Component: Contract Billing
Tables used: ERCH, ETRG, TE417, EUITRANS, EUIINSTLN, TFK001G, TFK002F, T001, TKA02, FKKVKP, EVER, EANL, 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
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
Column Name Description
UtilitiesBillingReason Billing Reason Show values
Column Name Description Domain name
OpnUtilsBillgDocAndOrdType null
UtilitiesContractIsActive null
UtilsInstTimeSliceIsValid null
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == T001.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.COMPANYCODE == T001.BUKRS
Contract Account
  • Client
  • Contract Account
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == FKKVK.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.CONTRACTACCOUNT == FKKVK.VKONT
Meter Reading Unit
  • Client
  • Meter Reading Unit
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == TE422.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.METERREADINGUNIT == TE422.TERMSCHL
Account Determination Code
  • Client
  • Company Code
  • Account Determination Code
  • Division
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == TE097.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.COMPANYCODE == TE097.BUKRS
  • I_OPENUTILSBILLGDOCANDORDDATA.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • I_OPENUTILSBILLGDOCANDORDDATA.DIVISION == TE097.SPARTE
Billing Class
  • Client
  • Billing Class
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == EAKLASSE.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
Installation I_OPENUTILSBILLGDOCANDORDDATA.UTILITIESINSTALLATION == EANL.MANDT
Portion
  • Client
  • Portion
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == TE420.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.UTILITIESPORTION == TE420.TERMSCHL
Rate Category
  • Client
  • Rate Category
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == ETTA.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Billing Block Reason
  • Client
  • Billing Block Reason
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == TE021.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
Release Reason
  • Client
  • Release Reason
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == TE023.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • I_OPENUTILSBILLGDOCANDORDDATA.MANDT == TESPT.MANDT
  • I_OPENUTILSBILLGDOCANDORDDATA.DIVISION == TESPT.SPARTE