SAP ABAP View V_RENTAL_OBJSP (Rental Object With Criteria From Superior Tables)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_LD_LD (Package) RE: Logical Databases

Basic Data

View Type	D	Database View
Database View	V_RENTAL_OBJSP
Short Description	Rental Object With Criteria From Superior Tables
Root table	VIBDRO	Rental Object

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VIBDRO	VIBDRO
2	VIBDBE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VIBDBE	MANDT	JL	EQ				0	0
2	VIBDRO	MANDT	JR	EQ			AND	0	0
3	VIBDBE	BUKRS	JL	EQ				0	0
4	VIBDRO	BUKRS	JR	EQ			AND	0	0
5	VIBDBE	SWENR	JL	EQ				0	0
6	VIBDRO	SWENR	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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