SAP ABAP Table CMS_STR_CAG_BASIC_MAP (Collateral agreement basic data)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD (Application Component) Master Data
     ⤷ CMS_CORE (Package) Collateral Management System

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_CAG_BASIC_MAP	Table Relationship Diagram
Short Description	Collateral agreement basic data

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	NOM_VALUE	☐	CMS_DTE_CAG_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Collateral Agreement
2	NOM_VALUE_CURR	☐	CMS_DTE_CAG_NOMINAL_CURR	WAERS	CUKY	5	0	Currency for Nominal Value of the Collateral Agreement	*
3	ASMT_AMT	☐	CMS_DTE_CAG_ASMT_AMT	CMS_AMOUNT	CURR	17	2	Assessment Amount
4	ASMT_CURR	☐	CMS_DTE_CAG_ASMT_CURR	WAERS	CUKY	5	0	Currency of Assessment Value	*
5	ASMT_DATE	☐	CMS_DTE_CAG_ASMT_DATE	CMS_DATE	DATS	8	0	Date on which the Assessment Value was Calculated
6	CAGMT_DATE	☐	CMS_DTE_CAG_DATE	CMS_DATE	DATS	8	0	Date on which Collateral Agreement was Concluded
7	VALID_FROM	☐	CMS_DTE_VALID_FROM	CMS_DATE	DATS	8	0	Date from when it is valid
8	VALID_TO	☐	CMS_DTE_VALID_TO	CMS_DATE	DATS	8	0	Date until when it is valid
9	COUNTRY_KEY	☐	CMS_DTE_COUNTRY_KEY	LAND1	CHAR	3	0	Jurisdiction Country	*
10	FLG_GLOBAL	☐	CMS_DTE_FLG_CAG_GLOBAL	CMS_FLG_GLOBAL_CAGMT	CHAR	1	0	Flag to indicate a Global Collateral Agreement
11	PCT_ASSET_VAL	☐	CMS_DTE_PCT_AST_VAL	CMS_PCT	DEC	10	6	Percentage of the Asset Value used in Collateral Agreement
12	GUAR_RATE	☐	CMS_DTE_CAG_GUAR_RATE	CMS_PCT	DEC	10	6	Guarantee Rate
13	SPL_MARKDOWN_PCT	☐	CMS_DTE_CAG_SPL_MARKDOWN_PCT	CMS_PCT	DEC	10	6	Percentage of Special Markdown
14	SPL_MARKDOWN_AMT	☐	CMS_DTE_CAG_SPL_MARKDOWN_AMT	CMS_AMOUNT	CURR	17	2	Amount of Special Markdown
15	SPL_MRKDOWN_CURR	☐	CMS_DTE_CAG_SPL_MRKDWN_CURR	WAERS	CUKY	5	0	Currency for Amount of Special Markdown	*
16	DESCRIPTION	☐	CMS_DTE_CAG_DESC	CMS_DSC	CHAR	30	0	Description of Collateral Agreement
17	UNIT_REL_FREQ	☐	CMS_DTE_IND_CAG_REL_FREQ_UNIT	CMS_IND_CAG_FREQ_UNIT	CHAR	2	0	The unit for period of Release Frequency
18	PERIOD_REL_FREQ	☐	CMS_DTE_CAG_REL_FREQ_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Period for Frequency of Release of Collateral Agreement
19	OLD_CAGMTID	☐	CMS_DTE_OLD_CAGID	CMS_OLD_CAGID	CHAR	40	0	External/Old Collateral Agreement ID
20	MIN_QL_EXCEP_TYP	☐	CMS_DTE_CAG_MIN_QUAL_EXCEP_TYP	CMS_CAG_MIN_QUAL_EXCEP_TYP	CHAR	6	0	Exceptions for Minimum Risk Weight	*
21	MIN_QL_REASON	☐	CMS_DTE_CAG_ATT_ID_TY_CAG001	CMS_ATT_ID_TYP	CHAR	6	0	Reason for the Minimum Qualitative Criterion
22	FLG_MIN_QL_REQMT	☐	CMS_DTE_FLG_CAG_MIN_QUAL_REQMT	CMS_FLG_MIN_QUAL_REQMT	CHAR	1	0	Flag:Minimum requirements fulfilled for CAG(for Basel II)
23	MIN_QL_CRITE	☐	CMS_DTE_CAG_MIN_QUAL_CRITERION	CMS_CAG_MIN_QUAL_CRITERION	CHAR	6	0	MInimum Qualitative Criterion	*
24	TERM_RIGHT_TYP	☐	CMS_DTE_TERM_RIGHT_TYP	CMS_CAG_TERM_RIGHT_TYP	CHAR	6	0	Termination Right Type	*
25	UNIT_TERM_FREQ	☐	CMS_DTE_IND_CAG_TERM_FREQ_UNIT	CMS_IND_CAG_FREQ_UNIT	CHAR	2	0	The Unit for Period of Termination Frequency
26	PERIOD_TERM_FREQ	☐	CMS_DTE_CAG_TERM_FREQ_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Period for Frequency of Termination of Collateral Agreement
27	NOTICE_PRD_UNIT	☐	CMS_DTE_IND_CAG_NOTICE_UNIT	CMS_IND_CAG_TIME_PRD_UNIT	CHAR	2	0	The Unit for the Termination Notice Period
28	REQ_NOTICE_PRD	☐	CMS_DTE_CAG_NOTICE_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Notice Period Required to Terminate Collateral Agreement
29	TERM_NOTICE_DATE	☐	CMS_DTE_CAG_TERM_NOTICE_DATE	CMS_DATE	DATS	8	0	Date on which Termination Notice was Sent
30	TERM_REASON	☐	CMS_DTE_CAG_ATT_ID_TY_CAG002	CMS_ATT_ID_TYP	CHAR	6	0	Termination Type
31	TERM_GUAR_AMT	☐	CMS_DTE_CAG_TERM_VALUE	CMS_AMOUNT	CURR	17	2	Amount of Guarantee in the event of Termination
32	TERMINATION_CURR	☐	CMS_DTE_CAG_TERM_VALUE_CURR	WAERS	CUKY	5	0	Currency for Amount of Guarantee in the event of Termination	*
33	MIN_STOCK_AMT	☐	CMS_DTE_CAG_MIN_STOCK_AMT	CMS_AMOUNT	CURR	17	2	Minimum stock Amount agreed in the Collateral Agreement
34	MIN_STOCK_CURR	☐	CMS_DTE_CAG_MIN_STOCK_AMT_CURR	WAERS	CUKY	5	0	Currency of the Minimum Stock Amount	*
35	FLG_ADDNL_RBL	☐	CMS_DTE_FLG_CAG_ADDNL_RBL	CMS_FLG_ADDNL_RBL	CHAR	1	0	Flag for Additional receivable
36	ADDNL_RBL_DATE	☐	CMS_DTE_CAG_DATE_ADDNL_RBL	CMS_DATE	DATS	8	0	Date on which Additional Receivable was Accepted
37	SCOPE_INS_COVER	☐	CMS_DTE_CAG_ATT_ID_TY_CAG004	CMS_ATT_ID_TYP	CHAR	6	0	Scope of Cover of Credit Insurance
38	LIQD_MODE	☐	CMS_DTE_LIQD_MODE	CMS_LIQD_MODE	CHAR	6	0	Mode of Liquidation decision for the pool agreement	*
39	REL_THRESHOLD	☐	CMS_DTE_CAG_RELEASE_THRESHOLD	CMS_PCT	DEC	10	6	Limit above which the Collaterals can be Released from Pool

History

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