SAP table VIGBUCH (Land register)
SAP table VIGBUCH has 2 primary key fields being MANDT,SGRUNDB.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Land register number
NUMC
8
0
SGRUNDB
PARTNR
Business Partner Number
CHAR
10
0
BP000
BP_PARTNR
XGBVON
Land register district
CHAR
25
0
XGBVON
NBANDNR
Land register volume number
CHAR
15
0
NBANDNR
NBLATTNR
Land register page number
CHAR
15
0
NBLATTNR
JLOESCH
Real Estate Deletion Indicator/Flag
CHAR
1
0
JLOESCH
SGRBA
Land register type
NUMC
2
0
TDO6
SGRBA
FEINS
Area Unit
UNIT
3
0
T006
FEINS
RERF
Entered By
CHAR
12
0
RERF
DERF
First Entered On
DATS
8
0
DERF
TERF
Time of Creation
TIMS
6
0
TERF
REHER
Source of Initial Entry
CHAR
10
0
REHER
RBEAR
Employee ID
CHAR
12
0
RBEAR
DBEAR
Last Edited On
DATS
8
0
DBEAR
TBEAR
Last Edited At
TIMS
6
0
TBEAR
RBHER
Editing Source
CHAR
10
0
RBHER
XGBAMT
Land registry ID
CHAR
25
0
XGBAMT
IMKEY
Internal Key for Real Estate Object
CHAR
8
0
IMKEY
VVNUMOBJ
Key for number range object
CHAR
2
0
VVNUMOBJ
Possible values
VB
Collateral value
VD
Loans
VI
Real Estate
VN
Loan interested parties
VO
Loan collateral object
VS
Loan collateral
VW
Securities
RFAKT
Conversion factor for fractional share of property
NUMC
6
0
VVRFAKT
INTRENO
Internal Real Estate Master Data Code
CHAR
13
0
VVINTRENO
BERGRP
Authorization group
CHAR
40
0
VVBERGRP
SGBVON
CHAR
6
0
TIVGBBEZ
SGBVON
ENDDATE
DATS
8
0
VVDATECLOSE
AKTKZ
Indicator: Active
CHAR
1
0
AKTKZ
VIGBUCH foreign key relationships
Table
Field
Check Table
Check Field
0 VIGBUCH
FEINS
T006 Units of Measurement
MANDT
1 VIGBUCH
MANDT
T000 Clients
MANDT
0 VIGBUCH
PARTNR
BP000 Business Partner Master (General Data)
PARTNR
1 VIGBUCH
SGRBA
TDO6 Land register type indicator
MANDT
1 VIGBUCH
SGRBA
TDO6 Land register type indicator
SGRBA