SAP ABAP Table RELM_NA_VAL_S (Notice of Assessment - 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_S | Table Relationship Diagram |
Short Description | Notice of Assessment - 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 | 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 | SELINDEX | SYTABIX | SYST_LONG | INT4 | 10 | 0 | Row Index of Internal Tables | ||
71 | PLMEAS | RELMNAPLMEAS | REBDMEASVALUE | QUAN | 17 | 4 | Area of Parcels | ||
72 | DIFFMEAS | RELMNADIFFMEAS | RELMNADIFFMEAS | QUAN | 17 | 4 | Difference in Area: Parcels versus Notice of Assessment | ||
73 | CURRENCY1 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
74 | CURRENCY2 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
75 | CURRENCY3 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
76 | CURRENCY4 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
77 | CURRENCY5 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
78 | CURRENCY6 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
79 | CURRENCY7 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
80 | CURRENCY8 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
81 | CURRENCY9 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
82 | CURRENCY10 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
83 | UNIT2 | REBDMEASUNIT | MEINS | UNIT | 3 | 0 | Measurement Unit | * | |
84 | UNIT3 | REBDMEASUNIT | MEINS | UNIT | 3 | 0 | Measurement Unit | * | |
85 | XVALIDFROM | TEXT | FL_TEXT | CHAR | 29 | 0 | Text field | ||
86 | .INCLUDE | 0 | 0 | Assessed Value: Non-Key Fields (in Alternative Currency) | |||||
87 | CURRENCY_ALT | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
88 | ASSESSVALUE_ALT | RELMNAVALUE_ALT | RECACURR | CURR | 15 | 2 | Assessed Value: Land (in Alternative Currency) | ||
89 | TAXVAL1_ALT | RELMNATAXVAL1_ALT | RECACURR | CURR | 15 | 2 | Basic Property Tax Amount (in Alternative Currency) | ||
90 | 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_S | CURRENCY | TCURC | WAERS | KEY | 1 | CN |
2 | RELM_NA_VAL_S | CURRENCY_ALT | TCURC | WAERS | KEY | 1 | CN |
3 | RELM_NA_VAL_S | MEASUNIT | T006 | MSEHI | KEY | 1 | CN |
4 | RELM_NA_VAL_S | MEASUNIT1 | T006 | MSEHI | KEY | 1 | CN |
5 | RELM_NA_VAL_S | MEASUNIT2 | T006 | MSEHI | KEY | 1 | CN |
6 | RELM_NA_VAL_S | MEASUNIT3 | T006 | MSEHI | KEY | 1 | CN |
7 | RELM_NA_VAL_S | MEASUNIT4 | T006 | MSEHI | KEY | 1 | CN |
8 | RELM_NA_VAL_S | MEASUNIT5 | T006 | MSEHI | KEY | 1 | CN |
9 | RELM_NA_VAL_S | NAOWNREL | TIVLMNAOWNREL | NAOWNREL | KEY | 1 | CN |
10 | RELM_NA_VAL_S | NAPRTYPE | TIVLMNAPRTY | NAPRTYPE | KEY | 1 | CN |
11 | RELM_NA_VAL_S | NAPRTYPEAR | TIVLMNAPRTYAR | NAPRTYPEAR | KEY | 1 | CN |
12 | RELM_NA_VAL_S | NASTMNTTYPE | TIVLMNASTTY | NASTMNTTYPE | KEY | 1 | CN |
13 | RELM_NA_VAL_S | ZONEMEASUNIT1 | T006 | MSEHI | KEY | 1 | CN |
14 | RELM_NA_VAL_S | ZONEMEASUNIT2 | T006 | MSEHI | REF | 1 | CN |
15 | RELM_NA_VAL_S | ZONEMEASUNIT3 | T006 | MSEHI | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |