SAP ABAP Table VIBDPR (Land)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-BD (Application Component) Basic Data
⤷ RE_BD_PR (Package) RE: Property Master Data
⤷ RE-FX-BD (Application Component) Basic Data
⤷ RE_BD_PR (Package) RE: Property Master Data
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VIBDPR | Table Relationship Diagram |
Short Description | Land |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | INTRENO | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
3 | .INCLUDE | 0 | 0 | Property: Key Fields | |||||
4 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
5 | SWENR | REBDBENO | REBDBENO | CHAR | 8 | 0 | Business Entity Number | * | |
6 | SGRNR | REBDPRNO | REBDPRNO | CHAR | 8 | 0 | Number of Land | ||
7 | .INCLUDE | 0 | 0 | Property: Non-Key Fields | |||||
8 | OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
9 | IMKEY | RECAIMKEY | IMKEY | CHAR | 8 | 0 | Internal Key of Real Estate Object (FI) | ||
10 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
11 | .INCLUDE | 0 | 0 | Field String for Maintenance of User Data | |||||
12 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
13 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
14 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
15 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
16 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
17 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
18 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
19 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
20 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | USR02 | |
21 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | USR02 | |
22 | AUTHGRP | RECAAUTHGRP | RECAAUTHGRP | CHAR | 40 | 0 | Authorization Group | ||
23 | VALIDFROM | REBDOBJVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date: Object Valid From | ||
24 | VALIDTO | REBDOBJVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Object Valid To | ||
25 | XGRTXT | REBDXPR | RECAXLDESCRIPTION | CHAR | 60 | 0 | Name of Land | ||
26 | RGRNART | RGRNART | CHAR2 | CHAR | 2 | 0 | Usage Type of Property According to Land Use Map | TIVC4 | |
27 | BDMQMB1 | BDMQMB1 | WRTV7 | CURR | 13 | 2 | Market value | ||
28 | BDMQMB2 | BDMQMB2 | WRTV7 | CURR | 13 | 2 | Purchase price | ||
29 | BDNRWERT | BDNRWERT | WRTV7 | CURR | 13 | 2 | Land reference value for determining current market value | ||
30 | BDNWERT | BDNWERT | WRTV7 | CURR | 13 | 2 | Land value for determining current market value | ||
31 | DBDNWERT | DBDNWERT | DDAT | DATS | 8 | 0 | Date of land value | ||
32 | RBEPLAN | RBEPLAN | XMBEZ | CHAR | 30 | 0 | Development plan | ||
33 | DBEPLAN | DBEPLAN | DDAT | DATS | 8 | 0 | Date of development plan | ||
34 | XNUTZGRU | XNUTZGRU | XMBEZ | CHAR | 30 | 0 | Current usage of property | ||
35 | NZGRZ | NZGRZ | DEC1_2 | DEC | 3 | 2 | Permitted Usage: Site Occupancy Index | ||
36 | NZGFZ | NZGFZ | DEC2_2 | DEC | 4 | 2 | Permitted Usage: Floor Area Ratio | ||
37 | NZBMZ | NZBMZ | DEC3_2 | DEC | 5 | 2 | Permitted Usage: Construction Dimension Number | ||
38 | NTGRZ | NTGRZ | DEC1_2 | DEC | 3 | 2 | Actual Usage: Site Occupancy Index | ||
39 | NTGFZ | NTGFZ | DEC2_2 | DEC | 4 | 2 | Actual Usage: Floor Area Ratio | ||
40 | NTBMZ | NTBMZ | DEC3_2 | DEC | 5 | 2 | Actual Usage: Construction Dimension Number | ||
41 | RNBPLAN | RNBPLAN | RGRNART | CHAR | 4 | 0 | Usage type according to development plan | TIVB3 | |
42 | SGRART | VVSGRART | VVSGRART | NUMC | 4 | 0 | Property type | TIV56 | |
43 | SGRQAL | VVSGRQAL | VVSGRQAL | NUMC | 3 | 0 | Property: Quality of location | TIV57 | |
44 | SGRFRM | VVSGRFRM | VVSGRFRM | NUMC | 3 | 0 | Property ground type | TIV58 | |
45 | SGRGZS | VVSGRGZS | VVSGRGZS | NUMC | 3 | 0 | Overall condition of property | TIV59 | |
46 | DWIRTUB | VVDWIRTUB | DATUM | DATS | 8 | 0 | Transfer usage / charges | ||
47 | DVERKAUF | VVDVERKAUF | DATUM | DATS | 8 | 0 | Sale date | ||
48 | SUNUTZA | VVSUNART | VVSUNART | CHAR | 8 | 0 | Main usage type | TIV36 | |
49 | JUNUTZA | REBDJUNUTZAOBS | CHAR1 | CHAR | 1 | 0 | OBSOLETE: Main Usage Type | ||
50 | DVRKPLAN | VVDVRKPLAN | DATUM | DATS | 8 | 0 | Planned sale | ||
51 | XGEMARK | VVGEMARK | VVGEMARK | CHAR | 12 | 0 | Local Subdistrict | TIVG2 | |
52 | NFLURNR | NFLURNR | NFLURNR | CHAR | 6 | 0 | Number of Tract of Land in Land Register | ||
53 | XFLURST | XFLURST | TEXT10 | CHAR | 10 | 0 | Parcel of Land | ||
54 | BRFLURST | VVBRFLURST | VVBRFLURST | CHAR | 4 | 0 | Fractional Parcel of Land | ||
55 | JERBBAU | JERBBAU | SOBJERBBAU | CHAR | 1 | 0 | Heritable building right indicator | TDO9 | |
56 | GEMEINDE | VVGEMEINDE | VVGEMEINDE | CHAR | 8 | 0 | Municipality key | TIVG1 | |
57 | ZULBAUH | VVZULBAUH | VVZULBAUH | QUAN | 4 | 0 | Permitted building height | ||
58 | LEINS | VVLEINS | MEINS | UNIT | 3 | 0 | Unit of length | T006 | |
59 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
60 | USGFUNCTION | REBDUSGFUNCTION | REBDUSGFUNCTION | CHAR | 4 | 0 | Function of Object | TIVBDUSGFUNC | |
61 | .INCLUDE | 0 | 0 | ||||||
62 | .INCLU--AP | 0 | 0 | Country specific fields (CI) for Switzerland - PR | |||||
63 | .INCLUDE | 0 | 0 | Rental Object Customer fields | |||||
64 | PLANNO | RELMRPRGNO | RELMRPRGNO | NUMC | 6 | 0 | Real Properties Register Number | ||
65 | LOCATIONCH | REXCCHPRLOCATION | RECAXLDESCRIPTION | CHAR | 60 | 0 | Location Description of Land Acc. To Tax Auth. | ||
66 | ESTATEDESCR | REXCCHPRDESCRIPTION | RECAXLDESCRIPTION | CHAR | 60 | 0 | Location Description of Land Acc. To Land Register | ||
67 | GEMEINDECH | RELMLRDISTRICT | RELMLRDISTRICT | CHAR | 6 | 0 | Land Register District | * | |
68 | .INCLU--AP | 0 | 0 | Country specific fields for India - PR | |||||
69 | SECCO | SECCO | SECCO | CHAR | 4 | 0 | Section Code | * | |
70 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
71 | .INCLU--AP | 0 | 0 | Country-Specific Fields for Portugal - Property | |||||
72 | .INCLUDE | 0 | 0 | Country-Specific Fields for Portugal - Property | |||||
73 | VPT | REXCPTVPT_NOSIGN | REXCPTVPT_NOSIGN | CURR | 15 | 2 | Property Taxable Value | ||
74 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VIBDPR | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | VIBDPR | CURRENCY | TCURC | WAERS | |||
3 | VIBDPR | GEMEINDE | TIVG1 | GEMEINDE | REF | C | CN |
4 | VIBDPR | JERBBAU | TDO9 | SOBJERBBAU | REF | 1 | CN |
5 | VIBDPR | LEINS | T006 | MSEHI | REF | C | CN |
6 | VIBDPR | RESPONSIBLE | USR02 | BNAME | REF | 1 | CN |
7 | VIBDPR | RGRNART | TIVC4 | RGRNART | REF | C | CN |
8 | VIBDPR | RNBPLAN | TIVB3 | RNBPLAN | REF | C | CN |
9 | VIBDPR | SGRART | TIV56 | SGRART | REF | C | CN |
10 | VIBDPR | SGRFRM | TIV58 | SGRFRM | REF | C | CN |
11 | VIBDPR | SGRGZS | TIV59 | SGRGZS | REF | C | CN |
12 | VIBDPR | SGRQAL | TIV57 | SGRQAL | REF | C | CN |
13 | VIBDPR | SUNUTZA | TIV36 | SUNART | REF | C | CN |
14 | VIBDPR | USEREXCLUSIVE | USR02 | BNAME | REF | C | CN |
15 | VIBDPR | USGFUNCTION | TIVBDUSGFUNC | USGFUNCTION | REF | C | CN |
16 | VIBDPR | WAERS | TCURC | WAERS | REF | C | CN |
17 | VIBDPR | XGEMARK | TIVG2 | GEMARK | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 200 |