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