I_UtilsContractKeyDateAnalysis

Key Date-Based Utilities Contract Analysis | view: IEUTILSCONTRANLY | TRAN | Extraction: Not supported | Component: Master Data
Tables used: SCAL_TT_DATEEVEREVERH
Column Name Description
UtilitiesContract Contract
Column Name Description
Column Name Description
Column Name Description
UtilsProdAllocationEndDate Product Allocation End Date
UtilsProdAllocationStartDate Product Allocation Start Date
UtilsContractCreationDate Date on which the record was created
UtilsContractLastChangeDate Last Changed On
UtilitiesContractCanclnDate Cancellation date of contract
UtilitiesContractRenewalDate Renewal date of contract
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
UtilitiesAnalysisKeyDate Contract Analysis Key Date
Column Name Description
UtilsPlantOrCompanyConsumption Plant or company consumption Show values
UtilsContrIsBilledManually Contract Is Billed Manually Show values
UtilitiesContractIsActive Contract Is Active Show values
UtilsContrJointInvcType Invoice Contracts Jointly Show values
UtilsContrHistoryIsNotExisting Contract History Does Not Exist Show values
DeletionIndicator Deletion Indicator Show values
Column Name Description Domain name
UtilitiesProduct CRM Product ESALES_CRM_PRODUCT
UtilsContractCreatedByUser Name of Person Responsible for Creating the Object USNAM
UtilsContractLastChangedByUser Name of Person Who Changed Object USNAM
NumberOfUtilitiesContracts Number of Contracts
UtilsMoveInDateAsYearMonth Move-In Date Formatted As YearMonth NUM6
UtilsMoveOutDateAsYearMonth Move-Out Date Formatted As YearMonth NUM6
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Dunning Procedure
  • Client
  • Dunning Procedure
  • I_UTILSCONTRACTKEYDATEANALYSIS.MANDT == TFK047A.MANDT
  • I_UTILSCONTRACTKEYDATEANALYSIS.CADUNNINGPROCEDURE == TFK047A.MAHNV
Company Code
  • Client
  • Company Code
  • I_UTILSCONTRACTKEYDATEANALYSIS.MANDT == T001.MANDT
  • I_UTILSCONTRACTKEYDATEANALYSIS.COMPANYCODE == T001.BUKRS
Account Determination Code
  • Client
  • Account Determination Code
  • Company Code
  • Division
  • I_UTILSCONTRACTKEYDATEANALYSIS.MANDT == TE097.MANDT
  • I_UTILSCONTRACTKEYDATEANALYSIS.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • I_UTILSCONTRACTKEYDATEANALYSIS.COMPANYCODE == TE097.BUKRS
  • I_UTILSCONTRACTKEYDATEANALYSIS.UTILITIESDIVISION == TE097.SPARTE
Service Provider
  • Client
  • Service Provider
  • I_UTILSCONTRACTKEYDATEANALYSIS.MANDT == ESERVPROV.MANDT
  • I_UTILSCONTRACTKEYDATEANALYSIS.UTILITIESSERVICEPROVIDER == ESERVPROV.SERVICEID
Billing Block Reason
  • Client
  • Billing Block Reason
  • I_UTILSCONTRACTKEYDATEANALYSIS.MANDT == TE021.MANDT
  • I_UTILSCONTRACTKEYDATEANALYSIS.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
Release Reason
  • Client
  • Release Reason
  • I_UTILSCONTRACTKEYDATEANALYSIS.MANDT == TE023.MANDT
  • I_UTILSCONTRACTKEYDATEANALYSIS.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
Processing Status
  • Processing Status
  • Client
  • I_UTILSCONTRACTKEYDATEANALYSIS.UTILSCONTRACTPROCESSINGSTS == TE643.BEARKZ
  • I_UTILSCONTRACTKEYDATEANALYSIS.MANDT == TE643.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • I_UTILSCONTRACTKEYDATEANALYSIS.MANDT == TESPT.MANDT
  • I_UTILSCONTRACTKEYDATEANALYSIS.UTILITIESDIVISION == TESPT.SPARTE