SAP CMS_RE_OBJ_SPC Space Details to describe a real estate object Table data and field list

CMS_RE_OBJ_SPC is a standard SAP Table which is used to store Space Details to describe a real estate object data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_RE_OBJ_SPC table consists of various fields, each holding specific information or linking keys about Space Details to describe a real estate object data available in SAP. These include SPC_GUID (GUID for Spaces in Real Estate), OBJ_GUID (GUID for Real Estate Object), SPACE_TYPE (Building Part Type ID), SPACE_COND (Condition ID)... 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_SPC 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: Not classified


SAP CMS_RE_OBJ_SPC 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_SPC 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 MANDTCLNT3T000MANDT
SPC_GUIDGUID for Spaces in Real Estate CMS_RE_DTE_SPC_GUIDRAW16SYSUUID
OBJ_GUIDGUID for Real Estate Object CMS_RE_DTE_OBJ_GUIDRAW16CMS_RE_OBJSYSUUIDCMS_RE_OBJ_GUID
SPACE_TYPEBuilding Part Type ID CMS_RE_DTE_SPC_TYPCHAR6TCMS_RE_SP_TYPCMS_RE_TYP
SPACE_CONDCondition ID CMS_RE_DTE_OBJ_CONDCHAR6TCMS_RE_CONDCMS_RE_COND
USAGE_TYPEUsage Type CMS_RE_DTE_USG_TYPCHAR6TCMS_RE_U_TYPCMS_RE_TYP
BLD_STR_TYPEReal Estate Building Structure ID CMS_RE_DTE_BLD_STR_TYPCHAR6TCMS_RE_STRCMS_RE_TYP
SPACE_DESCDescription of Building Part CMS_RE_DTE_SPC_DESCCHAR30CMS_RE_DESC
NO_UNITSNo of units in real estate object CMS_RE_DTE_NO_UNITINT410CMS_RE_UNITS
NO_PARK_UNITSNumber of Parking Units CMS_RE_DTE_NO_PARK_UNITINT410CMS_RE_UNITS
NO_GARAGESNo of Garages in Real Estate Object CMS_RE_DTE_NO_GARINT410CMS_RE_UNITS
AREATotal Area of the Real Estate Object CMS_RE_DTE_AREAQUAN13(3) CMS_RE_SIZE
AREA_UOMUnit of Measure for Area CMS_RE_DTE_AREA_UOMUNIT3Assigned to domainCUNITMEINSCMS_AREA_UOMCMS_ELM_SURFACE_UOM
VOLUMEVolume of Real Estate Object CMS_RE_DTE_VOLQUAN13(3) CMS_RE_SIZE
VOLUME_UOMUnit of Measure for Volume of Real Estate CMS_RE_DTE_VOL_UOMUNIT3Assigned to domainCUNITMEINSCMS_VOL_UOMCMS_ELM_VOLUME_UOM
AREA_VALUEArea in the Real Estate which has Collateral Value CMS_RE_DTE_AREA_VALQUAN13(3) CMS_RE_SIZE
AREA_VALUE_UOMUnit of Measure for Area CMS_RE_DTE_AREA_UOMUNIT3Assigned to domainCUNITMEINSCMS_AREA_UOMCMS_ELM_SURFACE_UOM
VOLUME_VALVolume of Real Estate which has Collateral Value CMS_RE_DTE_VOLUME_VALQUAN13(3) CMS_RE_SIZE
VOLUME_VALUE_UOMUnit of Measure for Volume of Real Estate CMS_RE_DTE_VOL_UOMUNIT3Assigned to domainCUNITMEINSCMS_VOL_UOMCMS_ELM_VOLUME_UOM
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

Key field Non-key field



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

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

SELECT SINGLE *
FROM CMS_RE_OBJ_SPC
INTO CORRESPONDING FIELDS OF WA_CMS_RE_OBJ_SPC
WHERE...

How to access SAP table CMS_RE_OBJ_SPC

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

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