SAP CMS_RE_STR_OBJ_SPC Strcuture for details of Space in a real estate object Table data and field list

CMS_RE_STR_OBJ_SPC is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Strcuture for details of Space in a real estate object" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMS_RE_STR_OBJ_SPC TYPE CMS_RE_STR_OBJ_SPC.

The CMS_RE_STR_OBJ_SPC table consists of various fields, each holding specific information or linking keys about Strcuture for details of Space in 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_STR_OBJ_SPC structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CMS_RE_STR_OBJ_SPC structure 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_STR_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
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 structure CMS_RE_STR_OBJ_SPC using ABAP code?

As CMS_RE_STR_OBJ_SPC is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMS_RE_STR_OBJ_SPC as there is no data to select.

How to access SAP table CMS_RE_STR_OBJ_SPC

Within an ECC or HANA version of SAP you can also view further information about CMS_RE_STR_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).