CMS_RE_OBJ_PRT

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 Object part details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_RE_OBJ_PRT (
    MANDT,             -- Client [MANDT]
    OBJ_PRT_GUID,      -- Part GUID [CMS_RE_DTE_OBJ_PRT_GUID]
    OBJ_GUID,          -- Object GUID [CMS_RE_DTE_OBJ_GUID]
    PART_ID,           -- Part ID [CMS_RE_DTE_PART_ID]
    BLD_PART_TYPE,     -- Bld. Part Type [CMS_RE_DTE_ATT_ID_TY_REO006]
    PART_COND,         -- Condition [CMS_RE_DTE_ATT_ID_TY_REO001]
    MAIN_USAGE,        -- Usage Type [CMS_RE_DTE_USG_TYP]
    ADD_USAGE_1,       -- Addition Usage1 [CMS_RE_DTE_ADD1_USG_TYP]
    ADD_USAGE_2,       -- Addition Usage2 [CMS_RE_DTE_ADD2_USG_TYP]
    BLD_METHOD_ROOF,   -- Bld. Mthd Roof [CMS_RE_DTE_ATT_ID_TY_REO007]
    BLD_METHOD_BODY,   -- Bld. Mthd Body [CMS_RE_DTE_ATT_ID_TY_REO008]
    BLD_METD_CELLAR,   -- Bld. MthdCellar [CMS_RE_DTE_ATT_ID_TY_REO009]
    UTILIZATION,       -- Utilization [CMS_RE_DTE_PRT_UTILIZATION]
    PART_DESC,         -- Description [CMS_RE_DTE_SPC_DESC]
    COMM_USAGE_PCT,    -- Comm Usage(%) [CMS_RE_DTE_COM_USE_PCT]
    OTHER_USG_FLG,     -- Third Party Usg [CMS_RE_DTE_OTH_USE_FLG]
    REF_OBJ_PRT_GUID,  -- RefGUID [CMS_RE_DTE_REF_OBJ_PRT_GUID]
    IS_SUB_AST_CREA,   -- Sub Asset [CMS_RE_DTE_CREATE_SUB_AST_FLG]
    USEFUL_AREA,       -- Usable area [CMS_RE_DTE_AREA_USEFUL]
    USBL_AREA_UOM,     -- Area UOM [CMS_RE_DTE_USBL_AREA_UOM]
    USEFUL_AREA_REN,   -- Usbl area(rent) [CMS_RE_DTE_AREA_USEFUL_REN]
    USBL_AR_REN_UOM,   -- Area UOM [CMS_RE_DTE_USBL_AREA_REN_UOM]
    USEFUL_VOL,        -- Usable Volume [CMS_RE_DTE_VOL_USEFUL]
    USBL_VOL_UOM,      -- Volume UOM [CMS_RE_DTE_USBL_VOL_UOM]
    USEFUL_VOL_REN,    -- Usbl Vol(rent) [CMS_RE_DTE_VOL_USEFUL_REN]
    USBL_VL_REN_UOM,   -- Volume UOM [CMS_RE_DTE_USBL_VOL_REN_UOM]
    RESIDENTIAL_AREA,  -- ResidentialArea [CMS_RE_DTE_AREA_RESIDENTIAL]
    RES_AR_UOM,        -- Area UOM [CMS_RE_DTE_RES_AREA_UOM]
    SECONDARY_AREA,    -- Secondary Area [CMS_RE_DTE_AREA_SECONDARY]
    SEC_AREA_UOM,      -- Area UOM [CMS_RE_DTE_SEC_AREA_UOM]
    OTHER_AREA,        -- Other Area [CMS_RE_DTE_AREA_OTHER]
    OTH_AREA_UOM,      -- Area UOM [CMS_RE_DTE_OTH_AREA_UOM]
    NO_PRT_UNIT,       -- No. Build Part [CMS_RE_DTE_NO_PRT_UNIT]
    NO_PRT_UNIT_REN,   -- No. Bld Prt Rnt [CMS_RE_DTE_NO_PRT_UNIT_REN]
    CONS_START_DATE,   -- Cons Start Date [CMS_RE_DTE_OBJ_CONS_ST_DATE]
    PERMSN_APPL_DATE,  -- Pmsn Appl Date [CMS_RE_DTE_OBJ_PMSN_APPL_DATE]
    PERMSN_OBTD_DATE,  -- Pmsn Obtd Date [CMS_RE_DTE_OBJ_PMSN_OBTD_DATE]
    OCCY_DATE,         -- Occupancy Date [CMS_RE_DTE_OBJ_OCCY_DATE]
    COMP_DATE,         -- Completion Date [CMS_RE_DTE_OBJ_COMP_DATE]
    FINAL_INSP_DATE,   -- Final Insp Date [CMS_RE_DTE_OBJ_FINAL_INSP_DATE]
    RENT_AMT_PLANNED,  -- Planned Rent [CMS_RE_DTE_RENT_AMOUNT]
    RENT_AMT_ACTUAL,   -- Actual Rent [CMS_RE_DTE_RENT_AMOUNT_ACT]
    RENT_PLAN_CURR,    -- Currency [CMS_RE_DTE_RENT_PLANNED_CURR]
    RENT_ACT_CURR,     -- Currency [CMS_RE_DTE_RENT_ACTUAL_CURR]
    BASE_PERIOD,       -- Base period [CMS_RE_DTE_BASE_PERIOD]
    BASE_MEASURE,      -- Base Measure [CMS_RE_DTE_BASE_MEAS]
    VACANT_POSN_PCT,   -- Vacant Posn(%) [CMS_RE_DTE_VACANT_POS_PCT]
    RES_RENT_IND,      -- Rent Type [CMS_RE_DTE_RES_IND]
    COMP_RENT_RES,     -- Comp. Rent(Res) [CMS_RE_DTE_RENT_LEVEL]
    COM_REN_RES_CURR,  -- Currency [CMS_RE_DTE_COMP_RENT_RES_CURR]
    LAND_AREA,         -- Total Land area [CMS_RE_DTE_LAND_AREA]
    LAND_AREA_UOM,     -- UOM [CMS_RE_DTE_LAND_AREA_UOM]
    LAND_AREA_REN,     -- Rented LandArea [CMS_RE_DTE_LAND_AREA_REN]
    LAND_AR_REN_UOM,   -- UOM [CMS_RE_DTE_LAND_AREA_REN_UOM]
    NO_OF_UNITS,       -- Units [CMS_RE_DTE_NO_UNIT]
    NO_OF_FLOORS,      -- No. of Floors [CMS_RE_DTE_NO_FLOOR]
    NO_GARAGES,        -- No of Garages [CMS_RE_DTE_NO_GAR]
    NO_GARAGES_REN,    -- Garages Rented [CMS_RE_DTE_NO_GAR_REN]
    NO_PARK_UNIT,      -- No. Park Units [CMS_RE_DTE_NO_PARK_UNIT]
    NO_PARK_UNIT_REN,  -- Units Rented [CMS_RE_DTE_NO_PARK_UNIT_REN]
    NO_PARK_UG,        -- UG Park Unit [CMS_RE_DTE_NO_PARK_UNIT_UG]
    NO_PARK_UG_REN,    -- UG Units Rented [CMS_RE_DTE_NO_PARK_UNIT_UG_REN]
    NO_CUR_UNITS,      -- Current Units [CMS_RE_DTE_NO_CUR_UNIT]
    NO_CUR_UNITS_REN,  -- Curr Rent Units [CMS_RE_DTE_NO_CUR_UNIT_REN]
    NO_OLD_UNITS,      -- Old Units [CMS_RE_DTE_NO_OLD_UNIT]
    NO_OLD_UNITS_REN,  -- Old Rent Units [CMS_RE_DTE_NO_OLD_UNIT_REN]
    NO_NEW_UNITS,      -- New Units [CMS_RE_DTE_NO_NEW_UNIT]
    NO_NEW_UNITS_REN,  -- New Rent Units [CMS_RE_DTE_NO_NEW_UNIT_REN]
    NO_ACCESS_STR,     -- No. Acc Struct [CMS_RE_DTE_NO_ACCESS_STR]
    NO_SALE_LEVEL,     -- No. Sal Level [CMS_RE_DTE_NO_SALE_LEVEL]
    NO_OF_ROOMS,       -- No. of Rooms [CMS_RE_DTE_NO_ROOMS]
    NO_OF_BEDS,        -- No. of Beds [CMS_RE_DTE_NO_BEDS]
    COMM_ENV_DESC,     -- Des. Comm. Env. [CMS_RE_DTE_COMM_ENV_DESC]
    ACCESS_STR_DESC,   -- Des. Acc.Struct [CMS_RE_DTE_ACCESS_STR_DESC]
    BLD_SECTION_DESC,  -- BuildingSection [CMS_RE_DTE_ATT_ID_TY_REO015]
    PRICE_CATEGORY,    -- Price Category [CMS_RE_DTE_ATT_ID_TY_REO013]
    AVG_PRICE,         -- Avg Price/Day [CMS_RE_DTE_AVG_PRICE]
    AVG_PRICE_CURR,    -- Currency [CMS_RE_DTE_AVG_PRICE_CURR]
    OCCUPANCY_PCT,     -- Occupancy (%) [CMS_RE_DTE_OCCY_PCT]
    TURNOVER_AMT,      -- Total Turn Over [CMS_RE_DTE_TURNOVER_AMOUNT]
    TURNOVER_CURR,     -- Currency [CMS_RE_DTE_TURNOVER_CURR]
    RENTAL_AGMT_TYP,   -- Rental Agmt Typ [CMS_RE_DTE_ATT_ID_TY_REO014]
    LAST_REPORT_DATE,  -- Last Rep Date [CMS_RE_DTE_LAST_CONST_REP_DATE]
    BLD_PROGRESS_AMT,  -- Amt BldProgress [CMS_RE_DTE_AMT_BLD_PROGRESS]
    BLD_AMT_CURR,      -- Currency [CMS_RE_DTE_BLD_PROGRESS_CURR]
    PCT_COMPLETED,     -- Completion(%) [CMS_RE_DTE_DEGREE_COMPLETE]
    INSURANCE_TYPE,    -- Insurance Type [CMS_RE_DTE_ATT_ID_TY_REO011]
    INSURANCE_AMT,     -- Insurance Amt [CMS_RE_DTE_INSURANCE_AMOUNT]
    INSURANCE_CURR,    -- Currency [CMS_RE_DTE_INSURANCE_CURR]
    INS_VALIDITY,      -- Ins. Valid Till [CMS_RE_DTE_INS_VALID_TILL]
    RATIONING_COST,    -- Ration Cst(Res) [CMS_RE_DTE_RAT_COST_AMT]
    RTN_CST_PCT,       -- Rtn Cst(%)-Res [CMS_RE_DTE_RAN_COST_PCT]
    EXT_LAYOUT_COST,   -- Ext Layout Cost [CMS_RE_DTE_EXT_LAYOUT_COST]
    EXT_LAY_CST_PCT,   -- ExtLayoutCst(%) [CMS_RE_DTE_EXT_LAYOUT_COST_PCT]
    RTN_CST_CURR,      -- Currency [CMS_RE_DTE_RTN_CST_CURR]
    EXT_RTN_CST_CURR,  -- Currency [CMS_RE_DTE_EXT_LAYOUT_CST_CURR]
    RTN_CST_COM,       -- Ration Cst(Com) [CMS_RE_DTE_RAT_COST_AMT_COM]
    RTN_CST_COM_CURR,  -- Currency [CMS_RE_DTE_RTN_CST_CURR_COM]
    RTN_CST_COM_PCT,   -- Rtn Cst(%)-Com [CMS_RE_DTE_RAN_COST_PCT_COM]
    GROSS_COLD_RENT,   -- Gross Cold Rent [CMS_RE_DTE_YRLY_GROSS_COLD_REN]
    GROSS_RENT_CURR,   -- Currency [CMS_RE_DTE_GROSS_RENT_CURR]
    NET_COLD_RENT,     -- Net Cold Rent [CMS_RE_DTE_YRLY_NET_COLD_REN]
    NET_RENT_CURR,     -- Currency [CMS_RE_DTE_NET_RENT_CURR]
    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]
    NO_OF_YEARS_COM,   -- Noof years(Com) [CMS_RE_DTE_VAL_NO_YEARS_COM]
    INT_RATE_COM,      -- Int Rate(Com) [CMS_RE_DTE_VAL_INT_RATE_COM]
    NO_OF_YEARS,       -- Noof years(Res) [CMS_RE_DTE_VALUATION_NO_YEARS]
    INT_RATE,          -- Int Rate(Res) [CMS_RE_DTE_VALUATION_INT_RATE]
    RENT_PLANNED_COM,  -- Planned Rent [CMS_RE_DTE_RENT_AMOUNT]
    RENT_ACTUAL_COM,   -- Actual Rent [CMS_RE_DTE_RENT_AMOUNT_ACT]
    PLAN_CURR_COM,     -- Currency [CMS_RE_DTE_RENT_PLANNED_CURR]
    ACT_CURR_COM,      -- Currency [CMS_RE_DTE_RENT_ACTUAL_CURR]
    BASE_PERIOD_COM,   -- Base period [CMS_RE_DTE_BASE_PERIOD]
    BASE_MEAS_COM,     -- Base Measure [CMS_RE_DTE_BASE_MEAS]
    COM_RENT_IND,      -- Rent Type [CMS_RE_DTE_COM_IND]
    COMP_RENT_COM,     -- Comp. Rent(Com) [CMS_RE_DTE_RENT_LEVEL_COM]
    COMP_REN_COM_CUR,  -- Currency [CMS_RE_DTE_COMP_RENT_COM_CURR]
    PLAN_RENT_LAND,    -- Planned Rent [CMS_RE_DTE_RENT_AMOUNT]
    ACTUAL_RENT_LAND,  -- Actual Rent [CMS_RE_DTE_RENT_AMOUNT_ACT]
    PLAN_RENT_CURR,    -- Currency [CMS_RE_DTE_RENT_PLANNED_CURR]
    ACTUAL_RENT_CURR,  -- Currency [CMS_RE_DTE_RENT_ACTUAL_CURR]
    BASE_PERIOD_LAND,  -- Base period [CMS_RE_DTE_BASE_PERIOD]
    BASE_MEAS_LAND,    -- Base Measure [CMS_RE_DTE_BASE_MEAS]
    DEPR,              -- Depriciation(%) [CMS_RE_DTE_DEPR]
    LAND_COST,         -- Land Cost [CMS_RE_DTE_LAND_COST]
    LAND_COST_CURR,    -- Currency [CMS_RE_DTE_LAND_COST_CURR]
    DEV_COST,          -- DevelopmentCost [CMS_RE_DTE_DEV_COST]
    DEV_COST_CURR,     -- Currency [CMS_RE_DTE_DEV_COST_CURR]
    LAND_CST_BASE,     -- Base Measure [CMS_RE_DTE_BASE_MEAS_LAND]
    DEV_CST_BASE,      -- Base Measure [CMS_RE_DTE_BASE_MEAS_LAND]
    ADD_LAND_CST,      -- Addn. Land Cost [CMS_RE_DTE_ADD_LAND_COST]
    ADD_CST_CURR,      -- Currency [CMS_RE_DTE_ADD_LAND_COST_CURR]
    ADD_CST_BASE,      -- Base Measure [CMS_RE_DTE_BASE_MEAS_LAND]
    CONST_COST,        -- Constr. Cost [CMS_RE_DTE_CONS_COST]
    CONST_COST_CURR,   -- Currency [CMS_RE_DTE_CONS_COST_CURR]
    BASE_MEAS,         -- Base Measure [CMS_RE_DTE_BASE_MEAS]
    GRS_PROFIT,        -- Yrly Grs Profit [CMS_RE_DTE_GRS_PROFIT]
    GRS_PROFIT_CURR,   -- Currency [CMS_RE_DTE_GRS_PROFIT_CURR]
    PRIMARY KEY (MANDT, OBJ_PRT_GUID)
);