SAP ABAP Table VIGBA3 (Section 3 of 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	VIGBA3	Table Relationship Diagram
Short Description	Section 3 of 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	SNRABT3	☑	SNRABT3	NRABT3	NUMC	3	0	No. of entry in Section 3 of land register
4	NRANG	☐	NRANG	NRANG	NUMC	4	0	Rank in section 3 of land register
5	XGRSTLST	☐	XGRSTLST	XTEXT18	CHAR	18	0	List of properties for an entry
6	RGRSTLST	☐	RGRSTLST	RGRSTLST	NUMC	10	0	Reference to relational table properties
7	DBEINTR	☐	DBEINTR	DATUM	DATS	8	0	Date of approval of entry
8	DEINTRAG	☐	DEINTRAG	DDAT	DATS	8	0	Date of entry
9	BDARLEH	☐	BDARLEH	WRTV7	CURR	13	2	Total amount of right registered in Section III
10	WAEBEZ	☐	WAEBEZ	WAERS	CUKY	5	0	Currency description	TCURC
11	RBELAST	☐	RBELAST	RBELAST	NUMC	2	0	Type of encumbrance in section 3 of land register	TIV02
12	NRDARLEH	☐	NRDARLEH	NRDARLEH	NUMC	12	0	Loan number
13	XBELAST	☐	XBELAST	TEXT60	CHAR	60	0	Text about charge
14	BNOMIN	☐	BNOMIN	WRBTR	CURR	11	2	Nominal loan amount
15	BEFFECT	☐	BEFFECT	WRBTR	CURR	11	2	Effective loan amount
16	XGLAUB	☐	XGLAUB	XTEXT25	CHAR	25	0	Creditor
17	ZGRUSCH	☐	VVZGRUSCH	DEC3_7	DEC	10	7	Land charge interest rate
18	JREVAL	☐	JREVAL	JANEI	CHAR	1	0	Indicator: Revaluation permitted
19	ZNEBENL	☐	VVZNEBENL	DEC3_7	DEC	10	7	Additional service interest rate
20	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
21	JEIGENR	☐	JEIGENR	JANEI	CHAR	1	0	Individual right indicator
22	DAUSZGV	☐	DAUSZGV	DAUSZGV	DATS	8	0	Date: Land register extract from
23	JKZLOE	☐	JKZLOE	JFLAGG	CHAR	1	0	Indicator: Land register entry is marked as being deleted
24	XNRA3	☐	VVXNRA3	VVXNRGB	CHAR	6	0	Section 3, number of entry

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIGBA3	MANDT	T000	MANDT	KEY	1	CN
2	VIGBA3	RBELAST	TIV02	SBELAST	KEY	1	CN
3	VIGBA3	WAEBEZ	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in