VILMLR SAP table for – Land Register

Here we would like to draw your attention to VILMLR 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). VILMLR is a SAP standard transp table used for storing Land Register related data in SAP. It comes under the package RE_LM_LR.

SAP VILMLR table

Table VILMLR technical data

TableVILMLR
Data storingLand Register
ModuleRE
Sub ModuleRE-FX-LM
SAP PackageRE_LM_LR
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VILMLR 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 VILMLR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Land Register: Key Fields
  • LRDISTRICT : Land Register District
    Its data type is CHAR (Character String) with field length 6
  • LRVOLUMENO : Number of Land Register Volume
    Its data type is CHAR (Character String) with field length 15
  • LRPAGENO : Page Number in Land Register
    Its data type is CHAR (Character String) with field length 15
  • .INCLUDE : Land Register: Non-Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • CREATIONTYPE : How the Object Was Created
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Field String for Maintenance of User Data
  • 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
  • RESPONSIBLE : Person Responsible
    Its data type is CHAR (Character String) with field length 12
  • USEREXCLUSIVE : User with Exclusive Change Authorization
    Its data type is CHAR (Character String) with field length 12
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • LRTYPE : Land Register Type
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • XLR : Name of Land Register
    Its data type is CHAR (Character String) with field length 60
  • VALIDFROM : Date: Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Closure Date of Land Register
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LRNOOLD : Old Land Register Number
    Its data type is CHAR (Character String) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes