C_UtilsContractChangeHistoryQ

Analysis on Utilities Contract Changes Query | view: CECONTPRODHISTQ | Extraction: Not supported | Component: Master Data
Column Name Description
UtilitiesContract Contract
UtilsProdAllocationEndDate Product Allocation End Date
Column Name Description
Column Name Description
Column Name Description
UtilsProdAllocationEndDate Product Allocation End Date
UtilitiesContractCanclnDate Cancellation date of contract
UtilitiesContractRenewalDate Renewal date of contract
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
UtilsContractCreationDate Date on which the record was created
UtilsContractLastChangeDate Last Changed On
UtilsProdAllocationStartDate Product Allocation Start Date
UtilsAnlysTimeframeStartDate Analysis Timeframe From
UtilsAnlysTimeframeEndDate Analysis Timeframe To
Column Name Description
DeletionIndicator Deletion Indicator Show values
UtilsContrJointInvcType Invoice Contracts Jointly Show values
UtilsContrHistoryIsNotExisting Contract History Does Not Exist Show values
UtilsContrIsBilledManually Contract Is Billed Manually Show values
UtilsPlantOrCompanyConsumption Plant or company consumption Show values
Column Name Description Domain name
CADunningProcedureName Dunning procedure text TXT50
CompanyCodeName Name of Company Code or Company TEXT25
UtilsContrJointInvcTypeName Joint Contract Invoicing Name DDTEXT
NumberOfProductChanges Number of CRM Product Changes
DivisionName Division Description TEXT20
UtilitiesPreviousProduct Previous Product ESALES_CRM_PRODUCT
UtilitiesProduct Target CRM Product ESALES_CRM_PRODUCT
UtilsBillgBlockReasonName Text (30 Characters) TEXT30
UtilsBillgUnblockReasonName Text (30 Characters) TEXT30
UtilsContractCreatedByUser Name of Person Responsible for Creating the Object USNAM
UtilsContractLastChangedByUser Name of Person Who Changed Object USNAM
UtilsContractProcessingStsName Processing Status Name TEXT50
UtilsMoveInDateAsYearMonth Move-In Date Formatted As YearMonth NUM6
UtilsMoveOutDateAsYearMonth Move-Out Date Formatted As YearMonth NUM6
UtilsPlantOrCompanyCnsmpnName Plant or Company Consumption Name DDTEXT
NrOfCreatedUtilitiesContract Number of Created Contracts
NrOfTerminatedUtilsContracts Number of Terminated Contracts
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Dunning Procedure
  • Client
  • Dunning Procedure
  • C_UTILSCONTRACTCHANGEHISTORYQ.MANDT == TFK047A.MANDT
  • C_UTILSCONTRACTCHANGEHISTORYQ.CADUNNINGPROCEDURE == TFK047A.MAHNV
Company Code
  • Company Code
  • Client
  • C_UTILSCONTRACTCHANGEHISTORYQ.COMPANYCODE == T001.BUKRS
  • C_UTILSCONTRACTCHANGEHISTORYQ.MANDT == T001.MANDT
Account Determination Code
  • Company Code
  • Account Determination Code
  • Client
  • Division
  • C_UTILSCONTRACTCHANGEHISTORYQ.COMPANYCODE == TE097.BUKRS
  • C_UTILSCONTRACTCHANGEHISTORYQ.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • C_UTILSCONTRACTCHANGEHISTORYQ.MANDT == TE097.MANDT
  • C_UTILSCONTRACTCHANGEHISTORYQ.UTILITIESDIVISION == TE097.SPARTE
Service Provider
  • Client
  • Service Provider
  • C_UTILSCONTRACTCHANGEHISTORYQ.MANDT == ESERVPROV.MANDT
  • C_UTILSCONTRACTCHANGEHISTORYQ.UTILITIESSERVICEPROVIDER == ESERVPROV.SERVICEID
Billing Block Reason
  • Billing Block Reason
  • Client
  • C_UTILSCONTRACTCHANGEHISTORYQ.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
  • C_UTILSCONTRACTCHANGEHISTORYQ.MANDT == TE021.MANDT
Release Reason
  • Release Reason
  • Client
  • C_UTILSCONTRACTCHANGEHISTORYQ.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
  • C_UTILSCONTRACTCHANGEHISTORYQ.MANDT == TE023.MANDT
Processing Status
  • Client
  • Processing Status
  • C_UTILSCONTRACTCHANGEHISTORYQ.MANDT == TE643.MANDT
  • C_UTILSCONTRACTCHANGEHISTORYQ.UTILSCONTRACTPROCESSINGSTS == TE643.BEARKZ
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_UTILSCONTRACTCHANGEHISTORYQ.MANDT == TESPT.MANDT
  • C_UTILSCONTRACTCHANGEHISTORYQ.UTILITIESDIVISION == TESPT.SPARTE