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

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-LM (Application Component) Land Use Management
     ⤷ RE_LM_NA (Package) RE: Notice of Assessment

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VILMNAVAL	Table Relationship Diagram
Short Description	Notice of Assessment: Annual Values

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☑				0	0	Assessed Value: Key Fields
3	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
4	VALIDFROM	☑	RELMNAVVALIDFROM	RECADATEBEG	DATS	8	0	Assessed Value Valid From
5	.INCLUDE	☐				0	0	Assessed Value: Non-Key Fields
6	VALIDTO	☐	RELMNAVVALIDTO	RECADATEEND	DATS	8	0	Assessed Value Valid To
7	ASSESSDATE	☐	RELMNAVALUEDATE	RECADATE	DATS	8	0	Date of Notice of Assessment
8	ASSESSVALUE	☐	RELMNAVALUE	RECACURR	CURR	15	2	Assessed Value: Land
9	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
10	TAXVAL1	☐	RELMNATAXVAL1	RECACURR	CURR	15	2	Basic Property Tax Amount
11	TAXVAL2	☐	RELMNATAXVAL2	RECACURR	CURR	15	2	Assessed Value Based on Valuation Law (Germany)
12	MEASVALUE	☐	RELMNAMEASVALUE	REBDMEASVALUE	QUAN	17	4	Total Size of Area
13	MEASUNIT	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
14	NAPRTYPE	☐	RELMNAPRTYPE	RELMNAPRTYPE	CHAR	4	0	Land Type in Notice of Assessment	TIVLMNAPRTY
15	LOCATION1	☐	RELMNALOCATION1	RELMNALOCATION1	CHAR	60	0	Assessed Value: Location Name
16	LOCATION2	☐	RELMNALOCATION2	RELMNALOCATION1	CHAR	60	0	Assessed Value: Location Name 2
17	SEARCHTERM	☐	RELMNASEARCHTERM	RELMNASEARCHTERM	CHAR	35	0	Assessed Value: Custom Search Term
18	MCLOCATION1	☐	RELMNAMCLOCATION1	RELMNAMCLOCATION1	CHAR	60	0	Assessed Value: Location Name
19	MCLOCATION2	☐	RELMNAMCLOCATION2	RELMNAMCLOCATION1	CHAR	60	0	Assessed Value: Location Name
20	MCSEARCHTERM	☐	RELMNALOCSEARCHTERM	RELMNALOCSEARCHTERM	CHAR	35	0	Assessed Value: Custom Search Term
21	NASTMNTTYPE	☐	RELMNASTMNTTYPE	RELMNASTMNTTYPE	CHAR	4	0	Determination Type in Notice of Assessment	TIVLMNASTTY
22	NAOWNREL	☐	RELMNAOWNREL	RELMNAOWNREL	CHAR	4	0	Type of Possession in Notice of Assessment	TIVLMNAOWNREL
23	NAMETHOD	☐	RELMNAMETHOD	RELMNAMETHOD	CHAR	4	0	Type of Method in Notice of Assessment
24	NAPRTYPEAR	☐	RELMNAPRTYPEAR	RELMNAPRTYPEAR	CHAR	4	0	Land Type for Assessment Rate	TIVLMNAPRTYAR
25	ZONEMEAS1	☐	RELMNAZONEMEAS1	REBDMEASVALUE	QUAN	17	4	Area of Zone 1
26	ZONEMEASUNIT1	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
27	ZONEVALUE1	☐	RELMNAZONEVALUE1	RECACURR	CURR	15	2	Value per Measurement Unit Zone 1
28	ZONEMEAS2	☐	RELMNAZONEMEAS2	REBDMEASVALUE	QUAN	17	4	Area of Zone 2
29	ZONEMEASUNIT2	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
30	ZONEVALUE2	☐	RELMNAZONEVALUE2	RECACURR	CURR	15	2	Value per Measurement Unit Zone 2
31	ZONEMEAS3	☐	RELMNAZONEMEAS3	REBDMEASVALUE	QUAN	17	4	Area of Zone 3
32	ZONEMEASUNIT3	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
33	ZONEVALUE3	☐	RELMNAZONEVALUE3	RECACURR	CURR	15	2	Value per Measurement Unit Zone 3
34	PROPERTYVAL1	☐	RELMNAPROPERTYVAL1	RECACURR	CURR	15	2	Land Value
35	BUILDINGVAL1	☐	RELMNABUILDINGVAL1	RECACURR	CURR	15	2	Building Value
36	GROUNDVAL	☐	RELMNAGROUNDVAL	RECACURR	CURR	15	2	Value of Grounds Improvements
37	BASICVAL	☐	RELMNABASICVAL	RECACURR	CURR	15	2	Starting Value
38	CALCPERCENT	☐	RELMNACALCPERCENT	DEC3_2	DEC	5	2	Value Used in Calculating Cost Approach to Appraisal
39	PROPERTYVAL2	☐	RELMNAPROPERTYVAL2	RECACURR	CURR	15	2	Land Value Portion
40	BUILDINGVAL2	☐	RELMNABUILDINGVAL2	RECACURR	CURR	15	2	Building Value Portion
41	CALCVALUE	☐	RELMNACALCVALUE	RECACURR	CURR	15	2	Calculated Assessed Value
42	CALCDIFF	☐	RELMNACALCDIFF	RECACURR	CURR	15	2	Calculated Difference
43	DIFFERENCE	☐	RELMNADIFFERENCE	RECACURR	CURR	15	2	Specified Difference
44	MEAS1	☐	RELMNAMEAS1	REBDMEASVALUE	QUAN	17	4	Area Used for Agriculture
45	MEASUNIT1	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
46	MEAS2	☐	RELMNAMEAS2	REBDMEASVALUE	QUAN	17	4	Area Is Poorest Quality Land
47	MEASUNIT2	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
48	MEAS3	☐	RELMNAMEAS3	REBDMEASVALUE	QUAN	17	4	Area Is Unusable Land
49	MEASUNIT3	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
50	MEAS4	☐	RELMNAMEAS4	REBDMEASVALUE	QUAN	17	4	Area of Courtyard and Buildings
51	MEASUNIT4	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
52	MEAS5	☐	RELMNAMEAS5	REBDMEASVALUE	QUAN	17	4	Area Used for Forestry
53	MEASUNIT5	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VILMNAVAL	CURRENCY	TCURC	WAERS	KEY	1	CN
2	VILMNAVAL	MEASUNIT	T006	MSEHI	KEY	1	CN
3	VILMNAVAL	MEASUNIT1	T006	MSEHI	KEY	1	CN
4	VILMNAVAL	MEASUNIT2	T006	MSEHI	KEY	1	CN
5	VILMNAVAL	MEASUNIT3	T006	MSEHI	KEY	1	CN
6	VILMNAVAL	MEASUNIT4	T006	MSEHI	KEY	1	CN
7	VILMNAVAL	MEASUNIT5	T006	MSEHI	KEY	1	CN
8	VILMNAVAL	NAOWNREL	TIVLMNAOWNREL	NAOWNREL	KEY	1	CN
9	VILMNAVAL	NAPRTYPE	TIVLMNAPRTY	NAPRTYPE	KEY	1	CN
10	VILMNAVAL	NAPRTYPEAR	TIVLMNAPRTYAR	NAPRTYPEAR	KEY	1	CN
11	VILMNAVAL	NASTMNTTYPE	TIVLMNASTTY	NASTMNTTYPE	KEY	1	CN
12	VILMNAVAL	ZONEMEASUNIT1	T006	MSEHI	KEY	1	CN
13	VILMNAVAL	ZONEMEASUNIT2	T006	MSEHI	REF	1	CN
14	VILMNAVAL	ZONEMEASUNIT3	T006	MSEHI	KEY	1	CN

History

Last changed by/on	SAP	20070913
SAP Release Created in	600