SAP Table EVER

IS-U Cont.

EVER (IS-U Cont.) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EVER to other SAP tables.

EVER table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VERTRAG Contract VERTRAG CHAR 10 0
BUKRS Company Code BUKRS T001 CHAR 4 0
SPARTE Division SPARTE TESPT CHAR 2 0
EIGENVERBR Plant or company consumption EIGENVERBR CHAR 1 0
NULL Customer consumption
1 Plant consumption
2 Company consumption
KOFIZ Account determination ID for IS-U contracts E_KOFIZ TE097 CHAR 2 0
PORTION Alternative portion PORTIONABW TE420 CHAR 8 0
ABSLANFO Budget billing request for debtor ABSLANFO CHAR 1 0
NULL Default from customizing
1 One budget billing request for all due dates
2 1st due date req. with bill; separate BB req. for remainder
3 Separate budget billing request for each due date
ABSZYK Overrriding BB cycle on contract level ABSZYKV CHAR 2 0
ABSMNANP Do not adjust budget billing amount automatically ABSMNANP CHAR 1 0
NULL Do not set flag
X Set flag
GEMFAKT Invoice Contracts Jointly (Mandatory Contracts) E_GEMFAKT CHAR 1 0
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 MANABR CHAR 1 0
NULL Field inactive
X Field active
ABRSPERR Reason for blocking billing ABRSPERR TE021 CHAR 2 0
ABRFREIG Reason for releasing billing ABRFREIG TE023 CHAR 2 0
BSTATUS Processing status BEARKZ TE643 CHAR 2 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
VBEZ Text for contract E_VBEZ CHAR 35 0
VBEGINN Start of contract E_VBEGINN DATS 8 0
EINZDAT_ALT Move-in date from legacy system EINZDAT_ALT DATS 8 0
VENDE End of contract E_VENDE DATS 8 0
KUENDDAT Cancellation date of contract KUENDAT DATS 8 0
KFRIST Number of time units for cancellation KUENZEIT NUMC 3 0
KUENPER Time unit for cancellation KUENPER CHAR 1 0
3 Weeks
2 Years
1 Months
0 Days
VBISDAT Renewal date of contract E_VBISDAT DATS 8 0
VERLAENG Number of time units for renewal VERZEIT NUMC 3 0
VERPER Time unit for renewal VERPER CHAR 1 0
3 Weeks
2 Years
1 Months
0 Days
VABSCHLEVU Date on which utility concluded the contract E_VSCHLEVU DATS 8 0
VABSCHLKND Date on which customer concluded the contract E_VSCHLKND DATS 8 0
VABSCHLKNDTI Time at which customer signed contract E_VSCHLKNDTI TIMS 6 0
PERSNR Personnel Number PERNR_D NUMC 8 0
VREFER Contract number from legacy system E_VREFER CHAR 20 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BEGRU Authorization Group BEGRU CHAR 4 0
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
MANOUTSORT Reason for manual outsorting in billing MANOUTSORT TE127 CHAR 8 0
FAKTURIERT Contract has already been invoiced FAKTURIERT CHAR 1 0
NULL Field inactive
X Field active
AUFNR Order Number AUFNR AUFK CHAR 12 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
COPAKONT Indicator: Profitability segment assigned (CO-PA) E_COPAKONT CHAR 1 0
X Yes
NULL No
AUSGRUP Outsorting check group for billing AUSGRUP TE191 CHAR 8 0
OUTCOUNT Number of manual outsortings to be carried out yet OUTCOUNT NUMC 2 0
PYPLT Payment plan type E_PYPLT TE015 CHAR 4 0
PYPLS Starting month of payment plan E_PYPLS NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
GSBER Business Area GSBER TGSB CHAR 4 0
SEGMENT Segment for Segmental Reporting SEGMT_KK FAGL_SEGM CHAR 10 0
SERVICEID Service Provider SERVICE_PROV ESERVPROV CHAR 10 0
SRVPRVREF Reference number of service provider SRVPRVREF CHAR 30 0
BILLMETHOD Billing method BILLMETHOD CHAR 2 0
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 E_STGRUV TE770 CHAR 2 0
PYPLA Alternative start month of payment plan E_PYPLA NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
BILLFINIT Contract terminated for billing reasons BILLFINIT CHAR 1 0
NULL Field inactive
X Field active
BFA_DEB_STAT Payment plan - BF amount not released for receivable E_BFA_PROC_DEBIT CHAR 1 0
NULL Release
1 Do not release
BFA_CRED_STAT Payment plan - BF amount not released for credit E_BFA_PROC_CREDIT CHAR 1 0
NULL Release
1 Do not release
SALESEMPLOYEE Sales employee VRTNR NUMC 8 0
SALESPARTNER Sales partners ESALESPARTNER KNA1 CHAR 10 0
SALESDOCUMENT Sales and Distribution Document Number VBELN VBUK CHAR 10 0
PS_STARTDAT Start Date of Payment Scheme (PS) PS_STARTDAT DATS 8 0
SERVPROV_PAY Payment Class SERVPROV_PAY ESERVPROV_PAY CHAR 4 0
INVOICING_PARTY Service Provider That Invoices the Contract INVOICING_PARTY CHAR 10 0
COKEY CO account assignment key, IS-U contract COKEY_EE2 TECOK CHAR 10 0
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
CONTRACTCLASS Contract Class CONTRACTCLASS TECONTRACTCLASS CHAR 4 0
CANCREASON Reason for Cancellation of Contract VKGRU_VEDA CHAR 2 0
CANCREASON_NEW Cancellation Reason (CRM) ECRMT_SRV_CANCEL_REASON CHAR 4 0
EXTRAPOLWASTE Category of Waste Disposal Budget Billing Extrapolation EXTRAPOLWASTE CHAR 2 0
01 Automatically
02 via Service Frequency
03 via Previous Period
04 via Previous Year Period
PPM_CONTRACT Identifies Contract as Prepayment Meter Contract E_PP_PPM_CONTRACT CHAR 1 0
OSB_GROUP On-Site Billing Group E_OSB_GROUP TE555 CHAR 3 0
OUCONT Outline Contract OUCONT CHAR 1 0
NULL Field inactive
X Field active
RULEGR Rule Group for Outline Agreements RULEGR CHAR 10 0
01 Joint Blocking
02 Bonus Calculation
03 Purchasing Communities
99 Customer-Specific, Multiple Contract Billing
REGIOGROUP Regional structure grouping REGIOGROUP ADRREGGRP CHAR 8 0
CMGRP Collection Management: Master Data Group CMGRP_CM_KK TFK041B CHAR 2 0
STRAT Collection Strategy STRAT_CM_KK TFK047X CHAR 2 0
CPERS Collections Contact Person CPERS_CM_KK CHAR 10 0
ANLAGE Installation ANLAGE CHAR 10 0
VKONTO Contract Account Number VKONT_KK FKKVK CHAR 12 0
KZSONDEINZ Move-In Processing (Special Case) KZSONDEINZ CHAR 1 0
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 KZSONDAUSZ CHAR 1 0
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 AUTEIGEINZ CHAR 1 0
X Selection character
NULL Blank
EINZDAT Move-In Date EINZDAT DATS 8 0
AUSZDAT Move-Out Date AUSZDAT DATS 8 0
ABSSTOPDAT Stop date for budget bill. requests in the case of move-out ABSSTOPDAT DATS 8 0
SCHLFAKT Joint final billing for move-in/out SCHLFAKT CHAR 1 0
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
MAHNV Dunning Procedure MAHNV_KK TFK047A CHAR 2 0
MAHNVUMZ Move-in/out dunning procedure MAHNV_UMZ TFK047A CHAR 2 0
MANSP Dunning Lock Reason MANSP_KK TFK047S CHAR 1 0
BEZUG Reference BEZUG CHAR 1 0
NULL Field inactive
X Field active
TRANSVER Transfer contract E_TRANSVER EVER CHAR 10 0
SSWTCREASON Reasons for contract change SSWTCREASON TE960 CHAR 2 0
XVERA Contract created due to data transfer XVERA CHAR 1 0
NULL Field inactive
X Field active

EVER foreign key relationships

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