SAP VILMNAVAL Notice of Assessment: Annual Values Table
Overview
VILMNAVAL is a standard SAP S/4HANA table that stores Notice of Assessment: Annual Values data. There are total 51 fields in the VILMNAVAL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VILMNAVAL belongs to Land Use Management (RE-FX-LM) module and is located in the package RE: Notice of Assessment (RE_LM_NA).
In addition, following links provide an overview of foreign key relationships, if any, that link VILMNAVAL to other SAP tables and standard CDS views available based on VILMNAVAL table in S/4HANA 2020.
Techincal Settings of VILMNAVAL
Below are technical details of the table VILMNAVAL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VILMNAVAL Fields
The following table gives you an overview of the fields available in VILMNAVAL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| VALIDFROM | Assessed Value Valid From | RELMNAVVALIDFROM | DATS | 8 | |
| VALIDTO | Assessed Value Valid To | RELMNAVVALIDTO | DATS | 8 | |
| ASSESSDATE | Date of Notice of Assessment | RELMNAVALUEDATE | DATS | 8 | |
| ASSESSVALUE | Assessed Value: Land | RELMNAVALUE | CURR | 15 | |
| CURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 |
| TAXVAL1 | Basic Property Tax Amount | RELMNATAXVAL1 | CURR | 15 | |
| TAXVAL2 | Assessed Value Based on Valuation Law (Germany) | RELMNATAXVAL2 | CURR | 15 | |
| MEASVALUE | Total Size of Area | RELMNAMEASVALUE | QUAN | 17 | |
| MEASUNIT | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
| NAPRTYPE | Land Type in Notice of Assessment | RELMNAPRTYPE | TIVLMNAPRTY | CHAR | 4 |
| LOCATION1 | Assessed Value: Location Name | RELMNALOCATION1 | CHAR | 60 | |
| LOCATION2 | Assessed Value: Location Name 2 | RELMNALOCATION2 | CHAR | 60 | |
| SEARCHTERM | Assessed Value: Custom Search Term | RELMNASEARCHTERM | CHAR | 35 | |
| MCLOCATION1 | Assessed Value: Location Name | RELMNAMCLOCATION1 | CHAR | 60 | |
| MCLOCATION2 | Assessed Value: Location Name | RELMNAMCLOCATION2 | CHAR | 60 | |
| MCSEARCHTERM | Assessed Value: Custom Search Term | RELMNALOCSEARCHTERM | CHAR | 35 | |
| NASTMNTTYPE | Determination Type in Notice of Assessment | RELMNASTMNTTYPE | TIVLMNASTTY | CHAR | 4 |
| NAOWNREL | Type of Possession in Notice of Assessment | RELMNAOWNREL | TIVLMNAOWNREL | CHAR | 4 |
| NAMETHOD | Type of Method in Notice of Assessment | RELMNAMETHOD | CHAR | 4 | |
| NAPRTYPEAR | Land Type for Assessment Rate | RELMNAPRTYPEAR | TIVLMNAPRTYAR | CHAR | 4 |
| ZONEMEAS1 | Area of Zone 1 | RELMNAZONEMEAS1 | QUAN | 17 | |
| ZONEMEASUNIT1 | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
| ZONEVALUE1 | Value per Measurement Unit Zone 1 | RELMNAZONEVALUE1 | CURR | 15 | |
| ZONEMEAS2 | Area of Zone 2 | RELMNAZONEMEAS2 | QUAN | 17 | |
| ZONEMEASUNIT2 | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
| ZONEVALUE2 | Value per Measurement Unit Zone 2 | RELMNAZONEVALUE2 | CURR | 15 | |
| ZONEMEAS3 | Area of Zone 3 | RELMNAZONEMEAS3 | QUAN | 17 | |
| ZONEMEASUNIT3 | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
| ZONEVALUE3 | Value per Measurement Unit Zone 3 | RELMNAZONEVALUE3 | CURR | 15 | |
| PROPERTYVAL1 | Land Value | RELMNAPROPERTYVAL1 | CURR | 15 | |
| BUILDINGVAL1 | Building Value | RELMNABUILDINGVAL1 | CURR | 15 | |
| GROUNDVAL | Value of Grounds Improvements | RELMNAGROUNDVAL | CURR | 15 | |
| BASICVAL | Starting Value | RELMNABASICVAL | CURR | 15 | |
| CALCPERCENT | Value Used in Calculating Cost Approach to Appraisal | RELMNACALCPERCENT | DEC | 5 | |
| PROPERTYVAL2 | Land Value Portion | RELMNAPROPERTYVAL2 | CURR | 15 | |
| BUILDINGVAL2 | Building Value Portion | RELMNABUILDINGVAL2 | CURR | 15 | |
| CALCVALUE | Calculated Assessed Value | RELMNACALCVALUE | CURR | 15 | |
| CALCDIFF | Calculated Difference | RELMNACALCDIFF | CURR | 15 | |
| DIFFERENCE | Specified Difference | RELMNADIFFERENCE | CURR | 15 | |
| MEAS1 | Area Used for Agriculture | RELMNAMEAS1 | QUAN | 17 | |
| MEASUNIT1 | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
| MEAS2 | Area Is Poorest Quality Land | RELMNAMEAS2 | QUAN | 17 | |
| MEASUNIT2 | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
| MEAS3 | Area Is Unusable Land | RELMNAMEAS3 | QUAN | 17 | |
| MEASUNIT3 | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
| MEAS4 | Area of Courtyard and Buildings | RELMNAMEAS4 | QUAN | 17 | |
| MEASUNIT4 | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
| MEAS5 | Area Used for Forestry | RELMNAMEAS5 | QUAN | 17 | |
| MEASUNIT5 | Measurement Unit | REBDMEASUNIT | T006 | UNIT | 3 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VILMNAVAL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VILMNAVAL | CURRENCY | 1: CN | TCURC |
| VILMNAVAL | MEASUNIT | 1: CN | T006 |
| VILMNAVAL | MEASUNIT1 | 1: CN | T006 |
| VILMNAVAL | MEASUNIT2 | 1: CN | T006 |
| VILMNAVAL | MEASUNIT3 | 1: CN | T006 |
| VILMNAVAL | MEASUNIT4 | 1: CN | T006 |
| VILMNAVAL | MEASUNIT5 | 1: CN | T006 |
| VILMNAVAL | NAOWNREL | 1: CN | TIVLMNAOWNREL |
| VILMNAVAL | NAPRTYPE | 1: CN | TIVLMNAPRTY |
| VILMNAVAL | NAPRTYPEAR | 1: CN | TIVLMNAPRTYAR |
| VILMNAVAL | NASTMNTTYPE | 1: CN | TIVLMNASTTY |
| VILMNAVAL | ZONEMEASUNIT1 | 1: CN | T006 |
| VILMNAVAL | ZONEMEASUNIT2 | 1: CN | T006 |
| VILMNAVAL | ZONEMEASUNIT3 | 1: CN | T006 |