1. SAP Tutorial
  2. Real Estate Management

VIBDPR SAP table for – Land

Here we would like to draw your attention to VIBDPR 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). VIBDPR is a SAP standard transp table used for storing Land related data in SAP. It comes under the package RE_BD_PR.

SAP VIBDPR table

Table VIBDPR technical data

TableVIBDPR
Data storingLand
ModuleRE
Sub ModuleRE-FX-BD
SAP PackageRE_BD_PR
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIBDPR 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 VIBDPR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Property: Key Fields
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • SWENR : Business Entity Number
    Its data type is CHAR (Character String) with field length 8
  • SGRNR : Number of Land
    Its data type is CHAR (Character String) with field length 8
  • .INCLUDE : Property: Non-Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • IMKEY : Internal Key of Real Estate Object (FI)
    Its data type is CHAR (Character String) with field length 8
  • CREATIONTYPE : How the Object Was Created
    Its data type is CHAR (Character String) with field length 1
  • .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
  • RESPONSIBLE : Person Responsible
    Its data type is CHAR (Character String) with field length 12
  • USEREXCLUSIVE : User with Exclusive Change Authorization
    Its data type is CHAR (Character String) with field length 12
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • VALIDFROM : Date: Object Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Date: Object Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XGRTXT : Name of Land
    Its data type is CHAR (Character String) with field length 60
  • RGRNART : Usage Type of Property According to Land Use Map
    Its data type is CHAR (Character String) with field length 2
  • BDMQMB1 : Market value
    Its data type is CURR (Currency Field) with field length 13
  • BDMQMB2 : Purchase price
    Its data type is CURR (Currency Field) with field length 13
  • BDNRWERT : Land reference value for determining current market value
    Its data type is CURR (Currency Field) with field length 13
  • BDNWERT : Land value for determining current market value
    Its data type is CURR (Currency Field) with field length 13
  • DBDNWERT : Date of land value
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RBEPLAN : Development plan
    Its data type is CHAR (Character String) with field length 30
  • DBEPLAN : Date of development plan
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XNUTZGRU : Current usage of property
    Its data type is CHAR (Character String) with field length 30
  • NZGRZ : Permitted Usage: Site Occupancy Index
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • NZGFZ : Permitted Usage: Floor Area Ratio
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • NZBMZ : Permitted Usage: Construction Dimension Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • NTGRZ : Actual Usage: Site Occupancy Index
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • NTGFZ : Actual Usage: Floor Area Ratio
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • NTBMZ : Actual Usage: Construction Dimension Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • RNBPLAN : Usage type according to development plan
    Its data type is CHAR (Character String) with field length 4
  • SGRART : Property type
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SGRQAL : Property: Quality of location
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SGRFRM : Property ground type
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SGRGZS : Overall condition of property
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DWIRTUB : Transfer usage / charges
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DVERKAUF : Sale date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SUNUTZA : Main usage type
    Its data type is CHAR (Character String) with field length 8
  • JUNUTZA : OBSOLETE: Main Usage Type
    Its data type is CHAR (Character String) with field length 1
  • DVRKPLAN : Planned sale
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XGEMARK : Local Subdistrict
    Its data type is CHAR (Character String) with field length 12
  • NFLURNR : Number of Tract of Land in Land Register
    Its data type is CHAR (Character String) with field length 6
  • XFLURST : Parcel of Land
    Its data type is CHAR (Character String) with field length 10
  • BRFLURST : Fractional Parcel of Land
    Its data type is CHAR (Character String) with field length 4
  • JERBBAU : Heritable building right indicator
    Its data type is CHAR (Character String) with field length 1
  • GEMEINDE : Municipality key
    Its data type is CHAR (Character String) with field length 8
  • ZULBAUH : Permitted building height
    Its data type is QUAN (Quantity field) with field length 4
  • LEINS : Unit of length
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • USGFUNCTION : Function of Object
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLU–AP : Country specific fields (CI) for Switzerland – PR
  • .INCLUDE : Rental Object Customer fields
  • PLANNO : Real Properties Register Number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • LOCATIONCH : Location Description of Land Acc. To Tax Auth.
    Its data type is CHAR (Character String) with field length 60
  • ESTATEDESCR : Location Description of Land Acc. To Land Register
    Its data type is CHAR (Character String) with field length 60
  • GEMEINDECH : Land Register District
    Its data type is CHAR (Character String) with field length 6
  • .INCLU–AP : Country specific fields for India – PR
  • SECCO : Section Code
    Its data type is CHAR (Character String) with field length 4
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • .INCLU–AP : Country-Specific Fields for Portugal – Property
  • .INCLUDE : Country-Specific Fields for Portugal – Property
  • VPT : Property Taxable Value
    Its data type is CURR (Currency Field) with field length 15
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5

    • VIBDPR related tables

    • VIBDPR : Land

    VIBDPR related transaction codes under SAP package RE_BD_PR

    • REBDPR0011 : PR:Assignment Screen Field->DB-Field
    • REBDPR0001 : PR: Applications
    • REBDPR0008 : PR: GUI Standard Functions
    • REBDPR0004 : PR: Stages
    • REBDPR0016 : PR: Tables
    • REBDPRARE : Display Land (Archive)
    • REBDPR0017 : PR: External Applications
    • REBDPR0003 : PR: Views
    • REBDPR0100 : PR: Field Modification per Activity
    • REBDPR0006 : PR: Screen sequences
    • REBDPR0002 : PR: Field Groupings
    • REBDPR0022 : PR: Where-Used List: Structure
    • REBDPR0102 : PR: Authorization Types
    • REBDPRAR : Archive Land
    • REBDPR0106 : PR: Assign. Object Part –> NoticeID
    • REBDPR0012 : PR: Field Grouping Criteria
    • REBDPR0103 : PR: Field Groups for Authorization
    • REBDPR0018 : PR: Activities
    • REBDPR0019 : PR:Fld Grouping per Actvty (Control)
    • REBDPR0005 : PR: Screens

    Related References

    Related Tutorials

    VILMLR SAP table for – Land Register

    VILMLR table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VILMEMADD SAP table for – Rights and Easements – Land

    VILMEMADD table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VILMPL SAP table for – Parcel of Land

    VILMPL table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VILMSEC1ADD SAP table for – Land Register – Section 1 – Land/Owners

    VILMSEC1ADD table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VILMLRPN SAP table for – Land Register: Processing Numbers

    VILMLRPN table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    /CEERE/KUK SAP table for – Cadastral district-average prices of agrucultural land

    /CEERE/KUK table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VILMSEC1 SAP table for – Land Register – Section 1 – Owners

    VILMSEC1 table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    «
    »