SAP ABAP Table VIGBUCH (Land register)

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	TRANSP	Transparent table
Transparent table	VIGBUCH	Table Relationship Diagram
Short Description	Land register

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	.INCLUDE	☐				0	0	Land Register Data Fields
4	.INCLUDE	☐				0	0	Land Register Data Fields Part 1
5	.INCLUDE	☐				0	0	Land Register Data Fields Part 1a
6	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
7	XGBVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
8	NBANDNR	☐	NBANDNR	TEXT15	CHAR	15	0	Land register volume number
9	NBLATTNR	☐	NBLATTNR	TEXT15	CHAR	15	0	Land register page number
10	.INCLUDE	☐				0	0	Land Register Data Fields Part 1b
11	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
12	.INCLUDE	☐				0	0	Land Register Data Fields Part 1c
13	SGRBA	☐	SGRBA	SGRBA	NUMC	2	0	Land register type	TDO6
14	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
15	.INCLUDE	☐				0	0	Land Register Data Fields Part 2
16	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
17	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
18	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
19	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
20	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
21	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
22	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
23	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
24	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
25	.INCLUDE	☐				0	0	Land Register Data Fields Part 3
26	XGBAMT	☐	XGBAMT	XTEXT25	CHAR	25	0	Land registry ID
27	.INCLUDE	☐				0	0	Land Register Data Fields Part 4
28	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
29	VVNUMOBJ	☐	VVNUMOBJ	VVNUMOBJ	CHAR	2	0	Key for number range object
30	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
31	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
32	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
33	.INCLU--AP	☐				0	0	LUM: Append für VIGBUCH-Erweiterung
34	SGBVON	☐	SGBVON	CHAR6	CHAR	6	0	Grundbuchbezirk	TIVGBBEZ
35	ENDDATE	☐	VVDATECLOSE	DATE	DATS	8	0	Schließungsdatum Grundbuch
36	AKTKZ	☐	AKTKZ	YNFLG	CHAR	1	0	Indicator: Active

Foreign Keys

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

History

Last changed by/on	SAP	20040819
SAP Release Created in