VILMNAVAL SAP (Notice of Assessment: Annual Values) Table details

Dictionary Type: Table
Description: Notice of Assessment: Annual Values




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




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

VILMNAVAL is a standard SAP Table which is used to store Notice of Assessment: Annual Values data and is available within R/3 SAP systems depending on the version and release level.

The VILMNAVAL table consists of various fields, each holding specific information or linking keys about Notice of Assessment: Annual Values data available in SAP. These include INTRENO (Internal Key of Real Estate Object), VALIDFROM (Assessed Value Valid From), VALIDTO (Assessed Value Valid To), ASSESSDATE (Date of Notice of Assessment).. 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 VILMNAVAL 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 Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
VALIDFROMAssessed Value Valid From RELMNAVVALIDFROMDATS8RECADATEBEG
VALIDTOAssessed Value Valid To RELMNAVVALIDTODATS8REDATRECADATEEND
ASSESSDATEDate of Notice of Assessment RELMNAVALUEDATEDATS8RECADATE
ASSESSVALUEAssessed Value: Land RELMNAVALUECURR15(2) RECACURR
CURRENCYCurrency Key WAERSCUKY5TCURCWAERSFWS
TAXVAL1Basic Property Tax Amount RELMNATAXVAL1CURR15(2) RECACURR
TAXVAL2Assessed Value Based on Valuation Law (Germany) RELMNATAXVAL2CURR15(2) RECACURR
MEASVALUETotal Size of Area RELMNAMEASVALUEQUAN17(4) REBDMEASVALUE
MEASUNITMeasurement Unit REBDMEASUNITUNIT3T006CUNITMEINS
NAPRTYPELand Type in Notice of Assessment RELMNAPRTYPECHAR4TIVLMNAPRTYRELMNAPRTYPE
LOCATION1Assessed Value: Location Name RELMNALOCATION1CHAR60RELMNALOCATION1
LOCATION2Assessed Value: Location Name 2 RELMNALOCATION2CHAR60RELMNALOCATION1
SEARCHTERMAssessed Value: Custom Search Term RELMNASEARCHTERMCHAR35RELMNASEARCHTERM
MCLOCATION1Assessed Value: Location Name RELMNAMCLOCATION1CHAR60RELMNAMCLOCATION1
MCLOCATION2Assessed Value: Location Name RELMNAMCLOCATION2CHAR60RELMNAMCLOCATION1
MCSEARCHTERMAssessed Value: Custom Search Term RELMNALOCSEARCHTERMCHAR35RELMNALOCSEARCHTERM
NASTMNTTYPEDetermination Type in Notice of Assessment RELMNASTMNTTYPECHAR4TIVLMNASTTYRELMNASTMNTTYPE
NAOWNRELType of Possession in Notice of Assessment RELMNAOWNRELCHAR4TIVLMNAOWNRELRELMNAOWNREL
NAMETHODType of Method in Notice of Assessment RELMNAMETHODCHAR4RELMNAMETHOD
NAPRTYPEARLand Type for Assessment Rate RELMNAPRTYPEARCHAR4TIVLMNAPRTYARRELMNAPRTYPEAR
ZONEMEAS1Area of Zone 1 RELMNAZONEMEAS1QUAN17(4) REBDMEASVALUE
ZONEMEASUNIT1Measurement Unit REBDMEASUNITUNIT3T006CUNITMEINS
ZONEVALUE1Value per Measurement Unit Zone 1 RELMNAZONEVALUE1CURR15(2) RECACURR
ZONEMEAS2Area of Zone 2 RELMNAZONEMEAS2QUAN17(4) REBDMEASVALUE
ZONEMEASUNIT2Measurement Unit REBDMEASUNITUNIT3T006CUNITMEINS
ZONEVALUE2Value per Measurement Unit Zone 2 RELMNAZONEVALUE2CURR15(2) RECACURR
ZONEMEAS3Area of Zone 3 RELMNAZONEMEAS3QUAN17(4) REBDMEASVALUE
ZONEMEASUNIT3Measurement Unit REBDMEASUNITUNIT3T006CUNITMEINS
ZONEVALUE3Value per Measurement Unit Zone 3 RELMNAZONEVALUE3CURR15(2) RECACURR
PROPERTYVAL1Land Value RELMNAPROPERTYVAL1CURR15(2) RECACURR
BUILDINGVAL1Building Value RELMNABUILDINGVAL1CURR15(2) RECACURR
GROUNDVALValue of Grounds Improvements RELMNAGROUNDVALCURR15(2) RECACURR
BASICVALStarting Value RELMNABASICVALCURR15(2) RECACURR
CALCPERCENTValue Used in Calculating Cost Approach to Appraisal RELMNACALCPERCENTDEC5(2) DEC3_2
PROPERTYVAL2Land Value Portion RELMNAPROPERTYVAL2CURR15(2) RECACURR
BUILDINGVAL2Building Value Portion RELMNABUILDINGVAL2CURR15(2) RECACURR
CALCVALUECalculated Assessed Value RELMNACALCVALUECURR15(2) RECACURR
CALCDIFFCalculated Difference RELMNACALCDIFFCURR15(2) RECACURR
DIFFERENCESpecified Difference RELMNADIFFERENCECURR15(2) RECACURR
MEAS1Area Used for Agriculture RELMNAMEAS1QUAN17(4) REBDMEASVALUE
MEASUNIT1Measurement Unit REBDMEASUNITUNIT3T006CUNITMEINS
MEAS2Area Is Poorest Quality Land RELMNAMEAS2QUAN17(4) REBDMEASVALUE
MEASUNIT2Measurement Unit REBDMEASUNITUNIT3T006CUNITMEINS
MEAS3Area Is Unusable Land RELMNAMEAS3QUAN17(4) REBDMEASVALUE
MEASUNIT3Measurement Unit REBDMEASUNITUNIT3T006CUNITMEINS
MEAS4Area of Courtyard and Buildings RELMNAMEAS4QUAN17(4) REBDMEASVALUE
MEASUNIT4Measurement Unit REBDMEASUNITUNIT3T006CUNITMEINS
MEAS5Area Used for Forestry RELMNAMEAS5QUAN17(4) REBDMEASVALUE
MEASUNIT5Measurement Unit REBDMEASUNITUNIT3T006CUNITMEINS

Key field Non-key field



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

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

SELECT SINGLE *
FROM VILMNAVAL
INTO CORRESPONDING FIELDS OF WA_VILMNAVAL
WHERE...

How to access SAP table VILMNAVAL

Within an ECC or HANA version of SAP you can also view further information about VILMNAVAL 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!