SAP ABAP Table EVERA (IS-U Contract: General Fields)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-MD (Application Component) Master Data
     ⤷ EE01 (Package) IS-U Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	EVERA	Table Relationship Diagram
Short Description	IS-U Contract: General Fields

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TESPT
3	EIGENVERBR	☐	EIGENVERBR	EIGENVERBR	CHAR	1	0	Plant or company consumption
4	KOFIZ	☐	E_KOFIZ	E_KOFIZ	CHAR	2	0	Account determination ID for IS-U contracts	TE097
5	PORTION	☐	PORTIONABW	PORTION	CHAR	8	0	Alternative portion	TE420
6	ABSLANFO	☐	ABSLANFO	ABSLANFOAB	CHAR	1	0	Budget billing request for debtor
7	ABSZYK	☐	ABSZYKV	ABSZYKV	CHAR	2	0	Overrriding BB cycle on contract level
8	ABSMNANP	☐	ABSMNANP	AS4FLAG	CHAR	1	0	Do not adjust budget billing amount automatically
9	GEMFAKT	☐	E_GEMFAKT	E_GEMFAKT	CHAR	1	0	Invoice Contracts Jointly (Mandatory Contracts)
10	MANABR	☐	MANABR	KENNZX	CHAR	1	0	Bill contract manually
11	ABRSPERR	☐	ABRSPERR	ABRSPERR	CHAR	2	0	Reason for blocking billing	TE021
12	ABRFREIG	☐	ABRFREIG	ABRFREIG	CHAR	2	0	Reason for releasing billing	TE023
13	BSTATUS	☐	BEARKZ	BEARSTAT	CHAR	2	0	Processing status	TE643
14	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
15	VBEZ	☐	E_VBEZ	TEXT35	CHAR	35	0	Text for contract
16	VBEGINN	☐	E_VBEGINN	DATUM	DATS	8	0	Start of contract
17	EINZDAT_ALT	☐	EINZDAT_ALT	DATUM	DATS	8	0	Move-in date from legacy system
18	VENDE	☐	E_VENDE	DATUM	DATS	8	0	End of contract
19	KUENDDAT	☐	KUENDAT	DATUM	DATS	8	0	Cancellation date of contract
20	KFRIST	☐	KUENZEIT	PERWERT	NUMC	3	0	Number of time units for cancellation
21	KUENPER	☐	KUENPER	PERART	CHAR	1	0	Time unit for cancellation
22	VBISDAT	☐	E_VBISDAT	DATUM	DATS	8	0	Renewal date of contract
23	VERLAENG	☐	VERZEIT	PERWERT	NUMC	3	0	Number of time units for renewal
24	VERPER	☐	VERPER	PERART	CHAR	1	0	Time unit for renewal
25	VABSCHLEVU	☐	E_VSCHLEVU	DATUM	DATS	8	0	Date on which utility concluded the contract
26	VABSCHLKND	☐	E_VSCHLKND	DATUM	DATS	8	0	Date on which customer concluded the contract
27	VABSCHLKNDTI	☐	E_VSCHLKNDTI	TIMS	TIMS	6	0	Time at which customer signed contract
28	PERSNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
29	VREFER	☐	E_VREFER	TEXT20	CHAR	20	0	Contract number from legacy system
30	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
31	.INCLUDE	☐				0	0	Creation and Change Data
32	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
33	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
34	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
35	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
36	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
37	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
38	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
39	MANOUTSORT	☐	MANOUTSORT	MANOUTSORT	CHAR	8	0	Reason for manual outsorting in billing	TE127
40	FAKTURIERT	☐	FAKTURIERT	KENNZX	CHAR	1	0	Contract has already been invoiced
41	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
42	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
43	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
44	COPAKONT	☐	E_COPAKONT	XFELD	CHAR	1	0	Indicator: Profitability segment assigned (CO-PA)
45	AUSGRUP	☐	AUSGRUP	AUSGRUP	CHAR	8	0	Outsorting check group for billing	TE191
46	OUTCOUNT	☐	OUTCOUNT	OUTNUMBER	NUMC	2	0	Number of manual outsortings to be carried out yet
47	PYPLT	☐	E_PYPLT	E_PYPLT	CHAR	4	0	Payment plan type	TE015
48	PYPLS	☐	E_PYPLS	MONTH	NUMC	2	0	Starting month of payment plan
49	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
50	SEGMENT	☐	SEGMT_KK	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
51	SERVICEID	☐	SERVICE_PROV	SERVICE_PROV	CHAR	10	0	Service Provider	ESERVPROV
52	SRVPRVREF	☐	SRVPRVREF	CHAR30	CHAR	30	0	Reference number of service provider
53	BILLMETHOD	☐	BILLMETHOD	BILLMETHOD	CHAR	2	0	Billing method
54	STAGRUVER	☐	E_STGRUV	E_STGRUV	CHAR	2	0	Statistics group for contract	TE770
55	PYPLA	☐	E_PYPLA	MONTH	NUMC	2	0	Alternative start month of payment plan
56	BILLFINIT	☐	BILLFINIT	KENNZX	CHAR	1	0	Contract terminated for billing reasons
57	BFA_DEB_STAT	☐	E_BFA_PROC_DEBIT	E_BFA_PROCESSING	CHAR	1	0	Payment plan - BF amount not released for receivable
58	BFA_CRED_STAT	☐	E_BFA_PROC_CREDIT	E_BFA_PROCESSING	CHAR	1	0	Payment plan - BF amount not released for credit
59	SALESEMPLOYEE	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
60	SALESPARTNER	☐	ESALESPARTNER	KUNNR	CHAR	10	0	Sales partners	KNA1
61	SALESDOCUMENT	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
62	PS_STARTDAT	☐	PS_STARTDAT	DATS	DATS	8	0	Start Date of Payment Scheme (PS)
63	SERVPROV_PAY	☐	SERVPROV_PAY	SERVPROV_PAY	CHAR	4	0	Payment Class	ESERVPROV_PAY
64	INVOICING_PARTY	☐	INVOICING_PARTY	SERVICE_PROV	CHAR	10	0	Service Provider That Invoices the Contract	*
65	COKEY	☐	COKEY_EE2	CHAR10	CHAR	10	0	CO account assignment key, IS-U contract	TECOK
66	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
67	CONTRACTCLASS	☐	CONTRACTCLASS	ECONTRACTCLASS	CHAR	4	0	Contract Class	TECONTRACTCLASS
68	CANCREASON	☐	VKGRU_VEDA	KUEGRU	CHAR	2	0	Reason for cancellation of contract	*
69	CANCREASON_NEW	☐	ECRMT_SRV_CANCEL_REASON	QCODE	CHAR	4	0	Cancellation Reason (CRM)	*
70	EXTRAPOLWASTE	☐	EXTRAPOLWASTE	EXTRAPOLWASTE	CHAR	2	0	Category of Waste Disposal Budget Billing Extrapolation
71	PPM_CONTRACT	☐	E_PP_PPM_CONTRACT	E_PP_PPM_CONTRACT	CHAR	1	0	Identifies Contract as Prepayment Meter Contract
72	OSB_GROUP	☐	E_OSB_GROUP		CHAR	3	0	On-Site Billing Group	TE555
73	OUCONT	☐	OUCONT	KENNZX	CHAR	1	0	Outline Contract
74	RULEGR	☐	RULEGR	RULEGR	CHAR	10	0	Rule Group for Outline Agreements	*
75	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EVERA	ABRFREIG	TE023	ABRFREIG		1	CN
2	EVERA	ABRSPERR	TE021	ABRSPERR		1	CN
3	EVERA	AUFNR	AUFK	AUFNR		1	CN
4	EVERA	AUSGRUP	TE191	AUSGRUP	KEY	1	CN
5	EVERA	BSTATUS	TE643	BEARKZ		1	CN
6	EVERA	BUKRS	T001	BUKRS
7	EVERA	BUPLA	J_1BBRANCH	BRANCH
8	EVERA	COKEY	TECOK	COKEY
9	EVERA	CONTRACTCLASS	TECONTRACTCLASS	CONTRACTCLASS
10	EVERA	GSBER	TGSB	GSBER
11	EVERA	KOFIZ	TE097	KOFIZ		1	CN
12	EVERA	KOSTL	CSKS	KOSTL		1	CN
13	EVERA	MANOUTSORT	TE127	MANOUTSORT	KEY	1	CN
14	EVERA	OSB_GROUP	TE555	OSB_GROUP
15	EVERA	PORTION	TE420	TERMSCHL		1	CN
16	EVERA	PRCTR	CEPC	PRCTR		1	CN
17	EVERA	PS_PSP_PNR	PRPS	PSPNR		1	CN
18	EVERA	PYPLT	TE015	PYPLT	KEY	1	CN
19	EVERA	SALESDOCUMENT	VBUK	VBELN
20	EVERA	SALESPARTNER	KNA1	KUNNR
21	EVERA	SEGMENT	FAGL_SEGM	SEGMENT
22	EVERA	SERVICEID	ESERVPROV	SERVICEID
23	EVERA	SERVPROV_PAY	ESERVPROV_PAY	SERVPROV_PAY
24	EVERA	SPARTE	TESPT	SPARTE
25	EVERA	STAGRUVER	TE770	STAGRUVER

History

Last changed by/on	SAP	20110901
SAP Release Created in