CMS_RE_OBJ

Real estate header details | #masterdata | Component: Real Estate
Column Name Description
MANDT FK Client
OBJ_GUID GUID for Real Estate Object
Column Name Description
💲 Currency of the Safety discount amount (SFTY_AMT_CURR):
SFTY_AMOUNT Safety discount as an amount
💲 Currency of Liquidation value (LIQD_CURR):
LIQD_AMT Proceeds obtained from liquidation of the collateral
Column Name Description
Column Name Description
CREATED_DATE Created On
CREATED_TIME Created At
LAST_CHG_DATE Last Changed On
LAST_CHG_TIME Last Changed At
PAST_VALUED_DATE Most Recent Date on which the Real Estate was last Valued
START_DATE Revaluation Start date
END_DATE End date for Revaluation of the Real Estate
LIQD_DATE Date of Liquidation of Collateral
LAST_VERF_DATE Last Verification Date
Column Name Description
FLOOD_ZONE_FLG Indicator for Flood Zone Show values
EARTHQUAKE_FLG Indicator : Eathquake Zone Show values
ARCT_CONV_FLG Indicator for Architectural Conservation Area Show values
HIST_SITE_FLG Indicator for Historical Site Show values
IS_VAL_IMP_FACS Indicates existence of Factors Impairing Real Estate Value Show values
SFTY_IND Indicates that the asset has a default sfty discount or not Show values
SFTY_DSCNT Safety discount Show values
VALUATION_TYP Type of Check conducted on the object Show values
UNIT_VALN_FREQ Indicator : Valuation Period Show values
LENDING_RATE_IND Indicates that the asset has a default lending rate or not Show values
UNIT_VERF_FREQ Indicator: Units of time for verification of an asset Show values
Column Name Description Domain name
OBJECT_ID Object ID CMS_RE_OBJECT_ID
OBJECT_DESC Description of the Real Estate Object CMS_RE_DESC
OBJ_PARENT_ID GUID for Real Estate Object SYSUUID
OBJ_OLD_REF_NO External reference Number of an External System CMS_RE_REFID
VALUE_IMP_DESC Description of the value imparing factor CMS_RE_DESC
ADMIN_ORG_UNIT Administration Organizational Unit TEXT12
BANKAREA Bank Area in Collateral Management CMS_BANKAREA
CREATED_BY Real Estate Add-On User CMS_RE_USER
ENTRY_SRC Sorce of Initial entry CMS_RE_SOURCE
LAST_CHG_BY Last Changed By CMS_RE_USER
PROCESSING_SRC Processing Source CMS_RE_SOURCE
RISK_CODE Risk Code CMS_RISK_CODE
PERIOD_VALN_FREQ Period of revaluation for a real estate CMS_RE_VALN_FREQ_PERIOD
LENDING_RATE1 Lending rate 1 CMS_PCT
LENDING_RATE2 Lending rate 2 CMS_PCT
LENDING_RATE3 Lending rate 3 CMS_PCT
LENDING_RATE4 Lending rate 4 CMS_PCT
LENDING_RATE5 Lending rate 5 CMS_PCT
LIQD_TYP Liquidation type CMS_TYP
PERIOD_VERF_FREQ Statement Period for an Asset CMS_AST_VERF_FREQ_PERIOD
ORG_UNIT1 organization unit 1: Assets CMS_RE_ORG_UNIT
ORG_UNIT2 organization unit 2: Assets CMS_RE_ORG_UNIT
ORG_UNIT3 organization unit 3: Assets CMS_RE_ORG_UNIT
ORG_UNIT4 organization unit 4: Assets CMS_RE_ORG_UNIT
ORG_UNIT5 organization unit 5: Assets CMS_RE_ORG_UNIT
BUPR_ID Business Process ID SYSUUID
BUPR_TYPE_CODE Business Process Type Code CMS_BUPR_TYP_CODE
Master Data Relations Join Conditions
Foreign key for environmental status
  • ?
  • Client
  • Enviromental Status
Fixtures and Fittings Type ID
Currency of Liquidation value
  • CMS_RE_OBJ.MANDT == TCURC.MANDT
  • CMS_RE_OBJ.LIQD_CURR == TCURC.WAERS
Liquidation Reason
  • ?
  • Client
  • Liquidation Reason
Foreign key for macro location type
  • ?
  • Client
  • Macro Location
Foreign key for Client CMS_RE_OBJ.MANDT == T000.MANDT
Foreign key for micro location type
  • ?
  • Client
  • Micro Location
Object Currency
  • CMS_RE_OBJ.MANDT == TCURC.MANDT
  • CMS_RE_OBJ.OBJECT_CURR == TCURC.WAERS
Real Estate Object Type ID CMS_RE_OBJ.MANDT == TCMS_RE_TYP.MANDT
Currency of the Safety discount amount
  • CMS_RE_OBJ.MANDT == TCURC.MANDT
  • CMS_RE_OBJ.SFTY_AMT_CURR == TCURC.WAERS
Foreign key for transport connection types
  • ?
  • Client
  • Transport Connection