VILMPL SAP (Parcel of Land) Table details

Dictionary Type: Table
Description: Parcel of Land




ABAP Code to SELECT data from VILMPL
Related tables to VILMPL
Access table VILMPL




Table field list including key, data, relationships and ABAP select examples

VILMPL is a standard SAP Table which is used to store Parcel of Land data and is available within R/3 SAP systems depending on the version and release level.

The VILMPL table consists of various fields, each holding specific information or linking keys about Parcel of Land data available in SAP. These include INTRENO (Internal Key of Real Estate Object), LOCHIER (Location Key of Parcel in Location Structure), PLSUBDIVNO (Tract Number), PLNO (Parcel Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VILMPL table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
LOCHIERLocation Key of Parcel in Location Structure RELMPLLOCHIERCHAR30TIVBDLOCHIERREBDLOCHIERRELMPLLOCHIERREBDLOCHIERO
PLSUBDIVNOTract Number RELMPLSUBDIVNOCHAR6ALPHARELMPLSUBDIVNORELMPLSUBDIVNO
PLNOParcel Number RELMPLNOCHAR20PLNORELMPLNORELMPLNO
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
CREATIONTYPEHow the Object Was Created RECACREATIONTYPECHAR1RECACREATIONTYPE
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
RESPONSIBLEPerson Responsible RECARESPONSIBLECHAR12USR02XUBNAMEUSER_COMP
USEREXCLUSIVEUser with Exclusive Change Authorization RECAUSEREXCLUSIVECHAR12USR02XUBNAMEUSER_COMP
AUTHGRPAuthorization Group RECAAUTHGRPCHAR40RECAAUTHGRP
XPLParcel of Land - Text RELMXPLCHAR60RECAXLDESCRIPTION
VALIDFROMDate Parcel Valid From RELMPLVALIDFROMDATS8RECADATEBEG
VALIDTODate: Parcel Ceased to Exist On RELMPLVALIDTODATS8REDATRECADATEEND
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
PLSURVEYINDSurveying Status of Parcel RELMPLSURVEYINDCHAR1RELMPLSURVEYIND
PLISTEMPORARYTemporary Parcel RELMPLISTEMPORARYCHAR1RECABOOL
USGFUNCTIONFunction of Object REBDUSGFUNCTIONCHAR4TIVBDUSGFUNCALPHAREBDUSGFUNCTIONREBDUSGFUNC
USESIMPLEPLNOUse Simplified Parcel Number RELMPLUSESIMPLEPLNOCHAR1RECABOOL
.INCLU--AP 0
CADASTERREFCadastral Register Number REXCESCADREFCHAR20TEXT20

Key field Non-key field



How do I retrieve data from SAP table VILMPL using ABAP code

The following ABAP code Example will allow you to do a basic selection on VILMPL to SELECT all data from the table
DATA: WA_VILMPL TYPE VILMPL.

SELECT SINGLE *
FROM VILMPL
INTO CORRESPONDING FIELDS OF WA_VILMPL
WHERE...

How to access SAP table VILMPL

Within an ECC or HANA version of SAP you can also view further information about VILMPL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!