SAP ABAP Table RVIOB02_ZS (RE: Property - Master Data and Additional Fields)

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	RVIOB02_ZS	Table Relationship Diagram
Short Description	RE: Property - Master Data and Additional Fields

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	XFLNART	☐	XFLNART	AS4TEXT	CHAR	60	0	Description of usage type of property acc. to land use map
78	RNBPLANKBZ	☐	RNBPLANKBZ	XKBEZ	CHAR	15	0	Short description usage type acc. to development plan
79	RNBPLANMBZ	☐	RNBPLANMBZ	XMBEZ	CHAR	30	0	Description of usage type according to development plan
80	XGRART	☐	VVXGRART	VVXTEXT20	CHAR	20	0	Property type
81	XGRQAL	☐	VVXGRQAL	VVXTEXT20	CHAR	20	0	Quality of property location
82	XGRFRM	☐	VVXGRFRM	VVXTEXT20	CHAR	20	0	Text: Ground type of property
83	XGRGZS	☐	VVXGRGZS	VVXTEXT20	CHAR	20	0	Text about property overall condition
84	XUNART	☐	VVXUNART	XTEXT35	CHAR	35	0	Main usage type
85	.INCLUDE	☐				0	0	Amounts from VIOB02 in second currency
86	SWHRKNDCUK	☐	SWHRKNDCUK	WAERS	CUKY	5	0	Second Currency for Correspondence	*
87	BDMQMB1CUK	☐	BDMQMB1CUK	WRTV7	CURR	13	2	Market value in second currency
88	BDMQMB2CUK	☐	BDMQMB2CUK	WRTV7	CURR	13	2	Purchase price in second currency
89	BDNRWRTCUK	☐	BDNRWRTCUK	WRTV7	CURR	13	2	Land ref.value for market value determination in 2nd curr.
90	BDNWERTCUK	☐	BDNWERTCUK	WRTV7	CURR	13	2	Land value for market value determination in 2nd currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RVIOB02_ZS	ADRNR	SANO1	OBJNR	KEY	1	C
2	RVIOB02_ZS	BUKRS	T001	BUKRS	KEY	1	CN
3	RVIOB02_ZS	GEMEINDE	TIVG1	GEMEINDE	KEY	1	CN
4	RVIOB02_ZS	GSBER	TGSB	GSBER	REF	1	CN
5	RVIOB02_ZS	JERBBAU	TDO9	SOBJERBBAU
6	RVIOB02_ZS	J_OBJNR	ONR00	OBJNR	KEY	1	CN
7	RVIOB02_ZS	KOKRS	TKA01	KOKRS	REF	C	CN
8	RVIOB02_ZS	PRCTR	CEPC	PRCTR	KEY	1	CN
9	RVIOB02_ZS	PROFL	TKB1A	APROF	REF	C	CN
10	RVIOB02_ZS	RGRNART	TIVC4	RGRNART	KEY	1	CN
11	RVIOB02_ZS	RNBPLAN	TIVB3	RNBPLAN		1	CN
12	RVIOB02_ZS	SGRART	TIV56	SGRART	KEY	1	CN
13	RVIOB02_ZS	SGRFRM	TIV58	SGRFRM	KEY	1	CN
14	RVIOB02_ZS	SGRGZS	TIV59	SGRGZS	KEY	1	CN
15	RVIOB02_ZS	SGRQAL	TIV57	SGRQAL	KEY	1	CN
16	RVIOB02_ZS	SGRUNDB	VIGBUCH	SGRUNDB	KEY	1	CN
17	RVIOB02_ZS	SUNUTZA	TIV36	SUNART	KEY	1	CN
18	RVIOB02_ZS	SWENR	VIOB01	SWENR	KEY	1	CN
19	RVIOB02_ZS	XGEMARK	TIVG2	GEMARK

History

Last changed by/on	SAP	20110901
SAP Release Created in