SAP ABAP Table CMS_STR_REAL_ESTATE_BY_AGM_CRM (Real Estate - Attributes and Associations)

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_BY_AGM_CRM	Table Relationship Diagram
Short Description	Real Estate - Attributes and Associations

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

History

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