VIGBA3 SAP (Section 3 of land register) Table details

Dictionary Type: Table
Description: Section 3 of land register




ABAP Code to SELECT data from VIGBA3
Related tables to VIGBA3
Access table VIGBA3




Table field list including key, data, relationships and ABAP select examples

VIGBA3 is a standard SAP Table which is used to store Section 3 of land register data and is available within R/3 SAP systems depending on the version and release level.

The VIGBA3 table consists of various fields, each holding specific information or linking keys about Section 3 of land register data available in SAP. These include SGRUNDB (Land register number), SNRABT3 (No. of entry in Section 3 of land register), NRANG (Rank in section 3 of land register), XGRSTLST (List of properties for an entry).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VIGBA3 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SGRUNDBLand register number SGRUNDBNUMC8Assigned to domainSGRUNDBGBS
SNRABT3No. of entry in Section 3 of land register SNRABT3NUMC3NRABT3
NRANGRank in section 3 of land register NRANGNUMC4NRANG
XGRSTLSTList of properties for an entry XGRSTLSTCHAR18XTEXT18
RGRSTLSTReference to relational table properties RGRSTLSTNUMC10RGRSTLST
DBEINTRDate of approval of entry DBEINTRDATS8DATUM
DEINTRAGDate of entry DEINTRAGDATS8DDAT
BDARLEHTotal amount of right registered in Section III BDARLEHCURR13(2) WRTV7
WAEBEZCurrency description WAEBEZCUKY5TCURCWAERS
RBELASTType of encumbrance in section 3 of land register RBELASTNUMC2TIV02RBELAST
NRDARLEHLoan number NRDARLEHNUMC12NRDARLEH
XBELASTText about charge XBELASTCHAR60TEXT60
BNOMINNominal loan amount BNOMINCURR11(2) WRBTR
BEFFECTEffective loan amount BEFFECTCURR11(2) WRBTR
XGLAUBCreditor XGLAUBCHAR25XTEXT25
ZGRUSCHLand charge interest rate VVZGRUSCHDEC10(7) DEC3_7
JREVALIndicator: Revaluation permitted JREVALCHAR1JANEI
ZNEBENLAdditional service interest rate VVZNEBENLDEC10(7) DEC3_7
JLOESCHReal Estate Deletion Indicator/Flag JLOESCHCHAR1JLOESCH
JEIGENRIndividual right indicator JEIGENRCHAR1JANEI
DAUSZGVDate: Land register extract from DAUSZGVDATS8DAUSZGV
JKZLOEIndicator: Land register entry is marked as being deleted JKZLOECHAR1JFLAGG
XNRA3Section 3, number of entry VVXNRA3CHAR6ALPHAVVXNRGB

Key field Non-key field



How do I retrieve data from SAP table VIGBA3 using ABAP code

The following ABAP code Example will allow you to do a basic selection on VIGBA3 to SELECT all data from the table
DATA: WA_VIGBA3 TYPE VIGBA3.

SELECT SINGLE *
FROM VIGBA3
INTO CORRESPONDING FIELDS OF WA_VIGBA3
WHERE...

How to access SAP table VIGBA3

Within an ECC or HANA version of SAP you can also view further information about VIGBA3 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!