SAP ABAP Table VICN01 (Real Estate Contract: Contract Data)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ RE (Application Component) Real Estate Management
     ⤷ FVVICN (Package) R/3 Real Estate Application Development - General Contract

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VICN01	Table Relationship Diagram
Short Description	Real Estate Contract: Contract Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	1. Key Structure VICN01
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	INTRENO	☑	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
4	.INCLUDE	☐				0	0	Real Estate Contract: Contract Data
5	.INCLUDE	☐				0	0	2. Key Structure VICN01
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	RECNTYPE	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
8	RECNNR	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
9	RECNDAT	☐	RECNDAT	DDAT	DATS	8	0	Date of Contract Conclusion
10	RECNBEG	☐	RECNBEG	DDAT	DATS	8	0	Date of contract start
11	RECNEND	☐	RECNEND	DDAT	DATS	8	0	Date of contract end
12	RECNADJT	☐	SMVAR	SMVAR	CHAR	1	0	Lease-Out Adjustment Type	*
13	RECNTXT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
14	RECNDPO	☐	RECNDPO	DDAT	DATS	8	0	Date of first posting
15	RECNOBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
16	RECNNOTTYPE	☐	SMVKUEART	SMVKUEART	CHAR	1	0	Notice Type of Lease-Out
17	RECNNOTKEY	☐	SKUEKEY	SKUEKEY	CHAR	12	0	Notice rule
18	RECNNOTPER	☐	DKUZU	DDAT	DATS	8	0	Contract Notice Per
19	RECNAUTHGR	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
20	RECNBUSAREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
21	RECNPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
22	RECNACCDETVAL	☐	VVWERTN_ADCN	VVWERTN_ADCN	CHAR	10	0	Account determination key for account determination	TIVCN08
23	RECNADMONTH	☐	VVJMABGR	JFLAGG	CHAR	1	0	Accrual/deferral method
24	RECNDDUNNED	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
25	RECNDCOMPLNT	☐	VVKLDATUM	DATUM	DATS	8	0	Date of complaint
26	RECNDCOMPLRC	☐	VVKLAKTZEI	CHAR20	CHAR	20	0	Complaint reference code
27	RECNJURISDIC	☐	VVXGERSTD	TEXT35	CHAR	35	0	Jurisdiction
28	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
29	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
30	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
31	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
32	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
33	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
34	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
35	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
36	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
37	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
38	RECNUNIT	☐	RECNUNIT	MEINS	UNIT	3	0	Area unit	T006
39	RECNKUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
40	RECNLIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
41	RECNTXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
42	RECNCURR	☐	RECNWAERS_H	WAERS	CUKY	5	0	Currency key for local currency	TCURC
43	RECNTLAW	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
44	RECNCURR2	☐	RECNWAERS_D	WAERS	CUKY	5	0	Currency key for the display currency	TCURC
45	RECNTXTOLD	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
46	RECNDACTIV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
47	RECNNRCOLLECT	☐	RECNNRCOLLECT	RECNNR	CHAR	13	0	Number of Real Estate main contract
48	RECNKOSTL	☐	RECNKOSTL	KOSTL	CHAR	10	0	Cost center of internal contract	*
49	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
50	RECNPREDATA	☐	RECNPREDATA	XFELD	CHAR	1	0	Flag: Predefined rates
51	SPARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	*
52	RECNNOTRECEIPT	☐	DEKUEA	DDAT	DATS	8	0	Receipt or issue date of notice
53	RECNNOTREASON	☐	RKUEGRU	RKUEGRU	NUMC	2	0	Reason for notice	TIV39
54	RECNNOTINVREA	☐	RABLGRU	RABLGRU	NUMC	2	0	Reason for rejection	TIV41
55	RECNJVSTOPT	☐	VVJVSTOPT	JANE	CHAR	1	0	Input tax opting (indicator)
56	RECNVSTSOND	☐	SVSTSOND	SVSTSOND	CHAR	1	0	Input tax opting reason	TIV63
57	RECNMANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
58	RECNMABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
59	RECNMAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	T047A
60	RECNMAHNS_D	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
61	RECNNOTCAT	☐	SKUAR	SKUAR	CHAR	1	0	Notice Type
62	RECNGFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
63	RECNZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
64	RECNHBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
65	RECNXBLNR	☐	RECNXBLNR1	XBLNR1	CHAR	16	0	Note to payee
66	RECNDKUZUG	☐	VVDKUZUG	DDAT	DATS	8	0	Date notice approved
67	RECNDKUABG	☐	VVDKUABG	DDAT	DATS	8	0	Date notice rejected
68	RECNDWIKU	☐	VVDWIKU	DDAT	DATS	8	0	Date of objection to notice
69	RECNDKUERCK	☐	DKUERCK	DATUM	DATS	8	0	Date of withdrawal of notice
70	RECNDKREUEB	☐	VVDKREUEB	DDAT	DATS	8	0	Date notice submitted to legal department
71	RECNDAKTKU	☐	VVDAKTKU	DDAT	DATS	8	0	Activation date
72	RECNDSTKU	☐	VVDSTKU	DDAT	DATS	8	0	Reversal date
73	RECNADJTTYPE	☐	RECNADJTTYPE	RECNADJTTYPE	CHAR	1	0	Adjustment triggered by
74	RECNADJTRUECK	☐	RECNADJTRUECK	XFELD	CHAR	1	0	Retroactive adjustment possible
75	RECNBUKRSCOLLECT	☐	RECNBUKRSCOLLECT	BUKRS	CHAR	4	0	Company code of main contract	T001
76	RECNBASISAEZIF	☐	RECNBASISAEZIF	RECNAEZIF	INT2	5	0	Base: equivalence number distribution
77	RECNXCROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
78	RECNMANDAT	☐	RECNMANDAT	CHAR20	CHAR	20	0	Mandate
79	RECNMANDATTYP	☐	RECNMANDATTYP	RECNMANDATTYP	NUMC	1	0	Role of Contract in Mandate
80	RECNFLESR	☐	VVKZESR	JANE	CHAR	1	0	Activation of POR functions
81	RECNESRNROW	☐	VVESRNR_EIG	NUM9	NUMC	9	0	POR participant number of owner	TIV9I
82	RECNESRCUIDOW	☐	VVESRKUID_EIG	CHAR15	CHAR	15	0	POR customer identification number	TIV9I
83	RECNVATNROW	☐	VVMWSTNR_EIG	STCEG	CHAR	20	0	Value-added tax of owner
84	RECNBUKRSGKT	☐	VVBUKRS_GKT	BUKRS	CHAR	4	0	Object and account CoCd	T001
85	RECNKZEIGGKT	☐	VVKZEIGGKT	VVKZEIGGKT	CHAR	1	0	Cash account control for owner
86	.INCLU--AP	☐				0	0	LUM: Vertragserweiterungen
87	RELSKASSENZ	☐	RELSKASSENZ	CHAR30	CHAR	30	0	Kassenzeichen/Hebebuch-Nr.
88	RELSGRDNR	☐	RELSGRDNR	CHAR30	CHAR	30	0	Grundstücksnummer im Abgabenbescheid
89	RELSSUBTYPE	☐	RELSSUBTYPE	RELSSUBTYPE	CHAR	4	0	Untervertragsart (Liegenschaftsvertrag)	TIVLSCNSTYPE
90	RELSAKTZ	☐	RELSAKTZ	TEXT35	CHAR	35	0	Aktenzeichen
91	RELSDAT2	☐	RELSDAT2	DDAT	DATS	8	0	Datum Vertragsbestätigung
92	RELSWIRTUEBG	☐	RELSWIRTUEBG	DDAT	DATS	8	0	Wirtschaftlicher Übergang
93	RELSNOTEARLY	☐	RELSNOTEARLY	DATS	DATS	8	0	Frühestmögliche Kündigung
94	RELSOWNER	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	*
95	RELSROLETYP	☐	BP_ROLETYP	BP_ROLETYP	CHAR	4	0	Business Partner Role Category	*
96	.INCLU--AP	☐				0	0	OBSOLETE: RE Contract: Append Fields
97	.INCLUDE	☐				0	0	OBSOLETE: RE Contract: Append Fields
98	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
99	RECNCNCURR	☐	RECNWAERS_CN	WAERS	CUKY	5	0	Currency for Contract	TCURC
100	RECNENDABS	☐	RECNCNENDABS	RECADATEEND	DATS	8	0	Term End Date
101	RECN2DAT	☐	RECN2DAT	RECADATE	DATS	8	0	Date of Second Signature
102	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
103	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*
104	SRRELEVANT	☐	RECNSALESRENTRELEVANT	RECABOOL	CHAR	1	0	Relevant to Sales
105	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
106	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
107	INDUSTRY	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	*
108	DPTARGETTYPE	☐	RECNDPTYPE	RECNDPTYPE	CHAR	4	0	Security Deposit Type	TIVCNDPTYPE
109	.INCLUDE	☐				0	0
110	.INCLU--AP	☐				0	0	LUM: Ausschreibung
111	BIRELEASE	☐	RELUBIRELEASE	XFELD	CHAR	1	0	Ausschreibung freigegeben (Kennzeichen)
112	BIVALIDFROM	☐	RELUBIVALIDFROM	DDAT	DATS	8	0	Ausschreibung gültig von
113	BIVALIDTO	☐	RELUBIVALIDTO	DDAT	DATS	8	0	Ausschreibung gültig bis
114	BIREPRTO	☐	RELUBIREPRTO	DDAT	DATS	8	0	Ausschreibung befristet bis
115	BIREPRTOTIME	☐	RELUBIREPRTOTIME	UZEIT	TIMS	6	0	Uhrzeit, bis zu der die Ausschreibung befristet ist
116	BIRECAT	☐	RELUBIRECAT	CHAR02	CHAR	2	0	Liegenschaftskategorie	TIVLUBIRECAT
117	PUBLICTYPE	☐	RELUPUBLICTYPE	CHAR02	CHAR	2	0	Art der Veröffentlichung	TIVLUPUBLICTYPE
118	FILENO	☐	RELUFILENO	CHAR35	CHAR	35	0	Aktenzeichen
119	BIPURPOSE	☐	RELUBIPURPOSE	CHAR02	CHAR	2	0	Zweck der Ausschreibung	TIVLUBIPURPOSE
120	BIPRICING	☐	RELUBIPRICING	CHAR02	CHAR	2	0	Preisfindung	TIVLUBIPRICING

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VICN01	BIPRICING	TIVLUBIPRICING	BIPRICING
2	VICN01	BIPURPOSE	TIVLUBIPURPOSE	BIPURPOSE
3	VICN01	BIRECAT	TIVLUBIRECAT	BIRECAT
4	VICN01	BUKRS	T001	BUKRS	KEY	1	CN
5	VICN01	DPTARGETTYPE	TIVCNDPTYPE	DPTYPE	REF	C	CN
6	VICN01	PUBLICTYPE	TIVLUPUBLICTYPE	PUBLICTYPE
7	VICN01	RECNACCDETVAL	TIVCN08	KOEIGR	KEY	1	CN
8	VICN01	RECNBUKRSCOLLECT	T001	BUKRS
9	VICN01	RECNBUKRSGKT	T001	BUKRS
10	VICN01	RECNBUSAREA	TGSB	GSBER	KEY	1	CN
11	VICN01	RECNCNCURR	TCURC	WAERS	KEY	1	CN
12	VICN01	RECNCURR	TCURC	WAERS	KEY	1	CN
13	VICN01	RECNCURR2	TCURC	WAERS	KEY	1	CN
14	VICN01	RECNESRCUIDOW	TIV9I	KUNID
15	VICN01	RECNESRNROW	TIV9I	TEILN
16	VICN01	RECNHBKID	T012	HBKID	KEY	1	CN
17	VICN01	RECNKUNNR	KNA1	KUNNR	KEY	1	CN
18	VICN01	RECNLIFNR	LFA1	LIFNR	KEY	1	CN
19	VICN01	RECNMABER	T047M	MABER	KEY	1	CN
20	VICN01	RECNMAHNA	T047A	MAHNA	KEY	1	CN
21	VICN01	RECNMANSP	T040S	MANSP	KEY	1	CN
22	VICN01	RECNNOTINVREA	TIV41	RABLGRU	KEY	1	CN
23	VICN01	RECNNOTREASON	TIV39	RKUEGRU	KEY	1	CN
24	VICN01	RECNPRCTR	CEPC	PRCTR	KEY	1	CN
25	VICN01	RECNTLAW	TIV03	SMIETR	KEY	1	CN
26	VICN01	RECNTYPE	TIV26	SMVART	KEY	1	CN
27	VICN01	RECNUNIT	T006	MSEHI	KEY	1	CN
28	VICN01	RECNVSTSOND	TIV63	SVSTSOND	KEY	1	CN
29	VICN01	RECNZLSPR	T008	ZAHLS	KEY	1	CN
30	VICN01	RELSSUBTYPE	TIVLSCNSTYPE	RELSSUBTYPE

History

Last changed by/on	SAP	20130529
SAP Release Created in