SAP ABAP Table RVIOB03_ZS (RE: Building - Master Data and Additional Fields)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate
Basic Data
Table Category | INTTAB | Structure |
Structure | RVIOB03_ZS | Table Relationship Diagram |
Short Description | RE: Building - Master Data and Additional Fields |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | .INCLUDE | 0 | 0 | Real estate building master | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
4 | SWENR | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | VIOB01 | |
5 | SGENR | SGENR | SGENR | CHAR | 8 | 0 | Building Number | * | |
6 | ADRNR | SOBJNR | SOBJNR | NUMC | 10 | 0 | Object number (virtual object) | SANO1 | |
7 | RGEBART | RGEBART | SOBJART | NUMC | 2 | 0 | Type of building | TIV5A | |
8 | JERBBAU | JERBBAU | SOBJERBBAU | CHAR | 1 | 0 | Heritable building right indicator | TDO9 | |
9 | RGEBZUST | RGEBZUST | VVRZUSTAND | NUMC | 2 | 0 | General condition of building | TIV83 | |
10 | YBAUJAHR | VVYBAUJAHR | DATUM | DATS | 8 | 0 | ConstYr | ||
11 | YMODERN | VVYMODERN | DATUM | DATS | 8 | 0 | Year of modernization | ||
12 | YAUFBAU | VVYAUFBAU | DATUM | DATS | 8 | 0 | Year of reconstruction | ||
13 | DBAUBEGI | DBAUBEGI | DDAT | DATS | 8 | 0 | Construction start date | ||
14 | BBAUW13 | BBAUW13 | WRBTR | CURR | 11 | 2 | Building value | ||
15 | BBAUWAKT | BBAUWAKT | WRBTR | CURR | 11 | 2 | Current building value | ||
16 | BBETRIEB | BBETRIEB | WRBTR | CURR | 11 | 2 | Production equipment value | ||
17 | BAUSSEN | BAUSSEN | WRBTR | CURR | 11 | 2 | Grounds value | ||
18 | BSCHADEN | BSCHADEN | WRBTR | CURR | 11 | 2 | Structural damage value | ||
19 | BREPSTAU | BREPSTAU | WRBTR | CURR | 11 | 2 | Value of repair backlog | ||
20 | BDMCBMRA | BDMCBMRA | WRBTR | CURR | 11 | 2 | Amount per volume unit | ||
21 | DBAUGENE | DBAUGENE | DDAT | DATS | 8 | 0 | Building permit | ||
22 | XBAUGENE | XBAUGENE | XMBEZ | CHAR | 30 | 0 | Note on building permit | ||
23 | DBEZUGSF | DBEZUGSF | DDAT | DATS | 8 | 0 | Ready for occupancy | ||
24 | DFERTIG | DFERTIG | DDAT | DATS | 8 | 0 | Completion | ||
25 | DSCHLUSS | DSCHLUSS | DDAT | DATS | 8 | 0 | Final Inspection | ||
26 | FDACHFL | FDACHFL | DEC6_2 | DEC | 8 | 2 | Attic space | ||
27 | RDAZUST | RDAZUST | VVRZUSTAND | NUMC | 2 | 0 | Condition of roof | TIV83 | |
28 | RFAZUST | RFAZUST | VVRZUSTAND | NUMC | 2 | 0 | Condition of facade | TIV83 | |
29 | BUBRA | BUBRA | DEC8_3 | DEC | 11 | 3 | Cubic Volume | ||
30 | JDENKMAL | JDENKMAL | JANE | CHAR | 1 | 0 | Protection of Historical Sites | ||
31 | AGESCH | AGESCH | DEC2_1 | DEC | 3 | 1 | Dummy, since replaced: Number of floors | ||
32 | AUGESCH | AUGESCH | DEC2 | DEC | 2 | 0 | Number of basements | ||
33 | RARTOPT | RARTOPT | RARTOPT | NUMC | 1 | 0 | Option rate calculation type | ||
34 | JLOESCH | JLOESCH | JLOESCH | CHAR | 1 | 0 | Real Estate Deletion Indicator/Flag | ||
35 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
36 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
37 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
38 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
39 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
40 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
41 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
42 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
43 | DAKTBEST | DAKTBEST | DATUM | DATS | 8 | 0 | Date active in portfolio | ||
44 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
45 | DBAUVOR | DBAUVOR | DDAT | DATS | 8 | 0 | Date of planning inquiry | ||
46 | DVORBES | DVORBES | DDAT | DATS | 8 | 0 | Date of prior notice | ||
47 | DANTBAU | DANTBAU | DATUM | DATS | 8 | 0 | Application for building permit | ||
48 | SGRUNDB | SGRUNDB | SGRUNDB | NUMC | 8 | 0 | Land register number | * | |
49 | XGETXT | XGETXT | XLBEZ | CHAR | 60 | 0 | Building text | ||
50 | BEINHEITW | BEINHEITW | WRBTR | CURR | 11 | 2 | Assessed value of building | ||
51 | NEINHEITW | NEINHEITW | GJAHR | NUMC | 4 | 0 | Assessed value base year | ||
52 | BVERSWRT | BVERSWRT | WRBTR | CURR | 11 | 2 | Insurable value amount | ||
53 | RVERSWRT | RVERSWRT | RVERSWRT | NUMC | 1 | 0 | Type of insurance value | ||
54 | SLAGK | SLAGK | SLAGK | NUMC | 2 | 0 | Location class | TIV22 | |
55 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
56 | J_OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
57 | RFAKT | VVRFAKT | VVRFAKT | NUMC | 6 | 0 | Conversion factor for fractional share of property | ||
58 | JNURJAHR | VVJNURJ | JANE | CHAR | 1 | 0 | Indicator: Only regard construction date in terms of years | ||
59 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
60 | DWIRTUB | VVDWIRTUB | DATUM | DATS | 8 | 0 | Transfer usage / charges | ||
61 | DVERKAUF | VVDVERKAUF | DATUM | DATS | 8 | 0 | Sale date | ||
62 | SUNUTZA | VVSUNART | VVSUNART | CHAR | 8 | 0 | Main usage type | TIV36 | |
63 | JUNUTZA | VVJUNUTZA | JANE | CHAR | 1 | 0 | Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 | ||
64 | PROFL | APROF | APROF | CHAR | 6 | 0 | Settlement profile | TKB1A | |
65 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
66 | DVRKPLAN | VVDVRKPLAN | DATUM | DATS | 8 | 0 | Planned sale | ||
67 | DNUTZEND | VVDNUTZEND | DATUM | DATS | 8 | 0 | End of usage | ||
68 | DFRDVON | VVDFRDVON | DATUM | DATS | 8 | 0 | Public funding from | ||
69 | DFRDBIS | VVDFRDBIS | DATUM | DATS | 8 | 0 | Public funding to | ||
70 | NSTCKLFT | VVNSTCKLFT | NUMC3 | NUMC | 3 | 0 | Number of highest floor reached by elevator | ||
71 | BANZGE | VVBANZGE | DEC3_1 | DEC | 4 | 1 | Number of floors | ||
72 | RPGENR | VVRPGENR | SGENR | CHAR | 8 | 0 | Building no. of hierarchical superior building part | * | |
73 | JANLHIE | VVJANLHIE | JANE | CHAR | 1 | 0 | Indicator: Asset allocation valid for subordin. building | ||
74 | SSTCKBIS | VVSTCKBIS | VVSSTOCKW | NUMC | 3 | 0 | Uppermost Floor of a Building | * | |
75 | SLIFTBIS | VVLIFTBIS | VVSSTOCKW | NUMC | 3 | 0 | Elevator to Floor in Building | * | |
76 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
77 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
78 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
79 | BERGRP | VVBERGRP | VVBERGRP | CHAR | 40 | 0 | Authorization group | ||
80 | GEMEINDE | VVGEMEINDE | VVGEMEINDE | CHAR | 8 | 0 | Municipality key | TIVG1 | |
81 | .INCLUDE | 0 | 0 | ||||||
82 | .INCLU--AP | 0 | 0 | OBSOLETE: Building: Append Fields | |||||
83 | .INCLUDE | 0 | 0 | OBSOLETE: Building: Append Fields | |||||
84 | .INCLUDE | 0 | 0 | OBSOLETE: Shared Master Data Fields: Append Fields | |||||
85 | VALIDFROM | REBDOBJVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date: Object Valid From | ||
86 | VALIDTO | REBDOBJVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Object Valid To | ||
87 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
88 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | * | |
89 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | * | |
90 | XGEBARTK | XGEBARTK | XKBEZ | CHAR | 15 | 0 | Short description of building type | ||
91 | XGEBARTM | XGEBARTM | XMBEZ | CHAR | 30 | 0 | Description of building type | ||
92 | XGEBZUST | XGEBZUST | XTEXT50 | CHAR | 50 | 0 | Description of condition of building | ||
93 | XDAZUST | XDAZUST | XTEXT50 | CHAR | 50 | 0 | Condition of roof | ||
94 | XFAZUST | XFAZUST | XTEXT50 | CHAR | 50 | 0 | Condition of facade | ||
95 | XARTOPT | XARTOPT | AS4TEXT | CHAR | 60 | 0 | Option rate calculation type description | ||
96 | XLAGKM | XLAGKM | XMBEZ | CHAR | 30 | 0 | Description of location class acc.to rep.list of rents | ||
97 | XUNART | VVXUNART | XTEXT35 | CHAR | 35 | 0 | Main usage type | ||
98 | BHOEHEBIS | BHOEHEBIS | VVDEC3_1V | DEC | 4 | 1 | Number of highest storey in building | ||
99 | XSTCKBISK | XSTCKBISK | VVXSTOCKK | CHAR | 4 | 0 | Short description of highest storey of building | ||
100 | XSTCKBISM | XSTCKBISM | XKBEZ | CHAR | 15 | 0 | Short description of highest storey of building | ||
101 | XSTCKBISL | XSTCKBISL | XMBEZ | CHAR | 30 | 0 | Description of highest storey of building | ||
102 | BLIFTBIS | BLIFTBIS | VVDEC3_1V | DEC | 4 | 1 | Number of last storey reached by elevator | ||
103 | XLIFTBISK | XLIFTBISK | VVXSTOCKK | CHAR | 4 | 0 | Short description of last floor reached by elevator | ||
104 | XLIFTBISM | XLIFTBISM | XKBEZ | CHAR | 15 | 0 | Short description of last floor reached by elevator | ||
105 | XLIFTBISL | XLIFTBISL | XMBEZ | CHAR | 30 | 0 | Description of last floor reached by elevator | ||
106 | .INCLUDE | 0 | 0 | Amounts from VIOB03 in second currency | |||||
107 | SWHRKNDCUK | SWHRKNDCUK | WAERS | CUKY | 5 | 0 | Second Currency for Correspondence | * | |
108 | BAUSSENCUK | BAUSSENCUK | WRBTR | CURR | 11 | 2 | Value of grounds in second currency | ||
109 | BBAUW13CUK | BBAUW13CUK | WRBTR | CURR | 11 | 2 | Building value 1913 in second currency | ||
110 | BBAUWAKCUK | BBAUWAKCUK | WRBTR | CURR | 11 | 2 | Current building value in second currency | ||
111 | BBTRIEBCUK | BBTRIEBCUK | WRBTR | CURR | 11 | 2 | Value of production equipment in second currency | ||
112 | BDMCBMRCUK | BDMCBMRCUK | WRBTR | CURR | 11 | 2 | Amount per volume unit in second currency | ||
113 | BEINHWCUK | BEINHWCUK | WRBTR | CURR | 11 | 2 | Assessed value of building in second currency | ||
114 | BREPSTACUK | BREPSTACUK | WRBTR | CURR | 11 | 2 | Value repair backlog in second currency | ||
115 | BSCHADNCUK | BSCHADNCUK | WRBTR | CURR | 11 | 2 | Value of structural damage in second currency | ||
116 | BVRSWRTCUK | BVRSWRTCUK | WRBTR | CURR | 11 | 2 | Amount of insurable value in second currency |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RVIOB03_ZS | ADRNR | SANO1 | OBJNR | KEY | 1 | C |
2 | RVIOB03_ZS | BUKRS | T001 | BUKRS | KEY | 1 | CN |
3 | RVIOB03_ZS | GEMEINDE | TIVG1 | GEMEINDE | |||
4 | RVIOB03_ZS | GSBER | TGSB | GSBER | KEY | 1 | CN |
5 | RVIOB03_ZS | JERBBAU | TDO9 | SOBJERBBAU | |||
6 | RVIOB03_ZS | J_OBJNR | ONR00 | OBJNR | KEY | 1 | CN |
7 | RVIOB03_ZS | KOKRS | TKA01 | KOKRS | REF | C | CN |
8 | RVIOB03_ZS | PRCTR | CEPC | PRCTR | KEY | 1 | CN |
9 | RVIOB03_ZS | PROFL | TKB1A | APROF | REF | C | CN |
10 | RVIOB03_ZS | RDAZUST | TIV83 | RZUSTAND | |||
11 | RVIOB03_ZS | RFAZUST | TIV83 | RZUSTAND | |||
12 | RVIOB03_ZS | RGEBART | TIV5A | SOBJART | KEY | 1 | CN |
13 | RVIOB03_ZS | RGEBZUST | TIV83 | RZUSTAND | |||
14 | RVIOB03_ZS | SLAGK | TIV22 | SLAGK | KEY | 1 | CN |
15 | RVIOB03_ZS | SUNUTZA | TIV36 | SUNART | KEY | 1 | CN |
16 | RVIOB03_ZS | SWENR | VIOB01 | SWENR | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |