SAP ABAP Table VVIOB03 (Change documents buildings)

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	INTTAB	Structure
Structure	VVIOB03	Table Relationship Diagram
Short Description	Change documents buildings

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	.INCLUDE	☐				0	0	Real estate building master
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
5	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
6	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	SANO1
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	ONR00
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	*
79	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
80	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
81	.INCLUDE	☐				0	0
82	.INCLU--AP	☐				0	0	OBSOLETE: Building: Append Fields
83	.INCLUDE	☐				0	0	OBSOLETE: Building: Append Fields
84	.INCLUDE	☐				0	0	OBSOLETE: Shared Master Data Fields: Append Fields
85	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
86	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
87	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
88	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
89	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*
90	.INCLUDE	☐				0	0	Structures for generating change document update programs
91	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in