SAP ABAP Table TXI_VIOB03 (Real estate building master)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_VIOB03	Table Relationship Diagram
Short Description	Real estate building master

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	BBAUW13_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
91	BBAUWAKT_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
92	BBETRIEB_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
93	BAUSSEN_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
94	BSCHADEN_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
95	BREPSTAU_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
96	BDMCBMRA_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
97	BEINHEITW_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
98	BVERSWRT_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXI_VIOB03	ADRNR	SANO1	OBJNR	KEY	1	C
2	TXI_VIOB03	BUKRS	T001	BUKRS	KEY	1	CN
3	TXI_VIOB03	GEMEINDE	TIVG1	GEMEINDE
4	TXI_VIOB03	GSBER	TGSB	GSBER	KEY	1	CN
5	TXI_VIOB03	JERBBAU	TDO9	SOBJERBBAU
6	TXI_VIOB03	J_OBJNR	ONR00	OBJNR	KEY	1	CN
7	TXI_VIOB03	KOKRS	TKA01	KOKRS	REF	C	CN
8	TXI_VIOB03	PRCTR	CEPC	PRCTR	KEY	1	CN
9	TXI_VIOB03	PROFL	TKB1A	APROF	REF	C	CN
10	TXI_VIOB03	RDAZUST	TIV83	RZUSTAND
11	TXI_VIOB03	RFAZUST	TIV83	RZUSTAND
12	TXI_VIOB03	RGEBART	TIV5A	SOBJART	KEY	1	CN
13	TXI_VIOB03	RGEBZUST	TIV83	RZUSTAND
14	TXI_VIOB03	SLAGK	TIV22	SLAGK	KEY	1	CN
15	TXI_VIOB03	SUNUTZA	TIV36	SUNART	KEY	1	CN
16	TXI_VIOB03	SWENR	VIOB01	SWENR	KEY	1	CN

History

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