I_RealEstateObjectMasterData

Real Estate Object Details | view: IREOBJMDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_RE_OBJ
Column Name Description
RealEstateUUID GUID for Real Estate Object
Column Name Description
Column Name Description
Column Name Description
RealEstateEnteredDate Created On
RealEstateEnteredTime Created At
RealEstateLastChangedDate Last Changed On
RealEstateLastChangedTime Last Changed At
Column Name Description
RealEstateIsFloodZone Indicator for Flood Zone Show values
RealEstateIsEarthquakeZone Indicator : Eathquake Zone Show values
RealEstateIsArchlConsvnArea Indicator for Architectural Conservation Area Show values
RealEstateIsHistoricalSite Indicator for Historical Site Show values
RealEstateHasFctrsImpairingVal Indicates existence of Factors Impairing Real Estate Value Show values
Column Name Description Domain name
RealEstateID Object ID CMS_RE_OBJECT_ID
RealEstateDescription Description of the Real Estate Object CMS_RE_DESC
RealEstateParentUUID GUID for Real Estate Object SYSUUID
RealEstateExtRefNumber External reference Number of an External System CMS_RE_REFID
RealEstteFctrsImpairingValDesc Description of the value imparing factor CMS_RE_DESC
CollateralAdminOrgUnit Administration Organizational Unit TEXT12
CollateralBankArea Bank Area in Collateral Management CMS_BANKAREA
RealEstateEnteredBy Real Estate Add-On User CMS_RE_USER
RealEstateEnteredSource Sorce of Initial entry CMS_RE_SOURCE
RealEstateLastChangedBy Last Changed By CMS_RE_USER
RealEstateLastChangedSource Processing Source CMS_RE_SOURCE
Master Data Relations Join Conditions
Real Estate Object Type ID I_REALESTATEOBJECTMASTERDATA.MANDT == TCMS_RE_TYP.MANDT
Foreign key for environmental status
  • ?
  • Enviromental Status
  • Client
  • I_REALESTATEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_REALESTATEOBJECTMASTERDATA.REALESTATEENVIRONMENTALSTATUS == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_REALESTATEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
Fixtures and Fittings Type ID
  • Client
  • Fixtures and Fittings Type ID
  • I_REALESTATEOBJECTMASTERDATA.MANDT == TCMS_RE_FX_FIT.MANDT
  • I_REALESTATEOBJECTMASTERDATA.REALESTATEFIXTUREFITTINGTYPE == TCMS_RE_FX_FIT.FIX_FITTING_TYPE
Foreign key for macro location type
  • ?
  • Macro Location
  • Client
  • I_REALESTATEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_REALESTATEOBJECTMASTERDATA.REALESTATEMACROLOCATION == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_REALESTATEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
Foreign key for micro location type
  • ?
  • Client
  • Micro Location
  • I_REALESTATEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_REALESTATEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_REALESTATEOBJECTMASTERDATA.REALESTATEMICROLOCATION == TCMS_ATT_ID_TY.INDICATOR_TYPE
Object Currency
  • Client
  • Object Currency
  • I_REALESTATEOBJECTMASTERDATA.MANDT == TCURC.MANDT
  • I_REALESTATEOBJECTMASTERDATA.REALESTATEOBJECTCURRENCY == TCURC.WAERS
Foreign key for transport connection types
  • ?
  • Client
  • Transport Connection
  • I_REALESTATEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_REALESTATEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_REALESTATEOBJECTMASTERDATA.REALESTATEOBJECTTRANSPTCONNCN == TCMS_ATT_ID_TY.INDICATOR_TYPE