CMS_RE_OBJ_SPC SAP table for – Space Details to describe a real estate object

Here we would like to draw your attention to CMS_RE_OBJ_SPC table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_RE_OBJ_SPC is a SAP standard transp table used for storing Space Details to describe a real estate object related data in SAP. It comes under the package CMS_RE.

SAP CMS_RE_OBJ_SPC table

Table CMS_RE_OBJ_SPC technical data

TableCMS_RE_OBJ_SPC
Data storingSpace Details to describe a real estate object
ModuleFS
Sub ModuleFS-CMS-MD-RE
SAP PackageCMS_RE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_RE_OBJ_SPC Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_RE_OBJ_SPC table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Structure for Space GUID
    Its a key field.
  • SPC_GUID : GUID for Spaces in Real Estate
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link structure for the real estate object
  • OBJ_GUID : GUID for Real Estate Object
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Structure for Space details
  • .INCLUDE : Strcuture for basic details of a space
  • SPACE_TYPE : Building Part Type ID
    Its data type is CHAR (Character String) with field length 6
  • SPACE_COND : Condition ID
    Its data type is CHAR (Character String) with field length 6
  • USAGE_TYPE : Usage Type
    Its data type is CHAR (Character String) with field length 6
  • BLD_STR_TYPE : Real Estate Building Structure ID
    Its data type is CHAR (Character String) with field length 6
  • SPACE_DESC : Description of Building Part
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Structure for Space building summary details
  • NO_UNITS : No of units in real estate object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_PARK_UNITS : Number of Parking Units
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • NO_GARAGES : No of Garages in Real Estate Object
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Structure for Size details
  • AREA : Total Area of the Real Estate Object
    Its data type is QUAN (Quantity field) with field length 13
  • AREA_UOM : Unit of Measure for Area
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • VOLUME : Volume of Real Estate Object
    Its data type is QUAN (Quantity field) with field length 13
  • VOLUME_UOM : Unit of Measure for Volume of Real Estate
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Structure for Area of collateral value
  • AREA_VALUE : Area in the Real Estate which has Collateral Value
    Its data type is QUAN (Quantity field) with field length 13
  • AREA_VALUE_UOM : Unit of Measure for Area
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • VOLUME_VAL : Volume of Real Estate which has Collateral Value
    Its data type is QUAN (Quantity field) with field length 13
  • VOLUME_VALUE_UOM : Unit of Measure for Volume of Real Estate
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Structure for history
  • CREATED_BY : Real Estate Add-On User
    Its data type is CHAR (Character String) with field length 12
  • CREATED_DATE : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATED_TIME : Created At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ENTRY_SRC : Sorce of Initial entry
    Its data type is CHAR (Character String) with field length 32
  • LAST_CHG_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • LAST_CHG_DATE : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAST_CHG_TIME : Last Changed At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PROCESSING_SRC : Processing Source
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes