CMS_RE_OBJ_PRT

Real Estate Object part details | #masterdata | Component: Real Estate
Column Name Description
MANDT Client
OBJ_PRT_GUID GUID for Object part
Column Name Description
💲 Planned Rent Currency (RENT_PLAN_CURR):
RENT_AMT_PLANNED Planned Rent Amount
💲 Actual Rent Currency (RENT_ACT_CURR):
RENT_AMT_ACTUAL Actual Rent Amount
💲 Comparative Rent Currency - Residential (COM_REN_RES_CURR):
COMP_RENT_RES Comparative Rent (Residential)
💲 Average Price Currency (AVG_PRICE_CURR):
AVG_PRICE Average Price per Day
💲 Currency (TURNOVER_CURR):
TURNOVER_AMT Total Amount of Turnover
💲 Building Progress Amount Curreny (BLD_AMT_CURR):
BLD_PROGRESS_AMT Amount Disbursed for Construction based on Building Progress
💲 Insurance Currency (INSURANCE_CURR):
INSURANCE_AMT Insurance Amount
💲 Rationing cost currency (RTN_CST_CURR):
RATIONING_COST Residential Rationing Cost
💲 External Layout cost currency (EXT_RTN_CST_CURR):
EXT_LAYOUT_COST External Layout Cost
💲 Rationing cost currency (RTN_CST_COM_CURR):
RTN_CST_COM Commercial Rationing Cost
💲 Gross Cold Rent Currency (GROSS_RENT_CURR):
GROSS_COLD_RENT Gross Cold Rent
💲 Net Cold Rent Currency (NET_RENT_CURR):
NET_COLD_RENT Net Cold Rent
💲 Planned Rent Currency (PLAN_CURR_COM):
RENT_PLANNED_COM Planned Rent Amount
💲 Actual Rent Currency (ACT_CURR_COM):
RENT_ACTUAL_COM Actual Rent Amount
💲 Comparative Rent Currency (Commercial) (COMP_REN_COM_CUR):
COMP_RENT_COM Comparative Rent (Commercial)
💲 Planned Rent Currency (PLAN_RENT_CURR):
PLAN_RENT_LAND Planned Rent Amount
💲 Actual Rent Currency (ACTUAL_RENT_CURR):
ACTUAL_RENT_LAND Actual Rent Amount
💲 Land Cost Currency (LAND_COST_CURR):
LAND_COST Land Cost Amount
💲 Dev Cost Currency (DEV_COST_CURR):
DEV_COST Development Cost Amount
💲 Additional Land Cost Currency (ADD_CST_CURR):
ADD_LAND_CST Additional Land Cost Amount
💲 Construction cost currency (CONST_COST_CURR):
CONST_COST Construction Cost
💲 Yearly Gross Profit Currency (GRS_PROFIT_CURR):
GRS_PROFIT Yearly Gross Profit
Column Name Description
📏 Unit of Measure for Usable Area (USBL_AREA_UOM):
USEFUL_AREA Usable Area
📏 Unit of Measure for Usable Rented Area (USBL_AR_REN_UOM):
USEFUL_AREA_REN Rented Usable Area
📏 Unit of Measure for Usable Volume of Real Estate (USBL_VOL_UOM):
USEFUL_VOL Usable Volume of Real Estate Building Parts
📏 Unit of measure for usable volume of Rented Parts (USBL_VL_REN_UOM):
USEFUL_VOL_REN Usable Volume of the Rented Portions of Real Estate
📏 Unit of Measure for Residential Area (RES_AR_UOM):
RESIDENTIAL_AREA Residential Area
📏 Unit of Measure for Secondary Area (SEC_AREA_UOM):
SECONDARY_AREA Secondary Area
📏 Unit of Measure for Other Area (OTH_AREA_UOM):
OTHER_AREA Other Area
📏 Unit of Measure of Land Area (LAND_AREA_UOM):
LAND_AREA Land Area of the Real Estate
📏 Land area unit of measure(rented) (LAND_AR_REN_UOM):
LAND_AREA_REN Land Area of the Real Estate which is Rented
Column Name Description
CONS_START_DATE Start Date of Construction
PERMSN_APPL_DATE Building Permssion applied date
PERMSN_OBTD_DATE Building Permssion obtained date
OCCY_DATE Occupancy Date
COMP_DATE Completion Date
FINAL_INSP_DATE Date of Final Inspection
LAST_REPORT_DATE Date of Last Constuction Report
INS_VALIDITY Date until which the Insurance Stands Valid
CREATED_DATE Created On
CREATED_TIME Created At
LAST_CHG_DATE Last Changed On
LAST_CHG_TIME Last Changed At
Column Name Description
UTILIZATION Utilization of the Object Show values
OTHER_USG_FLG Indicates if Usages in addition to Main Usage are Possible Show values
IS_SUB_AST_CREA Indicates whether a Sub-asset is created for Building Part Show values
BASE_PERIOD Base period for the rent Show values
BASE_MEASURE Base Measure Show values
RES_RENT_IND Indicator for Net or Gross Rent Show values
BASE_PERIOD_COM Base period for the rent Show values
BASE_MEAS_COM Base Measure Show values
COM_RENT_IND Indicator for Rent Type Show values
BASE_PERIOD_LAND Base period for the rent Show values
BASE_MEAS_LAND Base Measure Show values
LAND_CST_BASE Base measure of Land Show values
DEV_CST_BASE Base measure of Land Show values
ADD_CST_BASE Base measure of Land Show values
BASE_MEAS Base Measure Show values
Column Name Description Domain name
PART_ID Part ID for the Object CMS_RE_PRT_ID
PART_DESC Description of Building Part CMS_RE_DESC
COMM_USAGE_PCT Commercial Usage as a Percentage of Total Usage CMS_RE_PCT
REF_OBJ_PRT_GUID Reference Object Part GUID SYSUUID
NO_PRT_UNIT Number of building part units CMS_RE_UNITS
NO_PRT_UNIT_REN Number of building part units rented CMS_RE_UNITS
VACANT_POSN_PCT Ratio of Real Estate not rented to Total Real Estate Value CMS_RE_PCT
NO_OF_UNITS No of units in real estate object CMS_RE_UNITS
NO_OF_FLOORS Number of Floors CMS_RE_UNITS
NO_GARAGES No of Garages in Real Estate Object CMS_RE_UNITS
NO_GARAGES_REN No of Garages Rented in Real Estate Object CMS_RE_UNITS
NO_PARK_UNIT Number of Parking Units CMS_RE_UNITS
NO_PARK_UNIT_REN Number of Parking Units Rented CMS_RE_UNITS
NO_PARK_UG Number of Underground Parking Units CMS_RE_UNITS
NO_PARK_UG_REN Number of Rented Underground Parking Units CMS_RE_UNITS
NO_CUR_UNITS No of current units in real estate object CMS_RE_UNITS
NO_CUR_UNITS_REN No of Current Units Rented in Real Estate Object CMS_RE_UNITS
NO_OLD_UNITS No of old units in real estate object CMS_RE_UNITS
NO_OLD_UNITS_REN No of Old Units Rented in Real Estate Object CMS_RE_UNITS
NO_NEW_UNITS No of new units in real estate object CMS_RE_UNITS
NO_NEW_UNITS_REN No of New units Rented in Real Estate Object CMS_RE_UNITS
NO_ACCESS_STR No of Access Structures CMS_RE_UNITS
NO_SALE_LEVEL No of Sale levels in commercial building CMS_RE_UNITS
NO_OF_ROOMS No of rooms in the hotel/clinic CMS_RE_UNITS
NO_OF_BEDS No of beds in the clinic/nursing home CMS_RE_UNITS
COMM_ENV_DESC Description of the commercial environment CMS_RE_DESC
ACCESS_STR_DESC Description of the Access Structures CMS_RE_DESC
OCCUPANCY_PCT Occupancy specified in Percentage Terms CMS_RE_PCT
PCT_COMPLETED Degree of Completion of Construction CMS_RE_PCT
RTN_CST_PCT Percentage of Residential Rationing Cost CMS_RE_PCT
EXT_LAY_CST_PCT External Layout Cost as Percentage of Total Cost CMS_RE_PCT
RTN_CST_COM_PCT Percentage of Commercial Rationing Cost CMS_RE_PCT
CREATED_BY Real Estate Add-On User CMS_RE_USER
ENTRY_SRC Sorce of Initial entry CMS_RE_SOURCE
LAST_CHG_BY Last Changed By CMS_RE_USER
PROCESSING_SRC Processing Source CMS_RE_SOURCE
NO_OF_YEARS_COM No of years since Last Valuation of Commercial Real Estate CMS_RE_INT1
INT_RATE_COM Interest rate (Com) CMS_RE_PCT
NO_OF_YEARS No. of Years since Real Estate was last Valued CMS_RE_INT1
INT_RATE Interest rate used in Valuation of Residential Real Estate CMS_RE_PCT
DEPR Depriciation CMS_RE_PCT
Master Data Relations Join Conditions
Actual Rent Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.ACT_CURR_COM == TCURC.WAERS
Usage type Foreign key
Usage type Foreign key
Average Price Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.AVG_PRICE_CURR == TCURC.WAERS
Building method - Cellar
  • ?
  • Client
  • Building method - Cellar
