VICN01 - Real Estate Contract: Contract Data

Real Estate Contract: Contract Data information is stored in SAP table VICN01.
It is part of development package FVVICN in software component RE. This development package consists of objects that can be grouped under "R/3 Real Estate Application Development - General Contract".

Fields for table VICN01

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		VICN01_HD1	0
MANDT	Client	X	MANDT	CLNT	6	*
INTRENO	Internal Real Estate Master Data Code	X	VVINTRENO	CHAR	26
.INCLUDE				VICN01_FT	0
.INCLUDE				VICN01_HD2	0
BUKRS	Company Code		BUKRS	CHAR	8	T001
RECNTYPE	External Real Estate Contract Type		SMVART	CHAR	8	TIV26
RECNNR	Real Estate Contract Number		RECNNR	CHAR	26
RECNDAT	Date of Contract Conclusion		RECNDAT	DATS	16
RECNBEG	Date of contract start		RECNBEG	DATS	16
RECNEND	Date of contract end		RECNEND	DATS	16
RECNADJT	Lease-Out Adjustment Type		SMVAR	CHAR	2	*
RECNTXT	Contract Name		RECNTXT	CHAR	160
RECNDPO	Date of first posting		RECNDPO	DATS	16
RECNOBJNR	Object number		J_OBJNR	CHAR	44	*
RECNNOTTYPE	Notice Type of Lease-Out		SMVKUEART	CHAR	2
RECNNOTKEY	Notice rule		SKUEKEY	CHAR	24
RECNNOTPER	Contract Notice Per		DKUZU	DATS	16
RECNAUTHGR	Authorization group		VVBERGRP	CHAR	80
RECNBUSAREA	Business Area		GSBER	CHAR	8	TGSB
RECNPRCTR	Profit Center		PRCTR	CHAR	20	CEPC
RECNACCDETVAL	Account determination key for account determination		VVWERTN_ADCN	CHAR	20	TIVCN08
RECNADMONTH	Accrual/deferral method		VVJMABGR	CHAR	2
RECNDDUNNED	Date of Last Dunning Notice		MADAT	DATS	16
RECNDCOMPLNT	Date of complaint		VVKLDATUM	DATS	16
RECNDCOMPLRC	Complaint reference code		VVKLAKTZEI	CHAR	40
RECNJURISDIC	Jurisdiction		VVXGERSTD	CHAR	70
IMKEY	Internal Key for Real Estate Object		IMKEY	CHAR	16
.INCLUDE				RUSER	0
RERF	Entered By		RERF	CHAR	24
DERF	First Entered On		DERF	DATS	16
TERF	Time of Creation		TERF	TIMS	12
REHER	Source of Initial Entry		REHER	CHAR	20
RBEAR	Employee ID		RBEAR	CHAR	24
DBEAR	Last Edited On		DBEAR	DATS	16
TBEAR	Last Edited At		TBEAR	TIMS	12
RBHER	Editing Source		RBHER	CHAR	20
RECNUNIT	Area unit		RECNUNIT	UNIT	6	T006
RECNKUNNR	Customer Number		KUNNR	CHAR	20	KNA1
RECNLIFNR	Account Number of Supplier		LIFNR	CHAR	20	LFA1
RECNTXJCD	Tax Jurisdiction		TXJCD	CHAR	30	*
RECNCURR	Currency key for local currency		RECNWAERS_H	CUKY	10	TCURC
RECNTLAW	Tenancy law		SMIETR	CHAR	10	TIV03
RECNCURR2	Currency key for the display currency		RECNWAERS_D	CUKY	10	TCURC
RECNTXTOLD	Number of old contract		VVOSMIVE	CHAR	40
RECNDACTIV	Contract activation		DAKTV	DATS	16
RECNNRCOLLECT	Number of Real Estate Main Contract		RECNNRCOLLECT	CHAR	26
RECNKOSTL	Cost center of internal contract		RECNKOSTL	CHAR	20	*
RECNPREDATA	Flag: Predefined rates		RECNPREDATA	CHAR	2
SPARTNR	Business Partner Number		BP_PARTNR	CHAR	20	*
RECNNOTRECEIPT	Receipt or issue date of notice		DEKUEA	DATS	16
RECNNOTREASON	Reason for notice		RKUEGRU	NUMC	4	TIV39
RECNNOTINVREA	Reason for rejection		RABLGRU	NUMC	4	TIV41
RECNJVSTOPT	Input tax opting (indicator)		VVJVSTOPT	CHAR	2
RECNVSTSOND	Input tax opting reason		SVSTSOND	CHAR	2	TIV63
RECNMANSP	Dunning Block		MANSP	CHAR	2	T040S
RECNMABER	Dunning Area		MABER	CHAR	4	T047M
RECNMAHNA	Dunning Procedure		MAHNA	CHAR	8	T047A
RECNMAHNS_D	Dunning Level		MAHNS_D	NUMC	2
RECNNOTCAT	Notice Type		SKUAR	CHAR	2
RECNGFZLSCH	Payment method for credit memos		RECNGFZLSCH	CHAR	2	*
RECNZLSPR	Payment Block Key		DZLSPR	CHAR	2	T008
RECNHBKID	Short Key for a House Bank		HBKID	CHAR	10	T012
RECNXBLNR	Note to payee		RECNXBLNR1	CHAR	32
RECNDKUZUG	Date notice approved		VVDKUZUG	DATS	16
RECNDKUABG	Date notice rejected		VVDKUABG	DATS	16
RECNDWIKU	Date of objection to notice		VVDWIKU	DATS	16
RECNDKUERCK	Date of withdrawal of notice		DKUERCK	DATS	16
RECNDKREUEB	Date notice submitted to legal department		VVDKREUEB	DATS	16
RECNDAKTKU	Activation date		VVDAKTKU	DATS	16
RECNDSTKU	Reversal date		VVDSTKU	DATS	16
RECNADJTTYPE	Adjustment triggered by		RECNADJTTYPE	CHAR	2
RECNADJTRUECK	Retroactive adjustment possible		RECNADJTRUECK	CHAR	2
RECNBUKRSCOLLECT	Company Code of Main Contract		RECNBUKRSCOLLECT	CHAR	8	T001
RECNBASISAEZIF	Base: equivalence number distribution		RECNBASISAEZIF	INT2	2
RECNXCROSS	Gross amount indicator		RECNXCROSS	CHAR	2
RECNMANDAT	Mandate		RECNMANDAT	CHAR	40
RECNMANDATTYP	Role of Contract in Mandate		RECNMANDATTYP	NUMC	2
RECNFLESR	Activation of POR functions		VVKZESR	CHAR	2
RECNESRNROW	POR participant number of owner		VVESRNR_EIG	NUMC	18	TIV9I
RECNESRCUIDOW	POR customer identification number		VVESRKUID_EIG	CHAR	30	TIV9I
RECNVATNROW	Value-added tax of owner		VVMWSTNR_EIG	CHAR	40
RECNBUKRSGKT	Object and account CoCd		VVBUKRS_GKT	CHAR	8	T001
RECNKZEIGGKT	Cash account control for owner		VVKZEIGGKT	CHAR	2
.INCLU--AP				RELSVICN01	0
RELSKASSENZ			RELSKASSENZ	CHAR	60
RELSGRDNR			RELSGRDNR	CHAR	60
RELSSUBTYPE			RELSSUBTYPE	CHAR	8	TIVLSCNSTYPE
RELSAKTZ			RELSAKTZ	CHAR	70
RELSDAT2			RELSDAT2	DATS	16
RELSWIRTUEBG			RELSWIRTUEBG	DATS	16
RELSNOTEARLY			RELSNOTEARLY	DATS	16
RELSOWNER	Business Partner Number		BP_PARTNR	CHAR	20	*
RELSROLETYP	Business Partner Role Category		BP_ROLETYP	CHAR	8	*
.INCLU--AP				VICN01_APP	0
.INCLUDE				RECN_CONTRACT_APP	0
CREATIONTYPE	How the Object Was Created		RECACREATIONTYPE	CHAR	2
RECNCNCURR	Currency for Contract		RECNWAERS_CN	CUKY	10	TCURC
RECNENDABS	Term End Date		RECNCNENDABS	DATS	16
RECN2DAT	Date of Second Signature		RECN2DAT	DATS	16
RESPONSIBLE	Person Responsible		RECARESPONSIBLE	CHAR	24
USEREXCLUSIVE	User with Exclusive Change Authorization		RECAUSEREXCLUSIVE	CHAR	24
SRRELEVANT	Indicator: Relevant to Sales		RECNSALESRENTRELEVANT	CHAR	2
CFARCHIVEDTO	Date Up to Which the Cash Flow Is Archived		RECDCFARCHIVEDTO	DATS	16
CFLOCKEDTO	Date Until Which the Cash Flow Is Locked		RECDCFLOCKEDTO	DATS	16
INDUSTRY	Industry		BU_IND_SECTOR	CHAR	20	*
DPTARGETTYPE	Security Deposit Type		RECNDPTYPE	CHAR	8	TIVCNDPTYPE
.INCLUDE	CI_VICN01			CI_VICN01	0
.INCLU--AP				VICN01_APPRELUBI	0
BIRELEASE			RELUBIRELEASE	CHAR	2
BIVALIDFROM			RELUBIVALIDFROM	DATS	16
BIVALIDTO			RELUBIVALIDTO	DATS	16
BIREPRTO			RELUBIREPRTO	DATS	16
BIREPRTOTIME			RELUBIREPRTOTIME	TIMS	12
BIRECAT			RELUBIRECAT	CHAR	4	TIVLUBIRECAT
PUBLICTYPE			RELUPUBLICTYPE	CHAR	4	TIVLUPUBLICTYPE
FILENO			RELUFILENO	CHAR	70
BIPURPOSE			RELUBIPURPOSE	CHAR	4	TIVLUBIPURPOSE
BIPRICING			RELUBIPRICING	CHAR	4	TIVLUBIPRICING