SAP VIGB3A Changes / deletions in section 3 of land register Table

Overview

VIGB3A is a standard SAP S/4HANA table that stores Changes / deletions in section 3 of land register data. There are total 12 fields in the VIGB3A table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIGB3A belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).

In addition, following links provide an overview of foreign key relationships, if any, that link VIGB3A to other SAP tables and standard CDS views available based on VIGB3A table in S/4HANA 2020.

Techincal Settings of VIGB3A

Below are technical details of the table VIGB3A

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VIGB3A Fields

The following table gives you an overview of the fields available in VIGB3A

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDT*CLNT3
SGRUNDBLand register numberSGRUNDB*NUMC8
SNRABT3No. of entry in Section 3 of land registerSNRABT3NUMC3
SNRABT3ANo. of change/deletion in section 3 of land registerSNRABT3ANUMC3
JLOEKZIndicator: Land register entry is marked as being deletedJKZLOECHAR1
DAENDERChange /deletion dateDAENDERDATS8
BAENLOEChange or deletion amountBAENLOECURR13
WAEBEZCurrency descriptionWAEBEZTCURCCUKY5
DLOESCHDeletion dateDLOESCHDATS8
XAENDText for change or deletionVVXAENDCHAR60
JLOESCHReal Estate Deletion Indicator/FlagJLOESCHCHAR1
XNRA3ANo of change in sect. IIIVVXNRARACHAR6

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIGB3A

Table NameFieldCardinalityCheck Table
VIGB3AWAEBEZ1: CNTCURC

Other References