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

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