CMS_CAG - Collateral Agreement Details

Collateral Agreement Details information is stored in SAP table CMS_CAG.
It is part of development package CMS_CORE in software component FS-CMS-MD. This development package consists of objects that can be grouped under "Collateral Management System".

Fields for table CMS_CAG

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
.INCLUDE		X		CMS_STR_CAG_PKY	0
CAG_GUID	GUID for Table CMS_CAG	X	CMS_DTE_CAG_GUID	RAW	16
.INCLUDE				CMS_STR_CAG_SKY	0
CAGMTID	Collateral Agreement ID		CMS_DTE_CAGID	CHAR	80
CAGMT_TYPE	Collateral Agreement Type		CMS_DTE_CAG_TYP	CHAR	12	TCMS_CAG_TYP
.INCLUDE				CMS_STR_CAG_DATA	0
.INCLUDE				CMS_STR_CAG_NOMINAL_VALUE	0
NOM_VALUE	Nominal Value of the Collateral Agreement		CMS_DTE_CAG_NOMINAL_VALUE	CURR	9
NOM_VALUE_CURR	Currency for Nominal Value of the Collateral Agreement		CMS_DTE_CAG_NOMINAL_CURR	CUKY	10	TCURC
.INCLUDE				CMS_STR_CAG_ASMT_VALUE_DATA	0
ASMT_AMT	Assessment Amount		CMS_DTE_CAG_ASMT_AMT	CURR	9
ASMT_CURR	Currency of Assessment Value		CMS_DTE_CAG_ASMT_CURR	CUKY	10	TCURC
ASMT_DATE	Date on which the Assessment Value was Calculated		CMS_DTE_CAG_ASMT_DATE	DATS	16
.INCLUDE				CMS_STR_CAG_DATES_DB	0
CAGMT_DATE	Date on which Collateral Agreement was Concluded		CMS_DTE_CAG_DATE	DATS	16
VALID_FROM	Collateral Agreement Document Valid-from Date		CMS_DTE_CAG_VALID_FROM	NUMC	30
VALID_TO	Collateral Agreement Document Valid-to Date		CMS_DTE_CAG_VALID_TO	NUMC	30
.INCLUDE				CMS_STR_CAG_BASIC_DATA	0
.INCLUDE				CMS_STR_ADMINORG	0
ADMIN_ORG_UNIT	Administration Organizational Unit		CMS_DTE_ADMINORG	CHAR	24
.INCLUDE				CMS_STR_BANKAREA	0
BANKAREA	Bank Area in Collateral Management		CMS_DTE_BANKAREA	CHAR	8	*
COUNTRY_KEY	Jurisdiction Country/Region		CMS_DTE_COUNTRY_KEY	CHAR	6	*
FLG_GLOBAL	Flag to indicate a Global Collateral Agreement		CMS_DTE_FLG_CAG_GLOBAL	CHAR	2
SPL_MARKDOWN_PCT	Percentage of Special Markdown		CMS_DTE_CAG_SPL_MARKDOWN_PCT	DEC	6
SPL_MARKDOWN_AMT	Amount of Special Markdown		CMS_DTE_CAG_SPL_MARKDOWN_AMT	CURR	9
SPL_MRKDOWN_CURR	Currency for Amount of Special Markdown		CMS_DTE_CAG_SPL_MRKDWN_CURR	CUKY	10	*
DESCRIPTION	Description of Collateral Agreement		CMS_DTE_CAG_DESC	CHAR	60
UNIT_REL_FREQ	The unit for period of Release Frequency		CMS_DTE_IND_CAG_REL_FREQ_UNIT	CHAR	4
PERIOD_REL_FREQ	Period for Frequency of Release of Collateral Agreement		CMS_DTE_CAG_REL_FREQ_PERIOD	NUMC	8
OLD_CAGMTID	External/Old Collateral Agreement ID		CMS_DTE_OLD_CAGID	CHAR	80
.INCLUDE				CMS_STR_CAG_BII_DATA	0
MIN_QL_EXCEP_TYP	Exceptions for Minimum Risk Weight		CMS_DTE_CAG_MIN_QUAL_EXCEP_TYP	CHAR	12	TCMS_CAG_MQEXP
MIN_QL_REASON	Reason for the Minimum Qualitative Criterion		CMS_DTE_CAG_ATT_ID_TY_CAG001	CHAR	12	TCMS_ATT_ID_TY
FLG_MIN_QL_REQMT	Flag:Minimum requirements fulfilled for CAG(for Basel II)		CMS_DTE_FLG_CAG_MIN_QUAL_REQMT	CHAR	2
MIN_QL_CRITE	MInimum Qualitative Criterion		CMS_DTE_CAG_MIN_QUAL_CRITERION	CHAR	12	TCMS_CAG_MQCRT
.INCLUDE				CMS_STR_CAG_AST_DATA	0
PCT_ASSET_VAL	Percentage of the Asset Value used in Collateral Agreement		CMS_DTE_PCT_AST_VAL	DEC	6
.INCLUDE				CMS_STR_CAG_TERMINATION_DATA	0
TERM_RIGHT_TYP	Termination Right Type		CMS_DTE_TERM_RIGHT_TYP	CHAR	12
FIRST_TERM_DATE	First possible date of termination		CMS_DTE_CAG_TERM_FSTPOS_DATE	DATS	16
UNIT_TERM_FREQ	The Unit for Period of Termination Frequency		CMS_DTE_IND_CAG_TERM_FREQ_UNIT	CHAR	4
PERIOD_TERM_FREQ	Period for Frequency of Termination of Collateral Agreement		CMS_DTE_CAG_TERM_FREQ_PERIOD	NUMC	8
NOTICE_PRD_UNIT	The Unit for the Termination Notice Period		CMS_DTE_IND_CAG_NOTICE_UNIT	CHAR	4
REQ_NOTICE_PRD	Notice Period Required to Terminate Collateral Agreement		CMS_DTE_CAG_NOTICE_PERIOD	NUMC	8	*
TERM_NOTICE_DATE	Date on which Termination Notice was Sent		CMS_DTE_CAG_TERM_NOTICE_DATE	DATS	16
TERM_REASON	Termination Type		CMS_DTE_CAG_ATT_ID_TY_CAG002	CHAR	12	TCMS_ATT_ID_TY
TERM_GUAR_AMT	Amount of Guarantee in the event of Termination		CMS_DTE_CAG_TERM_VALUE	CURR	9
TERMINATION_CURR	Currency for Amount of Guarantee in the event of Termination		CMS_DTE_CAG_TERM_VALUE_CURR	CUKY	10	*
.INCLUDE				CMS_STR_CAG_GUAR_DATA	0
.INCLUDE				CMS_STR_CAG_GUAR_DETAILS	0
GUAR_RATE	Guarantee Rate		CMS_DTE_CAG_GUAR_RATE	DEC	6
FLG_COUNTER_GUAR	Flag for Counter Guarantee		CMS_DTE_FLG_CAG_CNTR_GUAR	CHAR	2
FLG_CO_GUAR	Flag for Co-guarantee		CMS_DTE_FLG_CAG_CO_GUAR	CHAR	2
FLG_FIXED_LIABTY	Flag for Fixed Liability		CMS_DTE_FLG_CAG_FIXED_LIABILTY	CHAR	2
FLG_DEF_LIABTY	Flag for Default Liability		CMS_DTE_FLG_CAG_DEF_LIABILITY	CHAR	2
PCT_DEF_LIABTY	Default Liability in %		CMS_DTE_FLG_CAG_PCT_DEF_LIABTY	DEC	6
FLG_INCL_CAG_LNK	Flag for back-up guarantee to be used in calculations or not		CMS_DTE_FLG_CAG_INCL_LINKED	CHAR	2
IND_APPR_AUTH	Approval from authorities		CMS_DTE_IND_CAG_APPR_AUTH	CHAR	4
FLG_ENFORCEABLE	Agreement directly enforceable		CMS_DTE_FLG_CAG_ENFORCEABLE	CHAR	2
LENDING_RATE	Lending Rate of a Guarantee		CMS_DTE_CAG_LRTE_PCT	DEC	6
.INCLUDE				CMS_STR_CAG_GUAR_REDU_DATA	0
UNIT_REDU_FREQ	Unit for Period of Frequency for Reduction in Guarantee Valu		CMS_DTE_IND_CAG_RED_FREQ_UNIT	CHAR	4
PERIOD_REDU_FREQ	Period for Frequency of Reduction in Value of Guarantee		CMS_DTE_CAG_RED_FREQ_PERIOD	NUMC	8
REDU_AMT	Reduction in Amount of Guarantee		CMS_DTE_CAG_REDU_AMT	CURR	9
REDU_CURR	Currency of the Reduced Amount of the Guarantee		CMS_DTE_CAG_REDU_AMT_CURR	CUKY	10	*
REDU_PCT	Percentage of Reduction in the Value of a Guarantee		CMS_DTE_CAG_REDU_PCT	DEC	6
REDU_START_DATE	Date from which Guarantee Value is Reduced		CMS_DTE_CAG_REDU_START_DATE	DATS	16
REDU_END_DATE	End Date for Reduction in Amount of Guarantee		CMS_DTE_CAG_REDU_END_DATE	DATS	16
REDU_LAST_DATE	Last date of reduction of value		CMS_DTE_CAG_REDU_LAST_DATE	DATS	16
.INCLUDE				CMS_STR_CAG_GUAR_ORI_DATA	0
ORI_VALUE	Original Protection of the Agreements		CMS_DTE_CAG_ORIGINAL_VALUE	CURR	9
ORI_VALUE_CURR	Currency of the Original Protection Value		CMS_DTE_ORI_VALUE_CURR	CUKY	10	*
.INCLUDE				CMS_STR_CAG_TRAN_DETAILS	0
FLG_LEASING_TXN	Flag: Transfer is part of a leasing transaction		CMS_DTE_FLG_CAG_LEASING_TXN	CHAR	2
IND_LESSOR_LIEN	Indicator for Lessor Lien on Collateral Agreement		CMS_DTE_IND_CAG_LESSOR_LIEN	CHAR	4	TCMS_CAG_LSRLN
IND_ACC_LIABLE	Specifies the applicability of accessories liability		CMS_DTE_IND_CAG_ACC_LIABLE	CHAR	4
FLG_ASGMT_AR	Flag for Assignment of Accounts Receivables(AR) from Sale		CMS_DTE_FLG_CAG_AR_FRM_SALE	CHAR	2
.INCLUDE				CMS_STR_CAG_ADDNL_RBL_DATA	0
MIN_STOCK_AMT	Minimum stock Amount agreed in the Collateral Agreement		CMS_DTE_CAG_MIN_STOCK_AMT	CURR	9
MIN_STOCK_CURR	Currency of the Minimum Stock Amount		CMS_DTE_CAG_MIN_STOCK_AMT_CURR	CUKY	10	TCURC
FLG_ADDNL_RBL	Flag for Additional receivable		CMS_DTE_FLG_CAG_ADDNL_RBL	CHAR	2
ADDNL_RBL_DATE	Date on which Additional Receivable was Accepted		CMS_DTE_CAG_DATE_ADDNL_RBL	DATS	16
.INCLUDE				CMS_STR_CAG_PLDG_ASGMT_DETAILS	0
IND_GBC_LIEN	GBC Lien on Agreement		CMS_DTE_IND_CAG_GBC_LIEN	CHAR	4	TCMS_CAG_GBCLN
FLG_DISCL	Flag to indicator whether the Agreement is disclosed or not		CMS_DTE_FLG_CAG_DISCL_PLEDGE	CHAR	2
DISCL_DATE	Date of Disclosure to Third-party Debtor		CMS_DTE_CAG_DISCL_DATE	DATS	16
.INCLUDE				CMS_STR_CAG_ASGMT_REASON	0
ASGMT_REASON	Reason for Assignment		CMS_DTE_CAG_ATT_ID_TY_CAG006	CHAR	12	TCMS_ATT_ID_TY
.INCLUDE				CMS_STR_CAG_LCHG_DATA	0
.INCLUDE				CMS_STR_CAG_LCHG_INT_DETAILS	0
INT_RATE	Land Charge Interest Rate		CMS_DTE_CAG_LCHG_INT_RATE	DEC	6
INCIDENTAL_PAYMT	Incidental Payments in Percentage		CMS_DTE_CAG_LCHG_INCD_PAYMT	DEC	6
UNIT_PMT_FREQ	The unit for period of payment frequency		CMS_DTE_IND_CAG_PYMT_FREQ_UNIT	CHAR	4
PERIOD_PMT_FREQ	Period for Frequency of Payment of Land Charge Interest		CMS_DTE_CAG_PYMT_FREQ_PERIOD	NUMC	8
INT_START_DATE	Start Date for Land Charge Interest Calculation		CMS_DTE_CAG_LCHG_INT_START_DAT	DATS	16
NUM_YR_LCHG_INT	Number of Years the Land Charge Interest can be Capitalized		CMS_DTE_CAG_LCHG_INT_YR	NUMC	8
.INCLUDE				CMS_STR_CAG_LCHG_ENFC_DETAILS	0
IND_ENFORCMT_TYP	Enforcement Type		CMS_DTE_IND_CAG_LCHG_ENFC_TYP	CHAR	4
ENFORCMT_AMT	Enforcement Amount		CMS_DTE_CAG_LCHG_ENFC_AMT	CURR	9
ENFORCMT_CURR	Currency for Enforcement Amount of Land Charge		CMS_DTE_CAG_LCHG_ENFC_AMT_CURR	CUKY	10	*
REF_ENFORCMT_AMT	Reference amount for part (Equal,Secondar) enforcebility		CMS_DTE_CAG_LCHG_ENFC_REF_AMT	CURR	9
RANK	Rank of the Land Charge Enforceable Amount		CMS_DTE_CAG_LCHG_ENFC_RANK	NUMC	8
ENFORCMT_TITLE	Indicator for Enforcement Title		CMS_DTE_IND_CAG_LCHG_ENFC_TITL	CHAR	4
.INCLUDE				CMS_STR_CAG_LCHG_HBR_DETAILS	0
UNIT_INT_FREQ	Unit for period of Payment Frequency of HBR interest		CMS_DTE_IND_CAG_HBR_INT_UNIT	CHAR	4
PERIOD_INT_FREQ	Payment Frequency Period for HBR interest		CMS_DTE_CAG_HBR_INT_PERIOD	NUMC	8
FLG_INTEREST_INC	Flag for increase in HBR interest		CMS_DTE_FLG_LCHG_INC_INT	CHAR	2
UNIT_INC_FREQ	Unit for Frequency Period of Increase in HBR Interest		CMS_DTE_IND_CAG_HBR_INC_UNIT	CHAR	4
PERIOD_INC_FREQ	Frequency Period for Increase in HBR Interest		CMS_DTE_CAG_HBR_INC_PERIOD	NUMC	8
INC_PCT	Percentage Increase in Heritable Building Rights Amount		CMS_DTE_CAG_LCHG_INC_PCT	DEC	6
INC_AMT	Increase in Heritable Building Rights Amount		CMS_DTE_CAG_LCHG_INC_AMT	CURR	9
INC_CURR	Currency for Increase in HBR amount		CMS_DTE_CAG_LCHG_INC_AMT_CURR	CUKY	10	*
INC_START_DATE	Start date for Increase in Heritable Building Right Interest		CMS_DTE_CAG_LCHG_INC_START_DAT	DATS	16
IND_HBR_WAIVER	Indicator for Waiver of HBR Enforcement		CMS_DTE_IND_CAG_LCHG_HBR_WAIVE	CHAR	4	TCMS_CAG_HBRWV
INC_LAST_DATE	Last date of Increase in Heritable Building Right Interest		CMS_DTE_CAG_LCHG_INC_LAST_DATE	DATS	16
.INCLUDE				CMS_STR_CAG_LCHG_DETAILS	0
FLG_COLL_LCHG	Flag: Collective Land Charge		CMS_DTE_FLG_CAG_LCHG_COLL	CHAR	2
FLG_CHARGE_CERT	Flag: Land Charge certificate exists		CMS_DTE_FLG_CAG_LCHG_CERT	CHAR	2
CHARGE_CERT_NUM	Charge Certificate Number		CMS_DTE_CAG_LCHG_CERT_NUM	CHAR	60
FILE_NUM	File Number		CMS_DTE_CAG_LCHG_FILE_NUM	CHAR	60
.INCLUDE				CMS_STR_CAG_INS_COVER_DATA	0
SCOPE_INS_COVER	Scope of Cover of Credit Insurance		CMS_DTE_CAG_ATT_ID_TY_CAG004	CHAR	12	TCMS_ATT_ID_TY
.INCLUDE				CMS_STR_CAG_ORG_UNIT	0
ORG_UNIT1	Organizational Unit 1: Collateral Agreement		CMS_DTE_CAG_ORG_UNIT1	CHAR	20	*
ORG_UNIT2	Organizational Unit 2: Collateral Agreement		CMS_DTE_CAG_ORG_UNIT2	CHAR	20	*
ORG_UNIT3	Organizational Unit 3: Collateral Agreement		CMS_DTE_CAG_ORG_UNIT3	CHAR	20	*
ORG_UNIT4	Organizational Unit 4: Collateral Agreement		CMS_DTE_CAG_ORG_UNIT4	CHAR	20	*
ORG_UNIT5	Organizational Unit 5: Collateral Agreement		CMS_DTE_CAG_ORG_UNIT5	CHAR	20	*
.INCLUDE				CMS_STR_CAG_LIQD_DATA	0
LIQD_MODE	Mode of Liquidation decision for the pool agreement		CMS_DTE_LIQD_MODE	CHAR	12	*
.INCLUDE				CMS_STR_CAG_COR_DATA	0
COR_ROLE	Correspondence role		CMS_DTE_COR_ROLE	CHAR	8	TFK070M
.INCLUDE				CMS_STR_CAG_THRESHOLD	0
REL_THRESHOLD	Limit above which the Collaterals can be Released from Pool		CMS_DTE_CAG_RELEASE_THRESHOLD	DEC	6
.INCLUDE				CMS_STR_LIQUIDATION_DATA	0
LIQD_TYP	Liquidation Type		CMS_DTE_LIQD_TYP	CHAR	12
LIQD_REASON	Liquidation Reason		CMS_DTE_ATT_ID_TY_AST004	CHAR	12	TCMS_ATT_ID_TY
LIQD_DATE	Date on which the Collateral was Liquidated		CMS_DTE_LIQD_DATE	DATS	16
LIQD_AMT	Returns from the Liquidation of Collateral		CMS_DTE_LIQD_VALUE	CURR	9
LIQD_CURR	Currency of Liquidation Value		CMS_DTE_LIQD_CURR	CUKY	10	TCURC
EXP_PRCD_AMNT	Expected Proceed Amount		CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CURR	9
EXP_PRCD_CURR	Currency: Expected Proceed		CMS_DTE_LIQ_EXP_PRCD_CURR	CUKY	10	TCURC
EXP_ACC_DATE	Expected accrual date		CMS_DTE_LIQ_EXP_ACCRUAL_DATE	DATS	16
OBJ_EXP_PRC_TIME	Expected Time of Proceeds		CMS_DTE_LIQ_OBJ_EXP_PRO_DATE	DATS	16
.INCLUDE				CMS_STR_LIQ_ACC_DET	0
ACC_NUMBER_LIQ	Account number for liquidation proceeds		CMS_DTE_LIQ_ACC_NUMBER	CHAR	70
BANK_CNTRY_LIQ	Key of Bank Country/Region		CMS_DTE_LIQ_BNK_CTRY_KY	CHAR	6	T005
BANK_KEY_LIQ	Bank Key		CMS_DTE_LIQ_BNK_KEY	CHAR	30
BANK_CTRLKEY_LIQ	Bank Control Key		BKONT	CHAR	4
.INCLUDE	CHG_HISTORY			CMS_STR_CHG_HISTORY	0
CREATED_BY	Login ID of the User who created the Record		CMS_DTE_USER	CHAR	24
CREATED_AT	Creation Timestamp		CMS_DTE_CREATED_AT	DEC	8
CHANGED_BY	Last Changed By		CMS_DTE_LAST_CHNG_USER	CHAR	24
CHANGED_AT	Change Timestamp		CMS_DTE_CHANGED_AT	DEC	8
SOURCEOFENTRY	Source of Entry		CMS_DTE_SOURCE_OF_ENTRY	CHAR	64
.INCLUDE	BPCA			CMS_STR_BUSINESS_PROCESS	0
BUPR_ID	Business Process ID		CMS_DTE_BUPR_ID	RAW	16
BUPR_TYPE_CODE	Business Process Type Code		CMS_DTE_BUPR_TYP_CODE	CHAR	12