SAP ABAP Table CMS_STR_CAG_SNG (Details for a single collateral agreement (without CAG_GUID))
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_SNG |
|
| Short Description | Details for a single collateral agreement (without CAG_GUID) |
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 | |
0 | 0 | Semantic Key for Table CMS_CAG | |||||
| 2 | |
CMS_DTE_CAGID | CMS_CAGID | CHAR | 40 | 0 | Collateral Agreement ID | ||
| 3 | |
CMS_DTE_CAG_TYP | CMS_CAG_TYP | CHAR | 6 | 0 | Collateral Agreement Type | * | |
| 4 | |
0 | 0 | Collateral Agreement Details | |||||
| 5 | |
0 | 0 | Nominal Value for Collateral Agreement | |||||
| 6 | |
CMS_DTE_CAG_NOMINAL_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Nominal Value of the Collateral Agreement | ||
| 7 | |
CMS_DTE_CAG_NOMINAL_CURR | WAERS | CUKY | 5 | 0 | Currency for Nominal Value of the Collateral Agreement | TCURC | |
| 8 | |
0 | 0 | Assessment Value details for a Collateral Agreement | |||||
| 9 | |
CMS_DTE_CAG_ASMT_AMT | CMS_AMOUNT | CURR | 17 | 2 | Assessment Amount | ||
| 10 | |
CMS_DTE_CAG_ASMT_CURR | WAERS | CUKY | 5 | 0 | Currency of Assessment Value | TCURC | |
| 11 | |
CMS_DTE_CAG_ASMT_DATE | CMS_DATE | DATS | 8 | 0 | Date on which the Assessment Value was Calculated | ||
| 12 | |
0 | 0 | Collateral Agreement Dates (DB Format ) | |||||
| 13 | |
CMS_DTE_CAG_DATE | CMS_DATE | DATS | 8 | 0 | Date on which Collateral Agreement was Concluded | ||
| 14 | |
CMS_DTE_CAG_VALID_FROM | TZNTSTMPSL | NUMC | 15 | 0 | Collateral Agreement Document Valid-from Date | ||
| 15 | |
CMS_DTE_CAG_VALID_TO | TZNTSTMPSL | NUMC | 15 | 0 | Collateral Agreement Document Valid-to Date | ||
| 16 | |
0 | 0 | Basic data for a Collateral Agreement | |||||
| 17 | |
0 | 0 | Administrative organization unit | |||||
| 18 | |
CMS_DTE_ADMINORG | TEXT12 | CHAR | 12 | 0 | Administration Organizational Unit | ||
| 19 | |
0 | 0 | Bank area | |||||
| 20 | |
CMS_DTE_BANKAREA | CMS_BANKAREA | CHAR | 4 | 0 | Bank Area in Collateral Management | * | |
| 21 | |
CMS_DTE_COUNTRY_KEY | LAND1 | CHAR | 3 | 0 | Jurisdiction Country | * | |
| 22 | |
CMS_DTE_FLG_CAG_GLOBAL | CMS_FLG_GLOBAL_CAGMT | CHAR | 1 | 0 | Flag to indicate a Global Collateral Agreement | ||
| 23 | |
CMS_DTE_CAG_SPL_MARKDOWN_PCT | CMS_PCT | DEC | 10 | 6 | Percentage of Special Markdown | ||
| 24 | |
CMS_DTE_CAG_SPL_MARKDOWN_AMT | CMS_AMOUNT | CURR | 17 | 2 | Amount of Special Markdown | ||
| 25 | |
CMS_DTE_CAG_SPL_MRKDWN_CURR | WAERS | CUKY | 5 | 0 | Currency for Amount of Special Markdown | * | |
| 26 | |
CMS_DTE_CAG_DESC | CMS_DSC | CHAR | 30 | 0 | Description of Collateral Agreement | ||
| 27 | |
CMS_DTE_IND_CAG_REL_FREQ_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | The unit for period of Release Frequency | ||
| 28 | |
CMS_DTE_CAG_REL_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Release of Collateral Agreement | ||
| 29 | |
CMS_DTE_OLD_CAGID | CMS_OLD_CAGID | CHAR | 40 | 0 | External/Old Collateral Agreement ID | ||
| 30 | |
0 | 0 | Basel II relevant data | |||||
| 31 | |
CMS_DTE_CAG_MIN_QUAL_EXCEP_TYP | CMS_CAG_MIN_QUAL_EXCEP_TYP | CHAR | 6 | 0 | Exceptions for Minimum Risk Weight | TCMS_CAG_MQEXP | |
| 32 | |
CMS_DTE_CAG_ATT_ID_TY_CAG001 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Reason for the Minimum Qualitative Criterion | TCMS_ATT_ID_TY | |
| 33 | |
CMS_DTE_FLG_CAG_MIN_QUAL_REQMT | CMS_FLG_MIN_QUAL_REQMT | CHAR | 1 | 0 | Flag:Minimum requirements fulfilled for CAG(for Basel II) | ||
| 34 | |
CMS_DTE_CAG_MIN_QUAL_CRITERION | CMS_CAG_MIN_QUAL_CRITERION | CHAR | 6 | 0 | MInimum Qualitative Criterion | TCMS_CAG_MQCRT | |
| 35 | |
0 | 0 | Asset details for a Collateral Agreement | |||||
| 36 | |
CMS_DTE_PCT_AST_VAL | CMS_PCT | DEC | 10 | 6 | Percentage of the Asset Value used in Collateral Agreement | ||
| 37 | |
0 | 0 | Termination rights data | |||||
| 38 | |
CMS_DTE_TERM_RIGHT_TYP | CMS_CAG_TERM_RIGHT_TYP | CHAR | 6 | 0 | Termination Right Type | * | |
| 39 | |
CMS_DTE_CAG_TERM_FSTPOS_DATE | CMS_DATE | DATS | 8 | 0 | First possible date of termination | ||
| 40 | |
CMS_DTE_IND_CAG_TERM_FREQ_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | The Unit for Period of Termination Frequency | ||
| 41 | |
CMS_DTE_CAG_TERM_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Termination of Collateral Agreement | ||
| 42 | |
CMS_DTE_IND_CAG_NOTICE_UNIT | CMS_IND_CAG_TIME_PRD_UNIT | CHAR | 2 | 0 | The Unit for the Termination Notice Period | ||
| 43 | |
CMS_DTE_CAG_NOTICE_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Notice Period Required to Terminate Collateral Agreement | * | |
| 44 | |
CMS_DTE_CAG_TERM_NOTICE_DATE | CMS_DATE | DATS | 8 | 0 | Date on which Termination Notice was Sent | ||
| 45 | |
CMS_DTE_CAG_ATT_ID_TY_CAG002 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Termination Type | TCMS_ATT_ID_TY | |
| 46 | |
CMS_DTE_CAG_TERM_VALUE | CMS_AMOUNT | CURR | 17 | 2 | Amount of Guarantee in the event of Termination | ||
| 47 | |
CMS_DTE_CAG_TERM_VALUE_CURR | WAERS | CUKY | 5 | 0 | Currency for Amount of Guarantee in the event of Termination | * | |
| 48 | |
0 | 0 | Guarantee specific data | |||||
| 49 | |
0 | 0 | Guarantee specific details | |||||
| 50 | |
CMS_DTE_CAG_GUAR_RATE | CMS_PCT | DEC | 10 | 6 | Guarantee Rate | ||
| 51 | |
CMS_DTE_FLG_CAG_CNTR_GUAR | CMS_FLG_CNTR_GUAR | CHAR | 1 | 0 | Flag for Counter Guarantee | ||
| 52 | |
CMS_DTE_FLG_CAG_CO_GUAR | CMS_FLG_CO_GUAR | CHAR | 1 | 0 | Flag for Co-guarantee | ||
| 53 | |
CMS_DTE_FLG_CAG_FIXED_LIABILTY | CMS_FLG_FIXED_LIABILITY | CHAR | 1 | 0 | Flag for Fixed Liability | ||
| 54 | |
CMS_DTE_FLG_CAG_DEF_LIABILITY | CMS_FLG_DEF_LIABILITY | CHAR | 1 | 0 | Flag for Default Liability | ||
| 55 | |
CMS_DTE_FLG_CAG_PCT_DEF_LIABTY | CMS_PCT | DEC | 10 | 6 | Default Liability in % | ||
| 56 | |
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 | ||
| 57 | |
CMS_DTE_IND_CAG_APPR_AUTH | CMS_IND_CAG_APPR_AUTH | CHAR | 2 | 0 | Approval from authorities | ||
| 58 | |
CMS_DTE_FLG_CAG_ENFORCEABLE | CMS_FLG_DIR_ENFC | CHAR | 1 | 0 | Agreement directly enforceable | ||
| 59 | |
CMS_DTE_CAG_LRTE_PCT | CMS_PCT | DEC | 10 | 6 | Lending Rate of a Guarantee | ||
| 60 | |
0 | 0 | Reduction relation data | |||||
| 61 | |
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 | ||
| 62 | |
CMS_DTE_CAG_RED_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Reduction in Value of Guarantee | ||
| 63 | |
CMS_DTE_CAG_REDU_AMT | CMS_AMOUNT | CURR | 17 | 2 | Reduction in Amount of Guarantee | ||
| 64 | |
CMS_DTE_CAG_REDU_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Reduced Amount of the Guarantee | * | |
| 65 | |
CMS_DTE_CAG_REDU_PCT | CMS_PCT | DEC | 10 | 6 | Percentage of Reduction in the Value of a Guarantee | ||
| 66 | |
CMS_DTE_CAG_REDU_START_DATE | CMS_DATE | DATS | 8 | 0 | Date from which Guarantee Value is Reduced | ||
| 67 | |
CMS_DTE_CAG_REDU_END_DATE | CMS_DATE | DATS | 8 | 0 | End Date for Reduction in Amount of Guarantee | ||
| 68 | |
CMS_DTE_CAG_REDU_LAST_DATE | CMS_DATE | DATS | 8 | 0 | Last date of reduction of value | ||
| 69 | |
0 | 0 | Transfer specific details | |||||
| 70 | |
CMS_DTE_FLG_CAG_LEASING_TXN | CMS_FLG_LEASING_TRANSACTION | CHAR | 1 | 0 | Flag: Transfer is part of a leasing transaction | ||
| 71 | |
CMS_DTE_IND_CAG_LESSOR_LIEN | CMS_IND_CAG_LESSOR_LIEN | CHAR | 2 | 0 | Indicator for Lessor Lien on Collateral Agreement | ||
| 72 | |
CMS_DTE_IND_CAG_ACC_LIABLE | CMS_IND_CAG_ACC_LIABLE | CHAR | 2 | 0 | Specifies the applicability of accessories liability | ||
| 73 | |
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 | ||
| 74 | |
0 | 0 | Minimum stock data | |||||
| 75 | |
CMS_DTE_CAG_MIN_STOCK_AMT | CMS_AMOUNT | CURR | 17 | 2 | Minimum stock Amount agreed in the Collateral Agreement | ||
| 76 | |
CMS_DTE_CAG_MIN_STOCK_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Minimum Stock Amount | TCURC | |
| 77 | |
CMS_DTE_FLG_CAG_ADDNL_RBL | CMS_FLG_ADDNL_RBL | CHAR | 1 | 0 | Flag for Additional receivable | ||
| 78 | |
CMS_DTE_CAG_DATE_ADDNL_RBL | CMS_DATE | DATS | 8 | 0 | Date on which Additional Receivable was Accepted | ||
| 79 | |
0 | 0 | Pledge/Assignment details | |||||
| 80 | |
CMS_DTE_IND_CAG_GBC_LIEN | CMS_IND_CAG_GBC_LIEN | CHAR | 2 | 0 | GBC Lien on Agreement | ||
| 81 | |
CMS_DTE_FLG_CAG_DISCL_PLEDGE | CMS_FLG_DISCL_PLEDGE | CHAR | 1 | 0 | Flag to indicator whether the Agreement is disclosed or not | ||
| 82 | |
CMS_DTE_CAG_DISCL_DATE | CMS_DATE | DATS | 8 | 0 | Date of Disclosure to Third-party Debtor | ||
| 83 | |
0 | 0 | Assignment reason | |||||
| 84 | |
CMS_DTE_CAG_ATT_ID_TY_CAG006 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Reason for Assignment | TCMS_ATT_ID_TY | |
| 85 | |
0 | 0 | Land Charge specific data | |||||
| 86 | |
0 | 0 | Land Charge specific interest details | |||||
| 87 | |
CMS_DTE_CAG_LCHG_INT_RATE | CMS_PCT | DEC | 10 | 6 | Land Charge Interest Rate | ||
| 88 | |
CMS_DTE_CAG_LCHG_INCD_PAYMT | CMS_PCT | DEC | 10 | 6 | Incidental Payments in Percentage | ||
| 89 | |
CMS_DTE_IND_CAG_PYMT_FREQ_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | The unit for period of payment frequency | ||
| 90 | |
CMS_DTE_CAG_PYMT_FREQ_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Period for Frequency of Payment of Land Charge Interest | ||
| 91 | |
CMS_DTE_CAG_LCHG_INT_START_DAT | CMS_DATE | DATS | 8 | 0 | Start Date for Land Charge Interest Calculation | ||
| 92 | |
CMS_DTE_CAG_LCHG_INT_YR | CMS_CAG_LCHG_INT_YR | NUMC | 4 | 0 | Number of Years the Land Charge Interest can be Capitalized | ||
| 93 | |
0 | 0 | Enforcement details for a land charge | |||||
| 94 | |
CMS_DTE_IND_CAG_LCHG_ENFC_TYP | CMS_IND_CAG_LCHG_ENFC_TYP | CHAR | 2 | 0 | Enforcement Type | ||
| 95 | |
CMS_DTE_CAG_LCHG_ENFC_AMT | CMS_AMOUNT | CURR | 17 | 2 | Enforcement Amount | ||
| 96 | |
CMS_DTE_CAG_LCHG_ENFC_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency for Enforcement Amount of Land Charge | * | |
| 97 | |
CMS_DTE_CAG_LCHG_ENFC_REF_AMT | CMS_AMOUNT | CURR | 17 | 2 | Reference amount for part (Equal,Secondar) enforcebility | ||
| 98 | |
CMS_DTE_CAG_LCHG_ENFC_RANK | CMS_CAG_LCHG_ENFC_RANK | NUMC | 4 | 0 | Rank of the Land Charge Enforceable Amount | ||
| 99 | |
CMS_DTE_IND_CAG_LCHG_ENFC_TITL | CMS_IND_CAG_LCHG_ENFC_TITLE | CHAR | 2 | 0 | Indicator for Enforcement Title | ||
| 100 | |
0 | 0 | Heritable building right (HBR) details | |||||
| 101 | |
CMS_DTE_IND_CAG_HBR_INT_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | Unit for period of Payment Frequency of HBR interest | ||
| 102 | |
CMS_DTE_CAG_HBR_INT_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Payment Frequency Period for HBR interest | ||
| 103 | |
CMS_DTE_FLG_LCHG_INC_INT | CMS_FLG_LCHG_INC_INT | CHAR | 1 | 0 | Flag for increase in HBR interest | ||
| 104 | |
CMS_DTE_IND_CAG_HBR_INC_UNIT | CMS_IND_CAG_FREQ_UNIT | CHAR | 2 | 0 | Unit for Frequency Period of Increase in HBR Interest | ||
| 105 | |
CMS_DTE_CAG_HBR_INC_PERIOD | CMS_CAG_FREQ_PERIOD | NUMC | 4 | 0 | Frequency Period for Increase in HBR Interest | ||
| 106 | |
CMS_DTE_CAG_LCHG_INC_PCT | CMS_PCT | DEC | 10 | 6 | Percentage Increase in Heritable Building Rights Amount | ||
| 107 | |
CMS_DTE_CAG_LCHG_INC_AMT | CMS_AMOUNT | CURR | 17 | 2 | Increase in Heritable Building Rights Amount | ||
| 108 | |
CMS_DTE_CAG_LCHG_INC_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency for Increase in HBR amount | * | |
| 109 | |
CMS_DTE_CAG_LCHG_INC_START_DAT | CMS_DATE | DATS | 8 | 0 | Start date for Increase in Heritable Building Right Interest | ||
| 110 | |
CMS_DTE_IND_CAG_LCHG_HBR_WAIVE | CMS_IND_CAG_LCHG_HBR_WAIVER | CHAR | 2 | 0 | Indicator for Waiver of HBR Enforcement | ||
| 111 | |
CMS_DTE_CAG_LCHG_INC_LAST_DATE | CMS_DATE | DATS | 8 | 0 | Last date of Increase in Heritable Building Right Interest | ||
| 112 | |
0 | 0 | Land Charge specific details | |||||
| 113 | |
CMS_DTE_FLG_CAG_LCHG_COLL | CMS_FLG_CAG_LCHG_COLLECTIVE | CHAR | 1 | 0 | Flag: Collective Land Charge | ||
| 114 | |
CMS_DTE_FLG_CAG_LCHG_CERT | CMS_FLG_LCHG_CERT | CHAR | 1 | 0 | Flag: Land Charge certificate exists | ||
| 115 | |
CMS_DTE_CAG_LCHG_CERT_NUM | CMS_LCHG_CERT_NUM | CHAR | 30 | 0 | Charge Certificate Number | ||
| 116 | |
CMS_DTE_CAG_LCHG_FILE_NUM | CMS_LCHG_FILE_NUM | CHAR | 30 | 0 | File Number | ||
| 117 | |
0 | 0 | Insurance Coverage data | |||||
| 118 | |
CMS_DTE_CAG_ATT_ID_TY_CAG004 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Scope of Cover of Credit Insurance | TCMS_ATT_ID_TY | |
| 119 | |
0 | 0 | Organization unit structure: Collateral Agreements | |||||
| 120 | |
CMS_DTE_CAG_ORG_UNIT1 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 1: Collateral Agreement | * | |
| 121 | |
CMS_DTE_CAG_ORG_UNIT2 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 2: Collateral Agreement | * | |
| 122 | |
CMS_DTE_CAG_ORG_UNIT3 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 3: Collateral Agreement | * | |
| 123 | |
CMS_DTE_CAG_ORG_UNIT4 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 4: Collateral Agreement | * | |
| 124 | |
CMS_DTE_CAG_ORG_UNIT5 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 5: Collateral Agreement | * | |
| 125 | |
0 | 0 | Liquidation data | |||||
| 126 | |
CMS_DTE_LIQD_MODE | CMS_LIQD_MODE | CHAR | 6 | 0 | Mode of Liquidation decision for the pool agreement | * | |
| 127 | |
0 | 0 | Correspondence related attributes for CAG | |||||
| 128 | |
CMS_DTE_COR_ROLE | CORR_ROLE_KK | CHAR | 4 | 0 | Correspondence role | TFK070M | |
| 129 | |
0 | 0 | Agreement Thresholds | |||||
| 130 | |
CMS_DTE_CAG_RELEASE_THRESHOLD | CMS_PCT | DEC | 10 | 6 | Limit above which the Collaterals can be Released from Pool | ||
| 131 | |
0 | 0 | Stucture to record history of changes in all application tab | |||||
| 132 | |
CMS_DTE_USER | CMS_USER | CHAR | 12 | 0 | Login ID of the User who created the Record | ||
| 133 | |
CMS_DTE_CREATED_AT | TZNTSTMPS | DEC | 15 | 0 | Creation Timestamp | ||
| 134 | |
CMS_DTE_LAST_CHNG_USER | CMS_USER | CHAR | 12 | 0 | Last Changed By | ||
| 135 | |
CMS_DTE_CHANGED_AT | TZNTSTMPS | DEC | 15 | 0 | Change Timestamp | ||
| 136 | |
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_SNG | ASGMT_REASON | |
|
REF | 1 | CN |
| 2 | CMS_STR_CAG_SNG | ASMT_CURR | |
|
REF | 1 | CN |
| 3 | CMS_STR_CAG_SNG | COR_ROLE | |
|
|||
| 4 | CMS_STR_CAG_SNG | MIN_QL_CRITE | |
|
REF | 1 | CN |
| 5 | CMS_STR_CAG_SNG | MIN_QL_EXCEP_TYP | |
|
REF | 1 | CN |
| 6 | CMS_STR_CAG_SNG | MIN_QL_REASON | |
|
|||
| 7 | CMS_STR_CAG_SNG | MIN_STOCK_CURR | |
|
REF | 1 | CN |
| 8 | CMS_STR_CAG_SNG | NOM_VALUE_CURR | |
|
REF | 1 | CN |
| 9 | CMS_STR_CAG_SNG | SCOPE_INS_COVER | |
|
REF | 1 | CN |
| 10 | CMS_STR_CAG_SNG | TERM_REASON | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in | 200 |