SAP ABAP Table CMS_RE_OBJ_PRT (Real Estate Object part details)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-RE (Application Component) Real Estate
     ⤷ CMS_RE (Package) Collateral Management System: Real Esate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMS_RE_OBJ_PRT	Table Relationship Diagram
Short Description	Real Estate Object part details

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	*
2	.INCLUDE	☑				0	0	Primary key for Object part
3	OBJ_PRT_GUID	☑	CMS_RE_DTE_OBJ_PRT_GUID	SYSUUID	RAW	16	0	GUID for Object part
4	.INCLUDE	☐				0	0	Link structure for the real estate object
5	OBJ_GUID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object	CMS_RE_OBJ
6	.INCLUDE	☐				0	0	Structure for Part ID
7	PART_ID	☐	CMS_RE_DTE_PART_ID	CMS_RE_PRT_ID	NUMC	10	0	Part ID for the Object
8	.INCLUDE	☐				0	0	Structure for Basic Part Details
9	BLD_PART_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO006	CMS_ATT_ID_TYP	CHAR	6	0	Building Part Type	TCMS_ATT_ID_TY
10	PART_COND	☐	CMS_RE_DTE_ATT_ID_TY_REO001	CMS_ATT_ID_TYP	CHAR	6	0	Object condition	TCMS_ATT_ID_TY
11	MAIN_USAGE	☐	CMS_RE_DTE_USG_TYP	CMS_RE_TYP	CHAR	6	0	Usage Type	TCMS_RE_U_TYP
12	ADD_USAGE_1	☐	CMS_RE_DTE_ADD1_USG_TYP	CMS_RE_TYP	CHAR	6	0	Additional Usage 1	TCMS_RE_U_TYP
13	ADD_USAGE_2	☐	CMS_RE_DTE_ADD2_USG_TYP	CMS_RE_TYP	CHAR	6	0	Additional Usage 2	TCMS_RE_U_TYP
14	BLD_METHOD_ROOF	☐	CMS_RE_DTE_ATT_ID_TY_REO007	CMS_ATT_ID_TYP	CHAR	6	0	Building method - Roof	TCMS_ATT_ID_TY
15	BLD_METHOD_BODY	☐	CMS_RE_DTE_ATT_ID_TY_REO008	CMS_ATT_ID_TYP	CHAR	6	0	Building method - Body	TCMS_ATT_ID_TY
16	BLD_METD_CELLAR	☐	CMS_RE_DTE_ATT_ID_TY_REO009	CMS_ATT_ID_TYP	CHAR	6	0	Building method - Cellar	TCMS_ATT_ID_TY
17	UTILIZATION	☐	CMS_RE_DTE_PRT_UTILIZATION	CMS_RE_UTIL	CHAR	6	0	Utilization of the Object
18	PART_DESC	☐	CMS_RE_DTE_SPC_DESC	CMS_RE_DESC	CHAR	30	0	Description of Building Part
19	COMM_USAGE_PCT	☐	CMS_RE_DTE_COM_USE_PCT	CMS_RE_PCT	DEC	10	6	Commercial Usage as a Percentage of Total Usage
20	OTHER_USG_FLG	☐	CMS_RE_DTE_OTH_USE_FLG	CMS_RE_OTH_USG_FLG	CHAR	1	0	Indicates if Usages in addition to Main Usage are Possible
21	REF_OBJ_PRT_GUID	☐	CMS_RE_DTE_REF_OBJ_PRT_GUID	SYSUUID	RAW	16	0	Reference Object Part GUID
22	IS_SUB_AST_CREA	☐	CMS_RE_DTE_CREATE_SUB_AST_FLG	CMS_RE_FLG	CHAR	1	0	Indicates whether a Sub-asset is created for Building Part
23	.INCLUDE	☐				0	0	Structure for Part Size Details
24	USEFUL_AREA	☐	CMS_RE_DTE_AREA_USEFUL	CMS_RE_SIZE	QUAN	13	3	Usable Area
25	USBL_AREA_UOM	☐	CMS_RE_DTE_USBL_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Usable Area	*
26	USEFUL_AREA_REN	☐	CMS_RE_DTE_AREA_USEFUL_REN	CMS_RE_SIZE	QUAN	13	3	Rented Usable Area
27	USBL_AR_REN_UOM	☐	CMS_RE_DTE_USBL_AREA_REN_UOM	MEINS	UNIT	3	0	Unit of Measure for Usable Rented Area	*
28	USEFUL_VOL	☐	CMS_RE_DTE_VOL_USEFUL	CMS_RE_SIZE	QUAN	13	3	Usable Volume of Real Estate Building Parts
29	USBL_VOL_UOM	☐	CMS_RE_DTE_USBL_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Usable Volume of Real Estate	*
30	USEFUL_VOL_REN	☐	CMS_RE_DTE_VOL_USEFUL_REN	CMS_RE_SIZE	QUAN	13	3	Usable Volume of the Rented Portions of Real Estate
31	USBL_VL_REN_UOM	☐	CMS_RE_DTE_USBL_VOL_REN_UOM	MEINS	UNIT	3	0	Unit of measure for usable volume of Rented Parts	*
32	RESIDENTIAL_AREA	☐	CMS_RE_DTE_AREA_RESIDENTIAL	CMS_RE_SIZE	QUAN	13	3	Residential Area
33	RES_AR_UOM	☐	CMS_RE_DTE_RES_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Residential Area	*
34	SECONDARY_AREA	☐	CMS_RE_DTE_AREA_SECONDARY	CMS_RE_SIZE	QUAN	13	3	Secondary Area
35	SEC_AREA_UOM	☐	CMS_RE_DTE_SEC_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Secondary Area	*
36	OTHER_AREA	☐	CMS_RE_DTE_AREA_OTHER	CMS_RE_SIZE	QUAN	13	3	Other Area
37	OTH_AREA_UOM	☐	CMS_RE_DTE_OTH_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Other Area	*
38	.INCLUDE	☐				0	0	Structure for Part Unit Details
39	NO_PRT_UNIT	☐	CMS_RE_DTE_NO_PRT_UNIT	CMS_RE_UNITS	INT4	10	0	Number of building part units
40	NO_PRT_UNIT_REN	☐	CMS_RE_DTE_NO_PRT_UNIT_REN	CMS_RE_UNITS	INT4	10	0	Number of building part units rented
41	.INCLUDE	☐				0	0	Structure for dates
42	CONS_START_DATE	☐	CMS_RE_DTE_OBJ_CONS_ST_DATE	CMS_RE_DATE	DATS	8	0	Start Date of Construction
43	PERMSN_APPL_DATE	☐	CMS_RE_DTE_OBJ_PMSN_APPL_DATE	CMS_RE_DATE	DATS	8	0	Building Permssion applied date
44	PERMSN_OBTD_DATE	☐	CMS_RE_DTE_OBJ_PMSN_OBTD_DATE	CMS_RE_DATE	DATS	8	0	Building Permssion obtained date
45	OCCY_DATE	☐	CMS_RE_DTE_OBJ_OCCY_DATE	CMS_RE_DATE	DATS	8	0	Occupancy Date
46	COMP_DATE	☐	CMS_RE_DTE_OBJ_COMP_DATE	CMS_RE_DATE	DATS	8	0	Completion Date
47	FINAL_INSP_DATE	☐	CMS_RE_DTE_OBJ_FINAL_INSP_DATE	CMS_RE_DATE	DATS	8	0	Date of Final Inspection
48	.INCLUDE	☐				0	0
49	.INCLUDE	☐				0	0	Structure for Part Rent Details
50	RENT_AMT_PLANNED	☐	CMS_RE_DTE_RENT_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Planned Rent Amount
51	RENT_AMT_ACTUAL	☐	CMS_RE_DTE_RENT_AMOUNT_ACT	CMS_RE_AMOUNT	CURR	17	2	Actual Rent Amount
52	RENT_PLAN_CURR	☐	CMS_RE_DTE_RENT_PLANNED_CURR	WAERS	CUKY	5	0	Planned Rent Currency	TCURC
53	RENT_ACT_CURR	☐	CMS_RE_DTE_RENT_ACTUAL_CURR	WAERS	CUKY	5	0	Actual Rent Currency	TCURC
54	BASE_PERIOD	☐	CMS_RE_DTE_BASE_PERIOD	CMS_RE_BASE_PERIOD	CHAR	1	0	Base period for the rent
55	BASE_MEASURE	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
56	VACANT_POSN_PCT	☐	CMS_RE_DTE_VACANT_POS_PCT	CMS_RE_PCT	DEC	10	6	Ratio of Real Estate not rented to Total Real Estate Value
57	RES_RENT_IND	☐	CMS_RE_DTE_RES_IND	CMS_RE_RENT_FLG	CHAR	1	0	Indicator for Net or Gross Rent
58	COMP_RENT_RES	☐	CMS_RE_DTE_RENT_LEVEL	CMS_RE_AMOUNT	CURR	17	2	Comparative Rent (Residential)
59	COM_REN_RES_CURR	☐	CMS_RE_DTE_COMP_RENT_RES_CURR	WAERS	CUKY	5	0	Comparative Rent Currency - Residential	TCURC
60	.INCLUDE	☐				0	0	Structure for Land Area & UOM
61	LAND_AREA	☐	CMS_RE_DTE_LAND_AREA	CMS_RE_SIZE	QUAN	13	3	Land Area of the Real Estate
62	LAND_AREA_UOM	☐	CMS_RE_DTE_LAND_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure of Land Area	T006
63	LAND_AREA_REN	☐	CMS_RE_DTE_LAND_AREA_REN	CMS_RE_SIZE	QUAN	13	3	Land Area of the Real Estate which is Rented
64	LAND_AR_REN_UOM	☐	CMS_RE_DTE_LAND_AREA_REN_UOM	MEINS	UNIT	3	0	Land area unit of measure(rented)	*
65	.INCLUDE	☐				0	0	Structure for General Details
66	NO_OF_UNITS	☐	CMS_RE_DTE_NO_UNIT	CMS_RE_UNITS	INT4	10	0	No of units in real estate object
67	NO_OF_FLOORS	☐	CMS_RE_DTE_NO_FLOOR	CMS_RE_UNITS	INT4	10	0	Number of Floors
68	NO_GARAGES	☐	CMS_RE_DTE_NO_GAR	CMS_RE_UNITS	INT4	10	0	No of Garages in Real Estate Object
69	NO_GARAGES_REN	☐	CMS_RE_DTE_NO_GAR_REN	CMS_RE_UNITS	INT4	10	0	No of Garages Rented in Real Estate Object
70	NO_PARK_UNIT	☐	CMS_RE_DTE_NO_PARK_UNIT	CMS_RE_UNITS	INT4	10	0	Number of Parking Units
71	NO_PARK_UNIT_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_REN	CMS_RE_UNITS	INT4	10	0	Number of Parking Units Rented
72	NO_PARK_UG	☐	CMS_RE_DTE_NO_PARK_UNIT_UG	CMS_RE_UNITS	INT4	10	0	Number of Underground Parking Units
73	NO_PARK_UG_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_UG_REN	CMS_RE_UNITS	INT4	10	0	Number of Rented Underground Parking Units
74	.INCLUDE	☐				0	0	Structure for Residential Details
75	NO_CUR_UNITS	☐	CMS_RE_DTE_NO_CUR_UNIT	CMS_RE_UNITS	INT4	10	0	No of current units in real estate object
76	NO_CUR_UNITS_REN	☐	CMS_RE_DTE_NO_CUR_UNIT_REN	CMS_RE_UNITS	INT4	10	0	No of Current Units Rented in Real Estate Object
77	NO_OLD_UNITS	☐	CMS_RE_DTE_NO_OLD_UNIT	CMS_RE_UNITS	INT4	10	0	No of old units in real estate object
78	NO_OLD_UNITS_REN	☐	CMS_RE_DTE_NO_OLD_UNIT_REN	CMS_RE_UNITS	INT4	10	0	No of Old Units Rented in Real Estate Object
79	NO_NEW_UNITS	☐	CMS_RE_DTE_NO_NEW_UNIT	CMS_RE_UNITS	INT4	10	0	No of new units in real estate object
80	NO_NEW_UNITS_REN	☐	CMS_RE_DTE_NO_NEW_UNIT_REN	CMS_RE_UNITS	INT4	10	0	No of New units Rented in Real Estate Object
81	.INCLUDE	☐				0	0	Structure for Number of Units in Office
82	NO_ACCESS_STR	☐	CMS_RE_DTE_NO_ACCESS_STR	CMS_RE_UNITS	INT4	10	0	No of Access Structures
83	.INCLUDE	☐				0	0	Structure for Number of Sales level in Commericial Building
84	NO_SALE_LEVEL	☐	CMS_RE_DTE_NO_SALE_LEVEL	CMS_RE_UNITS	INT4	10	0	No of Sale levels in commercial building
85	.INCLUDE	☐				0	0	Structure for Number of Rooms in the hotel/clinic
86	NO_OF_ROOMS	☐	CMS_RE_DTE_NO_ROOMS	CMS_RE_UNITS	INT4	10	0	No of rooms in the hotel/clinic
87	.INCLUDE	☐				0	0	Structure for Number of rooms in the clinic/nursing home
88	NO_OF_BEDS	☐	CMS_RE_DTE_NO_BEDS	CMS_RE_UNITS	INT4	10	0	No of beds in the clinic/nursing home
89	.INCLUDE	☐				0	0
90	.INCLUDE	☐				0	0	Structure for Commericial Details
91	COMM_ENV_DESC	☐	CMS_RE_DTE_COMM_ENV_DESC	CMS_RE_DESC	CHAR	30	0	Description of the commercial environment
92	ACCESS_STR_DESC	☐	CMS_RE_DTE_ACCESS_STR_DESC	CMS_RE_DESC	CHAR	30	0	Description of the Access Structures
93	BLD_SECTION_DESC	☐	CMS_RE_DTE_ATT_ID_TY_REO015	CMS_ATT_ID_TYP	CHAR	6	0	Building Section	TCMS_ATT_ID_TY
94	.INCLUDE	☐				0	0
95	.INCLUDE	☐				0	0	Structure for Hotel Details
96	PRICE_CATEGORY	☐	CMS_RE_DTE_ATT_ID_TY_REO013	CMS_ATT_ID_TYP	CHAR	6	0	Price Category	TCMS_ATT_ID_TY
97	AVG_PRICE	☐	CMS_RE_DTE_AVG_PRICE	CMS_RE_AMOUNT	CURR	17	2	Average Price per Day
98	AVG_PRICE_CURR	☐	CMS_RE_DTE_AVG_PRICE_CURR	WAERS	CUKY	5	0	Average Price Currency	TCURC
99	.INCLUDE	☐				0	0
100	.INCLUDE	☐				0	0	Structure for Other Details in RE Object
101	OCCUPANCY_PCT	☐	CMS_RE_DTE_OCCY_PCT	CMS_RE_PCT	DEC	10	6	Occupancy specified in Percentage Terms
102	TURNOVER_AMT	☐	CMS_RE_DTE_TURNOVER_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Total Amount of Turnover
103	TURNOVER_CURR	☐	CMS_RE_DTE_TURNOVER_CURR	WAERS	CUKY	5	0	Currency	TCURC
104	RENTAL_AGMT_TYP	☐	CMS_RE_DTE_ATT_ID_TY_REO014	CMS_ATT_ID_TYP	CHAR	6	0	Rental Agreement Type	TCMS_ATT_ID_TY
105	.INCLUDE	☐				0	0	Building Construction Progress
106	LAST_REPORT_DATE	☐	CMS_RE_DTE_LAST_CONST_REP_DATE	CMS_RE_DATE	DATS	8	0	Date of Last Constuction Report
107	BLD_PROGRESS_AMT	☐	CMS_RE_DTE_AMT_BLD_PROGRESS	CMS_RE_AMOUNT	CURR	17	2	Amount Disbursed for Construction based on Building Progress
108	BLD_AMT_CURR	☐	CMS_RE_DTE_BLD_PROGRESS_CURR	WAERS	CUKY	5	0	Building Progress Amount Curreny	*
109	PCT_COMPLETED	☐	CMS_RE_DTE_DEGREE_COMPLETE	CMS_RE_PCT	DEC	10	6	Degree of Completion of Construction
110	.INCLUDE	☐				0	0	Insurance details
111	INSURANCE_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO011	CMS_ATT_ID_TYP	CHAR	6	0	Insurance Type	TCMS_ATT_ID_TY
112	INSURANCE_AMT	☐	CMS_RE_DTE_INSURANCE_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Insurance Amount
113	INSURANCE_CURR	☐	CMS_RE_DTE_INSURANCE_CURR	WAERS	CUKY	5	0	Insurance Currency	TCURC
114	INS_VALIDITY	☐	CMS_RE_DTE_INS_VALID_TILL	CMS_RE_DATE	DATS	8	0	Date until which the Insurance Stands Valid
115	.INCLUDE	☐				0	0	Other Costs
116	RATIONING_COST	☐	CMS_RE_DTE_RAT_COST_AMT	CMS_RE_AMOUNT	CURR	17	2	Residential Rationing Cost
117	RTN_CST_PCT	☐	CMS_RE_DTE_RAN_COST_PCT	CMS_RE_PCT	DEC	10	6	Percentage of Residential Rationing Cost
118	EXT_LAYOUT_COST	☐	CMS_RE_DTE_EXT_LAYOUT_COST	CMS_RE_AMOUNT	CURR	17	2	External Layout Cost
119	EXT_LAY_CST_PCT	☐	CMS_RE_DTE_EXT_LAYOUT_COST_PCT	CMS_RE_PCT	DEC	10	6	External Layout Cost as Percentage of Total Cost
120	RTN_CST_CURR	☐	CMS_RE_DTE_RTN_CST_CURR	WAERS	CUKY	5	0	Rationing cost currency	*
121	EXT_RTN_CST_CURR	☐	CMS_RE_DTE_EXT_LAYOUT_CST_CURR	WAERS	CUKY	5	0	External Layout cost currency	*
122	RTN_CST_COM	☐	CMS_RE_DTE_RAT_COST_AMT_COM	CMS_RE_AMOUNT	CURR	17	2	Commercial Rationing Cost
123	RTN_CST_COM_CURR	☐	CMS_RE_DTE_RTN_CST_CURR_COM	WAERS	CUKY	5	0	Rationing cost currency	*
124	RTN_CST_COM_PCT	☐	CMS_RE_DTE_RAN_COST_PCT_COM	CMS_RE_PCT	DEC	10	6	Percentage of Commercial Rationing Cost
125	.INCLUDE	☐				0	0	Other rents
126	GROSS_COLD_RENT	☐	CMS_RE_DTE_YRLY_GROSS_COLD_REN	CMS_RE_AMOUNT	CURR	17	2	Gross Cold Rent
127	GROSS_RENT_CURR	☐	CMS_RE_DTE_GROSS_RENT_CURR	WAERS	CUKY	5	0	Gross Cold Rent Currency	TCURC
128	NET_COLD_RENT	☐	CMS_RE_DTE_YRLY_NET_COLD_REN	CMS_RE_AMOUNT	CURR	17	2	Net Cold Rent
129	NET_RENT_CURR	☐	CMS_RE_DTE_NET_RENT_CURR	WAERS	CUKY	5	0	Net Cold Rent Currency	TCURC
130	.INCLUDE	☐				0	0	Structure for history
131	CREATED_BY	☐	CMS_RE_DTE_CR_BY	CMS_RE_USER	CHAR	12	0	Real Estate Add-On User
132	CREATED_DATE	☐	CMS_RE_DTE_CR_ON	CMS_RE_DATE	DATS	8	0	Created On
133	CREATED_TIME	☐	CMS_RE_DTE_CR_AT	CMS_RE_TIME	TIMS	6	0	Created At
134	ENTRY_SRC	☐	CMS_RE_DTE_SRC_INIT	CMS_RE_SOURCE	CHAR	32	0	Sorce of Initial entry
135	LAST_CHG_BY	☐	CMS_RE_DTE_CHG_BY	CMS_RE_USER	CHAR	12	0	Last Changed By
136	LAST_CHG_DATE	☐	CMS_RE_DTE_CHG_ON	CMS_RE_DATE	DATS	8	0	Last Changed On
137	LAST_CHG_TIME	☐	CMS_RE_DTE_CHG_AT	CMS_RE_TIME	TIMS	6	0	Last Changed At
138	PROCESSING_SRC	☐	CMS_RE_DTE_PRC_SRC	CMS_RE_SOURCE	CHAR	32	0	Processing Source
139	.INCLUDE	☐				0	0
140	.INCLUDE	☐				0	0	Valuation Bases(Com)
141	NO_OF_YEARS_COM	☐	CMS_RE_DTE_VAL_NO_YEARS_COM	CMS_RE_INT1	INT1	3	0	No of years since Last Valuation of Commercial Real Estate
142	INT_RATE_COM	☐	CMS_RE_DTE_VAL_INT_RATE_COM	CMS_RE_PCT	DEC	10	6	Interest rate (Com)
143	.INCLUDE	☐				0	0	Valuation Bases
144	NO_OF_YEARS	☐	CMS_RE_DTE_VALUATION_NO_YEARS	CMS_RE_INT1	INT1	3	0	No. of Years since Real Estate was last Valued
145	INT_RATE	☐	CMS_RE_DTE_VALUATION_INT_RATE	CMS_RE_PCT	DEC	10	6	Interest rate used in Valuation of Residential Real Estate
146	.INCLUDE	☐				0	0	Structure for Part Rent Details
147	RENT_PLANNED_COM	☐	CMS_RE_DTE_RENT_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Planned Rent Amount
148	RENT_ACTUAL_COM	☐	CMS_RE_DTE_RENT_AMOUNT_ACT	CMS_RE_AMOUNT	CURR	17	2	Actual Rent Amount
149	PLAN_CURR_COM	☐	CMS_RE_DTE_RENT_PLANNED_CURR	WAERS	CUKY	5	0	Planned Rent Currency	TCURC
150	ACT_CURR_COM	☐	CMS_RE_DTE_RENT_ACTUAL_CURR	WAERS	CUKY	5	0	Actual Rent Currency	TCURC
151	BASE_PERIOD_COM	☐	CMS_RE_DTE_BASE_PERIOD	CMS_RE_BASE_PERIOD	CHAR	1	0	Base period for the rent
152	BASE_MEAS_COM	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
153	COM_RENT_IND	☐	CMS_RE_DTE_COM_IND	CMS_RE_RENT_FLG	CHAR	1	0	Indicator for Rent Type
154	COMP_RENT_COM	☐	CMS_RE_DTE_RENT_LEVEL_COM	CMS_RE_AMOUNT	CURR	17	2	Comparative Rent (Commercial)
155	COMP_REN_COM_CUR	☐	CMS_RE_DTE_COMP_RENT_COM_CURR	WAERS	CUKY	5	0	Comparative Rent Currency (Commercial)	TCURC
156	.INCLUDE	☐				0	0	Structure for Land Rent details
157	PLAN_RENT_LAND	☐	CMS_RE_DTE_RENT_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Planned Rent Amount
158	ACTUAL_RENT_LAND	☐	CMS_RE_DTE_RENT_AMOUNT_ACT	CMS_RE_AMOUNT	CURR	17	2	Actual Rent Amount
159	PLAN_RENT_CURR	☐	CMS_RE_DTE_RENT_PLANNED_CURR	WAERS	CUKY	5	0	Planned Rent Currency	TCURC
160	ACTUAL_RENT_CURR	☐	CMS_RE_DTE_RENT_ACTUAL_CURR	WAERS	CUKY	5	0	Actual Rent Currency	*
161	BASE_PERIOD_LAND	☐	CMS_RE_DTE_BASE_PERIOD	CMS_RE_BASE_PERIOD	CHAR	1	0	Base period for the rent
162	BASE_MEAS_LAND	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
163	.INCLUDE	☐				0	0	Depriciation
164	DEPR	☐	CMS_RE_DTE_DEPR	CMS_RE_PCT	DEC	10	6	Depriciation
165	.INCLUDE	☐				0	0	Land Costs
166	LAND_COST	☐	CMS_RE_DTE_LAND_COST	CMS_RE_AMOUNT	CURR	17	2	Land Cost Amount
167	LAND_COST_CURR	☐	CMS_RE_DTE_LAND_COST_CURR	WAERS	CUKY	5	0	Land Cost Currency	*
168	DEV_COST	☐	CMS_RE_DTE_DEV_COST	CMS_RE_AMOUNT	CURR	17	2	Development Cost Amount
169	DEV_COST_CURR	☐	CMS_RE_DTE_DEV_COST_CURR	WAERS	CUKY	5	0	Dev Cost Currency	*
170	LAND_CST_BASE	☐	CMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure of Land
171	DEV_CST_BASE	☐	CMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure of Land
172	ADD_LAND_CST	☐	CMS_RE_DTE_ADD_LAND_COST	CMS_RE_AMOUNT	CURR	17	2	Additional Land Cost Amount
173	ADD_CST_CURR	☐	CMS_RE_DTE_ADD_LAND_COST_CURR	WAERS	CUKY	5	0	Additional Land Cost Currency	*
174	ADD_CST_BASE	☐	CMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure of Land
175	.INCLUDE	☐				0	0	Construction Costs for Buildings
176	CONST_COST	☐	CMS_RE_DTE_CONS_COST	CMS_RE_AMOUNT	CURR	17	2	Construction Cost
177	CONST_COST_CURR	☐	CMS_RE_DTE_CONS_COST_CURR	WAERS	CUKY	5	0	Construction cost currency	*
178	BASE_MEAS	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
179	.INCLUDE	☐				0	0	Yearly Gross Profit for Commercial Real Estate
180	GRS_PROFIT	☐	CMS_RE_DTE_GRS_PROFIT	CMS_RE_AMOUNT	CURR	17	2	Yearly Gross Profit
181	GRS_PROFIT_CURR	☐	CMS_RE_DTE_GRS_PROFIT_CURR	WAERS	CUKY	5	0	Yearly Gross Profit Currency	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_RE_OBJ_PRT	ACT_CURR_COM	TCURC	WAERS	REF	1	CN
2	CMS_RE_OBJ_PRT	ADD_USAGE_1	TCMS_RE_U_TYP	USAGE_TYPE	REF	1	CN
3	CMS_RE_OBJ_PRT	ADD_USAGE_2	TCMS_RE_U_TYP	USAGE_TYPE	REF	1	CN
4	CMS_RE_OBJ_PRT	AVG_PRICE_CURR	TCURC	WAERS	REF	1	CN
5	CMS_RE_OBJ_PRT	BLD_METD_CELLAR	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
6	CMS_RE_OBJ_PRT	BLD_METHOD_BODY	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
7	CMS_RE_OBJ_PRT	BLD_METHOD_ROOF	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
8	CMS_RE_OBJ_PRT	BLD_PART_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
9	CMS_RE_OBJ_PRT	BLD_SECTION_DESC	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
10	CMS_RE_OBJ_PRT	COMP_REN_COM_CUR	TCURC	WAERS	REF	1	CN
11	CMS_RE_OBJ_PRT	COM_REN_RES_CURR	TCURC	WAERS	REF	1	CN
12	CMS_RE_OBJ_PRT	GROSS_RENT_CURR	TCURC	WAERS	REF	1	CN
13	CMS_RE_OBJ_PRT	INSURANCE_CURR	TCURC	WAERS	REF	1	CN
14	CMS_RE_OBJ_PRT	INSURANCE_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
15	CMS_RE_OBJ_PRT	LAND_AREA_UOM	T006	MSEHI	REF	1	CN
16	CMS_RE_OBJ_PRT	MAIN_USAGE	TCMS_RE_U_TYP	USAGE_TYPE	REF	1	CN
17	CMS_RE_OBJ_PRT	NET_RENT_CURR	TCURC	WAERS	REF	1	CN
18	CMS_RE_OBJ_PRT	PART_COND	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
19	CMS_RE_OBJ_PRT	PLAN_CURR_COM	TCURC	WAERS	REF	1	CN
20	CMS_RE_OBJ_PRT	PLAN_RENT_CURR	TCURC	WAERS	REF	1	CN
21	CMS_RE_OBJ_PRT	PRICE_CATEGORY	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
22	CMS_RE_OBJ_PRT	RENTAL_AGMT_TYP	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
23	CMS_RE_OBJ_PRT	RENT_ACT_CURR	TCURC	WAERS	REF	1	CN
24	CMS_RE_OBJ_PRT	RENT_PLAN_CURR	TCURC	WAERS	REF	1	CN
25	CMS_RE_OBJ_PRT	TURNOVER_CURR	TCURC	WAERS	REF	1	CN

History

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