VILIR SAP (IRE Historical data) Table details

Dictionary Type: Table
Description: IRE Historical data




ABAP Code to SELECT data from VILIR
Related tables to VILIR
Access table VILIR




Table field list including key, data, relationships and ABAP select examples

VILIR is a standard SAP Table which is used to store IRE Historical data data and is available within R/3 SAP systems depending on the version and release level.

The VILIR table consists of various fields, each holding specific information or linking keys about IRE Historical data data available in SAP. These include INTRENO (Internal Real Estate Master Data Code), ANFIS (Year for which levy is to be carried out), DTFAT (Billing date), BUKRS (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VILIR table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
ANFISYear for which levy is to be carried out JAHRNUMC4GJAHRGJAHR
DTFATBilling date VVLIRDTFATDATS8DDAT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SMIVELease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
SWENRSite Number SWENRCHAR8Assigned to domainSWENRSWENRWEHMCWE
SMENRNumber of Rental Unit SMENRCHAR8Assigned to domainSMENRSMENRMEHMCME
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
IDIRECalculation type VVLIRIDIRECHAR2TIVLIRCOVVLIC2
VLUFFRegister office IRE value VVLIRVLUFFCURR13(2) WRTV7
VLCANRental VVLIRVLCANCURR13(2) WRTV7
VLCAUBail value VVLIRVLCAUCURR13(2) WRTV7
VLGARGuarantor monthly val. VVLIRVLGARCURR13(2) WRTV7
VLARRFurniture value VVLIRVLARRCURR13(2) WRTV7
BAIMPTaxable amount VVLIRBAIMPCURR13(2) WRTV7
BACANRental taxable amount VVLIRBACANCURR13(2) WRTV7
BAGARGuarantor taxable amount VVLIRBAGARCURR13(2) WRTV7
BAARRFurniture taxable amount VVLIRBAARRCURR13(2) WRTV7
PEIREIRE Percentage VVLIRPEIREDEC5(2) DEC03_2
PEICAIRE% for bail VVLIRPEICADEC5(2) DEC03_2
PEIGAIRE% for guarantor VVLIRPEIGADEC5(2) DEC03_2
PEIARIRE% for Furniture VVLIRPEIARDEC5(2) DEC03_2
ABBATReduction percentage VVLIRABBATDEC5(2) DEC03_2
IRVALIRE value VVLIRIRVALCURR13(2) WRTV7
FLRECFlag Payback VVLIRFLRECCHAR1XFELD
RECIMIRE payback VVLIRRECIMCURR13(2) WRTV7
RECPEPayback percentage VVLIRRECPEDEC5(2) DEC03_2
DESPOAccounting position description VVLIRDESPOCHAR50CHAR50LOW
FLCONFlag accounted VVLIRFLCONCHAR1XFELD
BUDATPosting Date in the Document BUDATDATS8DATUM
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
CDTRItax code VVLIRCDTRICHAR4TIVLIRTRVVLIRCDTRIH_CDTRI
TPANNType of year VVLIRTPANNOCHAR1VVLIRTPANN0
DTINP VVLIRDTINPDATS8DDAT
DTFIP VVLIRDTFIPDATS8DDAT
NMSPE VVLIRNMSPENUMC3NUMC3
CDTRI2tax code VVLIRCDTRICHAR4TIVLIRTRVVLIRCDTRIH_CDTRI
CDTRI3tax code VVLIRCDTRICHAR4TIVLIRTRVVLIRCDTRIH_CDTRI
TPANNXType of year handled as intermediate year VVLIRTPANNXCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table VILIR using ABAP code

The following ABAP code Example will allow you to do a basic selection on VILIR to SELECT all data from the table
DATA: WA_VILIR TYPE VILIR.

SELECT SINGLE *
FROM VILIR
INTO CORRESPONDING FIELDS OF WA_VILIR
WHERE...

How to access SAP table VILIR

Within an ECC or HANA version of SAP you can also view further information about VILIR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!