CMS_RE_OBJ SAP (Real estate header details) Table details

Dictionary Type: Table
Description: Real estate header details




ABAP Code to SELECT data from CMS_RE_OBJ
Related tables to CMS_RE_OBJ
Access table CMS_RE_OBJ




Table field list including key, data, relationships and ABAP select examples

CMS_RE_OBJ is a standard SAP Table which is used to store Real estate header details data and is available within R/3 SAP systems depending on the version and release level.

The CMS_RE_OBJ table consists of various fields, each holding specific information or linking keys about Real estate header details data available in SAP. These include OBJ_GUID (GUID for Real Estate Object), OBJECT_ID (Object ID), OBJECT_TYPE (Real Estate Object Type ID), ADDR_ID (Address ID).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CMS_RE_OBJ table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
OBJ_GUIDGUID for Real Estate Object CMS_RE_DTE_OBJ_GUIDRAW16SYSUUIDCMS_RE_OBJ_GUID
OBJECT_IDObject ID CMS_RE_DTE_OBJECT_IDCHAR20ALPHACMS_RE_OBJECT_IDCMS_RE_OBJECT_IDCMS_RE_SRCH_ALL
OBJECT_TYPEReal Estate Object Type ID CMS_RE_DTE_OBJ_TYPCHAR6TCMS_RE_TYPCMS_RE_TYPCMS_RE_OBJECT_TYPE
ADDR_IDAddress ID CMS_RE_DTE_ADDR_IDCHAR10Assigned to domainALPHAAD_ADDRNUMADMC
OBJECT_DESCDescription of the Real Estate Object CMS_RE_DTE_OBJ_DESCCHAR30CMS_RE_DESC
OBJ_PARENT_IDGUID for Real Estate Object CMS_RE_DTE_OBJ_GUIDRAW16SYSUUIDCMS_RE_OBJ_GUID
OBJ_OLD_REF_NOExternal reference Number of an External System CMS_RE_DTE_OBJ_REF_NOCHAR32CMS_RE_REFID
FIX_FITTING_TYPFixtures and Fittings Type ID CMS_RE_DTE_FIX_FIT_TYPCHAR6ALPHACMS_RE_FIX_FIT_TYP
OBJECT_AREA_UOMUnit of Measure for Area CMS_RE_DTE_AREA_UOMUNIT3Assigned to domainCUNITMEINSCMS_AREA_UOMCMS_ELM_SURFACE_UOM
OBJECT_VOL_UOMUnit of Measure for Volume of Real Estate CMS_RE_DTE_VOL_UOMUNIT3Assigned to domainCUNITMEINSCMS_VOL_UOMCMS_ELM_VOLUME_UOM
OBJECT_CURRObject Currency CMS_RE_DTE_OBJ_CURRCUKY5TCURCWAERSCMS_OBJ_CURR
MACRO_LOC_TYPEMacro Location CMS_RE_DTE_ATT_ID_TY_REO002CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
MICRO_LOC_TYPEMicro Location CMS_RE_DTE_ATT_ID_TY_REO003CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
TRAN_CONN_TYPETransport Connection CMS_RE_DTE_ATT_ID_TY_REO004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
ENVIRON_STATUSEnviromental Status CMS_RE_DTE_ATT_ID_TY_REO005CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
FLOOD_ZONE_FLGIndicator for Flood Zone CMS_RE_DTE_FLOOD_ZONECHAR1ALPHACMS_RE_FLG
EARTHQUAKE_FLGIndicator : Eathquake Zone CMS_RE_DTE_EARTHQUAKECHAR1ALPHACMS_RE_FLG
ARCT_CONV_FLGIndicator for Architectural Conservation Area CMS_RE_DTE_ARCT_CONVCHAR1ALPHACMS_RE_FLG
HIST_SITE_FLGIndicator for Historical Site CMS_RE_DTE_HIST_SITECHAR1ALPHACMS_RE_FLG
IS_VAL_IMP_FACSIndicates existence of Factors Impairing Real Estate Value CMS_RE_DTE_VAL_IMP_FLGCHAR1ALPHACMS_RE_FLG
VALUE_IMP_DESCDescription of the value imparing factor CMS_RE_DTE_VAL_IMP_DESCCHAR30CMS_RE_DESC
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4Assigned to domainCMS_BANKAREACMS_BANKAREA
CREATED_BYReal Estate Add-On User CMS_RE_DTE_CR_BYCHAR12CMS_RE_USER
CREATED_DATECreated On CMS_RE_DTE_CR_ONDATS8CMS_RE_DATE
CREATED_TIMECreated At CMS_RE_DTE_CR_ATTIMS6CMS_RE_TIME
ENTRY_SRCSorce of Initial entry CMS_RE_DTE_SRC_INITCHAR32CMS_RE_SOURCE
LAST_CHG_BYLast Changed By CMS_RE_DTE_CHG_BYCHAR12CMS_RE_USER
LAST_CHG_DATELast Changed On CMS_RE_DTE_CHG_ONDATS8CMS_RE_DATE
LAST_CHG_TIMELast Changed At CMS_RE_DTE_CHG_ATTIMS6CMS_RE_TIME
PROCESSING_SRCProcessing Source CMS_RE_DTE_PRC_SRCCHAR32CMS_RE_SOURCE
RISK_CODERisk Code CMS_RE_DTE_RISK_CODECHAR6Assigned to domainCMS_RISK_CODE
SFTY_INDIndicates that the asset has a default sfty discount or not CMS_RE_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTSafety discount CMS_RE_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTSafety discount as an amount CMS_RE_DTE_SAFETY_AMTCURR17(2) CMS_AMOUNT
SFTY_AMT_CURRCurrency of the Safety discount amount CMS_RE_DTE_SAFETY_AMT_CURRCUKY5TCURCWAERS
VALUATION_TYPType of Check conducted on the object CMS_RE_DTE_IND_VALN_TYPCHAR2CMS_VALN_TYP
UNIT_VALN_FREQIndicator : Valuation Period CMS_RE_DTE_IND_FREQUENCYCHAR2CMS_RE_IND_FREQUENCY
PERIOD_VALN_FREQPeriod of revaluation for a real estate CMS_RE_DTE_VALN_FREQ_PERIODNUMC4CMS_RE_VALN_FREQ_PERIOD
PAST_VALUED_DATEMost Recent Date on which the Real Estate was last Valued CMS_RE_DTE_VALN_DATEDATS8CMS_DATE
START_DATERevaluation Start date CMS_RE_DTE_START_DATEDATS8CMS_DATE
END_DATEEnd date for Revaluation of the Real Estate CMS_RE_DTE_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicates that the asset has a default lending rate or not CMS_RE_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending rate 1 CMS_RE_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_RATE2Lending rate 2 CMS_RE_DTE_LRTE_PCT2DEC10(6) CMS_PCT
LENDING_RATE3Lending rate 3 CMS_RE_DTE_LRTE_PCT3DEC10(6) CMS_PCT
LENDING_RATE4Lending rate 4 CMS_RE_DTE_LRTE_PCT4DEC10(6) CMS_PCT
LENDING_RATE5Lending rate 5 CMS_RE_DTE_LRTE_PCT5DEC10(6) CMS_PCT
LIQD_TYPLiquidation type CMS_RE_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
LIQD_DATEDate of Liquidation of Collateral CMS_RE_DTE_LIQD_DATEDATS8CMS_DATE
LIQD_AMTProceeds obtained from liquidation of the collateral CMS_RE_DTE_LIQD_VALUECURR17(2) CMS_AMOUNT
LIQD_CURRCurrency of Liquidation value CMS_RE_DTE_LIQD_CURRCUKY5TCURCWAERS
UNIT_VERF_FREQIndicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNITCHAR2CMS_IND_AST_VERF_FREQ_UNIT
PERIOD_VERF_FREQStatement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIODNUMC4CMS_AST_VERF_FREQ_PERIOD
LAST_VERF_DATELast Verification Date CMS_DTE_AST_VERF_DATEDATS8CMS_DATE
ORG_UNIT1organization unit 1: Assets CMS_RE_DTE_ORG_UNIT1CHAR10Assigned to domainCMS_RE_ORG_UNIT
ORG_UNIT2organization unit 2: Assets CMS_RE_DTE_ORG_UNIT2CHAR10Assigned to domainCMS_RE_ORG_UNIT
ORG_UNIT3organization unit 3: Assets CMS_RE_DTE_ORG_UNIT3CHAR10Assigned to domainCMS_RE_ORG_UNIT
ORG_UNIT4organization unit 4: Assets CMS_RE_DTE_ORG_UNIT4CHAR10Assigned to domainCMS_RE_ORG_UNIT
ORG_UNIT5organization unit 5: Assets CMS_RE_DTE_ORG_UNIT5CHAR10Assigned to domainCMS_RE_ORG_UNIT

Key field Non-key field



How do I retrieve data from SAP table CMS_RE_OBJ using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_RE_OBJ to SELECT all data from the table
DATA: WA_CMS_RE_OBJ TYPE CMS_RE_OBJ.

SELECT SINGLE *
FROM CMS_RE_OBJ
INTO CORRESPONDING FIELDS OF WA_CMS_RE_OBJ
WHERE...

How to access SAP table CMS_RE_OBJ

Within an ECC or HANA version of SAP you can also view further information about CMS_RE_OBJ and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!