SAP ABAP Table CMS_RE_STR_OBJ (Strcuture for details of 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	INTTAB	Structure
Structure	CMS_RE_STR_OBJ	Table Relationship Diagram
Short Description	Strcuture for details of Object

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Structure for Object GUID
2	OBJ_GUID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object
3	.INCLUDE	☐				0	0	Structure for Semantic key for Objects in RE Add-On
4	OBJECT_ID	☐	CMS_RE_DTE_OBJECT_ID	CMS_RE_OBJECT_ID	CHAR	20	0	Object ID
5	.INCLUDE	☐				0	0	Structure for basic details for Objects in RE Add-On
6	.INCLUDE	☐				0	0	Strcuture for data for Object Description
7	OBJECT_TYPE	☐	CMS_RE_DTE_OBJ_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Object Type ID	TCMS_RE_TYP
8	ADDR_ID	☐	CMS_RE_DTE_ADDR_ID	AD_ADDRNUM	CHAR	10	0	Address ID	*
9	OBJECT_COND	☐	CMS_RE_DTE_OBJ_COND	CMS_RE_COND	CHAR	6	0	Condition ID	TCMS_RE_COND
10	OBJECT_DESC	☐	CMS_RE_DTE_OBJ_DESC	CMS_RE_DESC	CHAR	30	0	Description of the Real Estate Object
11	OBJECT_PARENT_ID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object
12	OBJECT_EXT_REFNO	☐	CMS_RE_DTE_OBJ_REF_NO	CMS_RE_REFID	CHAR	32	0	External reference Number of an External System
13	USAGE_TYPE	☐	CMS_RE_DTE_USG_TYP	CMS_RE_TYP	CHAR	6	0	Usage Type	TCMS_RE_U_TYP
14	BLD_STR_TYPE	☐	CMS_RE_DTE_BLD_STR_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Building Structure ID	TCMS_RE_STR
15	FIX_FITTING_TYPE	☐	CMS_RE_DTE_FIX_FIT_TYP	CMS_RE_FIX_FIT_TYP	CHAR	6	0	Fixtures and Fittings Type ID	TCMS_RE_FX_FIT
16	.INCLUDE	☐				0	0	Structure for Object value
17	OBJECT_VAL	☐	CMS_RE_DTE_OBJ_VAL	CMS_RE_AMOUNT	CURR	17	2	Real Estate Value
18	OBJECT_VAL_CURR	☐	CMS_RE_DTE_OBJ_VAL_CURR	WAERS	CUKY	5	0	Currency for the Object Value	TCURC
19	OBJECT_VAL_DATE	☐	CMS_RE_DTE_OBJ_VAL_DATE	CMS_RE_DATE	DATS	8	0	Object Value Calculation Date
20	.INCLUDE	☐				0	0	Structure for Size details
21	AREA	☐	CMS_RE_DTE_AREA	CMS_RE_SIZE	QUAN	13	3	Total Area of the Real Estate Object
22	AREA_UOM	☐	CMS_RE_DTE_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Area	*
23	VOLUME	☐	CMS_RE_DTE_VOL	CMS_RE_SIZE	QUAN	13	3	Volume of Real Estate Object
24	VOLUME_UOM	☐	CMS_RE_DTE_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Volume of Real Estate	*
25	.INCLUDE	☐				0	0	Structure for Area of collateral value
26	AREA_VALUE	☐	CMS_RE_DTE_AREA_VAL	CMS_RE_SIZE	QUAN	13	3	Area in the Real Estate which has Collateral Value
27	AREA_VALUE_UOM	☐	CMS_RE_DTE_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Area	*
28	VOLUME_VAL	☐	CMS_RE_DTE_VOLUME_VAL	CMS_RE_SIZE	QUAN	13	3	Volume of Real Estate which has Collateral Value
29	VOLUME_VALUE_UOM	☐	CMS_RE_DTE_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Volume of Real Estate	*
30	.INCLUDE	☐				0	0	Structure for Location description details
31	MACRO_LOC_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO002	CMS_ATT_ID_TYP	CHAR	6	0	Macro Location	TCMS_ATT_ID_TY
32	MICRO_LOC_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO003	CMS_ATT_ID_TYP	CHAR	6	0	Micro Location	TCMS_ATT_ID_TY
33	TRAN_CONN_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO004	CMS_ATT_ID_TYP	CHAR	6	0	Transport Connection	TCMS_ATT_ID_TY
34	ENVIRON_STATUS	☐	CMS_RE_DTE_ATT_ID_TY_REO005	CMS_ATT_ID_TYP	CHAR	6	0	Enviromental Status	TCMS_ATT_ID_TY
35	FLOOD_ZONE_FLG	☐	CMS_RE_DTE_FLOOD_ZONE	CMS_RE_FLG	CHAR	1	0	Indicator for Flood Zone
36	EARTHQUAKE_FLG	☐	CMS_RE_DTE_EARTHQUAKE	CMS_RE_FLG	CHAR	1	0	Indicator : Eathquake Zone
37	ARCT_CONV_FLG	☐	CMS_RE_DTE_ARCT_CONV	CMS_RE_FLG	CHAR	1	0	Indicator for Architectural Conservation Area
38	HIST_SITE_FLG	☐	CMS_RE_DTE_HIST_SITE	CMS_RE_FLG	CHAR	1	0	Indicator for Historical Site
39	IS_VAL_IMP_FACS	☐	CMS_RE_DTE_VAL_IMP_FLG	CMS_RE_FLG	CHAR	1	0	Indicates existence of Factors Impairing Real Estate Value
40	VALUE_IMP_DESC	☐	CMS_RE_DTE_VAL_IMP_DESC	CMS_RE_DESC	CHAR	30	0	Description of the value imparing factor
41	.INCLUDE	☐				0	0
42	.INCLUDE	☐				0	0	Structure for Building summary details
43	NO_UNITS	☐	CMS_RE_DTE_NO_UNIT	CMS_RE_UNITS	INT4	10	0	No of units in real estate object
44	NO_FLOORS	☐	CMS_RE_DTE_NO_FLOOR	CMS_RE_UNITS	INT4	10	0	Number of Floors
45	NO_CUR_UNITS	☐	CMS_RE_DTE_NO_CUR_UNIT	CMS_RE_UNITS	INT4	10	0	No of current units in real estate object
46	NO_CUR_UNITS_REN	☐	CMS_RE_DTE_NO_CUR_UNIT_REN	CMS_RE_UNITS	INT4	10	0	No of Current Units Rented in Real Estate Object
47	NO_OLD_UNITS	☐	CMS_RE_DTE_NO_OLD_UNIT	CMS_RE_UNITS	INT4	10	0	No of old units in real estate object
48	NO_OLD_UNITS_REN	☐	CMS_RE_DTE_NO_OLD_UNIT_REN	CMS_RE_UNITS	INT4	10	0	No of Old Units Rented in Real Estate Object
49	NO_NEW_UNITS	☐	CMS_RE_DTE_NO_NEW_UNIT	CMS_RE_UNITS	INT4	10	0	No of new units in real estate object
50	NO_NEW_UNITS_REN	☐	CMS_RE_DTE_NO_NEW_UNIT_REN	CMS_RE_UNITS	INT4	10	0	No of New units Rented in Real Estate Object
51	NO_GARAGES	☐	CMS_RE_DTE_NO_GAR	CMS_RE_UNITS	INT4	10	0	No of Garages in Real Estate Object
52	NO_GARAGES_REN	☐	CMS_RE_DTE_NO_GAR_REN	CMS_RE_UNITS	INT4	10	0	No of Garages Rented in Real Estate Object
53	NO_PARK_UNIT	☐	CMS_RE_DTE_NO_PARK_UNIT	CMS_RE_UNITS	INT4	10	0	Number of Parking Units
54	NO_PARK_UNIT_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_REN	CMS_RE_UNITS	INT4	10	0	Number of Parking Units Rented
55	NO_PARK_UG	☐	CMS_RE_DTE_NO_PARK_UNIT_UG	CMS_RE_UNITS	INT4	10	0	Number of Underground Parking Units
56	NO_PARK_UG_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_UG_REN	CMS_RE_UNITS	INT4	10	0	Number of Rented Underground Parking Units
57	.INCLUDE	☐				0	0
58	.INCLUDE	☐				0	0	Structure for Purcahse details
59	OBJECT_PUR_PRICE	☐	CMS_RE_DTE_OBJ_PRC	CMS_RE_AMOUNT	CURR	17	2	Buying Price for the Real estate object
60	OBJECT_PUR_CURR	☐	CMS_RE_DTE_OBJ_PRC_CURR	WAERS	CUKY	5	0	Buying Price Currency for the Real estate object	TCURC
61	OBJECT_PUR_DATE	☐	CMS_RE_DTE_OBJ_PRC_DATE	CMS_RE_DATE	DATS	8	0	Purchasing Date for the Real estate object
62	.INCLUDE	☐				0	0
63	.INCLUDE	☐				0	0	Structure for dates
64	CONS_START_DATE	☐	CMS_RE_DTE_OBJ_CONS_ST_DATE	CMS_RE_DATE	DATS	8	0	Start Date of Construction
65	PERMSN_APPL_DATE	☐	CMS_RE_DTE_OBJ_PMSN_APPL_DATE	CMS_RE_DATE	DATS	8	0	Building Permssion applied date
66	PERMSN_OBTD_DATE	☐	CMS_RE_DTE_OBJ_PMSN_OBTD_DATE	CMS_RE_DATE	DATS	8	0	Building Permssion obtained date
67	OCCY_DATE	☐	CMS_RE_DTE_OBJ_OCCY_DATE	CMS_RE_DATE	DATS	8	0	Occupancy Date
68	COMP_DATE	☐	CMS_RE_DTE_OBJ_COMP_DATE	CMS_RE_DATE	DATS	8	0	Completion Date
69	FINAL_INSP_DATE	☐	CMS_RE_DTE_OBJ_FINAL_INSP_DATE	CMS_RE_DATE	DATS	8	0	Date of Final Inspection
70	.INCLUDE	☐				0	0
71	.INCLUDE	☐				0	0	Structure for history
72	CREATED_BY	☐	CMS_RE_DTE_CR_BY	CMS_RE_USER	CHAR	12	0	Real Estate Add-On User
73	CREATED_DATE	☐	CMS_RE_DTE_CR_ON	CMS_RE_DATE	DATS	8	0	Created On
74	CREATED_TIME	☐	CMS_RE_DTE_CR_AT	CMS_RE_TIME	TIMS	6	0	Created At
75	ENTRY_SRC	☐	CMS_RE_DTE_SRC_INIT	CMS_RE_SOURCE	CHAR	32	0	Sorce of Initial entry
76	LAST_CHG_BY	☐	CMS_RE_DTE_CHG_BY	CMS_RE_USER	CHAR	12	0	Last Changed By
77	LAST_CHG_DATE	☐	CMS_RE_DTE_CHG_ON	CMS_RE_DATE	DATS	8	0	Last Changed On
78	LAST_CHG_TIME	☐	CMS_RE_DTE_CHG_AT	CMS_RE_TIME	TIMS	6	0	Last Changed At
79	PROCESSING_SRC	☐	CMS_RE_DTE_PRC_SRC	CMS_RE_SOURCE	CHAR	32	0	Processing Source
80	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_RE_STR_OBJ	BLD_STR_TYPE	TCMS_RE_STR	BLD_STR_TYPE	REF	1	CN
2	CMS_RE_STR_OBJ	ENVIRON_STATUS	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
3	CMS_RE_STR_OBJ	FIX_FITTING_TYPE	TCMS_RE_FX_FIT	FIX_FITTING_TYPE	REF	1	CN
4	CMS_RE_STR_OBJ	MACRO_LOC_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
5	CMS_RE_STR_OBJ	MICRO_LOC_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
6	CMS_RE_STR_OBJ	OBJECT_COND	TCMS_RE_COND	OBJECT_COND	REF	1	CN
7	CMS_RE_STR_OBJ	OBJECT_PUR_CURR	TCURC	WAERS	REF	1	CN
8	CMS_RE_STR_OBJ	OBJECT_VAL_CURR	TCURC	WAERS	REF	1	CN
9	CMS_RE_STR_OBJ	TRAN_CONN_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
10	CMS_RE_STR_OBJ	USAGE_TYPE	TCMS_RE_U_TYP	USAGE_TYPE	REF	1	CN

History

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