1. SAP Tutorial
  2. Real Estate Management

VILMPL SAP table for – Parcel of Land

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

SAP VILMPL table

Table VILMPL technical data

TableVILMPL
Data storingParcel of Land
ModuleRE
Sub ModuleRE-FX-LM
SAP PackageRE_LM_PL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VILMPL 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 VILMPL 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 : Parcel: Key Fields
  • LOCHIER : Location Key of Parcel in Location Structure
    Its data type is CHAR (Character String) with field length 30
  • PLSUBDIVNO : Tract Number
    Its data type is CHAR (Character String) with field length 6
  • PLNO : Parcel Number
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Parcel: 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
  • XPL : Parcel of Land – Text
    Its data type is CHAR (Character String) with field length 60
  • VALIDFROM : Date Parcel Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Date: Parcel Ceased to Exist On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PLSURVEYIND : Surveying Status of Parcel
    Its data type is CHAR (Character String) with field length 1
  • PLISTEMPORARY : Temporary Parcel
    Its data type is CHAR (Character String) with field length 1
  • USGFUNCTION : Function of Object
    Its data type is CHAR (Character String) with field length 4
  • USESIMPLEPLNO : Use Simplified Parcel Number
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLU–AP : Active Country Specific Fields for Spain
  • .INCLUDE : Country-Specific Fields for Spain – Parcel of Land
  • CADASTERREF : Cadastral Register Number
    Its data type is CHAR (Character String) with field length 20

    • VILMPL related tables

    • VILMPLUS : Usage and Development Planning
    • TIVLMPLUST : Usage Types (Internal, Planned, Other) – Texts
    • TIVLMPLMAP : Parcel Map Type
    • VILMPLMAP : Parcel Maps
    • TIVLMPLMAPT : Parcel Map Type – Texts
    • TIVLMPLCL : Cadastral Classification
    • TIVLMPLSL : Overlay Numbers
    • TIVLMPLUS : Usage Types (Internal, Planned, Other)
    • TIVLMPLUSSUB : Subusage Types (Internal, Planned)
    • TIVLMPLDPRAREA : LUM-Relevant Depreciation Areas
    • TIVLMPLSFO : Soil Parent Material
    • TIVLMPLSFOT : Soil Parent Material – Texts
    • TIVLMPLSLT : Overlay Numbers – Texts
    • TIVLMPLSLHIER : Relevant Overlay Numbers for Each Hierarchy Level
    • TIVLMPLUSSUBT : Subusage Types (Internal, Planned) – Texts
    • TIVLMPLSFTYT : Soil Texture – Texts
    • VILMPL : Parcel of Land
    • VILMPLSL : Overlays and Classifications
    • TIVLMPLSFTY : Soil Texture
    • TIVLMPLCLT : Cadastral Classification – Texts

    VILMPL related transaction codes under SAP package RE_LM_PL

    • RELML10100 : L1: Field Modification per Activity
    • RELML10006 : L1: Screen Sequences
    • RELMPLARE : Display Parcels (Archive)
    • RELML10106 : L1: Assignmt Object Part –> Memo ID
    • RELML10009 : L1: CUA Additional Functions
    • RELMPLAR : Archive Parcels
    • RELML10012 : L1: Field Modification Criteria
    • RELML10005 : L1: Screens
    • RELML10008 : L1: CUA Standard Functions
    • RELML10017 : L1: External Applications
    • RELML10007 : L1: Events
    • RELML10018 : L1: Activities
    • RELML10002 : L1: Field Groups
    • RELML10004 : L1: Sections
    • RELML10011 : L1: Assignment Screen Fld->DB Field
    • RELML10003 : L1: Views
    • RELML10019 : L1: Field Mod. per Activity (Control
    • RELML10104 : L1: Screen Configuration
    • RELML10016 : L1: Tables
    • RELMPLCHECK : Mass Check: Parcels

    Related References

    Related Tutorials

    VILMRCPLREL SAP table for – Parcel Update – Parcel

    VILMRCPLREL table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    RELMPL SAP tcode for – Process Parcel of Land

    RELMPL tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for Process Parcel...

    VILMRGBTYPE SAP table for – Real Estate Register – Land Use Types for Parcel

    VILMRGBTYPE table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VILMPLMAP SAP table for – Parcel Maps

    VILMPLMAP table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    REISPLLR SAP tcode for – InfoSystem: Land Registers f. Parcel

    REISPLLR tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for InfoSystem: Land...

    TIVLMPLMAPT SAP table for – Parcel Map Type – Texts

    TIVLMPLMAPT table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VILMRC SAP table for – Parcel Update

    VILMRC table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    «
    »