SAP ABAP Table AVILULB (LUM: Änderungsbelegstruktur Bebauungsplanung (VILULB))

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	INTTAB	Structure
Structure	AVILULB	Table Relationship Diagram
Short Description	LUM: Änderungsbelegstruktur Bebauungsplanung (VILULB)

Delivery and Maintenance

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

Foreign Keys

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

History

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