C_OutStdgUtilsBillgItemWthDets

Outstanding Billing Item with Details | view: CEOUTSTBILLGITMD | Extraction: Not supported | Component: Contract Billing

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

🔑 Keys (4)
💰 Amounts
∑ Quantities
📅 Dates (5)
☰ Categorical (4)
Other (7)
🔗 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
UtilitiesMoveInDate	Move-In
UtilitiesMoveOutDate	Move-Out
LatestUtilitiesBillingDate	Date of Last Billing

Column Name	Description
UtilitiesBillingReason	Billing Reason	Show values
LatestUtilitiesBillingReason	Reason for Last Billing	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
UtilsExternalPointOfDelivery	Point of Delivery ID	EXT_UI
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

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

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