SAP ABAP Table REXCAJMIRO_CH01_L (Migration: Rental Obj. Adjustment Terms Accord. to Swiss Law)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_XC_AJ_CH (Package) RE: XC - Adjustment Switzerland (Country-Specific)

Basic Data

Table Category	INTTAB	Structure
Structure	REXCAJMIRO_CH01_L	Table Relationship Diagram
Short Description	Migration: Rental Obj. Adjustment Terms Accord. to Swiss Law

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	Reporting Fields: Rental Objects
2	.INCLUDE	☐				0	0	Rental Object and Additional Fields (VIBDRO)
3	.INCLUDE	☐				0	0	Rental Object (VIBDRO)
4	.INCLUDE	☐				0	0	Rental Object
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
6	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
7	.INCLUDE	☐				0	0	Rental Object: Key Fields
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	SWENR	☐	REBDBENO	REBDBENO	CHAR	8	0	Business Entity Number	*
10	SMENR	☐	REBDRONO	REBDRONO	CHAR	8	0	Number of Rental Object
11	.INCLUDE	☐				0	0	Rental Object: Non-Key Fields
12	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
13	IMKEY	☐	RECAIMKEY	IMKEY	CHAR	8	0	Internal Key of Real Estate Object (FI)
14	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
15	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
16	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
17	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
18	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
19	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
20	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
21	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
22	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
23	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
24	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
25	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
26	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
27	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
28	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
29	ROTYPE	☐	REBDROTYPE	REBDROTYPE	CHAR	2	0	Rental Object Type
30	SNUNR	☐	REBDUSAGETYPE	SNUNR	NUMC	4	0	Usage Type of Rental Object	TIV01
31	XMETXT	☐	REBDXRO	RECAXLDESCRIPTION	CHAR	60	0	Rental Object Name
32	SGRNR	☐	REBDPRNO	REBDPRNO	CHAR	8	0	Number of Land
33	SGENR	☐	REBDBUNO	REBDBUNO	CHAR	8	0	Number of Building
34	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
35	CANBECOMMON	☐	REBDCANBECOMMON	RECABOOL	CHAR	1	0	Common Usage Possible
36	FIRSTPOSTING	☐	RECDCFSTARTFROM	RECADATE	DATS	8	0	Cash Flow Generated Starting On
37	DBEZU	☐	DBEZU	DDAT	DATS	8	0	Date of initial usage
38	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
39	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
40	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
41	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
42	RLRAFIXFITCATE	☐	REAJRLRAFIXFITCATE	REAJRLRAFIXFITCATE	CHAR	6	0	Fixtures and Fittings Category	TIVAJRLRAFFCT
43	RLRALOC	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	TIVAJRLRALOC
44	PZUABSP	☐	REBDSUREPERCENT	REBDSUREPERCENT	DEC	4	2	Increase or Reduction for Representative List of Rents
45	SPOSINMSP	☐	REBDRLRABASEIND	REAJRLRAADJMBASE	CHAR	1	0	Method for Calculating Base Rent of Rep. List of Rents
46	PPOSINMSP	☐	REBDRLRAPERCENT	DECV3_2	DEC	5	2	Percentage for Positioning RU in RLR Spread
47	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
48	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase	TIV43
49	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
50	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
51	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
52	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
53	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
54	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
55	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
56	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
57	CFPOSTINGFROM	☐	RECDCFPOSTINGFROM	RECADATE	DATS	8	0	First Posting From
58	HASCOP	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
59	RLRA	☐	REAJRLRA	REAJRLRA	CHAR	6	0	Representative List of Rents	TIVAJRLRA
60	USESRLRA	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
61	BUILDYEAR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
62	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
63	COMMONOWNED	☐	REBDCOMMONOWNED	RECABOOL	CHAR	1	0	Rental Object Is Common Property
64	OOLOCK	☐	REOROOLOCK	RECABOOL	CHAR	1	0	Do Not Consider Object for Real Estate Search
65	NEIGHBORH1	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
66	NEIGHBORH2	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
67	NEIGHBORH3	☐	REBDNEIGHBORHOOD	REBDNEIGHBORHOOD	CHAR	30	0	Neighborhood	TIVBDNEIGHBORH
68	.INCLUDE	☐				0	0
69	.INCLU--AP	☐				0	0	Country Specific fields for Switzerland
70	.INCLUDE	☐				0	0	Rental Object Customer fields
71	EDID	☐	REXCCHEDID	REXCCHEDID	NUMC	2	0	Federal Building Entrance Identification Number (EDID)
72	EGID	☐	REXCCHEGID	REXCCHEGID	NUMC	9	0	Federal Building Identification Number (EGID)
73	FLOOR	☐	REXCCHROFLOOR	REXCCHROFLOOR	NUMC	4	0	Code of Floor	*
74	FLOORLOC	☐	REXCCHROFLOORLOC	REXCCHROFLOORLOC	CHAR	40	0	Location of Dwelling on a Floor
75	EWID	☐	REXCCHEWID	REXCCHEWID	NUMC	3	0	Federal Dwelling Identification Number (EWID)
76	KITCHEN	☐	REXCCHROKITCHEN	REXCCHROKITCHEN	NUMC	4	0	Code of Cooking Facilities	*
77	ADMINNO	☐	REXCCHROADMINNO	REXCCHROADMINNO	CHAR	12	0	Administrative Dwelling Number
78	DOORNO	☐	REXCCHRODOORNO	REXCCHRODOORNO	CHAR	8	0	Door Number of Dwelling
79	OBJCOND	☐	REXCCHROCOND	REXCCHROCOND	NUMC	4	0	Code of Dwelling Status	*
80	YEARDECONSTR	☐	REXCCHBUDECONYEAR	DATUM	DATS	8	0	Year of Demolition
81	NUMROOMS	☐	REXCCHRONUMROOMS	REXCCHRONUMROOMS	NUMC	4	0	Number of Rooms in the Dwelling
82	LIVINGAREA	☐	REXCCHROAREA	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Floor Area of Dwelling in M2
83	USAGETYPE	☐	REXCCHROUSAGETYPE	REXCCHROUSAGETYPE	NUMC	4	0	Code of Usage Type	*
84	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
85	.INCLU--AP	☐				0	0	Country-Specific fields for Portugal
86	.INCLUDE	☐				0	0	Country-Specific Fields for Portugal - Rental Object
87	VPT	☐	REXCPTVPT_NOSIGN	REXCPTVPT_NOSIGN	CURR	15	2	Property Taxable Value
88	VPTCURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
89	CONDK	☐	REXCPTRACONS		CHAR	4	0	Conservation Level	TIVXCPTRACONS
90	BUKRSTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
91	XWETEXT	☐	REBDXBE	RECAXLDESCRIPTION	CHAR	60	0	Business Entity Name
92	XGRTXT	☐	REBDXPR	RECAXLDESCRIPTION	CHAR	60	0	Name of Land
93	XGETXT	☐	REBDXBU	RECAXLDESCRIPTION	CHAR	60	0	Description of Building
94	XLROTYPE	☐	REBDXLROTYPE	RECAXLDESCRIPTION	CHAR	60	0	Name of Rental Object Type
95	XMBEZ	☐	XNUNRM	XMBEZ	CHAR	30	0	Description of external usage type of rental unit
96	XRLRA	☐	REAJXRLRA	RECAXLDESCRIPTION	CHAR	60	0	Description of Representative List of Rents
97	XRLRAFIXFITCATE	☐	REAJXRLRAFIXFITCATE	RECAXLDESCRIPTION	CHAR	60	0	Description of Fixtures and Fittings Category
98	XRLRALOC	☐	REAJXRLRALOC	RECAXLDESCRIPTION	CHAR	60	0	Name of Location Class
99	XAUSTKLL	☐	XAUSTKLL	XTEXT50	CHAR	50	0	Long text of fixture and fitting category
100	XSTOCKK	☐	VVXSTOCKK	VVXSTOCKK	CHAR	4	0	Short name of floor
101	XSTOCKL	☐	VVXSTOCKL	XMBEZ	CHAR	30	0	Floor ID
102	XSTBISK	☐	VVXSTBISK	VVXSTOCKK	CHAR	4	0	For RUs with several storeys: Top storey of RU
103	XSTBISL	☐	VVXSTOCKL	XMBEZ	CHAR	30	0	Floor ID
104	XKLGESCH	☐	XKLGESCH	XKBEZ	CHAR	15	0	Location in floor short name
105	XSLIFTBIS	☐	VVXLIFTB	VVXSTOCKK	CHAR	4	0	Elevator to floor in building
106	XSTOCKL_LIFTBIS	☐	VVXSTOCKL	XMBEZ	CHAR	30	0	Floor ID
107	XGBVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
108	NBANDNR	☐	NBANDNR	TEXT15	CHAR	15	0	Land register volume number
109	NBLATTNR	☐	NBLATTNR	TEXT15	CHAR	15	0	Land register page number
110	XGEBK	☐	XGEBK	XKBEZ	CHAR	15	0	Short name for parts of building
111	XADDRESS	☐	REBPXADDRESS	REBPXADDRESS	CHAR	80	0	Compact Display of Address
112	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
113	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
114	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
115	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
116	REALVALIDFROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
117	REALVALIDTO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
118	XAUTHGRP	☐	RECAXAUTHGRP	RECAXLDESCRIPTION	CHAR	60	0	Description of Authorization Group
119	RLRAAGE	☐	REAJRLRAAGE	REAJRLRAAGE	CHAR	6	0	Building Age Category	TIVAJRLRAAGE
120	RLRASIZ	☐	REAJRLRASIZ	REAJRLRASIZ	CHAR	6	0	Size Class	TIVAJRLRASIZ
121	RLRALABEL	☐	REAJRLRALABEL	REAJRLRALABEL	CHAR	10	0	Representative List of Rents Label	TIVAJRLRALABEL
122	XRLRALABEL	☐	REAJXRLRALABEL	RECAXLDESCRIPTION	CHAR	60	0	Name of Representative List of Rents Label
123	XGEBM	☐	XGEBM	XMBEZ	CHAR	30	0	Building parts long text
124	NORUPS	☐	REBDNORUPS	REBDRONO	CHAR	8	0	Number of Pooled Space or Rental Unit
125	NORS	☐	REBDNORS	REBDRONO	CHAR	8	0	Number of Rental Space
126	.INCLUDE	☐				0	0	Account Assignment Fields - Funds Management
127	FUND	☐	RERAFUND	CHAR24	CHAR	24	0	Fund
128	FUNDSCENTER	☐	RERAFUNDSCENTER	CHAR24	CHAR	24	0	Funds Center
129	COMMITMENTITEM	☐	RERACOMMITMENTITEM	FM_FIPEX	CHAR	24	0	Commitment Item	*
130	FUNCTIONALAREA	☐	RERAFUNCTIONALAREA	CHAR24	CHAR	24	0	Functional Area
131	GRANTNUMBER	☐	RERAGRANTNUMBER	CHAR24	CHAR	24	0	Grant
132	MEASURE	☐	RERAMEASURE	CHAR24	CHAR	24	0	Program in Funds Management
133	BUDGETPERIOD	☐	RERABUDGETPERIOD	CHAR24	CHAR	24	0	FM: Budget Period
134	.INCLUDE	☐				0	0	Reporting Fields: Address for Objects
135	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
136	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
137	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
138	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
139	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
140	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
141	.INCLUDE	☐				0	0	Measurements in Report Profile
142	.INCLU-01	☐				0	0	Measurement in Report Profile
143	MEASVALUE01	☐	REBDMEASVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Available
144	MEASVALUECMPL01	☐	REBDMEASVALUECMPL	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Capacity
145	MEASUNIT01	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
146	MEASVALIDFROM01	☐	REBDMEASVALIDFROM	RECADATE	DATS	8	0	Date: Measurement Valid From
147	MEASVALIDTO01	☐	REBDMEASVALIDTO	RECADATEEND	DATS	8	0	Date: Measurement Valid To
148	.INCLU-02	☐				0	0	Measurement in Report Profile
149	MEASVALUE02	☐	REBDMEASVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Available
150	MEASVALUECMPL02	☐	REBDMEASVALUECMPL	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Capacity
151	MEASUNIT02	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
152	MEASVALIDFROM02	☐	REBDMEASVALIDFROM	RECADATE	DATS	8	0	Date: Measurement Valid From
153	MEASVALIDTO02	☐	REBDMEASVALIDTO	RECADATEEND	DATS	8	0	Date: Measurement Valid To
154	.INCLU-03	☐				0	0	Measurement in Report Profile
155	MEASVALUE03	☐	REBDMEASVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Available
156	MEASVALUECMPL03	☐	REBDMEASVALUECMPL	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Capacity
157	MEASUNIT03	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
158	MEASVALIDFROM03	☐	REBDMEASVALIDFROM	RECADATE	DATS	8	0	Date: Measurement Valid From
159	MEASVALIDTO03	☐	REBDMEASVALIDTO	RECADATEEND	DATS	8	0	Date: Measurement Valid To
160	.INCLU-04	☐				0	0	Measurement in Report Profile
161	MEASVALUE04	☐	REBDMEASVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Available
162	MEASVALUECMPL04	☐	REBDMEASVALUECMPL	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Capacity
163	MEASUNIT04	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
164	MEASVALIDFROM04	☐	REBDMEASVALIDFROM	RECADATE	DATS	8	0	Date: Measurement Valid From
165	MEASVALIDTO04	☐	REBDMEASVALIDTO	RECADATEEND	DATS	8	0	Date: Measurement Valid To
166	.INCLU-05	☐				0	0	Measurement in Report Profile
167	MEASVALUE05	☐	REBDMEASVALUE	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Available
168	MEASVALUECMPL05	☐	REBDMEASVALUECMPL	REBDMEASVALUE	QUAN	17	4	Measurement Amount: Capacity
169	MEASUNIT05	☐	REBDMEASUNIT	MEINS	UNIT	3	0	Measurement Unit	*
170	MEASVALIDFROM05	☐	REBDMEASVALIDFROM	RECADATE	DATS	8	0	Date: Measurement Valid From
171	MEASVALIDTO05	☐	REBDMEASVALIDTO	RECADATEEND	DATS	8	0	Date: Measurement Valid To
172	.INCLUDE	☐				0	0
173	MEASISVALIDFROM	☐	REISRECVALIDFROM	RECADATE	DATS	8	0	Displayed Row Is Valid From
174	MEASISVALIDTO	☐	REISRECVALIDTO	RECADATE	DATS	8	0	Displayed Row Is Valid Until
175	.INCLUDE	☐				0	0	Maximum Possible Set of Conditions for Reporting
176	.INCLU-01	☐				0	0	Condition in Report Profile
177	CONDVALUE_BD01	☐	RECDCONDVALUE	RECACURR	CURR	15	2	Condition item currency amount
178	CONDCURR_BD01	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
179	FREQUENCY_BD01	☐	REISFREQUENCY		CHAR	12	0	Name of Unit for Posting Frequency
180	CONDVALIDFROM_BD01	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
181	CONDVALIDTO_BD01	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
182	UNITPRICE_BD01	☐	REISCONDMEASPRICE	RECDUNITPRICE	DEC	19	6	Price per Measurement
183	.INCLU-02	☐				0	0	Condition in Report Profile
184	CONDVALUE_BD02	☐	RECDCONDVALUE	RECACURR	CURR	15	2	Condition item currency amount
185	CONDCURR_BD02	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
186	FREQUENCY_BD02	☐	REISFREQUENCY		CHAR	12	0	Name of Unit for Posting Frequency
187	CONDVALIDFROM_BD02	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
188	CONDVALIDTO_BD02	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
189	UNITPRICE_BD02	☐	REISCONDMEASPRICE	RECDUNITPRICE	DEC	19	6	Price per Measurement
190	.INCLU-03	☐				0	0	Condition in Report Profile
191	CONDVALUE_BD03	☐	RECDCONDVALUE	RECACURR	CURR	15	2	Condition item currency amount
192	CONDCURR_BD03	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
193	FREQUENCY_BD03	☐	REISFREQUENCY		CHAR	12	0	Name of Unit for Posting Frequency
194	CONDVALIDFROM_BD03	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
195	CONDVALIDTO_BD03	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
196	UNITPRICE_BD03	☐	REISCONDMEASPRICE	RECDUNITPRICE	DEC	19	6	Price per Measurement
197	.INCLU-04	☐				0	0	Condition in Report Profile
198	CONDVALUE_BD04	☐	RECDCONDVALUE	RECACURR	CURR	15	2	Condition item currency amount
199	CONDCURR_BD04	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
200	FREQUENCY_BD04	☐	REISFREQUENCY		CHAR	12	0	Name of Unit for Posting Frequency
201	CONDVALIDFROM_BD04	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
202	CONDVALIDTO_BD04	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
203	UNITPRICE_BD04	☐	REISCONDMEASPRICE	RECDUNITPRICE	DEC	19	6	Price per Measurement
204	.INCLU-05	☐				0	0	Condition in Report Profile
205	CONDVALUE_BD05	☐	RECDCONDVALUE	RECACURR	CURR	15	2	Condition item currency amount
206	CONDCURR_BD05	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
207	FREQUENCY_BD05	☐	REISFREQUENCY		CHAR	12	0	Name of Unit for Posting Frequency
208	CONDVALIDFROM_BD05	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
209	CONDVALIDTO_BD05	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
210	UNITPRICE_BD05	☐	REISCONDMEASPRICE	RECDUNITPRICE	DEC	19	6	Price per Measurement
211	.INCLU-06	☐				0	0	Condition in Report Profile
212	CONDVALUE_BD06	☐	RECDCONDVALUE	RECACURR	CURR	15	2	Condition item currency amount
213	CONDCURR_BD06	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
214	FREQUENCY_BD06	☐	REISFREQUENCY		CHAR	12	0	Name of Unit for Posting Frequency
215	CONDVALIDFROM_BD06	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
216	CONDVALIDTO_BD06	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
217	UNITPRICE_BD06	☐	REISCONDMEASPRICE	RECDUNITPRICE	DEC	19	6	Price per Measurement
218	.INCLU-07	☐				0	0	Condition in Report Profile
219	CONDVALUE_BD07	☐	RECDCONDVALUE	RECACURR	CURR	15	2	Condition item currency amount
220	CONDCURR_BD07	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
221	FREQUENCY_BD07	☐	REISFREQUENCY		CHAR	12	0	Name of Unit for Posting Frequency
222	CONDVALIDFROM_BD07	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
223	CONDVALIDTO_BD07	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
224	UNITPRICE_BD07	☐	REISCONDMEASPRICE	RECDUNITPRICE	DEC	19	6	Price per Measurement
225	.INCLU-08	☐				0	0	Condition in Report Profile
226	CONDVALUE_BD08	☐	RECDCONDVALUE	RECACURR	CURR	15	2	Condition item currency amount
227	CONDCURR_BD08	☐	RECDCONDCURR	WAERS	CUKY	5	0	Currency of condition item	*
228	FREQUENCY_BD08	☐	REISFREQUENCY		CHAR	12	0	Name of Unit for Posting Frequency
229	CONDVALIDFROM_BD08	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
230	CONDVALIDTO_BD08	☐	RECDVALIDTO	RECADATEEND	DATS	8	0	Date up to when condition is valid
231	UNITPRICE_BD08	☐	REISCONDMEASPRICE	RECDUNITPRICE	DEC	19	6	Price per Measurement
232	CONDVALUEFURTHER_BD	☐	REISCONDVALUEFURTHER	RECACURR	CURR	15	2	Total of Further Condition Amounts
233	TAXVALUE_BD	☐	RECDTAXVALUE	RECACURR	CURR	15	2	Tax on Sales/Purchase of Condition Item
234	.INCLUDE	☐				0	0
235	CDBDISVALIDFROM	☐	REISRECVALIDFROM	RECADATE	DATS	8	0	Displayed Row Is Valid From
236	CDBDISVALIDTO	☐	REISRECVALIDTO	RECADATE	DATS	8	0	Displayed Row Is Valid Until
237	.INCLUDE	☐				0	0	Time Slot Valid in a Row in the Info System
238	RECISVALIDFROM	☐	REISRECVALIDFROM	RECADATE	DATS	8	0	Displayed Row Is Valid From
239	RECISVALIDTO	☐	REISRECVALIDTO	RECADATE	DATS	8	0	Displayed Row Is Valid Until
240	.INCLUDE	☐				0	0	Reporting Fields: Generic Part
241	GEN_OBJTYPE	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
242	GEN_OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
243	GEN_CONTRACT	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
244	GEN_PARTNER1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
245	GEN_PARTNER2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
246	ALVROWS	☐	REISALVROWS		INT2	5	0	Number of Rows
247	.INCLU-01	☐				0	0	Third Party Management: Object Assignment
248	OBJNR01	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
249	VALIDFROM01	☐	REBDVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid From
250	VALIDTO01	☐	REBDVALIDTO	RECADATEEND	DATS	8	0	Date: Valid To
251	OBJTYPE01	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
252	XOBJTYPE01	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
253	XLOBJTYPE01	☐	RECAXLOBJTYPE	TEXT20	CHAR	20	0	Object Type Name (20)
254	DESCRIPTION01	☐	RECADESCRIPTION	RECAXLDESCRIPTION	CHAR	60	0	Object Description
255	IDENT01	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
256	IDENTKEY01	☐	REMMIDENTKEY	CHAR45	CHAR	45	0	Object ID
257	XCCTYPE01	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
258	.INCLU-02	☐				0	0	Third Party Management: Object Assignment
259	OBJNR02	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
260	VALIDFROM02	☐	REBDVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid From
261	VALIDTO02	☐	REBDVALIDTO	RECADATEEND	DATS	8	0	Date: Valid To
262	OBJTYPE02	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
263	XOBJTYPE02	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
264	XLOBJTYPE02	☐	RECAXLOBJTYPE	TEXT20	CHAR	20	0	Object Type Name (20)
265	DESCRIPTION02	☐	RECADESCRIPTION	RECAXLDESCRIPTION	CHAR	60	0	Object Description
266	IDENT02	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
267	IDENTKEY02	☐	REMMIDENTKEY	CHAR45	CHAR	45	0	Object ID
268	XCCTYPE02	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
269	.INCLU-03	☐				0	0	Third Party Management: Object Assignment
270	OBJNR03	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
271	VALIDFROM03	☐	REBDVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid From
272	VALIDTO03	☐	REBDVALIDTO	RECADATEEND	DATS	8	0	Date: Valid To
273	OBJTYPE03	☐	RECAOBJTYPE	J_OBART	CHAR	2	0	Object Type	*
274	XOBJTYPE03	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
275	XLOBJTYPE03	☐	RECAXLOBJTYPE	TEXT20	CHAR	20	0	Object Type Name (20)
276	DESCRIPTION03	☐	RECADESCRIPTION	RECAXLDESCRIPTION	CHAR	60	0	Object Description
277	IDENT03	☐	RECAIDENT	CHAR50	CHAR	50	0	Complete Object Identification, for Example BE 1000/123
278	IDENTKEY03	☐	REMMIDENTKEY	CHAR45	CHAR	45	0	Object ID
279	XCCTYPE03	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
280	.INCLU--AP	☐				0	0	Additional Fields Reporting
281	.INCLUDE	☐				0	0	Rental Object Customer fields text
282	XKITCHEN	☐	REXCCHXROKITCHEN	RECAXLDESCRIPTION	CHAR	60	0	Description of Cooking Facilities
283	XFLOOR	☐	REXCCHXROFLOOR	RECAXLDESCRIPTION	CHAR	60	0	Description of Floor
284	XCONDITION	☐	REXCCHXROCOND	RECAXLDESCRIPTION	CHAR	60	0	Description of Dwelling Status
285	XUSAGETYPE	☐	REXCCHXROUSAGETYPE	RECAXLDESCRIPTION	CHAR	60	0	Description of Usage Type
286	.INCLUDE	☐				0	0	Migration: Rental Object Adjustment Data from RE Rental Unit
287	DHPZSAKT	☐	VVDHPZSAKT	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
288	DUTBKAKT	☐	VVDUTBKAKT	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
289	DTEURAKT	☐	VVDTEURAKT	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
290	SBASTEU	☐	VVSBASTEU	BASJHR	NUMC	4	0	Swiss rent adj.: Base year for standard of living index	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REXCAJMIRO_CH01_L	BUKRS	T001	BUKRS	KEY	1	CN
2	REXCAJMIRO_CH01_L	CONDK	TIVXCPTRACONS	CONSLEVEL
3	REXCAJMIRO_CH01_L	CURRENCY	TCURC	WAERS	KEY	1	CN
4	REXCAJMIRO_CH01_L	NEIGHBORH1	TIVBDNEIGHBORH	NEIGHBORHOOD
5	REXCAJMIRO_CH01_L	NEIGHBORH2	TIVBDNEIGHBORH	NEIGHBORHOOD
6	REXCAJMIRO_CH01_L	NEIGHBORH3	TIVBDNEIGHBORH	NEIGHBORHOOD
7	REXCAJMIRO_CH01_L	RESPONSIBLE	USR02	BNAME	REF	1	CN
8	REXCAJMIRO_CH01_L	RLGESCH	TIV38	RLGESCH	KEY	1	CN
9	REXCAJMIRO_CH01_L	RLRA	TIVAJRLRA	RLRA	REF	C	CN
10	REXCAJMIRO_CH01_L	RLRAAGE	TIVAJRLRAAGE	RLRAAGE	REF	C	CN
11	REXCAJMIRO_CH01_L	RLRAFIXFITCATE	TIVAJRLRAFFCT	RLRAFIXFITCATE	REF	C	CN
12	REXCAJMIRO_CH01_L	RLRALABEL	TIVAJRLRALABEL	RLRALABEL	REF	C	CN
13	REXCAJMIRO_CH01_L	RLRALOC	TIVAJRLRALOC	RLRALOC	REF	C	CN
14	REXCAJMIRO_CH01_L	RLRASIZ	TIVAJRLRASIZ	RLRASIZ	REF	C	CN
15	REXCAJMIRO_CH01_L	RPROZGRD	TIV43	RPROZGRD	KEY	1	CN
16	REXCAJMIRO_CH01_L	SGEBT	TIV12	SGEBT	KEY	1	CN
17	REXCAJMIRO_CH01_L	SNUNR	TIV01	SNUNR	REF	1	CN
18	REXCAJMIRO_CH01_L	SSTCKBIS	TIV37	SSTOCKW	KEY	1	C
19	REXCAJMIRO_CH01_L	SSTOCKW	TIV37	SSTOCKW	KEY	1	C
20	REXCAJMIRO_CH01_L	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
21	REXCAJMIRO_CH01_L	VPTCURRENCY	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in	605