SAP ABAP Table TXI_VICN01 (Real Estate Contract: Contra)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_VICN01	Table Relationship Diagram
Short Description	Real Estate Contract: Contra

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXI_VICN01	BUKRS	T001	BUKRS	KEY	1	CN
2	TXI_VICN01	RECNACCDETVAL	TIVCN08	KOEIGR	KEY	1	CN
3	TXI_VICN01	RECNBUKRSCOLLECT	T001	BUKRS
4	TXI_VICN01	RECNBUKRSGKT	T001	BUKRS
5	TXI_VICN01	RECNBUSAREA	TGSB	GSBER	KEY	1	CN
6	TXI_VICN01	RECNCURR	TCURC	WAERS	KEY	1	CN
7	TXI_VICN01	RECNCURR2	TCURC	WAERS	KEY	1	CN
8	TXI_VICN01	RECNESRCUIDOW	TIV9I	KUNID
9	TXI_VICN01	RECNESRNROW	TIV9I	TEILN
10	TXI_VICN01	RECNHBKID	T012	HBKID	KEY	1	CN
11	TXI_VICN01	RECNKUNNR	KNA1	KUNNR	KEY	1	CN
12	TXI_VICN01	RECNLIFNR	LFA1	LIFNR	KEY	1	CN
13	TXI_VICN01	RECNMABER	T047M	MABER	KEY	1	CN
14	TXI_VICN01	RECNMAHNA	T047A	MAHNA	KEY	1	CN
15	TXI_VICN01	RECNMANSP	T040S	MANSP	KEY	1	CN
16	TXI_VICN01	RECNNOTINVREA	TIV41	RABLGRU	KEY	1	CN
17	TXI_VICN01	RECNNOTREASON	TIV39	RKUEGRU	KEY	1	CN
18	TXI_VICN01	RECNPRCTR	CEPC	PRCTR	KEY	1	CN
19	TXI_VICN01	RECNTLAW	TIV03	SMIETR	KEY	1	CN
20	TXI_VICN01	RECNTYPE	TIV26	SMVART	KEY	1	CN
21	TXI_VICN01	RECNUNIT	T006	MSEHI	KEY	1	CN
22	TXI_VICN01	RECNVSTSOND	TIV63	SVSTSOND	KEY	1	CN
23	TXI_VICN01	RECNZLSPR	T008	ZAHLS	KEY	1	CN

History

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