VILULB SAP table for – LUM: Bebauungsplanung

Here we would like to draw your attention to VILULB table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VILULB is a SAP standard transp table used for storing LUM: Bebauungsplanung related data in SAP. It comes under the package RE_MI_LU.

SAP VILULB table

Table VILULB technical data

TableVILULB
Data storingLUM: Bebauungsplanung
ModuleRE
Sub ModuleRE-FX
SAP PackageRE_MI_LU
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VILULB Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VILULB table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENOLB : Interne Verschlüsselung der Bebauungsplanung
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : LUM: Semantischer Schlüssel einer Bebauungsplanung
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • STATE : Bundesland
    Its data type is CHAR (Character String) with field length 3
  • DISTRICT : Kreis
    Its data type is CHAR (Character String) with field length 3
  • MUNICIPAL : Gemeinde
    Its data type is CHAR (Character String) with field length 3
  • LBCNO : Bebauungsplan-Nummer
    Its data type is CHAR (Character String) with field length 20
  • PROCNO : Nummer des Vorverfahrens zu einem Bebauungsplan
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : LUM: Nicht-Schlüsselfelder einer Bebauungsplanung
  • USATYPEPLUM : Usage Type of Property According to Land Use Map
    Its data type is CHAR (Character String) with field length 2
  • DESCRLB : Bezeichnung eines Bebauungsplans/Vorverfahrens
    Its data type is CHAR (Character String) with field length 80
  • DESCRLB_SH : Bezeichnung Bebauungsplan/Vorverfahren (Suchhilfe)
    Its data type is CHAR (Character String) with field length 80
  • DPLACEDUPROC : Aufstellungsbeschlussdatum eines Bebauungsplans
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DLEGALBIND : Rechtsverbindlichkeitsdatum eines Bebauungsplans
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBLOCKCHANGE : Datum Veränderungssperre
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DSTATEMENT : Bebauungsplan: Stellungnahme
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DLASTMODADD : Datum der letzten Änderung eines Bebauungsplans
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DREVOCATION : Aufhebungsdatum eines Bebauungsplans
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BERGRP : Authorization group
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10