SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

CMS_CAG Table in SAP | Collateral Agreement Details Table & Fields List

CMS_CAG is a SAP table coming under FS module and EA-FINSERV component.View details, Fields & related tables of CMS_CAG in SAP.

  • Table description : Collateral Agreement Details
  • Module : FS-CMS-MD
  • Parent Module : FS
  • Package : CMS_CORE
  • Software Component : EA-FINSERV
CMS_CAG table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP CMS_CAG Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
.INCLUDEPrimary Key for CMS_CAG    
CAG_GUIDGUID for Table CMS_CAGCMS_DTE_CAG_GUIDSYSUUID
.INCLUDESemantic Key for Table CMS_CAG    
CAGMTIDCollateral Agreement IDCMS_DTE_CAGIDCMS_CAGID
CAGMT_TYPECollateral Agreement TypeCMS_DTE_CAG_TYPCMS_CAG_TYP
.INCLUDECollateral Agreement Details    
.INCLUDENominal Value for Collateral Agreement    
NOM_VALUENominal Value of the Collateral AgreementCMS_DTE_CAG_NOMINAL_VALUECMS_AMOUNT
NOM_VALUE_CURRCurrency for Nominal Value of the Collateral AgreementCMS_DTE_CAG_NOMINAL_CURRWAERS
.INCLUDEAssessment Value details for a Collateral Agreement    
ASMT_AMTAssessment AmountCMS_DTE_CAG_ASMT_AMTCMS_AMOUNT
ASMT_CURRCurrency of Assessment ValueCMS_DTE_CAG_ASMT_CURRWAERS
ASMT_DATEDate on which the Assessment Value was CalculatedCMS_DTE_CAG_ASMT_DATECMS_DATE
.INCLUDECollateral Agreement Dates (DB Format )    
CAGMT_DATEDate on which Collateral Agreement was ConcludedCMS_DTE_CAG_DATECMS_DATE
VALID_FROMCollateral Agreement Document Valid-from DateCMS_DTE_CAG_VALID_FROMTZNTSTMPSL
VALID_TOCollateral Agreement Document Valid-to DateCMS_DTE_CAG_VALID_TOTZNTSTMPSL
.INCLUDEBasic data for a Collateral Agreement    
.INCLUDEAdministrative organization unit    
ADMIN_ORG_UNITAdministration Organizational UnitCMS_DTE_ADMINORGTEXT12
.INCLUDEBank area    
BANKAREABank Area in Collateral ManagementCMS_DTE_BANKAREACMS_BANKAREA
COUNTRY_KEYJurisdiction CountryCMS_DTE_COUNTRY_KEYLAND1
FLG_GLOBALFlag to indicate a Global Collateral AgreementCMS_DTE_FLG_CAG_GLOBALCMS_FLG_GLOBAL_CAGMT
SPL_MARKDOWN_PCTPercentage of Special MarkdownCMS_DTE_CAG_SPL_MARKDOWN_PCTCMS_PCT
SPL_MARKDOWN_AMTAmount of Special MarkdownCMS_DTE_CAG_SPL_MARKDOWN_AMTCMS_AMOUNT
SPL_MRKDOWN_CURRCurrency for Amount of Special MarkdownCMS_DTE_CAG_SPL_MRKDWN_CURRWAERS
DESCRIPTIONDescription of Collateral AgreementCMS_DTE_CAG_DESCCMS_DSC
UNIT_REL_FREQThe unit for period of Release FrequencyCMS_DTE_IND_CAG_REL_FREQ_UNITCMS_IND_CAG_FREQ_UNIT
PERIOD_REL_FREQPeriod for Frequency of Release of Collateral AgreementCMS_DTE_CAG_REL_FREQ_PERIODCMS_CAG_FREQ_PERIOD
OLD_CAGMTIDExternal/Old Collateral Agreement IDCMS_DTE_OLD_CAGIDCMS_OLD_CAGID
.INCLUDEBasel II relevant data    
MIN_QL_EXCEP_TYPExceptions for Minimum Risk WeightCMS_DTE_CAG_MIN_QUAL_EXCEP_TYPCMS_CAG_MIN_QUAL_EXCEP_TYP
MIN_QL_REASONReason for the Minimum Qualitative CriterionCMS_DTE_CAG_ATT_ID_TY_CAG001CMS_ATT_ID_TYP
FLG_MIN_QL_REQMTFlag:Minimum requirements fulfilled for CAG(for Basel II)CMS_DTE_FLG_CAG_MIN_QUAL_REQMTCMS_FLG_MIN_QUAL_REQMT
MIN_QL_CRITEMInimum Qualitative CriterionCMS_DTE_CAG_MIN_QUAL_CRITERIONCMS_CAG_MIN_QUAL_CRITERION
.INCLUDEAsset details for a Collateral Agreement    
PCT_ASSET_VALPercentage of the Asset Value used in Collateral AgreementCMS_DTE_PCT_AST_VALCMS_PCT
.INCLUDETermination rights data    
TERM_RIGHT_TYPTermination Right TypeCMS_DTE_TERM_RIGHT_TYPCMS_CAG_TERM_RIGHT_TYP
FIRST_TERM_DATEFirst possible date of terminationCMS_DTE_CAG_TERM_FSTPOS_DATECMS_DATE
UNIT_TERM_FREQThe Unit for Period of Termination FrequencyCMS_DTE_IND_CAG_TERM_FREQ_UNITCMS_IND_CAG_FREQ_UNIT
PERIOD_TERM_FREQPeriod for Frequency of Termination of Collateral AgreementCMS_DTE_CAG_TERM_FREQ_PERIODCMS_CAG_FREQ_PERIOD
NOTICE_PRD_UNITThe Unit for the Termination Notice PeriodCMS_DTE_IND_CAG_NOTICE_UNITCMS_IND_CAG_TIME_PRD_UNIT
REQ_NOTICE_PRDNotice Period Required to Terminate Collateral AgreementCMS_DTE_CAG_NOTICE_PERIODCMS_CAG_FREQ_PERIOD
TERM_NOTICE_DATEDate on which Termination Notice was SentCMS_DTE_CAG_TERM_NOTICE_DATECMS_DATE
TERM_REASONTermination TypeCMS_DTE_CAG_ATT_ID_TY_CAG002CMS_ATT_ID_TYP
TERM_GUAR_AMTAmount of Guarantee in the event of TerminationCMS_DTE_CAG_TERM_VALUECMS_AMOUNT
TERMINATION_CURRCurrency for Amount of Guarantee in the event of TerminationCMS_DTE_CAG_TERM_VALUE_CURRWAERS
.INCLUDEGuarantee specific data    
.INCLUDEGuarantee specific details    
GUAR_RATEGuarantee RateCMS_DTE_CAG_GUAR_RATECMS_PCT
FLG_COUNTER_GUARFlag for Counter GuaranteeCMS_DTE_FLG_CAG_CNTR_GUARCMS_FLG_CNTR_GUAR
FLG_CO_GUARFlag for Co-guaranteeCMS_DTE_FLG_CAG_CO_GUARCMS_FLG_CO_GUAR
FLG_FIXED_LIABTYFlag for Fixed LiabilityCMS_DTE_FLG_CAG_FIXED_LIABILTYCMS_FLG_FIXED_LIABILITY
FLG_DEF_LIABTYFlag for Default LiabilityCMS_DTE_FLG_CAG_DEF_LIABILITYCMS_FLG_DEF_LIABILITY
PCT_DEF_LIABTYDefault Liability in %CMS_DTE_FLG_CAG_PCT_DEF_LIABTYCMS_PCT
FLG_INCL_CAG_LNKFlag for back-up guarantee to be used in calculations or notCMS_DTE_FLG_CAG_INCL_LINKEDCMS_FLG_CAG_INCL_LINKED
IND_APPR_AUTHApproval from authoritiesCMS_DTE_IND_CAG_APPR_AUTHCMS_IND_CAG_APPR_AUTH
FLG_ENFORCEABLEAgreement directly enforceableCMS_DTE_FLG_CAG_ENFORCEABLECMS_FLG_DIR_ENFC
LENDING_RATELending Rate of a GuaranteeCMS_DTE_CAG_LRTE_PCTCMS_PCT
.INCLUDEReduction relation data    
UNIT_REDU_FREQUnit for Period of Frequency for Reduction in Guarantee ValuCMS_DTE_IND_CAG_RED_FREQ_UNITCMS_IND_CAG_FREQ_UNIT
PERIOD_REDU_FREQPeriod for Frequency of Reduction in Value of GuaranteeCMS_DTE_CAG_RED_FREQ_PERIODCMS_CAG_FREQ_PERIOD
REDU_AMTReduction in Amount of GuaranteeCMS_DTE_CAG_REDU_AMTCMS_AMOUNT
REDU_CURRCurrency of the Reduced Amount of the GuaranteeCMS_DTE_CAG_REDU_AMT_CURRWAERS
REDU_PCTPercentage of Reduction in the Value of a GuaranteeCMS_DTE_CAG_REDU_PCTCMS_PCT
REDU_START_DATEDate from which Guarantee Value is ReducedCMS_DTE_CAG_REDU_START_DATECMS_DATE
REDU_END_DATEEnd Date for Reduction in Amount of GuaranteeCMS_DTE_CAG_REDU_END_DATECMS_DATE
REDU_LAST_DATELast date of reduction of valueCMS_DTE_CAG_REDU_LAST_DATECMS_DATE
.INCLUDETransfer specific details    
FLG_LEASING_TXNFlag: Transfer is part of a leasing transactionCMS_DTE_FLG_CAG_LEASING_TXNCMS_FLG_LEASING_TRANSACTION
IND_LESSOR_LIENIndicator for Lessor Lien on Collateral AgreementCMS_DTE_IND_CAG_LESSOR_LIENCMS_IND_CAG_LESSOR_LIEN
IND_ACC_LIABLESpecifies the applicability of accessories liabilityCMS_DTE_IND_CAG_ACC_LIABLECMS_IND_CAG_ACC_LIABLE
FLG_ASGMT_ARFlag for Assignment of Accounts Receivables(AR) from SaleCMS_DTE_FLG_CAG_AR_FRM_SALECMS_FLG_ASGMT_RBL_FROM_SALE
.INCLUDEMinimum stock data    
MIN_STOCK_AMTMinimum stock Amount agreed in the Collateral AgreementCMS_DTE_CAG_MIN_STOCK_AMTCMS_AMOUNT
MIN_STOCK_CURRCurrency of the Minimum Stock AmountCMS_DTE_CAG_MIN_STOCK_AMT_CURRWAERS
FLG_ADDNL_RBLFlag for Additional receivableCMS_DTE_FLG_CAG_ADDNL_RBLCMS_FLG_ADDNL_RBL
ADDNL_RBL_DATEDate on which Additional Receivable was AcceptedCMS_DTE_CAG_DATE_ADDNL_RBLCMS_DATE
.INCLUDEPledge/Assignment details    
IND_GBC_LIENGBC Lien on AgreementCMS_DTE_IND_CAG_GBC_LIENCMS_IND_CAG_GBC_LIEN
FLG_DISCLFlag to indicator whether the Agreement is disclosed or notCMS_DTE_FLG_CAG_DISCL_PLEDGECMS_FLG_DISCL_PLEDGE
DISCL_DATEDate of Disclosure to Third-party DebtorCMS_DTE_CAG_DISCL_DATECMS_DATE
.INCLUDEAssignment reason    
ASGMT_REASONReason for AssignmentCMS_DTE_CAG_ATT_ID_TY_CAG006CMS_ATT_ID_TYP
.INCLUDELand Charge specific data    
.INCLUDELand Charge specific interest details    
INT_RATELand Charge Interest RateCMS_DTE_CAG_LCHG_INT_RATECMS_PCT
INCIDENTAL_PAYMTIncidental Payments in PercentageCMS_DTE_CAG_LCHG_INCD_PAYMTCMS_PCT
UNIT_PMT_FREQThe unit for period of payment frequencyCMS_DTE_IND_CAG_PYMT_FREQ_UNITCMS_IND_CAG_FREQ_UNIT
PERIOD_PMT_FREQPeriod for Frequency of Payment of Land Charge InterestCMS_DTE_CAG_PYMT_FREQ_PERIODCMS_CAG_FREQ_PERIOD
INT_START_DATEStart Date for Land Charge Interest CalculationCMS_DTE_CAG_LCHG_INT_START_DATCMS_DATE
NUM_YR_LCHG_INTNumber of Years the Land Charge Interest can be CapitalizedCMS_DTE_CAG_LCHG_INT_YRCMS_CAG_LCHG_INT_YR
.INCLUDEEnforcement details for a land charge    
IND_ENFORCMT_TYPEnforcement TypeCMS_DTE_IND_CAG_LCHG_ENFC_TYPCMS_IND_CAG_LCHG_ENFC_TYP
ENFORCMT_AMTEnforcement AmountCMS_DTE_CAG_LCHG_ENFC_AMTCMS_AMOUNT
ENFORCMT_CURRCurrency for Enforcement Amount of Land ChargeCMS_DTE_CAG_LCHG_ENFC_AMT_CURRWAERS
REF_ENFORCMT_AMTReference amount for part (Equal,Secondar) enforcebilityCMS_DTE_CAG_LCHG_ENFC_REF_AMTCMS_AMOUNT
RANKRank of the Land Charge Enforceable AmountCMS_DTE_CAG_LCHG_ENFC_RANKCMS_CAG_LCHG_ENFC_RANK
ENFORCMT_TITLEIndicator for Enforcement TitleCMS_DTE_IND_CAG_LCHG_ENFC_TITLCMS_IND_CAG_LCHG_ENFC_TITLE
.INCLUDEHeritable building right (HBR) details    
UNIT_INT_FREQUnit for period of Payment Frequency of HBR interestCMS_DTE_IND_CAG_HBR_INT_UNITCMS_IND_CAG_FREQ_UNIT
PERIOD_INT_FREQPayment Frequency Period for HBR interestCMS_DTE_CAG_HBR_INT_PERIODCMS_CAG_FREQ_PERIOD
FLG_INTEREST_INCFlag for increase in HBR interestCMS_DTE_FLG_LCHG_INC_INTCMS_FLG_LCHG_INC_INT
UNIT_INC_FREQUnit for Frequency Period of Increase in HBR InterestCMS_DTE_IND_CAG_HBR_INC_UNITCMS_IND_CAG_FREQ_UNIT
PERIOD_INC_FREQFrequency Period for Increase in HBR InterestCMS_DTE_CAG_HBR_INC_PERIODCMS_CAG_FREQ_PERIOD
INC_PCTPercentage Increase in Heritable Building Rights AmountCMS_DTE_CAG_LCHG_INC_PCTCMS_PCT
INC_AMTIncrease in Heritable Building Rights AmountCMS_DTE_CAG_LCHG_INC_AMTCMS_AMOUNT
INC_CURRCurrency for Increase in HBR amountCMS_DTE_CAG_LCHG_INC_AMT_CURRWAERS
INC_START_DATEStart date for Increase in Heritable Building Right InterestCMS_DTE_CAG_LCHG_INC_START_DATCMS_DATE
IND_HBR_WAIVERIndicator for Waiver of HBR EnforcementCMS_DTE_IND_CAG_LCHG_HBR_WAIVECMS_IND_CAG_LCHG_HBR_WAIVER
INC_LAST_DATELast date of Increase in Heritable Building Right InterestCMS_DTE_CAG_LCHG_INC_LAST_DATECMS_DATE
.INCLUDELand Charge specific details    
FLG_COLL_LCHGFlag: Collective Land ChargeCMS_DTE_FLG_CAG_LCHG_COLLCMS_FLG_CAG_LCHG_COLLECTIVE
FLG_CHARGE_CERTFlag: Land Charge certificate existsCMS_DTE_FLG_CAG_LCHG_CERTCMS_FLG_LCHG_CERT
CHARGE_CERT_NUMCharge Certificate NumberCMS_DTE_CAG_LCHG_CERT_NUMCMS_LCHG_CERT_NUM
FILE_NUMFile NumberCMS_DTE_CAG_LCHG_FILE_NUMCMS_LCHG_FILE_NUM
.INCLUDEInsurance Coverage data    
SCOPE_INS_COVERScope of Cover of Credit InsuranceCMS_DTE_CAG_ATT_ID_TY_CAG004CMS_ATT_ID_TYP
.INCLUDEOrganization unit structure: Collateral Agreements    
ORG_UNIT1Organizational Unit 1: Collateral AgreementCMS_DTE_CAG_ORG_UNIT1CMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2: Collateral AgreementCMS_DTE_CAG_ORG_UNIT2CMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3: Collateral AgreementCMS_DTE_CAG_ORG_UNIT3CMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4: Collateral AgreementCMS_DTE_CAG_ORG_UNIT4CMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5: Collateral AgreementCMS_DTE_CAG_ORG_UNIT5CMS_ORG_UNIT
.INCLUDELiquidation data    
LIQD_MODEMode of Liquidation decision for the pool agreementCMS_DTE_LIQD_MODECMS_LIQD_MODE
.INCLUDECorrespondence related attributes for CAG    
COR_ROLECorrespondence roleCMS_DTE_COR_ROLECORR_ROLE_KK
.INCLUDEAgreement Thresholds    
REL_THRESHOLDLimit above which the Collaterals can be Released from PoolCMS_DTE_CAG_RELEASE_THRESHOLDCMS_PCT
.INCLUDEStucture to record history of changes in all application tab    
CREATED_BYLogin ID of the User who created the RecordCMS_DTE_USERCMS_USER
CREATED_ATCreation TimestampCMS_DTE_CREATED_ATTZNTSTMPS
CHANGED_BYLast Changed ByCMS_DTE_LAST_CHNG_USERCMS_USER
CHANGED_ATChange TimestampCMS_DTE_CHANGED_ATTZNTSTMPS
SOURCEOFENTRYSource of EntryCMS_DTE_SOURCE_OF_ENTRYCMS_SOURCE

