SAP ABAP Table V_RELMNAE (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_RELMNAE	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
3	NANO	☑	RELMNANO	RELMNANO	CHAR	40	0	Number of Notice of Assessment
4	OBJNR	☑	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number
5	CREATIONTYPE	☑	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
6	RESPONSIBLE	☑	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible
7	USEREXCLUSIVE	☑	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization
8	AUTHGRP	☑	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
9	XNA	☑	RELMXNA	RECAXLDESCRIPTION	CHAR	60	0	Notice of Assessment - Text
10	VALIDFROM	☑	RELMNAVVALIDFROM	RECADATEBEG	DATS	8	0	Assessed Value Valid From
11	VALIDTO	☐	RELMNAVALIDTO	RECADATEEND	DATS	8	0	Notice of Assessment: Valid-To Date
12	NANOOLD	☐	RELMNANOOLD	RELMNANO	CHAR	40	0	Old Notice of Assessment Number
13	FILENO	☐	RELMNAFILENO	RELMNAFILENO	CHAR	30	0	Notice of Assessment: Internal File Number
14	ISCOLL	☐	RELMNAISCOLL	RECABOOL	CHAR	1	0	Collective Notice
15	ASSESSDATE	☐	RELMNAVALUEDATE	RECADATE	DATS	8	0	Date of Notice of Assessment
16	ASSESSVALUE	☐	RELMNAVALUE	RECACURR	CURR	15	2	Assessed Value: Land
17	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
18	TAXVAL1	☐	RELMNATAXVAL1	RECACURR	CURR	15	2	Basic Property Tax Amount
19	TAXVAL2	☐	RELMNATAXVAL2	RECACURR	CURR	15	2	Assessed Value Based on Valuation Law (Germany)
20	MEASVALUE	☐	RELMNAMEASVALUE	REBDMEASVALUE	QUAN	17	4	Total Size of Area
21	MEASUNIT	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
22	NAPRTYPE	☐	RELMNAPRTYPE	RELMNAPRTYPE	CHAR	4	0	Land Type in Notice of Assessment	TIVLMNAPRTY
23	LOCATION1	☐	RELMNALOCATION1	RELMNALOCATION1	CHAR	60	0	Assessed Value: Location Name
24	LOCATION2	☐	RELMNALOCATION2	RELMNALOCATION1	CHAR	60	0	Assessed Value: Location Name 2
25	SEARCHTERM	☐	RELMNASEARCHTERM	RELMNASEARCHTERM	CHAR	35	0	Assessed Value: Custom Search Term
26	MCLOCATION1	☐	RELMNAMCLOCATION1	RELMNAMCLOCATION1	CHAR	60	0	Assessed Value: Location Name
27	MCLOCATION2	☐	RELMNAMCLOCATION2	RELMNAMCLOCATION1	CHAR	60	0	Assessed Value: Location Name
28	MCSEARCHTERM	☐	RELMNALOCSEARCHTERM	RELMNALOCSEARCHTERM	CHAR	35	0	Assessed Value: Custom Search Term
29	NASTMNTTYPE	☐	RELMNASTMNTTYPE	RELMNASTMNTTYPE	CHAR	4	0	Determination Type in Notice of Assessment	TIVLMNASTTY
30	NAOWNREL	☐	RELMNAOWNREL	RELMNAOWNREL	CHAR	4	0	Type of Possession in Notice of Assessment	TIVLMNAOWNREL
31	NAMETHOD	☐	RELMNAMETHOD	RELMNAMETHOD	CHAR	4	0	Type of Method in Notice of Assessment
32	NAPRTYPEAR	☐	RELMNAPRTYPEAR	RELMNAPRTYPEAR	CHAR	4	0	Land Type for Assessment Rate	TIVLMNAPRTYAR
33	ZONEMEAS1	☐	RELMNAZONEMEAS1	REBDMEASVALUE	QUAN	17	4	Area of Zone 1
34	ZONEMEASUNIT1	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
35	ZONEVALUE1	☐	RELMNAZONEVALUE1	RECACURR	CURR	15	2	Value per Measurement Unit Zone 1
36	ZONEMEAS2	☐	RELMNAZONEMEAS2	REBDMEASVALUE	QUAN	17	4	Area of Zone 2
37	ZONEMEASUNIT2	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
38	ZONEVALUE2	☐	RELMNAZONEVALUE2	RECACURR	CURR	15	2	Value per Measurement Unit Zone 2
39	ZONEMEAS3	☐	RELMNAZONEMEAS3	REBDMEASVALUE	QUAN	17	4	Area of Zone 3
40	ZONEMEASUNIT3	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
41	ZONEVALUE3	☐	RELMNAZONEVALUE3	RECACURR	CURR	15	2	Value per Measurement Unit Zone 3
42	PROPERTYVAL1	☐	RELMNAPROPERTYVAL1	RECACURR	CURR	15	2	Land Value
43	BUILDINGVAL1	☐	RELMNABUILDINGVAL1	RECACURR	CURR	15	2	Building Value
44	GROUNDVAL	☐	RELMNAGROUNDVAL	RECACURR	CURR	15	2	Value of Grounds Improvements
45	BASICVAL	☐	RELMNABASICVAL	RECACURR	CURR	15	2	Starting Value
46	CALCPERCENT	☐	RELMNACALCPERCENT	DEC3_2	DEC	5	2	Value Used in Calculating Cost Approach to Appraisal
47	PROPERTYVAL2	☐	RELMNAPROPERTYVAL2	RECACURR	CURR	15	2	Land Value Portion
48	BUILDINGVAL2	☐	RELMNABUILDINGVAL2	RECACURR	CURR	15	2	Building Value Portion
49	CALCVALUE	☐	RELMNACALCVALUE	RECACURR	CURR	15	2	Calculated Assessed Value
50	CALCDIFF	☐	RELMNACALCDIFF	RECACURR	CURR	15	2	Calculated Difference
51	DIFFERENCE	☐	RELMNADIFFERENCE	RECACURR	CURR	15	2	Specified Difference
52	MEAS1	☐	RELMNAMEAS1	REBDMEASVALUE	QUAN	17	4	Area Used for Agriculture
53	MEASUNIT1	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
54	MEAS2	☐	RELMNAMEAS2	REBDMEASVALUE	QUAN	17	4	Area Is Poorest Quality Land
55	MEASUNIT2	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
56	MEAS3	☐	RELMNAMEAS3	REBDMEASVALUE	QUAN	17	4	Area Is Unusable Land
57	MEASUNIT3	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
58	MEAS4	☐	RELMNAMEAS4	REBDMEASVALUE	QUAN	17	4	Area of Courtyard and Buildings
59	MEASUNIT4	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	T006
60	MEAS5	☐	RELMNAMEAS5	REBDMEASVALUE	QUAN	17	4	Area Used for Forestry
61	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	V_RELMNAE	CURRENCY	TCURC	WAERS	KEY	1	CN
2	V_RELMNAE	MEASUNIT	T006	MSEHI	KEY	1	CN
3	V_RELMNAE	MEASUNIT1	T006	MSEHI	KEY	1	CN
4	V_RELMNAE	MEASUNIT2	T006	MSEHI	KEY	1	CN
5	V_RELMNAE	MEASUNIT3	T006	MSEHI	KEY	1	CN
6	V_RELMNAE	MEASUNIT4	T006	MSEHI	KEY	1	CN
7	V_RELMNAE	MEASUNIT5	T006	MSEHI	KEY	1	CN
8	V_RELMNAE	NAOWNREL	TIVLMNAOWNREL	NAOWNREL	KEY	1	CN
9	V_RELMNAE	NAPRTYPE	TIVLMNAPRTY	NAPRTYPE	KEY	1	CN
10	V_RELMNAE	NAPRTYPEAR	TIVLMNAPRTYAR	NAPRTYPEAR	KEY	1	CN
11	V_RELMNAE	NASTMNTTYPE	TIVLMNASTTY	NASTMNTTYPE	KEY	1	CN
12	V_RELMNAE	ZONEMEASUNIT1	T006	MSEHI	KEY	1	CN
13	V_RELMNAE	ZONEMEASUNIT2	T006	MSEHI	REF	1	CN
14	V_RELMNAE	ZONEMEASUNIT3	T006	MSEHI	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in