SAP ABAP Table S407 (Rental agreements)

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	S407	Table Relationship Diagram
Short Description	Rental agreements

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	SMIVE_07	☑	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
15	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
16	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
17	USRUNIT	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	*
18	USRCUKY	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	*
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
21	DERSTDR	☐	VVDERSTDR	DATUM	DATS	8	0	Date When the Lease-Out was First Printed
22	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
23	ABNNR	☐	VVABNNR	TEXT20	CHAR	20	0	Settlement firm: number
24	STECHEM	☐	VVSTECHEM	STECHEM	CHAR	13	0	Settlement firm: Evaluation group
25	ABNUNR	☐	VVABNUNR	NUM3	NUMC	3	0	Settlement company: subnumber
26	XNNPARTABW	☐	VVNNPARTBA	TEXT20	CHAR	20	0	Alternative payer: surname
27	XPARTNRABW	☐	VVXPARTNRA	CHAR35	CHAR	35	0	Alternative payer: name
28	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
29	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
30	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
31	ANKUEN	☐	ANKUEN	NUMC2	NUMC	2	0	Notification until (for renewal of contract)
32	XMVANART	☐	VVXMVANPPR	CHAR15	CHAR	15	0	Lease-out primary adjustment type
33	XMVANART44	☐	VVXMVANART	XKBEZ	CHAR	15	0	Lease-Out Secondary Adjustment Type
34	DASPVON	☐	VVDASPVON	DATUM	DATS	8	0	Adjustment block as from
35	DASPBIS	☐	VVDASPBIS	DATUM	DATS	8	0	Adjustment block until
36	ANZMV	☐	VVAMV	VVDEC6	DEC	6	0	No. of lease-outs
37	AZIMM	☐	VVAZIMM	DEC6	DEC	6	0	Number of rooms
38	AHALBZI	☐	VVAHALBZI	DEC6	DEC	6	0	Number of half rooms
39	SKUEFR	☐	SKUEFR	SKUEFR	NUMC	1	0	Type of notice period
40	SAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
41	BANKKS	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
42	DBKERH	☐	VVDBKERH	DATUM	DATS	8	0	Cash deposit received on
43	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
44	XBELEGNG	☐	VVSBELEGN2	CHAR30	CHAR	30	0	RU occupancy by LO (used by third-prty/private/corp.grp)
45	SBELEGNG	☐	VVSBELEGNG	VVSBELEGNG	CHAR	1	0	RU occupancy by LO (used by third-prty/private/corp.grp)
46	USR02	☐	USRCHAR101	USRCHAR10	CHAR	10	0	User-defined field 1 for 10 characters
47	USR03	☐	USRCHAR102	USRCHAR10	CHAR	10	0	User-defined field 2 for 10 characters
48	USR00	☐	USRCHAR201	USRCHAR20	CHAR	20	0	User-defined field 1 for 20 characters
49	USR01	☐	USRCHAR202	USRCHAR20	CHAR	20	0	User field 2 for 20 characters
50	USR08	☐	USRDATE1	USRDATE	DATS	8	0	User field 1 for date
51	USR09	☐	USRDATE2	USRDATE	DATS	8	0	User field 2 for date
52	USRUNIT1	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
53	USRCUKY2	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
54	USRCUKY1	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
55	USRUNIT2	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
56	USR10	☐	USRFLAG1	FLAG	CHAR	1	0	User field 1 indicator for evaluations
57	USR11	☐	USRFLAG2	FLAG	CHAR	1	0	User field 2 indicator for evaluations
58	USR04	☐	USRQUAN151	USRQUAN15	QUAN	15	3	User Field 1 for Set (Length 12,3)
59	USR05	☐	USRQUAN152	USRQUAN15	QUAN	15	3	User Field 2 for Set (Length 12,3)
60	USR06	☐	USRCURR131	USRCURR13	CURR	13	3	User field 1 for values (length 10.3)
61	USR07	☐	USRCURR132	USRCURR13	CURR	13	3	User field 2 for values (length 10.3)
62	JBETRST	☐	JBETRST	JANEI	CHAR	1	0	Security deposit granted
63	BKONDQM	☐	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
64	FBEZUG	☐	VVFBEZUG	VVFBEZUG	QUAN	15	2	Reference area for calculation of amounts per area unit
65	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
66	DERZAHL	☐	VVDERZA	DDAT	DATS	8	0	Date: 1st debit position
67	DAKTV	☐	VVDAKTV	DATUM	DATS	8	0	Date: Activation
68	DAUSZG	☐	VVDAUSZG2	DATS	DATS	8	0	Date: Move-out
69	DEINZG	☐	VVDEINZG2	DATS	DATS	8	0	Date: Move-in
70	DKUEZU	☐	VVDKUZU2	DATS	DATS	8	0	Date: Notice
71	DMIBEG	☐	VVDMIBE	DDAT	DATS	8	0	Date: Start of rent
72	DMIEND	☐	VVDMIEN	DDAT	DATS	8	0	Date: rental end
73	DUNTBIS	☐	VVDUNBI	DDAT	DATS	8	0	Date: Provisional agreement from
74	ZUSPKUNNR	☐	VVRDEBZUSP	KUNNR	CHAR	10	0	Subsidizer: Customer number	KNA1
75	BABRE	☐	VVBABRE	VVBABRE	QUAN	14	4	Settlement units
76	PERHOE	☐	VVPERHOE	DEC8_2	DEC	10	2	Percentage rate increase
77	FKONDFLA	☐	VVFKONDFLA	VVFKONDFLA	QUAN	15	2	Area for condition type
78	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
79	XGEBT	☐	VVXGEBT	CHAR15	CHAR	15	0	Building: part
80	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
81	GERSTD	☐	VVXGERSTD	TEXT35	CHAR	35	0	Jurisdiction
82	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
83	XSTOCKW	☐	VVXSTOCKW	CHAR15	CHAR	15	0	Floor (text)
84	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
85	XASPGRD	☐	VVXASPGRD	XTEXT30	CHAR	30	0	Reason for adjustment block (text)
86	XMANSP	☐	VVXMANSP	CHAR30	CHAR	30	0	Dunning block reason
87	SASPGRD	☐	VVSASPGRD	VVSASPGRD	NUMC	2	0	Reason for adjustment block	TIV14
88	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
89	KUNNR	☐	VVRDEBIHV2	KUNNR	CHAR	10	0	Main tenant: Customer number	KNA1
90	XNNPART	☐	VVNNPARTB	TEXT20	CHAR	20	0	Master tenant: last name
91	XPARTNR	☐	VVXPARTNR	CHAR35	CHAR	35	0	Master tenant: name
92	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
93	DKAUFOPT	☐	VVDKAUFOPT	DDAT	DATS	8	0	Purchase option: date
94	JKAUFOPT	☐	VVJKAUFOPT	JANEI	CHAR	1	0	Purchase option: indicator
95	BKAUTION	☐	VVBKAUTART	WRTV7	CURR	13	2	Deposit: amount
96	JMFREI	☐	VVJMFREI	JANE	CHAR	1	0	Condition is not checked
97	DGULTAB	☐	VVDKOND	DDAT	DATS	8	0	Condition: effective from
98	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
99	BKOND	☐	BKONDS407	WERTV8	CURR	15	2	Condition item currency amount
100	KOSTL	☐	VVXKOSTL	KOSTL	CHAR	10	0	Cost center: name	*
101	DATAB	☐	VVDKOSTL	DATUM	DATS	8	0	Cost center: effective from_
102	XKUEFR	☐	VVXKUEFR	CHAR30	CHAR	30	0	Type of notice period
103	DKUEFR	☐	VVAKUEFR2	DEC06	DEC	6	0	Notice period: months
104	XLGESCH	☐	VVXLGESCH	CHAR15	CHAR	15	0	Location in floor (text)
105	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
106	SLAGK	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
107	MANSP	☐	VVMANSP	MANSP	CHAR	1	0	Dunning: Blocking reason	T040S
108	JMAHNMSP	☐	VVJMANSP	JANE	CHAR	1	0	Dunning: Block indicator
109	MABER	☐	VVMABER	MABER	CHAR	2	0	Dunning: area	*
110	MADAT	☐	VVDMADAT	DATUM	DATS	8	0	Date of last dunning letter
111	MANST	☐	VVMAHNS	MAHNS	NUMC	1	0	Dunning: level
112	BMWST	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
113	AMELDIN	☐	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
114	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
115	XMBEZ	☐	VVMMXMBEZ	XMBEZ	CHAR	30	0	Reason for rent reduction
116	SKAUTART	☐	SKAUA	SKAUA	CHAR	1	0	Type of Rental Collateral	TIV18
117	XKAUTART	☐	VVXKAUTART	CHAR15	CHAR	15	0	Deposit: type
118	XAUSTKL	☐	VVXXAUSTKL	CHAR15	CHAR	15	0	Represent. list of rents: Fixture/fitting category
119	XLAGK	☐	VVXLAGK	XMBEZ	CHAR	30	0	Representative list of rents: locat.class
120	XMIETSP	☐	VVXMIETSP	CHAR15	CHAR	15	0	Representative list of rents: allocation
121	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
122	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
123	XMVART	☐	VVXMVART	CHAR15	CHAR	15	0	Lease out: Type
124	FLG_MITARB	☐	VVSMITARB2	XFELD	CHAR	1	0	Employee indicator
125	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
126	SPARTNR	☐	VVSPARTNR	VVSPARTNR	CHAR	22	0	Partner number
127	SMVANART	☐	SMVAR04	SMVAR	CHAR	1	0	Rental agreement primary adjustment type	TIV27
128	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
129	JBKRZ	☐	VVJBKRZ	JANEI	CHAR	1	0	Cash deposit instalment payment
130	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
131	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
132	DGABANRT44	☐	VVDGABANR2	DATUM	DATS	8	0	Secondary adjustment type valid from
133	DBISANRT44	☐	VVDBISANR2	DATUM	DATS	8	0	Secondary adjustment type valid until
134	SMVANART44	☐	SMVAR44	SMVAR	CHAR	1	0	Rental agreement secondary adjustment type	TIV27
135	SICHGEB	☐	VVXSICHGEB	TEXT30	CHAR	30	0	Guarantor
136	JSKUEND	☐	JSKUEND	JANEI	CHAR	1	0	Special right of notice
137	STTXT_EXT	☐	VVXSTXTEXT	CHAR40	CHAR	40	0	Status: Set by user
138	STTXT_INT	☐	VVXSTTXTIN	CHAR40	CHAR	40	0	Status: Set by system
139	DGAB	☐	VVDUMLGA	DDAT	DATS	8	0	Date when the apportionment factor becomes valid
140	SABRG	☐	SABRG	SABRG	NUMC	4	0	Apportionment unit	TIV07
141	PPROZ0	☐	VVPPROZ0	DEC3_2	DEC	5	2	Sales: minimum percentage
142	BMINUMS	☐	VVBUMSATZ1	WRTV7	CURR	13	2	Sales: minimum
143	BUMSPROJ	☐	VVBUMSPROJ	WRTV7	CURR	13	2	Sales: plan
144	DVMUN	☐	VVDVMUN	DATUM	DATS	8	0	Contract signed by landlord
145	VERLG	☐	VERLG	NUMC3	NUMC	3	0	Contract renewal by ... months
146	SMVART	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
147	JVERL	☐	JVERL	VVVERL	CHAR	1	0	Contract renewal
148	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
149	XGZLSCH	☐	VVXGZLSCH	CHAR30	CHAR	30	0	Payment method for credit memos
150	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
151	XZLSCH	☐	VVXZLSCH	CHAR30	CHAR	30	0	Payment method
152	GZLSCH	☐	VVGZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
153	PZUABSP	☐	VVPZUABSP	DEC8_2	DEC	10	2	Surcharge or reduction for representative list of rents
154	PROZTEIL	☐	VVPZUSP	DECV5_2	DEC	5	2	Subsidy percentage rate
155	DGUELTAB	☐	VVDZUSPAB	DATUM	DATS	8	0	Date as from when subsidy valid
156	DGUELBIS	☐	VVDZUSPBIS	DATUM	DATS	8	0	Date up to when subsidy valid
157	DFAELL	☐	VVDZUSPFAE	DATUM	DATS	8	0	Subsidy due date
158	BZUBETR	☐	VVZUBETR	WERTV7	CURR	13	2	Subsidy/allowance amount
159	BMAXBETR	☐	VVMAXBETR	WERTV7	CURR	13	2	Subsidy/grant maximum amount
160	XZUSPKUNNR	☐	VVXZUSPPRT	CHAR35	CHAR	35	0	Subsidizer
161	ZUSP	☐	VVZUSP	JANE	CHAR	1	0	Subsidies available, indicator
162	SPARTNRABW	☐	VVRPARTABW	SPARTNR	CHAR	10	0	Alternative payer (partner number)	*
163	DAENDDR	☐	VVDAENDDR	DATUM	DATS	8	0	Date When the Lease-Out was Changed and Printed Out
164	DMIENKUE	☐	VVDMIENKUE	DATS	DATS	8	0	End Date of Lease-Out
165	E_SMIVE	☐	VVESMIVE	VVSMIVE	CHAR	13	0	Contract No. of Collective Lease-Outs
166	IND_SECTOR	☐	VVMVINDSEC	BRSCH	CHAR	4	0	Industry of master tenant	*
167	XIND_SECT	☐	VVXMVINDSE	TEXT20	CHAR	20	0	Industry of master tenant
168	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
169	JVSTOPT	☐	VVJVSTOPT	JANE	CHAR	1	0	Input tax opting (indicator)
170	SVSTSOND	☐	SVSTSOND	SVSTSOND	CHAR	1	0	Input tax opting reason	*
171	XVSTSOND	☐	XVSTSOND	TEXT20	CHAR	20	0	Input tax opting reason
172	SKUEKEY	☐	SKUEKEY	SKUEKEY	CHAR	12	0	Notice rule
173	SKUEART	☐	SMVKUEART	SMVKUEART	CHAR	1	0	Notice Type of Lease-Out
174	XKUEART	☐	VVXMVKUEAR	TEXT20	CHAR	20	0	Notice Type of Lease-Out
175	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
176	FEHLBEL	☐	VVFEHLBEL	VVFEHLBEL	CHAR	20	0	Reference code false occupancy charges
177	R1DATUM	☐	VVR1DATUM	DATUM	DATS	8	0	1st date for vacating
178	R2DATUM	☐	VVR2DATUM	DATUM	DATS	8	0	2nd date for vacating
179	KLDATUM	☐	VVKLDATUM	DATUM	DATS	8	0	Date of complaint
180	KLAKTZEI	☐	VVKLAKTZEI	CHAR20	CHAR	20	0	Complaint reference code
181	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
182	DFLOWFIX	☐	VVDFLOWFIX	DATUM	DATS	8	0	Flows fixed upto
183	KONTOBV	☐	VVIKONTOBV	VVIKONTOBV	CHAR	10	0	Bank procedure account number
184	ZLSCH_DEB	☐	REZWELSDEB	ZWELS	CHAR	10	0	Customer payment methods
185	GZLSCH_DEB	☐	REGZWELSDEB	ZWELS	CHAR	10	0	Payment methods for customer credit memos
186	DGUELAB	☐	DGUELAB	DATUM	DATS	8	0	Date when the rent adjustment becomes valid
187	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
188	OSMIVE	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
189	SDUNMOD	☐	VVRAMAHNVERF	CHAR004	CHAR	4	0	Dunning level for dunning of non-approved rent adjustments
190	SKOTYP	☐	SKOTYP	SKOTYP	NUMC	3	0	Condition category	*
191	.INCLUDE	☐				0	0	Customer Fields LIS: Include for Infostructure
192	DUMMYFIELD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
193	.INCLUDE	☐				0	0
194	SNUNR	☐	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	*
195	XNUNR	☐	VVXNUNR	CHAR30	CHAR	30	0	Rental unit usage type (text)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S407	BUKRS	T001	BUKRS
2	S407	BUKRS_01	T001	BUKRS	KEY	1	CN
3	S407	FEINS	T006	MSEHI
4	S407	GSBER	TGSB	GSBER
5	S407	GSBER_02	TGSB	GSBER
6	S407	KUNNR	KNA1	KUNNR
7	S407	MANDT	T000	MANDT
8	S407	MANSP	T040S	MANSP
9	S407	MEINS	T006	MSEHI
10	S407	OBJNR	ONR00	OBJNR
11	S407	PERIV	T009	PERIV
12	S407	PROFL	TKB1A	APROF
13	S407	REINS	T006	MSEHI
14	S407	RLGESCH	TIV38	RLGESCH
15	S407	SABRG	TIV07	SABRG
16	S407	SASPGRD	TIV14	SASPGRD
17	S407	SAUSTKL	TIV23	SMKLASS
18	S407	SGEBT	TIV12	SGEBT
19	S407	SGENR	VIOB03	SGENR
20	S407	SGENR_05	VIOB03	SGENR
21	S407	SGRNR	VIOB02	SGRNR
22	S407	SGRNR_04	VIOB02	SGRNR
23	S407	SKAUTART	TIV18	SKAUTART
24	S407	SKOART	TZK01	SKOART
25	S407	SLAGK	TIV22	SLAGK
26	S407	SMENR	VIMI01	SMENR
27	S407	SMENR_06	VIMI01	SMENR
28	S407	SMIETSP	TIV20	SMIETSP
29	S407	SMVANART	TIV27	SMVANART
30	S407	SMVANART44	TIV27	SMVANART
31	S407	SMVART	TIV26	SMVART
32	S407	SSTOCKW	TIV37	SSTOCKW
33	S407	SWENR	VIOB01	SWENR
34	S407	SWENR_03	VIOB01	SWENR
35	S407	USRCUKY1	TCURC	WAERS
36	S407	USRCUKY2	TCURC	WAERS
37	S407	USRUNIT1	T006	MSEHI
38	S407	USRUNIT2	T006	MSEHI
39	S407	WAERS	TCURC	WAERS
40	S407	ZUSPKUNNR	KNA1	KUNNR

History

Last changed by/on	SAP	20130529
SAP Release Created in