CMS_RE_OBJ SAP table for – Real estate header details

Here we would like to draw your attention to CMS_RE_OBJ table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_RE_OBJ is a SAP standard transp table used for storing Real estate header details related data in SAP. It comes under the package CMS_RE.

SAP CMS_RE_OBJ table

Table CMS_RE_OBJ technical data

TableCMS_RE_OBJ
Data storingReal estate header details
ModuleFS
Sub ModuleFS-CMS-MD-RE
SAP PackageCMS_RE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_RE_OBJ Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_RE_OBJ table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Structure for Object GUID
    Its a key field.
  • OBJ_GUID : GUID for Real Estate Object
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Structure for Semantic key for Objects in RE Add-On
  • OBJECT_ID : Object ID
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Structure for Object Header
  • OBJECT_TYPE : Real Estate Object Type ID
    Its data type is CHAR (Character String) with field length 6
  • ADDR_ID : Address ID
    Its data type is CHAR (Character String) with field length 10
  • OBJECT_DESC : Description of the Real Estate Object
    Its data type is CHAR (Character String) with field length 30
  • OBJ_PARENT_ID : GUID for Real Estate Object
    Its data type is RAW (Byte string) with field length 16
  • OBJ_OLD_REF_NO : External reference Number of an External System
    Its data type is CHAR (Character String) with field length 32
  • FIX_FITTING_TYP : Fixtures and Fittings Type ID
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Structure for Object Unit Of Measure
  • OBJECT_AREA_UOM : Unit of Measure for Area
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • OBJECT_VOL_UOM : Unit of Measure for Volume of Real Estate
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Structure for Object Currency
  • OBJECT_CURR : Object Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Structure for Location description details
  • MACRO_LOC_TYPE : Macro Location
    Its data type is CHAR (Character String) with field length 6
  • MICRO_LOC_TYPE : Micro Location
    Its data type is CHAR (Character String) with field length 6
  • TRAN_CONN_TYPE : Transport Connection
    Its data type is CHAR (Character String) with field length 6
  • ENVIRON_STATUS : Enviromental Status
    Its data type is CHAR (Character String) with field length 6
  • FLOOD_ZONE_FLG : Indicator for Flood Zone
    Its data type is CHAR (Character String) with field length 1
  • EARTHQUAKE_FLG : Indicator : Eathquake Zone
    Its data type is CHAR (Character String) with field length 1
  • ARCT_CONV_FLG : Indicator for Architectural Conservation Area
    Its data type is CHAR (Character String) with field length 1
  • HIST_SITE_FLG : Indicator for Historical Site
    Its data type is CHAR (Character String) with field length 1
  • IS_VAL_IMP_FACS : Indicates existence of Factors Impairing Real Estate Value
    Its data type is CHAR (Character String) with field length 1
  • VALUE_IMP_DESC : Description of the value imparing factor
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Administrative organization unit
  • ADMIN_ORG_UNIT : Administration Organizational Unit
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Bank area
  • BANKAREA : Bank Area in Collateral Management
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Structure for history
  • CREATED_BY : Real Estate Add-On User
    Its data type is CHAR (Character String) with field length 12
  • CREATED_DATE : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATED_TIME : Created At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ENTRY_SRC : Sorce of Initial entry
    Its data type is CHAR (Character String) with field length 32
  • LAST_CHG_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • LAST_CHG_DATE : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAST_CHG_TIME : Last Changed At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PROCESSING_SRC : Processing Source
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : RE DB Asset Details – not used
  • .INCLUDE : Basic Asset data
  • RISK_CODE : Risk Code
    Its data type is CHAR (Character String) with field length 6
  • SFTY_IND : Indicates that the asset has a default sfty discount or not
    Its data type is CHAR (Character String) with field length 2
  • SFTY_DSCNT : Safety discount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SFTY_AMOUNT : Safety discount as an amount
    Its data type is CURR (Currency Field) with field length 17
  • SFTY_AMT_CURR : Currency of the Safety discount amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Valuation data
  • VALUATION_TYP : Type of Check conducted on the object
    Its data type is CHAR (Character String) with field length 2
  • UNIT_VALN_FREQ : Indicator : Valuation Period
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_VALN_FREQ : Period of revaluation for a real estate
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PAST_VALUED_DATE : Most Recent Date on which the Real Estate was last Valued
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • START_DATE : Revaluation Start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • END_DATE : End date for Revaluation of the Real Estate
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Lending rate data
  • LENDING_RATE_IND : Indicates that the asset has a default lending rate or not
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Lending rates
  • LENDING_RATE1 : Lending rate 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE2 : Lending rate 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE3 : Lending rate 3
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE4 : Lending rate 4
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • LENDING_RATE5 : Lending rate 5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Liquidation rights data
  • LIQD_TYP : Liquidation type
    Its data type is CHAR (Character String) with field length 6
  • LIQD_REASON : Liquidation Reason
    Its data type is CHAR (Character String) with field length 6
  • LIQD_DATE : Date of Liquidation of Collateral
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LIQD_AMT : Proceeds obtained from liquidation of the collateral
    Its data type is CURR (Currency Field) with field length 17
  • LIQD_CURR : Currency of Liquidation value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Verfication Data
  • UNIT_VERF_FREQ : Indicator: Units of time for verification of an asset
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_VERF_FREQ : Statement Period for an Asset
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • LAST_VERF_DATE : Last Verification Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Organization unit structure: RE
  • ORG_UNIT1 : organization unit 1: Assets
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT2 : organization unit 2: Assets
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT3 : organization unit 3: Assets
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT4 : organization unit 4: Assets
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT5 : organization unit 5: Assets
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes