SAP ABAP Table VILMNAVAL_TAB (Assessed Value: Non-Key Fields)

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	INTTAB	Structure
Structure	VILMNAVAL_TAB	Table Relationship Diagram
Short Description	Assessed Value: Non-Key Fields

Delivery and Maintenance

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

History

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