SAP ABAP Table VIOB03 (Real estate building master)

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

Table Category	TRANSP	Transparent table
Transparent table	VIOB03	Table Relationship Diagram
Short Description	Real estate building master

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
4	SGENR	☑	SGENR	SGENR	CHAR	8	0	Building Number
5	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	SANO1
6	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
7	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
8	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
9	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
10	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
11	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
12	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
13	BBAUW13	☐	BBAUW13	WRBTR	CURR	11	2	Building value
14	BBAUWAKT	☐	BBAUWAKT	WRBTR	CURR	11	2	Current building value
15	BBETRIEB	☐	BBETRIEB	WRBTR	CURR	11	2	Production equipment value
16	BAUSSEN	☐	BAUSSEN	WRBTR	CURR	11	2	Grounds value
17	BSCHADEN	☐	BSCHADEN	WRBTR	CURR	11	2	Structural damage value
18	BREPSTAU	☐	BREPSTAU	WRBTR	CURR	11	2	Value of repair backlog
19	BDMCBMRA	☐	BDMCBMRA	WRBTR	CURR	11	2	Amount per volume unit
20	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
21	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
22	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
23	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
24	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
25	FDACHFL	☐	FDACHFL	DEC6_2	DEC	8	2	Attic space
26	RDAZUST	☐	RDAZUST	VVRZUSTAND	NUMC	2	0	Condition of roof	TIV83
27	RFAZUST	☐	RFAZUST	VVRZUSTAND	NUMC	2	0	Condition of facade	TIV83
28	BUBRA	☐	BUBRA	DEC8_3	DEC	11	3	Cubic Volume
29	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
30	AGESCH	☐	AGESCH	DEC2_1	DEC	3	1	Dummy, since replaced: Number of floors
31	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
32	RARTOPT	☐	RARTOPT	RARTOPT	NUMC	1	0	Option rate calculation type
33	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
34	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
35	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
36	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
37	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
38	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
39	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
40	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
41	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
42	DAKTBEST	☐	DAKTBEST	DATUM	DATS	8	0	Date active in portfolio
43	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
44	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
45	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
46	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
47	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	*
48	XGETXT	☐	XGETXT	XLBEZ	CHAR	60	0	Building text
49	BEINHEITW	☐	BEINHEITW	WRBTR	CURR	11	2	Assessed value of building
50	NEINHEITW	☐	NEINHEITW	GJAHR	NUMC	4	0	Assessed value base year
51	BVERSWRT	☐	BVERSWRT	WRBTR	CURR	11	2	Insurable value amount
52	RVERSWRT	☐	RVERSWRT	RVERSWRT	NUMC	1	0	Type of insurance value
53	SLAGK	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
54	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
55	J_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
56	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
57	JNURJAHR	☐	VVJNURJ	JANE	CHAR	1	0	Indicator: Only regard construction date in terms of years
58	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
59	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
60	DVERKAUF	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
61	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
62	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
63	PROFL	☐	APROF	APROF	CHAR	6	0	Settlement profile	TKB1A
64	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
65	DVRKPLAN	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
66	DNUTZEND	☐	VVDNUTZEND	DATUM	DATS	8	0	End of usage
67	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
68	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
69	NSTCKLFT	☐	VVNSTCKLFT	NUMC3	NUMC	3	0	Number of highest floor reached by elevator
70	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
71	RPGENR	☐	VVRPGENR	SGENR	CHAR	8	0	Building no. of hierarchical superior building part	*
72	JANLHIE	☐	VVJANLHIE	JANE	CHAR	1	0	Indicator: Asset allocation valid for subordin. building
73	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	*
74	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	*
75	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
76	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
77	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
78	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
79	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
80	.INCLUDE	☐				0	0
81	.INCLU--AP	☐				0	0	OBSOLETE: Building: Append Fields
82	.INCLUDE	☐				0	0	OBSOLETE: Building: Append Fields
83	.INCLUDE	☐				0	0	OBSOLETE: Shared Master Data Fields: Append Fields
84	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
85	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
86	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
87	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
88	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIOB03	ADRNR	SANO1	OBJNR	KEY	1	C
2	VIOB03	BUKRS	T001	BUKRS	KEY	1	CN
3	VIOB03	GEMEINDE	TIVG1	GEMEINDE
4	VIOB03	GSBER	TGSB	GSBER	KEY	1	CN
5	VIOB03	JERBBAU	TDO9	SOBJERBBAU
6	VIOB03	J_OBJNR	ONR00	OBJNR	KEY	1	CN
7	VIOB03	KOKRS	TKA01	KOKRS	REF	C	CN
8	VIOB03	PRCTR	CEPC	PRCTR	KEY	1	CN
9	VIOB03	PROFL	TKB1A	APROF	REF	C	CN
10	VIOB03	RDAZUST	TIV83	RZUSTAND
11	VIOB03	RFAZUST	TIV83	RZUSTAND
12	VIOB03	RGEBART	TIV5A	SOBJART	KEY	1	CN
13	VIOB03	RGEBZUST	TIV83	RZUSTAND
14	VIOB03	SLAGK	TIV22	SLAGK	KEY	1	CN
15	VIOB03	SUNUTZA	TIV36	SUNART	KEY	1	CN
16	VIOB03	SWENR	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in