SAP ABAP Table CONTRCL (Transfer Structure for Contract Key)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ EE30 (Package) IS-U: Contract Accounts Receivable and Payable

Basic Data

Table Category	INTTAB	Structure
Structure	CONTRCL	Table Relationship Diagram
Short Description	Transfer Structure for Contract Key

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	ABRVORG	☐	ABRVORG	ABRVORG	CHAR	2	0	Billing Transaction
2	INVVORG	☐	INVVORG	INVVORG	CHAR	2	0	Invoicing transaction
3	.INCLUDE	☐				0	0	IS-U Cont.
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract	*
6	.INCLUDE	☐				0	0	IS-U Contract: General Fields
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TESPT
9	EIGENVERBR	☐	EIGENVERBR	EIGENVERBR	CHAR	1	0	Plant or company consumption
10	KOFIZ	☐	E_KOFIZ	E_KOFIZ	CHAR	2	0	Account determination ID for IS-U contracts	TE097
11	PORTION	☐	PORTIONABW	PORTION	CHAR	8	0	Alternative portion	TE420
12	ABSLANFO	☐	ABSLANFO	ABSLANFOAB	CHAR	1	0	Budget billing request for debtor
13	ABSZYK	☐	ABSZYKV	ABSZYKV	CHAR	2	0	Overrriding BB cycle on contract level
14	ABSMNANP	☐	ABSMNANP	AS4FLAG	CHAR	1	0	Do not adjust budget billing amount automatically
15	GEMFAKT	☐	E_GEMFAKT	E_GEMFAKT	CHAR	1	0	Invoice Contracts Jointly (Mandatory Contracts)
16	MANABR	☐	MANABR	KENNZX	CHAR	1	0	Bill contract manually
17	ABRSPERR	☐	ABRSPERR	ABRSPERR	CHAR	2	0	Reason for blocking billing	TE021
18	ABRFREIG	☐	ABRFREIG	ABRFREIG	CHAR	2	0	Reason for releasing billing	TE023
19	BSTATUS	☐	BEARKZ	BEARSTAT	CHAR	2	0	Processing status	TE643
20	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
21	VBEZ	☐	E_VBEZ	TEXT35	CHAR	35	0	Text for contract
22	VBEGINN	☐	E_VBEGINN	DATUM	DATS	8	0	Start of contract
23	EINZDAT_ALT	☐	EINZDAT_ALT	DATUM	DATS	8	0	Move-in date from legacy system
24	VENDE	☐	E_VENDE	DATUM	DATS	8	0	End of contract
25	KUENDDAT	☐	KUENDAT	DATUM	DATS	8	0	Cancellation date of contract
26	KFRIST	☐	KUENZEIT	PERWERT	NUMC	3	0	Number of time units for cancellation
27	KUENPER	☐	KUENPER	PERART	CHAR	1	0	Time unit for cancellation
28	VBISDAT	☐	E_VBISDAT	DATUM	DATS	8	0	Renewal date of contract
29	VERLAENG	☐	VERZEIT	PERWERT	NUMC	3	0	Number of time units for renewal
30	VERPER	☐	VERPER	PERART	CHAR	1	0	Time unit for renewal
31	VABSCHLEVU	☐	E_VSCHLEVU	DATUM	DATS	8	0	Date on which utility concluded the contract
32	VABSCHLKND	☐	E_VSCHLKND	DATUM	DATS	8	0	Date on which customer concluded the contract
33	VABSCHLKNDTI	☐	E_VSCHLKNDTI	TIMS	TIMS	6	0	Time at which customer signed contract
34	PERSNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
35	VREFER	☐	E_VREFER	TEXT20	CHAR	20	0	Contract number from legacy system
36	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
37	.INCLUDE	☐				0	0	Creation and Change Data
38	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
39	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
40	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
41	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
42	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
43	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
44	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
45	MANOUTSORT	☐	MANOUTSORT	MANOUTSORT	CHAR	8	0	Reason for manual outsorting in billing	TE127
46	FAKTURIERT	☐	FAKTURIERT	KENNZX	CHAR	1	0	Contract has already been invoiced
47	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
48	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
49	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
50	COPAKONT	☐	E_COPAKONT	XFELD	CHAR	1	0	Indicator: Profitability segment assigned (CO-PA)
51	AUSGRUP	☐	AUSGRUP	AUSGRUP	CHAR	8	0	Outsorting check group for billing	TE191
52	OUTCOUNT	☐	OUTCOUNT	OUTNUMBER	NUMC	2	0	Number of manual outsortings to be carried out yet
53	PYPLT	☐	E_PYPLT	E_PYPLT	CHAR	4	0	Payment plan type	TE015
54	PYPLS	☐	E_PYPLS	MONTH	NUMC	2	0	Starting month of payment plan
55	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
56	SEGMENT	☐	SEGMT_KK	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
57	SERVICEID	☐	SERVICE_PROV	SERVICE_PROV	CHAR	10	0	Service Provider	ESERVPROV
58	SRVPRVREF	☐	SRVPRVREF	CHAR30	CHAR	30	0	Reference number of service provider
59	BILLMETHOD	☐	BILLMETHOD	BILLMETHOD	CHAR	2	0	Billing method
60	STAGRUVER	☐	E_STGRUV	E_STGRUV	CHAR	2	0	Statistics group for contract	TE770
61	PYPLA	☐	E_PYPLA	MONTH	NUMC	2	0	Alternative start month of payment plan
62	BILLFINIT	☐	BILLFINIT	KENNZX	CHAR	1	0	Contract terminated for billing reasons
63	BFA_DEB_STAT	☐	E_BFA_PROC_DEBIT	E_BFA_PROCESSING	CHAR	1	0	Payment plan - BF amount not released for receivable
64	BFA_CRED_STAT	☐	E_BFA_PROC_CREDIT	E_BFA_PROCESSING	CHAR	1	0	Payment plan - BF amount not released for credit
65	SALESEMPLOYEE	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
66	SALESPARTNER	☐	ESALESPARTNER	KUNNR	CHAR	10	0	Sales partners	KNA1
67	SALESDOCUMENT	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
68	PS_STARTDAT	☐	PS_STARTDAT	DATS	DATS	8	0	Start Date of Payment Scheme (PS)
69	SERVPROV_PAY	☐	SERVPROV_PAY	SERVPROV_PAY	CHAR	4	0	Payment Class	ESERVPROV_PAY
70	INVOICING_PARTY	☐	INVOICING_PARTY	SERVICE_PROV	CHAR	10	0	Service Provider That Invoices the Contract	*
71	COKEY	☐	COKEY_EE2	CHAR10	CHAR	10	0	CO account assignment key, IS-U contract	TECOK
72	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
73	CONTRACTCLASS	☐	CONTRACTCLASS	ECONTRACTCLASS	CHAR	4	0	Contract Class	TECONTRACTCLASS
74	CANCREASON	☐	VKGRU_VEDA	KUEGRU	CHAR	2	0	Reason for cancellation of contract	*
75	CANCREASON_NEW	☐	ECRMT_SRV_CANCEL_REASON	QCODE	CHAR	4	0	Cancellation Reason (CRM)	*
76	EXTRAPOLWASTE	☐	EXTRAPOLWASTE	EXTRAPOLWASTE	CHAR	2	0	Category of Waste Disposal Budget Billing Extrapolation
77	PPM_CONTRACT	☐	E_PP_PPM_CONTRACT	E_PP_PPM_CONTRACT	CHAR	1	0	Identifies Contract as Prepayment Meter Contract
78	OSB_GROUP	☐	E_OSB_GROUP		CHAR	3	0	On-Site Billing Group	TE555
79	OUCONT	☐	OUCONT	KENNZX	CHAR	1	0	Outline Contract
80	RULEGR	☐	RULEGR	RULEGR	CHAR	10	0	Rule Group for Outline Agreements	*
81	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
82	.INCLUDE	☐				0	0	IS-U Contract: Move-in/out Fields
83	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation	*
84	VKONTO	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
85	KZSONDEINZ	☐	KZSONDEINZ	KZSONDEINZ	CHAR	1	0	Move-In Processing (Special Case)
86	KZSONDAUSZ	☐	KZSONDAUSZ	KZSONDAUSZ	CHAR	1	0	Special move-out processing case exists
87	AUTEIGEINZ	☐	AUTEIGEINZ	KENZX	CHAR	1	0	Automatic Owner Move-In
88	EINZDAT	☐	EINZDAT	DATUM	DATS	8	0	Move-In Date
89	AUSZDAT	☐	AUSZDAT	DATUM	DATS	8	0	Move-Out Date
90	ABSSTOPDAT	☐	ABSSTOPDAT	DATUM	DATS	8	0	Stop date for budget bill. requests in the case of move-out
91	SCHLFAKT	☐	SCHLFAKT	E_GEMFAKT	CHAR	1	0	Joint final billing for move-in/out
92	MAHNV	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
93	MAHNVUMZ	☐	MAHNV_UMZ	MAHNV_KK	CHAR	2	0	Move-in/out dunning procedure	TFK047A
94	MANSP	☐	MANSP_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	TFK047S
95	BEZUG	☐	BEZUG	KENNZX	CHAR	1	0	Reference
96	TRANSVER	☐	E_TRANSVER	VERTRAG	CHAR	10	0	Transfer contract	EVER
97	SSWTCREASON	☐	SSWTCREASON	CHAR2	CHAR	2	0	Reasons for contract change	TE960
98	XVERA	☐	XVERA	KENNZX	CHAR	1	0	Contract created due to data transfer
99	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CONTRCL	ABRFREIG	TE023	ABRFREIG		1	CN
2	CONTRCL	ABRSPERR	TE021	ABRSPERR		1	CN
3	CONTRCL	AUFNR	AUFK	AUFNR		1	CN
4	CONTRCL	AUSGRUP	TE191	AUSGRUP	KEY	1	CN
5	CONTRCL	BSTATUS	TE643	BEARKZ
6	CONTRCL	BUKRS	T001	BUKRS
7	CONTRCL	BUPLA	J_1BBRANCH	BRANCH
8	CONTRCL	COKEY	TECOK	COKEY
9	CONTRCL	CONTRACTCLASS	TECONTRACTCLASS	CONTRACTCLASS
10	CONTRCL	GSBER	TGSB	GSBER
11	CONTRCL	KOFIZ	TE097	KOFIZ		1	CN
12	CONTRCL	KOSTL	CSKS	KOSTL
13	CONTRCL	MAHNV	TFK047A	MAHNV
14	CONTRCL	MAHNVUMZ	TFK047A	MAHNV
15	CONTRCL	MANDT	T000	MANDT
16	CONTRCL	MANOUTSORT	TE127	MANOUTSORT
17	CONTRCL	MANSP	TFK047S	MANSP
18	CONTRCL	OSB_GROUP	TE555	OSB_GROUP
19	CONTRCL	PORTION	TE420	TERMSCHL		1	CN
20	CONTRCL	PRCTR	CEPC	PRCTR		1	CN
21	CONTRCL	PS_PSP_PNR	PRPS	PSPNR		1	CN
22	CONTRCL	PYPLT	TE015	PYPLT	KEY	1	CN
23	CONTRCL	REGIOGROUP	ADRREGGRP	REGIOGROUP
24	CONTRCL	SALESDOCUMENT	VBUK	VBELN
25	CONTRCL	SALESPARTNER	KNA1	KUNNR
26	CONTRCL	SEGMENT	FAGL_SEGM	SEGMENT
27	CONTRCL	SERVICEID	ESERVPROV	SERVICEID
28	CONTRCL	SERVPROV_PAY	ESERVPROV_PAY	SERVPROV_PAY
29	CONTRCL	SPARTE	TESPT	SPARTE	REF	1	CN
30	CONTRCL	SSWTCREASON	TE960	SSWTCREASON
31	CONTRCL	STAGRUVER	TE770	STAGRUVER
32	CONTRCL	TRANSVER	EVER	VERTRAG
33	CONTRCL	VKONTO	FKKVK	VKONT		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in