VILMRG SAP table for – Real Estate Register – Entries

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

SAP VILMRG table

Table VILMRG technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Real Estate Register – Entries: Key Fields
    Its a key field.
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • LRREGNO : Real Estate Register Number
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • LRREGSUBNO : RE Register Number: Subentry
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Real Estate Register – Entries: Non-Key Fields
  • COOWNERNUM : Coownership: Numerator
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • COOWNERDENOM : Coownership: Denominator
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RPRGNO : Real Properties Register Number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • LRMEASVALUE : Measurement Amount Relevant for Land Register
    Its data type is QUAN (Quantity field) with field length 17
  • MEASUNIT : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • APPLICATIONDATE : Date of Application
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ENTRYDATE : Date of Entry
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • APPROVALDATE : Date of Consent
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CANCELDATE : Date of Cancellation of Entry
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XCOMMENT : Comment
    Its data type is CHAR (Character String) with field length 80
  • HERITLRDISTRICT : Land Lease Right: Land Register District
    Its data type is CHAR (Character String) with field length 6
  • HERITLRVOLUMENO : Land Lease Right: Volume Number of Land Register
    Its data type is CHAR (Character String) with field length 15
  • HERITLRPAGENO : Land Lease Right: Page Number in Land Register
    Its data type is CHAR (Character String) with field length 15
  • HERITSEC2NO : Land Lease Right: Sequence Number of Land Register Section 2
    Its data type is CHAR (Character String) with field length 6
  • HERITOWNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • HERITFIXTERMDATE : Land Lease Right: End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HERITTERM : Land Lease Right: Term in Years
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ISDOMTENENTRY : Related Right in Real Estate Register
    Its data type is CHAR (Character String) with field length 1
  • DOMTENENTRYDATE : End of Validity of Related Right
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ENCUMBRANCETYPE : Encumbrance Type
    Its data type is CHAR (Character String) with field length 8
  • PLEXTIDENTKEY : ID of External Parcel – OBSOLETE
    Its data type is CHAR (Character String) with field length 45
  • PLOBJNR : Object Number of Assigned Parcel
    Its data type is CHAR (Character String) with field length 22
  • PLEXTIDENTKEYL : ID of External Parcel
    Its data type is CHAR (Character String) with field length 60