SAP ABAP Table VILMPE (Other Public Register)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-LM (Application Component) Land Use Management
     ⤷ RE_LM_PE (Package) RE: Other Public Registers

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VILMPE	Table Relationship Diagram
Short Description	Other Public Register

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	Other Public Register: Key Fields
4	PEID	☐	RELMPEID	RELMPEID	CHAR	40	0	ID of Other Public Registers
5	.INCLUDE	☐				0	0	Other Public Register: Non-Key Fields
6	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
7	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
8	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
9	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
10	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
11	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
12	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
13	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
14	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
15	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
16	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
17	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
18	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
19	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
20	PETYPE	☐	RELMPETYPE	RELMPETYPE	CHAR	1	0	Type of Other Public Register
21	XPE	☐	RELMXPE	RECAXLDESCRIPTION	CHAR	60	0	Name of Other Public Register
22	VALIDFROM	☐	RECADATEFROM	RECADATEBEG	DATS	8	0	Date: Valid From
23	VALIDTO	☐	RECADATETO	RECADATEEND	DATS	8	0	Date: Valid To
24	LOCHIER	☐	RELMPELOCHIER	REBDLOCHIER	CHAR	30	0	Location Key of Public Register in Location Structure	TIVBDLOCHIER
25	PEERPAGENO	☐	RELMPEERPAGENO	RELMPEERPAGENO	CHAR	10	0	Easement Register: Page Number
26	PECSNO	☐	RELMPECSNO	RELMPECSNO	CHAR	6	0	Number of Contamination or Non-Hazardous Waste
27	PEPSNO	☐	RELMPEPSNO	RELMPEPSNO	CHAR	6	0	Number of the Site Protection
28	PEDPNO	☐	RELMPEDPNO	RELMPEDPNO	CHAR	20	0	Development Plan Number
29	PEPREDPNO	☐	RELMPEPREDPNO	RELMPEPREDPNO	CHAR	20	0	Preliminary Procedure for Development Plan
30	PEPSTYPE	☐	RELMPEPSTYPE	RELMPEPSTYPE	CHAR	4	0	Type of Site Protection	TIVLMPEPSTYPE
31	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
32	PEPLANDATE	☐	RELMPEPLANDATE	RECADATE	DATS	8	0	Planning or Decision Date
33	PEEFFECTDATE	☐	RELMPEEFFECTDATE	RECADATE	DATS	8	0	Effective Date
34	PECHANGEDATE	☐	RELMPECHANGEDATE	RECADATE	DATS	8	0	Date of Change Lock
35	PESTATEMENTDATE	☐	RELMPESTATEMENTDATE	RECADATE	DATS	8	0	Date of Opinion Statement
36	PELASTMODDATE	☐	RELMPELASTMODDATE	RECADATE	DATS	8	0	Last Changed on
37	PEREVOCDATE	☐	RELMPEREVOCDATE	RECADATEEND	DATS	8	0	Date Revoked
38	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VILMPE	LOCHIER	TIVBDLOCHIER	LOCHIER	REF	C	CN
2	VILMPE	PEPSTYPE	TIVLMPEPSTYPE	PEPSTYPE	REF	1	CN
3	VILMPE	RESPONSIBLE	USR02	BNAME	REF	1	CN
4	VILMPE	RGRNART	TIVC4	RGRNART	REF	1	CN
5	VILMPE	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

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