C_BlockedUtilitiesContractTP

Blocked Utilities Contract | view: CEBUTILSCONTRTP | Extraction: Not supported | Component: Master Data
Tables used: CDHDR, ERCH, ETRG, BUT000, DFKKLOCKS, TFK001G, TFK002F, T001, TKA02, FKKVK, FKKVKP, TE422, USR21, EVER, EANLH, CDPOS
Column Name Description
UtilitiesContract Contract
Column Name Description
Column Name Description
Column Name Description
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
UtilsBillgPeriodEndDate Billing Period End
UtilsBillgPeriodStartDate Billing Period Start
UtilsBillgDocCreationDate Date of Last Billing
CreationDate Contract Blocking Date
Column Name Description
UtilsContrIsBilledManually Contract Is Billed Manually Show values
UtilsContrJointInvcType Invoice Contracts Jointly Show values
DeletionIndicator Deletion Indicator Show values
CAApplicationArea Application Area Show values
UtilsBillgOrderIsExisting Billing Order Exists Show values
Column Name Description Domain name
UtilitiesPortion Portion PORTION
AuthorizationGroup Authorization Group BEGRU
BusinessPartnerName null
UtilitiesBillingDocument Number of Billing Document E_BELNR
CreatedByUser Contract Blocked By User CHAR12
UserDescription User Description SUIDTECHDESC
CABusinessLockReason Invoicing Lock Reason LOCKR_KK
Master Data Relations Join Conditions
Business Partner Number
  • Client
  • Business Partner Number
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == BUT000.CLIENT
  • C_BLOCKEDUTILITIESCONTRACTTP.BUSINESSPARTNER == BUT000.PARTNER
Company Code
  • Client
  • Company Code
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == T001.MANDT
  • C_BLOCKEDUTILITIESCONTRACTTP.COMPANYCODE == T001.BUKRS
Contract Account
  • Client
  • Contract Account
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == FKKVK.MANDT
  • C_BLOCKEDUTILITIESCONTRACTTP.CONTRACTACCOUNT == FKKVK.VKONT
Check table
  • Application Area
  • Client
  • Contract Account Category
  • C_BLOCKEDUTILITIESCONTRACTTP.CAAPPLICATIONAREA == TFK002A.APPLK
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == TFK002A.MANDT
  • C_BLOCKEDUTILITIESCONTRACTTP.CONTRACTACCOUNTCATEGORY == TFK002A.VKTYP
Meter Reading Unit
  • Client
  • Meter Reading Unit
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == TE422.MANDT
  • C_BLOCKEDUTILITIESCONTRACTTP.METERREADINGUNIT == TE422.TERMSCHL
Account Determination Code
  • Account Determination Code
  • Client
  • Division
  • Company Code
  • C_BLOCKEDUTILITIESCONTRACTTP.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == TE097.MANDT
  • C_BLOCKEDUTILITIESCONTRACTTP.DIVISION == TE097.SPARTE
  • C_BLOCKEDUTILITIESCONTRACTTP.COMPANYCODE == TE097.BUKRS
Billing Class
  • Billing Class
  • Client
  • C_BLOCKEDUTILITIESCONTRACTTP.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == EAKLASSE.MANDT
Rate Category
  • Client
  • Rate Category
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == ETTA.MANDT
  • C_BLOCKEDUTILITIESCONTRACTTP.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Billing Block Reason
  • Billing Block Reason
  • Client
  • C_BLOCKEDUTILITIESCONTRACTTP.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == TE021.MANDT
Outsorting Reason
  • Client
  • Outsorting Reason
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == TE127.MANDT
  • C_BLOCKEDUTILITIESCONTRACTTP.UTILSBILLGOUTSORTINGREASON == TE127.MANOUTSORT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_BLOCKEDUTILITIESCONTRACTTP.MANDT == TESPT.MANDT
  • C_BLOCKEDUTILITIESCONTRACTTP.DIVISION == TESPT.SPARTE