SAP CMS_CAG Collateral Agreement Details Table data and field list

CMS_CAG is a standard SAP Table which is used to store Collateral Agreement Details data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_CAG table consists of various fields, each holding specific information or linking keys about Collateral Agreement Details data available in SAP. These include CAG_GUID (GUID for Table CMS_CAG), CAGMTID (Collateral Agreement ID), CAGMT_TYPE (Collateral Agreement Type), NOM_VALUE (Nominal Value of the Collateral Agreement)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMS_CAG table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CMS_CAG table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_CAG table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
CAG_GUIDGUID for Table CMS_CAG CMS_DTE_CAG_GUIDRAW16SYSUUID
CAGMTIDCollateral Agreement ID CMS_DTE_CAGIDCHAR40ALPHACMS_CAGIDCMS_CAGIDCMS_SRCH_CAG
CAGMT_TYPECollateral Agreement Type CMS_DTE_CAG_TYPCHAR6TCMS_CAG_TYPCMS_CAG_TYPCMS_CAG_TYPCMS_CAG_TYP
NOM_VALUENominal Value of the Collateral Agreement CMS_DTE_CAG_NOMINAL_VALUECURR17(2) CMS_AMOUNT
NOM_VALUE_CURRCurrency for Nominal Value of the Collateral Agreement CMS_DTE_CAG_NOMINAL_CURRCUKY5TCURCWAERS
ASMT_AMTAssessment Amount CMS_DTE_CAG_ASMT_AMTCURR17(2) CMS_AMOUNT
ASMT_CURRCurrency of Assessment Value CMS_DTE_CAG_ASMT_CURRCUKY5TCURCWAERS
ASMT_DATEDate on which the Assessment Value was Calculated CMS_DTE_CAG_ASMT_DATEDATS8CMS_DATE
CAGMT_DATEDate on which Collateral Agreement was Concluded CMS_DTE_CAG_DATEDATS8CMS_DATE
VALID_FROMCollateral Agreement Document Valid-from Date CMS_DTE_CAG_VALID_FROMNUMC15TSTPSTZNTSTMPSL
VALID_TOCollateral Agreement Document Valid-to Date CMS_DTE_CAG_VALID_TONUMC15TSTPSTZNTSTMPSL
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4Assigned to domainCMS_BANKAREACMS_BANKAREA
COUNTRY_KEYJurisdiction Country CMS_DTE_COUNTRY_KEYCHAR3Assigned to domainLAND1
FLG_GLOBALFlag to indicate a Global Collateral Agreement CMS_DTE_FLG_CAG_GLOBALCHAR1CMS_FLG_GLOBAL_CAGMT
SPL_MARKDOWN_PCTPercentage of Special Markdown CMS_DTE_CAG_SPL_MARKDOWN_PCTDEC10(6) CMS_PCT
SPL_MARKDOWN_AMTAmount of Special Markdown CMS_DTE_CAG_SPL_MARKDOWN_AMTCURR17(2) CMS_AMOUNT
SPL_MRKDOWN_CURRCurrency for Amount of Special Markdown CMS_DTE_CAG_SPL_MRKDWN_CURRCUKY5Assigned to domainWAERS
DESCRIPTIONDescription of Collateral Agreement CMS_DTE_CAG_DESCCHAR30CMS_DSC
UNIT_REL_FREQThe unit for period of Release Frequency CMS_DTE_IND_CAG_REL_FREQ_UNITCHAR2CMS_IND_CAG_FREQ_UNIT
PERIOD_REL_FREQPeriod for Frequency of Release of Collateral Agreement CMS_DTE_CAG_REL_FREQ_PERIODNUMC4CMS_CAG_FREQ_PERIOD
OLD_CAGMTIDExternal/Old Collateral Agreement ID CMS_DTE_OLD_CAGIDCHAR40CMS_OLD_CAGID
MIN_QL_EXCEP_TYPExceptions for Minimum Risk Weight CMS_DTE_CAG_MIN_QUAL_EXCEP_TYPCHAR6TCMS_CAG_MQEXPCMS_CAG_MIN_QUAL_EXCEP_TYPCMS_CAG_MQETYP
MIN_QL_REASONReason for the Minimum Qualitative Criterion CMS_DTE_CAG_ATT_ID_TY_CAG001CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
FLG_MIN_QL_REQMTFlag:Minimum requirements fulfilled for CAG(for Basel II) CMS_DTE_FLG_CAG_MIN_QUAL_REQMTCHAR1CMS_FLG_MIN_QUAL_REQMT
MIN_QL_CRITEMInimum Qualitative Criterion CMS_DTE_CAG_MIN_QUAL_CRITERIONCHAR6TCMS_CAG_MQCRTCMS_CAG_MIN_QUAL_CRITERIONCMS_CAG_MQCRT
PCT_ASSET_VALPercentage of the Asset Value used in Collateral Agreement CMS_DTE_PCT_AST_VALDEC10(6) CMS_PCT
TERM_RIGHT_TYPTermination Right Type CMS_DTE_TERM_RIGHT_TYPCHAR6Assigned to domainCMS_CAG_TERM_RIGHT_TYPCMS_CAG_TRTYP
FIRST_TERM_DATEFirst possible date of termination CMS_DTE_CAG_TERM_FSTPOS_DATEDATS8CMS_DATE
UNIT_TERM_FREQThe Unit for Period of Termination Frequency CMS_DTE_IND_CAG_TERM_FREQ_UNITCHAR2CMS_IND_CAG_FREQ_UNIT
PERIOD_TERM_FREQPeriod for Frequency of Termination of Collateral Agreement CMS_DTE_CAG_TERM_FREQ_PERIODNUMC4CMS_CAG_FREQ_PERIOD
NOTICE_PRD_UNITThe Unit for the Termination Notice Period CMS_DTE_IND_CAG_NOTICE_UNITCHAR2CMS_IND_CAG_TIME_PRD_UNIT
REQ_NOTICE_PRDNotice Period Required to Terminate Collateral Agreement CMS_DTE_CAG_NOTICE_PERIODNUMC4Assigned to domainCMS_CAG_FREQ_PERIOD
TERM_NOTICE_DATEDate on which Termination Notice was Sent CMS_DTE_CAG_TERM_NOTICE_DATEDATS8CMS_DATE
TERM_REASONTermination Type CMS_DTE_CAG_ATT_ID_TY_CAG002CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
TERM_GUAR_AMTAmount of Guarantee in the event of Termination CMS_DTE_CAG_TERM_VALUECURR17(2) CMS_AMOUNT
TERMINATION_CURRCurrency for Amount of Guarantee in the event of Termination CMS_DTE_CAG_TERM_VALUE_CURRCUKY5Assigned to domainWAERS
GUAR_RATEGuarantee Rate CMS_DTE_CAG_GUAR_RATEDEC10(6) CMS_PCT
FLG_COUNTER_GUARFlag for Counter Guarantee CMS_DTE_FLG_CAG_CNTR_GUARCHAR1CMS_FLG_CNTR_GUAR
FLG_CO_GUARFlag for Co-guarantee CMS_DTE_FLG_CAG_CO_GUARCHAR1CMS_FLG_CO_GUAR
FLG_FIXED_LIABTYFlag for Fixed Liability CMS_DTE_FLG_CAG_FIXED_LIABILTYCHAR1CMS_FLG_FIXED_LIABILITY
FLG_DEF_LIABTYFlag for Default Liability CMS_DTE_FLG_CAG_DEF_LIABILITYCHAR1CMS_FLG_DEF_LIABILITY
PCT_DEF_LIABTYDefault Liability in % CMS_DTE_FLG_CAG_PCT_DEF_LIABTYDEC10(6) CMS_PCT
FLG_INCL_CAG_LNKFlag for back-up guarantee to be used in calculations or not CMS_DTE_FLG_CAG_INCL_LINKEDCHAR1CMS_FLG_CAG_INCL_LINKED
IND_APPR_AUTHApproval from authorities CMS_DTE_IND_CAG_APPR_AUTHCHAR2CMS_IND_CAG_APPR_AUTH
FLG_ENFORCEABLEAgreement directly enforceable CMS_DTE_FLG_CAG_ENFORCEABLECHAR1CMS_FLG_DIR_ENFC
LENDING_RATELending Rate of a Guarantee CMS_DTE_CAG_LRTE_PCTDEC10(6) CMS_PCT
UNIT_REDU_FREQUnit for Period of Frequency for Reduction in Guarantee Valu CMS_DTE_IND_CAG_RED_FREQ_UNITCHAR2CMS_IND_CAG_FREQ_UNIT
PERIOD_REDU_FREQPeriod for Frequency of Reduction in Value of Guarantee CMS_DTE_CAG_RED_FREQ_PERIODNUMC4CMS_CAG_FREQ_PERIOD
REDU_AMTReduction in Amount of Guarantee CMS_DTE_CAG_REDU_AMTCURR17(2) CMS_AMOUNT
REDU_CURRCurrency of the Reduced Amount of the Guarantee CMS_DTE_CAG_REDU_AMT_CURRCUKY5Assigned to domainWAERS
REDU_PCTPercentage of Reduction in the Value of a Guarantee CMS_DTE_CAG_REDU_PCTDEC10(6) CMS_PCT
REDU_START_DATEDate from which Guarantee Value is Reduced CMS_DTE_CAG_REDU_START_DATEDATS8CMS_DATE
REDU_END_DATEEnd Date for Reduction in Amount of Guarantee CMS_DTE_CAG_REDU_END_DATEDATS8CMS_DATE
REDU_LAST_DATELast date of reduction of value CMS_DTE_CAG_REDU_LAST_DATEDATS8CMS_DATE
FLG_LEASING_TXNFlag: Transfer is part of a leasing transaction CMS_DTE_FLG_CAG_LEASING_TXNCHAR1CMS_FLG_LEASING_TRANSACTION
IND_LESSOR_LIENIndicator for Lessor Lien on Collateral Agreement CMS_DTE_IND_CAG_LESSOR_LIENCHAR2CMS_IND_CAG_LESSOR_LIEN
IND_ACC_LIABLESpecifies the applicability of accessories liability CMS_DTE_IND_CAG_ACC_LIABLECHAR2CMS_IND_CAG_ACC_LIABLE
FLG_ASGMT_ARFlag for Assignment of Accounts Receivables(AR) from Sale CMS_DTE_FLG_CAG_AR_FRM_SALECHAR1CMS_FLG_ASGMT_RBL_FROM_SALE
MIN_STOCK_AMTMinimum stock Amount agreed in the Collateral Agreement CMS_DTE_CAG_MIN_STOCK_AMTCURR17(2) CMS_AMOUNT
MIN_STOCK_CURRCurrency of the Minimum Stock Amount CMS_DTE_CAG_MIN_STOCK_AMT_CURRCUKY5TCURCWAERS
FLG_ADDNL_RBLFlag for Additional receivable CMS_DTE_FLG_CAG_ADDNL_RBLCHAR1CMS_FLG_ADDNL_RBL
ADDNL_RBL_DATEDate on which Additional Receivable was Accepted CMS_DTE_CAG_DATE_ADDNL_RBLDATS8CMS_DATE
IND_GBC_LIENGBC Lien on Agreement CMS_DTE_IND_CAG_GBC_LIENCHAR2CMS_IND_CAG_GBC_LIEN
FLG_DISCLFlag to indicator whether the Agreement is disclosed or not CMS_DTE_FLG_CAG_DISCL_PLEDGECHAR1CMS_FLG_DISCL_PLEDGE
DISCL_DATEDate of Disclosure to Third-party Debtor CMS_DTE_CAG_DISCL_DATEDATS8CMS_DATE
ASGMT_REASONReason for Assignment CMS_DTE_CAG_ATT_ID_TY_CAG006CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
INT_RATELand Charge Interest Rate CMS_DTE_CAG_LCHG_INT_RATEDEC10(6) CMS_PCT
INCIDENTAL_PAYMTIncidental Payments in Percentage CMS_DTE_CAG_LCHG_INCD_PAYMTDEC10(6) CMS_PCT
UNIT_PMT_FREQThe unit for period of payment frequency CMS_DTE_IND_CAG_PYMT_FREQ_UNITCHAR2CMS_IND_CAG_FREQ_UNIT
PERIOD_PMT_FREQPeriod for Frequency of Payment of Land Charge Interest CMS_DTE_CAG_PYMT_FREQ_PERIODNUMC4CMS_CAG_FREQ_PERIOD
INT_START_DATEStart Date for Land Charge Interest Calculation CMS_DTE_CAG_LCHG_INT_START_DATDATS8CMS_DATE
NUM_YR_LCHG_INTNumber of Years the Land Charge Interest can be Capitalized CMS_DTE_CAG_LCHG_INT_YRNUMC4CMS_CAG_LCHG_INT_YR
IND_ENFORCMT_TYPEnforcement Type CMS_DTE_IND_CAG_LCHG_ENFC_TYPCHAR2CMS_IND_CAG_LCHG_ENFC_TYP
ENFORCMT_AMTEnforcement Amount CMS_DTE_CAG_LCHG_ENFC_AMTCURR17(2) CMS_AMOUNT
ENFORCMT_CURRCurrency for Enforcement Amount of Land Charge CMS_DTE_CAG_LCHG_ENFC_AMT_CURRCUKY5Assigned to domainWAERS
REF_ENFORCMT_AMTReference amount for part (Equal,Secondar) enforcebility CMS_DTE_CAG_LCHG_ENFC_REF_AMTCURR17(2) CMS_AMOUNT
RANKRank of the Land Charge Enforceable Amount CMS_DTE_CAG_LCHG_ENFC_RANKNUMC4CMS_CAG_LCHG_ENFC_RANK
ENFORCMT_TITLEIndicator for Enforcement Title CMS_DTE_IND_CAG_LCHG_ENFC_TITLCHAR2CMS_IND_CAG_LCHG_ENFC_TITLE
UNIT_INT_FREQUnit for period of Payment Frequency of HBR interest CMS_DTE_IND_CAG_HBR_INT_UNITCHAR2CMS_IND_CAG_FREQ_UNIT
PERIOD_INT_FREQPayment Frequency Period for HBR interest CMS_DTE_CAG_HBR_INT_PERIODNUMC4CMS_CAG_FREQ_PERIOD
FLG_INTEREST_INCFlag for increase in HBR interest CMS_DTE_FLG_LCHG_INC_INTCHAR1CMS_FLG_LCHG_INC_INT
UNIT_INC_FREQUnit for Frequency Period of Increase in HBR Interest CMS_DTE_IND_CAG_HBR_INC_UNITCHAR2CMS_IND_CAG_FREQ_UNIT
PERIOD_INC_FREQFrequency Period for Increase in HBR Interest CMS_DTE_CAG_HBR_INC_PERIODNUMC4CMS_CAG_FREQ_PERIOD
INC_PCTPercentage Increase in Heritable Building Rights Amount CMS_DTE_CAG_LCHG_INC_PCTDEC10(6) CMS_PCT
INC_AMTIncrease in Heritable Building Rights Amount CMS_DTE_CAG_LCHG_INC_AMTCURR17(2) CMS_AMOUNT
INC_CURR Currency for Increase in HBR amount CMS_DTE_CAG_LCHG_INC_AMT_CURRCUKY5Assigned to domainWAERS
INC_START_DATEStart date for Increase in Heritable Building Right Interest CMS_DTE_CAG_LCHG_INC_START_DATDATS8CMS_DATE
IND_HBR_WAIVERIndicator for Waiver of HBR Enforcement CMS_DTE_IND_CAG_LCHG_HBR_WAIVECHAR2CMS_IND_CAG_LCHG_HBR_WAIVER
INC_LAST_DATELast date of Increase in Heritable Building Right Interest CMS_DTE_CAG_LCHG_INC_LAST_DATEDATS8CMS_DATE
FLG_COLL_LCHGFlag: Collective Land Charge CMS_DTE_FLG_CAG_LCHG_COLLCHAR1CMS_FLG_CAG_LCHG_COLLECTIVE
FLG_CHARGE_CERTFlag: Land Charge certificate exists CMS_DTE_FLG_CAG_LCHG_CERTCHAR1CMS_FLG_LCHG_CERT
CHARGE_CERT_NUMCharge Certificate Number CMS_DTE_CAG_LCHG_CERT_NUMCHAR30CMS_LCHG_CERT_NUM
FILE_NUMFile Number CMS_DTE_CAG_LCHG_FILE_NUMCHAR30CMS_LCHG_FILE_NUM
SCOPE_INS_COVERScope of Cover of Credit Insurance CMS_DTE_CAG_ATT_ID_TY_CAG004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
ORG_UNIT1Organizational Unit 1: Collateral Agreement CMS_DTE_CAG_ORG_UNIT1CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2: Collateral Agreement CMS_DTE_CAG_ORG_UNIT2CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3: Collateral Agreement CMS_DTE_CAG_ORG_UNIT3CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4: Collateral Agreement CMS_DTE_CAG_ORG_UNIT4CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5: Collateral Agreement CMS_DTE_CAG_ORG_UNIT5CHAR10Assigned to domainCMS_ORG_UNIT
LIQD_MODEMode of Liquidation decision for the pool agreement CMS_DTE_LIQD_MODECHAR6Assigned to domainCMS_LIQD_MODE
COR_ROLECorrespondence role CMS_DTE_COR_ROLECHAR4TFK070MCORR_ROLE_KK
REL_THRESHOLDLimit above which the Collaterals can be Released from Pool CMS_DTE_CAG_RELEASE_THRESHOLDDEC10(6) CMS_PCT
CREATED_BYLogin ID of the User who created the Record CMS_DTE_USERCHAR12CMS_USER
CREATED_ATCreation Timestamp CMS_DTE_CREATED_ATDEC15TZNTSTMPS
CHANGED_BYLast Changed By CMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
CHANGED_ATChange Timestamp CMS_DTE_CHANGED_ATDEC15TZNTSTMPS
SOURCEOFENTRYSource of Entry CMS_DTE_SOURCE_OF_ENTRYCHAR32CMS_SOURCE

Key field Non-key field



How do I retrieve data from SAP table CMS_CAG using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_CAG to SELECT all data from the table
DATA: WA_CMS_CAG TYPE CMS_CAG.

SELECT SINGLE *
FROM CMS_CAG
INTO CORRESPONDING FIELDS OF WA_CMS_CAG
WHERE...

How to access SAP table CMS_CAG

Within an ECC or HANA version of SAP you can also view further information about CMS_CAG and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).