SAP VILMPE Other Public Register Table
Overview
VILMPE is a standard SAP S/4HANA table that stores Other Public Register data. There are total 34 fields in the VILMPE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VILMPE belongs to Land Use Management (RE-FX-LM) module and is located in the package RE: Other Public Registers (RE_LM_PE).
In addition, following links provide an overview of foreign key relationships, if any, that link VILMPE to other SAP tables and standard CDS views available based on VILMPE table in S/4HANA 2020.
Techincal Settings of VILMPE
Below are technical details of the table VILMPE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VILMPE Fields
The following table gives you an overview of the fields available in VILMPE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| PEID | ID of Other Public Registers | RELMPEID | CHAR | 40 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| RESPONSIBLE | Person Responsible | RECARESPONSIBLE | USR02 | CHAR | 12 |
| USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | USR02 | CHAR | 12 |
| AUTHGRP | Authorization Group | RECAAUTHGRP | CHAR | 40 | |
| PETYPE | Type of Other Public Register | RELMPETYPE | CHAR | 1 | |
| XPE | Name of Other Public Register | RELMXPE | CHAR | 60 | |
| VALIDFROM | Date: Valid From | RECADATEFROM | DATS | 8 | |
| VALIDTO | Date: Valid To | RECADATETO | DATS | 8 | |
| LOCHIER | Location Key of Public Register in Location Structure | RELMPELOCHIER | TIVBDLOCHIER | CHAR | 30 |
| PEERPAGENO | Easement Register: Page Number | RELMPEERPAGENO | CHAR | 10 | |
| PECSNO | Number of Contamination or Non-Hazardous Waste | RELMPECSNO | CHAR | 6 | |
| PEPSNO | Number of the Site Protection | RELMPEPSNO | CHAR | 6 | |
| PEDPNO | Development Plan Number | RELMPEDPNO | CHAR | 20 | |
| PEPREDPNO | Preliminary Procedure for Development Plan | RELMPEPREDPNO | CHAR | 20 | |
| PEPSTYPE | Type of Site Protection | RELMPEPSTYPE | TIVLMPEPSTYPE | CHAR | 4 |
| RGRNART | Usage Type of Property According to Land Use Map | RGRNART | TIVC4 | CHAR | 2 |
| PEPLANDATE | Planning or Decision Date | RELMPEPLANDATE | DATS | 8 | |
| PEEFFECTDATE | Effective Date | RELMPEEFFECTDATE | DATS | 8 | |
| PECHANGEDATE | Date of Change Lock | RELMPECHANGEDATE | DATS | 8 | |
| PESTATEMENTDATE | Date of Opinion Statement | RELMPESTATEMENTDATE | DATS | 8 | |
| PELASTMODDATE | Last Changed on | RELMPELASTMODDATE | DATS | 8 | |
| PEREVOCDATE | Date Revoked | RELMPEREVOCDATE | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VILMPE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VILMPE | LOCHIER | C: CN | TIVBDLOCHIER |
| VILMPE | PEPSTYPE | 1: CN | TIVLMPEPSTYPE |
| VILMPE | RESPONSIBLE | 1: CN | USR02 |
| VILMPE | RGRNART | 1: CN | TIVC4 |
| VILMPE | USEREXCLUSIVE | C: CN | USR02 |