SAP ABAP Table S405 (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	S405	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	☐	USRQUAN151	USRQUAN15	QUAN	15	3	User Field 1 for Set (Length 12,3)
38	USR05	☐	USRQUAN152	USRQUAN15	QUAN	15	3	User Field 2 for Set (Length 12,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	☐	VVXGEBART	XTEXT50	CHAR	50	0	Building: Building type
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	☐	VVXGEBZUST	XTEXT50	CHAR	50	0	Condition: general condition
59	YBAUJAHR	☐	VVYBAUJAH2	DATUM	DATS	8	0	Year: construction year
60	YMODERN	☐	VVYMODERN2	DATUM	DATS	8	0	Year: modernization
61	YAUFBAU	☐	VVYAUFBAU2	DATUM	DATS	8	0	Year: reconstruction
62	DBAUBEGI	☐	VVDBAUBEGI	DDAT	DATS	8	0	Date: building start
63	BBAUW13	☐	VVBBAUW13	WRBTR_SUM	CURR	15	2	Value: Building value 1913
64	BBAUWAKT	☐	VVBBAUWAKT	WRBTR_SUM	CURR	15	2	Value: current building value
65	BBETRIEB	☐	VVBBETRIE2	WRBTR_SUM	CURR	15	2	Value: facilities
66	BAUSSEN	☐	VVBAUSSEN	WRBTR_SUM	CURR	15	2	Value: Grounds
67	BSCHADEN	☐	VVBSCHADEN	WRBTR_SUM	CURR	15	2	Value: Structural damage
68	BREPSTAU	☐	VVBREPSTAU	WRBTR_SUM	CURR	15	2	Value: Repair backlog
69	BDMCBMRA	☐	BDMCBMRA	WRBTR	CURR	11	2	Amount per volume unit
70	DBAUGENE	☐	VVDBAUGENE	DDAT	DATS	8	0	Building permit: date
71	XBAUGENE	☐	VVXBAUGENE	XMBEZ	CHAR	30	0	Building permit: note
72	DBEZUGSF	☐	VVDBEZUGSF	DDAT	DATS	8	0	Date: Ready for occupancy
73	DFERTIG	☐	VVDFERTIG	DDAT	DATS	8	0	Date: Completion
74	DSCHLUSS	☐	VVDSCHLUS2	DDAT	DATS	8	0	Date: 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	☐	VVXDAZUST	CHAR30	CHAR	30	0	Condition: roof
78	RFAZUST	☐	RFAZUST	VVRZUSTAND	NUMC	2	0	Condition of facade	TIV83
79	XFAZUST	☐	VVXFAZUST	CHAR30	CHAR	30	0	Condition: facade
80	BUBRA	☐	BUBRA12	REDEC12_3	DEC	15	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	☐	VVDBAUVOR	DDAT	DATS	8	0	Date: Planning inquiry
85	DVORBES	☐	VVDVORBES	DDAT	DATS	8	0	Date: prior notice
86	DANTBAU	☐	VVDANTBAU	DATUM	DATS	8	0	Date: Building permit application
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	☐	VVBEINHW2	WRBTR_SUM	CURR	15	2	Assessed value: value
91	NEINHEITW	☐	VVNEINHW	GJAHR	NUMC	4	0	Assessed value: base year
92	BVERSWRT	☐	VVBVERSWRT	WRBTR_SUM	CURR	15	2	Insurable value: amount
93	RVERSWRT	☐	RVERSWRT	RVERSWRT	NUMC	1	0	Type of insurance value
94	XVERSWRT	☐	VVXVERSWRT	TEXT25	CHAR	25	0	Insurance value type
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	☐	VVXLAGK	XMBEZ	CHAR	30	0	Representative list of rents: locat.class
99	RFAKT	☐	VVXFAKT	CHAR6	CHAR	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	☐	VVDWIRTUB2	DATUM	DATS	8	0	Date: Transfer usage/charges
102	PROFL	☐	APROF	APROF	CHAR	6	0	Settlement profile	TKB1A
103	DNUTZEND	☐	VVDNUTZEN2	DATUM	DATS	8	0	Date: end of usage
104	DFRDVON	☐	VVDFRDVON2	DATUM	DATS	8	0	Date: Public funding from
105	DFRDBIS	☐	VVDFRDBIS2	DATUM	DATS	8	0	Date: Public funding to
106	NSTCKLFT	☐	VVNSTCKLF2	CHAR3	CHAR	3	0	Number of highest floor reached by elevator
107	BANZGE	☐	VVBANZGE2	DEC5_1	DEC	6	1	Number of floors
108	RPGENR	☐	VVRPGENR	SGENR	CHAR	8	0	Building no. of hierarchical superior building part	VIOB03
109	SMERKMA	☐	SMERKMA	SMERKMA	NUMC	3	0	Fixtures and Fittings Characteristics	TIV71
110	XMERKMA	☐	VVXMERKMA	XTEXT30	CHAR	30	0	Characteristic
111	ANLN1	☐	VVANLN1	ANLN1	CHAR	12	0	Asset: main number	ANLH
112	ANLN2	☐	VVANLN2	ANLN2	CHAR	4	0	Asset: Subnumber	ANLA
113	JANLHIE	☐	VVJANLHIE	JANE	CHAR	1	0	Indicator: Asset allocation valid for subordin. building
114	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
115	VVSAOGR	☐	VVSAOGR	VVSAOGR	NUMC	3	0	Group of object characteristics	*
116	VVXAOGR	☐	VVXAOGR	XTEXT30	CHAR	30	0	Group of object characteristics
117	VVSAOB	☐	VVSAOB	VVSAOB	NUMC	3	0	Number of Object Characteristic	*
118	VVXAOB	☐	VVXAOB	XTEXT30	CHAR	30	0	Number of Object Characteristic
119	VVSAUSP	☐	VVSAUSP	VVSAUSP	NUMC	3	0	Number of object characteristic value	*
120	VVXAUSP	☐	VVXAUSP	XTEXT30	CHAR	30	0	Number of object characteristic value
121	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
122	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	*
123	XGEMEINDE	☐	VVXGEMEINDE	VVXGEMEINDE	CHAR	50	0	Name of municipality
124	XKREIS	☐	VVXKREIS	VVXKREIS	CHAR	30	0	Name of district
125	XREGIO	☐	VVXREGIO	VVXREGIO	CHAR	30	0	Name of federal state
126	XERBBAU	☐	VVXERBBAU	XTEXT30	CHAR	30	0	Heritable building right
127	.INCLUDE	☐				0	0	Customer Fields LIS: Include for Infostructure
128	DUMMYFIELD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
129	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in