1. Home
  2. Resources
  3. SAP Tables
  4. VILMPL - Parcel of Land

SAP Table VILMPL

Parcel of Land

VILMPL (Parcel of Land) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VILMPL to other SAP tables.

Source: VILMPL (Parcel of Land)

VILMPL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
INTRENO Internal Key of Real Estate Object RECAINTRENO CHAR 13 0
LOCHIER Location Key of Parcel in Location Structure RELMPLLOCHIER TIVBDLOCHIER CHAR 30 0
PLSUBDIVNO Tract Number RELMPLSUBDIVNO CHAR 6 0
PLNO Parcel Number RELMPLNO CHAR 20 0
OBJNR Object Number RECAOBJNR CHAR 22 0
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1 0
NULL Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
RESPONSIBLE Person Responsible RECARESPONSIBLE USR02 CHAR 12 0
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE USR02 CHAR 12 0
AUTHGRP Authorization Group RECAAUTHGRP CHAR 40 0
XPL Parcel of Land - Text RELMXPL CHAR 60 0
VALIDFROM Date Parcel Valid From RELMPLVALIDFROM DATS 8 0
VALIDTO Date: Parcel Ceased to Exist On RELMPLVALIDTO DATS 8 0
GSBER Business Area GSBER TGSB CHAR 4 0
PLSURVEYIND Surveying Status of Parcel RELMPLSURVEYIND CHAR 1 0
1 Surveyed
2 Not Surveyed
NULL Undefined
PLISTEMPORARY Temporary Parcel RELMPLISTEMPORARY CHAR 1 0
X Yes
NULL No
USGFUNCTION Function of Object REBDUSGFUNCTION TIVBDUSGFUNC CHAR 4 0
USESIMPLEPLNO Use Simplified Parcel Number RELMPLUSESIMPLEPLNO CHAR 1 0
X Yes
NULL No
CADASTERREF Cadastral Register Number REXCESCADREF CHAR 20 0

VILMPL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VILMPL GSBER SYST MANDT TGSB Business Areas MANDT
VILMPL GSBER VILMPL GSBER TGSB Business Areas GSBER
VILMPL LOCHIER SYST MANDT TIVBDLOCHIER Assignment of Hierarchical Locations to Location Structure MANDT
VILMPL LOCHIER * TIVBDLOCHIER Assignment of Hierarchical Locations to Location Structure LOCSYS
VILMPL LOCHIER VILMPL LOCHIER TIVBDLOCHIER Assignment of Hierarchical Locations to Location Structure LOCHIER
VILMPL RESPONSIBLE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
VILMPL RESPONSIBLE VILMPL RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
VILMPL USEREXCLUSIVE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
VILMPL USEREXCLUSIVE VILMPL USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME
VILMPL USGFUNCTION SYST MANDT TIVBDUSGFUNC Functions of Objects of Usage View MANDT
VILMPL USGFUNCTION 'I8' TIVBDUSGFUNC Functions of Objects of Usage View USGOBJTYP
VILMPL USGFUNCTION VILMPL USGFUNCTION TIVBDUSGFUNC Functions of Objects of Usage View USGFUNCTION