SAP table EVER (IS-U Cont.)

SAP table EVER has 2 primary key fields being MANDT,VERTRAG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VERTRAG Contract CHAR 10 0 VERTRAG
BUKRS Company Code CHAR 4 0 T001 BUKRS
SPARTE Division CHAR 2 0 TESPT SPARTE
EIGENVERBR Plant or company consumption CHAR 1 0 EIGENVERBR
Customer consumption
1 Plant consumption
2 Company consumption
KOFIZ Account determination ID for IS-U contracts CHAR 2 0 TE097 E_KOFIZ
PORTION Alternative portion CHAR 8 0 TE420 PORTIONABW
ABSLANFO Budget billing request for debtor CHAR 1 0 ABSLANFO
ABSZYK Overrriding BB cycle on contract level CHAR 2 0 ABSZYKV
Budget billing cycle of allocated portion
00 No budget billing amounts
01 Monthly interval between budget billing amounts
02 Bimonthly interval between budget billing amounts
03 Three-monthly interval between budget billing amounts
04 Four-monthly interval between budget billing amounts
06 Six-monthly interval between budget billing amounts
12 Annual budget billing amount
ABSMNANP Do not adjust budget billing amount automatically CHAR 1 0 ABSMNANP
GEMFAKT Invoice Contracts Jointly (Mandatory Contracts) CHAR 1 0 E_GEMFAKT
1 Contract must be invoiced jointly with other contracts
2 Contract can be invoiced jointly with other contracts
3 Contract must not be invoiced with other contracts
MANABR Bill contract manually CHAR 1 0 MANABR
ABRSPERR Reason for blocking billing CHAR 2 0 TE021 ABRSPERR
ABRFREIG Reason for releasing billing CHAR 2 0 TE023 ABRFREIG
BSTATUS Processing status CHAR 2 0 TE643 BEARKZ
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
VBEZ Text for contract CHAR 35 0 E_VBEZ
VBEGINN Start of contract DATS 8 0 E_VBEGINN
EINZDAT_ALT Move-in date from legacy system DATS 8 0 EINZDAT_ALT
VENDE End of contract DATS 8 0 E_VENDE
KUENDDAT Cancellation date of contract DATS 8 0 KUENDAT
KFRIST Number of time units for cancellation NUMC 3 0 KUENZEIT
KUENPER Time unit for cancellation CHAR 1 0 KUENPER
VBISDAT Renewal date of contract DATS 8 0 E_VBISDAT
VERLAENG Number of time units for renewal NUMC 3 0 VERZEIT
VERPER Time unit for renewal CHAR 1 0 VERPER
VABSCHLEVU Date on which utility concluded the contract DATS 8 0 E_VSCHLEVU
VABSCHLKND Date on which customer concluded the contract DATS 8 0 E_VSCHLKND
VABSCHLKNDTI Time at which customer signed contract TIMS 6 0 E_VSCHLKNDTI
PERSNR Personnel Number NUMC 8 0 PERNR_D
VREFER Contract number from legacy system CHAR 20 0 E_VREFER
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BEGRU Authorization Group CHAR 4 0 BEGRU
LOEVM Deletion Indicator CHAR 1 0 LOEVM
TXJCD Tax Jurisdiction CHAR 15 0 * TXJCD
MANOUTSORT Reason for manual outsorting in billing CHAR 8 0 TE127 MANOUTSORT
FAKTURIERT Contract has already been invoiced CHAR 1 0 FAKTURIERT
AUFNR Order Number CHAR 12 0 AUFK AUFNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
COPAKONT Indicator: Profitability segment assigned (CO-PA) CHAR 1 0 E_COPAKONT
AUSGRUP Outsorting check group for billing CHAR 8 0 TE191 AUSGRUP
OUTCOUNT Number of manual outsortings to be carried out yet NUMC 2 0 OUTCOUNT
PYPLT Payment plan type CHAR 4 0 TE015 E_PYPLT
PYPLS Starting month of payment plan NUMC 2 0 E_PYPLS
GSBER Business Area CHAR 4 0 TGSB GSBER
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM SEGMT_KK
SERVICEID Service Provider CHAR 10 0 ESERVPROV SERVICE_PROV
SRVPRVREF Reference number of service provider CHAR 30 0 SRVPRVREF
BILLMETHOD Billing method CHAR 2 0 BILLMETHOD
01 Local processing
02 External billing and invoicing
03 Local billing and external invoicing
04 Local invoicing and external billing
STAGRUVER Statistics group for contract CHAR 2 0 TE770 E_STGRUV
PYPLA Alternative start month of payment plan NUMC 2 0 E_PYPLA
BILLFINIT Contract Terminated for Billing Reasons CHAR 1 0 BILLFINIT
BFA_DEB_STAT Payment plan - BF amount not released for receivable CHAR 1 0 E_BFA_PROC_DEBIT
BFA_CRED_STAT Payment plan - BF amount not released for credit CHAR 1 0 E_BFA_PROC_CREDIT
SALESEMPLOYEE Sales employee NUMC 8 0 VRTNR
SALESPARTNER Sales partners CHAR 10 0 KNA1 ESALESPARTNER
SALESDOCUMENT Sales and Distribution Document Number CHAR 10 0 * VBELN
PS_STARTDAT Start Date of Payment Scheme (PS) DATS 8 0 PS_STARTDAT
SERVPROV_PAY Payment Class CHAR 4 0 ESERVPROV_PAY SERVPROV_PAY
INVOICING_PARTY Service Provider That Invoices the Contract CHAR 10 0 * INVOICING_PARTY
COKEY CO account assignment key, IS-U contract CHAR 10 0 TECOK COKEY_EE2
BUPLA Business Place CHAR 4 0 J_1BBRANCH BUPLA
CONTRACTCLASS Contract Class CHAR 4 0 TECONTRACTCLASS CONTRACTCLASS
CANCREASON Reason for Cancellation of Contract CHAR 2 0 * VKGRU_VEDA
CANCREASON_NEW Cancellation Reason (CRM) CHAR 4 0 * ECRMT_SRV_CANCEL_REASON
EXTRAPOLWASTE Category of Waste Disposal Budget Billing Extrapolation CHAR 2 0 EXTRAPOLWASTE
01 Automatically
02 via Service Frequency
03 via Previous Period
04 via Previous Year Period
PPM_CONTRACT Identifies Contract as Prepayment Meter Contract CHAR 1 0 E_PP_PPM_CONTRACT
OSB_GROUP On-Site Billing Group CHAR 3 0 TE555 E_OSB_GROUP
OUCONT Outline Contract CHAR 1 0 OUCONT
RULEGR Rule Group for Outline Agreements CHAR 10 0 RULEGR
01 Joint Blocking
02 Bonus Calculation
03 Purchasing Communities
99 Customer-Specific, Multiple Contract Billing
REGIOGROUP Regional structure grouping CHAR 8 0 ADRREGGRP REGIOGROUP
CMGRP Collection Management: Master Data Group CHAR 2 0 TFK041B CMGRP_CM_KK
STRAT Collection Strategy CHAR 2 0 TFK047X STRAT_CM_KK
CPERS Collections Contact Person CHAR 10 0 * CPERS_CM_KK
ANLAGE Installation CHAR 10 0 ANLAGE
VKONTO Contract Account Number CHAR 12 0 FKKVK VKONT_KK
KZSONDEINZ Move-In Processing (Special Case) CHAR 1 0 KZSONDEINZ
2 Transfer
4 Contract Change (Old)
6 Customer Change
7 Contract Change Without Invoicing
8 Move-In Inserted in Final Vacant Status Period
A Supplier Change
B Contract change with invoicing (new)
KZSONDAUSZ Special move-out processing case exists CHAR 1 0 KZSONDAUSZ
1 Move-out w/o move-in
4 Contract change (contracts before 4.63 suppl./cont. change)
6 Customer Change
7 Contract change without invoicing
8 Insert move-in/out
A Supplier change
B Contract change with invoicing (new)
AUTEIGEINZ Automatic Owner Move-In CHAR 1 0 AUTEIGEINZ
EINZDAT Move-In Date DATS 8 0 EINZDAT
AUSZDAT Move-Out Date DATS 8 0 AUSZDAT
ABSSTOPDAT Stop date for budget bill. requests in the case of move-out DATS 8 0 ABSSTOPDAT
SCHLFAKT Joint final billing for move-in/out CHAR 1 0 SCHLFAKT
MAHNV Dunning Procedure CHAR 2 0 TFK047A MAHNV_KK
MAHNVUMZ Move-in/out dunning procedure CHAR 2 0 TFK047A MAHNV_UMZ
MANSP Dunning Lock Reason CHAR 1 0 TFK047S MANSP_KK
BEZUG Purchase CHAR 1 0 BEZUG
TRANSVER Transfer contract CHAR 10 0 EVER E_TRANSVER
SSWTCREASON Reasons for contract change CHAR 2 0 TE960 SSWTCREASON
XVERA Contract created due to data transfer CHAR 1 0 XVERA
COLOGRP_INST Colocation group for Installation CHAR 12 0 E_COLOGRP_INST

