SAP ABAP Table VILULB (LUM: Bebauungsplanung)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_MI_LU (Package) RE: Migration LUM (Data Dictionary only)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VILULB	Table Relationship Diagram
Short Description	LUM: Bebauungsplanung

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	INTRENOLB	☑	RELUINTRENOLB	VVINTRENO	CHAR	13	0	Interne Verschlüsselung der Bebauungsplanung
3	.INCLUDE	☐				0	0	LUM: Semantischer Schlüssel einer Bebauungsplanung
4	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
5	STATE	☐	RELUSTATE	REGIO	CHAR	3	0	Bundesland	T005S
6	DISTRICT	☐	RELUDISTRICT	CHAR03	CHAR	3	0	Kreis	TIVFKREIS
7	MUNICIPAL	☐	RELUMUNICIPAL	CHAR3	CHAR	3	0	Gemeinde	TIVFGEMEINDE
8	LBCNO	☐	RELULBCNO	CHAR20	CHAR	20	0	Bebauungsplan-Nummer
9	PROCNO	☐	RELUPROCNO	CHAR20	CHAR	20	0	Nummer des Vorverfahrens zu einem Bebauungsplan
10	.INCLUDE	☐				0	0	LUM: Nicht-Schlüsselfelder einer Bebauungsplanung
11	USATYPEPLUM	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
12	DESCRLB	☐	RELUDESCRLB	TEXT80	CHAR	80	0	Bezeichnung eines Bebauungsplans/Vorverfahrens
13	DESCRLB_SH	☐	RELUDESCRLB_SH	CHAR80	CHAR	80	0	Bezeichnung Bebauungsplan/Vorverfahren (Suchhilfe)
14	DPLACEDUPROC	☐	RELUDPLACEDUPROC	RECADATE	DATS	8	0	Aufstellungsbeschlussdatum eines Bebauungsplans
15	DLEGALBIND	☐	RELUDLEGALBIND	RECADATE	DATS	8	0	Rechtsverbindlichkeitsdatum eines Bebauungsplans
16	DBLOCKCHANGE	☐	RELUDBLOCKCHANGE	RECADATE	DATS	8	0	Datum Veränderungssperre
17	DSTATEMENT	☐	RELUDSTATEMENT	RECADATE	DATS	8	0	Bebauungsplan: Stellungnahme
18	DLASTMODADD	☐	RELUDLASTMODADD	RECADATE	DATS	8	0	Datum der letzten Änderung eines Bebauungsplans
19	DREVOCATION	☐	RELUDREVOCATION	RECADATE	DATS	8	0	Aufhebungsdatum eines Bebauungsplans
20	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
21	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
22	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
23	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
24	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
25	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
26	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
27	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
28	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
29	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VILULB	COUNTRY	T005	LAND1
2	VILULB	DISTRICT	TIVFKREIS	KREIS
3	VILULB	MANDT	T000	MANDT
4	VILULB	MUNICIPAL	TIVFGEMEINDE	GEMEINDE
5	VILULB	STATE	T005S	BLAND
6	VILULB	USATYPEPLUM	TIVC4	RGRNART

History

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