I_UtilsContrToBeBlldInvcdAnlys

Analysis of Contract to Be Billed and Invoiced | view: IECONTRTBBILINV | TRAN | Extraction: Not supported | Component: Invoicing
Tables used: TE418, ERCH, ETRG, ERDK, EITR, TE417, ERCHC, DFKKLOCKS, TFK001G, TFK002F, T001, TKA02, FKKVKP, TE422, EVER, EANLH
Column Name Description
UtilitiesContract Contract
ScheduledUtilitiesBillingDate Scheduled Billing Date
UtilitiesPortion Portion
ScheduledMeterReadingDate Scheduled Meter Reading Date
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
UtilsContrToBeBlldType Billing Progress Show values
UtilsContrToBeBlldDetsType Billing Status Show values
UtilsContrToBeInvcdPrgrs Invoicing Progress Show values
UtilsContrToBeInvcdPrgrsSts Invoicing Status Show values
Column Name Description Domain name
CAAccountDeterminationCode Account Determination Code for Contract Account E_KOFIZ_SD
CABusinessLockReason Invoicing Lock Reason LOCKR_KK
AuthorizationGroup Authorization Group BEGRU
NmbrOfUtilsContrToBeInvoiced Number of Contracts
Master Data Relations Join Conditions
Collective Bill Account
  • Client
  • Collective Bill Account
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == FKKVK.MANDT
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.ALTVCONTRACTACCTFORCOLLVBILLS == FKKVK.VKONT
Business Partner Number
  • Business Partner Number
  • Client
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.BUSINESSPARTNER == BUT000.PARTNER
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == BUT000.CLIENT
Company Code
  • Company Code
  • Client
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.COMPANYCODE == T001.BUKRS
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == T001.MANDT
Contract Account Number
  • Contract Account Number
  • Client
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.CONTRACTACCOUNT == FKKVK.VKONT
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == FKKVK.MANDT
Meter Reading Unit
  • Meter Reading Unit
  • Client
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.METERREADINGUNIT == TE422.TERMSCHL
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TE422.MANDT
Account Determination Code
  • Division
  • Company Code
  • Account Determination Code
  • Client
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.DIVISION == TE097.SPARTE
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.COMPANYCODE == TE097.BUKRS
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TE097.MANDT
Billing Class
  • Billing Class
  • Client
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == EAKLASSE.MANDT
Rate Category
  • Client
  • Rate Category
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == ETTA.MANDT
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Billing Block Reason
  • Billing Block Reason
  • Client
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TE021.MANDT
Release Reason
  • Release Reason
  • Client
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TE023.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Division
  • Client
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.DIVISION == TESPT.SPARTE
  • I_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TESPT.MANDT