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