SAP ABAP Table VIGW_R_VIOB03F (Immobilien gew.: Reporting Gebäude Stichtag)

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_VIOB03F	Table Relationship Diagram
Short Description	Immobilien gew.: Reporting Gebäude Stichtag

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

History

Last changed by/on	SAP	20110901
SAP Release Created in