| # | Field | Description | Data Element | Checktable | Domain | Datatype | Length | Decimals | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | MANDT | Client | MANDT | T000 | MANDT | CLNT | 000003 | 000000 | ||||||||
| 2 | INTRENO | Internal Key of Real Estate Object | RECAINTRENO | RECAINTRENO | CHAR | 000013 | 000000 | |||||||||
| 3 | BUKRS | Company Code | BUKRS | T001 | BUKRS | CHAR | 000004 | 000000 | ||||||||
| 4 | SWENR | Business Entity Number | REBDBENO | VIBDBE | REBDBENO | CHAR | 000008 | 000000 | ||||||||
| 5 | SGRNR | Number of Land | REBDPRNO | VIBDPR | REBDPRNO | CHAR | 000008 | 000000 | ||||||||
| 6 | OBJNR | Object Number | RECAOBJNR | ONR00 | J_OBJNR | CHAR | 000022 | 000000 | ||||||||
| 7 | IMKEY | Internal Key of Real Estate Object (FI) | RECAIMKEY | IMKEY | CHAR | 000008 | 000000 | |||||||||
| 8 | CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 000001 | 000000 | |||||||||
Possible Values
| ||||||||||||||||
| 9 | RERF | Entered By | RERF | SYCHAR12 | CHAR | 000012 | 000000 | |||||||||
| 10 | DERF | First Entered On | DERF | DATUM | DATS | 000008 | 000000 | |||||||||
| 11 | TERF | Time of Creation | TERF | TIMES | TIMS | 000006 | 000000 | |||||||||
| 12 | REHER | Source of Initial Entry | REHER | CHAR10 | CHAR | 000010 | 000000 | |||||||||
| 13 | RBEAR | Employee ID | RBEAR | SYCHAR12 | CHAR | 000012 | 000000 | |||||||||
| 14 | DBEAR | Last Edited On | DBEAR | DATUM | DATS | 000008 | 000000 | |||||||||
| 15 | TBEAR | Last Edited At | TBEAR | TIMES | TIMS | 000006 | 000000 | |||||||||
| 16 | RBHER | Editing Source | RBHER | CHAR10 | CHAR | 000010 | 000000 | |||||||||
| 17 | RESPONSIBLE | Person Responsible | RECARESPONSIBLE | USR02 | XUBNAME | CHAR | 000012 | 000000 | ||||||||
| 18 | USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | USR02 | XUBNAME | CHAR | 000012 | 000000 | ||||||||
| 19 | AUTHGRP | Authorization Group | RECAAUTHGRP | RECAAUTHGRP | CHAR | 000040 | 000000 | |||||||||
| 20 | VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | RECADATEBEG | DATS | 000008 | 000000 | |||||||||
| 21 | VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | RECADATEEND | DATS | 000008 | 000000 | |||||||||
| 22 | XGRTXT | Name of Land | REBDXPR | RECAXLDESCRIPTION | CHAR | 000060 | 000000 | |||||||||
| 23 | RGRNART | Usage Type of Property According to Land Use Map | RGRNART | TIVC4 | CHAR2 | CHAR | 000002 | 000000 | ||||||||
| 24 | BDMQMB1 | Market value | BDMQMB1 | WRTV7 | CURR | 000013 | 000002 | |||||||||
| 25 | BDMQMB2 | Purchase price | BDMQMB2 | WRTV7 | CURR | 000013 | 000002 | |||||||||
| 26 | BDNRWERT | Land reference value for determining current market value | BDNRWERT | WRTV7 | CURR | 000013 | 000002 | |||||||||
| 27 | BDNWERT | Land value for determining current market value | BDNWERT | WRTV7 | CURR | 000013 | 000002 | |||||||||
| 28 | DBDNWERT | Date of land value | DBDNWERT | DDAT | DATS | 000008 | 000000 | |||||||||
| 29 | RBEPLAN | Development plan | RBEPLAN | XMBEZ | CHAR | 000030 | 000000 | |||||||||
| 30 | DBEPLAN | Date of development plan | DBEPLAN | DDAT | DATS | 000008 | 000000 | |||||||||
| 31 | XNUTZGRU | Current usage of property | XNUTZGRU | XMBEZ | CHAR | 000030 | 000000 | |||||||||
| 32 | NZGRZ | Permitted Usage: Site Occupancy Index | NZGRZ | DEC1_2 | DEC | 000003 | 000002 | |||||||||
| 33 | NZGFZ | Permitted Usage: Floor Area Ratio | NZGFZ | DEC2_2 | DEC | 000004 | 000002 | |||||||||
| 34 | NZBMZ | Permitted Usage: Construction Dimension Number | NZBMZ | DEC3_2 | DEC | 000005 | 000002 | |||||||||
| 35 | NTGRZ | Actual Usage: Site Occupancy Index | NTGRZ | DEC1_2 | DEC | 000003 | 000002 | |||||||||
| 36 | NTGFZ | Actual Usage: Floor Area Ratio | NTGFZ | DEC2_2 | DEC | 000004 | 000002 | |||||||||
| 37 | NTBMZ | Actual Usage: Construction Dimension Number | NTBMZ | DEC3_2 | DEC | 000005 | 000002 | |||||||||
| 38 | RNBPLAN | Usage type according to development plan | RNBPLAN | TIVB3 | RGRNART | CHAR | 000004 | 000000 | ||||||||
| 39 | SGRART | Property type | VVSGRART | TIV56 | VVSGRART | NUMC | 000004 | 000000 | ||||||||
| 40 | SGRQAL | Property: Quality of location | VVSGRQAL | TIV57 | VVSGRQAL | NUMC | 000003 | 000000 | ||||||||
| 41 | SGRFRM | Property ground type | VVSGRFRM | TIV58 | VVSGRFRM | NUMC | 000003 | 000000 | ||||||||
| 42 | SGRGZS | Overall condition of property | VVSGRGZS | TIV59 | VVSGRGZS | NUMC | 000003 | 000000 | ||||||||
| 43 | DWIRTUB | Transfer usage / charges | VVDWIRTUB | DATUM | DATS | 000008 | 000000 | |||||||||
| 44 | DVERKAUF | Sale date | VVDVERKAUF | DATUM | DATS | 000008 | 000000 | |||||||||
| 45 | SUNUTZA | Main usage type | VVSUNART | TIV36 | VVSUNART | CHAR | 000008 | 000000 | ||||||||
| 46 | JUNUTZA | OBSOLETE: Main Usage Type | REBDJUNUTZAOBS | CHAR1 | CHAR | 000001 | 000000 | |||||||||
| 47 | DVRKPLAN | Planned sale | VVDVRKPLAN | DATUM | DATS | 000008 | 000000 | |||||||||
| 48 | XGEMARK | Local Subdistrict | VVGEMARK | TIVG2 | VVGEMARK | CHAR | 000012 | 000000 | ||||||||
| 49 | NFLURNR | Number of Tract of Land in Land Register | NFLURNR | NFLURNR | CHAR | 000006 | 000000 | |||||||||
| 50 | XFLURST | Parcel of Land | XFLURST | TEXT10 | CHAR | 000010 | 000000 | |||||||||
| 51 | BRFLURST | Fractional Parcel of Land | VVBRFLURST | VVBRFLURST | CHAR | 000004 | 000000 | |||||||||
| 52 | JERBBAU | Heritable building right indicator | JERBBAU | TDO9 | SOBJERBBAU | CHAR | 000001 | 000000 | ||||||||
| 53 | GEMEINDE | Municipality key | VVGEMEINDE | TIVG1 | VVGEMEINDE | CHAR | 000008 | 000000 | ||||||||
| 54 | ZULBAUH | Permitted building height | VVZULBAUH | VVZULBAUH | QUAN | 000004 | 000000 | |||||||||
| 55 | LEINS | Unit of length | VVLEINS | T006 | MEINS | UNIT | 000003 | 000000 | ||||||||
| 56 | WAERS | Currency Key | WAERS | TCURC | WAERS | CUKY | 000005 | 000000 | ||||||||
| 57 | USGFUNCTION | Function of Object | REBDUSGFUNCTION | TIVBDUSGFUNC | REBDUSGFUNCTION | CHAR | 000004 | 000000 | ||||||||
| 58 | PLANNO | Real Properties Register Number | RELMRPRGNO | RELMRPRGNO | NUMC | 000006 | 000000 | |||||||||
| 59 | LOCATIONCH | Location Description of Land Acc. To Tax Auth. | REXCCHPRLOCATION | RECAXLDESCRIPTION | CHAR | 000060 | 000000 | |||||||||
| 60 | ESTATEDESCR | Location Description of Land Acc. To Land Register | REXCCHPRDESCRIPTION | RECAXLDESCRIPTION | CHAR | 000060 | 000000 | |||||||||
| 61 | GEMEINDECH | Land Register District | RELMLRDISTRICT | TIVLMLRDIST | RELMLRDISTRICT | CHAR | 000006 | 000000 | ||||||||
| 62 | SECCO | Section Code | SECCO | SECCODE | SECCO | CHAR | 000004 | 000000 | ||||||||
| 63 | BUPLA | Business Place | BUPLA | PBUSINESSPLACE | J_1BBRANCH | CHAR | 000004 | 000000 | ||||||||
| 64 | VPT | Property Taxable Value | REXCPTVPT_NOSIGN | REXCPTVPT_NOSIGN | CURR | 000015 | 000002 | |||||||||
| 65 | CURRENCY | Currency Key | WAERS | TCURC | WAERS | CUKY | 000005 | 000000 | ||||||||