| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | INTRENO | Internal Key of Real Estate Object | nvarchar | 13 | 0 | CHAR | (N' ') | No | | RECAINTRENO | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 4 | SWENR | Site Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | REBDBENO | Allow NULL? |
| 5 | SGENR | Number of Building | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | REBDBUNO | Allow NULL? |
| 6 | OBJNR | Object Number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RECAOBJNR | Allow NULL? |
| 7 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | RECAIMKEY | Allow NULL? |
| 8 | CREATIONTYPE | How the Object Was Created | char | 1 | 0 | CHAR | (N' ') | Yes | | RECACREATIONTYPE | Allow NULL? |
| 9 | RERF | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RERF | Allow NULL? |
| 10 | DERF | First Entered on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DERF | Allow NULL? |
| 11 | TERF | Time of Initial Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TERF | Allow NULL? |
| 12 | REHER | Source of initial entry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REHER | Allow NULL? |
| 13 | RBEAR | Employee ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RBEAR | Allow NULL? |
| 14 | DBEAR | Last Edited on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBEAR | Allow NULL? |
| 15 | TBEAR | Last Edited at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TBEAR | Allow NULL? |
| 16 | RBHER | Editing Source | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RBHER | Allow NULL? |
| 17 | RESPONSIBLE | Person Responsible | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | RECARESPONSIBLE | Allow NULL? |
| 18 | USEREXCLUSIVE | User with Exclusive Change Authorization | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | RECAUSEREXCLUSIVE | Allow NULL? |
| 19 | AUTHGRP | Authorization Group | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | RECAAUTHGRP | Allow NULL? |
| 20 | VALIDFROM | Date: Object Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REBDOBJVALIDFROM | Allow NULL? |
| 21 | VALIDTO | Date: Object Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REBDOBJVALIDTO | Allow NULL? |
| 22 | XGETXT | Description of Building | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | REBDXBU | Allow NULL? |
| 23 | RGEBART | Type of building | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | TIV5A | RGEBART | Allow NULL? |
| 24 | JERBBAU | Heritable building right indicator | char | 1 | 0 | CHAR | (N' ') | Yes | TDO9 | JERBBAU | Allow NULL? |
| 25 | RGEBZUST | General condition of building | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | TIV83 | RGEBZUST | Allow NULL? |
| 26 | YBAUJAHR | ConstYr | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVYBAUJAHR | Allow NULL? |
| 27 | YMODERN | Year of modernization | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVYMODERN | Allow NULL? |
| 28 | YAUFBAU | Year of reconstruction | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVYAUFBAU | Allow NULL? |
| 29 | DBAUBEGI | Construction start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBAUBEGI | Allow NULL? |
| 30 | BBAUW13 | OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933 | decimal | 11 | 2 | CURR | ((0)) | Yes | | BBAUWXOLD | |
| 31 | BBAUWX | Building Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | BBAUWX | |
| 32 | BBAUWAKT | OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933 | decimal | 11 | 2 | CURR | ((0)) | Yes | | BBAUWAKTXOLD | |
| 33 | BBAUWAKTX | Current Building Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | BBAUWAKTX | |
| 34 | BDMCBMRA | Amount per volume unit | decimal | 11 | 2 | CURR | ((0)) | Yes | | BDMCBMRA | |
| 35 | DBAUGENE | Building permit | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBAUGENE | Allow NULL? |
| 36 | XBAUGENE | Note on building permit | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | XBAUGENE | Allow NULL? |
| 37 | DBEZUGSF | Ready for occupancy | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBEZUGSF | Allow NULL? |
| 38 | DFERTIG | Completion | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DFERTIG | Allow NULL? |
| 39 | DSCHLUSS | Final Inspection | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DSCHLUSS | Allow NULL? |
| 40 | JDENKMAL | Protection of Historical Sites | char | 1 | 0 | CHAR | (N' ') | Yes | | JDENKMAL | Allow NULL? |
| 41 | DBAUVOR | Date of planning inquiry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBAUVOR | Allow NULL? |
| 42 | DVORBES | Date of prior notice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVORBES | Allow NULL? |
| 43 | DANTBAU | Application for building permit | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DANTBAU | Allow NULL? |
| 44 | BEINHEITW | OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933 | decimal | 11 | 2 | CURR | ((0)) | Yes | | BEINHEITWXOLD | |
| 45 | BEINHEITWX | Assessed Value of Building | decimal | 15 | 2 | CURR | ((0)) | Yes | | BEINHEITWX | |
| 46 | NEINHEITW | Assessed value base year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | NEINHEITW | Allow NULL? |
| 47 | BVERSWRT | OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933 | decimal | 11 | 2 | CURR | ((0)) | Yes | | BVERSWRTXOLD | |
| 48 | BVERSWRTX | Insurable Value Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | BVERSWRTX | |
| 49 | RVERSWRT | Type of insurance value | char | 1 | 0 | NUMC | (N'0') | Yes | | RVERSWRT | Allow NULL? |
| 50 | DWIRTUB | Transfer usage / charges | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDWIRTUB | Allow NULL? |
| 51 | DVERKAUF | Sale date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDVERKAUF | Allow NULL? |
| 52 | DVRKPLAN | Planned sale | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDVRKPLAN | Allow NULL? |
| 53 | DNUTZEND | End of usage | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDNUTZEND | Allow NULL? |
| 54 | DFRDVON | Public funding from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDFRDVON | Allow NULL? |
| 55 | DFRDBIS | Public funding to | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDFRDBIS | Allow NULL? |
| 56 | BANZGE | Number of floors | decimal | 4 | 1 | DEC | ((0)) | Yes | | VVBANZGE | |
| 57 | SUNUTZA | Main usage type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TIV36 | VVSUNART | Allow NULL? |
| 58 | JUNUTZA | OBSOLETE: Main Usage Type | char | 1 | 0 | CHAR | (N' ') | Yes | | REBDJUNUTZAOBS | Allow NULL? |
| 59 | SSTCKBIS | Uppermost Floor of a Building | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | VVSTCKBIS | Allow NULL? |
| 60 | SLIFTBIS | Elevator to Floor in Building | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | VVLIFTBIS | Allow NULL? |
| 61 | AUGESCH | Number of basements | decimal | 2 | 0 | DEC | ((0)) | Yes | | AUGESCH | |
| 62 | JANLHIE | OBSOLETE: Asset Assignment Also Applies for Subord. Building | char | 1 | 0 | CHAR | (N' ') | Yes | | REBDJANLHIEOBS | Allow NULL? |
| 63 | RLRALOC | Location Class | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TIVAJRLRALOC | REAJRLRALOC | Allow NULL? |
| 64 | USESRLRA | Representative List of Rents Is Used | char | 1 | 0 | CHAR | (N' ') | Yes | | REAJUSESRLRA | Allow NULL? |
| 65 | GEMEINDE | Municipality key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TIVG1 | VVGEMEINDE | Allow NULL? |
| 66 | REINS | Unit for cubic volume | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | REINS | Allow NULL? |
| 67 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 68 | HASCOP | Uses Current Occupancy Principle | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCHASCOP | Allow NULL? |
| 69 | USGFUNCTION | Function of Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVBDUSGFUNC | REBDUSGFUNCTION | Allow NULL? |
| 70 | OBJCOND | Code of Building Status | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TIVXCCHCOND | REXCCHBUCOND | Allow NULL? |
| 71 | OBJCAT | Building Category Code | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TIVXCCHKAT | REXCCHBUCATEGORY | Allow NULL? |
| 72 | YEARDECONSTR | Year of Demolition | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCCHBUDECONYEAR | Allow NULL? |
| 73 | AREAVALUE | Floor Area of Building in Square Meters | decimal | 10 | 2 | DEC | ((0)) | Yes | | REXCCHBUAREA | |
| 74 | HEATINGTYPE | Code of Heating Type | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TIVXCCHHEAT | REXCCHBUHEATINGTYPE | Allow NULL? |
| 75 | ENERGYHEAT | Energy Carrier of Heating | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TIVXCCHGENSRC | REXCCHBUENERGYSOURCEH | Allow NULL? |
| 76 | ENERGYWATER | Energy Carrier of Hot Water | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TIVXCCHGENSRC | REXCCHBUENERGYSOURCEW | Allow NULL? |
| 77 | HOTWATERSUPPLY | Central Hot Water Supply | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCCHBUHOTWATER | Allow NULL? |
| 78 | POWERCONSUM | Power Consumption of Building (in kWh) | decimal | 10 | 2 | DEC | ((0)) | Yes | | REXCCHBUPOWERCONSUMPTION | |
| 79 | GLAZING | Glazing Type | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | REXCCHBUGLAZING | Allow NULL? |
| 80 | ADMINNO | Administrative Building Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | REXCCHBUADMINNO | Allow NULL? |
| 81 | ADMINXGETXT | Building Name | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | REXCCHBUADMINXBU | Allow NULL? |
| 82 | GEMEINDECH | Land Register District | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RELMLRDISTRICT | Allow NULL? |
| 83 | BANZGECH | Number of floors | decimal | 4 | 1 | DEC | ((0)) | Yes | | VVBANZGE | |
| 84 | SSTCKBISCH | Uppermost Floor of a Building | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | VVSTCKBIS | Allow NULL? |
| 85 | SLIFTBISCH | Elevator to Floor in Building | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | VVLIFTBIS | Allow NULL? |
| 86 | AUGESCHCH | Number of basements | decimal | 2 | 0 | DEC | ((0)) | Yes | | AUGESCH | |
| 87 | SECCO | Section Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SECCO | Allow NULL? |
| 88 | BUPLA | Business Place | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUPLA | Allow NULL? |
| 89 | REPKOCH | Kind of Change | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCJPREPKOCH | Allow NULL? |
| 90 | BDCONSTR | Construction Status | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCJPBDCONSTR | Allow NULL? |
| 91 | BDFIREPREV | Fire Fighting Method Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | REXCJPBDFIREPREV | Allow NULL? |
| 92 | BDOTHOW | Number of Another Owners in the Same Building | int | 10 | 0 | INT4 | ((0)) | Yes | | REXCJPBDOTHOW | Allow NULL? |
| 93 | BDOWNSHIP | Building Ownership Status | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCJPBDOWNSHIP | Allow NULL? |
| 94 | KOCHDATE | Date of Change in Kind of Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCJPKOCHDATE | Allow NULL? |
| 95 | VPT | Property Taxable Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | REXCPTVPT_NOSIGN | |
| 96 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 97 | CONDK | Conservation Level | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVXCPTRACONS | REXCPTRACONS | Allow NULL? |
