SAP ABAP Table CMS_RE_STR_MAINOBJ_ACS_MAP_GET (MAPI : Structure for Accessory)

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_MAINOBJ_ACS_MAP_GET	Table Relationship Diagram
Short Description	MAPI : Structure for Accessory

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	OBJECT_TYPE	☐	CMS_RE_DTE_OBJ_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Object Type ID	*
6	.INCLUDE	☐				0	0	Structure for Accessory Type
7	ACS_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO010	CMS_ATT_ID_TYP	CHAR	6	0	Accessory Type	TCMS_ATT_ID_TY
8	NO_OF_ACS	☐	CMS_RE_DTE_NO_OF_ACS	CMS_RE_UNITS	INT4	10	0	No of Accessory Units
9	ACS_VALUE	☐	CMS_RE_DTE_ACS_VALUE	CMS_RE_AMOUNT	CURR	17	2	Value of the Accessory
10	ACS_VALUE_CURR	☐	CMS_RE_DTE_ACS_VALUE_CURR	WAERS	CUKY	5	0	Currency for Value of the accessory	TCURC
11	IS_SUB_AST_CREA	☐	CMS_RE_DTE_CREATE_SUB_AST_FLG	CMS_RE_FLG	CHAR	1	0	Indicates whether a Sub-asset is created for Building Part
12	ACS_DESC	☐	CMS_RE_DTE_CST_DESC	CMS_RE_DESC	CHAR	30	0	Description of the cost
13	ACS_ID	☐	CMS_RE_DTE_ACS_ID	CMS_ACS_ID	NUMC	4	0	Sequence Number of Accessory or Special Equipment
14	.INCLUDE	☐				0	0	Basic Asset data
15	RISK_CODE	☐	CMS_RE_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	TCMS_RISKCODE
16	SFTY_IND	☐	CMS_RE_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates that the asset has a default sfty discount or not
17	SFTY_DSCNT	☐	CMS_RE_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
18	SFTY_AMOUNT	☐	CMS_RE_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Safety discount as an amount
19	SFTY_AMT_CURR	☐	CMS_RE_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount	TCURC
20	.INCLUDE	☐				0	0	Valuation data
21	VALUATION_TYP	☐	CMS_RE_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Check conducted on the object
22	UNIT_VALN_FREQ	☐	CMS_RE_DTE_IND_FREQUENCY	CMS_RE_IND_FREQUENCY	CHAR	2	0	Indicator : Valuation Period
23	PERIOD_VALN_FREQ	☐	CMS_RE_DTE_VALN_FREQ_PERIOD	CMS_RE_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for a real estate
24	PAST_VALUED_DATE	☐	CMS_RE_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Most Recent Date on which the Real Estate was last Valued
25	START_DATE	☐	CMS_RE_DTE_START_DATE	CMS_DATE	DATS	8	0	Revaluation Start date
26	END_DATE	☐	CMS_RE_DTE_END_DATE	CMS_DATE	DATS	8	0	End date for Revaluation of the Real Estate
27	.INCLUDE	☐				0	0	Lending rate data
28	LENDING_RATE_IND	☐	CMS_RE_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicates that the asset has a default lending rate or not
29	.INCLUDE	☐				0	0	Lending rates
30	LENDING_RATE1	☐	CMS_RE_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
31	LENDING_RATE2	☐	CMS_RE_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending rate 2
32	LENDING_RATE3	☐	CMS_RE_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending rate 3
33	LENDING_RATE4	☐	CMS_RE_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending rate 4
34	LENDING_RATE5	☐	CMS_RE_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending rate 5

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_RE_STR_MAINOBJ_ACS_MAP_GET	ACS_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
2	CMS_RE_STR_MAINOBJ_ACS_MAP_GET	ACS_VALUE_CURR	TCURC	WAERS	REF	1	CN
3	CMS_RE_STR_MAINOBJ_ACS_MAP_GET	RISK_CODE	TCMS_RISKCODE	RISK_CODE	REF	1	CN
4	CMS_RE_STR_MAINOBJ_ACS_MAP_GET	SFTY_AMT_CURR	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20050615
SAP Release Created in	500