CMS_CAG

Collateral Agreement Details | #masterdata | Component: Master Data
Column Name Description
MANDT FK Client
CAG_GUID GUID for Table CMS_CAG
Column Name Description
💲 Currency for Nominal Value of the Collateral Agreement (NOM_VALUE_CURR):
NOM_VALUE Nominal Value of the Collateral Agreement
💲 Currency of Assessment Value (ASMT_CURR):
ASMT_AMT Assessment Amount
💲 Currency for Amount of Special Markdown (SPL_MRKDOWN_CURR):
SPL_MARKDOWN_AMT Amount of Special Markdown
💲 Currency for Amount of Guarantee in the event of Termination (TERMINATION_CURR):
TERM_GUAR_AMT Amount of Guarantee in the event of Termination
💲 Currency of the Reduced Amount of the Guarantee (REDU_CURR):
REDU_AMT Reduction in Amount of Guarantee
💲 Currency of the Original Protection Value (ORI_VALUE_CURR):
ORI_VALUE Original Protection of the Agreements
💲 Currency of the Minimum Stock Amount (MIN_STOCK_CURR):
MIN_STOCK_AMT Minimum stock Amount agreed in the Collateral Agreement
💲 Currency for Enforcement Amount of Land Charge (ENFORCMT_CURR):
ENFORCMT_AMT Enforcement Amount
REF_ENFORCMT_AMT Reference amount for part (Equal,Secondar) enforcebility
💲 Currency for Increase in HBR amount (INC_CURR):
INC_AMT Increase in Heritable Building Rights Amount
💲 Currency of Liquidation Value (LIQD_CURR):
LIQD_AMT Returns from the Liquidation of Collateral
💲 Currency: Expected Proceed (EXP_PRCD_CURR):
EXP_PRCD_AMNT Expected Proceed Amount
Column Name Description
Column Name Description
ASMT_DATE Date on which the Assessment Value was Calculated
CAGMT_DATE Date on which Collateral Agreement was Concluded
FIRST_TERM_DATE First possible date of termination
TERM_NOTICE_DATE Date on which Termination Notice was Sent
REDU_START_DATE Date from which Guarantee Value is Reduced
REDU_END_DATE End Date for Reduction in Amount of Guarantee
REDU_LAST_DATE Last date of reduction of value
ADDNL_RBL_DATE Date on which Additional Receivable was Accepted
DISCL_DATE Date of Disclosure to Third-party Debtor
INT_START_DATE Start Date for Land Charge Interest Calculation
INC_START_DATE Start date for Increase in Heritable Building Right Interest
INC_LAST_DATE Last date of Increase in Heritable Building Right Interest
LIQD_DATE Date on which the Collateral was Liquidated
EXP_ACC_DATE Expected accrual date
OBJ_EXP_PRC_TIME Expected Time of Proceeds
Column Name Description
FLG_GLOBAL Flag to indicate a Global Collateral Agreement Show values
UNIT_REL_FREQ The unit for period of Release Frequency Show values
FLG_MIN_QL_REQMT Flag:Minimum requirements fulfilled for CAG(for Basel II) Show values
UNIT_TERM_FREQ The Unit for Period of Termination Frequency Show values
NOTICE_PRD_UNIT The Unit for the Termination Notice Period Show values
FLG_COUNTER_GUAR Flag for Counter Guarantee Show values
FLG_CO_GUAR Flag for Co-guarantee Show values
FLG_FIXED_LIABTY Flag for Fixed Liability Show values
FLG_DEF_LIABTY Flag for Default Liability Show values
FLG_INCL_CAG_LNK Flag for back-up guarantee to be used in calculations or not Show values
IND_APPR_AUTH Approval from authorities Show values
FLG_ENFORCEABLE Agreement directly enforceable Show values
UNIT_REDU_FREQ Unit for Period of Frequency for Reduction in Guarantee Valu Show values
FLG_LEASING_TXN Flag: Transfer is part of a leasing transaction Show values
FLG_ASGMT_AR Flag for Assignment of Accounts Receivables(AR) from Sale Show values
FLG_ADDNL_RBL Flag for Additional receivable Show values
FLG_DISCL Flag to indicator whether the Agreement is disclosed or not Show values
UNIT_PMT_FREQ The unit for period of payment frequency Show values
IND_ENFORCMT_TYP Enforcement Type Show values
RANK Rank of the Land Charge Enforceable Amount Show values
ENFORCMT_TITLE Indicator for Enforcement Title Show values
UNIT_INT_FREQ Unit for period of Payment Frequency of HBR interest Show values
FLG_INTEREST_INC Flag for increase in HBR interest Show values
UNIT_INC_FREQ Unit for Frequency Period of Increase in HBR Interest Show values
FLG_COLL_LCHG Flag: Collective Land Charge Show values
FLG_CHARGE_CERT Flag: Land Charge certificate exists Show values
Column Name Description Domain name
CAGMTID Collateral Agreement ID CMS_CAGID
VALID_FROM Collateral Agreement Document Valid-from Date TZNTSTMPSL
VALID_TO Collateral Agreement Document Valid-to Date TZNTSTMPSL
ADMIN_ORG_UNIT Administration Organizational Unit TEXT12
BANKAREA Bank Area in Collateral Management CMS_BANKAREA
SPL_MARKDOWN_PCT Percentage of Special Markdown CMS_PCT
DESCRIPTION Description of Collateral Agreement CMS_DSC
PERIOD_REL_FREQ Period for Frequency of Release of Collateral Agreement CMS_CAG_FREQ_PERIOD
OLD_CAGMTID External/Old Collateral Agreement ID CMS_OLD_CAGID
PCT_ASSET_VAL Percentage of the Asset Value used in Collateral Agreement CMS_PCT
TERM_RIGHT_TYP Termination Right Type CMS_CAG_TERM_RIGHT_TYP
PERIOD_TERM_FREQ Period for Frequency of Termination of Collateral Agreement CMS_CAG_FREQ_PERIOD
GUAR_RATE Guarantee Rate CMS_PCT
PCT_DEF_LIABTY Default Liability in % CMS_PCT
LENDING_RATE Lending Rate of a Guarantee CMS_PCT
PERIOD_REDU_FREQ Period for Frequency of Reduction in Value of Guarantee CMS_CAG_FREQ_PERIOD
REDU_PCT Percentage of Reduction in the Value of a Guarantee CMS_PCT
IND_ACC_LIABLE Specifies the applicability of accessories liability CMS_IND_CAG_ACC_LIABLE
INT_RATE Land Charge Interest Rate CMS_PCT
INCIDENTAL_PAYMT Incidental Payments in Percentage CMS_PCT
PERIOD_PMT_FREQ Period for Frequency of Payment of Land Charge Interest CMS_CAG_FREQ_PERIOD
NUM_YR_LCHG_INT Number of Years the Land Charge Interest can be Capitalized CMS_CAG_LCHG_INT_YR
PERIOD_INT_FREQ Payment Frequency Period for HBR interest CMS_CAG_FREQ_PERIOD
PERIOD_INC_FREQ Frequency Period for Increase in HBR Interest CMS_CAG_FREQ_PERIOD
INC_PCT Percentage Increase in Heritable Building Rights Amount CMS_PCT
CHARGE_CERT_NUM Charge Certificate Number CMS_LCHG_CERT_NUM
FILE_NUM File Number CMS_LCHG_FILE_NUM
ORG_UNIT1 Organizational Unit 1: Collateral Agreement CMS_ORG_UNIT
ORG_UNIT2 Organizational Unit 2: Collateral Agreement CMS_ORG_UNIT
ORG_UNIT3 Organizational Unit 3: Collateral Agreement CMS_ORG_UNIT
ORG_UNIT4 Organizational Unit 4: Collateral Agreement CMS_ORG_UNIT
ORG_UNIT5 Organizational Unit 5: Collateral Agreement CMS_ORG_UNIT
LIQD_MODE Mode of Liquidation decision for the pool agreement CMS_LIQD_MODE
REL_THRESHOLD Limit above which the Collaterals can be Released from Pool CMS_PCT
LIQD_TYP Liquidation Type CMS_TYP
ACC_NUMBER_LIQ Account number for liquidation proceeds BANKN35
BANK_KEY_LIQ Bank Key BANKK
BANK_CTRLKEY_LIQ Bank Control Key BKONT
CREATED_BY Login ID of the User who created the Record CMS_USER
CREATED_AT Creation Timestamp TZNTSTMPS
CHANGED_BY Last Changed By CMS_USER
CHANGED_AT Change Timestamp TZNTSTMPS
SOURCEOFENTRY Source of Entry CMS_SOURCE
BUPR_ID Business Process ID SYSUUID
BUPR_TYPE_CODE Business Process Type Code CMS_BUPR_TYP_CODE
Master Data Relations Join Conditions
Reason for Assignment
  • ?
  • Client
  • Reason for Assignment
