SAP ABAP Table CMS_STR_REAL_ESTATE_CRM (Real Estate - ATtributes)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS (Application Component) Collateral Management System
     ⤷ CMS_CRM_TMP (Package) Temporary!!!: CMS-CRM Interface (to be deleted in ERP2006)

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_REAL_ESTATE_CRM	Table Relationship Diagram
Short Description	Real Estate - ATtributes

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	BTD_ID	☐	CMS_STR_BTD_ID_CRM		STRU	0	0
2	ID	☐	CHAR_35	CHAR_35	CHAR	35	0	Text field, length 35
3	SCHEME_ID	☐	CMS_DTE_CHAR60LOW_CRM	CHAR60LOW	CHAR	60	0	60 Characters Lower Case
4	SCHEME_AGENCY_ID	☐	CHAR_60	CHAR_60	CHAR	60	0	Character String 60
5	ID	☐	BAPICMS_RE_DTE_OBJECT_ID	CMS_RE_OBJECT_ID	CHAR	20	0	Object ID
6	TYPE	☐	BAPICMS_RE_DTE_OBJ_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Object Type ID	TCMS_RE_TYP
7	CATEGORY	☐	BAPICMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category	TCMS_OMS_CAT
8	UTILIZATION	☐	BAPICMS_RE_DTE_PRT_UTILIZATION	CMS_RE_UTIL	CHAR	6	0	Utilization of the part
9	DESCRIPTION	☐	BAPICMS_RE_DTE_SPC_DESC	CMS_RE_DESC	CHAR	30	0	Description of Building Part
10	MONETARY_VALUE	☐	CMS_STR_MONETARY_VALUE_CRM		STRU	0	0
11	MARKET_VALUE	☐	BAPICMS_DTE_AST_VALUE	BAPICURR	DEC	23	4	Final Asset Value
12	MARKET_VALUE_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
13	NOMINAL_VALUE	☐	BAPICMS_DTE_AST_NOMINAL_VALUE	BAPICURR	DEC	23	4	Nominal Value of the Asset
14	NOMINAL_VALUE_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
15	UNUSED_VALUE	☐	CMS_DTE_RE_UNUSED_AMOUNT	BAPICURR	DEC	23	4	Immobilien: Unbeliehener Betrag
16	UNUSED_VALUE_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
17	LENDING_RATES	☐	CMS_STR_LENDING_RATE_CRM		STRU	0	0
18	LENDING_RATE	☐	BAPICMS_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1
19	LENDING_AMOUNTS	☐	CMS_STR_LENDING_AMOUNTS_CRM		STRU	0	0
20	LENDING_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_VALUE	BAPICURR	DEC	23	4	Lending value Calculation for Asset
21	LENDING_AMOUNT_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
22	LENDING_LIMIT_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT5	BAPICURR	DEC	23	4	Lending Limit 5 Calculation for Asset
23	LENDING_LIMIT_AMOUNT_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
24	LENDING_RANGE_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE5	BAPICURR	DEC	23	4	Lending Range 5 calculation for Asset
25	LENDING_RANGE_AMOUNT_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
26	SAFETY_DISCOUNT	☐	CMS_STR_SAFETY_DISCOUNT_CRM		STRU	0	0
27	CODE	☐	BAPICMS_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates that the asset has a default sfty discount or not
28	PERCENTAGE	☐	BAPICMS_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
29	AMOUNT	☐	BAPICMS_DTE_SAFETY_AMT	BAPICURR	DEC	23	4	Safety discount as an amount
30	AMOUNT_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
31	ADDRESS	☐	CMS_STR_ADDRESS_CRM		STRU	0	0
32	CITY_NAME	☐	AD_CITY1	TEXT40	CHAR	40	0	City
33	STREET_POSTAL_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
34	STREET_NAME	☐	AD_STREET	TEXT60	CHAR	60	0	Street
35	HOUSE_ID	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
36	COUNTRY_CODE	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
37	REGION_CODE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
38	LOCATION	☐	CMS_STR_LOCATION_CRM		STRU	0	0
39	MACRO_LOCATION_CODE	☐	BAPICMS_DTE_RE_MACRO_LOC	CMS_ATT_ID_TYP	CHAR	6	0	Macro Location
40	MICRO_LOCATION_CODE	☐	BAPICMS_DTE_RE_MICRO_LOC	CMS_ATT_ID_TYP	CHAR	6	0	Micro Location
41	TRANSPORT_CONNECTION_CODE	☐	BAPICMS_DTE_RE_CONNECTION	CMS_ATT_ID_TYP	CHAR	6	0	Transport Connection
42	ENVIRONMENTAL_CONDITIONS_CODE	☐	BAPICMS_DTE_RE_ENV_STATUS	CMS_ATT_ID_TYP	CHAR	6	0	Enviromental Status
43	FLOOD_ZONE_INDICATOR	☐	BAPICMS_RE_DTE_FLOOD_ZONE	CMS_RE_FLG	CHAR	1	0	Indicator for Flood Zone
44	EARTHQUAKE_ZONE_INDICATOR	☐	BAPICMS_RE_DTE_EARTHQUAKE	CMS_RE_FLG	CHAR	1	0	Indicator for Eathquake Zone
45	ARCHITECTL_CONS_AREA_INDICATOR	☐	BAPICMS_RE_DTE_ARCT_CONV	CMS_RE_FLG	CHAR	1	0	Indicator for Architectural Conservation area
46	HISTORIC_SITE_INDICATOR	☐	BAPICMS_RE_DTE_HIST_SITE	CMS_RE_FLG	CHAR	1	0	Indicator for Historical Site
47	VALUE_IMPAIRING_FT_INDICATOR	☐	BAPICMS_RE_DTE_VAL_IMP_FLG	CMS_RE_FLG	CHAR	1	0	Indicates existence of Factors Impairing Real Estate Value
48	VALUE_IMPAIRING_FT_DESCRIPTION	☐	BAPICMS_RE_DTE_VAL_IMP_DESC	CMS_RE_DESC	CHAR	30	0	Description of the value imparing factor
49	LAND	☐	CMS_STR_LAND_CRM		STRU	0	0
50	AREA	☐	CMS_STR_LAND_AREA_CRM		STRU	0	0
51	LAND_AREA	☐	CMS_DTE_DEC_13_3_CRM	DEC10_3	DEC	13	3	Decimal
52	LAND_AREA_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement
53	RENTED_LAND_AREA	☐	CMS_DTE_DEC_13_3_CRM	DEC10_3	DEC	13	3	Decimal
54	RENTED_LAND_AREA_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement
55	COSTS	☐	CMS_STR_LAND_COSTS_CRM		STRU	0	0
56	LAND_COST	☐	BAPICMS_RE_DTE_LAND_COST	BAPICURR	DEC	23	4	Land Cost amount
57	LAND_COST_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
58	LAND_COST_BASE	☐	BAPICMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure - Land
59	DEVELOPMENT_COST	☐	BAPICMS_RE_DTE_DEV_COST	BAPICURR	DEC	23	4	Dev Cost amount
60	DEVELOPMENT_COST_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
61	DEVELOPMENT_COST_BASE	☐	BAPICMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure - Land
62	ADDITIONAL_LAND_COST	☐	BAPICMS_RE_DTE_ADD_LAND_COST	BAPICURR	DEC	23	4	Additional Land Cost amount
63	ADDITIONAL_LAND_COST_CURRENCY	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
64	ADDITIONAL_LAND_COST_BASE	☐	BAPICMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure - Land
65	BUILDING	☐	CMS_STR_BUILDING_CRM		STRU	0	0
66	AREA	☐	CMS_STR_BUILDING_AREA_CRM		STRU	0	0
67	USABLE_AREA	☐	CMS_DTE_DEC_13_3_CRM	DEC10_3	DEC	13	3	Decimal
68	USABLE_AREA_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement
69	USABLE_VOLUME	☐	CMS_DTE_DEC_13_3_CRM	DEC10_3	DEC	13	3	Decimal
70	USABLE_VOLUME_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement
71	RESIDENTIAL_AREA	☐	CMS_DTE_DEC_13_3_CRM	DEC10_3	DEC	13	3	Decimal
72	RESIDENTIAL_AREA_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement
73	SECONDARY_AREA	☐	CMS_DTE_DEC_13_3_CRM	DEC10_3	DEC	13	3	Decimal
74	SECONDARY_AREA_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement
75	OTHER_AREA	☐	CMS_DTE_DEC_13_3_CRM	DEC10_3	DEC	13	3	Decimal
76	OTHER_AREA_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement
77	UNITS	☐	CMS_STR_BUILDING_UNITS_CRM		STRU	0	0
78	NUMBER_OF_BUILDING_PARTS	☐	BAPICMS_RE_DTE_NO_PRT_UNIT	CMS_RE_UNITS	INT4	10	0	Number of building part units
79	OWNER	☐	CMS_TAB_OWNER_CRM		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_REAL_ESTATE_CRM	CATEGORY	TCMS_OMS_CAT	CATEGORYID

History

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