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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VILIR	CDTRI	TIVLIRTR	CDTRI	KEY	1	CN
2	VILIR	CDTRI2	TIVLIRTR	CDTRI	KEY	1	CN
3	VILIR	CDTRI3	TIVLIRTR	CDTRI	KEY	1	CN
4	VILIR	IDIRE	TIVLIRCO	IDIRE
5	VILIR	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20030714
SAP Release Created in