dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table CMS_RE_OBJ

Real estate header details

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table CMS_RE_OBJ (Real estate header details) is a standard table in SAP ERP. It belongs to the package CMS_RE.

Technical Information

Table CMS_RE_OBJ
Short Text Real estate header details
Package CMS_RE
Table Type Transparent Table

Fields for Table CMS_RE_OBJ

Field Name Key Description Data Element Type Length Check Table
MANDT ✔ Client MANDT CLNT 3 T000
OBJ_GUID ✔ GUID for Real Estate Object CMS_RE_DTE_OBJ_GUID RAW 16
OBJECT_ID Object ID CMS_RE_DTE_OBJECT_ID CHAR 20
OBJECT_TYPE Real Estate Object Type ID CMS_RE_DTE_OBJ_TYP CHAR 6 TCMS_RE_TYP
ADDR_ID Address ID CMS_RE_DTE_ADDR_ID CHAR 10 *
OBJECT_DESC Description of the Real Estate Object CMS_RE_DTE_OBJ_DESC CHAR 30
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 32
FIX_FITTING_TYP Fixtures and Fittings Type ID CMS_RE_DTE_FIX_FIT_TYP CHAR 6
OBJECT_AREA_UOM Unit of Measure for Area CMS_RE_DTE_AREA_UOM UNIT 3 *
OBJECT_VOL_UOM Unit of Measure for Volume of Real Estate CMS_RE_DTE_VOL_UOM UNIT 3 *
OBJECT_CURR Object Currency CMS_RE_DTE_OBJ_CURR CUKY 5 TCURC
MACRO_LOC_TYPE Macro Location CMS_RE_DTE_ATT_ID_TY_REO002 CHAR 6 TCMS_ATT_ID_TY
MICRO_LOC_TYPE Micro Location CMS_RE_DTE_ATT_ID_TY_REO003 CHAR 6 TCMS_ATT_ID_TY
TRAN_CONN_TYPE Transport Connection CMS_RE_DTE_ATT_ID_TY_REO004 CHAR 6 TCMS_ATT_ID_TY
ENVIRON_STATUS Enviromental Status CMS_RE_DTE_ATT_ID_TY_REO005 CHAR 6 TCMS_ATT_ID_TY
FLOOD_ZONE_FLG Indicator for Flood Zone CMS_RE_DTE_FLOOD_ZONE CHAR 1
EARTHQUAKE_FLG Indicator : Eathquake Zone CMS_RE_DTE_EARTHQUAKE CHAR 1
ARCT_CONV_FLG Indicator for Architectural Conservation Area CMS_RE_DTE_ARCT_CONV CHAR 1
HIST_SITE_FLG Indicator for Historical Site CMS_RE_DTE_HIST_SITE CHAR 1
IS_VAL_IMP_FACS Indicates existence of Factors Impairing Real Estate Value CMS_RE_DTE_VAL_IMP_FLG CHAR 1
VALUE_IMP_DESC Description of the value imparing factor CMS_RE_DTE_VAL_IMP_DESC CHAR 30
ADMIN_ORG_UNIT Administration Organizational Unit CMS_DTE_ADMINORG CHAR 12
BANKAREA Bank Area in Collateral Management CMS_DTE_BANKAREA CHAR 4 *
CREATED_BY Real Estate Add-On User CMS_RE_DTE_CR_BY CHAR 12
CREATED_DATE Created On CMS_RE_DTE_CR_ON DATS 8
CREATED_TIME Created At CMS_RE_DTE_CR_AT TIMS 6
ENTRY_SRC Sorce of Initial entry CMS_RE_DTE_SRC_INIT CHAR 32
LAST_CHG_BY Last Changed By CMS_RE_DTE_CHG_BY CHAR 12
LAST_CHG_DATE Last Changed On CMS_RE_DTE_CHG_ON DATS 8
LAST_CHG_TIME Last Changed At CMS_RE_DTE_CHG_AT TIMS 6
PROCESSING_SRC Processing Source CMS_RE_DTE_PRC_SRC CHAR 32
RISK_CODE Risk Code CMS_RE_DTE_RISK_CODE CHAR 6 *
SFTY_IND Indicates that the asset has a default sfty discount or not CMS_RE_DTE_IND_SFTY_DISC CHAR 2
SFTY_DSCNT Safety discount CMS_RE_DTE_SAFETY_DSCNT DEC 10
SFTY_AMOUNT Safety discount as an amount CMS_RE_DTE_SAFETY_AMT CURR 17
SFTY_AMT_CURR Currency of the Safety discount amount CMS_RE_DTE_SAFETY_AMT_CURR CUKY 5 TCURC
VALUATION_TYP Type of Check conducted on the object CMS_RE_DTE_IND_VALN_TYP CHAR 2
UNIT_VALN_FREQ Indicator : Valuation Period CMS_RE_DTE_IND_FREQUENCY CHAR 2
PERIOD_VALN_FREQ Period of revaluation for a real estate CMS_RE_DTE_VALN_FREQ_PERIOD NUMC 4
PAST_VALUED_DATE Most Recent Date on which the Real Estate was last Valued CMS_RE_DTE_VALN_DATE DATS 8
START_DATE Revaluation Start date CMS_RE_DTE_START_DATE DATS 8
END_DATE End date for Revaluation of the Real Estate CMS_RE_DTE_END_DATE DATS 8
LENDING_RATE_IND Indicates that the asset has a default lending rate or not CMS_RE_DTE_IND_LND_RTE CHAR 2
LENDING_RATE1 Lending rate 1 CMS_RE_DTE_LRTE_PCT1 DEC 10
LENDING_RATE2 Lending rate 2 CMS_RE_DTE_LRTE_PCT2 DEC 10
LENDING_RATE3 Lending rate 3 CMS_RE_DTE_LRTE_PCT3 DEC 10
LENDING_RATE4 Lending rate 4 CMS_RE_DTE_LRTE_PCT4 DEC 10
LENDING_RATE5 Lending rate 5 CMS_RE_DTE_LRTE_PCT5 DEC 10
LIQD_TYP Liquidation type CMS_RE_DTE_LIQD_TYP CHAR 6
LIQD_REASON Liquidation Reason CMS_DTE_ATT_ID_TY_AST004 CHAR 6 TCMS_ATT_ID_TY
LIQD_DATE Date of Liquidation of Collateral CMS_RE_DTE_LIQD_DATE DATS 8
LIQD_AMT Proceeds obtained from liquidation of the collateral CMS_RE_DTE_LIQD_VALUE CURR 17
LIQD_CURR Currency of Liquidation value CMS_RE_DTE_LIQD_CURR CUKY 5 TCURC
UNIT_VERF_FREQ Indicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNIT CHAR 2
PERIOD_VERF_FREQ Statement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIOD NUMC 4
LAST_VERF_DATE Last Verification Date CMS_DTE_AST_VERF_DATE DATS 8
ORG_UNIT1 organization unit 1: Assets CMS_RE_DTE_ORG_UNIT1 CHAR 10 *
ORG_UNIT2 organization unit 2: Assets CMS_RE_DTE_ORG_UNIT2 CHAR 10 *
ORG_UNIT3 organization unit 3: Assets CMS_RE_DTE_ORG_UNIT3 CHAR 10 *
ORG_UNIT4 organization unit 4: Assets CMS_RE_DTE_ORG_UNIT4 CHAR 10 *
ORG_UNIT5 organization unit 5: Assets CMS_RE_DTE_ORG_UNIT5 CHAR 10 *