SAP ABAP Table RECP_OI_DOC_BU_DETAIL (Basic Data of Building)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_XX (Package) RE: Obsolete Objects (Do Not Delete!!!)

Basic Data

Table Category	INTTAB	Structure
Structure	RECP_OI_DOC_BU_DETAIL	Table Relationship Diagram
Short Description	Basic Data of Building

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	SWENR	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
3	SGENR	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building
4	REALVALIDFROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
5	REALVALIDTO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
6	XGETXT	☐	REBDXBU	RECAXLDESCRIPTION	CHAR	60	0	Description of Building
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	BDMCBMRA	☐	BDMCBMRA	WRBTR	CURR	11	2	Amount per volume unit
17	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
18	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
19	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
20	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
21	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
22	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
23	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
24	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
25	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
26	BEINHEITW	☐	BEINHEITW	WRBTR	CURR	11	2	Assessed value of building
27	NEINHEITW	☐	NEINHEITW	GJAHR	NUMC	4	0	Assessed value base year
28	BVERSWRT	☐	BVERSWRT	WRBTR	CURR	11	2	Insurable value amount
29	RVERSWRT	☐	RVERSWRT	RVERSWRT	NUMC	1	0	Type of insurance value
30	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
31	DVERKAUF	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
32	DVRKPLAN	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
33	DNUTZEND	☐	VVDNUTZEND	DATUM	DATS	8	0	End of usage
34	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
35	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
36	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
37	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
38	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
39	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	TIV37
40	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	TIV37
41	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
42	JANLHIE	☐	VVJANLHIE	JANE	CHAR	1	0	Indicator: Asset allocation valid for subordin. building
43	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
44	RLRALOC	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	*
45	USESRLRA	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
46	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
47	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	*
48	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
49	HASCOP	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
50	XWETEXT	☐	REBDXBE	RECAXLDESCRIPTION	CHAR	60	0	Business Entity Name
51	XUNART	☐	VVXUNART	XTEXT35	CHAR	35	0	Main usage type
52	KTEXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
53	XGEBZUST	☐	XGEBZUST	XTEXT50	CHAR	50	0	Description of condition of building
54	XGEMEINDE	☐	VVXGEMEINDE	VVXGEMEINDE	CHAR	50	0	Name of municipality
55	XKREIS	☐	VVXKREIS	VVXKREIS	CHAR	30	0	Name of district
56	XREGIO	☐	VVXREGIO	VVXREGIO	CHAR	30	0	Name of federal state
57	RLRA	☐	REAJRLRA	REAJRLRA	CHAR	6	0	Representative List of Rents	TIVAJRLRA
58	XRLRA	☐	REAJXRLRA	RECAXLDESCRIPTION	CHAR	60	0	Description of Representative List of Rents
59	XRLRALOC	☐	REAJXRLRALOC	RECAXLDESCRIPTION	CHAR	60	0	Name of Location Class
60	XDAZUST	☐	VVXZUSTTXT	XTEXT50	CHAR	50	0	Description of condition of a real estate object
61	XFAZUST	☐	VVXZUSTTXT	XTEXT50	CHAR	50	0	Description of condition of a real estate object
62	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
63	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
64	XSTOCKO	☐	XGKBEZ	XKBEZ	CHAR	15	0	Short Description for Floor
65	XSTOCKL	☐	XGKBEZ	XKBEZ	CHAR	15	0	Short Description for Floor

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECP_OI_DOC_BU_DETAIL	BUKRS	T001	BUKRS	KEY	1	CN
2	RECP_OI_DOC_BU_DETAIL	GEMEINDE	TIVG1	GEMEINDE
3	RECP_OI_DOC_BU_DETAIL	JERBBAU	TDO9	SOBJERBBAU
4	RECP_OI_DOC_BU_DETAIL	RGEBART	TIV5A	SOBJART	KEY	1	CN
5	RECP_OI_DOC_BU_DETAIL	RGEBZUST	TIV83	RZUSTAND
6	RECP_OI_DOC_BU_DETAIL	RLRA	TIVAJRLRA	RLRA	REF	C	CN
7	RECP_OI_DOC_BU_DETAIL	SLIFTBIS	TIV37	SSTOCKW	REF	C	CN
8	RECP_OI_DOC_BU_DETAIL	SSTCKBIS	TIV37	SSTOCKW	REF	C	CN
9	RECP_OI_DOC_BU_DETAIL	SUNUTZA	TIV36	SUNART	KEY	1	CN

History

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