C_UnblockedUtilitiesContractTP

Unblocked Utilities Contract | view: CEUNBLKDCONTRTP | Extraction: Not supported | Component: Master Data
Tables used: EUITRANS, EUIINSTLN, TFK001G, TFK002F, T001, TKA02, FKKVKP, TE422, EVER, EANLH
Column Name Description
UtilitiesContract Contract
UtilitiesInstallation FK Installation
BusinessPartner FK Business Partner Number
UtilsInstHistValidityEndDate Validity End Date of Installation
UtilsInternalPointOfDelivery FK Internal key for point of delivery
Column Name Description
Column Name Description
Column Name Description
UtilsInstHistValidityEndDate Validity End Date of Installation
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
Column Name Description
Column Name Description Domain name
UtilitiesPortion Portion PORTION
UtilsExternalPointOfDelivery Point of Delivery ID EXT_UI
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Client
  • C_UNBLOCKEDUTILITIESCONTRACTTP.BUSINESSPARTNER == BUT000.PARTNER
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == BUT000.CLIENT
Alternative Invoice Recipient
  • Alternative Invoice Recipient
  • Client
  • C_UNBLOCKEDUTILITIESCONTRACTTP.CAALTERNATIVEINVOICERECIPIENT == BUT000.PARTNER
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == BUT000.CLIENT
Company Code
  • Company Code
  • Client
  • C_UNBLOCKEDUTILITIESCONTRACTTP.COMPANYCODE == T001.BUKRS
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == T001.MANDT
Contract Account Number
  • Contract Account Number
  • Client
  • C_UNBLOCKEDUTILITIESCONTRACTTP.CONTRACTACCOUNT == FKKVK.VKONT
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == FKKVK.MANDT
Meter Reading Unit
  • Meter Reading Unit
  • Client
  • C_UNBLOCKEDUTILITIESCONTRACTTP.METERREADINGUNIT == TE422.TERMSCHL
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == TE422.MANDT
Account Determination Code
  • Account Determination Code
  • Company Code
  • Client
  • Division
  • C_UNBLOCKEDUTILITIESCONTRACTTP.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • C_UNBLOCKEDUTILITIESCONTRACTTP.COMPANYCODE == TE097.BUKRS
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == TE097.MANDT
  • C_UNBLOCKEDUTILITIESCONTRACTTP.DIVISION == TE097.SPARTE
Billing Class
  • Billing Class
  • Client
  • C_UNBLOCKEDUTILITIESCONTRACTTP.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == EAKLASSE.MANDT
Rate Category
  • Client
  • Rate Category
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == ETTA.MANDT
  • C_UNBLOCKEDUTILITIESCONTRACTTP.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Outsorting Reason
  • Client
  • Outsorting Reason
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == TE127.MANDT
  • C_UNBLOCKEDUTILITIESCONTRACTTP.UTILSBILLGOUTSORTINGREASON == TE127.MANOUTSORT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_UNBLOCKEDUTILITIESCONTRACTTP.MANDT == TESPT.MANDT
  • C_UNBLOCKEDUTILITIESCONTRACTTP.DIVISION == TESPT.SPARTE