SAP ABAP Table VILICL (ICI structure List reporting)

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	INTTAB	Structure
Structure	VILICL	Table Relationship Diagram
Short Description	ICI structure List reporting

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

History

Last changed by/on	SAP	20110901
SAP Release Created in