SAP ABAP Table VICNCN (Real Estate Contract)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-CN (Application Component) Real Estate Contract
     ⤷ RE_CN_CN (Package) RE: Contract

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VICNCN	Table Relationship Diagram
Short Description	Real Estate Contract

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
3	.INCLUDE	☐				0	0	RE Contract: Key Fields
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	RECNNR	☐	RECNNUMBER	RECNNUMBER	CHAR	13	0	Contract Number
6	.INCLUDE	☐				0	0	RE Contract: Non-Key Fields
7	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
8	IMKEY	☐	RECAIMKEY	IMKEY	CHAR	8	0	Internal Key of Real Estate Object (FI)
9	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
10	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
11	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
12	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
13	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
14	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
15	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
16	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
17	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
18	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
19	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
20	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
21	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
22	RECNTYPE	☐	RECNCONTRACTTYPE	SMVART	CHAR	4	0	Contract Type	TIV26
23	RECNBEG	☐	RECNCNBEG	RECADATE	DATS	8	0	Date of contract start
24	RECNENDABS	☐	RECNCNENDABS	RECADATEEND	DATS	8	0	Term End Date
25	RECNTXT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
26	RECNDACTIV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
27	RECNTLAW	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
28	RECNTXTOLD	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
29	RECNBUKRSCOLLECT	☐	RECNBUKRSCOLLECT	BUKRS	CHAR	4	0	Company code of main contract	T001
30	RECNNRCOLLECT	☐	RECNNUMBERCOLLECT	RECNNUMBER	CHAR	13	0	Number of Real Estate Main Contract
31	RECNCNCURR	☐	RECNWAERS_CN	WAERS	CUKY	5	0	Currency for Contract	TCURC
32	INDUSTRY	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	*
33	SRRELEVANT	☐	RECNSALESRENTRELEVANT	RECABOOL	CHAR	1	0	Relevant to Sales
34	DPTARGETTYPE	☐	RECNDPTYPE	RECNDPTYPE	CHAR	4	0	Security Deposit Type	TIVCNDPTYPE
35	RECNDAT	☐	RECNDAT	DDAT	DATS	8	0	Date of Contract Conclusion
36	RECN2DAT	☐	RECN2DAT	RECADATE	DATS	8	0	Date of Second Signature
37	RECNDPO	☐	RECDCFSTARTFROM	RECADATE	DATS	8	0	Cash Flow Generated Starting On
38	RECNEND1ST	☐	RECNCNEND1ST	RECADATE	DATS	8	0	Date of First Contract End
39	RECNNOTPER	☐	RECNNTPER	RECADATE	DATS	8	0	Contract Notice Per
40	RECNNOTRECEIPT	☐	RECNNTRECEIPT	RECADATE	DATS	8	0	Date of receipt of notice
41	RECNNOTREASON	☐	RECNNTREASON	RECNNTREASON	NUMC	2	0	Reason for Notice	TIVCNNTRE
42	RECNDAKTKU	☐	RECNNTACTIVATEDON	RECADATE	DATS	8	0	Notice: Date of Activation
43	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
44	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
45	CFPOSTINGFROM	☐	RECDCFPOSTINGFROM	RECADATE	DATS	8	0	First Posting From
46	BENOCN	☐	RECNBENOCN	REBDBENO	CHAR	8	0	Business Entity That Belongs to Contract	*
47	TRANSPOSSFROM	☐	RECNTRANSPOSSFROM	RECADATEBEG	DATS	8	0	Transfer of Possession: Start Date
48	TRANSPOSSTO	☐	RECNTRANSPOSSTO	RECADATEEND	DATS	8	0	Transfer of Possession: End Date
49	HASMULTIASSIGN	☐	REBDHASMULTIASSIGN	RECABOOL	CHAR	1	0	Multiple Assignment of Object to Group Allowed
50	POSSDATEFROM	☐	REBDPOSSDATEFROM	RECADATE	DATS	8	0	Date From Which the Object Is Made Available for Use
51	POSSDATETO	☐	REBDPOSSDATETO	RECADATE	DATS	8	0	Date Up to Which the Object Is Used
52	.INCLUDE	☐				0	0
53	.INCLU--AP	☐				0	0	Country Specific Fields for Spain
54	.INCLUDE	☐				0	0	Country-Specific Fields for Spain - Contract
55	SECDEPRELEVANT	☐	REXCESCDREL	XFELD	CHAR	1	0	Relevant to Security Deposit
56	NOTADJSDCN	☐	REXCESCDNOTADJ	RECABOOL	CHAR	1	0	No Data Update in Security Deposit Contract

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VICNCN	BUKRS	T001	BUKRS	KEY	1	CN
2	VICNCN	DPTARGETTYPE	TIVCNDPTYPE	DPTYPE	REF	C	CN
3	VICNCN	RECNBUKRSCOLLECT	T001	BUKRS	REF	C	CN
4	VICNCN	RECNCNCURR	TCURC	WAERS	REF	1	CN
5	VICNCN	RECNNOTREASON	TIVCNNTRE	NTREASON	REF	C	CN
6	VICNCN	RECNTLAW	TIV03	SMIETR	REF	C	CN
7	VICNCN	RECNTYPE	TIV26	SMVART	KEY	1	CN
8	VICNCN	RESPONSIBLE	USR02	BNAME	REF	1	CN
9	VICNCN	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	300