SAP ABAP Table VIGBOOK (LUM: Grundbuch)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_MI_LU (Package) RE: Migration LUM (Data Dictionary only)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIGBOOK	Table Relationship Diagram
Short Description	LUM: Grundbuch

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	SGRUNDB	☑	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	*
3	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
4	SGBVON	☐	SGBVON	CHAR6	CHAR	6	0	Grundbuchbezirk	TIVGBBEZ
5	NBANDNR	☐	VVBANDNR	VVBANDNR	CHAR	10	0	Band-Nr. eines Grundbuchs
6	NBLATTNR	☐	VVBLATTNR	VVBLATTNR	CHAR	10	0	Blatt-Nr. Grundbuch
7	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
8	SGRBA	☐	SGRBA	SGRBA	NUMC	2	0	Land register type	TDO6
9	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
10	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
11	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
12	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
13	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
14	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
15	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
16	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
17	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
18	XGBAMT	☐	XGBAMT	XTEXT25	CHAR	25	0	Land registry ID
19	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
20	VVNUMOBJ	☐	VVNUMOBJ	VVNUMOBJ	CHAR	2	0	Key for number range object
21	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
22	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
23	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
24	ENDDATE	☐	VVDATECLOSE	DATE	DATS	8	0	Schließungsdatum Grundbuch
25	AKTKZ	☐	AKTKZ	YNFLG	CHAR	1	0	Indicator: Active
26	EXTPARTNR	☐	EXTPARTNR	CHAR15	CHAR	15	0	External business partner identification
27	XGBVON	☐	VVGBVON	XTEXT25	CHAR	25	0	Grundbuchbezirk

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIGBOOK	FEINS	T006	MSEHI	KEY	1	CN
2	VIGBOOK	MANDT	T000	MANDT	KEY	1	CN
3	VIGBOOK	PARTNR	BP000	PARTNR	KEY	1	CN
4	VIGBOOK	SGBVON	TIVGBBEZ	SGBVON
5	VIGBOOK	SGRBA	TDO6	SGRBA	KEY	1	CN

History

Last changed by/on	SAP	20040819
SAP Release Created in