SAP ABAP Table CMS_RE_STR_BASIC_DETAILS (Structure for basic details for Objects in RE Add-On)

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_BASIC_DETAILS	Table Relationship Diagram
Short Description	Structure for basic details for Objects in RE Add-On

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	Strcuture for data for Object Description
2	OBJECT_TYPE	☐	CMS_RE_DTE_OBJ_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Object Type ID	TCMS_RE_TYP
3	ADDR_ID	☐	CMS_RE_DTE_ADDR_ID	AD_ADDRNUM	CHAR	10	0	Address ID	*
4	OBJECT_COND	☐	CMS_RE_DTE_OBJ_COND	CMS_RE_COND	CHAR	6	0	Condition ID	TCMS_RE_COND
5	OBJECT_DESC	☐	CMS_RE_DTE_OBJ_DESC	CMS_RE_DESC	CHAR	30	0	Description of the Real Estate Object
6	OBJECT_PARENT_ID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object	*
7	OBJECT_EXT_REFNO	☐	CMS_RE_DTE_OBJ_REF_NO	CMS_RE_REFID	CHAR	32	0	External reference Number of an External System
8	USAGE_TYPE	☐	CMS_RE_DTE_USG_TYP	CMS_RE_TYP	CHAR	6	0	Usage Type	TCMS_RE_U_TYP
9	BLD_STR_TYPE	☐	CMS_RE_DTE_BLD_STR_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Building Structure ID	TCMS_RE_STR
10	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
11	.INCLUDE	☐				0	0	Structure for Object value
12	OBJECT_VAL	☐	CMS_RE_DTE_OBJ_VAL	CMS_RE_AMOUNT	CURR	17	2	Real Estate Value
13	OBJECT_VAL_CURR	☐	CMS_RE_DTE_OBJ_VAL_CURR	WAERS	CUKY	5	0	Currency for the Object Value	TCURC
14	OBJECT_VAL_DATE	☐	CMS_RE_DTE_OBJ_VAL_DATE	CMS_RE_DATE	DATS	8	0	Object Value Calculation Date
15	.INCLUDE	☐				0	0	Structure for Size details
16	AREA	☐	CMS_RE_DTE_AREA	CMS_RE_SIZE	QUAN	13	3	Total Area of the Real Estate Object
17	AREA_UOM	☐	CMS_RE_DTE_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Area	*
18	VOLUME	☐	CMS_RE_DTE_VOL	CMS_RE_SIZE	QUAN	13	3	Volume of Real Estate Object
19	VOLUME_UOM	☐	CMS_RE_DTE_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Volume of Real Estate	*
20	.INCLUDE	☐				0	0	Structure for Area of collateral value
21	AREA_VALUE	☐	CMS_RE_DTE_AREA_VAL	CMS_RE_SIZE	QUAN	13	3	Area in the Real Estate which has Collateral Value
22	AREA_VALUE_UOM	☐	CMS_RE_DTE_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Area	*
23	VOLUME_VAL	☐	CMS_RE_DTE_VOLUME_VAL	CMS_RE_SIZE	QUAN	13	3	Volume of Real Estate which has Collateral Value
24	VOLUME_VALUE_UOM	☐	CMS_RE_DTE_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Volume of Real Estate	*
25	.INCLUDE	☐				0	0	Structure for Location description details
26	MACRO_LOC_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO002	CMS_ATT_ID_TYP	CHAR	6	0	Macro Location	TCMS_ATT_ID_TY
27	MICRO_LOC_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO003	CMS_ATT_ID_TYP	CHAR	6	0	Micro Location	TCMS_ATT_ID_TY
28	TRAN_CONN_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO004	CMS_ATT_ID_TYP	CHAR	6	0	Transport Connection	TCMS_ATT_ID_TY
29	ENVIRON_STATUS	☐	CMS_RE_DTE_ATT_ID_TY_REO005	CMS_ATT_ID_TYP	CHAR	6	0	Enviromental Status	TCMS_ATT_ID_TY
30	FLOOD_ZONE_FLG	☐	CMS_RE_DTE_FLOOD_ZONE	CMS_RE_FLG	CHAR	1	0	Indicator for Flood Zone
31	EARTHQUAKE_FLG	☐	CMS_RE_DTE_EARTHQUAKE	CMS_RE_FLG	CHAR	1	0	Indicator : Eathquake Zone
32	ARCT_CONV_FLG	☐	CMS_RE_DTE_ARCT_CONV	CMS_RE_FLG	CHAR	1	0	Indicator for Architectural Conservation Area
33	HIST_SITE_FLG	☐	CMS_RE_DTE_HIST_SITE	CMS_RE_FLG	CHAR	1	0	Indicator for Historical Site
34	IS_VAL_IMP_FACS	☐	CMS_RE_DTE_VAL_IMP_FLG	CMS_RE_FLG	CHAR	1	0	Indicates existence of Factors Impairing Real Estate Value
35	VALUE_IMP_DESC	☐	CMS_RE_DTE_VAL_IMP_DESC	CMS_RE_DESC	CHAR	30	0	Description of the value imparing factor
36	.INCLUDE	☐				0	0
37	.INCLUDE	☐				0	0	Structure for Building summary details
38	NO_UNITS	☐	CMS_RE_DTE_NO_UNIT	CMS_RE_UNITS	INT4	10	0	No of units in real estate object
39	NO_FLOORS	☐	CMS_RE_DTE_NO_FLOOR	CMS_RE_UNITS	INT4	10	0	Number of Floors
40	NO_CUR_UNITS	☐	CMS_RE_DTE_NO_CUR_UNIT	CMS_RE_UNITS	INT4	10	0	No of current units in real estate object
41	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
42	NO_OLD_UNITS	☐	CMS_RE_DTE_NO_OLD_UNIT	CMS_RE_UNITS	INT4	10	0	No of old units in real estate object
43	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
44	NO_NEW_UNITS	☐	CMS_RE_DTE_NO_NEW_UNIT	CMS_RE_UNITS	INT4	10	0	No of new units in real estate object
45	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
46	NO_GARAGES	☐	CMS_RE_DTE_NO_GAR	CMS_RE_UNITS	INT4	10	0	No of Garages in Real Estate Object
47	NO_GARAGES_REN	☐	CMS_RE_DTE_NO_GAR_REN	CMS_RE_UNITS	INT4	10	0	No of Garages Rented in Real Estate Object
48	NO_PARK_UNIT	☐	CMS_RE_DTE_NO_PARK_UNIT	CMS_RE_UNITS	INT4	10	0	Number of Parking Units
49	NO_PARK_UNIT_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_REN	CMS_RE_UNITS	INT4	10	0	Number of Parking Units Rented
50	NO_PARK_UG	☐	CMS_RE_DTE_NO_PARK_UNIT_UG	CMS_RE_UNITS	INT4	10	0	Number of Underground Parking Units
51	NO_PARK_UG_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_UG_REN	CMS_RE_UNITS	INT4	10	0	Number of Rented Underground Parking Units
52	.INCLUDE	☐				0	0
53	.INCLUDE	☐				0	0	Structure for Purcahse details
54	OBJECT_PUR_PRICE	☐	CMS_RE_DTE_OBJ_PRC	CMS_RE_AMOUNT	CURR	17	2	Buying Price for the Real estate object
55	OBJECT_PUR_CURR	☐	CMS_RE_DTE_OBJ_PRC_CURR	WAERS	CUKY	5	0	Buying Price Currency for the Real estate object	TCURC
56	OBJECT_PUR_DATE	☐	CMS_RE_DTE_OBJ_PRC_DATE	CMS_RE_DATE	DATS	8	0	Purchasing Date for the Real estate object
57	.INCLUDE	☐				0	0

Foreign Keys

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

History

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