VIGBOOK SAP table for – LUM: Grundbuch

Here we would like to draw your attention to VIGBOOK table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VIGBOOK is a SAP standard transp table used for storing LUM: Grundbuch related data in SAP. It comes under the package RE_MI_LU.

SAP VIGBOOK table

Table VIGBOOK technical data

TableVIGBOOK
Data storingLUM: Grundbuch
ModuleRE
Sub ModuleRE-FX
SAP PackageRE_MI_LU
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIGBOOK Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VIGBOOK table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SGRUNDB : Land register number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • PARTNR : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • SGBVON : Grundbuchbezirk
    Its data type is CHAR (Character String) with field length 6
  • NBANDNR : Band-Nr. eines Grundbuchs
    Its data type is CHAR (Character String) with field length 10
  • NBLATTNR : Blatt-Nr. Grundbuch
    Its data type is CHAR (Character String) with field length 10
  • JLOESCH : Real Estate Deletion Indicator/Flag
    Its data type is CHAR (Character String) with field length 1
  • SGRBA : Land register type
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • FEINS : Area unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • XGBAMT : Land registry ID
    Its data type is CHAR (Character String) with field length 25
  • IMKEY : Internal Key for Real Estate Object
    Its data type is CHAR (Character String) with field length 8
  • VVNUMOBJ : Key for number range object
    Its data type is CHAR (Character String) with field length 2
  • RFAKT : Conversion factor for fractional share of property
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • INTRENO : Internal Real Estate Master Data Code
    Its data type is CHAR (Character String) with field length 13
  • BERGRP : Authorization group
    Its data type is CHAR (Character String) with field length 40
  • ENDDATE : Schließungsdatum Grundbuch
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AKTKZ : Indicator: Active
    Its data type is CHAR (Character String) with field length 1
  • EXTPARTNR : External business partner identification
    Its data type is CHAR (Character String) with field length 15
  • XGBVON : Grundbuchbezirk
    Its data type is CHAR (Character String) with field length 25