SAP ABAP Table VVIOB02 (Property change structure)

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	VVIOB02	Table Relationship Diagram
Short Description	Property change structure

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	Property master data
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	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
6	XGRTXT	☐	XGRTXT	XLBEZ	CHAR	60	0	Text for property
7	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	VIGBUCH
8	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
9	BDMQMB1	☐	BDMQMB1	WRTV7	CURR	13	2	Market value
10	BDMQMB2	☐	BDMQMB2	WRTV7	CURR	13	2	Purchase price
11	BDNRWERT	☐	BDNRWERT	WRTV7	CURR	13	2	Land reference value for determining current market value
12	BDNWERT	☐	BDNWERT	WRTV7	CURR	13	2	Land value for determining current market value
13	DBDNWERT	☐	DBDNWERT	DDAT	DATS	8	0	Date of land value
14	RBEPLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
15	DBEPLAN	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
16	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
17	NZGRZ	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
18	NZGFZ	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
19	NZBMZ	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
20	NTGRZ	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
21	NTGFZ	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
22	NTBMZ	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
23	JVORKAUF	☐	JVORKAUF	JANEI	CHAR	1	0	Preemptive right indicator
24	JAUSNAHM	☐	JAUSNAHM	JANEI	CHAR	1	0	Special licence indicator
25	JGRUNDW	☐	JGRUNDW	JANEI	CHAR	1	0	Ground water indicator
26	JUEBERS	☐	JUEBERS	JANEI	CHAR	1	0	Danger of flooding indicator
27	RARTOPT	☐	RARTOPT	RARTOPT	NUMC	1	0	Option rate calculation type
28	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
29	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
30	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
31	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
32	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
33	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
34	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
35	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
36	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
37	DAKTBEST	☐	DAKTBEST	DATUM	DATS	8	0	Date active in portfolio
38	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	SANO1
39	RNBPLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan	TIVB3
40	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
41	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
42	J_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
43	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
44	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
45	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
46	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
47	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
48	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
49	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
50	DVERKAUF	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
51	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
52	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
53	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
54	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
55	DVRKPLAN	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
56	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
57	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
58	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
59	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
60	XGEMARK	☐	VVGEMARK	VVGEMARK	CHAR	12	0	Local Subdistrict	TIVG2
61	NFLURNR	☐	NFLURNR	NFLURNR	CHAR	6	0	Number of Tract of Land in Land Register
62	XFLURST	☐	XFLURST	TEXT10	CHAR	10	0	Parcel of Land
63	BRFLURST	☐	VVBRFLURST	VVBRFLURST	CHAR	4	0	Fractional Parcel of Land
64	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
65	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
66	ZULBAUH	☐	VVZULBAUH	VVZULBAUH	QUAN	4	0	Permitted building height
67	LEINS	☐	VVLEINS	MEINS	UNIT	3	0	Unit of length	*
68	.INCLUDE	☐				0	0
69	.INCLU--AP	☐				0	0	OBSOLETE: Property: Append Fields
70	.INCLUDE	☐				0	0	OBSOLETE: Property: Append Fields
71	.INCLUDE	☐				0	0	OBSOLETE: Shared Master Data Fields: Append Fields
72	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
73	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
74	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
75	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
76	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*
77	.INCLUDE	☐				0	0	Structures for generating change document update programs
78	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	VVIOB02	ADRNR	SANO1	OBJNR
2	VVIOB02	BUKRS	T001	BUKRS
3	VVIOB02	GEMEINDE	TIVG1	GEMEINDE	KEY	1	CN
4	VVIOB02	GSBER	TGSB	GSBER	REF	1	CN
5	VVIOB02	JERBBAU	TDO9	SOBJERBBAU
6	VVIOB02	J_OBJNR	ONR00	OBJNR
7	VVIOB02	KOKRS	TKA01	KOKRS
8	VVIOB02	PRCTR	CEPC	PRCTR
9	VVIOB02	PROFL	TKB1A	APROF
10	VVIOB02	RGRNART	TIVC4	RGRNART	KEY	1	CN
11	VVIOB02	RNBPLAN	TIVB3	RNBPLAN		1	CN
12	VVIOB02	SGRART	TIV56	SGRART
13	VVIOB02	SGRFRM	TIV58	SGRFRM
14	VVIOB02	SGRGZS	TIV59	SGRGZS
15	VVIOB02	SGRQAL	TIV57	SGRQAL
16	VVIOB02	SGRUNDB	VIGBUCH	SGRUNDB
17	VVIOB02	SUNUTZA	TIV36	SUNART
18	VVIOB02	SWENR	VIOB01	SWENR
19	VVIOB02	XGEMARK	TIVG2	GEMARK

History

Last changed by/on	SAP	20110901
SAP Release Created in