SAP ABAP Table CMS_STR_CAG_DATA (Collateral Agreement Details)

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_DATA	Table Relationship Diagram
Short Description	Collateral Agreement Details

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	Nominal Value for Collateral Agreement
2	NOM_VALUE	☐	CMS_DTE_CAG_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Collateral Agreement
3	NOM_VALUE_CURR	☐	CMS_DTE_CAG_NOMINAL_CURR	WAERS	CUKY	5	0	Currency for Nominal Value of the Collateral Agreement	TCURC
4	.INCLUDE	☐				0	0	Assessment Value details for a Collateral Agreement
5	ASMT_AMT	☐	CMS_DTE_CAG_ASMT_AMT	CMS_AMOUNT	CURR	17	2	Assessment Amount
6	ASMT_CURR	☐	CMS_DTE_CAG_ASMT_CURR	WAERS	CUKY	5	0	Currency of Assessment Value	TCURC
7	ASMT_DATE	☐	CMS_DTE_CAG_ASMT_DATE	CMS_DATE	DATS	8	0	Date on which the Assessment Value was Calculated
8	.INCLUDE	☐				0	0	Collateral Agreement Dates (DB Format )
9	CAGMT_DATE	☐	CMS_DTE_CAG_DATE	CMS_DATE	DATS	8	0	Date on which Collateral Agreement was Concluded
10	VALID_FROM	☐	CMS_DTE_CAG_VALID_FROM	TZNTSTMPSL	NUMC	15	0	Collateral Agreement Document Valid-from Date
11	VALID_TO	☐	CMS_DTE_CAG_VALID_TO	TZNTSTMPSL	NUMC	15	0	Collateral Agreement Document Valid-to Date
12	.INCLUDE	☐				0	0	Basic data for a Collateral Agreement
13	.INCLUDE	☐				0	0	Administrative organization unit
14	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
15	.INCLUDE	☐				0	0	Bank area
16	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
17	COUNTRY_KEY	☐	CMS_DTE_COUNTRY_KEY	LAND1	CHAR	3	0	Jurisdiction Country	*
18	FLG_GLOBAL	☐	CMS_DTE_FLG_CAG_GLOBAL	CMS_FLG_GLOBAL_CAGMT	CHAR	1	0	Flag to indicate a Global Collateral Agreement
19	SPL_MARKDOWN_PCT	☐	CMS_DTE_CAG_SPL_MARKDOWN_PCT	CMS_PCT	DEC	10	6	Percentage of Special Markdown
20	SPL_MARKDOWN_AMT	☐	CMS_DTE_CAG_SPL_MARKDOWN_AMT	CMS_AMOUNT	CURR	17	2	Amount of Special Markdown
21	SPL_MRKDOWN_CURR	☐	CMS_DTE_CAG_SPL_MRKDWN_CURR	WAERS	CUKY	5	0	Currency for Amount of Special Markdown	*
22	DESCRIPTION	☐	CMS_DTE_CAG_DESC	CMS_DSC	CHAR	30	0	Description of Collateral Agreement
23	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
24	PERIOD_REL_FREQ	☐	CMS_DTE_CAG_REL_FREQ_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Period for Frequency of Release of Collateral Agreement
25	OLD_CAGMTID	☐	CMS_DTE_OLD_CAGID	CMS_OLD_CAGID	CHAR	40	0	External/Old Collateral Agreement ID
26	.INCLUDE	☐				0	0	Basel II relevant data
27	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	TCMS_CAG_MQEXP
28	MIN_QL_REASON	☐	CMS_DTE_CAG_ATT_ID_TY_CAG001	CMS_ATT_ID_TYP	CHAR	6	0	Reason for the Minimum Qualitative Criterion	TCMS_ATT_ID_TY
29	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)
30	MIN_QL_CRITE	☐	CMS_DTE_CAG_MIN_QUAL_CRITERION	CMS_CAG_MIN_QUAL_CRITERION	CHAR	6	0	MInimum Qualitative Criterion	TCMS_CAG_MQCRT
31	.INCLUDE	☐				0	0	Asset details for a Collateral Agreement
32	PCT_ASSET_VAL	☐	CMS_DTE_PCT_AST_VAL	CMS_PCT	DEC	10	6	Percentage of the Asset Value used in Collateral Agreement
33	.INCLUDE	☐				0	0	Termination rights data
34	TERM_RIGHT_TYP	☐	CMS_DTE_TERM_RIGHT_TYP	CMS_CAG_TERM_RIGHT_TYP	CHAR	6	0	Termination Right Type	*
35	FIRST_TERM_DATE	☐	CMS_DTE_CAG_TERM_FSTPOS_DATE	CMS_DATE	DATS	8	0	First possible date of termination
36	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
37	PERIOD_TERM_FREQ	☐	CMS_DTE_CAG_TERM_FREQ_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Period for Frequency of Termination of Collateral Agreement
38	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
39	REQ_NOTICE_PRD	☐	CMS_DTE_CAG_NOTICE_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Notice Period Required to Terminate Collateral Agreement	*
40	TERM_NOTICE_DATE	☐	CMS_DTE_CAG_TERM_NOTICE_DATE	CMS_DATE	DATS	8	0	Date on which Termination Notice was Sent
41	TERM_REASON	☐	CMS_DTE_CAG_ATT_ID_TY_CAG002	CMS_ATT_ID_TYP	CHAR	6	0	Termination Type	TCMS_ATT_ID_TY
42	TERM_GUAR_AMT	☐	CMS_DTE_CAG_TERM_VALUE	CMS_AMOUNT	CURR	17	2	Amount of Guarantee in the event of Termination
43	TERMINATION_CURR	☐	CMS_DTE_CAG_TERM_VALUE_CURR	WAERS	CUKY	5	0	Currency for Amount of Guarantee in the event of Termination	*
44	.INCLUDE	☐				0	0	Guarantee specific data
45	.INCLUDE	☐				0	0	Guarantee specific details
46	GUAR_RATE	☐	CMS_DTE_CAG_GUAR_RATE	CMS_PCT	DEC	10	6	Guarantee Rate
47	FLG_COUNTER_GUAR	☐	CMS_DTE_FLG_CAG_CNTR_GUAR	CMS_FLG_CNTR_GUAR	CHAR	1	0	Flag for Counter Guarantee
48	FLG_CO_GUAR	☐	CMS_DTE_FLG_CAG_CO_GUAR	CMS_FLG_CO_GUAR	CHAR	1	0	Flag for Co-guarantee
49	FLG_FIXED_LIABTY	☐	CMS_DTE_FLG_CAG_FIXED_LIABILTY	CMS_FLG_FIXED_LIABILITY	CHAR	1	0	Flag for Fixed Liability
50	FLG_DEF_LIABTY	☐	CMS_DTE_FLG_CAG_DEF_LIABILITY	CMS_FLG_DEF_LIABILITY	CHAR	1	0	Flag for Default Liability
51	PCT_DEF_LIABTY	☐	CMS_DTE_FLG_CAG_PCT_DEF_LIABTY	CMS_PCT	DEC	10	6	Default Liability in %
52	FLG_INCL_CAG_LNK	☐	CMS_DTE_FLG_CAG_INCL_LINKED	CMS_FLG_CAG_INCL_LINKED	CHAR	1	0	Flag for back-up guarantee to be used in calculations or not
53	IND_APPR_AUTH	☐	CMS_DTE_IND_CAG_APPR_AUTH	CMS_IND_CAG_APPR_AUTH	CHAR	2	0	Approval from authorities
54	FLG_ENFORCEABLE	☐	CMS_DTE_FLG_CAG_ENFORCEABLE	CMS_FLG_DIR_ENFC	CHAR	1	0	Agreement directly enforceable
55	LENDING_RATE	☐	CMS_DTE_CAG_LRTE_PCT	CMS_PCT	DEC	10	6	Lending Rate of a Guarantee
56	.INCLUDE	☐				0	0	Reduction relation data
57	UNIT_REDU_FREQ	☐	CMS_DTE_IND_CAG_RED_FREQ_UNIT	CMS_IND_CAG_FREQ_UNIT	CHAR	2	0	Unit for Period of Frequency for Reduction in Guarantee Valu
58	PERIOD_REDU_FREQ	☐	CMS_DTE_CAG_RED_FREQ_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Period for Frequency of Reduction in Value of Guarantee
59	REDU_AMT	☐	CMS_DTE_CAG_REDU_AMT	CMS_AMOUNT	CURR	17	2	Reduction in Amount of Guarantee
60	REDU_CURR	☐	CMS_DTE_CAG_REDU_AMT_CURR	WAERS	CUKY	5	0	Currency of the Reduced Amount of the Guarantee	*
61	REDU_PCT	☐	CMS_DTE_CAG_REDU_PCT	CMS_PCT	DEC	10	6	Percentage of Reduction in the Value of a Guarantee
62	REDU_START_DATE	☐	CMS_DTE_CAG_REDU_START_DATE	CMS_DATE	DATS	8	0	Date from which Guarantee Value is Reduced
63	REDU_END_DATE	☐	CMS_DTE_CAG_REDU_END_DATE	CMS_DATE	DATS	8	0	End Date for Reduction in Amount of Guarantee
64	REDU_LAST_DATE	☐	CMS_DTE_CAG_REDU_LAST_DATE	CMS_DATE	DATS	8	0	Last date of reduction of value
65	.INCLUDE	☐				0	0	Transfer specific details
66	FLG_LEASING_TXN	☐	CMS_DTE_FLG_CAG_LEASING_TXN	CMS_FLG_LEASING_TRANSACTION	CHAR	1	0	Flag: Transfer is part of a leasing transaction
67	IND_LESSOR_LIEN	☐	CMS_DTE_IND_CAG_LESSOR_LIEN	CMS_IND_CAG_LESSOR_LIEN	CHAR	2	0	Indicator for Lessor Lien on Collateral Agreement
68	IND_ACC_LIABLE	☐	CMS_DTE_IND_CAG_ACC_LIABLE	CMS_IND_CAG_ACC_LIABLE	CHAR	2	0	Specifies the applicability of accessories liability
69	FLG_ASGMT_AR	☐	CMS_DTE_FLG_CAG_AR_FRM_SALE	CMS_FLG_ASGMT_RBL_FROM_SALE	CHAR	1	0	Flag for Assignment of Accounts Receivables(AR) from Sale
70	.INCLUDE	☐				0	0	Minimum stock data
71	MIN_STOCK_AMT	☐	CMS_DTE_CAG_MIN_STOCK_AMT	CMS_AMOUNT	CURR	17	2	Minimum stock Amount agreed in the Collateral Agreement
72	MIN_STOCK_CURR	☐	CMS_DTE_CAG_MIN_STOCK_AMT_CURR	WAERS	CUKY	5	0	Currency of the Minimum Stock Amount	TCURC
73	FLG_ADDNL_RBL	☐	CMS_DTE_FLG_CAG_ADDNL_RBL	CMS_FLG_ADDNL_RBL	CHAR	1	0	Flag for Additional receivable
74	ADDNL_RBL_DATE	☐	CMS_DTE_CAG_DATE_ADDNL_RBL	CMS_DATE	DATS	8	0	Date on which Additional Receivable was Accepted
75	.INCLUDE	☐				0	0	Pledge/Assignment details
76	IND_GBC_LIEN	☐	CMS_DTE_IND_CAG_GBC_LIEN	CMS_IND_CAG_GBC_LIEN	CHAR	2	0	GBC Lien on Agreement
77	FLG_DISCL	☐	CMS_DTE_FLG_CAG_DISCL_PLEDGE	CMS_FLG_DISCL_PLEDGE	CHAR	1	0	Flag to indicator whether the Agreement is disclosed or not
78	DISCL_DATE	☐	CMS_DTE_CAG_DISCL_DATE	CMS_DATE	DATS	8	0	Date of Disclosure to Third-party Debtor
79	.INCLUDE	☐				0	0	Assignment reason
80	ASGMT_REASON	☐	CMS_DTE_CAG_ATT_ID_TY_CAG006	CMS_ATT_ID_TYP	CHAR	6	0	Reason for Assignment	TCMS_ATT_ID_TY
81	.INCLUDE	☐				0	0	Land Charge specific data
82	.INCLUDE	☐				0	0	Land Charge specific interest details
83	INT_RATE	☐	CMS_DTE_CAG_LCHG_INT_RATE	CMS_PCT	DEC	10	6	Land Charge Interest Rate
84	INCIDENTAL_PAYMT	☐	CMS_DTE_CAG_LCHG_INCD_PAYMT	CMS_PCT	DEC	10	6	Incidental Payments in Percentage
85	UNIT_PMT_FREQ	☐	CMS_DTE_IND_CAG_PYMT_FREQ_UNIT	CMS_IND_CAG_FREQ_UNIT	CHAR	2	0	The unit for period of payment frequency
86	PERIOD_PMT_FREQ	☐	CMS_DTE_CAG_PYMT_FREQ_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Period for Frequency of Payment of Land Charge Interest
87	INT_START_DATE	☐	CMS_DTE_CAG_LCHG_INT_START_DAT	CMS_DATE	DATS	8	0	Start Date for Land Charge Interest Calculation
88	NUM_YR_LCHG_INT	☐	CMS_DTE_CAG_LCHG_INT_YR	CMS_CAG_LCHG_INT_YR	NUMC	4	0	Number of Years the Land Charge Interest can be Capitalized
89	.INCLUDE	☐				0	0	Enforcement details for a land charge
90	IND_ENFORCMT_TYP	☐	CMS_DTE_IND_CAG_LCHG_ENFC_TYP	CMS_IND_CAG_LCHG_ENFC_TYP	CHAR	2	0	Enforcement Type
91	ENFORCMT_AMT	☐	CMS_DTE_CAG_LCHG_ENFC_AMT	CMS_AMOUNT	CURR	17	2	Enforcement Amount
92	ENFORCMT_CURR	☐	CMS_DTE_CAG_LCHG_ENFC_AMT_CURR	WAERS	CUKY	5	0	Currency for Enforcement Amount of Land Charge	*
93	REF_ENFORCMT_AMT	☐	CMS_DTE_CAG_LCHG_ENFC_REF_AMT	CMS_AMOUNT	CURR	17	2	Reference amount for part (Equal,Secondar) enforcebility
94	RANK	☐	CMS_DTE_CAG_LCHG_ENFC_RANK	CMS_CAG_LCHG_ENFC_RANK	NUMC	4	0	Rank of the Land Charge Enforceable Amount
95	ENFORCMT_TITLE	☐	CMS_DTE_IND_CAG_LCHG_ENFC_TITL	CMS_IND_CAG_LCHG_ENFC_TITLE	CHAR	2	0	Indicator for Enforcement Title
96	.INCLUDE	☐				0	0	Heritable building right (HBR) details
97	UNIT_INT_FREQ	☐	CMS_DTE_IND_CAG_HBR_INT_UNIT	CMS_IND_CAG_FREQ_UNIT	CHAR	2	0	Unit for period of Payment Frequency of HBR interest
98	PERIOD_INT_FREQ	☐	CMS_DTE_CAG_HBR_INT_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Payment Frequency Period for HBR interest
99	FLG_INTEREST_INC	☐	CMS_DTE_FLG_LCHG_INC_INT	CMS_FLG_LCHG_INC_INT	CHAR	1	0	Flag for increase in HBR interest
100	UNIT_INC_FREQ	☐	CMS_DTE_IND_CAG_HBR_INC_UNIT	CMS_IND_CAG_FREQ_UNIT	CHAR	2	0	Unit for Frequency Period of Increase in HBR Interest
101	PERIOD_INC_FREQ	☐	CMS_DTE_CAG_HBR_INC_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Frequency Period for Increase in HBR Interest
102	INC_PCT	☐	CMS_DTE_CAG_LCHG_INC_PCT	CMS_PCT	DEC	10	6	Percentage Increase in Heritable Building Rights Amount
103	INC_AMT	☐	CMS_DTE_CAG_LCHG_INC_AMT	CMS_AMOUNT	CURR	17	2	Increase in Heritable Building Rights Amount
104	INC_CURR	☐	CMS_DTE_CAG_LCHG_INC_AMT_CURR	WAERS	CUKY	5	0	Currency for Increase in HBR amount	*
105	INC_START_DATE	☐	CMS_DTE_CAG_LCHG_INC_START_DAT	CMS_DATE	DATS	8	0	Start date for Increase in Heritable Building Right Interest
106	IND_HBR_WAIVER	☐	CMS_DTE_IND_CAG_LCHG_HBR_WAIVE	CMS_IND_CAG_LCHG_HBR_WAIVER	CHAR	2	0	Indicator for Waiver of HBR Enforcement
107	INC_LAST_DATE	☐	CMS_DTE_CAG_LCHG_INC_LAST_DATE	CMS_DATE	DATS	8	0	Last date of Increase in Heritable Building Right Interest
108	.INCLUDE	☐				0	0	Land Charge specific details
109	FLG_COLL_LCHG	☐	CMS_DTE_FLG_CAG_LCHG_COLL	CMS_FLG_CAG_LCHG_COLLECTIVE	CHAR	1	0	Flag: Collective Land Charge
110	FLG_CHARGE_CERT	☐	CMS_DTE_FLG_CAG_LCHG_CERT	CMS_FLG_LCHG_CERT	CHAR	1	0	Flag: Land Charge certificate exists
111	CHARGE_CERT_NUM	☐	CMS_DTE_CAG_LCHG_CERT_NUM	CMS_LCHG_CERT_NUM	CHAR	30	0	Charge Certificate Number
112	FILE_NUM	☐	CMS_DTE_CAG_LCHG_FILE_NUM	CMS_LCHG_FILE_NUM	CHAR	30	0	File Number
113	.INCLUDE	☐				0	0	Insurance Coverage data
114	SCOPE_INS_COVER	☐	CMS_DTE_CAG_ATT_ID_TY_CAG004	CMS_ATT_ID_TYP	CHAR	6	0	Scope of Cover of Credit Insurance	TCMS_ATT_ID_TY
115	.INCLUDE	☐				0	0	Organization unit structure: Collateral Agreements
116	ORG_UNIT1	☐	CMS_DTE_CAG_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1: Collateral Agreement	*
117	ORG_UNIT2	☐	CMS_DTE_CAG_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2: Collateral Agreement	*
118	ORG_UNIT3	☐	CMS_DTE_CAG_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3: Collateral Agreement	*
119	ORG_UNIT4	☐	CMS_DTE_CAG_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4: Collateral Agreement	*
120	ORG_UNIT5	☐	CMS_DTE_CAG_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5: Collateral Agreement	*
121	.INCLUDE	☐				0	0	Liquidation data
122	LIQD_MODE	☐	CMS_DTE_LIQD_MODE	CMS_LIQD_MODE	CHAR	6	0	Mode of Liquidation decision for the pool agreement	*
123	.INCLUDE	☐				0	0	Correspondence related attributes for CAG
124	COR_ROLE	☐	CMS_DTE_COR_ROLE	CORR_ROLE_KK	CHAR	4	0	Correspondence role	TFK070M
125	.INCLUDE	☐				0	0	Agreement Thresholds
126	REL_THRESHOLD	☐	CMS_DTE_CAG_RELEASE_THRESHOLD	CMS_PCT	DEC	10	6	Limit above which the Collaterals can be Released from Pool

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_CAG_DATA	ASGMT_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
2	CMS_STR_CAG_DATA	ASMT_CURR	TCURC	WAERS	REF	1	CN
3	CMS_STR_CAG_DATA	COR_ROLE	TFK070M	CORR_ROLE
4	CMS_STR_CAG_DATA	MIN_QL_CRITE	TCMS_CAG_MQCRT	MIN_QL_CRITERION	REF	1	CN
5	CMS_STR_CAG_DATA	MIN_QL_EXCEP_TYP	TCMS_CAG_MQEXP	MIN_QL_EXCEP_TYP	REF	1	CN
6	CMS_STR_CAG_DATA	MIN_QL_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE
7	CMS_STR_CAG_DATA	MIN_STOCK_CURR	TCURC	WAERS	REF	1	CN
8	CMS_STR_CAG_DATA	NOM_VALUE_CURR	TCURC	WAERS	REF	1	CN
9	CMS_STR_CAG_DATA	SCOPE_INS_COVER	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
10	CMS_STR_CAG_DATA	TERM_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN

History

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