SAP ABAP View U_22511 (Building)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ RE (Application Component) Real Estate Management
     ⤷ U134 (Package) Data model RE real estate

Basic Data

View Type	D	Database View
Database View	U_22511
Short Description	Building
Root table	VIOB03	Real estate building master

Entity Type	DM02L
Short text	Building

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

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	ADRNR	VIOB03	ADRNR		☐	SOBJNR	☐	Object number (virtual object)
6	RGEBART	VIOB03	RGEBART		☐	RGEBART	☐	Type of building
7	JERBBAU	VIOB03	JERBBAU		☐	JERBBAU	☐	Heritable building right indicator
8	RGEBZUST	VIOB03	RGEBZUST		☐	RGEBZUST	☐	General condition of building
9	YBAUJAHR	VIOB03	YBAUJAHR		☐	VVYBAUJAHR	☐	ConstYr
10	YMODERN	VIOB03	YMODERN		☐	VVYMODERN	☐	Year of modernization
11	YAUFBAU	VIOB03	YAUFBAU		☐	VVYAUFBAU	☐	Year of reconstruction
12	DBAUBEGI	VIOB03	DBAUBEGI		☐	DBAUBEGI	☐	Construction start date
13	BBAUW13	VIOB03	BBAUW13		☐	BBAUW13	☐	Building value
14	BBAUWAKT	VIOB03	BBAUWAKT		☐	BBAUWAKT	☐	Current building value
15	BBETRIEB	VIOB03	BBETRIEB		☐	BBETRIEB	☐	Production equipment value
16	BAUSSEN	VIOB03	BAUSSEN		☐	BAUSSEN	☐	Grounds value
17	BSCHADEN	VIOB03	BSCHADEN		☐	BSCHADEN	☐	Structural damage value
18	BREPSTAU	VIOB03	BREPSTAU		☐	BREPSTAU	☐	Value of repair backlog
19	BDMCBMRA	VIOB03	BDMCBMRA		☐	BDMCBMRA	☐	Amount per volume unit
20	DBAUGENE	VIOB03	DBAUGENE		☐	DBAUGENE	☐	Building permit
21	XBAUGENE	VIOB03	XBAUGENE		☐	XBAUGENE	☐	Note on building permit
22	DBEZUGSF	VIOB03	DBEZUGSF		☐	DBEZUGSF	☐	Ready for occupancy
23	DFERTIG	VIOB03	DFERTIG		☐	DFERTIG	☐	Completion
24	DSCHLUSS	VIOB03	DSCHLUSS		☐	DSCHLUSS	☐	Final Inspection
25	FDACHFL	VIOB03	FDACHFL		☐	FDACHFL	☐	Attic space
26	RDAZUST	VIOB03	RDAZUST		☐	RDAZUST	☐	Condition of roof
27	RFAZUST	VIOB03	RFAZUST		☐	RFAZUST	☐	Condition of facade
28	BUBRA	VIOB03	BUBRA		☐	BUBRA	☐	Cubic Volume
29	JDENKMAL	VIOB03	JDENKMAL		☐	JDENKMAL	☐	Protection of Historical Sites
30	AGESCH	VIOB03	AGESCH		☐	AGESCH	☐	Dummy, since replaced: Number of floors
31	AUGESCH	VIOB03	AUGESCH		☐	AUGESCH	☐	Number of basements
32	RARTOPT	VIOB03	RARTOPT		☐	RARTOPT	☐	Option rate calculation type
33	JLOESCH	VIOB03	JLOESCH		☐	JLOESCH	☐	Real Estate Deletion Indicator/Flag
34	RERF	VIOB03	RERF		☐	RERF	☐	Entered by
35	DERF	VIOB03	DERF		☐	DERF	☐	First Entered on
36	TERF	VIOB03	TERF		☐	TERF	☐	Time of Initial Entry
37	REHER	VIOB03	REHER		☐	REHER	☐	Source of initial entry
38	RBEAR	VIOB03	RBEAR		☐	RBEAR	☐	Employee ID
39	DBEAR	VIOB03	DBEAR		☐	DBEAR	☐	Last Edited on
40	TBEAR	VIOB03	TBEAR		☐	TBEAR	☐	Last Edited at
41	RBHER	VIOB03	RBHER		☐	RBHER	☐	Editing Source
42	DAKTBEST	VIOB03	DAKTBEST		☐	DAKTBEST	☐	Date active in portfolio
43	IMKEY	VIOB03	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
44	DBAUVOR	VIOB03	DBAUVOR		☐	DBAUVOR	☐	Date of planning inquiry
45	DVORBES	VIOB03	DVORBES		☐	DVORBES	☐	Date of prior notice
46	DANTBAU	VIOB03	DANTBAU		☐	DANTBAU	☐	Application for building permit
47	SGRUNDB	VIOB03	SGRUNDB		☐	SGRUNDB	☐	Land register number
48	XGETXT	VIOB03	XGETXT		☐	XGETXT	☐	Building text
49	BEINHEITW	VIOB03	BEINHEITW		☐	BEINHEITW	☐	Assessed value of building
50	NEINHEITW	VIOB03	NEINHEITW		☐	NEINHEITW	☐	Assessed value base year
51	BVERSWRT	VIOB03	BVERSWRT		☐	BVERSWRT	☐	Insurable value amount
52	RVERSWRT	VIOB03	RVERSWRT		☐	RVERSWRT	☐	Type of insurance value
53	SLAGK	VIOB03	SLAGK		☐	SLAGK	☐	Location class
54	KOSTL	VIOB03	KOSTL		☐	KOSTL	☐	Cost Center
55	J_OBJNR	VIOB03	J_OBJNR		☐	J_OBJNR	☐	Object number
56	RFAKT	VIOB03	RFAKT		☐	VVRFAKT	☐	Conversion factor for fractional share of property
57	JNURJAHR	VIOB03	JNURJAHR		☐	VVJNURJ	☐	Indicator: Only regard construction date in terms of years
58	PRCTR	VIOB03	PRCTR		☐	PRCTR	☐	Profit Center
59	DWIRTUB	VIOB03	DWIRTUB		☐	VVDWIRTUB	☐	Transfer usage / charges
60	DVERKAUF	VIOB03	DVERKAUF		☐	VVDVERKAUF	☐	Sale date
61	SUNUTZA	VIOB03	SUNUTZA		☐	VVSUNART	☐	Main usage type
62	JUNUTZA	VIOB03	JUNUTZA		☐	VVJUNUTZA	☐	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
63	PROFL	VIOB03	PROFL		☐	APROF	☐	Settlement profile
64	KOKRS	VIOB03	KOKRS		☐	KOKRS	☐	Controlling Area
65	DVRKPLAN	VIOB03	DVRKPLAN		☐	VVDVRKPLAN	☐	Planned sale
66	DNUTZEND	VIOB03	DNUTZEND		☐	VVDNUTZEND	☐	End of usage
67	DFRDVON	VIOB03	DFRDVON		☐	VVDFRDVON	☐	Public funding from
68	DFRDBIS	VIOB03	DFRDBIS		☐	VVDFRDBIS	☐	Public funding to
69	NSTCKLFT	VIOB03	NSTCKLFT		☐	VVNSTCKLFT	☐	Number of highest floor reached by elevator
70	BANZGE	VIOB03	BANZGE		☐	VVBANZGE	☐	Number of floors
71	RPGENR	VIOB03	RPGENR		☐	VVRPGENR	☐	Building no. of hierarchical superior building part
72	JANLHIE	VIOB03	JANLHIE		☐	VVJANLHIE	☐	Indicator: Asset allocation valid for subordin. building
73	SSTCKBIS	VIOB03	SSTCKBIS		☐	VVSTCKBIS	☐	Uppermost Floor of a Building
74	SLIFTBIS	VIOB03	SLIFTBIS		☐	VVLIFTBIS	☐	Elevator to Floor in Building
75	INTRENO	VIOB03	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
76	GSBER	VIOB03	GSBER		☐	GSBER	☐	Business Area

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