SAP ABAP Table REBDBUFLDS (Real Estate Buildings: Work and Screen Fields)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	REBDBUFLDS	Table Relationship Diagram
Short Description	Real Estate Buildings: Work and Screen Fields

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	Building + Additional Fields (VIBDBU)
2	.INCLUDE	☐				0	0	Building (VIBDBU)
3	.INCLUDE	☐				0	0	Building
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	Building: Key Fields
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	SWENR	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
9	SGENR	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building
10	.INCLUDE	☐				0	0	Building: 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	XGETXT	☐	REBDXBU	RECAXLDESCRIPTION	CHAR	60	0	Description of Building
29	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
30	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
31	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
32	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
33	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
34	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
35	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
36	BBAUW13	☐	BBAUWXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933
37	BBAUWX	☐	BBAUWX	RECACURR	CURR	15	2	Building Value
38	BBAUWAKT	☐	BBAUWAKTXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933
39	BBAUWAKTX	☐	BBAUWAKTX	RECACURR	CURR	15	2	Current Building Value
40	BDMCBMRA	☐	BDMCBMRA	WRBTR	CURR	11	2	Amount per volume unit
41	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
42	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
43	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
44	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
45	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
46	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
47	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
48	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
49	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
50	BEINHEITW	☐	BEINHEITWXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933
51	BEINHEITWX	☐	BEINHEITWX	RECACURR	CURR	15	2	Assessed Value of Building
52	NEINHEITW	☐	NEINHEITW	GJAHR	NUMC	4	0	Assessed value base year
53	BVERSWRT	☐	BVERSWRTXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933
54	BVERSWRTX	☐	BVERSWRTX	RECACURR	CURR	15	2	Insurable Value Amount
55	RVERSWRT	☐	RVERSWRT	RVERSWRT	NUMC	1	0	Type of insurance value
56	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
57	DVERKAUF	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
58	DVRKPLAN	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
59	DNUTZEND	☐	VVDNUTZEND	DATUM	DATS	8	0	End of usage
60	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
61	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
62	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
63	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
64	JUNUTZA	☐	REBDJUNUTZAOBS	CHAR1	CHAR	1	0	OBSOLETE: Main Usage Type
65	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	*
66	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	*
67	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
68	JANLHIE	☐	REBDJANLHIEOBS	CHAR1	CHAR	1	0	OBSOLETE: Asset Assignment Also Applies for Subord. Building
69	RLRALOC	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	TIVAJRLRALOC
70	USESRLRA	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
71	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
72	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
73	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
74	HASCOP	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
75	USGFUNCTION	☐	REBDUSGFUNCTION	REBDUSGFUNCTION	CHAR	4	0	Function of Object	TIVBDUSGFUNC
76	.INCLUDE	☐				0	0
77	.INCLU--AP	☐				0	0	Country specific fields (CI) for Switzerland - BU
78	.INCLUDE	☐				0	0	Building Customer fields
79	OBJCOND	☐	REXCCHBUCOND	REXCCHBUCOND	NUMC	4	0	Code of Building Status	TIVXCCHCOND
80	OBJCAT	☐	REXCCHBUCATEGORY	REXCCHBUCATEGORY	NUMC	4	0	Building Category Code	TIVXCCHKAT
81	YEARDECONSTR	☐	REXCCHBUDECONYEAR	DATUM	DATS	8	0	Year of Demolition
82	AREAVALUE	☐	REXCCHBUAREA	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Floor Area of Building in Square Meters
83	HEATINGTYPE	☐	REXCCHBUHEATINGTYPE	REXCCHBUHEATINGTYPE	NUMC	4	0	Code of Heating Type	TIVXCCHHEAT
84	ENERGYHEAT	☐	REXCCHBUENERGYSOURCEH	REXCCHBUENERGYSOURCE	NUMC	4	0	Energy Carrier of Heating	TIVXCCHGENSRC
85	ENERGYWATER	☐	REXCCHBUENERGYSOURCEW	REXCCHBUENERGYSOURCE	NUMC	4	0	Energy Carrier of Hot Water	TIVXCCHGENSRC
86	HOTWATERSUPPLY	☐	REXCCHBUHOTWATER	RECABOOL	CHAR	1	0	Central Hot Water Supply
87	POWERCONSUM	☐	REXCCHBUPOWERCONSUMPTION	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Power Consumption of Building (in kWh)
88	GLAZING	☐	REXCCHBUGLAZING	TEXT15	CHAR	15	0	Glazing Type
89	ADMINNO	☐	REXCCHBUADMINNO	REXCCHBUADMINNO	CHAR	12	0	Administrative Building Number
90	ADMINXGETXT	☐	REXCCHBUADMINXBU	RECAXLDESCRIPTION	CHAR	60	0	Building Name
91	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
92	BANZGECH	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
93	SSTCKBISCH	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	*
94	SLIFTBISCH	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	*
95	AUGESCHCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
96	.INCLU--AP	☐				0	0	Country specific fields for India - BU
97	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
98	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
99	.INCLU--AP	☐				0	0	Localization Japan: Additional fields Building
100	.INCLUDE	☐				0	0	Country Specific Fields for Japan
101	REPKOCH	☐	REXCJPREPKOCH	REXCJPREPKOCH	CHAR	1	0	Kind of Change
102	BDCONSTR	☐	REXCJPBDCONSTR	REXCJPBDCONST	CHAR	1	0	Construction Status
103	BDFIREPREV	☐	REXCJPBDFIREPREV	CHAR8	CHAR	8	0	Fire Fighting Method Number
104	BDOTHOW	☐	REXCJPBDOTHOW	INT4	INT4	10	0	Number of Another Owners in the Same Building
105	BDOWNSHIP	☐	REXCJPBDOWNSHIP	REXCJPBDOWNSH	CHAR	1	0	Building Ownership Status
106	KOCHDATE	☐	REXCJPKOCHDATE	RECADATE	DATS	8	0	Date of Change in Kind of Change
107	.INCLU--AP	☐				0	0	Country-Specific fields for Portugal - Building
108	.INCLUDE	☐				0	0	Country-Specific Fields for Portugal - Building
109	VPT	☐	REXCPTVPT_NOSIGN	REXCPTVPT_NOSIGN	CURR	15	2	Property Taxable Value
110	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
111	CONDK	☐	REXCPTRACONS		CHAR	4	0	Conservation Level	TIVXCPTRACONS
112	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
113	XWETEXT	☐	REBDXBE	RECAXLDESCRIPTION	CHAR	60	0	Business Entity Name
114	XUNART	☐	VVXUNART	XTEXT35	CHAR	35	0	Main usage type
115	KTEXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
116	XGEBART	☐	XGEBART	XTEXT50	CHAR	50	0	Type of building
117	XGEBZUST	☐	XGEBZUST	XTEXT50	CHAR	50	0	Description of condition of building
118	XGEMEINDE	☐	VVXGEMEINDE	VVXGEMEINDE	CHAR	50	0	Name of municipality
119	XKREIS	☐	VVXKREIS	VVXKREIS	CHAR	30	0	Name of district
120	XREGIO	☐	VVXREGIO	VVXREGIO	CHAR	30	0	Name of federal state
121	RLRA	☐	REAJRLRA	REAJRLRA	CHAR	6	0	Representative List of Rents	TIVAJRLRA
122	XRLRA	☐	REAJXRLRA	RECAXLDESCRIPTION	CHAR	60	0	Description of Representative List of Rents
123	XRLRALOC	☐	REAJXRLRALOC	RECAXLDESCRIPTION	CHAR	60	0	Name of Location Class
124	XDAZUST	☐	VVXZUSTTXT	XTEXT50	CHAR	50	0	Description of condition of a real estate object
125	XFAZUST	☐	VVXZUSTTXT	XTEXT50	CHAR	50	0	Description of condition of a real estate object
126	XADDRESS	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
127	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
128	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
129	REALVALIDFROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
130	REALVALIDTO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
131	XSTOCKO	☐	REBDXSTOCKO	XKBEZ	CHAR	15	0	Top Floor (Floor Name)
132	XSTOCKL	☐	REBDXSTOCKL	XKBEZ	CHAR	15	0	Elevator to (Floor Name)
133	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
134	XAUTHGRP	☐	RECAXAUTHGRP	RECAXLDESCRIPTION	CHAR	60	0	Description of Authorization Group
135	XMUSGFUNCTION	☐	REBDXMUSGFUNCTION	RECAXMDESCRIPTION	CHAR	30	0	Name of Function of Object (Medium)
136	XJERBBAUK	☐	XTEXT15	TEXT15	CHAR	15	0	Name
137	XJERBBAUL	☐	XTEXT30	TEXT30	CHAR	30	0	Name
138	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
139	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
140	HASASSETS	☐	REBDBUHASASSETS	RECABOOL	CHAR	1	0	Fixed Assets Are Assigned to Building
141	INDPROZ13	☐	INDPRZ	DEC5_3	DEC	8	3	Index percentage
142	INDMON13	☐	INDMON	KMONAT	NUMC	2	0	Indexing month
143	INDJHR13	☐	INDJHR	GJAHR	NUMC	4	0	Indexing year
144	XBPIDX13	☐	XBPIDX	TEXT15	CHAR	15	0	Construction cost index ID
145	XTXTFROM13	☐	REBDXTXTFROM	REBDXTXTFROM	CHAR	4	0	Screen Text Field: "From"
146	INDPROZ14	☐	INDPRZ	DEC5_3	DEC	8	3	Index percentage
147	INDMON14	☐	INDMON	KMONAT	NUMC	2	0	Indexing month
148	INDJHR14	☐	INDJHR	GJAHR	NUMC	4	0	Indexing year
149	XBPIDX14	☐	XBPIDX	TEXT15	CHAR	15	0	Construction cost index ID
150	XTXTFROM14	☐	REBDXTXTFROM	REBDXTXTFROM	CHAR	4	0	Screen Text Field: "From"
151	BUBRAUNIT	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	*
152	BBAUW13CURR	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
153	BBAUWAKTCURR	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
154	BEINHEITWCURR	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
155	BVERSWRTCURR	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
156	BDMCBMRACURR	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
157	BDMCBMRAUNIT	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	*
158	SLASH1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
159	XSTBISDD	☐	REBDXSTOCKWDD	RECAXLDESCRIPTION	CHAR	60	0	Floor Number for Drop-Down Boxes
160	XLIFTBISDD	☐	REBDXSTOCKWDD	RECAXLDESCRIPTION	CHAR	60	0	Floor Number for Drop-Down Boxes
161	FDACHFLUNIT	☐	FEINS	MEINS	UNIT	3	0	Area unit	*
162	BUILDINGYEAR	☐	VVXBAUJ	VVXBAUJ	CHAR	10	0	Year of construction of building

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REBDBUFLDS	BUKRS	T001	BUKRS
2	REBDBUFLDS	CONDK	TIVXCPTRACONS	CONSLEVEL
3	REBDBUFLDS	CURRENCY	TCURC	WAERS
4	REBDBUFLDS	ENERGYHEAT	TIVXCCHGENSRC	ENERGYSRC	KEY
5	REBDBUFLDS	ENERGYWATER	TIVXCCHGENSRC	ENERGYSRC	KEY
6	REBDBUFLDS	GEMEINDE	TIVG1	GEMEINDE	KEY	1	CN
7	REBDBUFLDS	HEATINGTYPE	TIVXCCHHEAT	HEATINGTYPE	KEY
8	REBDBUFLDS	JERBBAU	TDO9	SOBJERBBAU
9	REBDBUFLDS	OBJCAT	TIVXCCHKAT	BCATEGORY	KEY
10	REBDBUFLDS	OBJCOND	TIVXCCHCOND	BCOND	KEY
11	REBDBUFLDS	REINS	T006	MSEHI	REF	C	CN
12	REBDBUFLDS	RESPONSIBLE	USR02	BNAME	REF	1	CN
13	REBDBUFLDS	RGEBART	TIV5A	SOBJART	KEY	1	CN
14	REBDBUFLDS	RGEBZUST	TIV83	RZUSTAND
15	REBDBUFLDS	RLRA	TIVAJRLRA	RLRA	REF	C	CN
16	REBDBUFLDS	RLRALOC	TIVAJRLRALOC	RLRALOC	REF	C	CN
17	REBDBUFLDS	SUNUTZA	TIV36	SUNART	KEY	1	CN
18	REBDBUFLDS	TXJCD	TTXJ	TXJCD	REF	C	CN
19	REBDBUFLDS	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
20	REBDBUFLDS	USGFUNCTION	TIVBDUSGFUNC	USGFUNCTION	REF	C	CN
21	REBDBUFLDS	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	110