C_UtilsContrToBeBlldInvcdAnlys

Analysis of Contract to Be Billed and Invoiced | view: CECONTRTBBILINV | Extraction: Not supported | Component: Invoicing
Tables used: TE418, ERCH, ETRG, ERDK, EITR, TE417, EUITRANS, EUIINSTLN, ERCHC, BUT000, DFKKLOCKS, TFK001G, TFK080R1, TFK080R1T, TFK002F, T001, TKA02, FKKVK, FKKVKP, TSPA, TSPAT, TE422, EVER, EANLH, TE420, ETTA, ETTAT, TE097, TE097T, TE021, TE021T, TE023, TE023T, EAKLASSE, EAKLASSET
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
UtilitiesPortionName Portion Name BEZEICHNG
BusinessPartnerName null
ContractAccountName Description of Contract Account TEXT35
UtilsBillgBlockReasonName Text (30 Characters) TEXT30
UtilsBillgUnblockReasonName Text (30 Characters) TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
DivisionName Division Description TEXT20
UtilitiesAccountDetnCodeName Account Determination Code Name TEXT50
MeterReadingUnitName Meter Reading Unit Name BEZEICHNG
UtilitiesRateCategoryName Name for Rate Category TEXT40
UtilitiesBillingClassName Billing Class Name TEXT30
AltvContrAcctForCollvBillsName Description of Contract Account TEXT35
CABusinessLockReason Invoicing Lock Reason LOCKR_KK
CAInvcgLockReasonName Name of Lock Reason TXT40
UtilsContrToBeBlldTypeName Billing Progress Name TEXT50
UtilsContrToBeBlldDetsTypeName Billing Status Name TEXT50
UtilsContrToBeInvcdPrgrsTxt Invoicing Progress Name DDTEXT
UtilsContrToBeInvcdPrgrsStsTxt Invoicing Status Name DDTEXT
UtilsExternalPointOfDelivery Point of Delivery ID EXT_UI
AuthorizationGroup Authorization Group BEGRU
NmbrOfUtilsContrToBeInvoiced Number of Contracts
Master Data Relations Join Conditions
Collective Bill Account
  • Collective Bill Account
  • Client
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.ALTVCONTRACTACCTFORCOLLVBILLS == FKKVK.VKONT
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == FKKVK.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.BUSINESSPARTNER == BUT000.PARTNER
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == BUT000.CLIENT
Company Code
  • Company Code
  • Client
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.COMPANYCODE == T001.BUKRS
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == T001.MANDT
Contract Account Number
  • Contract Account Number
  • Client
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.CONTRACTACCOUNT == FKKVK.VKONT
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == FKKVK.MANDT
Meter Reading Unit
  • Meter Reading Unit
  • Client
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.METERREADINGUNIT == TE422.TERMSCHL
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TE422.MANDT
Account Determination Code
  • Company Code
  • Account Determination Code
  • Client
  • Division
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.COMPANYCODE == TE097.BUKRS
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TE097.MANDT
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.DIVISION == TE097.SPARTE
Billing Class
  • Billing Class
  • Client
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == EAKLASSE.MANDT
Rate Category
  • Rate Category
  • Client
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.UTILITIESRATECATEGORY == ETTA.TARIFTYP
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == ETTA.MANDT
Billing Block Reason
  • Billing Block Reason
  • Client
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TE021.MANDT
Release Reason
  • Release Reason
  • Client
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TE023.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.MANDT == TESPT.MANDT
  • C_UTILSCONTRTOBEBLLDINVCDANLYS.DIVISION == TESPT.SPARTE