C_UtilsBillgOrdRdyBillgWthDets

Billing Order Ready for Billing with Details | view: CEBLLGORDRDYDET | Extraction: Not supported | Component: Contract Billing

Tables used: SCAL_TT_DATE, ETRG, TE417, EUITRANS, EUIINSTLN, ADCP, ADRC, TFK001G, TFK002F, T001, TKA02, FKKVKP, IFLOT, ILOA, EVER, EANL, EANLH, TE420, EVBS

🔑 Keys (4)
💰 Amounts
∑ Quantities
📅 Dates (4)
☰ Categorical (5)
Other (7)
🔗 Relations (15)

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

Column Name	Description
UtilitiesBillingReason	Billing Reason	Show values
UtilsDefaultBdgtBillgCycle	Budget Billing Cycle	Show values
UtilsContrSpcfcBdgtBillgCycle	Overriding Budget Billing Cycle	Show values
UtilsBillgOrdChkBfrBilling	Billing Order Check Before Billing	Show values
UtilsContrIsBilledManually	Contract Is Billed Manually	Show values

Column Name	Description	Domain name
UtilsExternalPointOfDelivery	Point of Delivery ID	EXT_UI
StatusCriticality	null
UtilsPostalAddressFormatted	null
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
Address Number ? ? Address Number Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.[column in domain "AD_NATION"] == ADRC.NATION` `C_UTILSBILLGORDRDYBILLGWTHDETS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM` `C_UTILSBILLGORDRDYBILLGWTHDETS.ADDRESSID == ADRC.ADDRNUMBER` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == ADRC.CLIENT`
Business Partner Number Business Partner Number Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.BUSINESSPARTNER == BUT000.PARTNER` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == BUT000.CLIENT`
Company Code Company Code Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.COMPANYCODE == T001.BUKRS` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == T001.MANDT`
Contract Account Client Contract Account	`C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == FKKVK.MANDT` `C_UTILSBILLGORDRDYBILLGWTHDETS.CONTRACTACCOUNT == FKKVK.VKONT`
Meter Reading Unit Meter Reading Unit Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.METERREADINGUNIT == TE422.TERMSCHL` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == TE422.MANDT`
Account Determination Code Division Company Code Account Determination Code Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.DIVISION == TE097.SPARTE` `C_UTILSBILLGORDRDYBILLGWTHDETS.COMPANYCODE == TE097.BUKRS` `C_UTILSBILLGORDRDYBILLGWTHDETS.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == TE097.MANDT`
Billing Class Billing Class Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == EAKLASSE.MANDT`
Installation	`C_UTILSBILLGORDRDYBILLGWTHDETS.UTILITIESINSTALLATION == EANL.MANDT`
Portion Portion Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.UTILITIESPORTION == TE420.TERMSCHL` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == TE420.MANDT`
Premise Premise Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.UTILITIESPREMISE == EVBS.VSTELLE` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == EVBS.MANDT`
Rate Category Rate Category Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.UTILITIESRATECATEGORY == ETTA.TARIFTYP` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == ETTA.MANDT`
Billing Block Reason Billing Block Reason Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.UTILSBILLGBLOCKREASON == TE021.ABRSPERR` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == TE021.MANDT`
Outsorting Reason Outsorting Reason Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.UTILSBILLGOUTSORTINGREASON == TE127.MANOUTSORT` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == TE127.MANDT`
Release Reason Release Reason Client	`C_UTILSBILLGORDRDYBILLGWTHDETS.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG` `C_UTILSBILLGORDRDYBILLGWTHDETS.MANDT == TE023.MANDT`

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