SAP table VILMPL (Parcel of Land)

SAP table VILMPL has 2 primary key fields being MANDT,INTRENO.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
INTRENO Internal Key of Real Estate Object CHAR 13 0 RECAINTRENO
LOCHIER Location Key of Parcel in Location Structure CHAR 30 0 TIVBDLOCHIER RELMPLLOCHIER
PLSUBDIVNO Tract Number CHAR 6 0 RELMPLSUBDIVNO
PLNO Parcel Number CHAR 20 0 RELMPLNO
OBJNR Object Number CHAR 22 0 * RECAOBJNR
CREATIONTYPE How the Object Was Created CHAR 1 0 RECACREATIONTYPE
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 CHAR 12 0 RERF
DERF First Entered On DATS 8 0 DERF
TERF Time of Creation TIMS 6 0 TERF
REHER Source of Initial Entry CHAR 10 0 REHER
RBEAR Employee ID CHAR 12 0 RBEAR
DBEAR Last Edited On DATS 8 0 DBEAR
TBEAR Last Edited At TIMS 6 0 TBEAR
RBHER Editing Source CHAR 10 0 RBHER
RESPONSIBLE Person Responsible CHAR 12 0 USR02 RECARESPONSIBLE
USEREXCLUSIVE User with Exclusive Change Authorization CHAR 12 0 USR02 RECAUSEREXCLUSIVE
AUTHGRP Authorization Group CHAR 40 0 RECAAUTHGRP
XPL Parcel of Land - Text CHAR 60 0 RELMXPL
VALIDFROM Date Parcel Valid From DATS 8 0 RELMPLVALIDFROM
VALIDTO Date: Parcel Ceased to Exist On DATS 8 0 RELMPLVALIDTO
GSBER Business Area CHAR 4 0 TGSB GSBER
PLSURVEYIND Surveying Status of Parcel CHAR 1 0 RELMPLSURVEYIND
Undefined
1 Surveyed
2 Not Surveyed
PLISTEMPORARY Temporary Parcel CHAR 1 0 RELMPLISTEMPORARY
USGFUNCTION Function of Object CHAR 4 0 TIVBDUSGFUNC REBDUSGFUNCTION
USESIMPLEPLNO Use Simplified Parcel Number CHAR 1 0 RELMPLUSESIMPLEPLNO
CADASTERREF Cadastral Register Number CHAR 20 0 REXCESCADREF

VILMPL foreign key relationships

Table Field Check Table Check Field
0 VILMPL GSBER TGSB Business Areas MANDT
0 VILMPL GSBER TGSB Business Areas GSBER
1 VILMPL LOCHIER TIVBDLOCHIER Assignment of Hierarchical Locations to Location Structure MANDT
1 VILMPL LOCHIER TIVBDLOCHIER Assignment of Hierarchical Locations to Location Structure LOCSYS
0 VILMPL RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
1 VILMPL USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME
0 VILMPL USGFUNCTION TIVBDUSGFUNC Functions of Objects of Usage View USGFUNCTION