SAP ABAP Table REIS_PR_L (Reporting Fields: Property)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-IS (Application Component) Information System
⤷ RE_IS_BD (Package) RE: Master Data Info System
⤷ RE-FX-IS (Application Component) Information System
⤷ RE_IS_BD (Package) RE: Master Data Info System
Basic Data
Table Category | INTTAB | Structure |
Structure | REIS_PR_L | Table Relationship Diagram |
Short Description | Reporting Fields: Property |
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 | Property and Additional Fields (VIBDPR) | |||||
2 | .INCLUDE | 0 | 0 | Land (VIBDPR) | |||||
3 | .INCLUDE | 0 | 0 | Land | |||||
4 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
5 | INTRENO | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
6 | .INCLUDE | 0 | 0 | Property: Key Fields | |||||
7 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
8 | SWENR | REBDBENO | REBDBENO | CHAR | 8 | 0 | Business Entity Number | * | |
9 | SGRNR | REBDPRNO | REBDPRNO | CHAR | 8 | 0 | Number of Land | ||
10 | .INCLUDE | 0 | 0 | Property: Non-Key Fields | |||||
11 | OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
12 | IMKEY | RECAIMKEY | IMKEY | CHAR | 8 | 0 | Internal Key of Real Estate Object (FI) | ||
13 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
14 | .INCLUDE | 0 | 0 | Field String for Maintenance of User Data | |||||
15 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
16 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
17 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
18 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
19 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
20 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
21 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
22 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
23 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | USR02 | |
24 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | USR02 | |
25 | AUTHGRP | RECAAUTHGRP | RECAAUTHGRP | CHAR | 40 | 0 | Authorization Group | ||
26 | VALIDFROM | REBDOBJVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date: Object Valid From | ||
27 | VALIDTO | REBDOBJVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Object Valid To | ||
28 | XGRTXT | REBDXPR | RECAXLDESCRIPTION | CHAR | 60 | 0 | Name of Land | ||
29 | RGRNART | RGRNART | CHAR2 | CHAR | 2 | 0 | Usage Type of Property According to Land Use Map | TIVC4 | |
30 | BDMQMB1 | BDMQMB1 | WRTV7 | CURR | 13 | 2 | Market value | ||
31 | BDMQMB2 | BDMQMB2 | WRTV7 | CURR | 13 | 2 | Purchase price | ||
32 | BDNRWERT | BDNRWERT | WRTV7 | CURR | 13 | 2 | Land reference value for determining current market value | ||
33 | BDNWERT | BDNWERT | WRTV7 | CURR | 13 | 2 | Land value for determining current market value | ||
34 | DBDNWERT | DBDNWERT | DDAT | DATS | 8 | 0 | Date of land value | ||
35 | RBEPLAN | RBEPLAN | XMBEZ | CHAR | 30 | 0 | Development plan | ||
36 | DBEPLAN | DBEPLAN | DDAT | DATS | 8 | 0 | Date of development plan | ||
37 | XNUTZGRU | XNUTZGRU | XMBEZ | CHAR | 30 | 0 | Current usage of property | ||
38 | NZGRZ | NZGRZ | DEC1_2 | DEC | 3 | 2 | Permitted Usage: Site Occupancy Index | ||
39 | NZGFZ | NZGFZ | DEC2_2 | DEC | 4 | 2 | Permitted Usage: Floor Area Ratio | ||
40 | NZBMZ | NZBMZ | DEC3_2 | DEC | 5 | 2 | Permitted Usage: Construction Dimension Number | ||
41 | NTGRZ | NTGRZ | DEC1_2 | DEC | 3 | 2 | Actual Usage: Site Occupancy Index | ||
42 | NTGFZ | NTGFZ | DEC2_2 | DEC | 4 | 2 | Actual Usage: Floor Area Ratio | ||
43 | NTBMZ | NTBMZ | DEC3_2 | DEC | 5 | 2 | Actual Usage: Construction Dimension Number | ||
44 | RNBPLAN | RNBPLAN | RGRNART | CHAR | 4 | 0 | Usage type according to development plan | TIVB3 | |
45 | SGRART | VVSGRART | VVSGRART | NUMC | 4 | 0 | Property type | TIV56 | |
46 | SGRQAL | VVSGRQAL | VVSGRQAL | NUMC | 3 | 0 | Property: Quality of location | TIV57 | |
47 | SGRFRM | VVSGRFRM | VVSGRFRM | NUMC | 3 | 0 | Property ground type | TIV58 | |
48 | SGRGZS | VVSGRGZS | VVSGRGZS | NUMC | 3 | 0 | Overall condition of property | TIV59 | |
49 | DWIRTUB | VVDWIRTUB | DATUM | DATS | 8 | 0 | Transfer usage / charges | ||
50 | DVERKAUF | VVDVERKAUF | DATUM | DATS | 8 | 0 | Sale date | ||
51 | SUNUTZA | VVSUNART | VVSUNART | CHAR | 8 | 0 | Main usage type | TIV36 | |
52 | JUNUTZA | REBDJUNUTZAOBS | CHAR1 | CHAR | 1 | 0 | OBSOLETE: Main Usage Type | ||
53 | DVRKPLAN | VVDVRKPLAN | DATUM | DATS | 8 | 0 | Planned sale | ||
54 | XGEMARK | VVGEMARK | VVGEMARK | CHAR | 12 | 0 | Local Subdistrict | TIVG2 | |
55 | NFLURNR | NFLURNR | NFLURNR | CHAR | 6 | 0 | Number of Tract of Land in Land Register | ||
56 | XFLURST | XFLURST | TEXT10 | CHAR | 10 | 0 | Parcel of Land | ||
57 | BRFLURST | VVBRFLURST | VVBRFLURST | CHAR | 4 | 0 | Fractional Parcel of Land | ||
58 | JERBBAU | JERBBAU | SOBJERBBAU | CHAR | 1 | 0 | Heritable building right indicator | TDO9 | |
59 | GEMEINDE | VVGEMEINDE | VVGEMEINDE | CHAR | 8 | 0 | Municipality key | TIVG1 | |
60 | ZULBAUH | VVZULBAUH | VVZULBAUH | QUAN | 4 | 0 | Permitted building height | ||
61 | LEINS | VVLEINS | MEINS | UNIT | 3 | 0 | Unit of length | T006 | |
62 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
63 | USGFUNCTION | REBDUSGFUNCTION | REBDUSGFUNCTION | CHAR | 4 | 0 | Function of Object | TIVBDUSGFUNC | |
64 | .INCLUDE | 0 | 0 | ||||||
65 | .INCLU--AP | 0 | 0 | Country specific fields (CI) for Switzerland - PR | |||||
66 | .INCLUDE | 0 | 0 | Rental Object Customer fields | |||||
67 | PLANNO | RELMRPRGNO | RELMRPRGNO | NUMC | 6 | 0 | Real Properties Register Number | ||
68 | LOCATIONCH | REXCCHPRLOCATION | RECAXLDESCRIPTION | CHAR | 60 | 0 | Location Description of Land Acc. To Tax Auth. | ||
69 | ESTATEDESCR | REXCCHPRDESCRIPTION | RECAXLDESCRIPTION | CHAR | 60 | 0 | Location Description of Land Acc. To Land Register | ||
70 | GEMEINDECH | RELMLRDISTRICT | RELMLRDISTRICT | CHAR | 6 | 0 | Land Register District | * | |
71 | .INCLU--AP | 0 | 0 | Country specific fields for India - PR | |||||
72 | SECCO | SECCO | SECCO | CHAR | 4 | 0 | Section Code | * | |
73 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
74 | .INCLU--AP | 0 | 0 | Country-Specific Fields for Portugal - Property | |||||
75 | .INCLUDE | 0 | 0 | Country-Specific Fields for Portugal - Property | |||||
76 | VPT | REXCPTVPT_NOSIGN | REXCPTVPT_NOSIGN | CURR | 15 | 2 | Property Taxable Value | ||
77 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
78 | BUTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
79 | XWETEXT | REBDXBE | RECAXLDESCRIPTION | CHAR | 60 | 0 | Business Entity Name | ||
80 | XUNART | VVXUNART | XTEXT35 | CHAR | 35 | 0 | Main usage type | ||
81 | KTEXT | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
82 | XGEMEINDE | VVXGEMEINDE | VVXGEMEINDE | CHAR | 50 | 0 | Name of municipality | ||
83 | XKREIS | VVXKREIS | VVXKREIS | CHAR | 30 | 0 | Name of district | ||
84 | XREGIO | VVXREGIO | VVXREGIO | CHAR | 30 | 0 | Name of federal state | ||
85 | LGEMARK | VVLGEMARK | VVLGEMARK | CHAR | 25 | 0 | Explanation of sub-district | ||
86 | XADDRESS | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address | ||
87 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
88 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
89 | REALVALIDFROM | REBDREALVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date: Valid from (Effective) | ||
90 | REALVALIDTO | REBDREALVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Valid to (Effective) | ||
91 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
92 | XAUTHGRP | RECAXAUTHGRP | RECAXLDESCRIPTION | CHAR | 60 | 0 | Description of Authorization Group | ||
93 | XMUSGFUNCTION | REBDXMUSGFUNCTION | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Function of Object (Medium) | ||
94 | XJERBBAUK | XTEXT15 | TEXT15 | CHAR | 15 | 0 | Name | ||
95 | XJERBBAUL | XTEXT30 | TEXT30 | CHAR | 30 | 0 | Name | ||
96 | .INCLUDE | 0 | 0 | Account Assignment Fields - Funds Management | |||||
97 | FUND | RERAFUND | CHAR24 | CHAR | 24 | 0 | Fund | ||
98 | FUNDSCENTER | RERAFUNDSCENTER | CHAR24 | CHAR | 24 | 0 | Funds Center | ||
99 | COMMITMENTITEM | RERACOMMITMENTITEM | FM_FIPEX | CHAR | 24 | 0 | Commitment Item | * | |
100 | FUNCTIONALAREA | RERAFUNCTIONALAREA | CHAR24 | CHAR | 24 | 0 | Functional Area | ||
101 | GRANTNUMBER | RERAGRANTNUMBER | CHAR24 | CHAR | 24 | 0 | Grant | ||
102 | MEASURE | RERAMEASURE | CHAR24 | CHAR | 24 | 0 | Program in Funds Management | ||
103 | BUDGETPERIOD | RERABUDGETPERIOD | CHAR24 | CHAR | 24 | 0 | FM: Budget Period | ||
104 | .INCLUDE | 0 | 0 | Reporting Fields: Address for Objects | |||||
105 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
106 | HOUSE_NUM1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
107 | POST_CODE1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
108 | CITY1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
109 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
110 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
111 | .INCLUDE | 0 | 0 | Measurements in Report Profile | |||||
112 | .INCLU-01 | 0 | 0 | Measurement in Report Profile | |||||
113 | MEASVALUE01 | REBDMEASVALUE | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Available | ||
114 | MEASVALUECMPL01 | REBDMEASVALUECMPL | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Capacity | ||
115 | MEASUNIT01 | REBDMEASUNIT | MEINS | UNIT | 3 | 0 | Measurement Unit | * | |
116 | MEASVALIDFROM01 | REBDMEASVALIDFROM | RECADATE | DATS | 8 | 0 | Date: Measurement Valid From | ||
117 | MEASVALIDTO01 | REBDMEASVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Measurement Valid To | ||
118 | .INCLU-02 | 0 | 0 | Measurement in Report Profile | |||||
119 | MEASVALUE02 | REBDMEASVALUE | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Available | ||
120 | MEASVALUECMPL02 | REBDMEASVALUECMPL | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Capacity | ||
121 | MEASUNIT02 | REBDMEASUNIT | MEINS | UNIT | 3 | 0 | Measurement Unit | * | |
122 | MEASVALIDFROM02 | REBDMEASVALIDFROM | RECADATE | DATS | 8 | 0 | Date: Measurement Valid From | ||
123 | MEASVALIDTO02 | REBDMEASVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Measurement Valid To | ||
124 | .INCLU-03 | 0 | 0 | Measurement in Report Profile | |||||
125 | MEASVALUE03 | REBDMEASVALUE | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Available | ||
126 | MEASVALUECMPL03 | REBDMEASVALUECMPL | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Capacity | ||
127 | MEASUNIT03 | REBDMEASUNIT | MEINS | UNIT | 3 | 0 | Measurement Unit | * | |
128 | MEASVALIDFROM03 | REBDMEASVALIDFROM | RECADATE | DATS | 8 | 0 | Date: Measurement Valid From | ||
129 | MEASVALIDTO03 | REBDMEASVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Measurement Valid To | ||
130 | .INCLU-04 | 0 | 0 | Measurement in Report Profile | |||||
131 | MEASVALUE04 | REBDMEASVALUE | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Available | ||
132 | MEASVALUECMPL04 | REBDMEASVALUECMPL | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Capacity | ||
133 | MEASUNIT04 | REBDMEASUNIT | MEINS | UNIT | 3 | 0 | Measurement Unit | * | |
134 | MEASVALIDFROM04 | REBDMEASVALIDFROM | RECADATE | DATS | 8 | 0 | Date: Measurement Valid From | ||
135 | MEASVALIDTO04 | REBDMEASVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Measurement Valid To | ||
136 | .INCLU-05 | 0 | 0 | Measurement in Report Profile | |||||
137 | MEASVALUE05 | REBDMEASVALUE | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Available | ||
138 | MEASVALUECMPL05 | REBDMEASVALUECMPL | REBDMEASVALUE | QUAN | 17 | 4 | Measurement Amount: Capacity | ||
139 | MEASUNIT05 | REBDMEASUNIT | MEINS | UNIT | 3 | 0 | Measurement Unit | * | |
140 | MEASVALIDFROM05 | REBDMEASVALIDFROM | RECADATE | DATS | 8 | 0 | Date: Measurement Valid From | ||
141 | MEASVALIDTO05 | REBDMEASVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Measurement Valid To | ||
142 | .INCLUDE | 0 | 0 | ||||||
143 | MEASISVALIDFROM | REISRECVALIDFROM | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid From | ||
144 | MEASISVALIDTO | REISRECVALIDTO | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid Until | ||
145 | .INCLUDE | 0 | 0 | Time Slot Valid in a Row in the Info System | |||||
146 | RECISVALIDFROM | REISRECVALIDFROM | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid From | ||
147 | RECISVALIDTO | REISRECVALIDTO | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid Until | ||
148 | .INCLUDE | 0 | 0 | Reporting Fields: Generic Part | |||||
149 | GEN_OBJTYPE | RECAOBJTYPE | J_OBART | CHAR | 2 | 0 | Object Type | * | |
150 | GEN_OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
151 | GEN_CONTRACT | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
152 | GEN_PARTNER1 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
153 | GEN_PARTNER2 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
154 | ALVROWS | REISALVROWS | INT2 | 5 | 0 | Number of Rows | |||
155 | .INCLU--AP | 0 | 0 | Additional Fields Reporting | |||||
156 | XGEMEINDECH | VVXGEMEINDE | VVXGEMEINDE | CHAR | 50 | 0 | Name of municipality | ||
157 | XKREISCH | VVXKREIS | VVXKREIS | CHAR | 30 | 0 | Name of district | ||
158 | XREGIOCH | VVXREGIO | VVXREGIO | CHAR | 30 | 0 | Name of federal state |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | REIS_PR_L | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | REIS_PR_L | CURRENCY | TCURC | WAERS | |||
3 | REIS_PR_L | GEMEINDE | TIVG1 | GEMEINDE | KEY | 1 | CN |
4 | REIS_PR_L | JERBBAU | TDO9 | SOBJERBBAU | |||
5 | REIS_PR_L | LEINS | T006 | MSEHI | REF | C | CN |
6 | REIS_PR_L | RESPONSIBLE | USR02 | BNAME | REF | 1 | CN |
7 | REIS_PR_L | RGRNART | TIVC4 | RGRNART | KEY | 1 | CN |
8 | REIS_PR_L | RNBPLAN | TIVB3 | RNBPLAN | 1 | CN | |
9 | REIS_PR_L | SGRART | TIV56 | SGRART | KEY | 1 | CN |
10 | REIS_PR_L | SGRFRM | TIV58 | SGRFRM | KEY | 1 | CN |
11 | REIS_PR_L | SGRGZS | TIV59 | SGRGZS | KEY | 1 | CN |
12 | REIS_PR_L | SGRQAL | TIV57 | SGRQAL | KEY | 1 | CN |
13 | REIS_PR_L | SUNUTZA | TIV36 | SUNART | KEY | 1 | CN |
14 | REIS_PR_L | TXJCD | TTXJ | TXJCD | REF | C | CN |
15 | REIS_PR_L | USEREXCLUSIVE | USR02 | BNAME | REF | C | CN |
16 | REIS_PR_L | USGFUNCTION | TIVBDUSGFUNC | USGFUNCTION | |||
17 | REIS_PR_L | WAERS | TCURC | WAERS | REF | C | CN |
18 | REIS_PR_L | XGEMARK | TIVG2 | GEMARK |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 200 |