SAP ABAP Table V_BUILDING (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_BUILDING   Table Relationship Diagram
Short Description Generated Table for View    
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 MANDT MANDT MANDT CLNT 3   0   Client  
2 INTRENO RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
4 SWENR REBDBENO REBDBENO CHAR 8   0   Business Entity Number  
5 SGENR REBDBUNO REBDBUNO CHAR 8   0   Number of Building  
6 OBJNR RECAOBJNR J_OBJNR CHAR 22   0   Object Number  
7 IMKEY RECAIMKEY IMKEY CHAR 8   0   Internal Key of Real Estate Object (FI)  
8 CREATIONTYPE RECACREATIONTYPE RECACREATIONTYPE CHAR 1   0   How the Object Was Created  
9 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
10 DERF DERF DATUM DATS 8   0   First Entered on  
11 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
12 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
13 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
14 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
15 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
16 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
17 RESPONSIBLE RECARESPONSIBLE XUBNAME CHAR 12   0   Person Responsible USR02
18 USEREXCLUSIVE RECAUSEREXCLUSIVE XUBNAME CHAR 12   0   User with Exclusive Change Authorization USR02
19 AUTHGRP RECAAUTHGRP RECAAUTHGRP CHAR 40   0   Authorization Group  
20 VALIDFROM REBDOBJVALIDFROM RECADATEBEG DATS 8   0   Date: Object Valid From  
21 VALIDTO REBDOBJVALIDTO RECADATEEND DATS 8   0   Date: Object Valid To  
22 XGETXT REBDXBU RECAXLDESCRIPTION CHAR 60   0   Description of Building  
23 RGEBART RGEBART SOBJART NUMC 2   0   Type of building TIV5A
24 JERBBAU JERBBAU SOBJERBBAU CHAR 1   0   Heritable building right indicator TDO9
25 RGEBZUST RGEBZUST VVRZUSTAND NUMC 2   0   General condition of building TIV83
26 YBAUJAHR VVYBAUJAHR DATUM DATS 8   0   ConstYr  
27 YMODERN VVYMODERN DATUM DATS 8   0   Year of modernization  
28 YAUFBAU VVYAUFBAU DATUM DATS 8   0   Year of reconstruction  
29 DBAUBEGI DBAUBEGI DDAT DATS 8   0   Construction start date  
30 BBAUW13 BBAUWXOLD WRBTR CURR 11   2   OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933  
31 BBAUWX BBAUWX RECACURR CURR 15   2   Building Value  
32 BBAUWAKT BBAUWAKTXOLD WRBTR CURR 11   2   OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933  
33 BBAUWAKTX BBAUWAKTX RECACURR CURR 15   2   Current Building Value  
34 BDMCBMRA BDMCBMRA WRBTR CURR 11   2   Amount per volume unit  
35 DBAUGENE DBAUGENE DDAT DATS 8   0   Building permit  
36 XBAUGENE XBAUGENE XMBEZ CHAR 30   0   Note on building permit  
37 DBEZUGSF DBEZUGSF DDAT DATS 8   0   Ready for occupancy  
38 DFERTIG DFERTIG DDAT DATS 8   0   Completion  
39 DSCHLUSS DSCHLUSS DDAT DATS 8   0   Final Inspection  
40 JDENKMAL JDENKMAL JANE CHAR 1   0   Protection of Historical Sites  
41 DBAUVOR DBAUVOR DDAT DATS 8   0   Date of planning inquiry  
42 DVORBES DVORBES DDAT DATS 8   0   Date of prior notice  
43 DANTBAU DANTBAU DATUM DATS 8   0   Application for building permit  
44 BEINHEITW BEINHEITWXOLD WRBTR CURR 11   2   OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933  
45 BEINHEITWX BEINHEITWX RECACURR CURR 15   2   Assessed Value of Building  
46 NEINHEITW NEINHEITW GJAHR NUMC 4   0   Assessed value base year  
47 BVERSWRT BVERSWRTXOLD WRBTR CURR 11   2   OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933  
48 BVERSWRTX BVERSWRTX RECACURR CURR 15   2   Insurable Value Amount  
49 RVERSWRT RVERSWRT RVERSWRT NUMC 1   0   Type of insurance value  
50 DWIRTUB VVDWIRTUB DATUM DATS 8   0   Transfer usage / charges  
51 DVERKAUF VVDVERKAUF DATUM DATS 8   0   Sale date  
52 DVRKPLAN VVDVRKPLAN DATUM DATS 8   0   Planned sale  
53 DNUTZEND VVDNUTZEND DATUM DATS 8   0   End of usage  
54 DFRDVON VVDFRDVON DATUM DATS 8   0   Public funding from  
55 DFRDBIS VVDFRDBIS DATUM DATS 8   0   Public funding to  
56 BANZGE VVBANZGE DEC3_1 DEC 4   1   Number of floors  
57 SUNUTZA VVSUNART VVSUNART CHAR 8   0   Main usage type TIV36
58 JUNUTZA REBDJUNUTZAOBS CHAR1 CHAR 1   0   OBSOLETE: Main Usage Type  
59 SSTCKBIS VVSTCKBIS VVSSTOCKW NUMC 3   0   Uppermost Floor of a Building  
60 SLIFTBIS VVLIFTBIS VVSSTOCKW NUMC 3   0   Elevator to Floor in Building  
61 AUGESCH AUGESCH DEC2 DEC 2   0   Number of basements  
62 JANLHIE REBDJANLHIEOBS CHAR1 CHAR 1   0   OBSOLETE: Asset Assignment Also Applies for Subord. Building  
63 RLRALOC REAJRLRALOC REAJRLRALOC CHAR 6   0   Location Class TIVAJRLRALOC
64 USESRLRA REAJUSESRLRA RECABOOL CHAR 1   0   Representative List of Rents Is Used  
65 GEMEINDE VVGEMEINDE VVGEMEINDE CHAR 8   0   Municipality key TIVG1
66 REINS REINS MEINS UNIT 3   0   Unit for cubic volume T006
67 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
68 HASCOP RESCHASCOP RECABOOL CHAR 1   0   Uses Current Occupancy Principle  
69 USGFUNCTION REBDUSGFUNCTION REBDUSGFUNCTION CHAR 4   0   Function of Object TIVBDUSGFUNC
70 OBJCOND REXCCHBUCOND REXCCHBUCOND NUMC 4   0   Code of Building Status TIVXCCHCOND
71 OBJCAT REXCCHBUCATEGORY REXCCHBUCATEGORY NUMC 4   0   Building Category Code TIVXCCHKAT
72 YEARDECONSTR REXCCHBUDECONYEAR DATUM DATS 8   0   Year of Demolition  
73 AREAVALUE REXCCHBUAREA REXCCHGWRFORMATUNITFIELD DEC 10   2   Floor Area of Building in Square Meters  
74 HEATINGTYPE REXCCHBUHEATINGTYPE REXCCHBUHEATINGTYPE NUMC 4   0   Code of Heating Type TIVXCCHHEAT
75 ENERGYHEAT REXCCHBUENERGYSOURCEH REXCCHBUENERGYSOURCE NUMC 4   0   Energy Carrier of Heating TIVXCCHGENSRC
76 ENERGYWATER REXCCHBUENERGYSOURCEW REXCCHBUENERGYSOURCE NUMC 4   0   Energy Carrier of Hot Water TIVXCCHGENSRC
77 HOTWATERSUPPLY REXCCHBUHOTWATER RECABOOL CHAR 1   0   Central Hot Water Supply  
78 POWERCONSUM REXCCHBUPOWERCONSUMPTION REXCCHGWRFORMATUNITFIELD DEC 10   2   Power Consumption of Building (in kWh)  
79 GLAZING REXCCHBUGLAZING TEXT15 CHAR 15   0   Glazing Type  
80 ADMINNO REXCCHBUADMINNO REXCCHBUADMINNO CHAR 12   0   Administrative Building Number  
81 ADMINXGETXT REXCCHBUADMINXBU RECAXLDESCRIPTION CHAR 60   0   Building Name  
82 GEMEINDECH RELMLRDISTRICT RELMLRDISTRICT CHAR 6   0   Land Register District  
83 BANZGECH VVBANZGE DEC3_1 DEC 4   1   Number of floors  
84 SSTCKBISCH VVSTCKBIS VVSSTOCKW NUMC 3   0   Uppermost Floor of a Building  
85 SLIFTBISCH VVLIFTBIS VVSSTOCKW NUMC 3   0   Elevator to Floor in Building  
86 AUGESCHCH AUGESCH DEC2 DEC 2   0   Number of basements  
87 SECCO SECCO SECCO CHAR 4   0   Section Code  
88 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place  
89 REPKOCH REXCJPREPKOCH REXCJPREPKOCH CHAR 1   0   Kind of Change  
90 BDCONSTR REXCJPBDCONSTR REXCJPBDCONST CHAR 1   0   Construction Status  
91 BDFIREPREV REXCJPBDFIREPREV CHAR8 CHAR 8   0   Fire Fighting Method Number  
92 BDOTHOW REXCJPBDOTHOW INT4 INT4 10   0   Number of Another Owners in the Same Building  
93 BDOWNSHIP REXCJPBDOWNSHIP REXCJPBDOWNSH CHAR 1   0   Building Ownership Status  
94 KOCHDATE REXCJPKOCHDATE RECADATE DATS 8   0   Date of Change in Kind of Change  
95 VPT REXCPTVPT_NOSIGN REXCPTVPT_NOSIGN CURR 15   2   Property Taxable Value  
96 CURRENCY WAERS WAERS CUKY 5   0   Currency Key TCURC
97 CONDK REXCPTRACONS   CHAR 4   0   Conservation Level TIVXCPTRACONS
98 INTRENOBE RECAINTRENO RECAINTRENO CHAR 13   0   Internal Key of Real Estate Object  
99 SINSTBEZ SINSTBEZ SINSTBEZ NUMC 5   0   Maintenance district TIV16
100 SVERKEHR SVERKEHR SVERKEHR CHAR 1   0   Transport Connections of Business Entity TIV44
101 XWETEXT REBDXBE RECAXLDESCRIPTION CHAR 60   0   Business Entity Name  
102 SLAGEWE SLAGEWE SLAGEWE NUMC 4   0   Business entity location number TIV10
103 SOBJLAGE RESOBJLAGE RESOBJLAGE NUMC 2   0   Indicator: District Location of Object TIV45
104 RLRA REAJRLRA REAJRLRA CHAR 6   0   Representative List of Rents TIVAJRLRA
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_BUILDING BUKRS T001 BUKRS KEY 1 CN
2 V_BUILDING CONDK TIVXCPTRACONS CONSLEVEL    
3 V_BUILDING CURRENCY TCURC WAERS    
4 V_BUILDING ENERGYHEAT TIVXCCHGENSRC ENERGYSRC KEY    
5 V_BUILDING ENERGYWATER TIVXCCHGENSRC ENERGYSRC KEY    
6 V_BUILDING GEMEINDE TIVG1 GEMEINDE REF C CN
7 V_BUILDING HEATINGTYPE TIVXCCHHEAT HEATINGTYPE KEY    
8 V_BUILDING JERBBAU TDO9 SOBJERBBAU REF 1 CN
9 V_BUILDING OBJCAT TIVXCCHKAT BCATEGORY KEY    
10 V_BUILDING OBJCOND TIVXCCHCOND BCOND KEY    
11 V_BUILDING REINS T006 MSEHI REF C CN
12 V_BUILDING RESPONSIBLE USR02 BNAME REF 1 CN
13 V_BUILDING RGEBART TIV5A SOBJART REF C CN
14 V_BUILDING RGEBZUST TIV83 RZUSTAND REF C CN
15 V_BUILDING RLRA TIVAJRLRA RLRA REF C CN
16 V_BUILDING RLRALOC TIVAJRLRALOC RLRALOC REF C CN
17 V_BUILDING SINSTBEZ TIV16 SINSTBEZ REF C CN
18 V_BUILDING SLAGEWE TIV10 SLAGEWE REF C CN
19 V_BUILDING SOBJLAGE TIV45 SOBJLAGE REF C CN
20 V_BUILDING SUNUTZA TIV36 SUNART REF C CN
21 V_BUILDING SVERKEHR TIV44 SVERKEHR REF C CN
22 V_BUILDING USEREXCLUSIVE USR02 BNAME REF C CN
23 V_BUILDING USGFUNCTION TIVBDUSGFUNC USGFUNCTION REF C CN
24 V_BUILDING WAERS TCURC WAERS REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in