SAP ABAP Table RELM_NA_VAL_L (Assessed Values - List 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	RELM_NA_VAL_L	Table Relationship Diagram
Short Description	Assessed Values - List 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	.INCLUDE	☐				0	0	Assessed Values
2	.INCLUDE	☐				0	0	Assessed Values
3	.INCLUDE	☐				0	0	Notice of Assessment: Annual Values
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	.INCLUDE	☐				0	0	Assessed Value: Key Fields
6	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
7	VALIDFROM	☐	RELMNAVVALIDFROM	RECADATEBEG	DATS	8	0	Assessed Value Valid From
8	.INCLUDE	☐				0	0	Assessed Value: Non-Key Fields
9	VALIDTO	☐	RELMNAVVALIDTO	RECADATEEND	DATS	8	0	Assessed Value Valid To
10	ASSESSDATE	☐	RELMNAVALUEDATE	RECADATE	DATS	8	0	Date of Notice of Assessment
11	ASSESSVALUE	☐	RELMNAVALUE	RECACURR	CURR	15	2	Assessed Value: Land
12	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	TAXVAL1	☐	RELMNATAXVAL1	RECACURR	CURR	15	2	Basic Property Tax Amount
14	TAXVAL2	☐	RELMNATAXVAL2	RECACURR	CURR	15	2	Assessed Value Based on Valuation Law (Germany)
15	MEASVALUE	☐	RELMNAMEASVALUE	REBDMEASVALUE	QUAN	17	4	Total Size of Area
16	MEASUNIT	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
17	NAPRTYPE	☐	RELMNAPRTYPE	RELMNAPRTYPE	CHAR	4	0	Land Type in Notice of Assessment	TIVLMNAPRTY
18	LOCATION1	☐	RELMNALOCATION1	RELMNALOCATION1	CHAR	60	0	Assessed Value: Location Name
19	LOCATION2	☐	RELMNALOCATION2	RELMNALOCATION1	CHAR	60	0	Assessed Value: Location Name 2
20	SEARCHTERM	☐	RELMNASEARCHTERM	RELMNASEARCHTERM	CHAR	35	0	Assessed Value: Custom Search Term
21	MCLOCATION1	☐	RELMNAMCLOCATION1	RELMNAMCLOCATION1	CHAR	60	0	Assessed Value: Location Name
22	MCLOCATION2	☐	RELMNAMCLOCATION2	RELMNAMCLOCATION1	CHAR	60	0	Assessed Value: Location Name
23	MCSEARCHTERM	☐	RELMNALOCSEARCHTERM	RELMNALOCSEARCHTERM	CHAR	35	0	Assessed Value: Custom Search Term
24	NASTMNTTYPE	☐	RELMNASTMNTTYPE	RELMNASTMNTTYPE	CHAR	4	0	Determination Type in Notice of Assessment	TIVLMNASTTY
25	NAOWNREL	☐	RELMNAOWNREL	RELMNAOWNREL	CHAR	4	0	Type of Possession in Notice of Assessment	TIVLMNAOWNREL
26	NAMETHOD	☐	RELMNAMETHOD	RELMNAMETHOD	CHAR	4	0	Type of Method in Notice of Assessment
27	NAPRTYPEAR	☐	RELMNAPRTYPEAR	RELMNAPRTYPEAR	CHAR	4	0	Land Type for Assessment Rate	TIVLMNAPRTYAR
28	ZONEMEAS1	☐	RELMNAZONEMEAS1	REBDMEASVALUE	QUAN	17	4	Area of Zone 1
29	ZONEMEASUNIT1	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
30	ZONEVALUE1	☐	RELMNAZONEVALUE1	RECACURR	CURR	15	2	Value per Measurement Unit Zone 1
31	ZONEMEAS2	☐	RELMNAZONEMEAS2	REBDMEASVALUE	QUAN	17	4	Area of Zone 2
32	ZONEMEASUNIT2	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
33	ZONEVALUE2	☐	RELMNAZONEVALUE2	RECACURR	CURR	15	2	Value per Measurement Unit Zone 2
34	ZONEMEAS3	☐	RELMNAZONEMEAS3	REBDMEASVALUE	QUAN	17	4	Area of Zone 3
35	ZONEMEASUNIT3	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
36	ZONEVALUE3	☐	RELMNAZONEVALUE3	RECACURR	CURR	15	2	Value per Measurement Unit Zone 3
37	PROPERTYVAL1	☐	RELMNAPROPERTYVAL1	RECACURR	CURR	15	2	Land Value
38	BUILDINGVAL1	☐	RELMNABUILDINGVAL1	RECACURR	CURR	15	2	Building Value
39	GROUNDVAL	☐	RELMNAGROUNDVAL	RECACURR	CURR	15	2	Value of Grounds Improvements
40	BASICVAL	☐	RELMNABASICVAL	RECACURR	CURR	15	2	Starting Value
41	CALCPERCENT	☐	RELMNACALCPERCENT	DEC3_2	DEC	5	2	Value Used in Calculating Cost Approach to Appraisal
42	PROPERTYVAL2	☐	RELMNAPROPERTYVAL2	RECACURR	CURR	15	2	Land Value Portion
43	BUILDINGVAL2	☐	RELMNABUILDINGVAL2	RECACURR	CURR	15	2	Building Value Portion
44	CALCVALUE	☐	RELMNACALCVALUE	RECACURR	CURR	15	2	Calculated Assessed Value
45	CALCDIFF	☐	RELMNACALCDIFF	RECACURR	CURR	15	2	Calculated Difference
46	DIFFERENCE	☐	RELMNADIFFERENCE	RECACURR	CURR	15	2	Specified Difference
47	MEAS1	☐	RELMNAMEAS1	REBDMEASVALUE	QUAN	17	4	Area Used for Agriculture
48	MEASUNIT1	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
49	MEAS2	☐	RELMNAMEAS2	REBDMEASVALUE	QUAN	17	4	Area Is Poorest Quality Land
50	MEASUNIT2	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
51	MEAS3	☐	RELMNAMEAS3	REBDMEASVALUE	QUAN	17	4	Area Is Unusable Land
52	MEASUNIT3	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
53	MEAS4	☐	RELMNAMEAS4	REBDMEASVALUE	QUAN	17	4	Area of Courtyard and Buildings
54	MEASUNIT4	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
55	MEAS5	☐	RELMNAMEAS5	REBDMEASVALUE	QUAN	17	4	Area Used for Forestry
56	MEASUNIT5	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
57	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
58	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
59	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
60	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
61	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
62	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
63	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
64	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
65	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
66	XNASTMNTTYPE	☐	RELMXNASTMNTTYPE	RECAXLDESCRIPTION	CHAR	60	0	Name of Determination Type in Notice of Assessment
67	XNAOWNREL	☐	RELMXNAOWNREL	RECAXLDESCRIPTION	CHAR	60	0	Name of Type of Possession in Notice of Assessment
68	XNAPRTYPEAR	☐	RELMXNAPRTYPEAR	RECAXLDESCRIPTION	CHAR	60	0	Name of Land Type for Assessment Rate
69	XNAMETHOD	☐	RELMXNAMETHOD	RECAXLDESCRIPTION	CHAR	60	0	Type of Method in Notice of Assessment
70	PLMEAS	☐	RELMNAPLMEAS	REBDMEASVALUE	QUAN	17	4	Area of Parcels
71	DIFFMEAS	☐	RELMNADIFFMEAS	RELMNADIFFMEAS	QUAN	17	4	Difference in Area: Parcels versus Notice of Assessment
72	ICON_DETAIL	☐	RECAICON	RECAICON	CHAR	137	0	Icon with Quick Info
73	.INCLUDE	☐				0	0	Assessed Value: Non-Key Fields (in Alternative Currency)
74	CURRENCY_ALT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
75	ASSESSVALUE_ALT	☐	RELMNAVALUE_ALT	RECACURR	CURR	15	2	Assessed Value: Land (in Alternative Currency)
76	TAXVAL1_ALT	☐	RELMNATAXVAL1_ALT	RECACURR	CURR	15	2	Basic Property Tax Amount (in Alternative Currency)
77	TAXVAL2_ALT	☐	RELMNATAXVAL2_ALT	RECACURR	CURR	15	2	Assessed Value Acc. to Valuation Law in Alternative Currency

Foreign Keys

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

History

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