SAP ABAP Table CMS_STR_COR_OBJ_PRT (Real estate object parts)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS (Application Component) Collateral Management System
     ⤷ CMS_COR (Package) Correspondence serivce for CMS

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_COR_OBJ_PRT	Table Relationship Diagram
Short Description	Real estate object parts

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	WA_OBJ_PRT	☐	CMS_RE_STR_OBJ_PRT_MAP_GET		STRU	0	0
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
6	.INCLUDE	☐				0	0	Structure for Semantic key for Objects in RE Add-On
7	OBJECT_ID	☐	CMS_RE_DTE_OBJECT_ID	CMS_RE_OBJECT_ID	CHAR	20	0	Object ID
8	OBJECT_TYPE	☐	CMS_RE_DTE_OBJ_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Object Type ID
9	.INCLUDE	☐				0	0	Structure for Part ID
10	PART_ID	☐	CMS_RE_DTE_PART_ID	CMS_RE_PRT_ID	NUMC	10	0	Part ID for the Object
11	.INCLUDE	☐				0	0	Structure for Basic Part Details
12	BLD_PART_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO006	CMS_ATT_ID_TYP	CHAR	6	0	Building Part Type
13	PART_COND	☐	CMS_RE_DTE_ATT_ID_TY_REO001	CMS_ATT_ID_TYP	CHAR	6	0	Object condition
14	MAIN_USAGE	☐	CMS_RE_DTE_USG_TYP	CMS_RE_TYP	CHAR	6	0	Usage Type
15	ADD_USAGE_1	☐	CMS_RE_DTE_ADD1_USG_TYP	CMS_RE_TYP	CHAR	6	0	Additional Usage 1
16	ADD_USAGE_2	☐	CMS_RE_DTE_ADD2_USG_TYP	CMS_RE_TYP	CHAR	6	0	Additional Usage 2
17	BLD_METHOD_ROOF	☐	CMS_RE_DTE_ATT_ID_TY_REO007	CMS_ATT_ID_TYP	CHAR	6	0	Building method - Roof
18	BLD_METHOD_BODY	☐	CMS_RE_DTE_ATT_ID_TY_REO008	CMS_ATT_ID_TYP	CHAR	6	0	Building method - Body
19	BLD_METD_CELLAR	☐	CMS_RE_DTE_ATT_ID_TY_REO009	CMS_ATT_ID_TYP	CHAR	6	0	Building method - Cellar
20	UTILIZATION	☐	CMS_RE_DTE_PRT_UTILIZATION	CMS_RE_UTIL	CHAR	6	0	Utilization of the Object
21	PART_DESC	☐	CMS_RE_DTE_SPC_DESC	CMS_RE_DESC	CHAR	30	0	Description of Building Part
22	COMM_USAGE_PCT	☐	CMS_RE_DTE_COM_USE_PCT	CMS_RE_PCT	DEC	10	6	Commercial Usage as a Percentage of Total Usage
23	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
24	REF_OBJ_PRT_GUID	☐	CMS_RE_DTE_REF_OBJ_PRT_GUID	SYSUUID	RAW	16	0	Reference Object Part GUID
25	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
26	.INCLUDE	☐				0	0	Structure for Part Size Details
27	USEFUL_AREA	☐	CMS_RE_DTE_AREA_USEFUL	CMS_RE_SIZE	QUAN	13	3	Usable Area
28	USBL_AREA_UOM	☐	CMS_RE_DTE_USBL_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Usable Area
29	USEFUL_AREA_REN	☐	CMS_RE_DTE_AREA_USEFUL_REN	CMS_RE_SIZE	QUAN	13	3	Rented Usable Area
30	USBL_AR_REN_UOM	☐	CMS_RE_DTE_USBL_AREA_REN_UOM	MEINS	UNIT	3	0	Unit of Measure for Usable Rented Area
31	USEFUL_VOL	☐	CMS_RE_DTE_VOL_USEFUL	CMS_RE_SIZE	QUAN	13	3	Usable Volume of Real Estate Building Parts
32	USBL_VOL_UOM	☐	CMS_RE_DTE_USBL_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Usable Volume of Real Estate
33	USEFUL_VOL_REN	☐	CMS_RE_DTE_VOL_USEFUL_REN	CMS_RE_SIZE	QUAN	13	3	Usable Volume of the Rented Portions of Real Estate
34	USBL_VL_REN_UOM	☐	CMS_RE_DTE_USBL_VOL_REN_UOM	MEINS	UNIT	3	0	Unit of measure for usable volume of Rented Parts
35	RESIDENTIAL_AREA	☐	CMS_RE_DTE_AREA_RESIDENTIAL	CMS_RE_SIZE	QUAN	13	3	Residential Area
36	RES_AR_UOM	☐	CMS_RE_DTE_RES_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Residential Area
37	SECONDARY_AREA	☐	CMS_RE_DTE_AREA_SECONDARY	CMS_RE_SIZE	QUAN	13	3	Secondary Area
38	SEC_AREA_UOM	☐	CMS_RE_DTE_SEC_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Secondary Area
39	OTHER_AREA	☐	CMS_RE_DTE_AREA_OTHER	CMS_RE_SIZE	QUAN	13	3	Other Area
40	OTH_AREA_UOM	☐	CMS_RE_DTE_OTH_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Other Area
41	.INCLUDE	☐				0	0	Structure for Part Unit Details
42	NO_PRT_UNIT	☐	CMS_RE_DTE_NO_PRT_UNIT	CMS_RE_UNITS	INT4	10	0	Number of building part units
43	NO_PRT_UNIT_REN	☐	CMS_RE_DTE_NO_PRT_UNIT_REN	CMS_RE_UNITS	INT4	10	0	Number of building part units rented
44	.INCLUDE	☐				0	0	Structure for dates
45	CONS_START_DATE	☐	CMS_RE_DTE_OBJ_CONS_ST_DATE	CMS_RE_DATE	DATS	8	0	Start Date of Construction
46	PERMSN_APPL_DATE	☐	CMS_RE_DTE_OBJ_PMSN_APPL_DATE	CMS_RE_DATE	DATS	8	0	Building Permssion applied date
47	PERMSN_OBTD_DATE	☐	CMS_RE_DTE_OBJ_PMSN_OBTD_DATE	CMS_RE_DATE	DATS	8	0	Building Permssion obtained date
48	OCCY_DATE	☐	CMS_RE_DTE_OBJ_OCCY_DATE	CMS_RE_DATE	DATS	8	0	Occupancy Date
49	COMP_DATE	☐	CMS_RE_DTE_OBJ_COMP_DATE	CMS_RE_DATE	DATS	8	0	Completion Date
50	FINAL_INSP_DATE	☐	CMS_RE_DTE_OBJ_FINAL_INSP_DATE	CMS_RE_DATE	DATS	8	0	Date of Final Inspection
51	.INCLUDE	☐				0	0
52	.INCLUDE	☐				0	0	Structure for Part Rent Details
53	RENT_AMT_PLANNED	☐	CMS_RE_DTE_RENT_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Planned Rent Amount
54	RENT_AMT_ACTUAL	☐	CMS_RE_DTE_RENT_AMOUNT_ACT	CMS_RE_AMOUNT	CURR	17	2	Actual Rent Amount
55	RENT_PLAN_CURR	☐	CMS_RE_DTE_RENT_PLANNED_CURR	WAERS	CUKY	5	0	Planned Rent Currency
56	RENT_ACT_CURR	☐	CMS_RE_DTE_RENT_ACTUAL_CURR	WAERS	CUKY	5	0	Actual Rent Currency
57	BASE_PERIOD	☐	CMS_RE_DTE_BASE_PERIOD	CMS_RE_BASE_PERIOD	CHAR	1	0	Base period for the rent
58	BASE_MEASURE	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
59	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
60	RES_RENT_IND	☐	CMS_RE_DTE_RES_IND	CMS_RE_RENT_FLG	CHAR	1	0	Indicator for Net or Gross Rent
61	COMP_RENT_RES	☐	CMS_RE_DTE_RENT_LEVEL	CMS_RE_AMOUNT	CURR	17	2	Comparative Rent (Residential)
62	COM_REN_RES_CURR	☐	CMS_RE_DTE_COMP_RENT_RES_CURR	WAERS	CUKY	5	0	Comparative Rent Currency - Residential
63	.INCLUDE	☐				0	0	Structure for Land Area & UOM
64	LAND_AREA	☐	CMS_RE_DTE_LAND_AREA	CMS_RE_SIZE	QUAN	13	3	Land Area of the Real Estate
65	LAND_AREA_UOM	☐	CMS_RE_DTE_LAND_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure of Land Area
66	LAND_AREA_REN	☐	CMS_RE_DTE_LAND_AREA_REN	CMS_RE_SIZE	QUAN	13	3	Land Area of the Real Estate which is Rented
67	LAND_AR_REN_UOM	☐	CMS_RE_DTE_LAND_AREA_REN_UOM	MEINS	UNIT	3	0	Land area unit of measure(rented)
68	.INCLUDE	☐				0	0	Structure for General Details
69	NO_OF_UNITS	☐	CMS_RE_DTE_NO_UNIT	CMS_RE_UNITS	INT4	10	0	No of units in real estate object
70	NO_OF_FLOORS	☐	CMS_RE_DTE_NO_FLOOR	CMS_RE_UNITS	INT4	10	0	Number of Floors
71	NO_GARAGES	☐	CMS_RE_DTE_NO_GAR	CMS_RE_UNITS	INT4	10	0	No of Garages in Real Estate Object
72	NO_GARAGES_REN	☐	CMS_RE_DTE_NO_GAR_REN	CMS_RE_UNITS	INT4	10	0	No of Garages Rented in Real Estate Object
73	NO_PARK_UNIT	☐	CMS_RE_DTE_NO_PARK_UNIT	CMS_RE_UNITS	INT4	10	0	Number of Parking Units
74	NO_PARK_UNIT_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_REN	CMS_RE_UNITS	INT4	10	0	Number of Parking Units Rented
75	NO_PARK_UG	☐	CMS_RE_DTE_NO_PARK_UNIT_UG	CMS_RE_UNITS	INT4	10	0	Number of Underground Parking Units
76	NO_PARK_UG_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_UG_REN	CMS_RE_UNITS	INT4	10	0	Number of Rented Underground Parking Units
77	.INCLUDE	☐				0	0	Structure for Residential Details
78	NO_CUR_UNITS	☐	CMS_RE_DTE_NO_CUR_UNIT	CMS_RE_UNITS	INT4	10	0	No of current units in real estate object
79	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
80	NO_OLD_UNITS	☐	CMS_RE_DTE_NO_OLD_UNIT	CMS_RE_UNITS	INT4	10	0	No of old units in real estate object
81	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
82	NO_NEW_UNITS	☐	CMS_RE_DTE_NO_NEW_UNIT	CMS_RE_UNITS	INT4	10	0	No of new units in real estate object
83	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
84	.INCLUDE	☐				0	0	Structure for Number of Units in Office
85	NO_ACCESS_STR	☐	CMS_RE_DTE_NO_ACCESS_STR	CMS_RE_UNITS	INT4	10	0	No of Access Structures
86	.INCLUDE	☐				0	0	Structure for Number of Sales level in Commericial Building
87	NO_SALE_LEVEL	☐	CMS_RE_DTE_NO_SALE_LEVEL	CMS_RE_UNITS	INT4	10	0	No of Sale levels in commercial building
88	.INCLUDE	☐				0	0	Structure for Number of Rooms in the hotel/clinic
89	NO_OF_ROOMS	☐	CMS_RE_DTE_NO_ROOMS	CMS_RE_UNITS	INT4	10	0	No of rooms in the hotel/clinic
90	.INCLUDE	☐				0	0	Structure for Number of rooms in the clinic/nursing home
91	NO_OF_BEDS	☐	CMS_RE_DTE_NO_BEDS	CMS_RE_UNITS	INT4	10	0	No of beds in the clinic/nursing home
92	.INCLUDE	☐				0	0
93	.INCLUDE	☐				0	0	Structure for Commericial Details
94	COMM_ENV_DESC	☐	CMS_RE_DTE_COMM_ENV_DESC	CMS_RE_DESC	CHAR	30	0	Description of the commercial environment
95	ACCESS_STR_DESC	☐	CMS_RE_DTE_ACCESS_STR_DESC	CMS_RE_DESC	CHAR	30	0	Description of the Access Structures
96	BLD_SECTION_DESC	☐	CMS_RE_DTE_ATT_ID_TY_REO015	CMS_ATT_ID_TYP	CHAR	6	0	Building Section
97	.INCLUDE	☐				0	0
98	.INCLUDE	☐				0	0	Structure for Hotel Details
99	PRICE_CATEGORY	☐	CMS_RE_DTE_ATT_ID_TY_REO013	CMS_ATT_ID_TYP	CHAR	6	0	Price Category
100	AVG_PRICE	☐	CMS_RE_DTE_AVG_PRICE	CMS_RE_AMOUNT	CURR	17	2	Average Price per Day
101	AVG_PRICE_CURR	☐	CMS_RE_DTE_AVG_PRICE_CURR	WAERS	CUKY	5	0	Average Price Currency
102	.INCLUDE	☐				0	0
103	.INCLUDE	☐				0	0	Structure for Other Details in RE Object
104	OCCUPANCY_PCT	☐	CMS_RE_DTE_OCCY_PCT	CMS_RE_PCT	DEC	10	6	Occupancy specified in Percentage Terms
105	TURNOVER_AMT	☐	CMS_RE_DTE_TURNOVER_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Total Amount of Turnover
106	TURNOVER_CURR	☐	CMS_RE_DTE_TURNOVER_CURR	WAERS	CUKY	5	0	Currency
107	RENTAL_AGMT_TYP	☐	CMS_RE_DTE_ATT_ID_TY_REO014	CMS_ATT_ID_TYP	CHAR	6	0	Rental Agreement Type
108	.INCLUDE	☐				0	0	Insurance details
109	INSURANCE_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO011	CMS_ATT_ID_TYP	CHAR	6	0	Insurance Type
110	INSURANCE_AMT	☐	CMS_RE_DTE_INSURANCE_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Insurance Amount
111	INSURANCE_CURR	☐	CMS_RE_DTE_INSURANCE_CURR	WAERS	CUKY	5	0	Insurance Currency
112	INS_VALIDITY	☐	CMS_RE_DTE_INS_VALID_TILL	CMS_RE_DATE	DATS	8	0	Date until which the Insurance Stands Valid
113	.INCLUDE	☐				0	0	Other Costs
114	RATIONING_COST	☐	CMS_RE_DTE_RAT_COST_AMT	CMS_RE_AMOUNT	CURR	17	2	Residential Rationing Cost
115	RTN_CST_PCT	☐	CMS_RE_DTE_RAN_COST_PCT	CMS_RE_PCT	DEC	10	6	Percentage of Residential Rationing Cost
116	EXT_LAYOUT_COST	☐	CMS_RE_DTE_EXT_LAYOUT_COST	CMS_RE_AMOUNT	CURR	17	2	External Layout Cost
117	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
118	RTN_CST_CURR	☐	CMS_RE_DTE_RTN_CST_CURR	WAERS	CUKY	5	0	Rationing cost currency
119	EXT_RTN_CST_CURR	☐	CMS_RE_DTE_EXT_LAYOUT_CST_CURR	WAERS	CUKY	5	0	External Layout cost currency
120	RTN_CST_COM	☐	CMS_RE_DTE_RAT_COST_AMT_COM	CMS_RE_AMOUNT	CURR	17	2	Commercial Rationing Cost
121	RTN_CST_COM_CURR	☐	CMS_RE_DTE_RTN_CST_CURR_COM	WAERS	CUKY	5	0	Rationing cost currency
122	RTN_CST_COM_PCT	☐	CMS_RE_DTE_RAN_COST_PCT_COM	CMS_RE_PCT	DEC	10	6	Percentage of Commercial Rationing Cost
123	.INCLUDE	☐				0	0	Other rents
124	GROSS_COLD_RENT	☐	CMS_RE_DTE_YRLY_GROSS_COLD_REN	CMS_RE_AMOUNT	CURR	17	2	Gross Cold Rent
125	GROSS_RENT_CURR	☐	CMS_RE_DTE_GROSS_RENT_CURR	WAERS	CUKY	5	0	Gross Cold Rent Currency
126	NET_COLD_RENT	☐	CMS_RE_DTE_YRLY_NET_COLD_REN	CMS_RE_AMOUNT	CURR	17	2	Net Cold Rent
127	NET_RENT_CURR	☐	CMS_RE_DTE_NET_RENT_CURR	WAERS	CUKY	5	0	Net Cold Rent Currency
128	.INCLUDE	☐				0	0	Structure for history
129	CREATED_BY	☐	CMS_RE_DTE_CR_BY	CMS_RE_USER	CHAR	12	0	Real Estate Add-On User
130	CREATED_DATE	☐	CMS_RE_DTE_CR_ON	CMS_RE_DATE	DATS	8	0	Created On
131	CREATED_TIME	☐	CMS_RE_DTE_CR_AT	CMS_RE_TIME	TIMS	6	0	Created At
132	ENTRY_SRC	☐	CMS_RE_DTE_SRC_INIT	CMS_RE_SOURCE	CHAR	32	0	Sorce of Initial entry
133	LAST_CHG_BY	☐	CMS_RE_DTE_CHG_BY	CMS_RE_USER	CHAR	12	0	Last Changed By
134	LAST_CHG_DATE	☐	CMS_RE_DTE_CHG_ON	CMS_RE_DATE	DATS	8	0	Last Changed On
135	LAST_CHG_TIME	☐	CMS_RE_DTE_CHG_AT	CMS_RE_TIME	TIMS	6	0	Last Changed At
136	PROCESSING_SRC	☐	CMS_RE_DTE_PRC_SRC	CMS_RE_SOURCE	CHAR	32	0	Processing Source
137	.INCLUDE	☐				0	0
138	.INCLUDE	☐				0	0	Valuation Bases(Com)
139	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
140	INT_RATE_COM	☐	CMS_RE_DTE_VAL_INT_RATE_COM	CMS_RE_PCT	DEC	10	6	Interest rate (Com)
141	.INCLUDE	☐				0	0	Valuation Bases
142	NO_OF_YEARS	☐	CMS_RE_DTE_VALUATION_NO_YEARS	CMS_RE_INT1	INT1	3	0	No. of Years since Real Estate was last Valued
143	INT_RATE	☐	CMS_RE_DTE_VALUATION_INT_RATE	CMS_RE_PCT	DEC	10	6	Interest rate used in Valuation of Residential Real Estate
144	.INCLUDE	☐				0	0	Structure for Part Rent Details
145	RENT_PLANNED_COM	☐	CMS_RE_DTE_RENT_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Planned Rent Amount
146	RENT_ACTUAL_COM	☐	CMS_RE_DTE_RENT_AMOUNT_ACT	CMS_RE_AMOUNT	CURR	17	2	Actual Rent Amount
147	PLAN_CURR_COM	☐	CMS_RE_DTE_RENT_PLANNED_CURR	WAERS	CUKY	5	0	Planned Rent Currency
148	ACT_CURR_COM	☐	CMS_RE_DTE_RENT_ACTUAL_CURR	WAERS	CUKY	5	0	Actual Rent Currency
149	BASE_PERIOD_COM	☐	CMS_RE_DTE_BASE_PERIOD	CMS_RE_BASE_PERIOD	CHAR	1	0	Base period for the rent
150	BASE_MEAS_COM	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
151	COM_RENT_IND	☐	CMS_RE_DTE_COM_IND	CMS_RE_RENT_FLG	CHAR	1	0	Indicator for Rent Type
152	COMP_RENT_COM	☐	CMS_RE_DTE_RENT_LEVEL_COM	CMS_RE_AMOUNT	CURR	17	2	Comparative Rent (Commercial)
153	COMP_REN_COM_CUR	☐	CMS_RE_DTE_COMP_RENT_COM_CURR	WAERS	CUKY	5	0	Comparative Rent Currency (Commercial)
154	.INCLUDE	☐				0	0	Building Construction Progress
155	LAST_REPORT_DATE	☐	CMS_RE_DTE_LAST_CONST_REP_DATE	CMS_RE_DATE	DATS	8	0	Date of Last Constuction Report
156	BLD_PROGRESS_AMT	☐	CMS_RE_DTE_AMT_BLD_PROGRESS	CMS_RE_AMOUNT	CURR	17	2	Amount Disbursed for Construction based on Building Progress
157	BLD_AMT_CURR	☐	CMS_RE_DTE_BLD_PROGRESS_CURR	WAERS	CUKY	5	0	Building Progress Amount Curreny
158	PCT_COMPLETED	☐	CMS_RE_DTE_DEGREE_COMPLETE	CMS_RE_PCT	DEC	10	6	Degree of Completion of Construction
159	.INCLUDE	☐				0	0	Structure for Land Rent details
160	PLAN_RENT_LAND	☐	CMS_RE_DTE_RENT_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Planned Rent Amount
161	ACTUAL_RENT_LAND	☐	CMS_RE_DTE_RENT_AMOUNT_ACT	CMS_RE_AMOUNT	CURR	17	2	Actual Rent Amount
162	PLAN_RENT_CURR	☐	CMS_RE_DTE_RENT_PLANNED_CURR	WAERS	CUKY	5	0	Planned Rent Currency
163	ACTUAL_RENT_CURR	☐	CMS_RE_DTE_RENT_ACTUAL_CURR	WAERS	CUKY	5	0	Actual Rent Currency
164	BASE_PERIOD_LAND	☐	CMS_RE_DTE_BASE_PERIOD	CMS_RE_BASE_PERIOD	CHAR	1	0	Base period for the rent
165	BASE_MEAS_LAND	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
166	.INCLUDE	☐				0	0	Depriciation
167	DEPR	☐	CMS_RE_DTE_DEPR	CMS_RE_PCT	DEC	10	6	Depriciation
168	.INCLUDE	☐				0	0	Land Costs
169	LAND_COST	☐	CMS_RE_DTE_LAND_COST	CMS_RE_AMOUNT	CURR	17	2	Land Cost Amount
170	LAND_COST_CURR	☐	CMS_RE_DTE_LAND_COST_CURR	WAERS	CUKY	5	0	Land Cost Currency
171	DEV_COST	☐	CMS_RE_DTE_DEV_COST	CMS_RE_AMOUNT	CURR	17	2	Development Cost Amount
172	DEV_COST_CURR	☐	CMS_RE_DTE_DEV_COST_CURR	WAERS	CUKY	5	0	Dev Cost Currency
173	LAND_CST_BASE	☐	CMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure of Land
174	DEV_CST_BASE	☐	CMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure of Land
175	ADD_LAND_CST	☐	CMS_RE_DTE_ADD_LAND_COST	CMS_RE_AMOUNT	CURR	17	2	Additional Land Cost Amount
176	ADD_CST_CURR	☐	CMS_RE_DTE_ADD_LAND_COST_CURR	WAERS	CUKY	5	0	Additional Land Cost Currency
177	ADD_CST_BASE	☐	CMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure of Land
178	.INCLUDE	☐				0	0	Construction Costs for Buildings
179	CONST_COST	☐	CMS_RE_DTE_CONS_COST	CMS_RE_AMOUNT	CURR	17	2	Construction Cost
180	CONST_COST_CURR	☐	CMS_RE_DTE_CONS_COST_CURR	WAERS	CUKY	5	0	Construction cost currency
181	BASE_MEAS	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
182	.INCLUDE	☐				0	0	Yearly Gross Profit for Commercial Real Estate
183	GRS_PROFIT	☐	CMS_RE_DTE_GRS_PROFIT	CMS_RE_AMOUNT	CURR	17	2	Yearly Gross Profit
184	GRS_PROFIT_CURR	☐	CMS_RE_DTE_GRS_PROFIT_CURR	WAERS	CUKY	5	0	Yearly Gross Profit Currency
185	.INCLUDE	☐				0	0	AST PKy and Type and Parent GUID
186	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
187	AST_TYP	☐	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type
188	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
189	.INCLUDE	☐				0	0	Structure with Asset Details
190	.INCLUDE	☐				0	0	Basic Asset data
191	RISK_CODE	☐	CMS_RE_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code
192	SFTY_IND	☐	CMS_RE_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates that the asset has a default sfty discount or not
193	SFTY_DSCNT	☐	CMS_RE_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
194	SFTY_AMOUNT	☐	CMS_RE_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Safety discount as an amount
195	SFTY_AMT_CURR	☐	CMS_RE_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount
196	.INCLUDE	☐				0	0	Valuation data
197	VALUATION_TYP	☐	CMS_RE_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Check conducted on the object
198	UNIT_VALN_FREQ	☐	CMS_RE_DTE_IND_FREQUENCY	CMS_RE_IND_FREQUENCY	CHAR	2	0	Indicator : Valuation Period
199	PERIOD_VALN_FREQ	☐	CMS_RE_DTE_VALN_FREQ_PERIOD	CMS_RE_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for a real estate
200	PAST_VALUED_DATE	☐	CMS_RE_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Most Recent Date on which the Real Estate was last Valued
201	START_DATE	☐	CMS_RE_DTE_START_DATE	CMS_DATE	DATS	8	0	Revaluation Start date
202	END_DATE	☐	CMS_RE_DTE_END_DATE	CMS_DATE	DATS	8	0	End date for Revaluation of the Real Estate
203	.INCLUDE	☐				0	0	Lending rate data
204	LENDING_RATE_IND	☐	CMS_RE_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicates that the asset has a default lending rate or not
205	.INCLUDE	☐				0	0	Lending rates
206	LENDING_RATE1	☐	CMS_RE_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
207	LENDING_RATE2	☐	CMS_RE_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending rate 2
208	LENDING_RATE3	☐	CMS_RE_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending rate 3
209	LENDING_RATE4	☐	CMS_RE_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending rate 4
210	LENDING_RATE5	☐	CMS_RE_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending rate 5
211	.INCLUDE	☐				0	0	Account for liquidation proceeds
212	ACC_NUMBER_LIQ	☐	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
213	BANK_CNTRY_LIQ	☐	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key
214	BANK_KEY_LIQ	☐	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
215	BANK_CTRLKEY_LIQ	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
216	.INCLUDE	☐				0	0	Verfication Data
217	UNIT_VERF_FREQ	☐	CMS_DTE_IND_AST_VERF_FREQ_UNIT	CMS_IND_AST_VERF_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for verification of an asset
218	PERIOD_VERF_FREQ	☐	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
219	LAST_VERF_DATE	☐	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
220	.INCLUDE	☐				0	0	Liquidation Data
221	LIQD_TYP	☐	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
222	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
223	LIQD_DATE	☐	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
224	LIQD_AMT	☐	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
225	LIQD_CURR	☐	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value
226	EXP_PRCD_AMNT	☐	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
227	EXP_PRCD_CURR	☐	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed
228	EXP_ACC_DATE	☐	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
229	.INCLUDE	☐				0	0	Structure for Asset values
230	.INCLUDE	☐				0	0	Structure for Asset values
231	NOM_VALUE	☐	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
232	NOM_VALUE_CURR	☐	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value
233	AST_VALUE	☐	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
234	AST_VALUE_CURR	☐	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value
235	QUANTITY	☐	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
236	UNIT_OF_MEASURE	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity
237	REC_AT	☐	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
238	.INCLUDE	☐				0	0	Purchase price data
239	PUR_PRICE	☐	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
240	PUR_PRICE_CURR	☐	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price
241	PUR_DATE	☐	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
242	.INCLUDE	☐				0	0	Organization unit structure
243	ORG_UNIT1	☐	CMS_DTE_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1
244	ORG_UNIT2	☐	CMS_DTE_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2
245	ORG_UNIT3	☐	CMS_DTE_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3
246	ORG_UNIT4	☐	CMS_DTE_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4
247	ORG_UNIT5	☐	CMS_DTE_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5

History

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