SAP ABAP Table VILMPL (Parcel of Land)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-LM (Application Component) Land Use Management
     ⤷ RE_LM_PL (Package) RE: Parcel of Land

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VILMPL	Table Relationship Diagram
Short Description	Parcel of Land

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	INTRENO	☑	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
3	.INCLUDE	☐				0	0	Parcel: Key Fields
4	LOCHIER	☐	RELMPLLOCHIER	REBDLOCHIER	CHAR	30	0	Location Key of Parcel in Location Structure	TIVBDLOCHIER
5	PLSUBDIVNO	☐	RELMPLSUBDIVNO	RELMPLSUBDIVNO	CHAR	6	0	Tract Number
6	PLNO	☐	RELMPLNO	RELMPLNO	CHAR	20	0	Parcel Number
7	.INCLUDE	☐				0	0	Parcel: Non-Key Fields
8	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
9	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
10	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
11	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
12	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
13	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
14	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
15	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
16	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
17	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
18	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
19	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
20	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
21	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
22	XPL	☐	RELMXPL	RECAXLDESCRIPTION	CHAR	60	0	Parcel of Land - Text
23	VALIDFROM	☐	RELMPLVALIDFROM	RECADATEBEG	DATS	8	0	Date Parcel Valid From
24	VALIDTO	☐	RELMPLVALIDTO	RECADATEEND	DATS	8	0	Date: Parcel Ceased to Exist On
25	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	PLSURVEYIND	☐	RELMPLSURVEYIND	RELMPLSURVEYIND	CHAR	1	0	Surveying Status of Parcel
27	PLISTEMPORARY	☐	RELMPLISTEMPORARY	RECABOOL	CHAR	1	0	Temporary Parcel
28	USGFUNCTION	☐	REBDUSGFUNCTION	REBDUSGFUNCTION	CHAR	4	0	Function of Object	TIVBDUSGFUNC
29	USESIMPLEPLNO	☐	RELMPLUSESIMPLEPLNO	RECABOOL	CHAR	1	0	Use Simplified Parcel Number
30	.INCLUDE	☐				0	0
31	.INCLU--AP	☐				0	0	Active Country Specific Fields for Spain
32	.INCLUDE	☐				0	0	Country-Specific Fields for Spain - Parcel of Land
33	CADASTERREF	☐	REXCESCADREF	TEXT20	CHAR	20	0	Cadastral Register Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VILMPL	GSBER	TGSB	GSBER	REF	C	CN
2	VILMPL	LOCHIER	TIVBDLOCHIER	LOCHIER	KEY	1	CN
3	VILMPL	RESPONSIBLE	USR02	BNAME	REF	1	CN
4	VILMPL	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
5	VILMPL	USGFUNCTION	TIVBDUSGFUNC	USGFUNCTION	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600