CMS_RE_OBJ_PRT - Real Estate Object part details

Real Estate Object part details information is stored in SAP table CMS_RE_OBJ_PRT.
It is part of development package CMS_RE in software component FS-CMS-MD-RE. This development package consists of objects that can be grouped under "Collateral Management System: Real Esate".

Fields for table CMS_RE_OBJ_PRT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE		X		CMS_RE_STR_OBJ_PRT_PKY	0
OBJ_PRT_GUID	GUID for Object part	X	CMS_RE_DTE_OBJ_PRT_GUID	RAW	16
.INCLUDE				CMS_RE_STR_OBJECT_LKY	0
OBJ_GUID	GUID for Real Estate Object		CMS_RE_DTE_OBJ_GUID	RAW	16	CMS_RE_OBJ
.INCLUDE				CMS_RE_STR_PRT_SKY	0
PART_ID	Part ID for the Object		CMS_RE_DTE_PART_ID	NUMC	20
.INCLUDE				CMS_RE_STR_PRT_BASIC	0
BLD_PART_TYPE	Building Part Type		CMS_RE_DTE_ATT_ID_TY_REO006	CHAR	12	TCMS_ATT_ID_TY
PART_COND	Object condition		CMS_RE_DTE_ATT_ID_TY_REO001	CHAR	12	TCMS_ATT_ID_TY
MAIN_USAGE	Usage Type		CMS_RE_DTE_USG_TYP	CHAR	12	TCMS_RE_U_TYP
ADD_USAGE_1	Additional Usage 1		CMS_RE_DTE_ADD1_USG_TYP	CHAR	12	TCMS_RE_U_TYP
ADD_USAGE_2	Additional Usage 2		CMS_RE_DTE_ADD2_USG_TYP	CHAR	12	TCMS_RE_U_TYP
BLD_METHOD_ROOF	Building method - Roof		CMS_RE_DTE_ATT_ID_TY_REO007	CHAR	12	TCMS_ATT_ID_TY
BLD_METHOD_BODY	Building method - Body		CMS_RE_DTE_ATT_ID_TY_REO008	CHAR	12	TCMS_ATT_ID_TY
BLD_METD_CELLAR	Building method - Cellar		CMS_RE_DTE_ATT_ID_TY_REO009	CHAR	12	TCMS_ATT_ID_TY
UTILIZATION	Utilization of the Object		CMS_RE_DTE_PRT_UTILIZATION	CHAR	12
PART_DESC	Description of Building Part		CMS_RE_DTE_SPC_DESC	CHAR	60
COMM_USAGE_PCT	Commercial Usage as a Percentage of Total Usage		CMS_RE_DTE_COM_USE_PCT	DEC	6
OTHER_USG_FLG	Indicates if Usages in addition to Main Usage are Possible		CMS_RE_DTE_OTH_USE_FLG	CHAR	2
REF_OBJ_PRT_GUID	Reference Object Part GUID		CMS_RE_DTE_REF_OBJ_PRT_GUID	RAW	16
IS_SUB_AST_CREA	Indicates whether a Sub-asset is created for Building Part		CMS_RE_DTE_CREATE_SUB_AST_FLG	CHAR	2
.INCLUDE				CMS_RE_STR_PRT_SIZE	0
USEFUL_AREA	Usable Area		CMS_RE_DTE_AREA_USEFUL	QUAN	7
USBL_AREA_UOM	Unit of Measure for Usable Area		CMS_RE_DTE_USBL_AREA_UOM	UNIT	6
USEFUL_AREA_REN	Rented Usable Area		CMS_RE_DTE_AREA_USEFUL_REN	QUAN	7
USBL_AR_REN_UOM	Unit of Measure for Usable Rented Area		CMS_RE_DTE_USBL_AREA_REN_UOM	UNIT	6
USEFUL_VOL	Usable Volume of Real Estate Building Parts		CMS_RE_DTE_VOL_USEFUL	QUAN	7
USBL_VOL_UOM	Unit of Measure for Usable Volume of Real Estate		CMS_RE_DTE_USBL_VOL_UOM	UNIT	6
USEFUL_VOL_REN	Usable Volume of the Rented Portions of Real Estate		CMS_RE_DTE_VOL_USEFUL_REN	QUAN	7
USBL_VL_REN_UOM	Unit of measure for usable volume of Rented Parts		CMS_RE_DTE_USBL_VOL_REN_UOM	UNIT	6
RESIDENTIAL_AREA	Residential Area		CMS_RE_DTE_AREA_RESIDENTIAL	QUAN	7
RES_AR_UOM	Unit of Measure for Residential Area		CMS_RE_DTE_RES_AREA_UOM	UNIT	6
SECONDARY_AREA	Secondary Area		CMS_RE_DTE_AREA_SECONDARY	QUAN	7
SEC_AREA_UOM	Unit of Measure for Secondary Area		CMS_RE_DTE_SEC_AREA_UOM	UNIT	6
OTHER_AREA	Other Area		CMS_RE_DTE_AREA_OTHER	QUAN	7
OTH_AREA_UOM	Unit of Measure for Other Area		CMS_RE_DTE_OTH_AREA_UOM	UNIT	6
.INCLUDE				CMS_RE_STR_PRT_UNIT	0
NO_PRT_UNIT	Number of building part units		CMS_RE_DTE_NO_PRT_UNIT	INT4	4
NO_PRT_UNIT_REN	Number of building part units rented		CMS_RE_DTE_NO_PRT_UNIT_REN	INT4	4
.INCLUDE				CMS_RE_STR_DATES	0
CONS_START_DATE	Start Date of Construction		CMS_RE_DTE_OBJ_CONS_ST_DATE	DATS	16
PERMSN_APPL_DATE	Building Permssion applied date		CMS_RE_DTE_OBJ_PMSN_APPL_DATE	DATS	16
PERMSN_OBTD_DATE	Building Permssion obtained date		CMS_RE_DTE_OBJ_PMSN_OBTD_DATE	DATS	16
OCCY_DATE	Occupancy Date		CMS_RE_DTE_OBJ_OCCY_DATE	DATS	16
COMP_DATE	Completion Date		CMS_RE_DTE_OBJ_COMP_DATE	DATS	16
FINAL_INSP_DATE	Date of Final Inspection		CMS_RE_DTE_OBJ_FINAL_INSP_DATE	DATS	16
.INCLUDE				CI_CMS_RE_STR_DATES	0
.INCLUDE				CMS_RE_STR_PRT_RENT	0
RENT_AMT_PLANNED	Planned Rent Amount		CMS_RE_DTE_RENT_AMOUNT	CURR	9
RENT_AMT_ACTUAL	Actual Rent Amount		CMS_RE_DTE_RENT_AMOUNT_ACT	CURR	9
RENT_PLAN_CURR	Planned Rent Currency		CMS_RE_DTE_RENT_PLANNED_CURR	CUKY	10	TCURC
RENT_ACT_CURR	Actual Rent Currency		CMS_RE_DTE_RENT_ACTUAL_CURR	CUKY	10	TCURC
BASE_PERIOD	Base period for the rent		CMS_RE_DTE_BASE_PERIOD	CHAR	2
BASE_MEASURE	Base Measure		CMS_RE_DTE_BASE_MEAS	CHAR	2
VACANT_POSN_PCT	Ratio of Real Estate not rented to Total Real Estate Value		CMS_RE_DTE_VACANT_POS_PCT	DEC	6
RES_RENT_IND	Indicator for Net or Gross Rent		CMS_RE_DTE_RES_IND	CHAR	2
COMP_RENT_RES	Comparative Rent (Residential)		CMS_RE_DTE_RENT_LEVEL	CURR	9
COM_REN_RES_CURR	Comparative Rent Currency - Residential		CMS_RE_DTE_COMP_RENT_RES_CURR	CUKY	10	TCURC
.INCLUDE				CMS_RE_STR_LAND_AREA	0
LAND_AREA	Land Area of the Real Estate		CMS_RE_DTE_LAND_AREA	QUAN	7
LAND_AREA_UOM	Unit of Measure of Land Area		CMS_RE_DTE_LAND_AREA_UOM	UNIT	6	T006
LAND_AREA_REN	Land Area of the Real Estate which is Rented		CMS_RE_DTE_LAND_AREA_REN	QUAN	7
LAND_AR_REN_UOM	Land area unit of measure(rented)		CMS_RE_DTE_LAND_AREA_REN_UOM	UNIT	6	*
.INCLUDE				CMS_RE_STR_BLD_SUM_GENERAL	0
NO_OF_UNITS	No of units in real estate object		CMS_RE_DTE_NO_UNIT	INT4	4
NO_OF_FLOORS	Number of Floors		CMS_RE_DTE_NO_FLOOR	INT4	4
NO_GARAGES	No of Garages in Real Estate Object		CMS_RE_DTE_NO_GAR	INT4	4
NO_GARAGES_REN	No of Garages Rented in Real Estate Object		CMS_RE_DTE_NO_GAR_REN	INT4	4
NO_PARK_UNIT	Number of Parking Units		CMS_RE_DTE_NO_PARK_UNIT	INT4	4
NO_PARK_UNIT_REN	Number of Parking Units Rented		CMS_RE_DTE_NO_PARK_UNIT_REN	INT4	4
NO_PARK_UG	Number of Underground Parking Units		CMS_RE_DTE_NO_PARK_UNIT_UG	INT4	4
NO_PARK_UG_REN	Number of Rented Underground Parking Units		CMS_RE_DTE_NO_PARK_UNIT_UG_REN	INT4	4
.INCLUDE				CMS_RE_STR_BLD_SUM_RESIDENTIA	0
NO_CUR_UNITS	No of current units in real estate object		CMS_RE_DTE_NO_CUR_UNIT	INT4	4
NO_CUR_UNITS_REN	No of Current Units Rented in Real Estate Object		CMS_RE_DTE_NO_CUR_UNIT_REN	INT4	4
NO_OLD_UNITS	No of old units in real estate object		CMS_RE_DTE_NO_OLD_UNIT	INT4	4
NO_OLD_UNITS_REN	No of Old Units Rented in Real Estate Object		CMS_RE_DTE_NO_OLD_UNIT_REN	INT4	4
NO_NEW_UNITS	No of new units in real estate object		CMS_RE_DTE_NO_NEW_UNIT	INT4	4
NO_NEW_UNITS_REN	No of New units Rented in Real Estate Object		CMS_RE_DTE_NO_NEW_UNIT_REN	INT4	4
.INCLUDE				CMS_RE_STR_BLD_SUM_OFFICE	0
NO_ACCESS_STR	No of Access Structures		CMS_RE_DTE_NO_ACCESS_STR	INT4	4
.INCLUDE				CMS_RE_STR_BLD_SUM_COMMERCIAL	0
NO_SALE_LEVEL	No of Sale levels in commercial building		CMS_RE_DTE_NO_SALE_LEVEL	INT4	4
.INCLUDE				CMS_RE_STR_BLD_SUM_HOTEL_CLIN	0
NO_OF_ROOMS	No of rooms in the hotel/clinic		CMS_RE_DTE_NO_ROOMS	INT4	4
.INCLUDE				CMS_RE_STR_BLD_SUM_CLINIC_NURS	0
NO_OF_BEDS	No of beds in the clinic/nursing home		CMS_RE_DTE_NO_BEDS	INT4	4
.INCLUDE				CI_CMS_RE_STR_BLD_SUMMARY	0
.INCLUDE				CMS_RE_STR_COMMERCIAL	0
COMM_ENV_DESC	Description of the commercial environment		CMS_RE_DTE_COMM_ENV_DESC	CHAR	60
ACCESS_STR_DESC	Description of the Access Structures		CMS_RE_DTE_ACCESS_STR_DESC	CHAR	60
BLD_SECTION_DESC	Building Section		CMS_RE_DTE_ATT_ID_TY_REO015	CHAR	12	TCMS_ATT_ID_TY
.INCLUDE				CI_CMS_RE_STR_COMMERCIAL	0
.INCLUDE				CMS_RE_STR_HOTEL	0
PRICE_CATEGORY	Price Category		CMS_RE_DTE_ATT_ID_TY_REO013	CHAR	12	TCMS_ATT_ID_TY
AVG_PRICE	Average Price per Day		CMS_RE_DTE_AVG_PRICE	CURR	9
AVG_PRICE_CURR	Average Price Currency		CMS_RE_DTE_AVG_PRICE_CURR	CUKY	10	TCURC
.INCLUDE				CI_CMS_RE_STR_HOTEL	0
.INCLUDE				CMS_RE_STR_OTHERS	0
OCCUPANCY_PCT	Occupancy specified in Percentage Terms		CMS_RE_DTE_OCCY_PCT	DEC	6
TURNOVER_AMT	Total Amount of Turnover		CMS_RE_DTE_TURNOVER_AMOUNT	CURR	9
TURNOVER_CURR	Currency		CMS_RE_DTE_TURNOVER_CURR	CUKY	10	TCURC
RENTAL_AGMT_TYP	Rental Agreement Type		CMS_RE_DTE_ATT_ID_TY_REO014	CHAR	12	TCMS_ATT_ID_TY
.INCLUDE				CMS_RE_STR_CONST_PROGRESS	0
LAST_REPORT_DATE	Date of Last Constuction Report		CMS_RE_DTE_LAST_CONST_REP_DATE	DATS	16
BLD_PROGRESS_AMT	Amount Disbursed for Construction based on Building Progress		CMS_RE_DTE_AMT_BLD_PROGRESS	CURR	9
BLD_AMT_CURR	Building Progress Amount Curreny		CMS_RE_DTE_BLD_PROGRESS_CURR	CUKY	10	*
PCT_COMPLETED	Degree of Completion of Construction		CMS_RE_DTE_DEGREE_COMPLETE	DEC	6
.INCLUDE				CMS_RE_STR_INSURANCE_DETAILS	0
INSURANCE_TYPE	Insurance Type		CMS_RE_DTE_ATT_ID_TY_REO011	CHAR	12	TCMS_ATT_ID_TY
INSURANCE_AMT	Insurance Amount		CMS_RE_DTE_INSURANCE_AMOUNT	CURR	9
INSURANCE_CURR	Insurance Currency		CMS_RE_DTE_INSURANCE_CURR	CUKY	10	TCURC
INS_VALIDITY	Date until which the Insurance Stands Valid		CMS_RE_DTE_INS_VALID_TILL	DATS	16
.INCLUDE				CMS_RE_STR_OTHER_COSTS	0
RATIONING_COST	Residential Rationing Cost		CMS_RE_DTE_RAT_COST_AMT	CURR	9
RTN_CST_PCT	Percentage of Residential Rationing Cost		CMS_RE_DTE_RAN_COST_PCT	DEC	6
EXT_LAYOUT_COST	External Layout Cost		CMS_RE_DTE_EXT_LAYOUT_COST	CURR	9
EXT_LAY_CST_PCT	External Layout Cost as Percentage of Total Cost		CMS_RE_DTE_EXT_LAYOUT_COST_PCT	DEC	6
RTN_CST_CURR	Rationing cost currency		CMS_RE_DTE_RTN_CST_CURR	CUKY	10	*
EXT_RTN_CST_CURR	External Layout cost currency		CMS_RE_DTE_EXT_LAYOUT_CST_CURR	CUKY	10	*
RTN_CST_COM	Commercial Rationing Cost		CMS_RE_DTE_RAT_COST_AMT_COM	CURR	9
RTN_CST_COM_CURR	Rationing cost currency		CMS_RE_DTE_RTN_CST_CURR_COM	CUKY	10	*
RTN_CST_COM_PCT	Percentage of Commercial Rationing Cost		CMS_RE_DTE_RAN_COST_PCT_COM	DEC	6
.INCLUDE				CMS_RE_STR_OTHER_RENTS	0
GROSS_COLD_RENT	Gross Cold Rent		CMS_RE_DTE_YRLY_GROSS_COLD_REN	CURR	9
GROSS_RENT_CURR	Gross Cold Rent Currency		CMS_RE_DTE_GROSS_RENT_CURR	CUKY	10	TCURC
NET_COLD_RENT	Net Cold Rent		CMS_RE_DTE_YRLY_NET_COLD_REN	CURR	9
NET_RENT_CURR	Net Cold Rent Currency		CMS_RE_DTE_NET_RENT_CURR	CUKY	10	TCURC
.INCLUDE				CMS_RE_STR_HIST	0
CREATED_BY	Real Estate Add-On User		CMS_RE_DTE_CR_BY	CHAR	24
CREATED_DATE	Created On		CMS_RE_DTE_CR_ON	DATS	16
CREATED_TIME	Created At		CMS_RE_DTE_CR_AT	TIMS	12
ENTRY_SRC	Sorce of Initial entry		CMS_RE_DTE_SRC_INIT	CHAR	64
LAST_CHG_BY	Last Changed By		CMS_RE_DTE_CHG_BY	CHAR	24
LAST_CHG_DATE	Last Changed On		CMS_RE_DTE_CHG_ON	DATS	16
LAST_CHG_TIME	Last Changed At		CMS_RE_DTE_CHG_AT	TIMS	12
PROCESSING_SRC	Processing Source		CMS_RE_DTE_PRC_SRC	CHAR	64
.INCLUDE				CI_CMS_RE_STR_SPC_OTHERS	0
.INCLUDE				CMS_RE_STR_VALUATION_BASES_COM	0
NO_OF_YEARS_COM	No of years since Last Valuation of Commercial Real Estate		CMS_RE_DTE_VAL_NO_YEARS_COM	INT1	1
INT_RATE_COM	Interest rate (Com)		CMS_RE_DTE_VAL_INT_RATE_COM	DEC	6
.INCLUDE				CMS_RE_STR_VALUATION_BASES_RES	0
NO_OF_YEARS	No. of Years since Real Estate was last Valued		CMS_RE_DTE_VALUATION_NO_YEARS	INT1	1
INT_RATE	Interest rate used in Valuation of Residential Real Estate		CMS_RE_DTE_VALUATION_INT_RATE	DEC	6
.INCLUDE				CMS_RE_STR_PRT_RENT_COM	0
RENT_PLANNED_COM	Planned Rent Amount		CMS_RE_DTE_RENT_AMOUNT	CURR	9
RENT_ACTUAL_COM	Actual Rent Amount		CMS_RE_DTE_RENT_AMOUNT_ACT	CURR	9
PLAN_CURR_COM	Planned Rent Currency		CMS_RE_DTE_RENT_PLANNED_CURR	CUKY	10	TCURC
ACT_CURR_COM	Actual Rent Currency		CMS_RE_DTE_RENT_ACTUAL_CURR	CUKY	10	TCURC
BASE_PERIOD_COM	Base period for the rent		CMS_RE_DTE_BASE_PERIOD	CHAR	2
BASE_MEAS_COM	Base Measure		CMS_RE_DTE_BASE_MEAS	CHAR	2
COM_RENT_IND	Indicator for Rent Type		CMS_RE_DTE_COM_IND	CHAR	2
COMP_RENT_COM	Comparative Rent (Commercial)		CMS_RE_DTE_RENT_LEVEL_COM	CURR	9
COMP_REN_COM_CUR	Comparative Rent Currency (Commercial)		CMS_RE_DTE_COMP_RENT_COM_CURR	CUKY	10	TCURC
.INCLUDE				CMS_RE_STR_PRT_RENT_LAND	0
PLAN_RENT_LAND	Planned Rent Amount		CMS_RE_DTE_RENT_AMOUNT	CURR	9
ACTUAL_RENT_LAND	Actual Rent Amount		CMS_RE_DTE_RENT_AMOUNT_ACT	CURR	9
PLAN_RENT_CURR	Planned Rent Currency		CMS_RE_DTE_RENT_PLANNED_CURR	CUKY	10	TCURC
ACTUAL_RENT_CURR	Actual Rent Currency		CMS_RE_DTE_RENT_ACTUAL_CURR	CUKY	10	*
BASE_PERIOD_LAND	Base period for the rent		CMS_RE_DTE_BASE_PERIOD	CHAR	2
BASE_MEAS_LAND	Base Measure		CMS_RE_DTE_BASE_MEAS	CHAR	2
.INCLUDE				CMS_RE_STR_DEPR	0
DEPR	Depriciation		CMS_RE_DTE_DEPR	DEC	6
.INCLUDE				CMS_RE_STR_OBJ_LAND_COST	0
LAND_COST	Land Cost Amount		CMS_RE_DTE_LAND_COST	CURR	9
LAND_COST_CURR	Land Cost Currency		CMS_RE_DTE_LAND_COST_CURR	CUKY	10	*
DEV_COST	Development Cost Amount		CMS_RE_DTE_DEV_COST	CURR	9
DEV_COST_CURR	Dev Cost Currency		CMS_RE_DTE_DEV_COST_CURR	CUKY	10	*
LAND_CST_BASE	Base measure of Land		CMS_RE_DTE_BASE_MEAS_LAND	CHAR	2
DEV_CST_BASE	Base measure of Land		CMS_RE_DTE_BASE_MEAS_LAND	CHAR	2
ADD_LAND_CST	Additional Land Cost Amount		CMS_RE_DTE_ADD_LAND_COST	CURR	9
ADD_CST_CURR	Additional Land Cost Currency		CMS_RE_DTE_ADD_LAND_COST_CURR	CUKY	10	*
ADD_CST_BASE	Base measure of Land		CMS_RE_DTE_BASE_MEAS_LAND	CHAR	2
.INCLUDE				CMS_RE_STR_CONS_COST	0
CONST_COST	Construction Cost		CMS_RE_DTE_CONS_COST	CURR	9
CONST_COST_CURR	Construction cost currency		CMS_RE_DTE_CONS_COST_CURR	CUKY	10	*
BASE_MEAS	Base Measure		CMS_RE_DTE_BASE_MEAS	CHAR	2
.INCLUDE				CMS_RE_STR_GROSS_PROFIT	0
GRS_PROFIT	Yearly Gross Profit		CMS_RE_DTE_GRS_PROFIT	CURR	9
GRS_PROFIT_CURR	Yearly Gross Profit Currency		CMS_RE_DTE_GRS_PROFIT_CURR	CUKY	10	*