dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table CMS_CAG

Collateral Agreement Details

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table CMS_CAG (Collateral Agreement Details) is a standard table in SAP ERP. It belongs to the package CMS_CORE.

Technical Information

Table CMS_CAG
Short Text Collateral Agreement Details
Package CMS_CORE
Table Type Transparent Table

Fields for Table CMS_CAG

Field Name Key Description Data Element Type Length Check Table
MANDT ✔ Client MANDT CLNT 3 T000
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 CHAR 6 TCMS_CAG_TYP
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 CUKY 5 TCURC
ASMT_AMT Assessment Amount CMS_DTE_CAG_ASMT_AMT CURR 17
ASMT_CURR Currency of Assessment Value CMS_DTE_CAG_ASMT_CURR CUKY 5 TCURC
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 CHAR 6 TCMS_CAG_MQEXP
MIN_QL_REASON Reason for the Minimum Qualitative Criterion CMS_DTE_CAG_ATT_ID_TY_CAG001 CHAR 6 TCMS_ATT_ID_TY
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 CHAR 6 TCMS_CAG_MQCRT
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 CHAR 6 TCMS_ATT_ID_TY
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
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 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 CUKY 5 TCURC
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 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 CHAR 6 TCMS_ATT_ID_TY
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 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 CHAR 6 TCMS_ATT_ID_TY
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 CHAR 4 TFK070M
REL_THRESHOLD Limit above which the Collaterals can be Released from Pool CMS_DTE_CAG_RELEASE_THRESHOLD DEC 10
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