SAP Table EVERD

Screen Fields: IS-U Cont.

EVERD (Screen Fields: 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 EVERD to other SAP tables.

Source: EVERD (Screen Fields: IS-U Cont.)

EVERD 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
V_VERTRAG Contract VERTRAG CHAR 10 0
ADRNB_TXJCD Address number AD_ADDRNUM CHAR 10 0
SERVICE Service Type SERCODE CHAR 4 0
INVLOCKR Reason For Invoicing Lock INV_LOCKREASON_KK TFK080R1 CHAR 1 0
INVLOCKRVON Lock valid from FDATE_KK DATS 8 0
BVAR Processing variant: general BVAR CHAR 4 0
INVLOCKRBIS Lock valid to TDATE_KK DATS 8 0
VORLAGE Outline text E_RAHMEN20 CHAR 20 0
RAHMEN1 Outline text E_RAHMEN50 CHAR 50 0
RAHMEN2 Outline text E_RAHMEN50 CHAR 50 0
RAHMEN3 Outline text E_RAHMEN50 CHAR 50 0
RAHMEN4 Outline text E_RAHMEN50 CHAR 50 0
RAHMEN5 Outline text E_RAHMEN50 CHAR 50 0
RAHMEN6 Outline text E_RAHMEN50 CHAR 50 0
RAHMEN7 Outline text E_RAHMEN50 CHAR 50 0
RAHMEN8 Outline text E_RAHMEN50 CHAR 50 0
RAHMEN9 Outline text E_RAHMEN50 CHAR 50 0

EVERD foreign key relationships

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