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