CMS_CAG related tables

TableNote
CMS_CAGCollateral Agreement Details
CMS_CAG_PORCollateral Agreement Portion details
CMS_CAG_RBLCollateral Agreement - Receivable Link Details
CRMC_FS_CAGCATCollateral Agreement details
CRMC_FS_CAGTYPCollateral Agreement Types details
TCMS_CAG_CATCollateral Agreement Category Details
CMS_CAG_TRMCSTTermination and Cost details for Agreement/Agreement BP
CMS_CAG_BPCollateral Agreement-Business Partner Relationship
CMS_CAG_DOCCollateral Agreement Documents
CMS_CHGAsset - Collateral Agreement Relationship
CRMC_FSCA_AG_TYCollateral Agreement Type
CRMC_FSCA_AG_TYTCollateral Agreement Type - Text
CRMC_FS_CAGCAT_TCollateral Agreement Category - Text Table
CRMC_FS_CAGTYP_TCollateral Agreement Type - Text Table
CRMC_FS_CGAS_TYPAsset - Collateral Agreement Type Relationship
Vendor bank details and iban details TablesAgreement TablesScheduling agreement TablesRebate agreement TablesContract agreement TablesAgreement number TablesOutline agreement TablesAgreement attachment Tables

Latest Table Searches

Sap handling unit packaging material table in SAP
How to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP

Popular Table Searches

Hdfc bank ltd company code for zinghr table in SAP
Link between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com