1. SAP Tutorial
  2. Real Estate Management

VILMPE SAP table for – Other Public Register

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

SAP VILMPE table

Table VILMPE technical data

TableVILMPE
Data storingOther Public Register
ModuleRE
Sub ModuleRE-FX-LM
SAP PackageRE_LM_PE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VILMPE 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 VILMPE 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 : Other Public Register: Key Fields
  • PEID : ID of Other Public Registers
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Other Public 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
  • PETYPE : Type of Other Public Register
    Its data type is CHAR (Character String) with field length 1
  • XPE : Name of Other Public 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 : Date: Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LOCHIER : Location Key of Public Register in Location Structure
    Its data type is CHAR (Character String) with field length 30
  • PEERPAGENO : Easement Register: Page Number
    Its data type is CHAR (Character String) with field length 10
  • PECSNO : Number of Contamination or Non-Hazardous Waste
    Its data type is CHAR (Character String) with field length 6
  • PEPSNO : Number of the Site Protection
    Its data type is CHAR (Character String) with field length 6
  • PEDPNO : Development Plan Number
    Its data type is CHAR (Character String) with field length 20
  • PEPREDPNO : Preliminary Procedure for Development Plan
    Its data type is CHAR (Character String) with field length 20
  • PEPSTYPE : Type of Site Protection
    Its data type is CHAR (Character String) with field length 4
  • RGRNART : Usage Type of Property According to Land Use Map
    Its data type is CHAR (Character String) with field length 2
  • PEPLANDATE : Planning or Decision Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PEEFFECTDATE : Effective Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PECHANGEDATE : Date of Change Lock
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PESTATEMENTDATE : Date of Opinion Statement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PELASTMODDATE : Last Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PEREVOCDATE : Date Revoked
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • VILMPE related tables

    • VILMPEER : Public Register – Easements
    • VILMPECS : Other Public Register – Contamination/Non-Hazardous Waste
    • TIVLMPEERTYPE : Easement Type
    • VILMPE : Other Public Register
    • TIVLMPECSTYPET : Site Protection Type – Texts
    • TIVLMPEPSTYPE : Type of Site Protection
    • VILMPEEROA : Public Register – Easements – Dominant Tenements
    • TIVLMPEERTYPET : Easement Type – Texts
    • TIVLMPECSTYPE : Type of Contamination/Non-Hazardous Waste
    • TIVLMPEPSTYPET : Site Protection Type – Texts

    VILMPE related transaction codes under SAP package RE_LM_PE

    • RELML20017 : L2: External Applications
    • RELML20006 : L2: Screen Sequences
    • RELMPEAR : Archive Other Public Registers
    • RELML20002 : L2: Field Groups
    • RELML20019 : L2: Field Mod. per Activity (Control
    • RELML20106 : L2: Assignmt Object Part –> Memo ID
    • RELML20007 : L2: Events
    • RELML20105 : L2: Field Mod. per Ext. Application
    • RELMPERP : Change Pers.Resp: Public Registers
    • RELML20104 : L2: Screen Configuration
    • RELMPE : Process Other Public Register
    • RELML20001 : L2: Applications
    • RELMPEARE : Disp.Other Public Registers(Archive)
    • RELML20003 : L2: Views
    • RELML20012 : L2: Field Modification Criteria
    • RELML20016 : L2: Tables
    • RELMPEPSNO : Number Range Maintenance: RELMPEPS
    • RELMPECHECK : Mass Check: Public Registers
    • RELML20018 : L2: Activities
    • RELML20005 : L2: Screens

    Related References

    Related Tutorials

    VILMPECS SAP table for – Other Public Register – Contamination/Non-Hazardous Waste

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

    VILMPEER SAP table for – Public Register – Easements

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

    VILMPEEROA SAP table for – Public Register – Easements – Dominant Tenements

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

    RELMPE SAP tcode for – Process Other Public Register

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

    RECPA260 SAP tcode for – General Letter (Public Register)

    RECPA260 tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for General Letter...

    RECPA270 SAP tcode for – Master Data Summ. (Public Register)

    RECPA270 tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for Master Data...

    RELMPEAR SAP tcode for – Archive Other Public Registers

    RELMPEAR tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for Archive Other...

    «
    »