CRMS4_IU_I_UTCT

Utilities Contract | view: CRMS4IUVIUTCT | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: CRMS4D_IUCH_H, CRMS4D_IUCI_I, CRMS4D_IUCI_I, CRMS4D_IUCI_I, MAKT, EVER, TSPA, TSPAT, EVER, EANL
Column Name Description
UtilitiesContract Contract
Column Name Description
Column Name Description
Column Name Description
UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate Move-Out
UtilsContractCreationDate Date on which the record was created
UtilsContractLastChangeDate Last Changed On
UtilitiesContractCanclnDate Cancellation date of contract
UtilitiesContractRenewalDate Renewal date of contract
vbeginn Start of contract
vende End of contract
vabschlevu Date on which utility concluded the contract
vabschlknd Date on which customer concluded the contract
vabschlkndti Time at which customer signed contract
Column Name Description
UtilsContrIsBilledManually Contract Is Billed Manually Show values
UtilsContrIsFinallyBilled Contract Terminated for Billing Reasons Show values
UtilsPlantOrCompanyConsumption Plant or company consumption Show values
UtilsContrJointInvcType Invoice Contracts Jointly Show values
DeletionIndicator Deletion Indicator Show values
UtilsContrSpcfcBdgtBillgCycle Overriding Budget Billing Cycle Show values
fakturiert Contract has already been invoiced Show values
absmnanp Do not adjust budget billing amount automatically Show values
verper Time unit for renewal Show values
kuenper Time unit for cancellation Show values
Column Name Description Domain name
UtilsContractCreatedByUser Name of Person Responsible for Creating the Object USNAM
UtilsContractLastChangedByUser Name of Person Who Changed Object USNAM
AuthorizationGroup Authorization Group BEGRU
UtilitiesContractDescription Text for contract TEXT35
persnr Personnel Number PERNR
vrefer Contract number from legacy system TEXT20
outcount Number of manual outsortings to be carried out yet OUTNUMBER
srvprvref Reference number of service provider CHAR30
invoicing_party Service Provider That Invoices the Contract SERVICE_PROV
verlaeng Number of time units for renewal PERWERT
kfrist Number of time units for cancellation PERWERT
DivisionName Division Description TEXT20
SalesContractItemExists null
Master Data Relations Join Conditions
Alternative portion
  • Client
  • Alternative portion
  • CRMS4_IU_I_UTCT.MANDT == TE420.MANDT
  • CRMS4_IU_I_UTCT.ALTERNATIVEUTILITIESPORTION == TE420.TERMSCHL
Business Place
  • Business Place
  • ?
  • Client
  • Company Code
  • CRMS4_IU_I_UTCT.BUPLA == J_1BBRANCH.BRANCH
  • CRMS4_IU_I_UTCT.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • CRMS4_IU_I_UTCT.MANDT == J_1BBRANCH.MANDT
  • CRMS4_IU_I_UTCT.COMPANYCODE == J_1BBRANCH.BUKRS
Dunning Procedure
  • Dunning Procedure
  • Client
  • CRMS4_IU_I_UTCT.CADUNNINGPROCEDURE == TFK047A.MAHNV
  • CRMS4_IU_I_UTCT.MANDT == TFK047A.MANDT
CO account assignment key, IS-U contract
  • CO account assignment key, IS-U contract
  • Client
  • CRMS4_IU_I_UTCT.COKEY == TECOK.COKEY
  • CRMS4_IU_I_UTCT.MANDT == TECOK.MANDT
Company Code
  • Client
  • Company Code
  • CRMS4_IU_I_UTCT.MANDT == T001.MANDT
  • CRMS4_IU_I_UTCT.COMPANYCODE == T001.BUKRS
Contract Account Number
  • Client
  • Contract Account Number
  • CRMS4_IU_I_UTCT.MANDT == FKKVK.MANDT
  • CRMS4_IU_I_UTCT.CONTRACTACCOUNT == FKKVK.VKONT
Contract Class
  • Client
  • Contract Class
Business Area
  • Client
  • Business Area
  • CRMS4_IU_I_UTCT.MANDT == TGSB.MANDT
  • CRMS4_IU_I_UTCT.GSBER == TGSB.GSBER
Move-in/out dunning procedure
  • Client
  • Move-in/out dunning procedure
  • CRMS4_IU_I_UTCT.MANDT == TFK047A.MANDT
  • CRMS4_IU_I_UTCT.MAHNVUMZ == TFK047A.MAHNV
Regional structure grouping
  • Regional structure grouping
  • Client
  • CRMS4_IU_I_UTCT.REGIOGROUP == ADRREGGRP.REGIOGROUP
  • CRMS4_IU_I_UTCT.MANDT == ADRREGGRP.CLIENT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Payment Class
  • Client
  • Payment Class
Client
  • Client
  • Statistics group for contract
  • CRMS4_IU_I_UTCT.MANDT == TE770.MANDT
  • CRMS4_IU_I_UTCT.STAGRUVER == TE770.STAGRUVER
Account Determination Code
  • Client
  • Company Code
  • Account Determination Code
  • Division
  • CRMS4_IU_I_UTCT.MANDT == TE097.MANDT
  • CRMS4_IU_I_UTCT.COMPANYCODE == TE097.BUKRS
  • CRMS4_IU_I_UTCT.UTILITIESACCOUNTDETNCODE == TE097.KOFIZ
  • CRMS4_IU_I_UTCT.UTILITIESDIVISION == TE097.SPARTE
Service Provider
  • Client
  • Service Provider
  • CRMS4_IU_I_UTCT.MANDT == ESERVPROV.MANDT
  • CRMS4_IU_I_UTCT.UTILITIESSERVICEPROVIDER == ESERVPROV.SERVICEID
Billing Block Reason
  • Client
  • Billing Block Reason
  • CRMS4_IU_I_UTCT.MANDT == TE021.MANDT
  • CRMS4_IU_I_UTCT.UTILSBILLGBLOCKREASON == TE021.ABRSPERR
Outsorting Reason
  • Client
  • Outsorting Reason
  • CRMS4_IU_I_UTCT.MANDT == TE127.MANDT
  • CRMS4_IU_I_UTCT.UTILSBILLGOUTSORTINGREASON == TE127.MANOUTSORT
Release Reason
  • Client
  • Release Reason
  • CRMS4_IU_I_UTCT.MANDT == TE023.MANDT
  • CRMS4_IU_I_UTCT.UTILSBILLGUNBLOCKREASON == TE023.ABRFREIG
Processing Status
  • Client
  • Processing Status
  • CRMS4_IU_I_UTCT.MANDT == TE643.MANDT
  • CRMS4_IU_I_UTCT.UTILSCONTRACTPROCESSINGSTS == TE643.BEARKZ
Outsorting check group for billing
  • Client
  • Outsorting check group for billing
  • CRMS4_IU_I_UTCT.MANDT == TE191.MANDT
  • CRMS4_IU_I_UTCT.UTILSOUTSRTGCHECKGRPFORBILLG == TE191.AUSGRUP
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • CRMS4_IU_I_UTCT.MANDT == TESPT.MANDT
  • CRMS4_IU_I_UTCT.UTILITIESDIVISION == TESPT.SPARTE