This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →The table VIOB03 (Real estate building master) is a standard table in SAP ERP. It belongs to the package FVVI.
Table | VIOB03 |
Short Text | Real estate building master |
Package | FVVI |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
BUKRS | ✔ | Company Code | BUKRS | CHAR | 4 | T001 |
SGENR | ✔ | Building Number | SGENR | CHAR | 8 | |
ADRNR | Object number (virtual object) | SOBJNR | NUMC | 10 | SANO1 | |
RGEBART | Type of building | RGEBART | NUMC | 2 | TIV5A | |
JERBBAU | Heritable building right indicator | JERBBAU | CHAR | 1 | TDO9 | |
RGEBZUST | General condition of building | RGEBZUST | NUMC | 2 | TIV83 | |
YBAUJAHR | ConstYr | VVYBAUJAHR | DATS | 8 | ||
YMODERN | Year of modernization | VVYMODERN | DATS | 8 | ||
YAUFBAU | Year of reconstruction | VVYAUFBAU | DATS | 8 | ||
DBAUBEGI | Construction start date | DBAUBEGI | DATS | 8 | ||
BBAUW13 | Building value | BBAUW13 | CURR | 11 | ||
BBAUWAKT | Current building value | BBAUWAKT | CURR | 11 | ||
BBETRIEB | Production equipment value | BBETRIEB | CURR | 11 | ||
BAUSSEN | Grounds value | BAUSSEN | CURR | 11 | ||
BSCHADEN | Structural damage value | BSCHADEN | CURR | 11 | ||
BREPSTAU | Value of repair backlog | BREPSTAU | CURR | 11 | ||
BDMCBMRA | Amount per volume unit | BDMCBMRA | CURR | 11 | ||
DBAUGENE | Building permit | DBAUGENE | DATS | 8 | ||
XBAUGENE | Note on building permit | XBAUGENE | CHAR | 30 | ||
DBEZUGSF | Ready for occupancy | DBEZUGSF | DATS | 8 | ||
DFERTIG | Completion | DFERTIG | DATS | 8 | ||
DSCHLUSS | Final Inspection | DSCHLUSS | DATS | 8 | ||
FDACHFL | Attic space | FDACHFL | DEC | 8 | ||
RDAZUST | Condition of roof | RDAZUST | NUMC | 2 | TIV83 | |
RFAZUST | Condition of facade | RFAZUST | NUMC | 2 | TIV83 | |
BUBRA | Cubic Volume | BUBRA | DEC | 11 | ||
JDENKMAL | Protection of Historical Sites | JDENKMAL | CHAR | 1 | ||
AGESCH | Dummy, since replaced: Number of floors | AGESCH | DEC | 3 | ||
AUGESCH | Number of basements | AUGESCH | DEC | 2 | ||
RARTOPT | Option rate calculation type | RARTOPT | NUMC | 1 | ||
JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | ||
RERF | Entered by | RERF | CHAR | 12 | ||
DERF | First Entered on | DERF | DATS | 8 | ||
TERF | Time of Initial Entry | 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 | ||
DAKTBEST | Date active in portfolio | DAKTBEST | DATS | 8 | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | ||
DBAUVOR | Date of planning inquiry | DBAUVOR | DATS | 8 | ||
DVORBES | Date of prior notice | DVORBES | DATS | 8 | ||
DANTBAU | Application for building permit | DANTBAU | DATS | 8 | ||
SGRUNDB | Land register number | SGRUNDB | NUMC | 8 | * | |
XGETXT | Building text | XGETXT | CHAR | 60 | ||
BEINHEITW | Assessed value of building | BEINHEITW | CURR | 11 | ||
NEINHEITW | Assessed value base year | NEINHEITW | NUMC | 4 | ||
BVERSWRT | Insurable value amount | BVERSWRT | CURR | 11 | ||
RVERSWRT | Type of insurance value | RVERSWRT | NUMC | 1 | ||
SLAGK | Location class | SLAGK | NUMC | 2 | TIV22 | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | * | |
J_OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | |
RFAKT | Conversion factor for fractional share of property | VVRFAKT | NUMC | 6 | ||
JNURJAHR | Indicator: Only regard construction date in terms of years | VVJNURJ | CHAR | 1 | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | |
DWIRTUB | Transfer usage / charges | VVDWIRTUB | DATS | 8 | ||
DVERKAUF | Sale date | VVDVERKAUF | DATS | 8 | ||
SUNUTZA | Main usage type | VVSUNART | CHAR | 8 | TIV36 | |
JUNUTZA | Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 | VVJUNUTZA | CHAR | 1 | ||
PROFL | Settlement profile | APROF | CHAR | 6 | TKB1A | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | |
DVRKPLAN | Planned sale | VVDVRKPLAN | DATS | 8 | ||
DNUTZEND | End of usage | VVDNUTZEND | DATS | 8 | ||
DFRDVON | Public funding from | VVDFRDVON | DATS | 8 | ||
DFRDBIS | Public funding to | VVDFRDBIS | DATS | 8 | ||
NSTCKLFT | Number of highest floor reached by elevator | VVNSTCKLFT | NUMC | 3 | ||
BANZGE | Number of floors | VVBANZGE | DEC | 4 | ||
RPGENR | Building no. of hierarchical superior building part | VVRPGENR | CHAR | 8 | * | |
JANLHIE | Indicator: Asset allocation valid for subordin. building | VVJANLHIE | CHAR | 1 | ||
SSTCKBIS | Uppermost Floor of a Building | VVSTCKBIS | NUMC | 3 | * | |
SLIFTBIS | Elevator to Floor in Building | VVLIFTBIS | NUMC | 3 | * | |
INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | |
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | * | |
BERGRP | Authorization group | VVBERGRP | CHAR | 40 | ||
GEMEINDE | Municipality key | VVGEMEINDE | CHAR | 8 | TIVG1 | |
EXPOSURE | Exposure (direction) of Building/ Part of building | HB_EXPOSR | CHAR | 4 | CHBSEXP | |
REFNO | External Reference Number | HB_REFNO | CHAR | 24 | ||
SGEBT | Part of Building | SGEBT | CHAR | 2 | TIV12 | |
SSTOCKW | Floor | VVSSTOCKW | NUMC | 3 | TIV37 | |
RLGESCH | Location on Floor | RLGESCH | CHAR | 2 | TIV38 | |
XSTANDNR | Number of garage / parking space | VVXSTANDNR | CHAR | 5 | ||
HB_MARKER | Single-Character Indicator | CHAR1 | CHAR | 1 | ||
VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | DATS | 8 | ||
VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | DATS | 8 | ||
CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | ||
RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | * | |
USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | CHAR | 12 | * |