C_OpenUtilsBillgBlkdContr

Blocked Utilities Contract with Open Billing | view: CECBLKDCONTR | Extraction: Not supported | Component: Contract Billing

Tables used: EABL, EABLG, ERCH, ETRG, TE417, EUITRANS, EUIINSTLN, TFK001G, TFK002F, T001, TKA02, FKKVKP, EVER, EANL, EANLH, ETDZ, TE021, TE021T

🔑 Keys (4)
💰 Amounts
∑ Quantities
📅 Dates (3)
☰ Categorical (1)
Other (3)
🔗 Relations (12)

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

Column Name	Description
UtilitiesBillingReason	Billing Reason	Show values

Column Name	Description	Domain name
UtilsBillgBlockReasonName	Text (30 Characters)	TEXT30
AuthorizationGroup	Authorization Group	BEGRU
NmbrOfUtilsContrBlkdForBillg	Number of Contracts

Master Data Relations	Join Conditions
Business Partner Number Business Partner Number Client	`C_OPENUTILSBILLGBLKDCONTR.BUSINESSPARTNER == BUT000.PARTNER` `C_OPENUTILSBILLGBLKDCONTR.MANDT == BUT000.CLIENT`
Company Code Client Company Code	`C_OPENUTILSBILLGBLKDCONTR.MANDT == T001.MANDT` `C_OPENUTILSBILLGBLKDCONTR.COMPANYCODE == T001.BUKRS`
Contract Account Client Contract Account	`C_OPENUTILSBILLGBLKDCONTR.MANDT == FKKVK.MANDT` `C_OPENUTILSBILLGBLKDCONTR.CONTRACTACCOUNT == FKKVK.VKONT`
Meter Reading Unit Client Meter Reading Unit	`C_OPENUTILSBILLGBLKDCONTR.MANDT == TE422.MANDT` `C_OPENUTILSBILLGBLKDCONTR.METERREADINGUNIT == TE422.TERMSCHL`
Account Determination Code Client Division Account Determination Code Company Code	`C_OPENUTILSBILLGBLKDCONTR.MANDT == TE097.MANDT` `C_OPENUTILSBILLGBLKDCONTR.DIVISION == TE097.SPARTE` `C_OPENUTILSBILLGBLKDCONTR.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ` `C_OPENUTILSBILLGBLKDCONTR.COMPANYCODE == TE097.BUKRS`
Billing Class Client Billing Class	`C_OPENUTILSBILLGBLKDCONTR.MANDT == EAKLASSE.MANDT` `C_OPENUTILSBILLGBLKDCONTR.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE`
Installation	`C_OPENUTILSBILLGBLKDCONTR.UTILITIESINSTALLATION == EANL.MANDT`
Portion Client Portion	`C_OPENUTILSBILLGBLKDCONTR.MANDT == TE420.MANDT` `C_OPENUTILSBILLGBLKDCONTR.UTILITIESPORTION == TE420.TERMSCHL`
Rate Category Client Rate Category	`C_OPENUTILSBILLGBLKDCONTR.MANDT == ETTA.MANDT` `C_OPENUTILSBILLGBLKDCONTR.UTILITIESRATECATEGORY == ETTA.TARIFTYP`
Billing Block Reason Billing Block Reason Client	`C_OPENUTILSBILLGBLKDCONTR.UTILSBILLGBLOCKREASON == TE021.ABRSPERR` `C_OPENUTILSBILLGBLKDCONTR.MANDT == TE021.MANDT`
Release Reason Client Release Reason	`C_OPENUTILSBILLGBLKDCONTR.MANDT == TE023.MANDT` `C_OPENUTILSBILLGBLKDCONTR.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG`

Other Relations \| to Master Data Relations ↑	Join Conditions
Division Client Division	`C_OPENUTILSBILLGBLKDCONTR.MANDT == TESPT.MANDT` `C_OPENUTILSBILLGBLKDCONTR.DIVISION == TESPT.SPARTE`