The CMS_CAG table in SAP ERP or S/4HANA stores Collateral Agreement Details data. There are total 126 fields in CMS_CAG table. The Collateral Agreement Details table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMS_CAG table. It is in Collateral Management System (CMS_CORE) ABAP package and is part of the Master Data (FS-CMS-MD) module.
SAP CMS_CAG Table Fields
Following is the list of fields that are available in SAP CMS_CAG table. The primary key fields of the table are MANDT (Client), CAG_GUID (GUID for Table CMS_CAG).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| CAG_GUID | GUID for Table CMS_CAG | CMS_DTE_CAG_GUID | RAW (16) | |
| CAGMTID | Collateral Agreement ID | CMS_DTE_CAGID | CHAR (40) | |
| CAGMT_TYPE | Collateral Agreement Type | CMS_DTE_CAG_TYP | TCMS_CAG_TYP | CHAR (6) |
| NOM_VALUE | Nominal Value of the Collateral Agreement | CMS_DTE_CAG_NOMINAL_VALUE | CURR (17) | |
| NOM_VALUE_CURR | Currency for Nominal Value of the Collateral Agreement | CMS_DTE_CAG_NOMINAL_CURR | TCURC | CUKY (5) |
| ASMT_AMT | Assessment Amount | CMS_DTE_CAG_ASMT_AMT | CURR (17) | |
| ASMT_CURR | Currency of Assessment Value | CMS_DTE_CAG_ASMT_CURR | TCURC | CUKY (5) |
| ASMT_DATE | Date on which the Assessment Value was Calculated | CMS_DTE_CAG_ASMT_DATE | DATS (8) | |
| CAGMT_DATE | Date on which Collateral Agreement was Concluded | CMS_DTE_CAG_DATE | DATS (8) | |
| VALID_FROM | Collateral Agreement Document Valid-from Date | CMS_DTE_CAG_VALID_FROM | NUMC (15) | |
| VALID_TO | Collateral Agreement Document Valid-to Date | CMS_DTE_CAG_VALID_TO | NUMC (15) | |
| ADMIN_ORG_UNIT | Administration Organizational Unit | CMS_DTE_ADMINORG | CHAR (12) | |
| BANKAREA | Bank Area in Collateral Management | CMS_DTE_BANKAREA | * | CHAR (4) |
| COUNTRY_KEY | Jurisdiction Country | CMS_DTE_COUNTRY_KEY | * | CHAR (3) |
| FLG_GLOBAL | Flag to indicate a Global Collateral Agreement | CMS_DTE_FLG_CAG_GLOBAL | CHAR (1) | |
| SPL_MARKDOWN_PCT | Percentage of Special Markdown | CMS_DTE_CAG_SPL_MARKDOWN_PCT | DEC (10) | |
| SPL_MARKDOWN_AMT | Amount of Special Markdown | CMS_DTE_CAG_SPL_MARKDOWN_AMT | CURR (17) | |
| SPL_MRKDOWN_CURR | Currency for Amount of Special Markdown | CMS_DTE_CAG_SPL_MRKDWN_CURR | * | CUKY (5) |
| DESCRIPTION | Description of Collateral Agreement | CMS_DTE_CAG_DESC | CHAR (30) | |
| UNIT_REL_FREQ | The unit for period of Release Frequency | CMS_DTE_IND_CAG_REL_FREQ_UNIT | CHAR (2) | |
| PERIOD_REL_FREQ | Period for Frequency of Release of Collateral Agreement | CMS_DTE_CAG_REL_FREQ_PERIOD | NUMC (4) | |
| OLD_CAGMTID | External/Old Collateral Agreement ID | CMS_DTE_OLD_CAGID | CHAR (40) | |
| MIN_QL_EXCEP_TYP | Exceptions for Minimum Risk Weight | CMS_DTE_CAG_MIN_QUAL_EXCEP_TYP | TCMS_CAG_MQEXP | CHAR (6) |
| MIN_QL_REASON | Reason for the Minimum Qualitative Criterion | CMS_DTE_CAG_ATT_ID_TY_CAG001 | TCMS_ATT_ID_TY | CHAR (6) |
| FLG_MIN_QL_REQMT | Flag:Minimum requirements fulfilled for CAG(for Basel II) | CMS_DTE_FLG_CAG_MIN_QUAL_REQMT | CHAR (1) | |
| MIN_QL_CRITE | MInimum Qualitative Criterion | CMS_DTE_CAG_MIN_QUAL_CRITERION | TCMS_CAG_MQCRT | CHAR (6) |
| PCT_ASSET_VAL | Percentage of the Asset Value used in Collateral Agreement | CMS_DTE_PCT_AST_VAL | DEC (10) | |
| TERM_RIGHT_TYP | Termination Right Type | CMS_DTE_TERM_RIGHT_TYP | CHAR (6) | |
| FIRST_TERM_DATE | First possible date of termination | CMS_DTE_CAG_TERM_FSTPOS_DATE | DATS (8) | |
| UNIT_TERM_FREQ | The Unit for Period of Termination Frequency | CMS_DTE_IND_CAG_TERM_FREQ_UNIT | CHAR (2) | |
| PERIOD_TERM_FREQ | Period for Frequency of Termination of Collateral Agreement | CMS_DTE_CAG_TERM_FREQ_PERIOD | NUMC (4) | |
| NOTICE_PRD_UNIT | The Unit for the Termination Notice Period | CMS_DTE_IND_CAG_NOTICE_UNIT | CHAR (2) | |
| REQ_NOTICE_PRD | Notice Period Required to Terminate Collateral Agreement | CMS_DTE_CAG_NOTICE_PERIOD | * | NUMC (4) |
| TERM_NOTICE_DATE | Date on which Termination Notice was Sent | CMS_DTE_CAG_TERM_NOTICE_DATE | DATS (8) | |
| TERM_REASON | Termination Type | CMS_DTE_CAG_ATT_ID_TY_CAG002 | TCMS_ATT_ID_TY | CHAR (6) |
| TERM_GUAR_AMT | Amount of Guarantee in the event of Termination | CMS_DTE_CAG_TERM_VALUE | CURR (17) | |
| TERMINATION_CURR | Currency for Amount of Guarantee in the event of Termination | CMS_DTE_CAG_TERM_VALUE_CURR | * | CUKY (5) |
| GUAR_RATE | Guarantee Rate | CMS_DTE_CAG_GUAR_RATE | DEC (10) | |
| FLG_COUNTER_GUAR | Flag for Counter Guarantee | CMS_DTE_FLG_CAG_CNTR_GUAR | CHAR (1) | |
| FLG_CO_GUAR | Flag for Co-guarantee | CMS_DTE_FLG_CAG_CO_GUAR | CHAR (1) | |
| FLG_FIXED_LIABTY | Flag for Fixed Liability | CMS_DTE_FLG_CAG_FIXED_LIABILTY | CHAR (1) | |
| FLG_DEF_LIABTY | Flag for Default Liability | CMS_DTE_FLG_CAG_DEF_LIABILITY | CHAR (1) | |
| PCT_DEF_LIABTY | Default Liability in % | CMS_DTE_FLG_CAG_PCT_DEF_LIABTY | DEC (10) | |
| FLG_INCL_CAG_LNK | Flag for back-up guarantee to be used in calculations or not | CMS_DTE_FLG_CAG_INCL_LINKED | CHAR (1) | |
| IND_APPR_AUTH | Approval from authorities | CMS_DTE_IND_CAG_APPR_AUTH | CHAR (2) | |
| FLG_ENFORCEABLE | Agreement directly enforceable | CMS_DTE_FLG_CAG_ENFORCEABLE | CHAR (1) | |
| LENDING_RATE | Lending Rate of a Guarantee | CMS_DTE_CAG_LRTE_PCT | DEC (10) | |
| UNIT_REDU_FREQ | Unit for Period of Frequency for Reduction in Guarantee Valu | CMS_DTE_IND_CAG_RED_FREQ_UNIT | CHAR (2) | |
| PERIOD_REDU_FREQ | Period for Frequency of Reduction in Value of Guarantee | CMS_DTE_CAG_RED_FREQ_PERIOD | NUMC (4) | |
| REDU_AMT | Reduction in Amount of Guarantee | CMS_DTE_CAG_REDU_AMT | CURR (17) | |
| REDU_CURR | Currency of the Reduced Amount of the Guarantee | CMS_DTE_CAG_REDU_AMT_CURR | * | CUKY (5) |
| REDU_PCT | Percentage of Reduction in the Value of a Guarantee | CMS_DTE_CAG_REDU_PCT | DEC (10) | |
| REDU_START_DATE | Date from which Guarantee Value is Reduced | CMS_DTE_CAG_REDU_START_DATE | DATS (8) | |
| REDU_END_DATE | End Date for Reduction in Amount of Guarantee | CMS_DTE_CAG_REDU_END_DATE | DATS (8) | |
| REDU_LAST_DATE | Last date of reduction of value | CMS_DTE_CAG_REDU_LAST_DATE | DATS (8) | |
| ORI_VALUE | Original Protection of the Agreements | CMS_DTE_CAG_ORIGINAL_VALUE | CURR (17) | |
| ORI_VALUE_CURR | Currency of the Original Protection Value | CMS_DTE_ORI_VALUE_CURR | * | CUKY (5) |
| FLG_LEASING_TXN | Flag: Transfer is part of a leasing transaction | CMS_DTE_FLG_CAG_LEASING_TXN | CHAR (1) | |
| IND_LESSOR_LIEN | Indicator for Lessor Lien on Collateral Agreement | CMS_DTE_IND_CAG_LESSOR_LIEN | TCMS_CAG_LSRLN | CHAR (2) |
| IND_ACC_LIABLE | Specifies the applicability of accessories liability | CMS_DTE_IND_CAG_ACC_LIABLE | CHAR (2) | |
| FLG_ASGMT_AR | Flag for Assignment of Accounts Receivables(AR) from Sale | CMS_DTE_FLG_CAG_AR_FRM_SALE | CHAR (1) | |
| MIN_STOCK_AMT | Minimum stock Amount agreed in the Collateral Agreement | CMS_DTE_CAG_MIN_STOCK_AMT | CURR (17) | |
| MIN_STOCK_CURR | Currency of the Minimum Stock Amount | CMS_DTE_CAG_MIN_STOCK_AMT_CURR | TCURC | CUKY (5) |
| FLG_ADDNL_RBL | Flag for Additional receivable | CMS_DTE_FLG_CAG_ADDNL_RBL | CHAR (1) | |
| ADDNL_RBL_DATE | Date on which Additional Receivable was Accepted | CMS_DTE_CAG_DATE_ADDNL_RBL | DATS (8) | |
| IND_GBC_LIEN | GBC Lien on Agreement | CMS_DTE_IND_CAG_GBC_LIEN | TCMS_CAG_GBCLN | CHAR (2) |
| FLG_DISCL | Flag to indicator whether the Agreement is disclosed or not | CMS_DTE_FLG_CAG_DISCL_PLEDGE | CHAR (1) | |
| DISCL_DATE | Date of Disclosure to Third-party Debtor | CMS_DTE_CAG_DISCL_DATE | DATS (8) | |
| ASGMT_REASON | Reason for Assignment | CMS_DTE_CAG_ATT_ID_TY_CAG006 | TCMS_ATT_ID_TY | CHAR (6) |
| INT_RATE | Land Charge Interest Rate | CMS_DTE_CAG_LCHG_INT_RATE | DEC (10) | |
| INCIDENTAL_PAYMT | Incidental Payments in Percentage | CMS_DTE_CAG_LCHG_INCD_PAYMT | DEC (10) | |
| UNIT_PMT_FREQ | The unit for period of payment frequency | CMS_DTE_IND_CAG_PYMT_FREQ_UNIT | CHAR (2) | |
| PERIOD_PMT_FREQ | Period for Frequency of Payment of Land Charge Interest | CMS_DTE_CAG_PYMT_FREQ_PERIOD | NUMC (4) | |
| INT_START_DATE | Start Date for Land Charge Interest Calculation | CMS_DTE_CAG_LCHG_INT_START_DAT | DATS (8) | |
| NUM_YR_LCHG_INT | Number of Years the Land Charge Interest can be Capitalized | CMS_DTE_CAG_LCHG_INT_YR | NUMC (4) | |
| IND_ENFORCMT_TYP | Enforcement Type | CMS_DTE_IND_CAG_LCHG_ENFC_TYP | CHAR (2) | |
| ENFORCMT_AMT | Enforcement Amount | CMS_DTE_CAG_LCHG_ENFC_AMT | CURR (17) | |
| ENFORCMT_CURR | Currency for Enforcement Amount of Land Charge | CMS_DTE_CAG_LCHG_ENFC_AMT_CURR | * | CUKY (5) |
| REF_ENFORCMT_AMT | Reference amount for part (Equal,Secondar) enforcebility | CMS_DTE_CAG_LCHG_ENFC_REF_AMT | CURR (17) | |
| RANK | Rank of the Land Charge Enforceable Amount | CMS_DTE_CAG_LCHG_ENFC_RANK | NUMC (4) | |
| ENFORCMT_TITLE | Indicator for Enforcement Title | CMS_DTE_IND_CAG_LCHG_ENFC_TITL | CHAR (2) | |
| UNIT_INT_FREQ | Unit for period of Payment Frequency of HBR interest | CMS_DTE_IND_CAG_HBR_INT_UNIT | CHAR (2) | |
| PERIOD_INT_FREQ | Payment Frequency Period for HBR interest | CMS_DTE_CAG_HBR_INT_PERIOD | NUMC (4) | |
| FLG_INTEREST_INC | Flag for increase in HBR interest | CMS_DTE_FLG_LCHG_INC_INT | CHAR (1) | |
| UNIT_INC_FREQ | Unit for Frequency Period of Increase in HBR Interest | CMS_DTE_IND_CAG_HBR_INC_UNIT | CHAR (2) | |
| PERIOD_INC_FREQ | Frequency Period for Increase in HBR Interest | CMS_DTE_CAG_HBR_INC_PERIOD | NUMC (4) | |
| INC_PCT | Percentage Increase in Heritable Building Rights Amount | CMS_DTE_CAG_LCHG_INC_PCT | DEC (10) | |
| INC_AMT | Increase in Heritable Building Rights Amount | CMS_DTE_CAG_LCHG_INC_AMT | CURR (17) | |
| INC_CURR | Currency for Increase in HBR amount | CMS_DTE_CAG_LCHG_INC_AMT_CURR | * | CUKY (5) |
| INC_START_DATE | Start date for Increase in Heritable Building Right Interest | CMS_DTE_CAG_LCHG_INC_START_DAT | DATS (8) | |
| IND_HBR_WAIVER | Indicator for Waiver of HBR Enforcement | CMS_DTE_IND_CAG_LCHG_HBR_WAIVE | TCMS_CAG_HBRWV | CHAR (2) |
| INC_LAST_DATE | Last date of Increase in Heritable Building Right Interest | CMS_DTE_CAG_LCHG_INC_LAST_DATE | DATS (8) | |
| FLG_COLL_LCHG | Flag: Collective Land Charge | CMS_DTE_FLG_CAG_LCHG_COLL | CHAR (1) | |
| FLG_CHARGE_CERT | Flag: Land Charge certificate exists | CMS_DTE_FLG_CAG_LCHG_CERT | CHAR (1) | |
| CHARGE_CERT_NUM | Charge Certificate Number | CMS_DTE_CAG_LCHG_CERT_NUM | CHAR (30) | |
| FILE_NUM | File Number | CMS_DTE_CAG_LCHG_FILE_NUM | CHAR (30) | |
| SCOPE_INS_COVER | Scope of Cover of Credit Insurance | CMS_DTE_CAG_ATT_ID_TY_CAG004 | TCMS_ATT_ID_TY | CHAR (6) |
| ORG_UNIT1 | Organizational Unit 1: Collateral Agreement | CMS_DTE_CAG_ORG_UNIT1 | * | CHAR (10) |
| ORG_UNIT2 | Organizational Unit 2: Collateral Agreement | CMS_DTE_CAG_ORG_UNIT2 | * | CHAR (10) |
| ORG_UNIT3 | Organizational Unit 3: Collateral Agreement | CMS_DTE_CAG_ORG_UNIT3 | * | CHAR (10) |
| ORG_UNIT4 | Organizational Unit 4: Collateral Agreement | CMS_DTE_CAG_ORG_UNIT4 | * | CHAR (10) |
| ORG_UNIT5 | Organizational Unit 5: Collateral Agreement | CMS_DTE_CAG_ORG_UNIT5 | * | CHAR (10) |
| LIQD_MODE | Mode of Liquidation decision for the pool agreement | CMS_DTE_LIQD_MODE | * | CHAR (6) |
| COR_ROLE | Correspondence role | CMS_DTE_COR_ROLE | TFK070M | CHAR (4) |
| REL_THRESHOLD | Limit above which the Collaterals can be Released from Pool | CMS_DTE_CAG_RELEASE_THRESHOLD | DEC (10) | |
| LIQD_TYP | Liquidation Type | CMS_DTE_LIQD_TYP | CHAR (6) | |
| LIQD_REASON | Liquidation Reason | CMS_DTE_ATT_ID_TY_AST004 | TCMS_ATT_ID_TY | CHAR (6) |
| LIQD_DATE | Date on which the Collateral was Liquidated | CMS_DTE_LIQD_DATE | DATS (8) | |
| LIQD_AMT | Returns from the Liquidation of Collateral | CMS_DTE_LIQD_VALUE | CURR (17) | |
| LIQD_CURR | Currency of Liquidation Value | CMS_DTE_LIQD_CURR | TCURC | CUKY (5) |
| EXP_PRCD_AMNT | Expected Proceed Amount | CMS_DTE_LIQ_EXP_PRCD_AMOUNT | CURR (17) | |
| EXP_PRCD_CURR | Currency: Expected Proceed | CMS_DTE_LIQ_EXP_PRCD_CURR | TCURC | CUKY (5) |
| EXP_ACC_DATE | Expected accrual date | CMS_DTE_LIQ_EXP_ACCRUAL_DATE | DATS (8) | |
| OBJ_EXP_PRC_TIME | Expected Time of Proceeds | CMS_DTE_LIQ_OBJ_EXP_PRO_DATE | DATS (8) | |
| ACC_NUMBER_LIQ | Account number for liquidation proceeds | CMS_DTE_LIQ_ACC_NUMBER | CHAR (35) | |
| BANK_CNTRY_LIQ | Bank country key | CMS_DTE_LIQ_BNK_CTRY_KY | T005 | CHAR (3) |
| BANK_KEY_LIQ | Bank Key | CMS_DTE_LIQ_BNK_KEY | CHAR (15) | |
| BANK_CTRLKEY_LIQ | Bank Control Key | BKONT | CHAR (2) | |
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR (12) | |
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC (15) | |
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR (12) | |
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC (15) | |
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR (32) | |
| BUPR_ID | Business Process ID | CMS_DTE_BUPR_ID | RAW (16) | |
| BUPR_TYPE_CODE | Business Process Type Code | CMS_DTE_BUPR_TYP_CODE | CHAR (6) |
