SAP ABAP Table CMS_STR_CAG_BASIC_DATA_GET_MAP (General Collateral agreement 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_DATA_GET_MAP	Table Relationship Diagram
Short Description	General Collateral agreement 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	CAG_GUID	☐	CMS_DTE_CAG_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_CAG
2	CAGMTID	☐	CMS_DTE_CAGID	CMS_CAGID	CHAR	40	0	Collateral Agreement ID
3	CATEGORYID	☐	CMS_DTE_CAG_CAT	CMS_CAT	CHAR	6	0	Collateral Agreement Category ID
4	CAGMT_TYPE	☐	CMS_DTE_CAG_TYP	CMS_CAG_TYP	CHAR	6	0	Collateral Agreement Type	*
5	CAGMT_TYP_DESC	☐	CMS_DTE_CAG_TYP_NAME	CMS_NAME	CHAR	40	0	Name of Collateral Agreement Type
6	NOM_VALUE	☐	CMS_DTE_CAG_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Collateral Agreement
7	NOM_VALUE_CURR	☐	CMS_DTE_CAG_NOMINAL_CURR	WAERS	CUKY	5	0	Currency for Nominal Value of the Collateral Agreement	*
8	CAGMT_DATE	☐	CMS_DTE_CAG_DATE	CMS_DATE	DATS	8	0	Date on which Collateral Agreement was Concluded
9	VALID_FROM	☐	CMS_DTE_VALID_FROM	CMS_DATE	DATS	8	0	Date from when it is valid
10	VALID_TO	☐	CMS_DTE_VALID_TO	CMS_DATE	DATS	8	0	Date until when it is valid
11	COUNTRY_KEY	☐	CMS_DTE_COUNTRY_KEY	LAND1	CHAR	3	0	Jurisdiction Country	*
12	FLG_GLOBAL	☐	CMS_DTE_FLG_CAG_GLOBAL	CMS_FLG_GLOBAL_CAGMT	CHAR	1	0	Flag to indicate a Global Collateral Agreement
13	PCT_ASSET_VAL	☐	CMS_DTE_PCT_AST_VAL	CMS_PCT	DEC	10	6	Percentage of the Asset Value used in Collateral Agreement
14	GUAR_RATE	☐	CMS_DTE_CAG_GUAR_RATE	CMS_PCT	DEC	10	6	Guarantee Rate
15	SPL_MARKDOWN_PCT	☐	CMS_DTE_CAG_SPL_MARKDOWN_PCT	CMS_PCT	DEC	10	6	Percentage of Special Markdown
16	SPL_MARKDOWN_AMT	☐	CMS_DTE_CAG_SPL_MARKDOWN_AMT	CMS_AMOUNT	CURR	17	2	Amount of Special Markdown
17	SPL_MRKDOWN_CURR	☐	CMS_DTE_CAG_SPL_MRKDWN_CURR	WAERS	CUKY	5	0	Currency for Amount of Special Markdown	*
18	DESCRIPTION	☐	CMS_DTE_CAG_DESC	CMS_DSC	CHAR	30	0	Description of Collateral Agreement
19	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
20	PERIOD_REL_FREQ	☐	CMS_DTE_CAG_REL_FREQ_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Period for Frequency of Release of Collateral Agreement
21	OLD_CAGMTID	☐	CMS_DTE_OLD_CAGID	CMS_OLD_CAGID	CHAR	40	0	External/Old Collateral Agreement ID
22	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	*
23	MIN_QL_REASON	☐	CMS_DTE_CAG_ATT_ID_TY_CAG001	CMS_ATT_ID_TYP	CHAR	6	0	Reason for the Minimum Qualitative Criterion
24	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)
25	MIN_QL_CRITE	☐	CMS_DTE_CAG_MIN_QUAL_CRITERION	CMS_CAG_MIN_QUAL_CRITERION	CHAR	6	0	MInimum Qualitative Criterion	*
26	TERM_RIGHT_TYP	☐	CMS_DTE_TERM_RIGHT_TYP	CMS_CAG_TERM_RIGHT_TYP	CHAR	6	0	Termination Right Type	*
27	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
28	PERIOD_TERM_FREQ	☐	CMS_DTE_CAG_TERM_FREQ_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Period for Frequency of Termination of Collateral Agreement
29	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
30	REQ_NOTICE_PRD	☐	CMS_DTE_CAG_NOTICE_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Notice Period Required to Terminate Collateral Agreement
31	TERM_NOTICE_DATE	☐	CMS_DTE_CAG_TERM_NOTICE_DATE	CMS_DATE	DATS	8	0	Date on which Termination Notice was Sent
32	TERM_REASON	☐	CMS_DTE_CAG_ATT_ID_TY_CAG002	CMS_ATT_ID_TYP	CHAR	6	0	Termination Type
33	TERM_GUAR_AMT	☐	CMS_DTE_CAG_TERM_VALUE	CMS_AMOUNT	CURR	17	2	Amount of Guarantee in the event of Termination
34	TERMINATION_CURR	☐	CMS_DTE_CAG_TERM_VALUE_CURR	WAERS	CUKY	5	0	Currency for Amount of Guarantee in the event of Termination	*
35	MIN_STOCK_AMT	☐	CMS_DTE_CAG_MIN_STOCK_AMT	CMS_AMOUNT	CURR	17	2	Minimum stock Amount agreed in the Collateral Agreement
36	MIN_STOCK_CURR	☐	CMS_DTE_CAG_MIN_STOCK_AMT_CURR	WAERS	CUKY	5	0	Currency of the Minimum Stock Amount	*
37	FLG_ADDNL_RBL	☐	CMS_DTE_FLG_CAG_ADDNL_RBL	CMS_FLG_ADDNL_RBL	CHAR	1	0	Flag for Additional receivable
38	ADDNL_RBL_DATE	☐	CMS_DTE_CAG_DATE_ADDNL_RBL	CMS_DATE	DATS	8	0	Date on which Additional Receivable was Accepted
39	SCOPE_INS_COVER	☐	CMS_DTE_CAG_ATT_ID_TY_CAG004	CMS_ATT_ID_TYP	CHAR	6	0	Scope of Cover of Credit Insurance
40	LIQD_MODE	☐	CMS_DTE_LIQD_MODE	CMS_LIQD_MODE	CHAR	6	0	Mode of Liquidation decision for the pool agreement	*
41	REL_THRESHOLD	☐	CMS_DTE_CAG_RELEASE_THRESHOLD	CMS_PCT	DEC	10	6	Limit above which the Collaterals can be Released from Pool
42	COR_ROLE	☐	CMS_DTE_COR_ROLE	CORR_ROLE_KK	CHAR	4	0	Correspondence role	*

History

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