CMS_RE_OBJ - Real estate header details

Real estate header details information is stored in SAP table CMS_RE_OBJ.
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

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
.INCLUDE		X		CMS_RE_STR_OBJECT_PKY	0
OBJ_GUID	GUID for Real Estate Object	X	CMS_RE_DTE_OBJ_GUID	RAW	16
.INCLUDE				CMS_RE_STR_OBJECT_SKY	0
OBJECT_ID	Object ID		CMS_RE_DTE_OBJECT_ID	CHAR	40
.INCLUDE				CMS_RE_STR_OBJ_HDR_DATA	0
OBJECT_TYPE	Real Estate Object Type ID		CMS_RE_DTE_OBJ_TYP	CHAR	12	TCMS_RE_TYP
ADDR_ID	Address ID		CMS_RE_DTE_ADDR_ID	CHAR	20
OBJECT_DESC	Description of the Real Estate Object		CMS_RE_DTE_OBJ_DESC	CHAR	60
OBJ_PARENT_ID	GUID for Real Estate Object		CMS_RE_DTE_OBJ_GUID	RAW	16
OBJ_OLD_REF_NO	External reference Number of an External System		CMS_RE_DTE_OBJ_REF_NO	CHAR	64
FIX_FITTING_TYP	Fixtures and Fittings Type ID		CMS_RE_DTE_FIX_FIT_TYP	CHAR	12	TCMS_RE_FX_FIT
.INCLUDE				CMS_RE_STR_OBJECT_UOM	0
OBJECT_AREA_UOM	Unit of Measure for Area		CMS_RE_DTE_AREA_UOM	UNIT	6
OBJECT_VOL_UOM	Unit of Measure for Volume of Real Estate		CMS_RE_DTE_VOL_UOM	UNIT	6
.INCLUDE				CMS_RE_STR_OBJECT_CURR	0
OBJECT_CURR	Object Currency		CMS_RE_DTE_OBJ_CURR	CUKY	10	TCURC
.INCLUDE				CMS_RE_STR_LOC_DESC	0
MACRO_LOC_TYPE	Macro Location		CMS_RE_DTE_ATT_ID_TY_REO002	CHAR	12	TCMS_ATT_ID_TY
MICRO_LOC_TYPE	Micro Location		CMS_RE_DTE_ATT_ID_TY_REO003	CHAR	12	TCMS_ATT_ID_TY
TRAN_CONN_TYPE	Transport Connection		CMS_RE_DTE_ATT_ID_TY_REO004	CHAR	12	TCMS_ATT_ID_TY
ENVIRON_STATUS	Enviromental Status		CMS_RE_DTE_ATT_ID_TY_REO005	CHAR	12	TCMS_ATT_ID_TY
FLOOD_ZONE_FLG	Indicator for Flood Zone		CMS_RE_DTE_FLOOD_ZONE	CHAR	2
EARTHQUAKE_FLG	Indicator : Eathquake Zone		CMS_RE_DTE_EARTHQUAKE	CHAR	2
ARCT_CONV_FLG	Indicator for Architectural Conservation Area		CMS_RE_DTE_ARCT_CONV	CHAR	2
HIST_SITE_FLG	Indicator for Historical Site		CMS_RE_DTE_HIST_SITE	CHAR	2
IS_VAL_IMP_FACS	Indicates existence of Factors Impairing Real Estate Value		CMS_RE_DTE_VAL_IMP_FLG	CHAR	2
VALUE_IMP_DESC	Description of the value imparing factor		CMS_RE_DTE_VAL_IMP_DESC	CHAR	60
.INCLUDE				CI_CMS_RE_STR_LOC_DESC	0
.INCLUDE				CMS_STR_ADMINORG	0
ADMIN_ORG_UNIT	Administration Organizational Unit		CMS_DTE_ADMINORG	CHAR	24
.INCLUDE				CMS_STR_BANKAREA	0
BANKAREA	Bank Area in Collateral Management		CMS_DTE_BANKAREA	CHAR	8	*
.INCLUDE	CHG_HISTORY			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				CMS_RE_STR_RE_AST_DATA_DB	0
.INCLUDE	BASIC_DATA			CMS_RE_STR_RE_AST_BASIC_DATA	0
RISK_CODE	Risk Code		CMS_RE_DTE_RISK_CODE	CHAR	12	*
SFTY_IND	Indicates that the asset has a default sfty discount or not		CMS_RE_DTE_IND_SFTY_DISC	CHAR	4
SFTY_DSCNT	Safety discount		CMS_RE_DTE_SAFETY_DSCNT	DEC	6
SFTY_AMOUNT	Safety discount as an amount		CMS_RE_DTE_SAFETY_AMT	CURR	9
SFTY_AMT_CURR	Currency of the Safety discount amount		CMS_RE_DTE_SAFETY_AMT_CURR	CUKY	10	TCURC
.INCLUDE	VALUATION_DATA			CMS_RE_STR_VALUATION_DATA	0
VALUATION_TYP	Type of Check conducted on the object		CMS_RE_DTE_IND_VALN_TYP	CHAR	4
UNIT_VALN_FREQ	Indicator : Valuation Period		CMS_RE_DTE_IND_FREQUENCY	CHAR	4
PERIOD_VALN_FREQ	Period of revaluation for a real estate		CMS_RE_DTE_VALN_FREQ_PERIOD	NUMC	8
PAST_VALUED_DATE	Most Recent Date on which the Real Estate was last Valued		CMS_RE_DTE_VALN_DATE	DATS	16
START_DATE	Revaluation Start date		CMS_RE_DTE_START_DATE	DATS	16
END_DATE	End date for Revaluation of the Real Estate		CMS_RE_DTE_END_DATE	DATS	16
.INCLUDE	LENDING_RATES			CMS_RE_STR_LND_RTE_DATA	0
LENDING_RATE_IND	Indicates that the asset has a default lending rate or not		CMS_RE_DTE_IND_LND_RTE	CHAR	4
.INCLUDE	LENDING_RATE			CMS_RE_STR_LENDING_RATE	0
LENDING_RATE1	Lending rate 1		CMS_RE_DTE_LRTE_PCT1	DEC	6
LENDING_RATE2	Lending rate 2		CMS_RE_DTE_LRTE_PCT2	DEC	6
LENDING_RATE3	Lending rate 3		CMS_RE_DTE_LRTE_PCT3	DEC	6
LENDING_RATE4	Lending rate 4		CMS_RE_DTE_LRTE_PCT4	DEC	6
LENDING_RATE5	Lending rate 5		CMS_RE_DTE_LRTE_PCT5	DEC	6
.INCLUDE	LIQ_DATA			CMS_RE_STR_LIQUIDATION_DATA	0
LIQD_TYP	Liquidation type		CMS_RE_DTE_LIQD_TYP	CHAR	12
LIQD_REASON	Liquidation Reason		CMS_DTE_ATT_ID_TY_AST004	CHAR	12	TCMS_ATT_ID_TY
LIQD_DATE	Date of Liquidation of Collateral		CMS_RE_DTE_LIQD_DATE	DATS	16
LIQD_AMT	Proceeds obtained from liquidation of the collateral		CMS_RE_DTE_LIQD_VALUE	CURR	9
LIQD_CURR	Currency of Liquidation value		CMS_RE_DTE_LIQD_CURR	CUKY	10	TCURC
.INCLUDE	VERIFICATION_DATA			CMS_STR_VERIFICATION_DATA	0
UNIT_VERF_FREQ	Indicator: Units of time for verification of an asset		CMS_DTE_IND_AST_VERF_FREQ_UNIT	CHAR	4
PERIOD_VERF_FREQ	Statement Period for an Asset		CMS_DTE_AST_VERF_FREQ_PERIOD	NUMC	8
LAST_VERF_DATE	Last Verification Date		CMS_DTE_AST_VERF_DATE	DATS	16
.INCLUDE				CMS_RE_STR_ORG_UNIT	0
ORG_UNIT1	organization unit 1: Assets		CMS_RE_DTE_ORG_UNIT1	CHAR	20	*
ORG_UNIT2	organization unit 2: Assets		CMS_RE_DTE_ORG_UNIT2	CHAR	20	*
ORG_UNIT3	organization unit 3: Assets		CMS_RE_DTE_ORG_UNIT3	CHAR	20	*
ORG_UNIT4	organization unit 4: Assets		CMS_RE_DTE_ORG_UNIT4	CHAR	20	*
ORG_UNIT5	organization unit 5: Assets		CMS_RE_DTE_ORG_UNIT5	CHAR	20	*
.INCLUDE				CI_CMS_RE_STR_OTHERS	0
.INCLUDE	BPCA			CMS_STR_BUSINESS_PROCESS	0
BUPR_ID	Business Process ID		CMS_DTE_BUPR_ID	RAW	16
BUPR_TYPE_CODE	Business Process Type Code		CMS_DTE_BUPR_TYP_CODE	CHAR	12