SAP ABAP Table VIGW_R_VIOB02 (Immobilien gew.: Struktur Reporting Grundstücke)

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_VIOB02	Table Relationship Diagram
Short Description	Immobilien gew.: Struktur Reporting Grundstücke

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	XGRTXT	☐	XGRTXT	XLBEZ	CHAR	60	0	Text for property
2	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	VIGBUCH
3	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
4	BDMQMB1	☐	BDMQMB1	WRTV7	CURR	13	2	Market value
5	BDMQMB2	☐	BDMQMB2	WRTV7	CURR	13	2	Purchase price
6	BDNRWERT	☐	BDNRWERT	WRTV7	CURR	13	2	Land reference value for determining current market value
7	BDNWERT	☐	BDNWERT	WRTV7	CURR	13	2	Land value for determining current market value
8	DBDNWERT	☐	DBDNWERT	DDAT	DATS	8	0	Date of land value
9	RBEPLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
10	DBEPLAN	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
11	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
12	NZGRZ	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
13	NZGFZ	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
14	NZBMZ	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
15	NTGRZ	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
16	NTGFZ	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
17	NTBMZ	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
18	JVORKAUF	☐	JVORKAUF	JANEI	CHAR	1	0	Preemptive right indicator
19	JAUSNAHM	☐	JAUSNAHM	JANEI	CHAR	1	0	Special licence indicator
20	JGRUNDW	☐	JGRUNDW	JANEI	CHAR	1	0	Ground water indicator
21	JUEBERS	☐	JUEBERS	JANEI	CHAR	1	0	Danger of flooding indicator
22	RARTOPT	☐	RARTOPT	RARTOPT	NUMC	1	0	Option rate calculation type
23	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
24	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
25	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
26	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
27	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
28	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
29	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
30	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
31	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
32	DAKTBEST	☐	DAKTBEST	DATUM	DATS	8	0	Date active in portfolio
33	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	*
34	RNBPLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan	TIVB3
35	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
36	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
37	J_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
38	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
39	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
40	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
41	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
42	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
43	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
44	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
45	DVERKAUF	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
46	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
47	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
48	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
49	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
50	DVRKPLAN	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
51	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
52	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
53	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_VIOB02	GSBER	TGSB	GSBER
2	VIGW_R_VIOB02	KOKRS	TKA01	KOKRS
3	VIGW_R_VIOB02	PRCTR	CEPC	PRCTR
4	VIGW_R_VIOB02	PROFL	TKB1A	APROF
5	VIGW_R_VIOB02	RGRNART	TIVC4	RGRNART
6	VIGW_R_VIOB02	RNBPLAN	TIVB3	RNBPLAN
7	VIGW_R_VIOB02	SGRART	TIV56	SGRART
8	VIGW_R_VIOB02	SGRFRM	TIV58	SGRFRM
9	VIGW_R_VIOB02	SGRGZS	TIV59	SGRGZS
10	VIGW_R_VIOB02	SGRQAL	TIV57	SGRQAL
11	VIGW_R_VIOB02	SGRUNDB	VIGBUCH	SGRUNDB
12	VIGW_R_VIOB02	SUNUTZA	TIV36	SUNART

History

Last changed by/on	SAP	20110901
SAP Release Created in