SAP ABAP Table BAPI_RE_BUILDING (Buildings)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-BD (Application Component) Basic Data
     ⤷ RE_BD_BU (Package) RE: Building (Master Data)

Basic Data

Table Category	INTTAB	Structure
Structure	BAPI_RE_BUILDING	Table Relationship Diagram
Short Description	Buildings

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	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	BUSINESS_ENTITY	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
3	BUILDING	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building
4	IDENT_OBJECT_TYPE	☐	RECAIDENTTYPE	J_OBART	CHAR	2	0	ID Part of Object Type, such as "IS" (Real Estate Contract)	TBO00
5	IDENT_KEY	☐	RECAIDENTKEY	CHAR45	CHAR	45	0	ID Part Key, for example "1000/123"
6	CREATION_USER	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
7	CREATION_DATE	☐	DERF	DATUM	DATS	8	0	First Entered on
8	CREATION_TIME	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
9	LASTCHANGE_USER	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	LASTCHANGE_DATE	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	LASTCHANGE_TIME	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	BUILDING_TEXT	☐	REBDXBU	RECAXLDESCRIPTION	CHAR	60	0	Description of Building
13	BUILDING_TYPE	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
14	BUILDING_CONDITION	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
15	CONSTRUCTION_YEAR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
16	MODERNIZATION_YEAR	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
17	RECONSTRUCTION_YEAR	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
18	BEGIN_CONSTRUCTION_YEAR	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
19	READY_FOR_OCCUPANCY_DATE	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
20	COMPLETION_DATE	☐	DFERTIG	DDAT	DATS	8	0	Completion
21	FINAL_INSPECTION_DATE	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
22	PLANNING_INQUIRY_DATE	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
23	PRIOR_NOTICE_DATE	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
24	BUILDING_PERMIT_APPLIC_DATE	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
25	BUILDING_PERMIT_DATE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
26	TRANSF_USE_AND_ENCUMBR_DATE	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
27	SALE_DATE	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
28	PLANNED_SALE_DATE	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
29	USAGE_END_DATE	☐	VVDNUTZEND	DATUM	DATS	8	0	End of usage
30	BUILDING_PERMIT_NOTE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
31	BUILDING_VALUE	☐	REBDBAPIVALBUILD	BAPICURR	DEC	23	4	BAPI: Building Value
32	CURRENT_BUILDING_VALUE	☐	REBDBAPIVALBUILDCURR	BAPICURR	DEC	23	4	BAPI: Current Building Value
33	AMOUNT_PER_VOLUME	☐	REBDBAPIVALAMOUNTVOLUME	BAPICURR	DEC	23	4	BAPI: Amount per Unit of Volume
34	HAS_HIST_SITE_PROTECTION	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
35	ASSESSMENT_VALUE	☐	REBDBAPIVALASSESSMENT	BAPICURR	DEC	23	4	BAPI: Assessed Value of Building
36	ASSESSMENT_VALUE_YEAR	☐	NEINHEITW	GJAHR	NUMC	4	0	Assessed value base year
37	INSURANCE_VALUE	☐	REBDBAPIVALINSURANCE	BAPICURR	DEC	23	4	BAPI: Amount of Insurable Value
38	INSURANCE_VALUE_TYPE	☐	RVERSWRT	RVERSWRT	NUMC	1	0	Type of insurance value
39	HERITABLE_BLDG_RIGHT_IND	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
40	REPR_LIST_OF_RENTS	☐	REAJRLRA	REAJRLRA	CHAR	6	0	Representative List of Rents	TIVAJRLRA
41	LOCATION_CLASS	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	TIVAJRLRALOC
42	MAIN_USAGE_TYPE	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
43	PUBLIC_FUNDING_FROM	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
44	PUBLIC_FUNDING_TO	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
45	FLOORS	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
46	BASEMENTS	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
47	TOP_FLOOR	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	TIV37
48	ELEVATOR_TO_FLOOR	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	TIV37
49	MUNICIPALITY_KEY	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
50	HAS_CURR_OCC_PRINC	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
51	UNIT_VOLUME	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
52	UNIT_VOLUME_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
53	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
54	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
55	AUTHORIZATION_GROUP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
56	OBJECT_VALID_FROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
57	OBJECT_VALID_TO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
58	REAL_VALID_FROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
59	REAL_VALID_TO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
60	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
61	STAT_PROF	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	TJ20
62	MANDATE_OBJECT_ID	☐	REMMBUSOBJIDMN	CHAR45	CHAR	45	0	ID of Mandate Object in Mandate Company Code
63	MANDATE_MNG_OBJECT_ID	☐	REMMBUSOBJIDMNG	CHAR45	CHAR	45	0	ID of Mandate Object in Manager Company Code
64	MANDATE_CR_OBJECT_ID	☐	REMMBUSOBJIDCR	CHAR45	CHAR	45	0	ID of Mandate Object in Condominium Owner Company Code
65	USES_REPR_LIST_OF_RENTS	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
66	FUNCTION	☐	REBDUSGFUNCTION	REBDUSGFUNCTION	CHAR	4	0	Function of Object	TIVBDUSGFUNC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI_RE_BUILDING	BUILDING_CONDITION	TIV83	RZUSTAND	REF	C	CN
2	BAPI_RE_BUILDING	BUILDING_TYPE	TIV5A	SOBJART	REF	C	CN
3	BAPI_RE_BUILDING	ELEVATOR_TO_FLOOR	TIV37	SSTOCKW	REF	C	CN
4	BAPI_RE_BUILDING	FUNCTION	TIVBDUSGFUNC	USGFUNCTION	REF	C	CN
5	BAPI_RE_BUILDING	HERITABLE_BLDG_RIGHT_IND	TDO9	SOBJERBBAU	REF	C	CN
6	BAPI_RE_BUILDING	IDENT_OBJECT_TYPE	TBO00	OBART	REF	1	CN
7	BAPI_RE_BUILDING	LOCATION_CLASS	TIVAJRLRALOC	RLRALOC	REF	C	CN
8	BAPI_RE_BUILDING	MAIN_USAGE_TYPE	TIV36	SUNART	REF	C	CN
9	BAPI_RE_BUILDING	MUNICIPALITY_KEY	TIVG1	GEMEINDE	REF	C	CN
10	BAPI_RE_BUILDING	REPR_LIST_OF_RENTS	TIVAJRLRA	RLRA	REF	C	CN
11	BAPI_RE_BUILDING	STAT_PROF	TJ20	STSMA	REF	C	CN
12	BAPI_RE_BUILDING	TOP_FLOOR	TIV37	SSTOCKW	REF	C	CN
13	BAPI_RE_BUILDING	UNIT_VOLUME	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	200