Currency of Assessment Value
  • CMS_CAG.MANDT == TCURC.MANDT
  • CMS_CAG.ASMT_CURR == TCURC.WAERS
Key of Bank Country/Region
  • Key of Bank Country/Region
  • Client
  • CMS_CAG.BANK_CNTRY_LIQ == T005.LAND1
  • CMS_CAG.MANDT == T005.MANDT
Foreign key for Agreement type
  • Collateral Agreement Type
  • Client
Correspondence role
  • Correspondence role
  • Client
Currency: Expected Proceed
  • CMS_CAG.MANDT == TCURC.MANDT
  • CMS_CAG.EXP_PRCD_CURR == TCURC.WAERS
GBC Lien on Agreement
  • GBC Lien on Agreement
  • Client
Indicator for Waiver of HBR Enforcement
Indicator for Lessor Lien on Collateral Agreement
Currency of Liquidation Value
  • CMS_CAG.MANDT == TCURC.MANDT
  • CMS_CAG.LIQD_CURR == TCURC.WAERS
Liquidation Reason
  • ?
  • Client
  • Liquidation Reason
Foreign Key for Mandt CMS_CAG.MANDT == T000.MANDT
MInimum Qualitative Criterion
  • MInimum Qualitative Criterion
  • Client
Exceptions for Minimum Risk Weight
Reason for the Minimum Qualitative Criterion
  • ?
  • Client
  • Reason for the Minimum Qualitative Criterion
Currency of the Minimum Stock Amount
  • CMS_CAG.MANDT == TCURC.MANDT
  • CMS_CAG.MIN_STOCK_CURR == TCURC.WAERS
Currency for Nominal Value of the Collateral Agreement
  • CMS_CAG.MANDT == TCURC.MANDT
  • CMS_CAG.NOM_VALUE_CURR == TCURC.WAERS
Scope of Cover of Credit Insurance
  • ?
  • Client
  • Scope of Cover of Credit Insurance
Foreign key relationship
  • ?
  • Client
  • Termination Type