SAP ABAP Table REBDROFLDS (RE Rental Object: Work and Screen Fields)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-BD (Application Component) Basic Data
     ⤷ RE_BD_RO (Package) RE: Rental Object Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	REBDROFLDS	Table Relationship Diagram
Short Description	RE Rental Object: 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	Rental Object and Additional Fields (VIBDRO)
2	.INCLUDE	☐				0	0	Rental Object (VIBDRO)
3	.INCLUDE	☐				0	0	Rental Object
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	Rental Object: Key Fields
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	SWENR	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
9	SMENR	☐	REBDRONO	REBDRONO	CHAR	8	0	Number of Rental Object
10	.INCLUDE	☐				0	0	Rental Object: 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	ROTYPE	☐	REBDROTYPE	REBDROTYPE	CHAR	2	0	Rental Object Type
29	SNUNR	☐	REBDUSAGETYPE	SNUNR	NUMC	4	0	Usage Type of Rental Object	TIV01
30	XMETXT	☐	REBDXRO	RECAXLDESCRIPTION	CHAR	60	0	Rental Object Name
31	SGRNR	☐	REBDPRNO	REBDPRNO	CHAR	8	0	Number of Land	*
32	SGENR	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building	*
33	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
34	CANBECOMMON	☐	REBDCANBECOMMON	RECABOOL	CHAR	1	0	Common Usage Possible
35	FIRSTPOSTING	☐	RECDCFSTARTFROM	RECADATE	DATS	8	0	Cash Flow Generated Starting On
36	DBEZU	☐	DBEZU	DDAT	DATS	8	0	Date of initial usage
37	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
38	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
39	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
40	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
41	RLRAFIXFITCATE	☐	REAJRLRAFIXFITCATE	REAJRLRAFIXFITCATE	CHAR	6	0	Fixtures and Fittings Category	TIVAJRLRAFFCT
42	RLRALOC	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	TIVAJRLRALOC
43	PZUABSP	☐	REBDSUREPERCENT	REBDSUREPERCENT	DEC	4	2	Increase or Reduction for Representative List of Rents
44	SPOSINMSP	☐	REBDRLRABASEIND	REAJRLRAADJMBASE	CHAR	1	0	Method for Calculating Base Rent of Rep. List of Rents
45	PPOSINMSP	☐	REBDRLRAPERCENT	DECV3_2	DEC	5	2	Percentage for Positioning RU in RLR Spread
46	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
47	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase	TIV43
48	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
49	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
50	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
51	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
52	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
53	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
54	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
55	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
56	CFPOSTINGFROM	☐	RECDCFPOSTINGFROM	RECADATE	DATS	8	0	First Posting From
57	HASCOP	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
58	RLRA	☐	REAJRLRA	REAJRLRA	CHAR	6	0	Representative List of Rents	TIVAJRLRA
59	USESRLRA	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
60	BUILDYEAR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
61	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
62	COMMONOWNED	☐	REBDCOMMONOWNED	RECABOOL	CHAR	1	0	Rental Object Is Common Property
63	OOLOCK	☐	REOROOLOCK	RECABOOL	CHAR	1	0	Do Not Consider Object for Real Estate Search
64	NEIGHBORH1	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
65	NEIGHBORH2	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
66	NEIGHBORH3	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
67	.INCLUDE	☐				0	0
68	.INCLU--AP	☐				0	0	Country Specific fields for Switzerland
69	.INCLUDE	☐				0	0	Rental Object Customer fields
70	EDID	☐	REXCCHEDID	REXCCHEDID	NUMC	2	0	Federal Building Entrance Identification Number (EDID)
71	EGID	☐	REXCCHEGID	REXCCHEGID	NUMC	9	0	Federal Building Identification Number (EGID)
72	FLOOR	☐	REXCCHROFLOOR	REXCCHROFLOOR	NUMC	4	0	Code of Floor	*
73	FLOORLOC	☐	REXCCHROFLOORLOC	REXCCHROFLOORLOC	CHAR	40	0	Location of Dwelling on a Floor
74	EWID	☐	REXCCHEWID	REXCCHEWID	NUMC	3	0	Federal Dwelling Identification Number (EWID)
75	KITCHEN	☐	REXCCHROKITCHEN	REXCCHROKITCHEN	NUMC	4	0	Code of Cooking Facilities	*
76	ADMINNO	☐	REXCCHROADMINNO	REXCCHROADMINNO	CHAR	12	0	Administrative Dwelling Number
77	DOORNO	☐	REXCCHRODOORNO	REXCCHRODOORNO	CHAR	8	0	Door Number of Dwelling
78	OBJCOND	☐	REXCCHROCOND	REXCCHROCOND	NUMC	4	0	Code of Dwelling Status	*
79	YEARDECONSTR	☐	REXCCHBUDECONYEAR	DATUM	DATS	8	0	Year of Demolition
80	NUMROOMS	☐	REXCCHRONUMROOMS	REXCCHRONUMROOMS	NUMC	4	0	Number of Rooms in the Dwelling
81	LIVINGAREA	☐	REXCCHROAREA	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Floor Area of Dwelling in M2
82	USAGETYPE	☐	REXCCHROUSAGETYPE	REXCCHROUSAGETYPE	NUMC	4	0	Code of Usage Type	*
83	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
84	.INCLU--AP	☐				0	0	Country-Specific fields for Portugal
85	.INCLUDE	☐				0	0	Country-Specific Fields for Portugal - Rental Object
86	VPT	☐	REXCPTVPT_NOSIGN	REXCPTVPT_NOSIGN	CURR	15	2	Property Taxable Value
87	VPTCURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
88	CONDK	☐	REXCPTRACONS		CHAR	4	0	Conservation Level	TIVXCPTRACONS
89	BUKRSTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
90	XWETEXT	☐	REBDXBE	RECAXLDESCRIPTION	CHAR	60	0	Business Entity Name
91	XGRTXT	☐	REBDXPR	RECAXLDESCRIPTION	CHAR	60	0	Name of Land
92	XGETXT	☐	REBDXBU	RECAXLDESCRIPTION	CHAR	60	0	Description of Building
93	XLROTYPE	☐	REBDXLROTYPE	RECAXLDESCRIPTION	CHAR	60	0	Name of Rental Object Type
94	XMBEZ	☐	XNUNRM	XMBEZ	CHAR	30	0	Description of external usage type of rental unit
95	XRLRA	☐	REAJXRLRA	RECAXLDESCRIPTION	CHAR	60	0	Description of Representative List of Rents
96	XRLRAFIXFITCATE	☐	REAJXRLRAFIXFITCATE	RECAXLDESCRIPTION	CHAR	60	0	Description of Fixtures and Fittings Category
97	XRLRALOC	☐	REAJXRLRALOC	RECAXLDESCRIPTION	CHAR	60	0	Name of Location Class
98	XAUSTKLL	☐	XAUSTKLL	XTEXT50	CHAR	50	0	Long text of fixture and fitting category
99	XSTOCKK	☐	VVXSTOCKK	VVXSTOCKK	CHAR	4	0	Short name of floor
100	XSTOCKL	☐	VVXSTOCKL	XMBEZ	CHAR	30	0	Floor ID
101	XSTBISK	☐	VVXSTBISK	VVXSTOCKK	CHAR	4	0	For RUs with several storeys: Top storey of RU
102	XSTBISL	☐	VVXSTOCKL	XMBEZ	CHAR	30	0	Floor ID
103	XKLGESCH	☐	XKLGESCH	XKBEZ	CHAR	15	0	Location in floor short name
104	XSLIFTBIS	☐	VVXLIFTB	VVXSTOCKK	CHAR	4	0	Elevator to floor in building
105	XSTOCKL_LIFTBIS	☐	VVXSTOCKL	XMBEZ	CHAR	30	0	Floor ID
106	XGBVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
107	NBANDNR	☐	NBANDNR	TEXT15	CHAR	15	0	Land register volume number
108	NBLATTNR	☐	NBLATTNR	TEXT15	CHAR	15	0	Land register page number
109	XGEBK	☐	XGEBK	XKBEZ	CHAR	15	0	Short name for parts of building
110	XADDRESS	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
111	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
112	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
113	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
114	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
115	REALVALIDFROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
116	REALVALIDTO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
117	XAUTHGRP	☐	RECAXAUTHGRP	RECAXLDESCRIPTION	CHAR	60	0	Description of Authorization Group
118	RLRAAGE	☐	REAJRLRAAGE	REAJRLRAAGE	CHAR	6	0	Building Age Category	TIVAJRLRAAGE
119	RLRASIZ	☐	REAJRLRASIZ	REAJRLRASIZ	CHAR	6	0	Size Class	TIVAJRLRASIZ
120	RLRALABEL	☐	REAJRLRALABEL	REAJRLRALABEL	CHAR	10	0	Representative List of Rents Label	TIVAJRLRALABEL
121	XRLRALABEL	☐	REAJXRLRALABEL	RECAXLDESCRIPTION	CHAR	60	0	Name of Representative List of Rents Label
122	XGEBM	☐	XGEBM	XMBEZ	CHAR	30	0	Building parts long text
123	XSVACREASON	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
124	XMVACREASON	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
125	XVACCOSTCENTER	☐	KTEXT	TEXT20	CHAR	20	0	General Name
126	XKBELBEZ	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
127	XKPROZGRD	☐	XKPROZGRD	XKBEZ	CHAR	15	0	Reason for percentage rate increase
128	PHPZSAKT	☐	VVPHPZSAKT	DEC2_3	DEC	5	3	Interest rate of mortgage loan on a specific date
129	PUTBKAKT	☐	VVPUTBKAKT	DEC5_3	DEC	8	3	Change in maint./operating costs index in percentage points
130	PTEURAKT	☐	VVPTEURAKT	DEC5_3	DEC	8	3	Standard of living index point status on a date
131	XBEWERBER	☐	XBEWERBER	XLBEZ	CHAR	60	0	Name of applicant
132	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	*
133	XSTOCKDD	☐	REBDXSTOCKWDD	RECAXLDESCRIPTION	CHAR	60	0	Floor Number for Drop-Down Boxes
134	XSTBISDD	☐	REBDXSTOCKWDD	RECAXLDESCRIPTION	CHAR	60	0	Floor Number for Drop-Down Boxes
135	POOLID	☐	REBDRONOPS	REBDRONO	CHAR	8	0	Number of Pooled Space
136	XPOOL	☐	REBDXRO	RECAXLDESCRIPTION	CHAR	60	0	Rental Object Name
137	CH_SLASH1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
138	CH_PERCENT1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
139	ISRLRALOCFROMSUPER	☐	RECABOOL	RECABOOL	CHAR	1	0	General Yes/No Field
140	BUILDINGYEAR	☐	VVXBAUJ	VVXBAUJ	CHAR	10	0	Year of construction of building
141	ISRLRAFROMSUPER	☐	RECABOOL	RECABOOL	CHAR	1	0	General Yes/No Field
142	ISBUILDYEARFROMSUPER	☐	RECABOOL	RECABOOL	CHAR	1	0	General Yes/No Field
143	XBUILDINGYEARICON	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
144	XRLRAICON	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
145	XRLRALOCICON	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
146	ISCURRENCYFROMSUPER	☐	RECABOOL	RECABOOL	CHAR	1	0	General Yes/No Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REBDROFLDS	BUKRS	T001	BUKRS
2	REBDROFLDS	CONDK	TIVXCPTRACONS	CONSLEVEL
3	REBDROFLDS	CURRENCY	TCURC	WAERS	KEY	1	CN
4	REBDROFLDS	NEIGHBORH1	TIVBDNEIGHBORH	NEIGHBORHOOD
5	REBDROFLDS	NEIGHBORH2	TIVBDNEIGHBORH	NEIGHBORHOOD
6	REBDROFLDS	NEIGHBORH3	TIVBDNEIGHBORH	NEIGHBORHOOD
7	REBDROFLDS	RESPONSIBLE	USR02	BNAME	REF	1	CN
8	REBDROFLDS	RLGESCH	TIV38	RLGESCH	KEY	1	CN
9	REBDROFLDS	RLRA	TIVAJRLRA	RLRA	KEY	1	CN
10	REBDROFLDS	RLRAAGE	TIVAJRLRAAGE	RLRAAGE	REF	C	CN
11	REBDROFLDS	RLRAFIXFITCATE	TIVAJRLRAFFCT	RLRAFIXFITCATE	REF	C	CN
12	REBDROFLDS	RLRALABEL	TIVAJRLRALABEL	RLRALABEL	REF	C	CN
13	REBDROFLDS	RLRALOC	TIVAJRLRALOC	RLRALOC	REF	C	CN
14	REBDROFLDS	RLRASIZ	TIVAJRLRASIZ	RLRASIZ	REF	C	CN
15	REBDROFLDS	RPROZGRD	TIV43	RPROZGRD	KEY	1	CN
16	REBDROFLDS	SGEBT	TIV12	SGEBT	KEY	1	CN
17	REBDROFLDS	SNUNR	TIV01	SNUNR	REF	1	CN
18	REBDROFLDS	SSTCKBIS	TIV37	SSTOCKW	KEY	1	C
19	REBDROFLDS	SSTOCKW	TIV37	SSTOCKW	KEY	1	C
20	REBDROFLDS	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
21	REBDROFLDS	VPTCURRENCY	TCURC	WAERS

History

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