SAP ABAP Table RECP_NA_VAL_C (Assessed Value)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-CP (Application Component) Correspondence
⤷ RE_CP_SD (Package) RE: Data Retrieval (for Mass Print)
⤷ RE-FX-CP (Application Component) Correspondence
⤷ RE_CP_SD (Package) RE: Data Retrieval (for Mass Print)
Basic Data
Table Category | INTTAB | Structure |
Structure | RECP_NA_VAL_C | Table Relationship Diagram |
Short Description | Assessed Value |
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 | XDATERANGE | RECAXDATERANGE | CHAR23 | CHAR | 23 | 0 | Time Period (Text) | ||
71 | CUKY2ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
72 | ASSESSVALUE2ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
73 | TAXVAL12ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | TCURC | |
74 | ZONEVALUE12ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
75 | ZONEVALUE22ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
76 | ZONEVALUE32ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
77 | PROPERTYVAL12ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
78 | PROPERTYVAL22ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
79 | GROUNDVAL2ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
80 | BASICVAL2ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
81 | BUILDINGVAL12ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
82 | BUILDINGVAL22ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
83 | CALCVALUE2ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
84 | CALCDIFF2ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
85 | MEAS12ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
86 | MEAS22ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
87 | MEAS32ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
88 | MEAS42ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
89 | MEAS52ND | RECPCUKY2ND | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
90 | MEASUNIT_OUT | RECAUNITOUT | MSEH6 | CHAR | 6 | 0 | Unit of Measure: Technical Representation | ||
91 | ZONEMEASUNIT1_OUT | RECAUNITOUT | MSEH6 | CHAR | 6 | 0 | Unit of Measure: Technical Representation | ||
92 | ZONEMEASUNIT2_OUT | RECAUNITOUT | MSEH6 | CHAR | 6 | 0 | Unit of Measure: Technical Representation | ||
93 | ZONEMEASUNIT3_OUT | RECAUNITOUT | MSEH6 | CHAR | 6 | 0 | Unit of Measure: Technical Representation | ||
94 | MEASUNIT1_OUT | RECAUNITOUT | MSEH6 | CHAR | 6 | 0 | Unit of Measure: Technical Representation | ||
95 | MEASUNIT2_OUT | RECAUNITOUT | MSEH6 | CHAR | 6 | 0 | Unit of Measure: Technical Representation | ||
96 | MEASUNIT3_OUT | RECAUNITOUT | MSEH6 | CHAR | 6 | 0 | Unit of Measure: Technical Representation | ||
97 | MEASUNIT4_OUT | RECAUNITOUT | MSEH6 | CHAR | 6 | 0 | Unit of Measure: Technical Representation | ||
98 | MEASUNIT5_OUT | RECAUNITOUT | MSEH6 | CHAR | 6 | 0 | Unit of Measure: Technical Representation |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RECP_NA_VAL_C | CURRENCY | TCURC | WAERS | KEY | 1 | CN |
2 | RECP_NA_VAL_C | MEASUNIT | T006 | MSEHI | KEY | 1 | CN |
3 | RECP_NA_VAL_C | MEASUNIT1 | T006 | MSEHI | KEY | 1 | CN |
4 | RECP_NA_VAL_C | MEASUNIT2 | T006 | MSEHI | KEY | 1 | CN |
5 | RECP_NA_VAL_C | MEASUNIT3 | T006 | MSEHI | KEY | 1 | CN |
6 | RECP_NA_VAL_C | MEASUNIT4 | T006 | MSEHI | KEY | 1 | CN |
7 | RECP_NA_VAL_C | MEASUNIT5 | T006 | MSEHI | KEY | 1 | CN |
8 | RECP_NA_VAL_C | NAOWNREL | TIVLMNAOWNREL | NAOWNREL | KEY | 1 | CN |
9 | RECP_NA_VAL_C | NAPRTYPE | TIVLMNAPRTY | NAPRTYPE | KEY | 1 | CN |
10 | RECP_NA_VAL_C | NAPRTYPEAR | TIVLMNAPRTYAR | NAPRTYPEAR | KEY | 1 | CN |
11 | RECP_NA_VAL_C | NASTMNTTYPE | TIVLMNASTTY | NASTMNTTYPE | KEY | 1 | CN |
12 | RECP_NA_VAL_C | TAXVAL12ND | TCURC | WAERS | |||
13 | RECP_NA_VAL_C | ZONEMEASUNIT1 | T006 | MSEHI | KEY | 1 | CN |
14 | RECP_NA_VAL_C | ZONEMEASUNIT2 | T006 | MSEHI | REF | 1 | CN |
15 | RECP_NA_VAL_C | ZONEMEASUNIT3 | T006 | MSEHI | KEY | 1 | CN |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in | 600 |