SAP ABAP Table CMS_STR_OVR_DETAILS_CAG (Collateral Overview : Required CAG details)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-CAL (Application Component) Calculations
     ⤷ CMS_CORE_ANL (Package) Analysis

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_OVR_DETAILS_CAG	Table Relationship Diagram
Short Description	Collateral Overview : Required CAG 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	Primary Key for CMS_CAG
2	CAG_GUID	☐	CMS_DTE_CAG_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_CAG
3	.INCLUDE	☐				0	0	Semantic Key for Table CMS_CAG
4	CAGMTID	☐	CMS_DTE_CAGID	CMS_CAGID	CHAR	40	0	Collateral Agreement ID
5	CAGMT_TYPE	☐	CMS_DTE_CAG_TYP	CMS_CAG_TYP	CHAR	6	0	Collateral Agreement Type	*
6	.INCLUDE	☐				0	0	Nominal Value for Collateral Agreement
7	NOM_VALUE	☐	CMS_DTE_CAG_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Collateral Agreement
8	NOM_VALUE_CURR	☐	CMS_DTE_CAG_NOMINAL_CURR	WAERS	CUKY	5	0	Currency for Nominal Value of the Collateral Agreement	TCURC
9	.INCLUDE	☐				0	0	Assessment Value details for a Collateral Agreement
10	ASMT_AMT	☐	CMS_DTE_CAG_ASMT_AMT	CMS_AMOUNT	CURR	17	2	Assessment Amount
11	ASMT_CURR	☐	CMS_DTE_CAG_ASMT_CURR	WAERS	CUKY	5	0	Currency of Assessment Value	TCURC
12	ASMT_DATE	☐	CMS_DTE_CAG_ASMT_DATE	CMS_DATE	DATS	8	0	Date on which the Assessment Value was Calculated
13	.INCLUDE	☐				0	0	Collateral Agreement Dates (DB Format )
14	CAGMT_DATE	☐	CMS_DTE_CAG_DATE	CMS_DATE	DATS	8	0	Date on which Collateral Agreement was Concluded
15	VALID_FROM	☐	CMS_DTE_CAG_VALID_FROM	TZNTSTMPSL	NUMC	15	0	Collateral Agreement Document Valid-from Date
16	VALID_TO	☐	CMS_DTE_CAG_VALID_TO	TZNTSTMPSL	NUMC	15	0	Collateral Agreement Document Valid-to Date
17	.INCLUDE	☐				0	0	Bank area
18	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
19	COUNTRY_KEY	☐	CMS_DTE_COUNTRY_KEY	LAND1	CHAR	3	0	Jurisdiction Country	*
20	FLG_GLOBAL	☐	CMS_DTE_FLG_CAG_GLOBAL	CMS_FLG_GLOBAL_CAGMT	CHAR	1	0	Flag to indicate a Global Collateral Agreement
21	SPL_MARKDOWN_PCT	☐	CMS_DTE_CAG_SPL_MARKDOWN_PCT	CMS_PCT	DEC	10	6	Percentage of Special Markdown
22	SPL_MARKDOWN_AMT	☐	CMS_DTE_CAG_SPL_MARKDOWN_AMT	CMS_AMOUNT	CURR	17	2	Amount of Special Markdown
23	DESCRIPTION	☐	CMS_DTE_CAG_DESC	CMS_DSC	CHAR	30	0	Description of Collateral Agreement
24	GUAR_RATE	☐	CMS_DTE_CAG_GUAR_RATE	CMS_PCT	DEC	10	6	Guarantee Rate
25	FLG_FIXED_LIABTY	☐	CMS_DTE_FLG_CAG_FIXED_LIABILTY	CMS_FLG_FIXED_LIABILITY	CHAR	1	0	Flag for Fixed Liability
26	FLG_DEF_LIABTY	☐	CMS_DTE_FLG_CAG_DEF_LIABILITY	CMS_FLG_DEF_LIABILITY	CHAR	1	0	Flag for Default Liability
27	PCT_DEF_LIABTY	☐	CMS_DTE_FLG_CAG_PCT_DEF_LIABTY	CMS_PCT	DEC	10	6	Default Liability in %
28	PCT_ASSET_VAL	☐	CMS_DTE_PCT_AST_VAL	CMS_PCT	DEC	10	6	Percentage of the Asset Value used in Collateral Agreement
29	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
30	LENDING_RATE	☐	CMS_DTE_CAG_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1 of a Guarantee
31	IND_LESSOR_LIEN	☐	CMS_DTE_IND_CAG_LESSOR_LIEN	CMS_IND_CAG_LESSOR_LIEN	CHAR	2	0	Indicator for Lessor Lien on Collateral Agreement
32	IND_ACC_LIABLE	☐	CMS_DTE_IND_CAG_ACC_LIABLE	CMS_IND_CAG_ACC_LIABLE	CHAR	2	0	Specifies the applicability of accessories liability
33	IND_GBC_LIEN	☐	CMS_DTE_IND_CAG_GBC_WAIVER	CMS_IND_CAG_GBC_LIEN	CHAR	2	0	GBC Lien on Collateral Agreement
34	FLG_COLL_LCHG	☐	CMS_DTE_FLG_CAG_LCHG_COLL	CMS_FLG_CAG_LCHG_COLLECTIVE	CHAR	1	0	Flag: Collective Land Charge

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_OVR_DETAILS_CAG	ASMT_CURR	TCURC	WAERS	REF	1	CN
2	CMS_STR_OVR_DETAILS_CAG	NOM_VALUE_CURR	TCURC	WAERS	REF	1	CN

History

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