SAP ABAP View V_VIMIMV_VIOB01 (RE: View With Inner Join to BE <- LO)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

View Type	D	Database View
Database View	V_VIMIMV_VIOB01
Short Description	RE: View With Inner Join to BE <- LO
Root table	VIMIMV	Lease-Out

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VIMIMV	VIMIMV
2	VIOB01

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VIMIMV	MANDT		☐	MANDT	☐	Client
2	MVINTRENO	VIMIMV	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
3	BUKRS	VIMIMV	BUKRS		☐	BUKRS	☐	Company Code
4	SMIVE	VIMIMV	SMIVE		☐	SMIVE	☐	Lease-Out Number
5	SWENR	VIMIMV	SWENR		☐	SWENR	☐	Business Entity Number
6	SMENR	VIMIMV	SMENR		☐	SMENR	☐	Number of Rental Unit
7	*	VIOB01	*		☐		☐
8	-	VIOB01	MANDT		☐	MANDT	☐	Client
9	-	VIOB01	BUKRS		☐	BUKRS	☐	Company Code
10	-	VIOB01	SWENR		☐	SWENR	☐	Business Entity Number
11	GSBER	VIOB01	GSBER		☐	GSBER	☐	Business Area
12	SINSTBEZ	VIOB01	SINSTBEZ		☐	SINSTBEZ	☐	Maintenance district
13	SVERKEHR	VIOB01	SVERKEHR		☐	SVERKEHR	☐	Transport Connections of Business Entity
14	XWETEXT	VIOB01	XWETEXT		☐	XWETEXT	☐	Business entity identification
15	SLAGEWE	VIOB01	SLAGEWE		☐	SLAGEWE	☐	Business entity location number
16	RKZBEST	VIOB01	RKZBEST		☐	RKZBEST	☐	Object status
17	SOBJLAGE	VIOB01	SOBJLAGE		☐	RESOBJLAGE	☐	Indicator: District Location of Object
18	SMIETSP	VIOB01	SMIETSP		☐	SMIETSP	☐	Representative list of rents assignment
19	RARTOPT	VIOB01	RARTOPT		☐	RARTOPT	☐	Option rate calculation type
20	WAERS	VIOB01	WAERS		☐	WAERS	☐	Currency Key
21	FEINS	VIOB01	FEINS		☐	FEINS	☐	Area unit
22	REINS	VIOB01	REINS		☐	REINS	☐	Unit for cubic volume
23	JLOESCH	VIOB01	JLOESCH		☐	JLOESCH	☐	Real Estate Deletion Indicator/Flag
24	NUMKIGR	VIOB01	NUMKIGR		☐	NUMKIGR	☐	Internal number range for property
25	NUMKIGE	VIOB01	NUMKIGE		☐	NUMKIGE	☐	Building internal number range
26	NUMKIME	VIOB01	NUMKIME		☐	NUMKIME	☐	Internal number range for rental unit
27	RERF	VIOB01	RERF		☐	RERF	☐	Entered by
28	DERF	VIOB01	DERF		☐	DERF	☐	First Entered on
29	TERF	VIOB01	TERF		☐	TERF	☐	Time of Initial Entry
30	REHER	VIOB01	REHER		☐	REHER	☐	Source of initial entry
31	RBEAR	VIOB01	RBEAR		☐	RBEAR	☐	Employee ID
32	DBEAR	VIOB01	DBEAR		☐	DBEAR	☐	Last Edited on
33	TBEAR	VIOB01	TBEAR		☐	TBEAR	☐	Last Edited at
34	RBHER	VIOB01	RBHER		☐	RBHER	☐	Editing Source
35	SMIETR	VIOB01	SMIETR		☐	SMIETR	☐	Tenancy law
36	VORBK	VIOB01	VORBK		☐	VORBK	☐	Predefined operating costs settlement variant
37	VORHK	VIOB01	VORHK		☐	VORHK	☐	Predefined heating expenses settlement variant
38	DAKTBEST	VIOB01	DAKTBEST		☐	DAKTBEST	☐	Date active in portfolio
39	ANLN1	VIOB01	ANLN1		☐	ANLN1	☐	Main Asset Number
40	IMKEY	VIOB01	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
41	VVLEN	VIOB01	VVLEN		☐	VVLEN	☐	Unit of length
42	KOSTL	VIOB01	KOSTL		☐	KOSTL	☐	Cost Center
43	J_OBJNR	VIOB01	J_OBJNR		☐	J_OBJNR	☐	Object number
44	RFAKT	VIOB01	RFAKT		☐	VVRFAKT	☐	Conversion factor for fractional share of property
45	PRCTR	VIOB01	PRCTR		☐	PRCTR	☐	Profit Center
46	ADRNR	VIOB01	ADRNR		☐	SOBJNR	☐	Object number (virtual object)
47	SSTDORT	VIOB01	SSTDORT		☐	VVSSTDORT	☐	Regional location
48	PROFL	VIOB01	PROFL		☐	VVAPROF	☐	Settlement profile for costs
49	KOKRS	VIOB01	KOKRS		☐	KOKRS	☐	Controlling Area
50	PROFIL	VIOB01	PROFIL		☐	VVPROFIL	☐	Planning profile for Real Estate objects
51	INTRENO	VIOB01	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
52	TXJCD	VIOB01	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
53	BERGRP	VIOB01	BERGRP		☐	VVBERGRP	☐	Authorization group
54	XNOTPL	VIOB01	XNOTPL		☐	VVXNOTPL	☐	No automatic creation of functional location allowed
55	HOCONTR	VIOB01	HOCONTR		☐	REHOCONTR	☐	WEG-Verwaltung: Wirtschaftseinheit ist WEG verwaltet
56	VALIDFROM	VIOB01	VALIDFROM		☐	REBDOBJVALIDFROM	☐	Date: Object Valid From
57	VALIDTO	VIOB01	VALIDTO		☐	REBDOBJVALIDTO	☐	Date: Object Valid To
58	CREATIONTYPE	VIOB01	CREATIONTYPE		☐	RECACREATIONTYPE	☐	How the Object Was Created
59	RESPONSIBLE	VIOB01	RESPONSIBLE		☐	RECARESPONSIBLE	☐	Person Responsible
60	USEREXCLUSIVE	VIOB01	USEREXCLUSIVE		☐	RECAUSEREXCLUSIVE	☐	User with Exclusive Change Authorization

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	20110901
SAP Release Created in