SAP ABAP Table VIGW_R_VIOB03 (Immobilien gew.: Struktur Reporting Gebäude)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-MI (Application Component) Migration
     ⤷ RE_MI_CR (Package) RE: Migration CRE (Data Dictionary Only)

Basic Data

Table Category	INTTAB	Structure
Structure	VIGW_R_VIOB03	Table Relationship Diagram
Short Description	Immobilien gew.: Struktur Reporting Gebäude

Delivery and Maintenance

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIGW_R_VIOB03	GSBER	TGSB	GSBER
2	VIGW_R_VIOB03	JERBBAU	TDO9	SOBJERBBAU
3	VIGW_R_VIOB03	KOKRS	TKA01	KOKRS
4	VIGW_R_VIOB03	PRCTR	CEPC	PRCTR	KEY	1	CN
5	VIGW_R_VIOB03	PROFL	TKB1A	APROF
6	VIGW_R_VIOB03	RDAZUST	TIV83	RZUSTAND
7	VIGW_R_VIOB03	RFAZUST	TIV83	RZUSTAND
8	VIGW_R_VIOB03	RGEBART	TIV5A	SOBJART
9	VIGW_R_VIOB03	RGEBZUST	TIV83	RZUSTAND
10	VIGW_R_VIOB03	SLAGK	TIV22	SLAGK	KEY	1	CN
11	VIGW_R_VIOB03	SUNUTZA	TIV36	SUNART

History

Last changed by/on	SAP	20110901
SAP Release Created in