SAP ABAP Table V_RENTAL_OBJSP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_RENTAL_OBJSP	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	V_RENTAL_OBJSP	BE_RLRA	TIVAJRLRA	RLRA	REF	C	CN
2	V_RENTAL_OBJSP	BUKRS	T001	BUKRS	KEY	1	CN
3	V_RENTAL_OBJSP	CONDK	TIVXCPTRACONS	CONSLEVEL
4	V_RENTAL_OBJSP	CURRENCY	TCURC	WAERS	KEY	1	CN
5	V_RENTAL_OBJSP	NEIGHBORH1	TIVBDNEIGHBORH	NEIGHBORHOOD
6	V_RENTAL_OBJSP	NEIGHBORH2	TIVBDNEIGHBORH	NEIGHBORHOOD
7	V_RENTAL_OBJSP	NEIGHBORH3	TIVBDNEIGHBORH	NEIGHBORHOOD
8	V_RENTAL_OBJSP	RESPONSIBLE	USR02	BNAME	REF	1	CN
9	V_RENTAL_OBJSP	RLGESCH	TIV38	RLGESCH	REF	C	CN
10	V_RENTAL_OBJSP	RLRA	TIVAJRLRA	RLRA	KEY	1	CN
11	V_RENTAL_OBJSP	RLRAFIXFITCATE	TIVAJRLRAFFCT	RLRAFIXFITCATE	REF	C	CN
12	V_RENTAL_OBJSP	RLRALOC	TIVAJRLRALOC	RLRALOC	REF	C	CN
13	V_RENTAL_OBJSP	RPROZGRD	TIV43	RPROZGRD	KEY	1	CN
14	V_RENTAL_OBJSP	SGEBT	TIV12	SGEBT	REF	C	CN
15	V_RENTAL_OBJSP	SINSTBEZ	TIV16	SINSTBEZ	REF	C	CN
16	V_RENTAL_OBJSP	SLAGEWE	TIV10	SLAGEWE	REF	C	CN
17	V_RENTAL_OBJSP	SNUNR	TIV01	SNUNR
18	V_RENTAL_OBJSP	SOBJLAGE	TIV45	SOBJLAGE	REF	C	CN
19	V_RENTAL_OBJSP	SSTCKBIS	TIV37	SSTOCKW	REF	C	CN
20	V_RENTAL_OBJSP	SSTOCKW	TIV37	SSTOCKW	REF	C	CN
21	V_RENTAL_OBJSP	SVERKEHR	TIV44	SVERKEHR	REF	C	CN
22	V_RENTAL_OBJSP	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
23	V_RENTAL_OBJSP	VPTCURRENCY	TCURC	WAERS