SAP ABAP Table AVILIC (Structure for saving)

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	AVILIC	Table Relationship Diagram
Short Description	Structure for saving

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in