EVER foreign key relationships

Table Field Check Table Check Field
0 EVER ABRFREIG TE023 Rs.for Releas. MANDT
0 EVER ABRFREIG TE023 Rs.for Releas. ABRFREIG
1 EVER ABRSPERR TE021 Reas.for Blockg Billg MANDT
1 EVER ABRSPERR TE021 Reas.for Blockg Billg ABRSPERR
0 EVER AUFNR AUFK Order master data AUFNR
1 EVER AUSGRUP TE191 Outsorting Check Groups for Billing MANDT
0 EVER BSTATUS TE643 Processing Status MANDT
0 EVER BSTATUS TE643 Processing Status BEARKZ
1 EVER BUKRS T001 Company Codes BUKRS
0 EVER BUPLA J_1BBRANCH Business Place BUKRS
0 EVER BUPLA J_1BBRANCH Business Place BRANCH
0 EVER BUPLA J_1BBRANCH Business Place BUPLA_TYPE
1 EVER CMGRP TFK041B Master Data Groups MANDT
1 EVER CMGRP TFK041B Master Data Groups CMGRP
0 EVER COKEY TECOK CO account assignment key IS-U contract MANDT
0 EVER COKEY TECOK CO account assignment key IS-U contract COKEY
1 EVER CONTRACTCLASS TECONTRACTCLASS IS-U Contract Classes MANDT
1 EVER CONTRACTCLASS TECONTRACTCLASS IS-U Contract Classes CONTRACTCLASS
0 EVER GSBER TGSB Business Areas MANDT
0 EVER GSBER TGSB Business Areas GSBER
1 EVER KOFIZ TE097 Account Determ. IDs MANDT
1 EVER KOFIZ TE097 Account Determ. IDs BUKRS
1 EVER KOFIZ TE097 Account Determ. IDs KOFIZ
0 EVER KOSTL CSKS Cost Center Master Record MANDT
0 EVER KOSTL CSKS Cost Center Master Record KOKRS
0 EVER KOSTL CSKS Cost Center Master Record KOSTL
0 EVER KOSTL CSKS Cost Center Master Record DATBI
1 EVER MAHNV TFK047A Dunning procedure MAHNV
0 EVER MAHNVUMZ TFK047A Dunning procedure MAHNV
1 EVER MANDT T000 Clients MANDT
0 EVER MANOUTSORT TE127 Manual Bill Outsorting for Billing MANDT
1 EVER OSB_GROUP TE555 On-Site Billing Billing Groups MANDT
1 EVER OSB_GROUP TE555 On-Site Billing Billing Groups OSB_GROUP
0 EVER PORTION TE420 Sch. Mast. Data: Portion MANDT
1 EVER PRCTR CEPC Profit Center Master Data Table PRCTR
1 EVER PRCTR CEPC Profit Center Master Data Table DATBI
1 EVER PRCTR CEPC Profit Center Master Data Table KOKRS
0 EVER PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 EVER PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 EVER PYPLT TE015 Payment plan type for category AMB/BBP MANDT
0 EVER REGIOGROUP ADRREGGRP Regional structure grouping CLIENT
1 EVER SALESPARTNER KNA1 General Data in Customer Master MANDT
1 EVER SALESPARTNER KNA1 General Data in Customer Master KUNNR
0 EVER SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 EVER SERVICEID ESERVPROV Service Providers SERVICEID
0 EVER SERVPROV_PAY ESERVPROV_PAY Payment Class for Service Provider MANDT
0 EVER SERVPROV_PAY ESERVPROV_PAY Payment Class for Service Provider SERVPROV_PAY
1 EVER SPARTE TESPT Alloc. of Div. Cat. to Div. MANDT
0 EVER SSWTCREASON TE960 Reasons for Contract Change MANDT
0 EVER SSWTCREASON TE960 Reasons for Contract Change SSWTCREASON
1 EVER STAGRUVER TE770 Contract: Statistics Groups MANDT
1 EVER STAGRUVER TE770 Contract: Statistics Groups STAGRUVER
0 EVER TRANSVER EVER IS-U Cont. MANDT
1 EVER VKONTO FKKVK Contract Account Header VKONT