SAP ABAP Table RELM_NA_VAL (Assessed Values)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-LM (Application Component) Land Use Management
⤷ RE_LM_NA (Package) RE: Notice of Assessment
⤷ 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 | Table Relationship Diagram |
Short Description | Assessed Values |
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 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RELM_NA_VAL | CURRENCY | TCURC | WAERS | KEY | 1 | CN |
2 | RELM_NA_VAL | MEASUNIT | T006 | MSEHI | KEY | 1 | CN |
3 | RELM_NA_VAL | MEASUNIT1 | T006 | MSEHI | KEY | 1 | CN |
4 | RELM_NA_VAL | MEASUNIT2 | T006 | MSEHI | KEY | 1 | CN |
5 | RELM_NA_VAL | MEASUNIT3 | T006 | MSEHI | KEY | 1 | CN |
6 | RELM_NA_VAL | MEASUNIT4 | T006 | MSEHI | KEY | 1 | CN |
7 | RELM_NA_VAL | MEASUNIT5 | T006 | MSEHI | KEY | 1 | CN |
8 | RELM_NA_VAL | NAOWNREL | TIVLMNAOWNREL | NAOWNREL | KEY | 1 | CN |
9 | RELM_NA_VAL | NAPRTYPE | TIVLMNAPRTY | NAPRTYPE | KEY | 1 | CN |
10 | RELM_NA_VAL | NAPRTYPEAR | TIVLMNAPRTYAR | NAPRTYPEAR | KEY | 1 | CN |
11 | RELM_NA_VAL | NASTMNTTYPE | TIVLMNASTTY | NASTMNTTYPE | KEY | 1 | CN |
12 | RELM_NA_VAL | ZONEMEASUNIT1 | T006 | MSEHI | KEY | 1 | CN |
13 | RELM_NA_VAL | ZONEMEASUNIT2 | T006 | MSEHI | REF | 1 | CN |
14 | RELM_NA_VAL | ZONEMEASUNIT3 | T006 | MSEHI | KEY | 1 | CN |
History
Last changed by/on | SAP | 20070913 |
SAP Release Created in | 600 |