SAP VIBDPR Land Table
Overview
VIBDPR is a standard SAP S/4HANA table that stores Land data. There are total 65 fields in the VIBDPR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIBDPR belongs to Basic Data (RE-FX-BD) module and is located in the package RE: Property Master Data (RE_BD_PR).
In addition, following links provide an overview of foreign key relationships, if any, that link VIBDPR to other SAP tables and standard CDS views available based on VIBDPR table in S/4HANA 2020.
Techincal Settings of VIBDPR
Below are technical details of the table VIBDPR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIBDPR Fields
The following table gives you an overview of the fields available in VIBDPR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SWENR | Business Entity Number | REBDBENO | * | CHAR | 8 |
| SGRNR | Number of Land | REBDPRNO | CHAR | 8 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| IMKEY | Internal Key of Real Estate Object (FI) | RECAIMKEY | CHAR | 8 | |
| CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| RESPONSIBLE | Person Responsible | RECARESPONSIBLE | USR02 | CHAR | 12 |
| USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | USR02 | CHAR | 12 |
| AUTHGRP | Authorization Group | RECAAUTHGRP | CHAR | 40 | |
| VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | DATS | 8 | |
| VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | DATS | 8 | |
| XGRTXT | Name of Land | REBDXPR | CHAR | 60 | |
| RGRNART | Usage Type of Property According to Land Use Map | RGRNART | TIVC4 | CHAR | 2 |
| BDMQMB1 | Market value | BDMQMB1 | CURR | 13 | |
| BDMQMB2 | Purchase price | BDMQMB2 | CURR | 13 | |
| BDNRWERT | Land reference value for determining current market value | BDNRWERT | CURR | 13 | |
| BDNWERT | Land value for determining current market value | BDNWERT | CURR | 13 | |
| DBDNWERT | Date of land value | DBDNWERT | DATS | 8 | |
| RBEPLAN | Development plan | RBEPLAN | CHAR | 30 | |
| DBEPLAN | Date of development plan | DBEPLAN | DATS | 8 | |
| XNUTZGRU | Current usage of property | XNUTZGRU | CHAR | 30 | |
| NZGRZ | Permitted Usage: Site Occupancy Index | NZGRZ | DEC | 3 | |
| NZGFZ | Permitted Usage: Floor Area Ratio | NZGFZ | DEC | 4 | |
| NZBMZ | Permitted Usage: Construction Dimension Number | NZBMZ | DEC | 5 | |
| NTGRZ | Actual Usage: Site Occupancy Index | NTGRZ | DEC | 3 | |
| NTGFZ | Actual Usage: Floor Area Ratio | NTGFZ | DEC | 4 | |
| NTBMZ | Actual Usage: Construction Dimension Number | NTBMZ | DEC | 5 | |
| RNBPLAN | Usage type according to development plan | RNBPLAN | TIVB3 | CHAR | 4 |
| SGRART | Property type | VVSGRART | TIV56 | NUMC | 4 |
| SGRQAL | Property: Quality of location | VVSGRQAL | TIV57 | NUMC | 3 |
| SGRFRM | Property ground type | VVSGRFRM | TIV58 | NUMC | 3 |
| SGRGZS | Overall condition of property | VVSGRGZS | TIV59 | NUMC | 3 |
| DWIRTUB | Transfer usage / charges | VVDWIRTUB | DATS | 8 | |
| DVERKAUF | Sale date | VVDVERKAUF | DATS | 8 | |
| SUNUTZA | Main usage type | VVSUNART | TIV36 | CHAR | 8 |
| JUNUTZA | OBSOLETE: Main Usage Type | REBDJUNUTZAOBS | CHAR | 1 | |
| DVRKPLAN | Planned sale | VVDVRKPLAN | DATS | 8 | |
| XGEMARK | Local Subdistrict | VVGEMARK | TIVG2 | CHAR | 12 |
| NFLURNR | Number of Tract of Land in Land Register | NFLURNR | CHAR | 6 | |
| XFLURST | Parcel of Land | XFLURST | CHAR | 10 | |
| BRFLURST | Fractional Parcel of Land | VVBRFLURST | CHAR | 4 | |
| JERBBAU | Heritable building right indicator | JERBBAU | TDO9 | CHAR | 1 |
| GEMEINDE | Municipality key | VVGEMEINDE | TIVG1 | CHAR | 8 |
| ZULBAUH | Permitted building height | VVZULBAUH | QUAN | 4 | |
| LEINS | Unit of length | VVLEINS | T006 | UNIT | 3 |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| USGFUNCTION | Function of Object | REBDUSGFUNCTION | TIVBDUSGFUNC | CHAR | 4 |
| PLANNO | Real Properties Register Number | RELMRPRGNO | NUMC | 6 | |
| LOCATIONCH | Location Description of Land Acc. To Tax Auth. | REXCCHPRLOCATION | CHAR | 60 | |
| ESTATEDESCR | Location Description of Land Acc. To Land Register | REXCCHPRDESCRIPTION | CHAR | 60 | |
| GEMEINDECH | Land Register District | RELMLRDISTRICT | CHAR | 6 | |
| SECCO | Section Code | SECCO | CHAR | 4 | |
| BUPLA | Business Place | BUPLA | * | CHAR | 4 |
| VPT | Property Taxable Value | REXCPTVPT_NOSIGN | CURR | 15 | |
| CURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIBDPR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIBDPR | BUKRS | 1: CN | T001 |
| VIBDPR | CURRENCY | : | TCURC |
| VIBDPR | GEMEINDE | C: CN | TIVG1 |
| VIBDPR | JERBBAU | 1: CN | TDO9 |
| VIBDPR | LEINS | C: CN | T006 |
| VIBDPR | OBJNR | 1: CN | * |
| VIBDPR | RESPONSIBLE | 1: CN | USR02 |
| VIBDPR | RGRNART | C: CN | TIVC4 |
| VIBDPR | RNBPLAN | C: CN | TIVB3 |
| VIBDPR | SGRART | C: CN | TIV56 |
| VIBDPR | SGRFRM | C: CN | TIV58 |
| VIBDPR | SGRGZS | C: CN | TIV59 |
| VIBDPR | SGRQAL | C: CN | TIV57 |
| VIBDPR | SUNUTZA | C: CN | TIV36 |
| VIBDPR | USEREXCLUSIVE | C: CN | USR02 |
| VIBDPR | USGFUNCTION | C: CN | TIVBDUSGFUNC |
| VIBDPR | WAERS | C: CN | TCURC |
| VIBDPR | XGEMARK | C: CN | TIVG2 |