SAP ABAP Table CMS_CAG (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 TRANSP    Transparent table 
Transparent table CMS_CAG   Table Relationship Diagram
Short Description Collateral Agreement Details    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 .INCLUDE       0   0   Primary Key for CMS_CAG  
3 CAG_GUID CMS_DTE_CAG_GUID SYSUUID RAW 16   0   GUID for Table CMS_CAG  
4 .INCLUDE       0   0   Semantic Key for Table CMS_CAG  
5 CAGMTID CMS_DTE_CAGID CMS_CAGID CHAR 40   0   Collateral Agreement ID  
6 CAGMT_TYPE CMS_DTE_CAG_TYP CMS_CAG_TYP CHAR 6   0   Collateral Agreement Type TCMS_CAG_TYP
7 .INCLUDE       0   0   Collateral Agreement Details  
8 .INCLUDE       0   0   Nominal Value for Collateral Agreement  
9 NOM_VALUE CMS_DTE_CAG_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Collateral Agreement  
10 NOM_VALUE_CURR CMS_DTE_CAG_NOMINAL_CURR WAERS CUKY 5   0   Currency for Nominal Value of the Collateral Agreement TCURC
11 .INCLUDE       0   0   Assessment Value details for a Collateral Agreement  
12 ASMT_AMT CMS_DTE_CAG_ASMT_AMT CMS_AMOUNT CURR 17   2   Assessment Amount  
13 ASMT_CURR CMS_DTE_CAG_ASMT_CURR WAERS CUKY 5   0   Currency of Assessment Value TCURC
14 ASMT_DATE CMS_DTE_CAG_ASMT_DATE CMS_DATE DATS 8   0   Date on which the Assessment Value was Calculated  
15 .INCLUDE       0   0   Collateral Agreement Dates (DB Format )  
16 CAGMT_DATE CMS_DTE_CAG_DATE CMS_DATE DATS 8   0   Date on which Collateral Agreement was Concluded  
17 VALID_FROM CMS_DTE_CAG_VALID_FROM TZNTSTMPSL NUMC 15   0   Collateral Agreement Document Valid-from Date  
18 VALID_TO CMS_DTE_CAG_VALID_TO TZNTSTMPSL NUMC 15   0   Collateral Agreement Document Valid-to Date  
19 .INCLUDE       0   0   Basic data for a Collateral Agreement  
20 .INCLUDE       0   0   Administrative organization unit  
21 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
22 .INCLUDE       0   0   Bank area  
23 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management *
24 COUNTRY_KEY CMS_DTE_COUNTRY_KEY LAND1 CHAR 3   0   Jurisdiction Country *
25 FLG_GLOBAL CMS_DTE_FLG_CAG_GLOBAL CMS_FLG_GLOBAL_CAGMT CHAR 1   0   Flag to indicate a Global Collateral Agreement  
26 SPL_MARKDOWN_PCT CMS_DTE_CAG_SPL_MARKDOWN_PCT CMS_PCT DEC 10   6   Percentage of Special Markdown  
27 SPL_MARKDOWN_AMT CMS_DTE_CAG_SPL_MARKDOWN_AMT CMS_AMOUNT CURR 17   2   Amount of Special Markdown  
28 SPL_MRKDOWN_CURR CMS_DTE_CAG_SPL_MRKDWN_CURR WAERS CUKY 5   0   Currency for Amount of Special Markdown *
29 DESCRIPTION CMS_DTE_CAG_DESC CMS_DSC CHAR 30   0   Description of Collateral Agreement  
30 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  
31 PERIOD_REL_FREQ CMS_DTE_CAG_REL_FREQ_PERIOD CMS_CAG_FREQ_PERIOD NUMC 4   0   Period for Frequency of Release of Collateral Agreement  
32 OLD_CAGMTID CMS_DTE_OLD_CAGID CMS_OLD_CAGID CHAR 40   0   External/Old Collateral Agreement ID  
33 .INCLUDE       0   0   Basel II relevant data  
34 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
35 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
36 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)  
37 MIN_QL_CRITE CMS_DTE_CAG_MIN_QUAL_CRITERION CMS_CAG_MIN_QUAL_CRITERION CHAR 6   0   MInimum Qualitative Criterion TCMS_CAG_MQCRT
38 .INCLUDE       0   0   Asset details for a Collateral Agreement  
39 PCT_ASSET_VAL CMS_DTE_PCT_AST_VAL CMS_PCT DEC 10   6   Percentage of the Asset Value used in Collateral Agreement  
40 .INCLUDE       0   0   Termination rights data  
41 TERM_RIGHT_TYP CMS_DTE_TERM_RIGHT_TYP CMS_CAG_TERM_RIGHT_TYP CHAR 6   0   Termination Right Type *
42 FIRST_TERM_DATE CMS_DTE_CAG_TERM_FSTPOS_DATE CMS_DATE DATS 8   0   First possible date of termination  
43 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  
44 PERIOD_TERM_FREQ CMS_DTE_CAG_TERM_FREQ_PERIOD CMS_CAG_FREQ_PERIOD NUMC 4   0   Period for Frequency of Termination of Collateral Agreement  
45 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  
46 REQ_NOTICE_PRD CMS_DTE_CAG_NOTICE_PERIOD CMS_CAG_FREQ_PERIOD NUMC 4   0   Notice Period Required to Terminate Collateral Agreement *
47 TERM_NOTICE_DATE CMS_DTE_CAG_TERM_NOTICE_DATE CMS_DATE DATS 8   0   Date on which Termination Notice was Sent  
48 TERM_REASON CMS_DTE_CAG_ATT_ID_TY_CAG002 CMS_ATT_ID_TYP CHAR 6   0   Termination Type TCMS_ATT_ID_TY
49 TERM_GUAR_AMT CMS_DTE_CAG_TERM_VALUE CMS_AMOUNT CURR 17   2   Amount of Guarantee in the event of Termination  
50 TERMINATION_CURR CMS_DTE_CAG_TERM_VALUE_CURR WAERS CUKY 5   0   Currency for Amount of Guarantee in the event of Termination *
51 .INCLUDE       0   0   Guarantee specific data  
52 .INCLUDE       0   0   Guarantee specific details  
53 GUAR_RATE CMS_DTE_CAG_GUAR_RATE CMS_PCT DEC 10   6   Guarantee Rate  
54 FLG_COUNTER_GUAR CMS_DTE_FLG_CAG_CNTR_GUAR CMS_FLG_CNTR_GUAR CHAR 1   0   Flag for Counter Guarantee  
55 FLG_CO_GUAR CMS_DTE_FLG_CAG_CO_GUAR CMS_FLG_CO_GUAR CHAR 1   0   Flag for Co-guarantee  
56 FLG_FIXED_LIABTY CMS_DTE_FLG_CAG_FIXED_LIABILTY CMS_FLG_FIXED_LIABILITY CHAR 1   0   Flag for Fixed Liability  
57 FLG_DEF_LIABTY CMS_DTE_FLG_CAG_DEF_LIABILITY CMS_FLG_DEF_LIABILITY CHAR 1   0   Flag for Default Liability  
58 PCT_DEF_LIABTY CMS_DTE_FLG_CAG_PCT_DEF_LIABTY CMS_PCT DEC 10   6   Default Liability in %  
59 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  
60 IND_APPR_AUTH CMS_DTE_IND_CAG_APPR_AUTH CMS_IND_CAG_APPR_AUTH CHAR 2   0   Approval from authorities  
61 FLG_ENFORCEABLE CMS_DTE_FLG_CAG_ENFORCEABLE CMS_FLG_DIR_ENFC CHAR 1   0   Agreement directly enforceable  
62 LENDING_RATE CMS_DTE_CAG_LRTE_PCT CMS_PCT DEC 10   6   Lending Rate of a Guarantee  
63 .INCLUDE       0   0   Reduction relation data  
64 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  
65 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  
66 REDU_AMT CMS_DTE_CAG_REDU_AMT CMS_AMOUNT CURR 17   2   Reduction in Amount of Guarantee  
67 REDU_CURR CMS_DTE_CAG_REDU_AMT_CURR WAERS CUKY 5   0   Currency of the Reduced Amount of the Guarantee *
68 REDU_PCT CMS_DTE_CAG_REDU_PCT CMS_PCT DEC 10   6   Percentage of Reduction in the Value of a Guarantee  
69 REDU_START_DATE CMS_DTE_CAG_REDU_START_DATE CMS_DATE DATS 8   0   Date from which Guarantee Value is Reduced  
70 REDU_END_DATE CMS_DTE_CAG_REDU_END_DATE CMS_DATE DATS 8   0   End Date for Reduction in Amount of Guarantee  
71 REDU_LAST_DATE CMS_DTE_CAG_REDU_LAST_DATE CMS_DATE DATS 8   0   Last date of reduction of value  
72 .INCLUDE       0   0   Transfer specific details  
73 FLG_LEASING_TXN CMS_DTE_FLG_CAG_LEASING_TXN CMS_FLG_LEASING_TRANSACTION CHAR 1   0   Flag: Transfer is part of a leasing transaction  
74 IND_LESSOR_LIEN CMS_DTE_IND_CAG_LESSOR_LIEN CMS_IND_CAG_LESSOR_LIEN CHAR 2   0   Indicator for Lessor Lien on Collateral Agreement  
75 IND_ACC_LIABLE CMS_DTE_IND_CAG_ACC_LIABLE CMS_IND_CAG_ACC_LIABLE CHAR 2   0   Specifies the applicability of accessories liability  
76 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  
77 .INCLUDE       0   0   Minimum stock data  
78 MIN_STOCK_AMT CMS_DTE_CAG_MIN_STOCK_AMT CMS_AMOUNT CURR 17   2   Minimum stock Amount agreed in the Collateral Agreement  
79 MIN_STOCK_CURR CMS_DTE_CAG_MIN_STOCK_AMT_CURR WAERS CUKY 5   0   Currency of the Minimum Stock Amount TCURC
80 FLG_ADDNL_RBL CMS_DTE_FLG_CAG_ADDNL_RBL CMS_FLG_ADDNL_RBL CHAR 1   0   Flag for Additional receivable  
81 ADDNL_RBL_DATE CMS_DTE_CAG_DATE_ADDNL_RBL CMS_DATE DATS 8   0   Date on which Additional Receivable was Accepted  
82 .INCLUDE       0   0   Pledge/Assignment details  
83 IND_GBC_LIEN CMS_DTE_IND_CAG_GBC_LIEN CMS_IND_CAG_GBC_LIEN CHAR 2   0   GBC Lien on Agreement  
84 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  
85 DISCL_DATE CMS_DTE_CAG_DISCL_DATE CMS_DATE DATS 8   0   Date of Disclosure to Third-party Debtor  
86 .INCLUDE       0   0   Assignment reason  
87 ASGMT_REASON CMS_DTE_CAG_ATT_ID_TY_CAG006 CMS_ATT_ID_TYP CHAR 6   0   Reason for Assignment TCMS_ATT_ID_TY
88 .INCLUDE       0   0   Land Charge specific data  
89 .INCLUDE       0   0   Land Charge specific interest details  
90 INT_RATE CMS_DTE_CAG_LCHG_INT_RATE CMS_PCT DEC 10   6   Land Charge Interest Rate  
91 INCIDENTAL_PAYMT CMS_DTE_CAG_LCHG_INCD_PAYMT CMS_PCT DEC 10   6   Incidental Payments in Percentage  
92 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  
93 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  
94 INT_START_DATE CMS_DTE_CAG_LCHG_INT_START_DAT CMS_DATE DATS 8   0   Start Date for Land Charge Interest Calculation  
95 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  
96 .INCLUDE       0   0   Enforcement details for a land charge  
97 IND_ENFORCMT_TYP CMS_DTE_IND_CAG_LCHG_ENFC_TYP CMS_IND_CAG_LCHG_ENFC_TYP CHAR 2   0   Enforcement Type  
98 ENFORCMT_AMT CMS_DTE_CAG_LCHG_ENFC_AMT CMS_AMOUNT CURR 17   2   Enforcement Amount  
99 ENFORCMT_CURR CMS_DTE_CAG_LCHG_ENFC_AMT_CURR WAERS CUKY 5   0   Currency for Enforcement Amount of Land Charge *
100 REF_ENFORCMT_AMT CMS_DTE_CAG_LCHG_ENFC_REF_AMT CMS_AMOUNT CURR 17   2   Reference amount for part (Equal,Secondar) enforcebility  
101 RANK CMS_DTE_CAG_LCHG_ENFC_RANK CMS_CAG_LCHG_ENFC_RANK NUMC 4   0   Rank of the Land Charge Enforceable Amount  
102 ENFORCMT_TITLE CMS_DTE_IND_CAG_LCHG_ENFC_TITL CMS_IND_CAG_LCHG_ENFC_TITLE CHAR 2   0   Indicator for Enforcement Title  
103 .INCLUDE       0   0   Heritable building right (HBR) details  
104 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  
105 PERIOD_INT_FREQ CMS_DTE_CAG_HBR_INT_PERIOD CMS_CAG_FREQ_PERIOD NUMC 4   0   Payment Frequency Period for HBR interest  
106 FLG_INTEREST_INC CMS_DTE_FLG_LCHG_INC_INT CMS_FLG_LCHG_INC_INT CHAR 1   0   Flag for increase in HBR interest  
107 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  
108 PERIOD_INC_FREQ CMS_DTE_CAG_HBR_INC_PERIOD CMS_CAG_FREQ_PERIOD NUMC 4   0   Frequency Period for Increase in HBR Interest  
109 INC_PCT CMS_DTE_CAG_LCHG_INC_PCT CMS_PCT DEC 10   6   Percentage Increase in Heritable Building Rights Amount  
110 INC_AMT CMS_DTE_CAG_LCHG_INC_AMT CMS_AMOUNT CURR 17   2   Increase in Heritable Building Rights Amount  
111 INC_CURR CMS_DTE_CAG_LCHG_INC_AMT_CURR WAERS CUKY 5   0   Currency for Increase in HBR amount *
112 INC_START_DATE CMS_DTE_CAG_LCHG_INC_START_DAT CMS_DATE DATS 8   0   Start date for Increase in Heritable Building Right Interest  
113 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  
114 INC_LAST_DATE CMS_DTE_CAG_LCHG_INC_LAST_DATE CMS_DATE DATS 8   0   Last date of Increase in Heritable Building Right Interest  
115 .INCLUDE       0   0   Land Charge specific details  
116 FLG_COLL_LCHG CMS_DTE_FLG_CAG_LCHG_COLL CMS_FLG_CAG_LCHG_COLLECTIVE CHAR 1   0   Flag: Collective Land Charge  
117 FLG_CHARGE_CERT CMS_DTE_FLG_CAG_LCHG_CERT CMS_FLG_LCHG_CERT CHAR 1   0   Flag: Land Charge certificate exists  
118 CHARGE_CERT_NUM CMS_DTE_CAG_LCHG_CERT_NUM CMS_LCHG_CERT_NUM CHAR 30   0   Charge Certificate Number  
119 FILE_NUM CMS_DTE_CAG_LCHG_FILE_NUM CMS_LCHG_FILE_NUM CHAR 30   0   File Number  
120 .INCLUDE       0   0   Insurance Coverage data  
121 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
122 .INCLUDE       0   0   Organization unit structure: Collateral Agreements  
123 ORG_UNIT1 CMS_DTE_CAG_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1: Collateral Agreement *
124 ORG_UNIT2 CMS_DTE_CAG_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2: Collateral Agreement *
125 ORG_UNIT3 CMS_DTE_CAG_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3: Collateral Agreement *
126 ORG_UNIT4 CMS_DTE_CAG_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4: Collateral Agreement *
127 ORG_UNIT5 CMS_DTE_CAG_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5: Collateral Agreement *
128 .INCLUDE       0   0   Liquidation data  
129 LIQD_MODE CMS_DTE_LIQD_MODE CMS_LIQD_MODE CHAR 6   0   Mode of Liquidation decision for the pool agreement *
130 .INCLUDE       0   0   Correspondence related attributes for CAG  
131 COR_ROLE CMS_DTE_COR_ROLE CORR_ROLE_KK CHAR 4   0   Correspondence role TFK070M
132 .INCLUDE       0   0   Agreement Thresholds  
133 REL_THRESHOLD CMS_DTE_CAG_RELEASE_THRESHOLD CMS_PCT DEC 10   6   Limit above which the Collaterals can be Released from Pool  
134 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
135 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
136 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
137 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
138 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
139 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CMS_CAG ASGMT_REASON TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
2 CMS_CAG ASMT_CURR TCURC WAERS REF 1 CN
3 CMS_CAG CAGMT_TYPE TCMS_CAG_TYP CAGMT_TYPE REF 1 CN
4 CMS_CAG COR_ROLE TFK070M CORR_ROLE    
5 CMS_CAG MANDT T000 MANDT KEY 1 CN
6 CMS_CAG MIN_QL_CRITE TCMS_CAG_MQCRT MIN_QL_CRITERION REF 1 CN
7 CMS_CAG MIN_QL_EXCEP_TYP TCMS_CAG_MQEXP MIN_QL_EXCEP_TYP REF 1 CN
8 CMS_CAG MIN_QL_REASON TCMS_ATT_ID_TY INDICATOR_TYPE    
9 CMS_CAG MIN_STOCK_CURR TCURC WAERS REF 1 CN
10 CMS_CAG NOM_VALUE_CURR TCURC WAERS REF 1 CN
11 CMS_CAG SCOPE_INS_COVER TCMS_ATT_ID_TY INDICATOR_TYPE    
12 CMS_CAG TERM_REASON TCMS_ATT_ID_TY INDICATOR_TYPE    
History
Last changed by/on SAP  20110901 
SAP Release Created in 110