SAP ABAP Table VICN01_FT (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	INTTAB	Structure
Structure	VICN01_FT	Table Relationship Diagram
Short Description	Real Estate Contract: Contract Data

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	2. Key Structure VICN01
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RECNTYPE	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
4	RECNNR	☐	RECNNR	RECNNR	CHAR	13	0	Real Estate Contract Number
5	RECNDAT	☐	RECNDAT	DDAT	DATS	8	0	Date of Contract Conclusion
6	RECNBEG	☐	RECNBEG	DDAT	DATS	8	0	Date of contract start
7	RECNEND	☐	RECNEND	DDAT	DATS	8	0	Date of contract end
8	RECNADJT	☐	SMVAR	SMVAR	CHAR	1	0	Lease-Out Adjustment Type	*
9	RECNTXT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
10	RECNDPO	☐	RECNDPO	DDAT	DATS	8	0	Date of first posting
11	RECNOBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
12	RECNNOTTYPE	☐	SMVKUEART	SMVKUEART	CHAR	1	0	Notice Type of Lease-Out
13	RECNNOTKEY	☐	SKUEKEY	SKUEKEY	CHAR	12	0	Notice rule
14	RECNNOTPER	☐	DKUZU	DDAT	DATS	8	0	Contract Notice Per
15	RECNAUTHGR	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
16	RECNBUSAREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
17	RECNPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
18	RECNACCDETVAL	☐	VVWERTN_ADCN	VVWERTN_ADCN	CHAR	10	0	Account determination key for account determination	*
19	RECNADMONTH	☐	VVJMABGR	JFLAGG	CHAR	1	0	Accrual/deferral method
20	RECNDDUNNED	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
21	RECNDCOMPLNT	☐	VVKLDATUM	DATUM	DATS	8	0	Date of complaint
22	RECNDCOMPLRC	☐	VVKLAKTZEI	CHAR20	CHAR	20	0	Complaint reference code
23	RECNJURISDIC	☐	VVXGERSTD	TEXT35	CHAR	35	0	Jurisdiction
24	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
25	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
26	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
27	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
28	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
29	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
30	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
31	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
32	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
33	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
34	RECNUNIT	☐	RECNUNIT	MEINS	UNIT	3	0	Area unit	*
35	RECNKUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
36	RECNLIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
37	RECNTXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
38	RECNCURR	☐	RECNWAERS_H	WAERS	CUKY	5	0	Currency key for local currency	TCURC
39	RECNTLAW	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	*
40	RECNCURR2	☐	RECNWAERS_D	WAERS	CUKY	5	0	Currency key for the display currency	TCURC
41	RECNTXTOLD	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
42	RECNDACTIV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
43	RECNNRCOLLECT	☐	RECNNRCOLLECT	RECNNR	CHAR	13	0	Number of Real Estate main contract
44	RECNKOSTL	☐	RECNKOSTL	KOSTL	CHAR	10	0	Cost center of internal contract	*
45	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
46	RECNPREDATA	☐	RECNPREDATA	XFELD	CHAR	1	0	Flag: Predefined rates
47	SPARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	*
48	RECNNOTRECEIPT	☐	DEKUEA	DDAT	DATS	8	0	Receipt or issue date of notice
49	RECNNOTREASON	☐	RKUEGRU	RKUEGRU	NUMC	2	0	Reason for notice	*
50	RECNNOTINVREA	☐	RABLGRU	RABLGRU	NUMC	2	0	Reason for rejection	*
51	RECNJVSTOPT	☐	VVJVSTOPT	JANE	CHAR	1	0	Input tax opting (indicator)
52	RECNVSTSOND	☐	SVSTSOND	SVSTSOND	CHAR	1	0	Input tax opting reason	*
53	RECNMANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
54	RECNMABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
55	RECNMAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	*
56	RECNMAHNS_D	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
57	RECNNOTCAT	☐	SKUAR	SKUAR	CHAR	1	0	Notice Type
58	RECNGFZLSCH	☐	RECNGFZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
59	RECNZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
60	RECNHBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
61	RECNXBLNR	☐	RECNXBLNR1	XBLNR1	CHAR	16	0	Note to payee
62	RECNDKUZUG	☐	VVDKUZUG	DDAT	DATS	8	0	Date notice approved
63	RECNDKUABG	☐	VVDKUABG	DDAT	DATS	8	0	Date notice rejected
64	RECNDWIKU	☐	VVDWIKU	DDAT	DATS	8	0	Date of objection to notice
65	RECNDKUERCK	☐	DKUERCK	DATUM	DATS	8	0	Date of withdrawal of notice
66	RECNDKREUEB	☐	VVDKREUEB	DDAT	DATS	8	0	Date notice submitted to legal department
67	RECNDAKTKU	☐	VVDAKTKU	DDAT	DATS	8	0	Activation date
68	RECNDSTKU	☐	VVDSTKU	DDAT	DATS	8	0	Reversal date
69	RECNADJTTYPE	☐	RECNADJTTYPE	RECNADJTTYPE	CHAR	1	0	Adjustment triggered by
70	RECNADJTRUECK	☐	RECNADJTRUECK	XFELD	CHAR	1	0	Retroactive adjustment possible
71	RECNBUKRSCOLLECT	☐	RECNBUKRSCOLLECT	BUKRS	CHAR	4	0	Company code of main contract	T001
72	RECNBASISAEZIF	☐	RECNBASISAEZIF	RECNAEZIF	INT2	5	0	Base: equivalence number distribution
73	RECNXCROSS	☐	RECNXCROSS	XFELD	CHAR	1	0	Gross amount indicator
74	RECNMANDAT	☐	RECNMANDAT	CHAR20	CHAR	20	0	Mandate
75	RECNMANDATTYP	☐	RECNMANDATTYP	RECNMANDATTYP	NUMC	1	0	Role of Contract in Mandate
76	RECNFLESR	☐	VVKZESR	JANE	CHAR	1	0	Activation of POR functions
77	RECNESRNROW	☐	VVESRNR_EIG	NUM9	NUMC	9	0	POR participant number of owner	TIV9I
78	RECNESRCUIDOW	☐	VVESRKUID_EIG	CHAR15	CHAR	15	0	POR customer identification number	TIV9I
79	RECNVATNROW	☐	VVMWSTNR_EIG	STCEG	CHAR	20	0	Value-added tax of owner
80	RECNBUKRSGKT	☐	VVBUKRS_GKT	BUKRS	CHAR	4	0	Object and account CoCd	T001
81	RECNKZEIGGKT	☐	VVKZEIGGKT	VVKZEIGGKT	CHAR	1	0	Cash account control for owner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VICN01_FT	BUKRS	T001	BUKRS
2	VICN01_FT	RECNBUKRSCOLLECT	T001	BUKRS
3	VICN01_FT	RECNBUKRSGKT	T001	BUKRS
4	VICN01_FT	RECNCURR	TCURC	WAERS	KEY	1	CN
5	VICN01_FT	RECNCURR2	TCURC	WAERS	KEY	1	CN
6	VICN01_FT	RECNESRCUIDOW	TIV9I	KUNID
7	VICN01_FT	RECNESRNROW	TIV9I	TEILN
8	VICN01_FT	RECNTYPE	TIV26	SMVART

History

Last changed by/on	SAP	20110901
SAP Release Created in