CMS_RE_OBJ

Transparent Table Application Table
64 Fields 3 CDS Views

Real estate header details

CMS_RE_OBJ is an SAP database table in S/4HANA. Real estate header details. It contains 64 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CollateralRealEstate view from BASIC Collateral Real Estate Object Details
I_CollateralRealEstateMaster view from BASIC Collateral Real Estate Object Details
I_RealEstateObjectMasterData view from BASIC Collateral Real Estate Object Details

Fields (64)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY obj_guid CMS_RE_DTE_OBJ_GUID Object GUID
object_id CMS_RE_DTE_OBJECT_ID Object ID
object_type CMS_RE_DTE_OBJ_TYP Object Type
addr_id CMS_RE_DTE_ADDR_ID Address ID
object_desc CMS_RE_DTE_OBJ_DESC Description
obj_parent_id CMS_RE_DTE_OBJ_GUID Object GUID
obj_old_ref_no CMS_RE_DTE_OBJ_REF_NO Ext. reference
fix_fitting_typ CMS_RE_DTE_FIX_FIT_TYP Fixture&Fitting
object_area_uom CMS_RE_DTE_AREA_UOM Area UOM
object_vol_uom CMS_RE_DTE_VOL_UOM Volume UOM
object_curr CMS_RE_DTE_OBJ_CURR Object Curr
macro_loc_type CMS_RE_DTE_ATT_ID_TY_REO002 Macro Location
micro_loc_type CMS_RE_DTE_ATT_ID_TY_REO003 Micro Location
tran_conn_type CMS_RE_DTE_ATT_ID_TY_REO004 Tranport Conn
environ_status CMS_RE_DTE_ATT_ID_TY_REO005 Environ. Status
flood_zone_flg CMS_RE_DTE_FLOOD_ZONE Flood Zone
earthquake_flg CMS_RE_DTE_EARTHQUAKE Earthquake Zone
arct_conv_flg CMS_RE_DTE_ARCT_CONV Arct. Conv Site
hist_site_flg CMS_RE_DTE_HIST_SITE Historical Site
is_val_imp_facs CMS_RE_DTE_VAL_IMP_FLG Imp Factors
value_imp_desc CMS_RE_DTE_VAL_IMP_DESC Des.Imp Factors
admin_org_unit CMS_DTE_ADMINORG AdminOrg
bankarea CMS_DTE_BANKAREA Bankarea
created_by CMS_RE_DTE_CR_BY Created By
created_date CMS_RE_DTE_CR_ON Created On
created_time CMS_RE_DTE_CR_AT Created At
entry_src CMS_RE_DTE_SRC_INIT Source Of Entry
last_chg_by CMS_RE_DTE_CHG_BY Last Changed by
last_chg_date CMS_RE_DTE_CHG_ON Last Changed On
last_chg_time CMS_RE_DTE_CHG_AT Last Changed At
processing_src CMS_RE_DTE_PRC_SRC Processing Src
risk_code CMS_RE_DTE_RISK_CODE Risk Code
sfty_ind CMS_RE_DTE_IND_SFTY_DISC Def Safety disc
sfty_dscnt CMS_RE_DTE_SAFETY_DSCNT Safety disc (%)
sfty_amount CMS_RE_DTE_SAFETY_AMT Sfty disc (amt)
sfty_amt_curr CMS_RE_DTE_SAFETY_AMT_CURR Currency
valuation_typ CMS_RE_DTE_IND_VALN_TYP Valuation type
unit_valn_freq CMS_RE_DTE_IND_FREQUENCY ValuationPeriod
period_valn_freq CMS_RE_DTE_VALN_FREQ_PERIOD Valn period
past_valued_date CMS_RE_DTE_VALN_DATE Last Revaln dt
start_date CMS_RE_DTE_START_DATE Revaln start dt
end_date CMS_RE_DTE_END_DATE Revaln End date
lending_rate_ind CMS_RE_DTE_IND_LND_RTE Lending Rate
lending_rate1 CMS_RE_DTE_LRTE_PCT1 Rate 1
lending_rate2 CMS_RE_DTE_LRTE_PCT2 Rate 2
lending_rate3 CMS_RE_DTE_LRTE_PCT3 Rate 3
lending_rate4 CMS_RE_DTE_LRTE_PCT4 Rate 4
lending_rate5 CMS_RE_DTE_LRTE_PCT5 Rate 5
liqd_typ CMS_RE_DTE_LIQD_TYP Liquidation typ
liqd_reason CMS_DTE_ATT_ID_TY_AST004 Liquidation Rsn
liqd_date CMS_RE_DTE_LIQD_DATE Liqd Date
liqd_amt CMS_RE_DTE_LIQD_VALUE Liqd Value
liqd_curr CMS_RE_DTE_LIQD_CURR Currency
unit_verf_freq CMS_DTE_IND_AST_VERF_FREQ_UNIT VerifcationUnit
period_verf_freq CMS_DTE_AST_VERF_FREQ_PERIOD Verf. Period
last_verf_date CMS_DTE_AST_VERF_DATE Last Verf. Date
org_unit1 CMS_RE_DTE_ORG_UNIT1 Org Unit 1
org_unit2 CMS_RE_DTE_ORG_UNIT2 Org Unit 2
org_unit3 CMS_RE_DTE_ORG_UNIT3 Org Unit 3
org_unit4 CMS_RE_DTE_ORG_UNIT4 Org Unit 4
org_unit5 CMS_RE_DTE_ORG_UNIT5 Org Unit 5
bupr_id CMS_DTE_BUPR_ID Bus. Process ID
bupr_type_code CMS_DTE_BUPR_TYP_CODE BusProcess Code

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Real estate header details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_RE_OBJ (
    MANDT,             -- Client [MANDT]
    OBJ_GUID,          -- Object GUID [CMS_RE_DTE_OBJ_GUID]
    OBJECT_ID,         -- Object ID [CMS_RE_DTE_OBJECT_ID]
    OBJECT_TYPE,       -- Object Type [CMS_RE_DTE_OBJ_TYP]
    ADDR_ID,           -- Address ID [CMS_RE_DTE_ADDR_ID]
    OBJECT_DESC,       -- Description [CMS_RE_DTE_OBJ_DESC]
    OBJ_PARENT_ID,     -- Object GUID [CMS_RE_DTE_OBJ_GUID]
    OBJ_OLD_REF_NO,    -- Ext. reference [CMS_RE_DTE_OBJ_REF_NO]
    FIX_FITTING_TYP,   -- Fixture&Fitting [CMS_RE_DTE_FIX_FIT_TYP]
    OBJECT_AREA_UOM,   -- Area UOM [CMS_RE_DTE_AREA_UOM]
    OBJECT_VOL_UOM,    -- Volume UOM [CMS_RE_DTE_VOL_UOM]
    OBJECT_CURR,       -- Object Curr [CMS_RE_DTE_OBJ_CURR]
    MACRO_LOC_TYPE,    -- Macro Location [CMS_RE_DTE_ATT_ID_TY_REO002]
    MICRO_LOC_TYPE,    -- Micro Location [CMS_RE_DTE_ATT_ID_TY_REO003]
    TRAN_CONN_TYPE,    -- Tranport Conn [CMS_RE_DTE_ATT_ID_TY_REO004]
    ENVIRON_STATUS,    -- Environ. Status [CMS_RE_DTE_ATT_ID_TY_REO005]
    FLOOD_ZONE_FLG,    -- Flood Zone [CMS_RE_DTE_FLOOD_ZONE]
    EARTHQUAKE_FLG,    -- Earthquake Zone [CMS_RE_DTE_EARTHQUAKE]
    ARCT_CONV_FLG,     -- Arct. Conv Site [CMS_RE_DTE_ARCT_CONV]
    HIST_SITE_FLG,     -- Historical Site [CMS_RE_DTE_HIST_SITE]
    IS_VAL_IMP_FACS,   -- Imp Factors [CMS_RE_DTE_VAL_IMP_FLG]
    VALUE_IMP_DESC,    -- Des.Imp Factors [CMS_RE_DTE_VAL_IMP_DESC]
    ADMIN_ORG_UNIT,    -- AdminOrg [CMS_DTE_ADMINORG]
    BANKAREA,          -- Bankarea [CMS_DTE_BANKAREA]
    CREATED_BY,        -- Created By [CMS_RE_DTE_CR_BY]
    CREATED_DATE,      -- Created On [CMS_RE_DTE_CR_ON]
    CREATED_TIME,      -- Created At [CMS_RE_DTE_CR_AT]
    ENTRY_SRC,         -- Source Of Entry [CMS_RE_DTE_SRC_INIT]
    LAST_CHG_BY,       -- Last Changed by [CMS_RE_DTE_CHG_BY]
    LAST_CHG_DATE,     -- Last Changed On [CMS_RE_DTE_CHG_ON]
    LAST_CHG_TIME,     -- Last Changed At [CMS_RE_DTE_CHG_AT]
    PROCESSING_SRC,    -- Processing Src [CMS_RE_DTE_PRC_SRC]
    RISK_CODE,         -- Risk Code [CMS_RE_DTE_RISK_CODE]
    SFTY_IND,          -- Def Safety disc [CMS_RE_DTE_IND_SFTY_DISC]
    SFTY_DSCNT,        -- Safety disc (%) [CMS_RE_DTE_SAFETY_DSCNT]
    SFTY_AMOUNT,       -- Sfty disc (amt) [CMS_RE_DTE_SAFETY_AMT]
    SFTY_AMT_CURR,     -- Currency [CMS_RE_DTE_SAFETY_AMT_CURR]
    VALUATION_TYP,     -- Valuation type [CMS_RE_DTE_IND_VALN_TYP]
    UNIT_VALN_FREQ,    -- ValuationPeriod [CMS_RE_DTE_IND_FREQUENCY]
    PERIOD_VALN_FREQ,  -- Valn period [CMS_RE_DTE_VALN_FREQ_PERIOD]
    PAST_VALUED_DATE,  -- Last Revaln dt [CMS_RE_DTE_VALN_DATE]
    START_DATE,        -- Revaln start dt [CMS_RE_DTE_START_DATE]
    END_DATE,          -- Revaln End date [CMS_RE_DTE_END_DATE]
    LENDING_RATE_IND,  -- Lending Rate [CMS_RE_DTE_IND_LND_RTE]
    LENDING_RATE1,     -- Rate 1 [CMS_RE_DTE_LRTE_PCT1]
    LENDING_RATE2,     -- Rate 2 [CMS_RE_DTE_LRTE_PCT2]
    LENDING_RATE3,     -- Rate 3 [CMS_RE_DTE_LRTE_PCT3]
    LENDING_RATE4,     -- Rate 4 [CMS_RE_DTE_LRTE_PCT4]
    LENDING_RATE5,     -- Rate 5 [CMS_RE_DTE_LRTE_PCT5]
    LIQD_TYP,          -- Liquidation typ [CMS_RE_DTE_LIQD_TYP]
    LIQD_REASON,       -- Liquidation Rsn [CMS_DTE_ATT_ID_TY_AST004]
    LIQD_DATE,         -- Liqd Date [CMS_RE_DTE_LIQD_DATE]
    LIQD_AMT,          -- Liqd Value [CMS_RE_DTE_LIQD_VALUE]
    LIQD_CURR,         -- Currency [CMS_RE_DTE_LIQD_CURR]
    UNIT_VERF_FREQ,    -- VerifcationUnit [CMS_DTE_IND_AST_VERF_FREQ_UNIT]
    PERIOD_VERF_FREQ,  -- Verf. Period [CMS_DTE_AST_VERF_FREQ_PERIOD]
    LAST_VERF_DATE,    -- Last Verf. Date [CMS_DTE_AST_VERF_DATE]
    ORG_UNIT1,         -- Org Unit 1 [CMS_RE_DTE_ORG_UNIT1]
    ORG_UNIT2,         -- Org Unit 2 [CMS_RE_DTE_ORG_UNIT2]
    ORG_UNIT3,         -- Org Unit 3 [CMS_RE_DTE_ORG_UNIT3]
    ORG_UNIT4,         -- Org Unit 4 [CMS_RE_DTE_ORG_UNIT4]
    ORG_UNIT5,         -- Org Unit 5 [CMS_RE_DTE_ORG_UNIT5]
    BUPR_ID,           -- Bus. Process ID [CMS_DTE_BUPR_ID]
    BUPR_TYPE_CODE,    -- BusProcess Code [CMS_DTE_BUPR_TYP_CODE]
    PRIMARY KEY (MANDT, OBJ_GUID)
);

Learn More