Building method - Body
  • ?
  • Client
  • Building method - Body
Building method - Roof
  • ?
  • Client
  • Building method - Roof
Building Part Type
  • ?
  • Client
  • Building Part Type
Building Section
  • ?
  • Client
  • Building Section
Comparative Rent Currency (Commercial)
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.COMP_REN_COM_CUR == TCURC.WAERS
Comparative Rent Currency - Residential
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.COM_REN_RES_CURR == TCURC.WAERS
Gross Cold Rent Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.GROSS_RENT_CURR == TCURC.WAERS
Insurance Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.INSURANCE_CURR == TCURC.WAERS
Insurance Type
  • ?
  • Client
  • Insurance Type
Foreign key for Unit of measure
  • CMS_RE_OBJ_PRT.MANDT == T006.MANDT
  • CMS_RE_OBJ_PRT.LAND_AREA_UOM == T006.MSEHI
Usage type Foreign key
Net Cold Rent Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.NET_RENT_CURR == TCURC.WAERS
Foreign key for Object GUID CMS_RE_OBJ_PRT.MANDT == CMS_RE_OBJ.MANDT
Object condition
  • ?
  • Client
  • Object condition
Foreign key for Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.PLAN_CURR_COM == TCURC.WAERS
Foreign key for Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.PLAN_RENT_CURR == TCURC.WAERS
Price Category
  • ?
  • Client
  • Price Category
Rental Agreement Type
  • ?
  • Client
  • Rental Agreement Type
Actual Rent Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.RENT_ACT_CURR == TCURC.WAERS
Foreign key for Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.RENT_PLAN_CURR == TCURC.WAERS
Foreign key for Currency
  • CMS_RE_OBJ_PRT.MANDT == TCURC.MANDT
  • CMS_RE_OBJ_PRT.TURNOVER_CURR == TCURC.WAERS