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

SAP Table CMS_CAG

Collateral Agreement Details

Unsere Literaturempfehlung

IDoc-Entwicklung für SAP: Customizing, Erweiterung, Eigenentwicklung

Wenn der Standard nicht ausreicht: Mit diesem Buch lernen Sie, IDocs selbstständig zu programmieren und zu erweitern. Die Autorin beschreibt Customizing-Techniken, die Erweiterung der Standardbausteine und komplette Eigenentwicklungen. Ob Rückmeldungen von Statuswerten, E-Mail-Workflows oder Serialisierung – für alle Aufgaben finden Sie Anleitungen und Tipps aus der Programmierpraxis. Neu in dieser Auflage: Überwachung und Fehlerbehandlung mit dem SAP Application Interface Framework.

Bei amazon.de ansehen →

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