SAP ABAP View V_VIOB03_VIOB01 (RE: View With Inner Join to BE <- BU)

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_VIOB03_VIOB01
Short Description	RE: View With Inner Join to BE <- BU
Root table	VIOB03	Real estate building master

Table

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

Join Conditions

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