SAP ABAP Table VIRPS405 (Building)

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIRPS405	Table Relationship Diagram
Short Description	Building

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	BUKRS_01	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	GSBER_02	☑	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
10	SWENR_03	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
11	SGENR_04	☑	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
12	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
14	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
15	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
16	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
17	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
18	USRUNIT1	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
19	USRUNIT2	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
20	USRCUKY1	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
21	USRCUKY2	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
22	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
23	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
24	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
25	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
26	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
27	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
28	ANZGE	☐	VVAGE	DEC6	DEC	6	0	No. of buildings
29	USR02	☐	USRCHAR101	USRCHAR10	CHAR	10	0	User-defined field 1 for 10 characters
30	USR03	☐	USRCHAR102	USRCHAR10	CHAR	10	0	User-defined field 2 for 10 characters
31	USR00	☐	USRCHAR201	USRCHAR20	CHAR	20	0	User-defined field 1 for 20 characters
32	USR01	☐	USRCHAR202	USRCHAR20	CHAR	20	0	User field 2 for 20 characters
33	USR08	☐	USRDATE1	USRDATE	DATS	8	0	User field 1 for date
34	USR09	☐	USRDATE2	USRDATE	DATS	8	0	User field 2 for date
35	USR10	☐	USRFLAG1	FLAG	CHAR	1	0	User field 1 indicator for evaluations
36	USR11	☐	USRFLAG2	FLAG	CHAR	1	0	User field 2 indicator for evaluations
37	USR04	☐	USRQUAN131	USRQUAN13	QUAN	13	3	User field 1 for set (length 10,3)
38	USR05	☐	USRQUAN132	USRQUAN13	QUAN	13	3	User field 2 for set (length 10.3)
39	USR06	☐	USRCURR131	USRCURR13	CURR	13	3	User field 1 for values (length 10.3)
40	USR07	☐	USRCURR132	USRCURR13	CURR	13	3	User field 2 for values (length 10.3)
41	FQMFLART	☐	VVBFLART	VVBFLART	QUAN	14	4	Area of area type
42	DSFLART	☐	VVDSFLART	DATS	DATS	8	0	Area: effective from
43	SFLART	☐	SFLART	SFLART	NUMC	4	0	Area type	TIV08
44	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
45	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	*
46	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
47	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
48	STTXT_EXT	☐	VVXSTXTEXT	CHAR40	CHAR	40	0	Status: Set by user
49	STTXT_INT	☐	VVXSTTXTIN	CHAR40	CHAR	40	0	Status: Set by system
50	DVERKAUF	☐	VVDVERKAU2	DATUM	DATS	8	0	Date: Sale
51	DVRKPLAN	☐	VVDVRKPLA2	DATUM	DATS	8	0	Date: Planned sale
52	XUNART	☐	VVXUNART	XTEXT35	CHAR	35	0	Main usage type
53	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
54	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
55	XGEBART	☐	XGEBART	XTEXT50	CHAR	50	0	Type of building
56	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	*
57	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
58	XGEBZUST	☐	XGEBZUST	XTEXT50	CHAR	50	0	Description of condition of building
59	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
60	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
61	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
62	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
63	BBAUW13	☐	BBAUW13	WRBTR	CURR	11	2	Building value
64	BBAUWAKT	☐	BBAUWAKT	WRBTR	CURR	11	2	Current building value
65	BBETRIEB	☐	BBETRIEB	WRBTR	CURR	11	2	Production equipment value
66	BAUSSEN	☐	BAUSSEN	WRBTR	CURR	11	2	Grounds value
67	BSCHADEN	☐	BSCHADEN	WRBTR	CURR	11	2	Structural damage value
68	BREPSTAU	☐	BREPSTAU	WRBTR	CURR	11	2	Value of repair backlog
69	BDMCBMRA	☐	BDMCBMRA	WRBTR	CURR	11	2	Amount per volume unit
70	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
71	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
72	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
73	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
74	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
75	FDACHFL	☐	FDACHFL	DEC6_2	DEC	8	2	Attic space
76	RDAZUST	☐	RDAZUST	VVRZUSTAND	NUMC	2	0	Condition of roof	TIV83
77	XDAZUST	☐	XDAZUST	XTEXT50	CHAR	50	0	Condition of roof
78	RFAZUST	☐	RFAZUST	VVRZUSTAND	NUMC	2	0	Condition of facade	TIV83
79	XFAZUST	☐	XFAZUST	XTEXT50	CHAR	50	0	Condition of facade
80	BUBRA	☐	BUBRA	DEC8_3	DEC	11	3	Cubic Volume
81	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
82	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
83	DAKTBEST	☐	DAKTBEST	DATUM	DATS	8	0	Date active in portfolio
84	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
85	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
86	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
87	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	VIGBUCH
88	XGBVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
89	XGETXT	☐	XGETXT	XLBEZ	CHAR	60	0	Building text
90	BEINHEITW	☐	BEINHEITW	WRBTR	CURR	11	2	Assessed value of building
91	NEINHEITW	☐	NEINHEITW	GJAHR	NUMC	4	0	Assessed value base year
92	BVERSWRT	☐	BVERSWRT	WRBTR	CURR	11	2	Insurable value amount
93	RVERSWRT	☐	RVERSWRT	RVERSWRT	NUMC	1	0	Type of insurance value
94	XVERSWRT	☐	XVERSWRT	TEXT25	CHAR	25	0	Type of insurance value
95	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
96	XMIETSP	☐	VVXMIETSP	CHAR15	CHAR	15	0	Representative list of rents: allocation
97	SLAGK	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
98	XLAGK	☐	XLAGK	XMBEZ	CHAR	30	0	Description of location class for rep.list of rents
99	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
100	JNURJAHR	☐	VVJNURJ	JANE	CHAR	1	0	Indicator: Only regard construction date in terms of years
101	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
102	PROFL	☐	APROF	APROF	CHAR	6	0	Settlement profile	TKB1A
103	DNUTZEND	☐	VVDNUTZEND	DATUM	DATS	8	0	End of usage
104	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
105	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
106	NSTCKLFT	☐	VVNSTCKLF2	CHAR3	CHAR	3	0	Number of highest floor reached by elevator
107	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
108	RPGENR	☐	VVRPGENR	SGENR	CHAR	8	0	Building no. of hierarchical superior building part	VIOB03
109	XPGENR	☐	XGETXT	XLBEZ	CHAR	60	0	Building text
110	SMERKMA	☐	SMERKMA	SMERKMA	NUMC	3	0	Fixtures and Fittings Characteristics	TIV71
111	XMERKMA	☐	XMERKMA	XTEXT50	CHAR	50	0	Description of characteristic
112	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
113	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIRPS405	ANLN1	ANLH	ANLN1
2	VIRPS405	ANLN2	ANLA	ANLN2
3	VIRPS405	BUKRS	T001	BUKRS
4	VIRPS405	BUKRS_01	T001	BUKRS
5	VIRPS405	FEINS	T006	MSEHI
6	VIRPS405	GSBER	TGSB	GSBER
7	VIRPS405	GSBER_02	TGSB	GSBER
8	VIRPS405	MANDT	T000	MANDT
9	VIRPS405	OBJNR	ONR00	OBJNR
10	VIRPS405	PERIV	T009	PERIV
11	VIRPS405	PROFL	TKB1A	APROF
12	VIRPS405	RDAZUST	TIV83	RZUSTAND
13	VIRPS405	REINS	T006	MSEHI
14	VIRPS405	RFAZUST	TIV83	RZUSTAND
15	VIRPS405	RGEBART	TIV5A	SOBJART
16	VIRPS405	RGEBZUST	TIV83	RZUSTAND
17	VIRPS405	RPGENR	VIOB03	SGENR
18	VIRPS405	SFLART	TIV08	SFLART
19	VIRPS405	SGENR	VIOB03	SGENR
20	VIRPS405	SGENR_04	VIOB03	SGENR
21	VIRPS405	SGRUNDB	VIGBUCH	SGRUNDB
22	VIRPS405	SLAGK	TIV22	SLAGK
23	VIRPS405	SMERKMA	TIV71	SMERKMA
24	VIRPS405	SMIETSP	TIV20	SMIETSP
25	VIRPS405	SUNUTZA	TIV36	SUNART
26	VIRPS405	SWENR	VIOB01	SWENR
27	VIRPS405	SWENR_03	VIOB01	SWENR
28	VIRPS405	USRCUKY1	TCURC	WAERS
29	VIRPS405	USRCUKY2	TCURC	WAERS
30	VIRPS405	USRUNIT1	T006	MSEHI
31	VIRPS405	USRUNIT2	T006	MSEHI
32	VIRPS405	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in