- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Business Partner (FS-BP)
- Claims Management (FS-CM)
- Collateral Management System (FS-CMS)
- Collections/Disbursements (FS-CD)
- Loans Management (FS-CML)
- Policy Management (FS-PM)
- Regulatory reporting for insurance companies (FS-SR)
- SAP Policy Management for Auto Insurance (FS-PMA)
- Value Adjustment (FS-RBD)
- msg.PM Connection (FS-MPM)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
CMS_CAG
Collateral Agreement Details
|
#masterdata
|
Component: Master Data
- 🔑 Keys (2)
- 💰 Amounts (12)
- ∑ Quantities
- 📅 Dates (15)
- ☰ Categorical (26)
- Other (45)
- 🔗 Relations (19)
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
|
|
Currency of Assessment Value | |
Key of Bank Country/Region
| |
Foreign key for Agreement type
|
|
Correspondence role
| |
Currency: Expected Proceed | |
GBC Lien on Agreement
|
|
Indicator for Waiver of HBR Enforcement |
|
Indicator for Lessor Lien on Collateral Agreement |
|
Currency of Liquidation Value | |
Liquidation Reason
|
|
Foreign Key for Mandt | CMS_CAG.MANDT == T000.MANDT |
MInimum Qualitative Criterion
|
|
Exceptions for Minimum Risk Weight |
|
Reason for the Minimum Qualitative Criterion
|
|
Currency of the Minimum Stock Amount | |
Currency for Nominal Value of the Collateral Agreement | |
Scope of Cover of Credit Insurance
|
|
Foreign key relationship
|
|