SAP ABAP Table AVILMNAVAL (Aenderungsbelegstruktur; generiert durch RSSCD000)

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	AVILMNAVAL	Table Relationship Diagram
Short Description	Aenderungsbelegstruktur; generiert durch RSSCD000

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

Foreign Keys

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

History

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