VILIC - ICI Historical Data

ICI Historical Data information is stored in SAP table VILIC.
It is part of development package FVVIIT in software component RE. This development package consists of objects that can be grouped under "".

Fields for table VILIC

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	3	*
INTRENO	Internal Real Estate Master Data Code	X	VVINTRENO	CHAR	13
ANFIS	Fiscal Year	X	GJAHR	NUMC	4
DTVAL	Validity date	X	VVLICDTVAL	DATS	8
BUKRS	Company Code		BUKRS	CHAR	4	*
SWENR	Business Entity Number		SWENR	CHAR	8	*
SMENR	Number of Rental Unit		SMENR	CHAR	8	*
SGRNR	Land Number for BE		SGRNR	CHAR	8	*
WAERS	Currency Key		WAERS	CUKY	5	TCURC
DTFIN	End period date		VVLICDTFIN	DATS	8
ICVAL	ICI value		VVLICICVAL	CURR	7
ORT01	Ort		VVLICORT01	CHAR	35
ALCOM	County rate		VVLICALCOM	DEC	3
ESATT	Name of the ICI collector		VVLICESATT	CHAR	60
CCNRO	C/C number		VVLICCCNRO	CHAR	10
IDCAT	Category ID		VVLICIDCAT	CHAR	4	TIVLICTG
COFCA	Category coefficient		VVLICCOFCA	DEC	3
IDCLA	Class ID		VVLICIDCLA	CHAR	2	TIVLICLA
COFRE	Regional Coefficient		VVLICCOFRE	DEC	3
COFRI	Revaluation Coefficient		VVLICCOFRI	DEC	3
TPCAL	Calculation type		VVLICTPCAL	CHAR	2
CORUS	Use grouping code		VVLICCORUS	CHAR	2	TIVLICRU
RENBA	Basic Cadastral revenue		VVLICRENBA	CURR	7
RENCA	Cadastral revenue		VVLICRENCA	CURR	7
VAVEN	Selling value for building areas		VVLICVAVEN	CURR	7
REDOM	Domain revenue		VVLICREDOM	CURR	7
VAIMM	D-Building value		VVLICVAIMM	CURR	7
BASVL	Basic value		VVLICBASVL	CURR	7
BASIM	Taxable amount		VVLICBASIM	CURR	7
MEPOS	Months of ownership		VVLICMEPOS	NUMC	2
PEPOS	Percentage of ownership		VVLICPEPOS	DEC	3
MEESC	Months of exclusion		VVLICMEESC	NUMC	2
VEDET	Possible detraction value		VVLICVEDET	CURR	7
PEDET	Detraction percentage		VVLICPEDET	DEC	3
AUPER	Raising percentage		VVLICAUPER	DEC	3
DTPRI	First payment deadline		VVLICDTPRI	DATS	8
VLPRI	First instalment value		VVLICVLPRI	CURR	7
DEPRI	First instalment detractions		VVLICDEPRI	CURR	7
FLPRI	Flag 1st instalment payment		VVLICFLPRI	CHAR	1
ACCON	Down payment		VVLICACCON	CURR	7
DTSEC	Second payment deadline		VVLICDTSEC	DATS	8
VLSEC	Second instalments value		VVLICVLSEC	CURR	7
DESEC	Second instalment detractions		VVLICDESEC	CURR	7
SALDO	Balance		VVLICSALDO	CURR	7
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	8
USNAM	User Name		USNAM	CHAR	12	*
BLDAT	Document Date in Document		BLDAT	DATS	8