SAP ABAP Table CMS_RE_STR_OBJ_PRT_SCR (Object part details(screen structure))
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CMS-MD-RE (Application Component) Real Estate
     CMS_RE_UI (Package) Real Estate User Interface
Basic Data
Table Category INTTAB    Structure 
Structure CMS_RE_STR_OBJ_PRT_SCR   Table Relationship Diagram
Short Description Object part details(screen structure)    
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   Primary key for Object part  
2 OBJ_PRT_GUID CMS_RE_DTE_OBJ_PRT_GUID SYSUUID RAW 16   0   GUID for Object part  
3 .INCLUDE       0   0   Link structure for the real estate object  
4 OBJ_GUID CMS_RE_DTE_OBJ_GUID SYSUUID RAW 16   0   GUID for Real Estate Object CMS_RE_OBJ
5 .INCLUDE       0   0   Structure for Part ID  
6 PART_ID CMS_RE_DTE_PART_ID CMS_RE_PRT_ID NUMC 10   0   Part ID for the Object  
7 .INCLUDE       0   0   Structure for Basic Part Details  
8 BLD_PART_TYPE CMS_RE_DTE_ATT_ID_TY_REO006 CMS_ATT_ID_TYP CHAR 6   0   Building Part Type TCMS_ATT_ID_TY
9 PART_COND CMS_RE_DTE_ATT_ID_TY_REO001 CMS_ATT_ID_TYP CHAR 6   0   Object condition TCMS_ATT_ID_TY
10 MAIN_USAGE CMS_RE_DTE_USG_TYP CMS_RE_TYP CHAR 6   0   Usage Type TCMS_RE_U_TYP
11 ADD_USAGE_1 CMS_RE_DTE_ADD1_USG_TYP CMS_RE_TYP CHAR 6   0   Additional Usage 1 TCMS_RE_U_TYP
12 ADD_USAGE_2 CMS_RE_DTE_ADD2_USG_TYP CMS_RE_TYP CHAR 6   0   Additional Usage 2 TCMS_RE_U_TYP
13 BLD_METHOD_ROOF CMS_RE_DTE_ATT_ID_TY_REO007 CMS_ATT_ID_TYP CHAR 6   0   Building method - Roof TCMS_ATT_ID_TY
14 BLD_METHOD_BODY CMS_RE_DTE_ATT_ID_TY_REO008 CMS_ATT_ID_TYP CHAR 6   0   Building method - Body TCMS_ATT_ID_TY
15 BLD_METD_CELLAR CMS_RE_DTE_ATT_ID_TY_REO009 CMS_ATT_ID_TYP CHAR 6   0   Building method - Cellar TCMS_ATT_ID_TY
16 UTILIZATION CMS_RE_DTE_PRT_UTILIZATION CMS_RE_UTIL CHAR 6   0   Utilization of the Object  
17 PART_DESC CMS_RE_DTE_SPC_DESC CMS_RE_DESC CHAR 30   0   Description of Building Part  
18 COMM_USAGE_PCT CMS_RE_DTE_COM_USE_PCT CMS_RE_PCT DEC 10   6   Commercial Usage as a Percentage of Total Usage  
19 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  
20 REF_OBJ_PRT_GUID CMS_RE_DTE_REF_OBJ_PRT_GUID SYSUUID RAW 16   0   Reference Object Part GUID  
21 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  
22 .INCLUDE       0   0   Structure for Part Size Details  
23 USEFUL_AREA CMS_RE_DTE_AREA_USEFUL CMS_RE_SIZE QUAN 13   3   Usable Area  
24 USBL_AREA_UOM CMS_RE_DTE_USBL_AREA_UOM MEINS UNIT 3   0   Unit of Measure for Usable Area *
25 USEFUL_AREA_REN CMS_RE_DTE_AREA_USEFUL_REN CMS_RE_SIZE QUAN 13   3   Rented Usable Area  
26 USBL_AR_REN_UOM CMS_RE_DTE_USBL_AREA_REN_UOM MEINS UNIT 3   0   Unit of Measure for Usable Rented Area *
27 USEFUL_VOL CMS_RE_DTE_VOL_USEFUL CMS_RE_SIZE QUAN 13   3   Usable Volume of Real Estate Building Parts  
28 USBL_VOL_UOM CMS_RE_DTE_USBL_VOL_UOM MEINS UNIT 3   0   Unit of Measure for Usable Volume of Real Estate *
29 USEFUL_VOL_REN CMS_RE_DTE_VOL_USEFUL_REN CMS_RE_SIZE QUAN 13   3   Usable Volume of the Rented Portions of Real Estate  
30 USBL_VL_REN_UOM CMS_RE_DTE_USBL_VOL_REN_UOM MEINS UNIT 3   0   Unit of measure for usable volume of Rented Parts *
31 RESIDENTIAL_AREA CMS_RE_DTE_AREA_RESIDENTIAL CMS_RE_SIZE QUAN 13   3   Residential Area  
32 RES_AR_UOM CMS_RE_DTE_RES_AREA_UOM MEINS UNIT 3   0   Unit of Measure for Residential Area *
33 SECONDARY_AREA CMS_RE_DTE_AREA_SECONDARY CMS_RE_SIZE QUAN 13   3   Secondary Area  
34 SEC_AREA_UOM CMS_RE_DTE_SEC_AREA_UOM MEINS UNIT 3   0   Unit of Measure for Secondary Area *
35 OTHER_AREA CMS_RE_DTE_AREA_OTHER CMS_RE_SIZE QUAN 13   3   Other Area  
36 OTH_AREA_UOM CMS_RE_DTE_OTH_AREA_UOM MEINS UNIT 3   0   Unit of Measure for Other Area *
37 .INCLUDE       0   0   Structure for Part Unit Details  
38 NO_PRT_UNIT CMS_RE_DTE_NO_PRT_UNIT CMS_RE_UNITS INT4 10   0   Number of building part units  
39 NO_PRT_UNIT_REN CMS_RE_DTE_NO_PRT_UNIT_REN CMS_RE_UNITS INT4 10   0   Number of building part units rented  
40 .INCLUDE       0   0   Structure for dates  
41 CONS_START_DATE CMS_RE_DTE_OBJ_CONS_ST_DATE CMS_RE_DATE DATS 8   0   Start Date of Construction  
42 PERMSN_APPL_DATE CMS_RE_DTE_OBJ_PMSN_APPL_DATE CMS_RE_DATE DATS 8   0   Building Permssion applied date  
43 PERMSN_OBTD_DATE CMS_RE_DTE_OBJ_PMSN_OBTD_DATE CMS_RE_DATE DATS 8   0   Building Permssion obtained date  
44 OCCY_DATE CMS_RE_DTE_OBJ_OCCY_DATE CMS_RE_DATE DATS 8   0   Occupancy Date  
45 COMP_DATE CMS_RE_DTE_OBJ_COMP_DATE CMS_RE_DATE DATS 8   0   Completion Date  
46 FINAL_INSP_DATE CMS_RE_DTE_OBJ_FINAL_INSP_DATE CMS_RE_DATE DATS 8   0   Date of Final Inspection  
47 .INCLUDE       0   0    
48 .INCLUDE       0   0   Structure for Part Rent Details  
49 RENT_AMT_PLANNED CMS_RE_DTE_RENT_AMOUNT CMS_RE_AMOUNT CURR 17   2   Planned Rent Amount  
50 RENT_AMT_ACTUAL CMS_RE_DTE_RENT_AMOUNT_ACT CMS_RE_AMOUNT CURR 17   2   Actual Rent Amount  
51 RENT_PLAN_CURR CMS_RE_DTE_RENT_PLANNED_CURR WAERS CUKY 5   0   Planned Rent Currency TCURC
52 RENT_ACT_CURR CMS_RE_DTE_RENT_ACTUAL_CURR WAERS CUKY 5   0   Actual Rent Currency TCURC
53 BASE_PERIOD CMS_RE_DTE_BASE_PERIOD CMS_RE_BASE_PERIOD CHAR 1   0   Base period for the rent  
54 BASE_MEASURE CMS_RE_DTE_BASE_MEAS CMS_RE_BASE_MEAS CHAR 1   0   Base Measure  
55 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  
56 RES_RENT_IND CMS_RE_DTE_RES_IND CMS_RE_RENT_FLG CHAR 1   0   Indicator for Net or Gross Rent  
57 COMP_RENT_RES CMS_RE_DTE_RENT_LEVEL CMS_RE_AMOUNT CURR 17   2   Comparative Rent (Residential)  
58 COM_REN_RES_CURR CMS_RE_DTE_COMP_RENT_RES_CURR WAERS CUKY 5   0   Comparative Rent Currency - Residential TCURC
59 .INCLUDE       0   0   Structure for Land Area & UOM  
60 LAND_AREA CMS_RE_DTE_LAND_AREA CMS_RE_SIZE QUAN 13   3   Land Area of the Real Estate  
61 LAND_AREA_UOM CMS_RE_DTE_LAND_AREA_UOM MEINS UNIT 3   0   Unit of Measure of Land Area T006
62 LAND_AREA_REN CMS_RE_DTE_LAND_AREA_REN CMS_RE_SIZE QUAN 13   3   Land Area of the Real Estate which is Rented  
63 LAND_AR_REN_UOM CMS_RE_DTE_LAND_AREA_REN_UOM MEINS UNIT 3   0   Land area unit of measure(rented) *
64 .INCLUDE       0   0   Structure for General Details  
65 NO_OF_UNITS CMS_RE_DTE_NO_UNIT CMS_RE_UNITS INT4 10   0   No of units in real estate object  
66 NO_OF_FLOORS CMS_RE_DTE_NO_FLOOR CMS_RE_UNITS INT4 10   0   Number of Floors  
67 NO_GARAGES CMS_RE_DTE_NO_GAR CMS_RE_UNITS INT4 10   0   No of Garages in Real Estate Object  
68 NO_GARAGES_REN CMS_RE_DTE_NO_GAR_REN CMS_RE_UNITS INT4 10   0   No of Garages Rented in Real Estate Object  
69 NO_PARK_UNIT CMS_RE_DTE_NO_PARK_UNIT CMS_RE_UNITS INT4 10   0   Number of Parking Units  
70 NO_PARK_UNIT_REN CMS_RE_DTE_NO_PARK_UNIT_REN CMS_RE_UNITS INT4 10   0   Number of Parking Units Rented  
71 NO_PARK_UG CMS_RE_DTE_NO_PARK_UNIT_UG CMS_RE_UNITS INT4 10   0   Number of Underground Parking Units  
72 NO_PARK_UG_REN CMS_RE_DTE_NO_PARK_UNIT_UG_REN CMS_RE_UNITS INT4 10   0   Number of Rented Underground Parking Units  
73 .INCLUDE       0   0   Structure for Residential Details  
74 NO_CUR_UNITS CMS_RE_DTE_NO_CUR_UNIT CMS_RE_UNITS INT4 10   0   No of current units in real estate object  
75 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  
76 NO_OLD_UNITS CMS_RE_DTE_NO_OLD_UNIT CMS_RE_UNITS INT4 10   0   No of old units in real estate object  
77 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  
78 NO_NEW_UNITS CMS_RE_DTE_NO_NEW_UNIT CMS_RE_UNITS INT4 10   0   No of new units in real estate object  
79 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  
80 .INCLUDE       0   0   Structure for Number of Units in Office  
81 NO_ACCESS_STR CMS_RE_DTE_NO_ACCESS_STR CMS_RE_UNITS INT4 10   0   No of Access Structures  
82 .INCLUDE       0   0   Structure for Number of Sales level in Commericial Building  
83 NO_SALE_LEVEL CMS_RE_DTE_NO_SALE_LEVEL CMS_RE_UNITS INT4 10   0   No of Sale levels in commercial building  
84 .INCLUDE       0   0   Structure for Number of Rooms in the hotel/clinic  
85 NO_OF_ROOMS CMS_RE_DTE_NO_ROOMS CMS_RE_UNITS INT4 10   0   No of rooms in the hotel/clinic  
86 .INCLUDE       0   0   Structure for Number of rooms in the clinic/nursing home  
87 NO_OF_BEDS CMS_RE_DTE_NO_BEDS CMS_RE_UNITS INT4 10   0   No of beds in the clinic/nursing home  
88 .INCLUDE       0   0    
89 .INCLUDE       0   0   Structure for Commericial Details  
90 COMM_ENV_DESC CMS_RE_DTE_COMM_ENV_DESC CMS_RE_DESC CHAR 30   0   Description of the commercial environment  
91 ACCESS_STR_DESC CMS_RE_DTE_ACCESS_STR_DESC CMS_RE_DESC CHAR 30   0   Description of the Access Structures  
92 BLD_SECTION_DESC CMS_RE_DTE_ATT_ID_TY_REO015 CMS_ATT_ID_TYP CHAR 6   0   Building Section TCMS_ATT_ID_TY
93 .INCLUDE       0   0    
94 .INCLUDE       0   0   Structure for Hotel Details  
95 PRICE_CATEGORY CMS_RE_DTE_ATT_ID_TY_REO013 CMS_ATT_ID_TYP CHAR 6   0   Price Category TCMS_ATT_ID_TY
96 AVG_PRICE CMS_RE_DTE_AVG_PRICE CMS_RE_AMOUNT CURR 17   2   Average Price per Day  
97 AVG_PRICE_CURR CMS_RE_DTE_AVG_PRICE_CURR WAERS CUKY 5   0   Average Price Currency TCURC
98 .INCLUDE       0   0    
99 .INCLUDE       0   0   Structure for Other Details in RE Object  
100 OCCUPANCY_PCT CMS_RE_DTE_OCCY_PCT CMS_RE_PCT DEC 10   6   Occupancy specified in Percentage Terms  
101 TURNOVER_AMT CMS_RE_DTE_TURNOVER_AMOUNT CMS_RE_AMOUNT CURR 17   2   Total Amount of Turnover  
102 TURNOVER_CURR CMS_RE_DTE_TURNOVER_CURR WAERS CUKY 5   0   Currency TCURC
103 RENTAL_AGMT_TYP CMS_RE_DTE_ATT_ID_TY_REO014 CMS_ATT_ID_TYP CHAR 6   0   Rental Agreement Type TCMS_ATT_ID_TY
104 .INCLUDE       0   0   Insurance details  
105 INSURANCE_TYPE CMS_RE_DTE_ATT_ID_TY_REO011 CMS_ATT_ID_TYP CHAR 6   0   Insurance Type TCMS_ATT_ID_TY
106 INSURANCE_AMT CMS_RE_DTE_INSURANCE_AMOUNT CMS_RE_AMOUNT CURR 17   2   Insurance Amount  
107 INSURANCE_CURR CMS_RE_DTE_INSURANCE_CURR WAERS CUKY 5   0   Insurance Currency TCURC
108 INS_VALIDITY CMS_RE_DTE_INS_VALID_TILL CMS_RE_DATE DATS 8   0   Date until which the Insurance Stands Valid  
109 .INCLUDE       0   0   Other Costs  
110 RATIONING_COST CMS_RE_DTE_RAT_COST_AMT CMS_RE_AMOUNT CURR 17   2   Residential Rationing Cost  
111 RTN_CST_PCT CMS_RE_DTE_RAN_COST_PCT CMS_RE_PCT DEC 10   6   Percentage of Residential Rationing Cost  
112 EXT_LAYOUT_COST CMS_RE_DTE_EXT_LAYOUT_COST CMS_RE_AMOUNT CURR 17   2   External Layout Cost  
113 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  
114 RTN_CST_CURR CMS_RE_DTE_RTN_CST_CURR WAERS CUKY 5   0   Rationing cost currency *
115 EXT_RTN_CST_CURR CMS_RE_DTE_EXT_LAYOUT_CST_CURR WAERS CUKY 5   0   External Layout cost currency *
116 RTN_CST_COM CMS_RE_DTE_RAT_COST_AMT_COM CMS_RE_AMOUNT CURR 17   2   Commercial Rationing Cost  
117 RTN_CST_COM_CURR CMS_RE_DTE_RTN_CST_CURR_COM WAERS CUKY 5   0   Rationing cost currency *
118 RTN_CST_COM_PCT CMS_RE_DTE_RAN_COST_PCT_COM CMS_RE_PCT DEC 10   6   Percentage of Commercial Rationing Cost  
119 .INCLUDE       0   0   Other rents  
120 GROSS_COLD_RENT CMS_RE_DTE_YRLY_GROSS_COLD_REN CMS_RE_AMOUNT CURR 17   2   Gross Cold Rent  
121 GROSS_RENT_CURR CMS_RE_DTE_GROSS_RENT_CURR WAERS CUKY 5   0   Gross Cold Rent Currency TCURC
122 NET_COLD_RENT CMS_RE_DTE_YRLY_NET_COLD_REN CMS_RE_AMOUNT CURR 17   2   Net Cold Rent  
123 NET_RENT_CURR CMS_RE_DTE_NET_RENT_CURR WAERS CUKY 5   0   Net Cold Rent Currency TCURC
124 .INCLUDE       0   0   Structure for history  
125 CREATED_BY CMS_RE_DTE_CR_BY CMS_RE_USER CHAR 12   0   Real Estate Add-On User  
126 CREATED_DATE CMS_RE_DTE_CR_ON CMS_RE_DATE DATS 8   0   Created On  
127 CREATED_TIME CMS_RE_DTE_CR_AT CMS_RE_TIME TIMS 6   0   Created At  
128 ENTRY_SRC CMS_RE_DTE_SRC_INIT CMS_RE_SOURCE CHAR 32   0   Sorce of Initial entry  
129 LAST_CHG_BY CMS_RE_DTE_CHG_BY CMS_RE_USER CHAR 12   0   Last Changed By  
130 LAST_CHG_DATE CMS_RE_DTE_CHG_ON CMS_RE_DATE DATS 8   0   Last Changed On  
131 LAST_CHG_TIME CMS_RE_DTE_CHG_AT CMS_RE_TIME TIMS 6   0   Last Changed At  
132 PROCESSING_SRC CMS_RE_DTE_PRC_SRC CMS_RE_SOURCE CHAR 32   0   Processing Source  
133 .INCLUDE       0   0    
134 .INCLUDE       0   0   Building Construction Progress  
135 LAST_REPORT_DATE CMS_RE_DTE_LAST_CONST_REP_DATE CMS_RE_DATE DATS 8   0   Date of Last Constuction Report  
136 BLD_PROGRESS_AMT CMS_RE_DTE_AMT_BLD_PROGRESS CMS_RE_AMOUNT CURR 17   2   Amount Disbursed for Construction based on Building Progress  
137 BLD_AMT_CURR CMS_RE_DTE_BLD_PROGRESS_CURR WAERS CUKY 5   0   Building Progress Amount Curreny *
138 PCT_COMPLETED CMS_RE_DTE_DEGREE_COMPLETE CMS_RE_PCT DEC 10   6   Degree of Completion of Construction  
139 .INCLUDE       0   0   Valuation Bases(Com)  
140 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  
141 INT_RATE_COM CMS_RE_DTE_VAL_INT_RATE_COM CMS_RE_PCT DEC 10   6   Interest rate (Com)  
142 .INCLUDE       0   0   Valuation Bases  
143 NO_OF_YEARS CMS_RE_DTE_VALUATION_NO_YEARS CMS_RE_INT1 INT1 3   0   No. of Years since Real Estate was last Valued  
144 INT_RATE CMS_RE_DTE_VALUATION_INT_RATE CMS_RE_PCT DEC 10   6   Interest rate used in Valuation of Residential Real Estate  
145 .INCLUDE       0   0   Structure for Part Rent Details  
146 RENT_PLANNED_COM CMS_RE_DTE_RENT_AMOUNT CMS_RE_AMOUNT CURR 17   2   Planned Rent Amount  
147 RENT_ACTUAL_COM CMS_RE_DTE_RENT_AMOUNT_ACT CMS_RE_AMOUNT CURR 17   2   Actual Rent Amount  
148 PLAN_CURR_COM CMS_RE_DTE_RENT_PLANNED_CURR WAERS CUKY 5   0   Planned Rent Currency TCURC
149 ACT_CURR_COM CMS_RE_DTE_RENT_ACTUAL_CURR WAERS CUKY 5   0   Actual Rent Currency TCURC
150 BASE_PERIOD_COM CMS_RE_DTE_BASE_PERIOD CMS_RE_BASE_PERIOD CHAR 1   0   Base period for the rent  
151 BASE_MEAS_COM CMS_RE_DTE_BASE_MEAS CMS_RE_BASE_MEAS CHAR 1   0   Base Measure  
152 COM_RENT_IND CMS_RE_DTE_COM_IND CMS_RE_RENT_FLG CHAR 1   0   Indicator for Rent Type  
153 COMP_RENT_COM CMS_RE_DTE_RENT_LEVEL_COM CMS_RE_AMOUNT CURR 17   2   Comparative Rent (Commercial)  
154 COMP_REN_COM_CUR CMS_RE_DTE_COMP_RENT_COM_CURR WAERS CUKY 5   0   Comparative Rent Currency (Commercial) TCURC
155 .INCLUDE       0   0   Rental Summary  
156 RES_AREA_REN CMS_RE_DTE_RES_AREA_REN CMS_RE_SIZE QUAN 13   3   Total Residential Area rented  
157 RES_AREA_UOM CMS_RE_DTE_RES_AREA_REN_UOM MEINS UNIT 3   0   Unit of Measure for Rented Residential Area *
158 COM_AREA_REN CMS_RE_DTE_COM_AREA_REN CMS_RE_SIZE QUAN 13   3   Total Commercial Area Rented  
159 COM_AREA_UOM CMS_RE_DTE_COM_AREA_REN_UOM MEINS UNIT 3   0   Unit of Measure for Rented Commercial Area *
160 RES_VOL_REN CMS_RE_DTE_RES_VOL_REN CMS_RE_SIZE QUAN 13   3   Total Residential Volume Rented  
161 RES_VOL_UOM CMS_RE_DTE_RES_VOL_REN_UOM MEINS UNIT 3   0   Unit of Measure for Total Rented Residential Volume *
162 COM_VOL_REN CMS_RE_DTE_COM_VOL_REN CMS_RE_SIZE QUAN 13   3   Total Volume Rented for Commercial Use  
163 COM_VOL_UOM CMS_RE_DTE_COM_VOL_REN_UOM MEINS UNIT 3   0   Unit of Measure for Volume Rented for Commercial Use *
164 RENTAL_INC_RES CMS_RE_DTE_RENTAL_INC_RES CMS_RE_AMOUNT CURR 17   2   Total rental income - residential  
165 INC_RES_CURR CMS_RE_DTE_REN_INC_RES_CURRR WAERS CUKY 5   0   Currency for Residential Rental Income *
166 RENTAL_INC_COM CMS_RE_DTE_RENTAL_INC_COM CMS_RE_AMOUNT CURR 17   2   Total rental income - commercial  
167 INC_COM_CURR CMS_RE_DTE_REN_INC_COM_CURRR WAERS CUKY 5   0   Currency for Commercial Rental Income *
168 RENTAL_INC_TOTAL CMS_RE_DTE_RENTAL_INC_TOTAL CMS_RE_AMOUNT CURR 17   2   Total rental income  
169 INC_TOTAL_CURR CMS_RE_DTE_REN_INC_TOTAL_CURRR WAERS CUKY 5   0   Currency for Total Rental Income *
170 INC_TOTAL_ENT CMS_RE_DTE_ENTERED_VAL_AMOUNT CMS_RE_AMOUNT CURR 17   2   Entered Value  
171 INC_ENT_CURR CMS_RE_DTE_ENTERED_VAL_CURR WAERS CUKY 5   0   Entered value Currency *
172 REN_VAL_DATE CMS_RE_DTE_VAL_DATE CMS_RE_DATE DATS 8   0   Date on which Real Estate Valuation was Performed  
173 NET_RES_INC CMS_RE_DTE_NET_RENTAL_INC_RES CMS_RE_AMOUNT CURR 17   2   Net rental income - residential  
174 NET_RES_INC_CURR CMS_RE_DTE_NET_INC_RES_CURR WAERS CUKY 5   0   Currency for Residential Rental Income -Net *
175 NET_COM_INC CMS_RE_DTE_NET_RENTAL_INC_COM CMS_RE_AMOUNT CURR 17   2   Net rental income - commercial  
176 NET_COM_INC_CURR CMS_RE_DTE_NET_INC_COM_CURR WAERS CUKY 5   0   Currency for Commercial Rental Income -Net *
177 NET_TOT_INC CMS_RE_DTE_NET_RENT_INC_TOTAL CMS_RE_AMOUNT CURR 17   2   Net rental income  
178 NET_TOT_INC_CURR CMS_RE_DTE_NET_INC_TOTAL_CURR WAERS CUKY 5   0   Currency for Total Rental Income *
179 REV_TOT_RES CMS_RE_DTE_TOTAL_REVENUE_RES CMS_RE_AMOUNT CURR 17   2   Total revenue - residential  
180 REV_TOT_RES_CURR CMS_RE_DTE_TOTAL_REV_RES_CURR WAERS CUKY 5   0   Currency for Total Residential revenue *
181 REV_TOT_COM CMS_RE_DTE_TOTAL_REVENUE_COM CMS_RE_AMOUNT CURR 17   2   Total revenue - commercial  
182 REV_TOT_COM_CURR CMS_RE_DTE_TOTAL_REV_COM_CURR WAERS CUKY 5   0   Currency for Total commercial revenue *
183 REVTOT_CALC CMS_RE_DTE_TOTAL_REVENUE CMS_RE_AMOUNT CURR 17   2   Total revenue  
184 REVTOT_CALC_CURR CMS_RE_DTE_TOTAL_REV_CURR WAERS CUKY 5   0   Currency for Total revenue *
185 REVTOT_ENT CMS_RE_DTE_ENTERED_VAL_AMOUNT CMS_RE_AMOUNT CURR 17   2   Entered Value  
186 REVTOT_ENT_CURR CMS_RE_DTE_ENTERED_VAL_CURR WAERS CUKY 5   0   Entered value Currency *
187 REVCALC_DATE CMS_RE_DTE_VAL_DATE CMS_RE_DATE DATS 8   0   Date on which Real Estate Valuation was Performed  
188 .INCLUDE       0   0   Object Land Value  
189 LAND_VALUE CMS_RE_DTE_LAND_VAL CMS_RE_AMOUNT CURR 17   2   Land Value  
190 LAND_VALUE_CURR CMS_RE_DTE_LAND_VAL_CURR WAERS CUKY 5   0   Land Value Currency *
191 LAND_VALUE_ENT CMS_RE_DTE_ENTERED_VAL_AMOUNT CMS_RE_AMOUNT CURR 17   2   Entered Value  
192 VAL_ENT_CURR CMS_RE_DTE_ENTERED_VAL_CURR WAERS CUKY 5   0   Entered value Currency *
193 LAND_VAL_DATE CMS_RE_DTE_VAL_DATE CMS_RE_DATE DATS 8   0   Date on which Real Estate Valuation was Performed  
194 .INCLUDE       0   0   Structure for Land Rent details  
195 PLAN_RENT_LAND CMS_RE_DTE_RENT_AMOUNT CMS_RE_AMOUNT CURR 17   2   Planned Rent Amount  
196 ACTUAL_RENT_LAND CMS_RE_DTE_RENT_AMOUNT_ACT CMS_RE_AMOUNT CURR 17   2   Actual Rent Amount  
197 PLAN_RENT_CURR CMS_RE_DTE_RENT_PLANNED_CURR WAERS CUKY 5   0   Planned Rent Currency TCURC
198 ACTUAL_RENT_CURR CMS_RE_DTE_RENT_ACTUAL_CURR WAERS CUKY 5   0   Actual Rent Currency *
199 BASE_PERIOD_LAND CMS_RE_DTE_BASE_PERIOD CMS_RE_BASE_PERIOD CHAR 1   0   Base period for the rent  
200 BASE_MEAS_LAND CMS_RE_DTE_BASE_MEAS CMS_RE_BASE_MEAS CHAR 1   0   Base Measure  
201 .INCLUDE       0   0   Depriciation  
202 DEPR CMS_RE_DTE_DEPR CMS_RE_PCT DEC 10   6   Depriciation  
203 .INCLUDE       0   0   Object Building Value  
204 BLD_VALUE_CALC CMS_RE_DTE_BLD_VAL CMS_RE_AMOUNT CURR 17   2   Building Value  
205 CALC_VALUE_CURR CMS_RE_DTE_BLD_VAL_CURR WAERS CUKY 5   0   Building Value Currency *
206 BLD_VALUE_ENT CMS_RE_DTE_ENTERED_VAL_AMOUNT CMS_RE_AMOUNT CURR 17   2   Entered Value  
207 ENT_VALUE_CURR CMS_RE_DTE_ENTERED_VAL_CURR WAERS CUKY 5   0   Entered value Currency *
208 BLD_VAL_DATE CMS_RE_DTE_VAL_DATE CMS_RE_DATE DATS 8   0   Date on which Real Estate Valuation was Performed  
209 .INCLUDE       0   0   Land Costs  
210 LAND_COST CMS_RE_DTE_LAND_COST CMS_RE_AMOUNT CURR 17   2   Land Cost Amount  
211 LAND_COST_CURR CMS_RE_DTE_LAND_COST_CURR WAERS CUKY 5   0   Land Cost Currency *
212 DEV_COST CMS_RE_DTE_DEV_COST CMS_RE_AMOUNT CURR 17   2   Development Cost Amount  
213 DEV_COST_CURR CMS_RE_DTE_DEV_COST_CURR WAERS CUKY 5   0   Dev Cost Currency *
214 LAND_CST_BASE CMS_RE_DTE_BASE_MEAS_LAND CMS_RE_BASE_MEAS_LAND CHAR 1   0   Base measure of Land  
215 DEV_CST_BASE CMS_RE_DTE_BASE_MEAS_LAND CMS_RE_BASE_MEAS_LAND CHAR 1   0   Base measure of Land  
216 ADD_LAND_CST CMS_RE_DTE_ADD_LAND_COST CMS_RE_AMOUNT CURR 17   2   Additional Land Cost Amount  
217 ADD_CST_CURR CMS_RE_DTE_ADD_LAND_COST_CURR WAERS CUKY 5   0   Additional Land Cost Currency *
218 ADD_CST_BASE CMS_RE_DTE_BASE_MEAS_LAND CMS_RE_BASE_MEAS_LAND CHAR 1   0   Base measure of Land  
219 .INCLUDE       0   0   Construction Costs for Buildings  
220 CONST_COST CMS_RE_DTE_CONS_COST CMS_RE_AMOUNT CURR 17   2   Construction Cost  
221 CONST_COST_CURR CMS_RE_DTE_CONS_COST_CURR WAERS CUKY 5   0   Construction cost currency *
222 BASE_MEAS CMS_RE_DTE_BASE_MEAS CMS_RE_BASE_MEAS CHAR 1   0   Base Measure  
223 .INCLUDE       0   0   Cost Depreciation Value  
224 CST_DEP_CAL CMS_RE_DTE_CST_DEP_VAL CMS_RE_AMOUNT CURR 17   2   Object Value Calculated using Cost Depreciation Method  
225 CST_DEP_CAL_CURR CMS_RE_DTE_CST_DEP_VAL_CURR WAERS CUKY 5   0   Object Value Currency - Cost Depreciation Method *
226 CST_DEP_ENT CMS_RE_DTE_ENTERED_VAL_AMOUNT CMS_RE_AMOUNT CURR 17   2   Entered Value  
227 CST_DEP_ENT_CURR CMS_RE_DTE_ENTERED_VAL_CURR WAERS CUKY 5   0   Entered value Currency *
228 CST_DEP_DATE CMS_RE_DTE_VAL_DATE CMS_RE_DATE DATS 8   0   Date on which Real Estate Valuation was Performed  
229 .INCLUDE       0   0   Yearly Gross Profit for Commercial Real Estate  
230 GRS_PROFIT CMS_RE_DTE_GRS_PROFIT CMS_RE_AMOUNT CURR 17   2   Yearly Gross Profit  
231 GRS_PROFIT_CURR CMS_RE_DTE_GRS_PROFIT_CURR WAERS CUKY 5   0   Yearly Gross Profit Currency *
232 .INCLUDE       0   0   Structure with Asset Details  
233 .INCLUDE       0   0   Basic Asset data  
234 RISK_CODE CMS_RE_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code TCMS_RISKCODE
235 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  
236 SFTY_DSCNT CMS_RE_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Safety discount  
237 SFTY_AMOUNT CMS_RE_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Safety discount as an amount  
238 SFTY_AMT_CURR CMS_RE_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety discount amount TCURC
239 .INCLUDE       0   0   Valuation data  
240 VALUATION_TYP CMS_RE_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Check conducted on the object  
241 UNIT_VALN_FREQ CMS_RE_DTE_IND_FREQUENCY CMS_RE_IND_FREQUENCY CHAR 2   0   Indicator : Valuation Period  
242 PERIOD_VALN_FREQ CMS_RE_DTE_VALN_FREQ_PERIOD CMS_RE_VALN_FREQ_PERIOD NUMC 4   0   Period of revaluation for a real estate  
243 PAST_VALUED_DATE CMS_RE_DTE_VALN_DATE CMS_DATE DATS 8   0   Most Recent Date on which the Real Estate was last Valued  
244 START_DATE CMS_RE_DTE_START_DATE CMS_DATE DATS 8   0   Revaluation Start date  
245 END_DATE CMS_RE_DTE_END_DATE CMS_DATE DATS 8   0   End date for Revaluation of the Real Estate  
246 .INCLUDE       0   0   Lending rate data  
247 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  
248 .INCLUDE       0   0   Lending rates  
249 LENDING_RATE1 CMS_RE_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending rate 1  
250 LENDING_RATE2 CMS_RE_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending rate 2  
251 LENDING_RATE3 CMS_RE_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending rate 3  
252 LENDING_RATE4 CMS_RE_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending rate 4  
253 LENDING_RATE5 CMS_RE_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending rate 5  
254 .INCLUDE       0   0   Account for liquidation proceeds  
255 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
256 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key T005
257 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
258 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
259 .INCLUDE       0   0   Verfication Data  
260 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  
261 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
262 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
263 .INCLUDE       0   0   Liquidation Data  
264 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
265 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason TCMS_ATT_ID_TY
266 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
267 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
268 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value TCURC
269 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
270 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed TCURC
271 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
272 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
273 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
274 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type *
275 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
276 .INCLUDE       0   0   Structure for Asset values  
277 .INCLUDE       0   0   Structure for Asset values  
278 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
279 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value TCURC
280 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
281 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value TCURC
282 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
283 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity T006
284 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
285 .INCLUDE       0   0   Purchase price data  
286 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
287 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price TCURC
288 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
289 .INCLUDE       0   0   Bank name  
290 BANK_NAME BANKA TEXT60 CHAR 60   0   Name of bank  
291 .INCLUDE       0   0   Organization unit structure  
292 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1 *
293 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2 *
294 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3 *
295 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4 *
296 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5 *
297 .INCLUDE       0   0   Structure for Variable object field names  
298 NOM_VALUE_SCR CMS_DTE_SCREEN_FLD_NAME CMS_FLD_TEXT CHAR 15   0   Name of the Asset Screen field  
299 AST_VALUE_SCR CMS_DTE_SCREEN_FLD_NAME CMS_FLD_TEXT CHAR 15   0   Name of the Asset Screen field  
300 OBJECT_REF_ID_SCR CMS_DTE_SCREEN_FLD_NAME CMS_FLD_TEXT CHAR 15   0   Name of the Asset Screen field  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CMS_RE_STR_OBJ_PRT_SCR ACT_CURR_COM TCURC WAERS REF 1 CN
2 CMS_RE_STR_OBJ_PRT_SCR ADD_USAGE_1 TCMS_RE_U_TYP USAGE_TYPE REF 1 CN
3 CMS_RE_STR_OBJ_PRT_SCR ADD_USAGE_2 TCMS_RE_U_TYP USAGE_TYPE REF 1 CN
4 CMS_RE_STR_OBJ_PRT_SCR AST_VALUE_CURR TCURC WAERS REF 1 CN
5 CMS_RE_STR_OBJ_PRT_SCR AVG_PRICE_CURR TCURC WAERS REF 1 CN
6 CMS_RE_STR_OBJ_PRT_SCR BANK_CNTRY_LIQ T005 LAND1 REF 1 CN
7 CMS_RE_STR_OBJ_PRT_SCR BLD_METD_CELLAR TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
8 CMS_RE_STR_OBJ_PRT_SCR BLD_METHOD_BODY TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
9 CMS_RE_STR_OBJ_PRT_SCR BLD_METHOD_ROOF TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
10 CMS_RE_STR_OBJ_PRT_SCR BLD_PART_TYPE TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
11 CMS_RE_STR_OBJ_PRT_SCR BLD_SECTION_DESC TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
12 CMS_RE_STR_OBJ_PRT_SCR COMP_REN_COM_CUR TCURC WAERS REF 1 CN
13 CMS_RE_STR_OBJ_PRT_SCR COM_REN_RES_CURR TCURC WAERS REF 1 CN
14 CMS_RE_STR_OBJ_PRT_SCR EXP_PRCD_CURR TCURC WAERS REF 1 CN
15 CMS_RE_STR_OBJ_PRT_SCR GROSS_RENT_CURR TCURC WAERS REF 1 CN
16 CMS_RE_STR_OBJ_PRT_SCR INSURANCE_CURR TCURC WAERS REF 1 CN
17 CMS_RE_STR_OBJ_PRT_SCR INSURANCE_TYPE TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
18 CMS_RE_STR_OBJ_PRT_SCR LAND_AREA_UOM T006 MSEHI REF 1 CN
19 CMS_RE_STR_OBJ_PRT_SCR LIQD_CURR TCURC WAERS REF 1 CN
20 CMS_RE_STR_OBJ_PRT_SCR LIQD_REASON TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
21 CMS_RE_STR_OBJ_PRT_SCR MAIN_USAGE TCMS_RE_U_TYP USAGE_TYPE REF 1 CN
22 CMS_RE_STR_OBJ_PRT_SCR NET_RENT_CURR TCURC WAERS REF 1 CN
23 CMS_RE_STR_OBJ_PRT_SCR NOM_VALUE_CURR TCURC WAERS REF 1 CN
24 CMS_RE_STR_OBJ_PRT_SCR PART_COND TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
25 CMS_RE_STR_OBJ_PRT_SCR PLAN_CURR_COM TCURC WAERS REF 1 CN
26 CMS_RE_STR_OBJ_PRT_SCR PLAN_RENT_CURR TCURC WAERS REF 1 CN
27 CMS_RE_STR_OBJ_PRT_SCR PRICE_CATEGORY TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
28 CMS_RE_STR_OBJ_PRT_SCR PUR_PRICE_CURR TCURC WAERS    
29 CMS_RE_STR_OBJ_PRT_SCR RENTAL_AGMT_TYP TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
30 CMS_RE_STR_OBJ_PRT_SCR RENT_ACT_CURR TCURC WAERS REF 1 CN
31 CMS_RE_STR_OBJ_PRT_SCR RENT_PLAN_CURR TCURC WAERS REF 1 CN
32 CMS_RE_STR_OBJ_PRT_SCR RISK_CODE TCMS_RISKCODE RISK_CODE REF 1 CN
33 CMS_RE_STR_OBJ_PRT_SCR SFTY_AMT_CURR TCURC WAERS REF 1 CN
34 CMS_RE_STR_OBJ_PRT_SCR TURNOVER_CURR TCURC WAERS REF 1 CN
35 CMS_RE_STR_OBJ_PRT_SCR UNIT_OF_MEASURE T006 MSEHI REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 200