SAP CMS_RE_OBJ_PRT Real Estate Object part details Table data and field list

CMS_RE_OBJ_PRT is a standard SAP Table which is used to store Real Estate Object part details data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_RE_OBJ_PRT table consists of various fields, each holding specific information or linking keys about Real Estate Object part details data available in SAP. These include OBJ_PRT_GUID (GUID for Object part), OBJ_GUID (GUID for Real Estate Object), PART_ID (Part ID for the Object), BLD_PART_TYPE (Building Part Type)... 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. .

CMS_RE_OBJ_PRT table Technical Details:

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_PRT table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_RE_OBJ_PRT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
OBJ_PRT_GUIDGUID for Object part CMS_RE_DTE_OBJ_PRT_GUIDRAW16SYSUUID
OBJ_GUIDGUID for Real Estate Object CMS_RE_DTE_OBJ_GUIDRAW16CMS_RE_OBJSYSUUIDCMS_RE_OBJ_GUID
PART_IDPart ID for the Object CMS_RE_DTE_PART_IDNUMC10CMS_RE_PRT_ID
BLD_PART_TYPEBuilding Part Type CMS_RE_DTE_ATT_ID_TY_REO006CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
PART_CONDObject condition CMS_RE_DTE_ATT_ID_TY_REO001CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
MAIN_USAGEUsage Type CMS_RE_DTE_USG_TYPCHAR6TCMS_RE_U_TYPCMS_RE_TYP
ADD_USAGE_1Additional Usage 1 CMS_RE_DTE_ADD1_USG_TYPCHAR6TCMS_RE_U_TYPCMS_RE_TYP
ADD_USAGE_2Additional Usage 2 CMS_RE_DTE_ADD2_USG_TYPCHAR6TCMS_RE_U_TYPCMS_RE_TYP
BLD_METHOD_ROOFBuilding method - Roof CMS_RE_DTE_ATT_ID_TY_REO007CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
BLD_METHOD_BODYBuilding method - Body CMS_RE_DTE_ATT_ID_TY_REO008CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
BLD_METD_CELLARBuilding method - Cellar CMS_RE_DTE_ATT_ID_TY_REO009CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
UTILIZATIONUtilization of the Object CMS_RE_DTE_PRT_UTILIZATIONCHAR6CMS_RE_UTIL
PART_DESCDescription of Building Part CMS_RE_DTE_SPC_DESCCHAR30CMS_RE_DESC
COMM_USAGE_PCTCommercial Usage as a Percentage of Total Usage CMS_RE_DTE_COM_USE_PCTDEC10(6) CMS_RE_PCT
OTHER_USG_FLGIndicates if Usages in addition to Main Usage are Possible CMS_RE_DTE_OTH_USE_FLGCHAR1ALPHACMS_RE_OTH_USG_FLG
REF_OBJ_PRT_GUIDReference Object Part GUID CMS_RE_DTE_REF_OBJ_PRT_GUIDRAW16SYSUUID
IS_SUB_AST_CREAIndicates whether a Sub-asset is created for Building Part CMS_RE_DTE_CREATE_SUB_AST_FLGCHAR1ALPHACMS_RE_FLG
USEFUL_AREAUsable Area CMS_RE_DTE_AREA_USEFULQUAN13(3) CMS_RE_SIZE
USBL_AREA_UOMUnit of Measure for Usable Area CMS_RE_DTE_USBL_AREA_UOMUNIT3Assigned to domainCUNITMEINSCMS_ELM_SURFACE_UOM
USEFUL_AREA_RENRented Usable Area CMS_RE_DTE_AREA_USEFUL_RENQUAN13(3) CMS_RE_SIZE
USBL_AR_REN_UOMUnit of Measure for Usable Rented Area CMS_RE_DTE_USBL_AREA_REN_UOMUNIT3Assigned to domainCUNITMEINSCMS_ELM_SURFACE_UOM
USEFUL_VOLUsable Volume of Real Estate Building Parts CMS_RE_DTE_VOL_USEFULQUAN13(3) CMS_RE_SIZE
USBL_VOL_UOMUnit of Measure for Usable Volume of Real Estate CMS_RE_DTE_USBL_VOL_UOMUNIT3Assigned to domainCUNITMEINSCMS_ELM_VOLUME_UOM
USEFUL_VOL_RENUsable Volume of the Rented Portions of Real Estate CMS_RE_DTE_VOL_USEFUL_RENQUAN13(3) CMS_RE_SIZE
USBL_VL_REN_UOMUnit of measure for usable volume of Rented Parts CMS_RE_DTE_USBL_VOL_REN_UOMUNIT3Assigned to domainCUNITMEINSCMS_ELM_VOLUME_UOM
RESIDENTIAL_AREAResidential Area CMS_RE_DTE_AREA_RESIDENTIALQUAN13(3) CMS_RE_SIZE
RES_AR_UOMUnit of Measure for Residential Area CMS_RE_DTE_RES_AREA_UOMUNIT3Assigned to domainCUNITMEINSCMS_ELM_SURFACE_UOM
SECONDARY_AREASecondary Area CMS_RE_DTE_AREA_SECONDARYQUAN13(3) CMS_RE_SIZE
SEC_AREA_UOMUnit of Measure for Secondary Area CMS_RE_DTE_SEC_AREA_UOMUNIT3Assigned to domainCUNITMEINSCMS_ELM_SURFACE_UOM
OTHER_AREAOther Area CMS_RE_DTE_AREA_OTHERQUAN13(3) CMS_RE_SIZE
OTH_AREA_UOMUnit of Measure for Other Area CMS_RE_DTE_OTH_AREA_UOMUNIT3Assigned to domainCUNITMEINSCMS_ELM_SURFACE_UOM
NO_PRT_UNITNumber of building part units CMS_RE_DTE_NO_PRT_UNITINT410CMS_RE_UNITS
NO_PRT_UNIT_RENNumber of building part units rented CMS_RE_DTE_NO_PRT_UNIT_RENINT410CMS_RE_UNITS
CONS_START_DATEStart Date of Construction CMS_RE_DTE_OBJ_CONS_ST_DATEDATS8CMS_RE_DATE
PERMSN_APPL_DATEBuilding Permssion applied date CMS_RE_DTE_OBJ_PMSN_APPL_DATEDATS8CMS_RE_DATE
PERMSN_OBTD_DATEBuilding Permssion obtained date CMS_RE_DTE_OBJ_PMSN_OBTD_DATEDATS8CMS_RE_DATE
OCCY_DATEOccupancy Date CMS_RE_DTE_OBJ_OCCY_DATEDATS8CMS_RE_DATE
COMP_DATECompletion Date CMS_RE_DTE_OBJ_COMP_DATEDATS8CMS_RE_DATE
FINAL_INSP_DATEDate of Final Inspection CMS_RE_DTE_OBJ_FINAL_INSP_DATEDATS8CMS_RE_DATE
RENT_AMT_PLANNEDPlanned Rent Amount CMS_RE_DTE_RENT_AMOUNTCURR17(2) CMS_RE_AMOUNT
RENT_AMT_ACTUALActual Rent Amount CMS_RE_DTE_RENT_AMOUNT_ACTCURR17(2) CMS_RE_AMOUNT
RENT_PLAN_CURRPlanned Rent Currency CMS_RE_DTE_RENT_PLANNED_CURRCUKY5TCURCWAERS
RENT_ACT_CURRActual Rent Currency CMS_RE_DTE_RENT_ACTUAL_CURRCUKY5TCURCWAERS
BASE_PERIODBase period for the rent CMS_RE_DTE_BASE_PERIODCHAR1CMS_RE_BASE_PERIOD
BASE_MEASUREBase Measure CMS_RE_DTE_BASE_MEASCHAR1CMS_RE_BASE_MEAS
VACANT_POSN_PCTRatio of Real Estate not rented to Total Real Estate Value CMS_RE_DTE_VACANT_POS_PCTDEC10(6) CMS_RE_PCT
RES_RENT_INDIndicator for Net or Gross Rent CMS_RE_DTE_RES_INDCHAR1CMS_RE_RENT_FLG
COMP_RENT_RESComparative Rent (Residential) CMS_RE_DTE_RENT_LEVELCURR17(2) CMS_RE_AMOUNT
COM_REN_RES_CURRComparative Rent Currency - Residential CMS_RE_DTE_COMP_RENT_RES_CURRCUKY5TCURCWAERS
LAND_AREALand Area of the Real Estate CMS_RE_DTE_LAND_AREAQUAN13(3) CMS_RE_SIZE
LAND_AREA_UOMUnit of Measure of Land Area CMS_RE_DTE_LAND_AREA_UOMUNIT3T006CUNITMEINSCMS_ELM_SURFACE_UOM
LAND_AREA_RENLand Area of the Real Estate which is Rented CMS_RE_DTE_LAND_AREA_RENQUAN13(3) CMS_RE_SIZE
LAND_AR_REN_UOMLand area unit of measure(rented) CMS_RE_DTE_LAND_AREA_REN_UOMUNIT3Assigned to domainCUNITMEINS
NO_OF_UNITSNo of units in real estate object CMS_RE_DTE_NO_UNITINT410CMS_RE_UNITS
NO_OF_FLOORSNumber of Floors CMS_RE_DTE_NO_FLOORINT410CMS_RE_UNITS
NO_GARAGESNo of Garages in Real Estate Object CMS_RE_DTE_NO_GARINT410CMS_RE_UNITS
NO_GARAGES_RENNo of Garages Rented in Real Estate Object CMS_RE_DTE_NO_GAR_RENINT410CMS_RE_UNITS
NO_PARK_UNITNumber of Parking Units CMS_RE_DTE_NO_PARK_UNITINT410CMS_RE_UNITS
NO_PARK_UNIT_RENNumber of Parking Units Rented CMS_RE_DTE_NO_PARK_UNIT_RENINT410CMS_RE_UNITS
NO_PARK_UGNumber of Underground Parking Units CMS_RE_DTE_NO_PARK_UNIT_UGINT410CMS_RE_UNITS
NO_PARK_UG_RENNumber of Rented Underground Parking Units CMS_RE_DTE_NO_PARK_UNIT_UG_RENINT410CMS_RE_UNITS
NO_CUR_UNITSNo of current units in real estate object CMS_RE_DTE_NO_CUR_UNITINT410CMS_RE_UNITS
NO_CUR_UNITS_RENNo of Current Units Rented in Real Estate Object CMS_RE_DTE_NO_CUR_UNIT_RENINT410CMS_RE_UNITS
NO_OLD_UNITSNo of old units in real estate object CMS_RE_DTE_NO_OLD_UNITINT410CMS_RE_UNITS
NO_OLD_UNITS_RENNo of Old Units Rented in Real Estate Object CMS_RE_DTE_NO_OLD_UNIT_RENINT410CMS_RE_UNITS
NO_NEW_UNITSNo of new units in real estate object CMS_RE_DTE_NO_NEW_UNITINT410CMS_RE_UNITS
NO_NEW_UNITS_RENNo of New units Rented in Real Estate Object CMS_RE_DTE_NO_NEW_UNIT_RENINT410CMS_RE_UNITS
NO_ACCESS_STRNo of Access Structures CMS_RE_DTE_NO_ACCESS_STRINT410CMS_RE_UNITS
NO_SALE_LEVELNo of Sale levels in commercial building CMS_RE_DTE_NO_SALE_LEVELINT410CMS_RE_UNITS
NO_OF_ROOMSNo of rooms in the hotel/clinic CMS_RE_DTE_NO_ROOMSINT410CMS_RE_UNITS
NO_OF_BEDSNo of beds in the clinic/nursing home CMS_RE_DTE_NO_BEDSINT410CMS_RE_UNITS
COMM_ENV_DESCDescription of the commercial environment CMS_RE_DTE_COMM_ENV_DESCCHAR30CMS_RE_DESC
ACCESS_STR_DESCDescription of the Access Structures CMS_RE_DTE_ACCESS_STR_DESCCHAR30CMS_RE_DESC
BLD_SECTION_DESCBuilding Section CMS_RE_DTE_ATT_ID_TY_REO015CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
PRICE_CATEGORYPrice Category CMS_RE_DTE_ATT_ID_TY_REO013CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
AVG_PRICEAverage Price per Day CMS_RE_DTE_AVG_PRICECURR17(2) CMS_RE_AMOUNT
AVG_PRICE_CURRAverage Price Currency CMS_RE_DTE_AVG_PRICE_CURRCUKY5TCURCWAERS
OCCUPANCY_PCTOccupancy specified in Percentage Terms CMS_RE_DTE_OCCY_PCTDEC10(6) CMS_RE_PCT
TURNOVER_AMTTotal Amount of Turnover CMS_RE_DTE_TURNOVER_AMOUNTCURR17(2) CMS_RE_AMOUNT
TURNOVER_CURRCurrency CMS_RE_DTE_TURNOVER_CURRCUKY5TCURCWAERS
RENTAL_AGMT_TYPRental Agreement Type CMS_RE_DTE_ATT_ID_TY_REO014CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
LAST_REPORT_DATEDate of Last Constuction Report CMS_RE_DTE_LAST_CONST_REP_DATEDATS8CMS_RE_DATE
BLD_PROGRESS_AMTAmount Disbursed for Construction based on Building Progress CMS_RE_DTE_AMT_BLD_PROGRESSCURR17(2) CMS_RE_AMOUNT
BLD_AMT_CURRBuilding Progress Amount Curreny CMS_RE_DTE_BLD_PROGRESS_CURRCUKY5Assigned to domainWAERS
PCT_COMPLETEDDegree of Completion of Construction CMS_RE_DTE_DEGREE_COMPLETEDEC10(6) CMS_RE_PCT
INSURANCE_TYPEInsurance Type CMS_RE_DTE_ATT_ID_TY_REO011CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
INSURANCE_AMTInsurance Amount CMS_RE_DTE_INSURANCE_AMOUNTCURR17(2) CMS_RE_AMOUNT
INSURANCE_CURRInsurance Currency CMS_RE_DTE_INSURANCE_CURRCUKY5TCURCWAERS
INS_VALIDITYDate until which the Insurance Stands Valid CMS_RE_DTE_INS_VALID_TILLDATS8CMS_RE_DATE
RATIONING_COSTResidential Rationing Cost CMS_RE_DTE_RAT_COST_AMTCURR17(2) CMS_RE_AMOUNT
RTN_CST_PCTPercentage of Residential Rationing Cost CMS_RE_DTE_RAN_COST_PCTDEC10(6) CMS_RE_PCT
EXT_LAYOUT_COSTExternal Layout Cost CMS_RE_DTE_EXT_LAYOUT_COSTCURR17(2) CMS_RE_AMOUNT
EXT_LAY_CST_PCTExternal Layout Cost as Percentage of Total Cost CMS_RE_DTE_EXT_LAYOUT_COST_PCTDEC10(6) CMS_RE_PCT
RTN_CST_CURRRationing cost currency CMS_RE_DTE_RTN_CST_CURRCUKY5Assigned to domainWAERS
EXT_RTN_CST_CURRExternal Layout cost currency CMS_RE_DTE_EXT_LAYOUT_CST_CURRCUKY5Assigned to domainWAERS
RTN_CST_COMCommercial Rationing Cost CMS_RE_DTE_RAT_COST_AMT_COMCURR17(2) CMS_RE_AMOUNT
RTN_CST_COM_CURRRationing cost currency CMS_RE_DTE_RTN_CST_CURR_COMCUKY5Assigned to domainWAERS
RTN_CST_COM_PCTPercentage of Commercial Rationing Cost CMS_RE_DTE_RAN_COST_PCT_COMDEC10(6) CMS_RE_PCT
GROSS_COLD_RENTGross Cold Rent CMS_RE_DTE_YRLY_GROSS_COLD_RENCURR17(2) CMS_RE_AMOUNT
GROSS_RENT_CURRGross Cold Rent Currency CMS_RE_DTE_GROSS_RENT_CURRCUKY5TCURCWAERS
NET_COLD_RENTNet Cold Rent CMS_RE_DTE_YRLY_NET_COLD_RENCURR17(2) CMS_RE_AMOUNT
NET_RENT_CURRNet Cold Rent Currency CMS_RE_DTE_NET_RENT_CURRCUKY5TCURCWAERS
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
NO_OF_YEARS_COMNo of years since Last Valuation of Commercial Real Estate CMS_RE_DTE_VAL_NO_YEARS_COMINT13CMS_RE_INT1
INT_RATE_COMInterest rate (Com) CMS_RE_DTE_VAL_INT_RATE_COMDEC10(6) CMS_RE_PCT
NO_OF_YEARSNo. of Years since Real Estate was last Valued CMS_RE_DTE_VALUATION_NO_YEARSINT13CMS_RE_INT1
INT_RATEInterest rate used in Valuation of Residential Real Estate CMS_RE_DTE_VALUATION_INT_RATEDEC10(6) CMS_RE_PCT
RENT_PLANNED_COMPlanned Rent Amount CMS_RE_DTE_RENT_AMOUNTCURR17(2) CMS_RE_AMOUNT
RENT_ACTUAL_COMActual Rent Amount CMS_RE_DTE_RENT_AMOUNT_ACTCURR17(2) CMS_RE_AMOUNT
PLAN_CURR_COMPlanned Rent Currency CMS_RE_DTE_RENT_PLANNED_CURRCUKY5TCURCWAERS
ACT_CURR_COMActual Rent Currency CMS_RE_DTE_RENT_ACTUAL_CURRCUKY5TCURCWAERS
BASE_PERIOD_COMBase period for the rent CMS_RE_DTE_BASE_PERIODCHAR1CMS_RE_BASE_PERIOD
BASE_MEAS_COMBase Measure CMS_RE_DTE_BASE_MEASCHAR1CMS_RE_BASE_MEAS
COM_RENT_INDIndicator for Rent Type CMS_RE_DTE_COM_INDCHAR1CMS_RE_RENT_FLG
COMP_RENT_COMComparative Rent (Commercial) CMS_RE_DTE_RENT_LEVEL_COMCURR17(2) CMS_RE_AMOUNT
COMP_REN_COM_CURComparative Rent Currency (Commercial) CMS_RE_DTE_COMP_RENT_COM_CURRCUKY5TCURCWAERS
PLAN_RENT_LANDPlanned Rent Amount CMS_RE_DTE_RENT_AMOUNTCURR17(2) CMS_RE_AMOUNT
ACTUAL_RENT_LANDActual Rent Amount CMS_RE_DTE_RENT_AMOUNT_ACTCURR17(2) CMS_RE_AMOUNT
PLAN_RENT_CURRPlanned Rent Currency CMS_RE_DTE_RENT_PLANNED_CURRCUKY5TCURCWAERS
ACTUAL_RENT_CURRActual Rent Currency CMS_RE_DTE_RENT_ACTUAL_CURRCUKY5Assigned to domainWAERS
BASE_PERIOD_LANDBase period for the rent CMS_RE_DTE_BASE_PERIODCHAR1CMS_RE_BASE_PERIOD
BASE_MEAS_LANDBase Measure CMS_RE_DTE_BASE_MEASCHAR1CMS_RE_BASE_MEAS
DEPRDepriciation CMS_RE_DTE_DEPRDEC10(6) CMS_RE_PCT
LAND_COSTLand Cost Amount CMS_RE_DTE_LAND_COSTCURR17(2) CMS_RE_AMOUNT
LAND_COST_CURRLand Cost Currency CMS_RE_DTE_LAND_COST_CURRCUKY5Assigned to domainWAERS
DEV_COSTDevelopment Cost Amount CMS_RE_DTE_DEV_COSTCURR17(2) CMS_RE_AMOUNT
DEV_COST_CURRDev Cost Currency CMS_RE_DTE_DEV_COST_CURRCUKY5Assigned to domainWAERS
LAND_CST_BASEBase measure of Land CMS_RE_DTE_BASE_MEAS_LANDCHAR1CMS_RE_BASE_MEAS_LAND
DEV_CST_BASEBase measure of Land CMS_RE_DTE_BASE_MEAS_LANDCHAR1CMS_RE_BASE_MEAS_LAND
ADD_LAND_CSTAdditional Land Cost Amount CMS_RE_DTE_ADD_LAND_COSTCURR17(2) CMS_RE_AMOUNT
ADD_CST_CURRAdditional Land Cost Currency CMS_RE_DTE_ADD_LAND_COST_CURRCUKY5Assigned to domainWAERS
ADD_CST_BASEBase measure of Land CMS_RE_DTE_BASE_MEAS_LANDCHAR1CMS_RE_BASE_MEAS_LAND
CONST_COSTConstruction Cost CMS_RE_DTE_CONS_COSTCURR17(2) CMS_RE_AMOUNT
CONST_COST_CURRConstruction cost currency CMS_RE_DTE_CONS_COST_CURRCUKY5Assigned to domainWAERS
BASE_MEASBase Measure CMS_RE_DTE_BASE_MEASCHAR1CMS_RE_BASE_MEAS
GRS_PROFITYearly Gross Profit CMS_RE_DTE_GRS_PROFITCURR17(2) CMS_RE_AMOUNT
GRS_PROFIT_CURRYearly Gross Profit Currency CMS_RE_DTE_GRS_PROFIT_CURRCUKY5Assigned to domainWAERS

Key field Non-key field



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

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

SELECT SINGLE *
FROM CMS_RE_OBJ_PRT
INTO CORRESPONDING FIELDS OF WA_CMS_RE_OBJ_PRT
WHERE...

How to access SAP table CMS_RE_OBJ_PRT

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

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