SAP ABAP Table AVILIR (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	AVILIR	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	IRE 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	☐	JAHR	GJAHR	NUMC	4	0	Year for which levy is to be carried out
5	DTFAT	☐	VVLIRDTFAT	DDAT	DATS	8	0	Billing date
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
7	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
8	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
9	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
10	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
11	IDIRE	☐	VVLIRIDIRE	VVLIC2	CHAR	2	0	Calculation type	TIVLIRCO
12	VLUFF	☐	VVLIRVLUFF	WRTV7	CURR	13	2	Register office IRE value
13	VLCAN	☐	VVLIRVLCAN	WRTV7	CURR	13	2	Rental
14	VLCAU	☐	VVLIRVLCAU	WRTV7	CURR	13	2	Bail value
15	VLGAR	☐	VVLIRVLGAR	WRTV7	CURR	13	2	Guarantor monthly val.
16	VLARR	☐	VVLIRVLARR	WRTV7	CURR	13	2	Furniture value
17	BAIMP	☐	VVLIRBAIMP	WRTV7	CURR	13	2	Taxable amount
18	BACAN	☐	VVLIRBACAN	WRTV7	CURR	13	2	Rental taxable amount
19	BAGAR	☐	VVLIRBAGAR	WRTV7	CURR	13	2	Guarantor taxable amount
20	BAARR	☐	VVLIRBAARR	WRTV7	CURR	13	2	Furniture taxable amount
21	PEIRE	☐	VVLIRPEIRE	DEC03_2	DEC	5	2	IRE Percentage
22	PEICA	☐	VVLIRPEICA	DEC03_2	DEC	5	2	IRE% for bail
23	PEIGA	☐	VVLIRPEIGA	DEC03_2	DEC	5	2	IRE% for guarantor
24	PEIAR	☐	VVLIRPEIAR	DEC03_2	DEC	5	2	IRE% for Furniture
25	ABBAT	☐	VVLIRABBAT	DEC03_2	DEC	5	2	Reduction percentage
26	IRVAL	☐	VVLIRIRVAL	WRTV7	CURR	13	2	IRE value
27	FLREC	☐	VVLIRFLREC	XFELD	CHAR	1	0	Flag Payback
28	RECIM	☐	VVLIRRECIM	WRTV7	CURR	13	2	IRE payback
29	RECPE	☐	VVLIRRECPE	DEC03_2	DEC	5	2	Payback percentage
30	DESPO	☐	VVLIRDESPO	CHAR50LOW	CHAR	50	0	Accounting position description
31	FLCON	☐	VVLIRFLCON	XFELD	CHAR	1	0	Flag accounted
32	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
33	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
34	CDTRI	☐	VVLIRCDTRI	VVLIRCDTRI	CHAR	4	0	tax code	TIVLIRTR
35	TPANN	☐	VVLIRTPANNO	VVLIRTPANN0	CHAR	1	0	Type of year
36	DTINP	☐	VVLIRDTINP	DDAT	DATS	8	0
37	DTFIP	☐	VVLIRDTFIP	DDAT	DATS	8	0
38	NMSPE	☐	VVLIRNMSPE	NUMC3	NUMC	3	0
39	CDTRI2	☐	VVLIRCDTRI	VVLIRCDTRI	CHAR	4	0	tax code	TIVLIRTR
40	CDTRI3	☐	VVLIRCDTRI	VVLIRCDTRI	CHAR	4	0	tax code	TIVLIRTR
41	TPANNX	☐	VVLIRTPANNX	XFELD	CHAR	1	0	Type of year handled as intermediate year
42	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	AVILIR	CDTRI	TIVLIRTR	CDTRI
2	AVILIR	CDTRI2	TIVLIRTR	CDTRI	KEY	1	CN
3	AVILIR	CDTRI3	TIVLIRTR	CDTRI	KEY	1	CN
4	AVILIR	IDIRE	TIVLIRCO	IDIRE
5	AVILIR	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20030714
SAP Release Created in