SAP ABAP Table REBD_PROPERTY (Land (VIBDPR))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-BD (Application Component) Basic Data
     ⤷ RE_BD_PR (Package) RE: Property Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	REBD_PROPERTY	Table Relationship Diagram
Short Description	Land (VIBDPR)

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	Land
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
4	.INCLUDE	☐				0	0	Property: Key Fields
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	SWENR	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
7	SGRNR	☐	REBDPRNO	REBDPRNO	CHAR	8	0	Number of Land	*
8	.INCLUDE	☐				0	0	Property: Non-Key Fields
9	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
10	IMKEY	☐	RECAIMKEY	IMKEY	CHAR	8	0	Internal Key of Real Estate Object (FI)
11	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
12	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
13	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
14	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
15	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
16	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
17	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
18	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
19	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
20	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
21	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
22	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
23	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
24	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
25	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
26	XGRTXT	☐	REBDXPR	RECAXLDESCRIPTION	CHAR	60	0	Name of Land
27	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
28	BDMQMB1	☐	BDMQMB1	WRTV7	CURR	13	2	Market value
29	BDMQMB2	☐	BDMQMB2	WRTV7	CURR	13	2	Purchase price
30	BDNRWERT	☐	BDNRWERT	WRTV7	CURR	13	2	Land reference value for determining current market value
31	BDNWERT	☐	BDNWERT	WRTV7	CURR	13	2	Land value for determining current market value
32	DBDNWERT	☐	DBDNWERT	DDAT	DATS	8	0	Date of land value
33	RBEPLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
34	DBEPLAN	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
35	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
36	NZGRZ	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
37	NZGFZ	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
38	NZBMZ	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
39	NTGRZ	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
40	NTGFZ	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
41	NTBMZ	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
42	RNBPLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan	TIVB3
43	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
44	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
45	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
46	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
47	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
48	DVERKAUF	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
49	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
50	JUNUTZA	☐	REBDJUNUTZAOBS	CHAR1	CHAR	1	0	OBSOLETE: Main Usage Type
51	DVRKPLAN	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
52	XGEMARK	☐	VVGEMARK	VVGEMARK	CHAR	12	0	Local Subdistrict	TIVG2
53	NFLURNR	☐	NFLURNR	NFLURNR	CHAR	6	0	Number of Tract of Land in Land Register
54	XFLURST	☐	XFLURST	TEXT10	CHAR	10	0	Parcel of Land
55	BRFLURST	☐	VVBRFLURST	VVBRFLURST	CHAR	4	0	Fractional Parcel of Land
56	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
57	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
58	ZULBAUH	☐	VVZULBAUH	VVZULBAUH	QUAN	4	0	Permitted building height
59	LEINS	☐	VVLEINS	MEINS	UNIT	3	0	Unit of length	T006
60	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
61	USGFUNCTION	☐	REBDUSGFUNCTION	REBDUSGFUNCTION	CHAR	4	0	Function of Object	TIVBDUSGFUNC
62	.INCLUDE	☐				0	0
63	.INCLU--AP	☐				0	0	Country specific fields (CI) for Switzerland - PR
64	.INCLUDE	☐				0	0	Rental Object Customer fields
65	PLANNO	☐	RELMRPRGNO	RELMRPRGNO	NUMC	6	0	Real Properties Register Number
66	LOCATIONCH	☐	REXCCHPRLOCATION	RECAXLDESCRIPTION	CHAR	60	0	Location Description of Land Acc. To Tax Auth.
67	ESTATEDESCR	☐	REXCCHPRDESCRIPTION	RECAXLDESCRIPTION	CHAR	60	0	Location Description of Land Acc. To Land Register
68	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
69	.INCLU--AP	☐				0	0	Country specific fields for India - PR
70	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
71	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
72	.INCLU--AP	☐				0	0	Country-Specific Fields for Portugal - Property
73	.INCLUDE	☐				0	0	Country-Specific Fields for Portugal - Property
74	VPT	☐	REXCPTVPT_NOSIGN	REXCPTVPT_NOSIGN	CURR	15	2	Property Taxable Value
75	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REBD_PROPERTY	BUKRS	T001	BUKRS	KEY	1	CN
2	REBD_PROPERTY	CURRENCY	TCURC	WAERS
3	REBD_PROPERTY	GEMEINDE	TIVG1	GEMEINDE	KEY	1	CN
4	REBD_PROPERTY	JERBBAU	TDO9	SOBJERBBAU
5	REBD_PROPERTY	LEINS	T006	MSEHI	REF	C	CN
6	REBD_PROPERTY	RESPONSIBLE	USR02	BNAME	REF	1	CN
7	REBD_PROPERTY	RGRNART	TIVC4	RGRNART	KEY	1	CN
8	REBD_PROPERTY	RNBPLAN	TIVB3	RNBPLAN		1	CN
9	REBD_PROPERTY	SGRART	TIV56	SGRART	KEY	1	CN
10	REBD_PROPERTY	SGRFRM	TIV58	SGRFRM	KEY	1	CN
11	REBD_PROPERTY	SGRGZS	TIV59	SGRGZS	KEY	1	CN
12	REBD_PROPERTY	SGRQAL	TIV57	SGRQAL	KEY	1	CN
13	REBD_PROPERTY	SUNUTZA	TIV36	SUNART	KEY	1	CN
14	REBD_PROPERTY	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
15	REBD_PROPERTY	USGFUNCTION	TIVBDUSGFUNC	USGFUNCTION
16	REBD_PROPERTY	WAERS	TCURC	WAERS	REF	C	CN
17	REBD_PROPERTY	XGEMARK	TIVG2	GEMARK

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C