SAP ABAP Table S406 (Rental units)

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	S406	Table Relationship Diagram
Short Description	Rental units

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	SGRNR_04	☑	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
12	SGENR_05	☑	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
13	SMENR_06	☑	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
14	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
16	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
17	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
18	SGENR	☐	VVSGENR	SGENR	CHAR	8	0	Building: number	VIOB03
19	SMENR	☐	VVSMENR	SMENR	CHAR	8	0	Rental unit: number	VIMI01
20	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
21	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
22	USRUNIT1	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
23	USRUNIT2	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
24	USRCUKY1	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
25	USRCUKY2	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
26	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
27	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
28	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
29	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
30	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
31	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
32	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
33	ANZME	☐	VVAME	DEC6	DEC	6	0	Number of rental units
34	USR02	☐	USRCHAR101	USRCHAR10	CHAR	10	0	User-defined field 1 for 10 characters
35	USR03	☐	USRCHAR102	USRCHAR10	CHAR	10	0	User-defined field 2 for 10 characters
36	USR00	☐	USRCHAR201	USRCHAR20	CHAR	20	0	User-defined field 1 for 20 characters
37	USR01	☐	USRCHAR202	USRCHAR20	CHAR	20	0	User field 2 for 20 characters
38	USR08	☐	USRDATE1	USRDATE	DATS	8	0	User field 1 for date
39	USR09	☐	USRDATE2	USRDATE	DATS	8	0	User field 2 for date
40	USR10	☐	USRFLAG1	FLAG	CHAR	1	0	User field 1 indicator for evaluations
41	USR11	☐	USRFLAG2	FLAG	CHAR	1	0	User field 2 indicator for evaluations
42	USR04	☐	USRQUAN151	USRQUAN15	QUAN	15	3	User Field 1 for Set (Length 12,3)
43	USR05	☐	USRQUAN152	USRQUAN15	QUAN	15	3	User Field 2 for Set (Length 12,3)
44	USR06	☐	USRCURR131	USRCURR13	CURR	13	3	User field 1 for values (length 10.3)
45	USR07	☐	USRCURR132	USRCURR13	CURR	13	3	User field 2 for values (length 10.3)
46	FBEZUG	☐	VVFBEZUG	VVFBEZUG	QUAN	15	2	Reference area for calculation of amounts per area unit
47	FQMFLART	☐	VVBFLART	VVBFLART	QUAN	14	4	Area of area type
48	DSFLART	☐	VVDSFLART	DATS	DATS	8	0	Area: effective from
49	SFLART	☐	SFLART	SFLART	NUMC	4	0	Area type	TIV08
50	KOSTL	☐	VVXKOSTL	KOSTL	CHAR	10	0	Cost center: name	*
51	DATAB	☐	VVDKOSTL	DATUM	DATS	8	0	Cost center: effective from_
52	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	*
53	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
54	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
55	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
56	STTXT_EXT	☐	VVXSTXTEXT	CHAR40	CHAR	40	0	Status: Set by user
57	STTXT_INT	☐	VVXSTTXTIN	CHAR40	CHAR	40	0	Status: Set by system
58	XMETXT	☐	VVXMETXT	XMBEZ	CHAR	30	0	Text for rental unit
59	SKOART	☐	VVSKOART	SKOART	NUMC	4	0	Condition: Type	TZK01
60	BKOND	☐	VVBKOND	WRTV7	CURR	13	2	Condition: amount
61	DGULTAB	☐	VVDKOND	DDAT	DATS	8	0	Condition: effective from
62	SNUNR	☐	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	TIV01
63	XNUNR	☐	VVXNUNR	CHAR30	CHAR	30	0	Rental unit usage type (text)
64	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
65	SRAART	☐	SRAART	SRAART	NUMC	2	0	Room type	TIV09
66	BRAART	☐	VVBRAARTA	DEC12	DEC	12	0	Number of rooms
67	SMERKMA	☐	SMERKMA	SMERKMA	NUMC	3	0	Fixtures and Fittings Characteristics	TIV71
68	XMERKMA	☐	VVXMERKMA	XTEXT30	CHAR	30	0	Characteristic
69	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
70	XSTOCKK	☐	VVXSTOCKK2	VVXSTOCKK	CHAR	4	0	Floor (short text)
71	XSTOCKW	☐	VVXSTOCKW	CHAR15	CHAR	15	0	Floor (text)
72	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
73	XLGESCH	☐	VVXLGESCH	CHAR15	CHAR	15	0	Location in floor (text)
74	DBEZU	☐	VVDBEZU	DDAT	DATS	8	0	Date: First usage
75	SABRG	☐	VVSABRG2	SABRG	NUMC	4	0	Apportionment unit: type	TIV07
76	DGAB	☐	VVDGAB2	DDAT	DATS	8	0	Apportionment unit: effective from
77	BABRE	☐	VVBUMLEINH	VVBUMLEINH	QUAN	6	2	Apportionment units
78	TXT04	☐	VVXJ_TXT04	CHAR04	CHAR	4	0	Occupancy type: short text
79	TXT30	☐	VVXJ_TXT30	CHAR30	CHAR	30	0	Occupancy type (text)
80	BELEAB	☐	VVDBELEAB	DATUM	DATS	8	0	Occupancy type: effet.from
81	BELEBIS	☐	VVDBELEBIS	DATUM	DATS	8	0	Occupancy type: eff. to
82	DBEGEH	☐	VVDBEGEH	DDAT	DATS	8	0	Last access: date
83	XBEGEH	☐	VVXBEGEH	XKBEZ	CHAR	15	0	Last inspection: by
84	PERHOE	☐	VVPERHOE2	DEC8_2	DEC	10	2	Increase: percentage
85	RPROZGRD	☐	VVRPROZGRD	RPROZGRD	CHAR	2	0	Increase: Reason for difference	TIV43
86	XPROZGRD	☐	VVXPROZGRD	CHAR15	CHAR	15	0	Increase: Reason for difference
87	SMOEBL	☐	SMOEB	SMOEB	CHAR	1	0	Furniture indicator
88	AZIMM	☐	VVAZIMM	DEC6	DEC	6	0	Number of rooms
89	AHALBZI	☐	VVAHALBZI	DEC6	DEC	6	0	Number of half rooms
90	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
91	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
92	ABNNR	☐	VVABNNR	TEXT20	CHAR	20	0	Settlement firm: number
93	STECHEM	☐	VVSTECHEM	STECHEM	CHAR	13	0	Settlement firm: Evaluation group
94	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
95	JVORSTEIG	☐	JVORSTEIG	OPTIERT	CHAR	1	0	Input tax deduction for vacancy
96	RFAKT	☐	VVXFAKT	CHAR6	CHAR	6	0	Conversion factor for fractional share of property
97	JKONDMV	☐	VVJKONDMV2	XFELD	CHAR	1	0	Cond.transfer RA: indicator
98	PKONDMV	☐	VVPKONDMV2	PRZ32	DEC	5	2	Cond.transfer LO: percent
99	DFSTRBIS	☐	VVDFSTRBI2	DATUM	DATS	8	0	Date: Cash flow until
100	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
101	DHPZSAKT	☐	VVDHPZSAK2	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
102	DUTBKAKT	☐	VVDUTBKAK2	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
103	DTEURAKT	☐	VVDTEURAK2	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
104	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
105	XMIETSP	☐	VVXMIETSP	CHAR15	CHAR	15	0	Representative list of rents: allocation
106	PZUABSP	☐	VVPZUABSP2	DEC8_2	DEC	10	2	Representative list of rents: surcharge/reduction
107	SLAGK	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
108	XLAGK	☐	VVXLAGK	XMBEZ	CHAR	30	0	Representative list of rents: locat.class
109	SAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
110	XAUSTKL	☐	VVXXAUSTKL	CHAR15	CHAR	15	0	Represent. list of rents: Fixture/fitting category
111	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
112	RBELBIND	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
113	XBELBIND	☐	VVXBELBIND	CHAR15	CHAR	15	0	Occupancy obligation: to
114	DBINDBIS	☐	VVDBINDBIS	DATUM	DATS	8	0	Occupancy obligation: until
115	SBWNR	☐	VVXBWNR	VVXBWNR	CHAR	7	0	Reservation application number of a rental unit
116	SPARTNR	☐	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
117	XPARTNR	☐	VVXPARTNRB	CHAR35	CHAR	35	0	Name of applicant for a rental unit
118	XNNPART	☐	VVNNPART	TEXT20	CHAR	20	0	Last name of applicant
119	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
120	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
121	UMBRAUM	☐	VVBUBRA	VVBUBRA	QUAN	11	3	Cubic Volume
122	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
123	XGEBT	☐	VVXGEBT	CHAR15	CHAR	15	0	Building: part
124	SBASTEU	☐	VVSBASTEU	BASJHR	NUMC	4	0	Swiss rent adj.: Base year for standard of living index	*
125	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
126	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
127	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
128	DFLOWFIX	☐	VVDFLOWFIX	DATUM	DATS	8	0	Flows fixed upto
129	KOEIGR	☐	VVWERTN_AD	VVWERTN_AD	CHAR	10	0	Account determination key for account determination	*
130	SPOSINMSP	☐	VVSPOSINMSP	VVSADJBASE	CHAR	1	0	Base value for grouping RU in RLR group
131	PPOSINMSP	☐	VVPPOSINMSP	DECV3_2	DEC	5	2	Percentage value for grouping RU in RLR category group
132	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
133	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
134	BMMVALFE	☐	VVBMMVALUFE	WRTV7	CURR	13	2	Amount for each area unit for a fixtures & fittings charact.
135	DMMGUELAB	☐	VVDMMGUELAB	DATE	DATS	8	0	Valid from date of a fixture and fitting characteristic
136	SIHMA	☐	VVSIHMA	VVSIHMA	CHAR	20	0	Modernization Measure	*
137	SKOTYP	☐	SKOTYP	SKOTYP	NUMC	3	0	Condition category	*
138	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	*
139	XGBVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
140	PAUSFW	☐	VVPAUSFW2	DEC6_2	DEC	8	2	Service charge stt. apport.loss risk percentage surcharge
141	.INCLUDE	☐				0	0	Customer Fields LIS: Include for Infostructure
142	DUMMYFIELD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
143	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S406	BUKRS	T001	BUKRS
2	S406	BUKRS_01	T001	BUKRS
3	S406	FEINS	T006	MSEHI
4	S406	GSBER	TGSB	GSBER
5	S406	GSBER_02	TGSB	GSBER
6	S406	MANDT	T000	MANDT
7	S406	MEINS	T006	MSEHI
8	S406	OBJNR	ONR00	OBJNR
9	S406	PERIV	T009	PERIV
10	S406	RBELBIND	TIV31	RBELBIND
11	S406	REINS	T006	MSEHI
12	S406	RLGESCH	TIV38	RLGESCH
13	S406	RPROZGRD	TIV43	RPROZGRD
14	S406	SABRG	TIV07	SABRG
15	S406	SAUSTKL	TIV23	SMKLASS
16	S406	SFLART	TIV08	SFLART
17	S406	SGEBT	TIV12	SGEBT
18	S406	SGENR	VIOB03	SGENR
19	S406	SGENR_05	VIOB03	SGENR
20	S406	SGRNR	VIOB02	SGRNR
21	S406	SGRNR_04	VIOB02	SGRNR
22	S406	SKOART	TZK01	SKOART
23	S406	SLAGK	TIV22	SLAGK
24	S406	SMENR	VIMI01	SMENR
25	S406	SMENR_06	VIMI01	SMENR
26	S406	SMERKMA	TIV71	SMERKMA
27	S406	SMIETSP	TIV20	SMIETSP
28	S406	SNUNR	TIV01	SNUNR
29	S406	SPARTNR	SPRT1	PARTNR
30	S406	SRAART	TIV09	SRAART
31	S406	SSTCKBIS	TIV37	SSTOCKW
32	S406	SSTOCKW	TIV37	SSTOCKW
33	S406	SWENR	VIOB01	SWENR
34	S406	SWENR_03	VIOB01	SWENR
35	S406	USRCUKY1	TCURC	WAERS
36	S406	USRCUKY2	TCURC	WAERS
37	S406	USRUNIT1	T006	MSEHI
38	S406	USRUNIT2	T006	MSEHI
39	S406	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in