VILMSEC1 SAP table for – Land Register – Section 1 – Owners

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

SAP VILMSEC1 table

Table VILMSEC1 technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Land Register – Section 1: 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
  • SEC1NO : Land Register Section: Sequence Number of Entry
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • SEC1SUBNO : Section in Land Register: Subentry
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Land Register – Section 1: Non-Key Fields
  • OWNER : GUID: Business Partner Object Relationship
    Its data type is RAW (Byte string) with field length 16
  • LEGALOWNER : GUID: Business Partner Object Relationship
    Its data type is RAW (Byte string) with field length 16
  • ENTRYDATE : Date of Entry
    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
  • FRACTSHNUM : Tenancy in Common: Numerator
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • FRACTSHDENOM : Tenancy in Common: Denominator
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • JOINDOSNUM : Joint Ownership: Numerator
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • JOINDOSDENOM : Joint Ownership: Denominator
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PROCESSINGNO : Processing Number
    Its data type is CHAR (Character String) with field length 12