SAP ABAP Table VILIC (ICI Historical Data)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ RE (Application Component) Real Estate Management
     ⤷ FVVIIT (Package) RE: Real Estate Italy (to translate Italian/English only)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VILIC	Table Relationship Diagram
Short Description	ICI Historical Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	INTRENO	☑	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
3	ANFIS	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	DTVAL	☑	VVLICDTVAL	DATS	DATS	8	0	Validity date
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
7	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
8	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
9	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
10	DTFIN	☐	VVLICDTFIN	DATS	DATS	8	0	End period date
11	ICVAL	☐	VVLICICVAL	WRTV7	CURR	13	2	ICI value
12	ORT01	☐	VVLICORT01	VVLICORT01	CHAR	35	0	Ort
13	ZOCEN	☐	VVLICZOCEN	VVLIC2	CHAR	2	0	Census Area
14	ALCOM	☐	VVLICALCOM	DEC03_2	DEC	5	2	County rate
15	ESATT	☐	VVLICESATT	DDTEXT	CHAR	60	0	Name of the ICI collector
16	CCNRO	☐	VVLICCCNRO	CHAR010	CHAR	10	0	C/C number
17	IDCAT	☐	VVLICIDCAT	VVLIC4	CHAR	4	0	Category ID	TIVLICTG
18	COFCA	☐	VVLICCOFCA	DEC03_2	DEC	5	2	Category coefficient
19	IDCLA	☐	VVLICIDCLA	VVLIC2	CHAR	2	0	Class ID	TIVLICLA
20	COFRE	☐	VVLICCOFRE	DEC03_2	DEC	5	2	Regional Coefficient
21	COFRI	☐	VVLICCOFRI	DEC3_2	DEC	5	2	Revaluation Coefficient
22	TPCAL	☐	VVLICTPCAL	VVLICTPCAL	CHAR	2	0	Calculation type
23	CORUS	☐	VVLICCORUS	VVLIC2	CHAR	2	0	Use grouping code	TIVLICRU
24	RENBA	☐	VVLICRENBA	WRTV7	CURR	13	2	Basic Cadastral revenue
25	RENCA	☐	VVLICRENCA	WRTV7	CURR	13	2	Cadastral revenue
26	VAVEN	☐	VVLICVAVEN	WRTV7	CURR	13	2	Selling value for building areas
27	REDOM	☐	VVLICREDOM	WRTV7	CURR	13	2	Domain revenue
28	VAIMM	☐	VVLICVAIMM	WRTV7	CURR	13	2	D-Building value
29	BASVL	☐	VVLICBASVL	WRTV7	CURR	13	2	Basic value
30	BASIM	☐	VVLICBASIM	WRTV7	CURR	13	2	Taxable amount
31	MEPOS	☐	VVLICMEPOS	NUMC02	NUMC	2	0	Months of ownership
32	PEPOS	☐	VVLICPEPOS	DEC03_2	DEC	5	2	Percentage of ownership
33	MEESC	☐	VVLICMEESC	NUMC02	NUMC	2	0	Months of exclusion
34	VEDET	☐	VVLICVEDET	WRTV7	CURR	13	2	Possible detraction value
35	PEDET	☐	VVLICPEDET	DEC03_2	DEC	5	2	Detraction percentage
36	AUPER	☐	VVLICAUPER	DEC03_2	DEC	5	2	Raising percentage
37	DTPRI	☐	VVLICDTPRI	DATS	DATS	8	0	First payment deadline
38	VLPRI	☐	VVLICVLPRI	WRTV7	CURR	13	2	First instalment value
39	DEPRI	☐	VVLICDEPRI	WRTV7	CURR	13	2	First instalment detractions
40	FLPRI	☐	VVLICFLPRI	XFELD	CHAR	1	0	Flag 1st instalment payment
41	ACCON	☐	VVLICACCON	WRTV7	CURR	13	2	Down payment
42	DTSEC	☐	VVLICDTSEC	DATS	DATS	8	0	Second payment deadline
43	VLSEC	☐	VVLICVLSEC	WRTV7	CURR	13	2	Second instalments value
44	DESEC	☐	VVLICDESEC	WRTV7	CURR	13	2	Second instalment detractions
45	SALDO	☐	VVLICSALDO	WRTV7	CURR	13	2	Balance
46	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
47	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
48	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VILIC	CORUS	TIVLICRU	CORUS
2	VILIC	IDCAT	TIVLICTG	IDCAT
3	VILIC	IDCLA	TIVLICLA	IDCLA
4	VILIC	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in