CRMS4_IU_C_UTCT

Utilities Contract | view: CRMS4IUVCUTCT | 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
VERTRAG Contract
Column Name Description
Column Name Description
Column Name Description
EINZDAT Move-In
AUSZDAT Move-Out
ERDAT Date on which the record was created
AEDAT Last Changed On
KUENDDAT Cancellation date of contract
VBISDAT 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
MANABR Contract Is Billed Manually Show values
BILLFINIT Contract Terminated for Billing Reasons Show values
EIGENVERBR Plant or company consumption Show values
GEMFAKT Invoice Contracts Jointly Show values
LOEVM Deletion Indicator Show values
ABSZYK 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
SPARTE_DESC Division Description TEXT20
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
BEGRU Authorization Group BEGRU
VBEZ 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
SalesContractItemExists null
Master Data Relations Join Conditions
Release Reason
  • Client
  • Release Reason
  • CRMS4_IU_C_UTCT.MANDT == TE023.MANDT
  • CRMS4_IU_C_UTCT.ABRFREIG == TE023.ABRFREIG
Billing Block Reason
  • Client
  • Billing Block Reason
  • CRMS4_IU_C_UTCT.MANDT == TE021.MANDT
  • CRMS4_IU_C_UTCT.ABRSPERR == TE021.ABRSPERR
Outsorting check group for billing
  • Outsorting check group for billing
  • Client
  • CRMS4_IU_C_UTCT.AUSGRUP == TE191.AUSGRUP
  • CRMS4_IU_C_UTCT.MANDT == TE191.MANDT
Processing Status
  • Processing Status
  • Client
  • CRMS4_IU_C_UTCT.BSTATUS == TE643.BEARKZ
  • CRMS4_IU_C_UTCT.MANDT == TE643.MANDT
Company Code
  • Company Code
  • Client
  • CRMS4_IU_C_UTCT.BUKRS == T001.BUKRS
  • CRMS4_IU_C_UTCT.MANDT == T001.MANDT
Business Place
  • Company Code
  • ?
  • Client
  • Business Place
  • CRMS4_IU_C_UTCT.BUKRS == J_1BBRANCH.BUKRS
  • CRMS4_IU_C_UTCT.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • CRMS4_IU_C_UTCT.MANDT == J_1BBRANCH.MANDT
  • CRMS4_IU_C_UTCT.BUPLA == J_1BBRANCH.BRANCH
CO account assignment key, IS-U contract
  • Client
  • CO account assignment key, IS-U contract
  • CRMS4_IU_C_UTCT.MANDT == TECOK.MANDT
  • CRMS4_IU_C_UTCT.COKEY == TECOK.COKEY
Contract Class
  • Contract Class
  • Client
Business Area
  • Client
  • Business Area
  • CRMS4_IU_C_UTCT.MANDT == TGSB.MANDT
  • CRMS4_IU_C_UTCT.GSBER == TGSB.GSBER
Account Determination Code
  • Company Code
  • Account Determination Code
  • Client
  • Division
  • CRMS4_IU_C_UTCT.BUKRS == TE097.BUKRS
  • CRMS4_IU_C_UTCT.KOFIZ == TE097.KOFIZ
  • CRMS4_IU_C_UTCT.MANDT == TE097.MANDT
  • CRMS4_IU_C_UTCT.SPARTE == TE097.SPARTE
Dunning Procedure
  • Client
  • Dunning Procedure
  • CRMS4_IU_C_UTCT.MANDT == TFK047A.MANDT
  • CRMS4_IU_C_UTCT.MAHNV == TFK047A.MAHNV
Move-in/out dunning procedure
  • Client
  • Move-in/out dunning procedure
  • CRMS4_IU_C_UTCT.MANDT == TFK047A.MANDT
  • CRMS4_IU_C_UTCT.MAHNVUMZ == TFK047A.MAHNV
Outsorting Reason
  • Client
  • Outsorting Reason
  • CRMS4_IU_C_UTCT.MANDT == TE127.MANDT
  • CRMS4_IU_C_UTCT.MANOUTSORT == TE127.MANOUTSORT
Alternative portion
  • Client
  • Alternative portion
  • CRMS4_IU_C_UTCT.MANDT == TE420.MANDT
  • CRMS4_IU_C_UTCT.PORTION == TE420.TERMSCHL
Regional structure grouping
  • Client
  • Regional structure grouping
  • CRMS4_IU_C_UTCT.MANDT == ADRREGGRP.CLIENT
  • CRMS4_IU_C_UTCT.REGIOGROUP == ADRREGGRP.REGIOGROUP
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
Service Provider
  • Service Provider
  • Client
  • CRMS4_IU_C_UTCT.SERVICEID == ESERVPROV.SERVICEID
  • CRMS4_IU_C_UTCT.MANDT == ESERVPROV.MANDT
Payment Class
  • Client
  • Payment Class
Client
  • Client
  • Statistics group for contract
  • CRMS4_IU_C_UTCT.MANDT == TE770.MANDT
  • CRMS4_IU_C_UTCT.STAGRUVER == TE770.STAGRUVER
Contract Account Number
  • Client
  • Contract Account Number
  • CRMS4_IU_C_UTCT.MANDT == FKKVK.MANDT
  • CRMS4_IU_C_UTCT.VKONTO == FKKVK.VKONT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • CRMS4_IU_C_UTCT.MANDT == TESPT.MANDT
  • CRMS4_IU_C_UTCT.SPARTE == TESPT.SPARTE