SAP ABAP Table CMS_RE_OBJ_SPC (Space Details to describe a real estate object)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-RE (Application Component) Real Estate
     ⤷ CMS_RE (Package) Collateral Management System: Real Esate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMS_RE_OBJ_SPC	Table Relationship Diagram
Short Description	Space Details to describe a real estate object

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Structure for Space GUID
3	SPC_GUID	☑	CMS_RE_DTE_SPC_GUID	SYSUUID	RAW	16	0	GUID for Spaces in Real Estate
4	.INCLUDE	☐				0	0	Link structure for the real estate object
5	OBJ_GUID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object	CMS_RE_OBJ
6	.INCLUDE	☐				0	0	Structure for Space details
7	.INCLUDE	☐				0	0	Strcuture for basic details of a space
8	SPACE_TYPE	☐	CMS_RE_DTE_SPC_TYP	CMS_RE_TYP	CHAR	6	0	Building Part Type ID	TCMS_RE_SP_TYP
9	SPACE_COND	☐	CMS_RE_DTE_OBJ_COND	CMS_RE_COND	CHAR	6	0	Condition ID	TCMS_RE_COND
10	USAGE_TYPE	☐	CMS_RE_DTE_USG_TYP	CMS_RE_TYP	CHAR	6	0	Usage Type	TCMS_RE_U_TYP
11	BLD_STR_TYPE	☐	CMS_RE_DTE_BLD_STR_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Building Structure ID	TCMS_RE_STR
12	SPACE_DESC	☐	CMS_RE_DTE_SPC_DESC	CMS_RE_DESC	CHAR	30	0	Description of Building Part
13	.INCLUDE	☐				0	0	Structure for Space building summary details
14	NO_UNITS	☐	CMS_RE_DTE_NO_UNIT	CMS_RE_UNITS	INT4	10	0	No of units in real estate object
15	NO_PARK_UNITS	☐	CMS_RE_DTE_NO_PARK_UNIT	CMS_RE_UNITS	INT4	10	0	Number of Parking Units
16	NO_GARAGES	☐	CMS_RE_DTE_NO_GAR	CMS_RE_UNITS	INT4	10	0	No of Garages in Real Estate Object
17	.INCLUDE	☐				0	0
18	.INCLUDE	☐				0	0	Structure for Size details
19	AREA	☐	CMS_RE_DTE_AREA	CMS_RE_SIZE	QUAN	13	3	Total Area of the Real Estate Object
20	AREA_UOM	☐	CMS_RE_DTE_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Area	*
21	VOLUME	☐	CMS_RE_DTE_VOL	CMS_RE_SIZE	QUAN	13	3	Volume of Real Estate Object
22	VOLUME_UOM	☐	CMS_RE_DTE_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Volume of Real Estate	*
23	.INCLUDE	☐				0	0	Structure for Area of collateral value
24	AREA_VALUE	☐	CMS_RE_DTE_AREA_VAL	CMS_RE_SIZE	QUAN	13	3	Area in the Real Estate which has Collateral Value
25	AREA_VALUE_UOM	☐	CMS_RE_DTE_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Area	*
26	VOLUME_VAL	☐	CMS_RE_DTE_VOLUME_VAL	CMS_RE_SIZE	QUAN	13	3	Volume of Real Estate which has Collateral Value
27	VOLUME_VALUE_UOM	☐	CMS_RE_DTE_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Volume of Real Estate	*
28	.INCLUDE	☐				0	0
29	.INCLUDE	☐				0	0	Structure for history
30	CREATED_BY	☐	CMS_RE_DTE_CR_BY	CMS_RE_USER	CHAR	12	0	Real Estate Add-On User
31	CREATED_DATE	☐	CMS_RE_DTE_CR_ON	CMS_RE_DATE	DATS	8	0	Created On
32	CREATED_TIME	☐	CMS_RE_DTE_CR_AT	CMS_RE_TIME	TIMS	6	0	Created At
33	ENTRY_SRC	☐	CMS_RE_DTE_SRC_INIT	CMS_RE_SOURCE	CHAR	32	0	Sorce of Initial entry
34	LAST_CHG_BY	☐	CMS_RE_DTE_CHG_BY	CMS_RE_USER	CHAR	12	0	Last Changed By
35	LAST_CHG_DATE	☐	CMS_RE_DTE_CHG_ON	CMS_RE_DATE	DATS	8	0	Last Changed On
36	LAST_CHG_TIME	☐	CMS_RE_DTE_CHG_AT	CMS_RE_TIME	TIMS	6	0	Last Changed At
37	PROCESSING_SRC	☐	CMS_RE_DTE_PRC_SRC	CMS_RE_SOURCE	CHAR	32	0	Processing Source
38	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_RE_OBJ_SPC	BLD_STR_TYPE	TCMS_RE_STR	BLD_STR_TYPE	REF	1	CN
2	CMS_RE_OBJ_SPC	MANDT	T000	MANDT	KEY	1	CN
3	CMS_RE_OBJ_SPC	SPACE_COND	TCMS_RE_COND	OBJECT_COND	REF	1	CN
4	CMS_RE_OBJ_SPC	SPACE_TYPE	TCMS_RE_SP_TYP	SPACE_TYPE	REF	1	CN
5	CMS_RE_OBJ_SPC	USAGE_TYPE	TCMS_RE_U_TYP	USAGE_TYPE	REF	1	CN

History

Last changed by/on	SAP	20030514
SAP Release Created in	110