SAP ABAP Table REBD_MAINOBJECTS (Screen Structure for Rental Object Assignment (Main Objects))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_XX (Package) RE: Obsolete Objects (Do Not Delete!!!)

Basic Data

Table Category	INTTAB	Structure
Structure	REBD_MAINOBJECTS	Table Relationship Diagram
Short Description	Screen Structure for Rental Object Assignment (Main Objects)

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	Assignment Table for Real Estate to Standard Objects
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	FOR_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
4	DATGAB	☐	DGULTAB	DDAT	DATS	8	0	Date from when assignment is valid
5	RE_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
6	DATBIS	☐	DGULTBIS	DDAT	DATS	8	0	Date up to when the assignment is valid
7	NO_DISPLAY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
8	SPEZ_OBART	☐	J_OBART	J_OBART	CHAR	2	0	Object Type	*
9	.INCLU--AP	☐				0	0	OBSOLETE: Assignment RE to Standard Obj: Append Fields
10	ASSIGNONLYINFO	☐	REBDASSIGNONLYINFO	RECABOOL	CHAR	1	0	Informational Assignment
11	FOR_OBJNR_ARCH	☐	REBDFOR_OBJNR_ARCHIVED	RECABOOL	CHAR	1	0	OBSOLETE: Source Object Was Archived
12	.INCLUDE	☐				0	0	Rental Object: Key Fields
13	.INCLUDE	☐				0	0	Rental Object: Key Fields
14	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
15	SWENR	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
16	SMENR	☐	REBDRONO	REBDRONO	CHAR	8	0	Number of Rental Object
17	.INCLUDE	☐				0	0	Rental Object: Non-Key Fields
18	.INCLUDE	☐				0	0	Rental Object: Non-Key Fields
19	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
20	IMKEY	☐	RECAIMKEY	IMKEY	CHAR	8	0	Internal Key of Real Estate Object (FI)
21	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
22	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
23	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
24	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
25	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
26	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
27	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
28	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
29	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
30	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
31	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
32	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
33	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
34	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
35	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
36	ROTYPE	☐	REBDROTYPE	REBDROTYPE	CHAR	2	0	Rental Object Type
37	SNUNR	☐	REBDUSAGETYPE	SNUNR	NUMC	4	0	Usage Type of Rental Object	TIV01
38	XMETXT	☐	REBDXRO	RECAXLDESCRIPTION	CHAR	60	0	Rental Object Name
39	SGRNR	☐	REBDPRNO	REBDPRNO	CHAR	8	0	Number of Land	*
40	SGENR	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building	*
41	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
42	CANBECOMMON	☐	REBDCANBECOMMON	RECABOOL	CHAR	1	0	Common Usage Possible
43	FIRSTPOSTING	☐	RECDCFSTARTFROM	RECADATE	DATS	8	0	Cash Flow Generated Starting On
44	DBEZU	☐	DBEZU	DDAT	DATS	8	0	Date of initial usage
45	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
46	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
47	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
48	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	*
49	RLRAFIXFITCATE	☐	REAJRLRAFIXFITCATE	REAJRLRAFIXFITCATE	CHAR	6	0	Fixtures and Fittings Category	TIVAJRLRAFFCT
50	RLRALOC	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	TIVAJRLRALOC
51	PZUABSP	☐	REBDSUREPERCENT	REBDSUREPERCENT	DEC	4	2	Increase or Reduction for Representative List of Rents
52	SPOSINMSP	☐	REBDRLRABASEIND	REAJRLRAADJMBASE	CHAR	1	0	Method for Calculating Base Rent of Rep. List of Rents
53	PPOSINMSP	☐	REBDRLRAPERCENT	DECV3_2	DEC	5	2	Percentage for Positioning RU in RLR Spread
54	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
55	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase	*
56	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	*
57	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
58	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
59	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	*
60	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	*
61	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
62	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
63	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
64	CFPOSTINGFROM	☐	RECDCFPOSTINGFROM	RECADATE	DATS	8	0	First Posting From
65	HASCOP	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
66	RLRA	☐	REAJRLRA	REAJRLRA	CHAR	6	0	Representative List of Rents	TIVAJRLRA
67	USESRLRA	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
68	BUILDYEAR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
69	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
70	COMMONOWNED	☐	REBDCOMMONOWNED	RECABOOL	CHAR	1	0	Rental Object Is Common Property
71	OOLOCK	☐	REOROOLOCK	RECABOOL	CHAR	1	0	Do Not Consider Object for Real Estate Search
72	NEIGHBORH1	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
73	NEIGHBORH2	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
74	NEIGHBORH3	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
75	.INCLUDE	☐				0	0
76	.INCLU--AP	☐				0	0	Country Specific fields for Switzerland
77	.INCLUDE	☐				0	0	Rental Object Customer fields
78	EDID	☐	REXCCHEDID	REXCCHEDID	NUMC	2	0	Federal Building Entrance Identification Number (EDID)
79	EGID	☐	REXCCHEGID	REXCCHEGID	NUMC	9	0	Federal Building Identification Number (EGID)
80	FLOOR	☐	REXCCHROFLOOR	REXCCHROFLOOR	NUMC	4	0	Code of Floor	*
81	FLOORLOC	☐	REXCCHROFLOORLOC	REXCCHROFLOORLOC	CHAR	40	0	Location of Dwelling on a Floor
82	EWID	☐	REXCCHEWID	REXCCHEWID	NUMC	3	0	Federal Dwelling Identification Number (EWID)
83	KITCHEN	☐	REXCCHROKITCHEN	REXCCHROKITCHEN	NUMC	4	0	Code of Cooking Facilities	*
84	ADMINNO	☐	REXCCHROADMINNO	REXCCHROADMINNO	CHAR	12	0	Administrative Dwelling Number
85	DOORNO	☐	REXCCHRODOORNO	REXCCHRODOORNO	CHAR	8	0	Door Number of Dwelling
86	OBJCOND	☐	REXCCHROCOND	REXCCHROCOND	NUMC	4	0	Code of Dwelling Status	*
87	YEARDECONSTR	☐	REXCCHBUDECONYEAR	DATUM	DATS	8	0	Year of Demolition
88	NUMROOMS	☐	REXCCHRONUMROOMS	REXCCHRONUMROOMS	NUMC	4	0	Number of Rooms in the Dwelling
89	LIVINGAREA	☐	REXCCHROAREA	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Floor Area of Dwelling in M2
90	USAGETYPE	☐	REXCCHROUSAGETYPE	REXCCHROUSAGETYPE	NUMC	4	0	Code of Usage Type	*
91	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
92	.INCLU--AP	☐				0	0	Country-Specific fields for Portugal
93	.INCLUDE	☐				0	0	Country-Specific Fields for Portugal - Rental Object
94	VPT	☐	REXCPTVPT_NOSIGN	REXCPTVPT_NOSIGN	CURR	15	2	Property Taxable Value
95	VPTCURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
96	CONDK	☐	REXCPTRACONS		CHAR	4	0	Conservation Level	TIVXCPTRACONS
97	BUKRSTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
98	XWETEXT	☐	REBDXBE	RECAXLDESCRIPTION	CHAR	60	0	Business Entity Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REBD_MAINOBJECTS	CONDK	TIVXCPTRACONS	CONSLEVEL
2	REBD_MAINOBJECTS	CURRENCY	TCURC	WAERS	KEY	1	CN
3	REBD_MAINOBJECTS	NEIGHBORH1	TIVBDNEIGHBORH	NEIGHBORHOOD
4	REBD_MAINOBJECTS	NEIGHBORH2	TIVBDNEIGHBORH	NEIGHBORHOOD
5	REBD_MAINOBJECTS	NEIGHBORH3	TIVBDNEIGHBORH	NEIGHBORHOOD
6	REBD_MAINOBJECTS	RESPONSIBLE	USR02	BNAME	REF	1	CN
7	REBD_MAINOBJECTS	RLRA	TIVAJRLRA	RLRA	KEY	1	CN
8	REBD_MAINOBJECTS	RLRAFIXFITCATE	TIVAJRLRAFFCT	RLRAFIXFITCATE	REF	C	CN
9	REBD_MAINOBJECTS	RLRALOC	TIVAJRLRALOC	RLRALOC	REF	C	CN
10	REBD_MAINOBJECTS	SNUNR	TIV01	SNUNR
11	REBD_MAINOBJECTS	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
12	REBD_MAINOBJECTS	VPTCURRENCY	TCURC	WAERS

History

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