CMS_CAG SAP table for – Collateral Agreement Details

Here we would like to draw your attention to CMS_CAG table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_CAG is a SAP standard transp table used for storing Collateral Agreement Details related data in SAP. It comes under the package CMS_CORE.

SAP CMS_CAG table

Table CMS_CAG technical data

TableCMS_CAG
Data storingCollateral Agreement Details
ModuleFS
Sub ModuleFS-CMS-MD
SAP PackageCMS_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_CAG Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_CAG table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary Key for CMS_CAG
    Its a key field.
  • CAG_GUID : GUID for Table CMS_CAG
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Semantic Key for Table CMS_CAG
  • CAGMTID : Collateral Agreement ID
    Its data type is CHAR (Character String) with field length 40
  • CAGMT_TYPE : Collateral Agreement Type
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Collateral Agreement Details
  • .INCLUDE : Nominal Value for Collateral Agreement
  • NOM_VALUE : Nominal Value of the Collateral Agreement
    Its data type is CURR (Currency Field) with field length 17
  • NOM_VALUE_CURR : Currency for Nominal Value of the Collateral Agreement
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Assessment Value details for a Collateral Agreement
  • ASMT_AMT : Assessment Amount
    Its data type is CURR (Currency Field) with field length 17
  • ASMT_CURR : Currency of Assessment Value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ASMT_DATE : Date on which the Assessment Value was Calculated
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Collateral Agreement Dates (DB Format )
  • CAGMT_DATE : Date on which Collateral Agreement was Concluded
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALID_FROM : Collateral Agreement Document Valid-from Date
    Its data type is NUMC (Character String with Digits Only) with field length 15
  • VALID_TO : Collateral Agreement Document Valid-to Date
    Its data type is NUMC (Character String with Digits Only) with field length 15
  • .INCLUDE : Basic data for a Collateral Agreement
  • .INCLUDE : Administrative organization unit
  • ADMIN_ORG_UNIT : Administration Organizational Unit
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Bank area
  • BANKAREA : Bank Area in Collateral Management
    Its data type is CHAR (Character String) with field length 4
  • COUNTRY_KEY : Jurisdiction Country
    Its data type is CHAR (Character String) with field length 3
  • FLG_GLOBAL : Flag to indicate a Global Collateral Agreement
    Its data type is CHAR (Character String) with field length 1
  • SPL_MARKDOWN_PCT : Percentage of Special Markdown
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SPL_MARKDOWN_AMT : Amount of Special Markdown
    Its data type is CURR (Currency Field) with field length 17
  • SPL_MRKDOWN_CURR : Currency for Amount of Special Markdown
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DESCRIPTION : Description of Collateral Agreement
    Its data type is CHAR (Character String) with field length 30
  • UNIT_REL_FREQ : The unit for period of Release Frequency
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_REL_FREQ : Period for Frequency of Release of Collateral Agreement
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • OLD_CAGMTID : External/Old Collateral Agreement ID
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Basel II relevant data
  • MIN_QL_EXCEP_TYP : Exceptions for Minimum Risk Weight
    Its data type is CHAR (Character String) with field length 6
  • MIN_QL_REASON : Reason for the Minimum Qualitative Criterion
    Its data type is CHAR (Character String) with field length 6
  • FLG_MIN_QL_REQMT : Flag:Minimum requirements fulfilled for CAG(for Basel II)
    Its data type is CHAR (Character String) with field length 1
  • MIN_QL_CRITE : MInimum Qualitative Criterion
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Asset details for a Collateral Agreement
  • PCT_ASSET_VAL : Percentage of the Asset Value used in Collateral Agreement
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Termination rights data
  • TERM_RIGHT_TYP : Termination Right Type
    Its data type is CHAR (Character String) with field length 6
  • FIRST_TERM_DATE : First possible date of termination
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNIT_TERM_FREQ : The Unit for Period of Termination Frequency
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_TERM_FREQ : Period for Frequency of Termination of Collateral Agreement
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • NOTICE_PRD_UNIT : The Unit for the Termination Notice Period
    Its data type is CHAR (Character String) with field length 2
  • REQ_NOTICE_PRD : Notice Period Required to Terminate Collateral Agreement
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • TERM_NOTICE_DATE : Date on which Termination Notice was Sent
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERM_REASON : Termination Type
    Its data type is CHAR (Character String) with field length 6
  • TERM_GUAR_AMT : Amount of Guarantee in the event of Termination
    Its data type is CURR (Currency Field) with field length 17
  • TERMINATION_CURR : Currency for Amount of Guarantee in the event of Termination
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Guarantee specific data
  • .INCLUDE : Guarantee specific details
  • GUAR_RATE : Guarantee Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • FLG_COUNTER_GUAR : Flag for Counter Guarantee
    Its data type is CHAR (Character String) with field length 1
  • FLG_CO_GUAR : Flag for Co-guarantee
    Its data type is CHAR (Character String) with field length 1
  • FLG_FIXED_LIABTY : Flag for Fixed Liability
    Its data type is CHAR (Character String) with field length 1
  • FLG_DEF_LIABTY : Flag for Default Liability
    Its data type is CHAR (Character String) with field length 1
  • PCT_DEF_LIABTY : Default Liability in %
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • FLG_INCL_CAG_LNK : Flag for back-up guarantee to be used in calculations or not
    Its data type is CHAR (Character String) with field length 1
  • IND_APPR_AUTH : Approval from authorities
    Its data type is CHAR (Character String) with field length 2
  • FLG_ENFORCEABLE : Agreement directly enforceable
    Its data type is CHAR (Character String) with field length 1
  • LENDING_RATE : Lending Rate of a Guarantee
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Reduction relation data
  • UNIT_REDU_FREQ : Unit for Period of Frequency for Reduction in Guarantee Valu
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_REDU_FREQ : Period for Frequency of Reduction in Value of Guarantee
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REDU_AMT : Reduction in Amount of Guarantee
    Its data type is CURR (Currency Field) with field length 17
  • REDU_CURR : Currency of the Reduced Amount of the Guarantee
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • REDU_PCT : Percentage of Reduction in the Value of a Guarantee
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • REDU_START_DATE : Date from which Guarantee Value is Reduced
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REDU_END_DATE : End Date for Reduction in Amount of Guarantee
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REDU_LAST_DATE : Last date of reduction of value
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Transfer specific details
  • FLG_LEASING_TXN : Flag: Transfer is part of a leasing transaction
    Its data type is CHAR (Character String) with field length 1
  • IND_LESSOR_LIEN : Indicator for Lessor Lien on Collateral Agreement
    Its data type is CHAR (Character String) with field length 2
  • IND_ACC_LIABLE : Specifies the applicability of accessories liability
    Its data type is CHAR (Character String) with field length 2
  • FLG_ASGMT_AR : Flag for Assignment of Accounts Receivables(AR) from Sale
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Minimum stock data
  • MIN_STOCK_AMT : Minimum stock Amount agreed in the Collateral Agreement
    Its data type is CURR (Currency Field) with field length 17
  • MIN_STOCK_CURR : Currency of the Minimum Stock Amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FLG_ADDNL_RBL : Flag for Additional receivable
    Its data type is CHAR (Character String) with field length 1
  • ADDNL_RBL_DATE : Date on which Additional Receivable was Accepted
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Pledge/Assignment details
  • IND_GBC_LIEN : GBC Lien on Agreement
    Its data type is CHAR (Character String) with field length 2
  • FLG_DISCL : Flag to indicator whether the Agreement is disclosed or not
    Its data type is CHAR (Character String) with field length 1
  • DISCL_DATE : Date of Disclosure to Third-party Debtor
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Assignment reason
  • ASGMT_REASON : Reason for Assignment
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Land Charge specific data
  • .INCLUDE : Land Charge specific interest details
  • INT_RATE : Land Charge Interest Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • INCIDENTAL_PAYMT : Incidental Payments in Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • UNIT_PMT_FREQ : The unit for period of payment frequency
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_PMT_FREQ : Period for Frequency of Payment of Land Charge Interest
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • INT_START_DATE : Start Date for Land Charge Interest Calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NUM_YR_LCHG_INT : Number of Years the Land Charge Interest can be Capitalized
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Enforcement details for a land charge
  • IND_ENFORCMT_TYP : Enforcement Type
    Its data type is CHAR (Character String) with field length 2
  • ENFORCMT_AMT : Enforcement Amount
    Its data type is CURR (Currency Field) with field length 17
  • ENFORCMT_CURR : Currency for Enforcement Amount of Land Charge
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • REF_ENFORCMT_AMT : Reference amount for part (Equal,Secondar) enforcebility
    Its data type is CURR (Currency Field) with field length 17
  • RANK : Rank of the Land Charge Enforceable Amount
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ENFORCMT_TITLE : Indicator for Enforcement Title
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Heritable building right (HBR) details
  • UNIT_INT_FREQ : Unit for period of Payment Frequency of HBR interest
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_INT_FREQ : Payment Frequency Period for HBR interest
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FLG_INTEREST_INC : Flag for increase in HBR interest
    Its data type is CHAR (Character String) with field length 1
  • UNIT_INC_FREQ : Unit for Frequency Period of Increase in HBR Interest
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_INC_FREQ : Frequency Period for Increase in HBR Interest
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • INC_PCT : Percentage Increase in Heritable Building Rights Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • INC_AMT : Increase in Heritable Building Rights Amount
    Its data type is CURR (Currency Field) with field length 17
  • INC_CURR : Currency for Increase in HBR amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INC_START_DATE : Start date for Increase in Heritable Building Right Interest
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IND_HBR_WAIVER : Indicator for Waiver of HBR Enforcement
    Its data type is CHAR (Character String) with field length 2
  • INC_LAST_DATE : Last date of Increase in Heritable Building Right Interest
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Land Charge specific details
  • FLG_COLL_LCHG : Flag: Collective Land Charge
    Its data type is CHAR (Character String) with field length 1
  • FLG_CHARGE_CERT : Flag: Land Charge certificate exists
    Its data type is CHAR (Character String) with field length 1
  • CHARGE_CERT_NUM : Charge Certificate Number
    Its data type is CHAR (Character String) with field length 30
  • FILE_NUM : File Number
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Insurance Coverage data
  • SCOPE_INS_COVER : Scope of Cover of Credit Insurance
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Organization unit structure: Collateral Agreements
  • ORG_UNIT1 : Organizational Unit 1: Collateral Agreement
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT2 : Organizational Unit 2: Collateral Agreement
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT3 : Organizational Unit 3: Collateral Agreement
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT4 : Organizational Unit 4: Collateral Agreement
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT5 : Organizational Unit 5: Collateral Agreement
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Liquidation data
  • LIQD_MODE : Mode of Liquidation decision for the pool agreement
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Correspondence related attributes for CAG
  • COR_ROLE : Correspondence role
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Agreement Thresholds
  • REL_THRESHOLD : Limit above which the Collaterals can be Released from Pool
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Stucture to record history of changes in all application tab
  • CREATED_BY : Login ID of the User who created the Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_AT : Creation Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Change Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOURCEOFENTRY : Source of Entry
    Its data type is CHAR (Character String) with field length 32