SAP VICN01 Real Estate Contract: Contract Data Table

Overview

VICN01 is a standard SAP S/4HANA table that stores Real Estate Contract: Contract Data data. There are total 94 fields in the VICN01 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VICN01 belongs to Real Estate Management (RE) module and is located in the package R/3 Real Estate Application Development - General Contract (FVVICN).

In addition, following links provide an overview of foreign key relationships, if any, that link VICN01 to other SAP tables and standard CDS views available based on VICN01 table in S/4HANA 2020.

Techincal Settings of VICN01

Below are technical details of the table VICN01

Buffering not allowed
No buffering
Storage type is Column Store

List of VICN01 Fields

The following table gives you an overview of the fields available in VICN01

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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VICN01

Table Name	Field	Cardinality	Check Table
VICN01	BIPRICING	:	TIVLUBIPRICING
VICN01	BIPURPOSE	:	TIVLUBIPURPOSE
VICN01	BIRECAT	:	TIVLUBIRECAT
VICN01	BUKRS	1: CN	T001
VICN01	DPTARGETTYPE	C: CN	TIVCNDPTYPE
VICN01	PUBLICTYPE	:	TIVLUPUBLICTYPE
VICN01	RECNACCDETVAL	1: CN	TIVCN08
VICN01	RECNBUKRSCOLLECT	:	T001
VICN01	RECNBUKRSGKT	:	T001
VICN01	RECNBUSAREA	1: CN	TGSB
VICN01	RECNCNCURR	1: CN	TCURC
VICN01	RECNCURR	1: CN	TCURC
VICN01	RECNCURR2	1: CN	TCURC
VICN01	RECNESRCUIDOW	:	TIV9I
VICN01	RECNESRNROW	:	TIV9I
VICN01	RECNHBKID	1: CN	T012
VICN01	RECNKUNNR	1: CN	KNA1
VICN01	RECNLIFNR	1: CN	LFA1
VICN01	RECNMABER	1: CN	T047M
VICN01	RECNMAHNA	1: CN	T047A
VICN01	RECNMANSP	1: CN	T040S
VICN01	RECNNOTINVREA	1: CN	TIV41
VICN01	RECNNOTREASON	1: CN	TIV39
VICN01	RECNPRCTR	1: CN	CEPC
VICN01	RECNTLAW	1: CN	TIV03
VICN01	RECNTYPE	1: CN	TIV26
VICN01	RECNUNIT	1: CN	T006
VICN01	RECNVSTSOND	1: CN	TIV63
VICN01	RECNZLSPR	1: CN	T008
VICN01	RELSSUBTYPE	:	TIVLSCNSTYPE

SAP VICN01 Real Estate Contract: Contract Data Table

Overview

Techincal Settings of VICN01

List of VICN01 Fields

Foreign Key Relationships

Other References