CMS_STR_CAG_BASIC_DATA_GET_MAP SAP (General Collateral agreement data) Structure details
Description: General Collateral agreement data
Related tables to CMS_STR_CAG_BASIC_DATA_GET_MAP
Access table CMS_STR_CAG_BASIC_DATA_GET_MAP
Structure field list including key, data, relationships and ABAP select examples
CMS_STR_CAG_BASIC_DATA_GET_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 "General Collateral agreement 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_DATA_GET_MAP TYPE CMS_STR_CAG_BASIC_DATA_GET_MAP.
The CMS_STR_CAG_BASIC_DATA_GET_MAP table consists of various fields, each holding specific information or linking keys about General Collateral agreement data data available in SAP. These include CAGMTID (Collateral Agreement ID), CATEGORYID (Collateral Agreement Category ID), CAGMT_TYPE (Collateral Agreement Type), CAGMT_TYP_DESC (Name of Collateral Agreement Type).. 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. .
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_DATA_GET_MAP structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CAG_GUID | GUID for Table CMS_CAG | CMS_DTE_CAG_GUID | RAW | 16 | SYSUUID | ||||
CAGMTID | Collateral Agreement ID | CMS_DTE_CAGID | CHAR | 40 | ALPHA | CMS_CAGID | CMS_CAGID | CMS_SRCH_CAG | |
CATEGORYID | Collateral Agreement Category ID | CMS_DTE_CAG_CAT | CHAR | 6 | CMS_CAT | CMS_CAG_CAT | |||
CAGMT_TYPE | Collateral Agreement Type | CMS_DTE_CAG_TYP | CHAR | 6 | Assigned to domain | CMS_CAG_TYP | CMS_CAG_TYP | CMS_CAG_TYP | |
CAGMT_TYP_DESC | Name of Collateral Agreement Type | CMS_DTE_CAG_TYP_NAME | CHAR | 40 | CMS_NAME | ||||
NOM_VALUE | Nominal Value of the Collateral Agreement | CMS_DTE_CAG_NOMINAL_VALUE | CURR | 17(2) | CMS_AMOUNT | ||||
NOM_VALUE_CURR | Currency for Nominal Value of the Collateral Agreement | CMS_DTE_CAG_NOMINAL_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
CAGMT_DATE | Date on which Collateral Agreement was Concluded | CMS_DTE_CAG_DATE | DATS | 8 | CMS_DATE | ||||
VALID_FROM | Date from when it is valid | CMS_DTE_VALID_FROM | DATS | 8 | CMS_DATE | ||||
VALID_TO | Date until when it is valid | CMS_DTE_VALID_TO | DATS | 8 | CMS_DATE | ||||
COUNTRY_KEY | Jurisdiction Country | CMS_DTE_COUNTRY_KEY | CHAR | 3 | Assigned to domain | LAND1 | |||
FLG_GLOBAL | Flag to indicate a Global Collateral Agreement | CMS_DTE_FLG_CAG_GLOBAL | CHAR | 1 | CMS_FLG_GLOBAL_CAGMT | ||||
PCT_ASSET_VAL | Percentage of the Asset Value used in Collateral Agreement | CMS_DTE_PCT_AST_VAL | DEC | 10(6) | CMS_PCT | ||||
GUAR_RATE | Guarantee Rate | CMS_DTE_CAG_GUAR_RATE | DEC | 10(6) | CMS_PCT | ||||
SPL_MARKDOWN_PCT | Percentage of Special Markdown | CMS_DTE_CAG_SPL_MARKDOWN_PCT | DEC | 10(6) | CMS_PCT | ||||
SPL_MARKDOWN_AMT | Amount of Special Markdown | CMS_DTE_CAG_SPL_MARKDOWN_AMT | CURR | 17(2) | CMS_AMOUNT | ||||
SPL_MRKDOWN_CURR | Currency for Amount of Special Markdown | CMS_DTE_CAG_SPL_MRKDWN_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
DESCRIPTION | Description of Collateral Agreement | CMS_DTE_CAG_DESC | CHAR | 30 | CMS_DSC | ||||
UNIT_REL_FREQ | The unit for period of Release Frequency | CMS_DTE_IND_CAG_REL_FREQ_UNIT | CHAR | 2 | CMS_IND_CAG_FREQ_UNIT | ||||
PERIOD_REL_FREQ | Period for Frequency of Release of Collateral Agreement | CMS_DTE_CAG_REL_FREQ_PERIOD | NUMC | 4 | CMS_CAG_FREQ_PERIOD | ||||
OLD_CAGMTID | External/Old Collateral Agreement ID | CMS_DTE_OLD_CAGID | CHAR | 40 | CMS_OLD_CAGID | ||||
MIN_QL_EXCEP_TYP | Exceptions for Minimum Risk Weight | CMS_DTE_CAG_MIN_QUAL_EXCEP_TYP | CHAR | 6 | Assigned to domain | CMS_CAG_MIN_QUAL_EXCEP_TYP | CMS_CAG_MQETYP | ||
MIN_QL_REASON | Reason for the Minimum Qualitative Criterion | CMS_DTE_CAG_ATT_ID_TY_CAG001 | CHAR | 6 | CMS_ATT_ID_TYP | ||||
FLG_MIN_QL_REQMT | Flag:Minimum requirements fulfilled for CAG(for Basel II) | CMS_DTE_FLG_CAG_MIN_QUAL_REQMT | CHAR | 1 | CMS_FLG_MIN_QUAL_REQMT | ||||
MIN_QL_CRITE | MInimum Qualitative Criterion | CMS_DTE_CAG_MIN_QUAL_CRITERION | CHAR | 6 | Assigned to domain | CMS_CAG_MIN_QUAL_CRITERION | CMS_CAG_MQCRT | ||
TERM_RIGHT_TYP | Termination Right Type | CMS_DTE_TERM_RIGHT_TYP | CHAR | 6 | Assigned to domain | CMS_CAG_TERM_RIGHT_TYP | CMS_CAG_TRTYP | ||
UNIT_TERM_FREQ | The Unit for Period of Termination Frequency | CMS_DTE_IND_CAG_TERM_FREQ_UNIT | CHAR | 2 | CMS_IND_CAG_FREQ_UNIT | ||||
PERIOD_TERM_FREQ | Period for Frequency of Termination of Collateral Agreement | CMS_DTE_CAG_TERM_FREQ_PERIOD | NUMC | 4 | CMS_CAG_FREQ_PERIOD | ||||
NOTICE_PRD_UNIT | The Unit for the Termination Notice Period | CMS_DTE_IND_CAG_NOTICE_UNIT | CHAR | 2 | CMS_IND_CAG_TIME_PRD_UNIT | ||||
REQ_NOTICE_PRD | Notice Period Required to Terminate Collateral Agreement | CMS_DTE_CAG_NOTICE_PERIOD | NUMC | 4 | CMS_CAG_FREQ_PERIOD | ||||
TERM_NOTICE_DATE | Date on which Termination Notice was Sent | CMS_DTE_CAG_TERM_NOTICE_DATE | DATS | 8 | CMS_DATE | ||||
TERM_REASON | Termination Type | CMS_DTE_CAG_ATT_ID_TY_CAG002 | CHAR | 6 | CMS_ATT_ID_TYP | ||||
TERM_GUAR_AMT | Amount of Guarantee in the event of Termination | CMS_DTE_CAG_TERM_VALUE | CURR | 17(2) | CMS_AMOUNT | ||||
TERMINATION_CURR | Currency for Amount of Guarantee in the event of Termination | CMS_DTE_CAG_TERM_VALUE_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
MIN_STOCK_AMT | Minimum stock Amount agreed in the Collateral Agreement | CMS_DTE_CAG_MIN_STOCK_AMT | CURR | 17(2) | CMS_AMOUNT | ||||
MIN_STOCK_CURR | Currency of the Minimum Stock Amount | CMS_DTE_CAG_MIN_STOCK_AMT_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
FLG_ADDNL_RBL | Flag for Additional receivable | CMS_DTE_FLG_CAG_ADDNL_RBL | CHAR | 1 | CMS_FLG_ADDNL_RBL | ||||
ADDNL_RBL_DATE | Date on which Additional Receivable was Accepted | CMS_DTE_CAG_DATE_ADDNL_RBL | DATS | 8 | CMS_DATE | ||||
SCOPE_INS_COVER | Scope of Cover of Credit Insurance | CMS_DTE_CAG_ATT_ID_TY_CAG004 | CHAR | 6 | CMS_ATT_ID_TYP | ||||
LIQD_MODE | Mode of Liquidation decision for the pool agreement | CMS_DTE_LIQD_MODE | CHAR | 6 | Assigned to domain | CMS_LIQD_MODE | |||
REL_THRESHOLD | Limit above which the Collaterals can be Released from Pool | CMS_DTE_CAG_RELEASE_THRESHOLD | DEC | 10(6) | CMS_PCT | ||||
COR_ROLE | Correspondence role | CMS_DTE_COR_ROLE | CHAR | 4 | Assigned to domain | CORR_ROLE_KK |
Key field | Non-key field |
How do I retrieve data from SAP structure CMS_STR_CAG_BASIC_DATA_GET_MAP using ABAP code?
As CMS_STR_CAG_BASIC_DATA_GET_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_DATA_GET_MAP as there is no data to select.How to access SAP table CMS_STR_CAG_BASIC_DATA_GET_MAP
Within an ECC or HANA version of SAP you can also view further information about CMS_STR_CAG_BASIC_DATA_GET_MAP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects