SAP CMS_STR_CAG_BASIC_MAP Collateral agreement basic data Table data and field list

CMS_STR_CAG_BASIC_MAP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Collateral agreement basic data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMS_STR_CAG_BASIC_MAP TYPE CMS_STR_CAG_BASIC_MAP.

The CMS_STR_CAG_BASIC_MAP table consists of various fields, each holding specific information or linking keys about Collateral agreement basic data data available in SAP. These include NOM_VALUE_CURR (Currency for Nominal Value of the Collateral Agreement), ASMT_AMT (Assessment Amount), ASMT_CURR (Currency of Assessment Value), ASMT_DATE (Date on which the Assessment Value was Calculated)... 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_STR_CAG_BASIC_MAP structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CMS_STR_CAG_BASIC_MAP structure 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_STR_CAG_BASIC_MAP 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
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_CURRCUKY5Assigned to domainWAERS
ASMT_AMTAssessment Amount CMS_DTE_CAG_ASMT_AMTCURR17(2) CMS_AMOUNT
ASMT_CURRCurrency of Assessment Value CMS_DTE_CAG_ASMT_CURRCUKY5Assigned to domainWAERS
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_FROMDate from when it is valid CMS_DTE_VALID_FROMDATS8CMS_DATE
VALID_TODate until when it is valid CMS_DTE_VALID_TODATS8CMS_DATE
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
PCT_ASSET_VALPercentage of the Asset Value used in Collateral Agreement CMS_DTE_PCT_AST_VALDEC10(6) CMS_PCT
GUAR_RATEGuarantee Rate CMS_DTE_CAG_GUAR_RATEDEC10(6) CMS_PCT
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_TYPCHAR6Assigned to domainCMS_CAG_MIN_QUAL_EXCEP_TYPCMS_CAG_MQETYP
MIN_QL_REASONReason for the Minimum Qualitative Criterion CMS_DTE_CAG_ATT_ID_TY_CAG001CHAR6CMS_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_CRITERIONCHAR6Assigned to domainCMS_CAG_MIN_QUAL_CRITERIONCMS_CAG_MQCRT
TERM_RIGHT_TYPTermination Right Type CMS_DTE_TERM_RIGHT_TYPCHAR6Assigned to domainCMS_CAG_TERM_RIGHT_TYPCMS_CAG_TRTYP
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_PERIODNUMC4CMS_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_CAG002CHAR6CMS_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
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_CURRCUKY5Assigned to domainWAERS
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
SCOPE_INS_COVERScope of Cover of Credit Insurance CMS_DTE_CAG_ATT_ID_TY_CAG004CHAR6CMS_ATT_ID_TYP
LIQD_MODEMode of Liquidation decision for the pool agreement CMS_DTE_LIQD_MODECHAR6Assigned to domainCMS_LIQD_MODE
REL_THRESHOLDLimit above which the Collaterals can be Released from Pool CMS_DTE_CAG_RELEASE_THRESHOLDDEC10(6) CMS_PCT

Key field Non-key field



How do I retrieve data from SAP structure CMS_STR_CAG_BASIC_MAP using ABAP code?

As CMS_STR_CAG_BASIC_MAP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMS_STR_CAG_BASIC_MAP as there is no data to select.

How to access SAP table CMS_STR_CAG_BASIC_MAP

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

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