I_AgreementSpecialArrangement

Agreement Special Arrangement Details | view: ICAGSA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_CAG_SA
Column Name Description
AgrmtSpecialArrangementUUID Primary key for CMS_CAG_SA
Column Name Description
💲 Currency of Special Arrangement: Nominal Value (AgrmtSpclArrgmtNominalCurrency):
AgrmtSpclArrgmtNominalAmount Special Arrangement Nominal Value
💲 Currency of Special Arrangement: Assessment Amount (AgrmtSpclArrgmtAssessmentCrcy):
AgrmtSpclArrgmtAssessmentAmt Special Arrangement Assessment Amount
Column Name Description
Column Name Description
AgrmtSpclArrgmtValidFromDate Date from which Special Arrangement Stands Valid
AgrmtSpclArrgmtValidToDate Date from which Special Arrangement Stands Valid
AgrmtSpclArrgmtPurchaseDate Purchase Agreement Date of Special Arrangement
Column Name Description
AgrmtSpclArrgmtProcgStatus Processing Status of Special Arrangement Show values
AgrmtSpclArrgmtLegalStatus Special Arrangement Legal Status Show values
Column Name Description Domain name
AgrmtSpecialArrangementRefUUID Link Key for CMS_CAG_SA SYSUUID
AgreementSpecialArrangementID Special Arrangement ID CMS_CAG_SA_ID
AgrmtSpclArrgmtBankKey Bank Keys BANKK
AgrmtSpclArrgmtBankAcctNmbr Bank account number BANKN35
AgrmtSpclArrgmtPurchaseID Pruchase Agreement ID of a Special Arrangement CMS_CAG_SA_REFAGMT_ID
AgrmtSpclArrgmtDescription Description for Special Arrangement CMS_DSC
Master Data Relations Join Conditions
Special Arrangement Type I_AGREEMENTSPECIALARRANGEMENT.MANDT == TCMS_CAG_SA_TY.MANDT
Currency of Special Arrangement: Assessment Amount
  • Client
  • Currency of Special Arrangement: Assessment Amount
  • I_AGREEMENTSPECIALARRANGEMENT.MANDT == TCURC.MANDT
  • I_AGREEMENTSPECIALARRANGEMENT.AGRMTSPCLARRGMTASSESSMENTCRCY == TCURC.WAERS
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • I_AGREEMENTSPECIALARRANGEMENT.MANDT == T005.MANDT
  • I_AGREEMENTSPECIALARRANGEMENT.AGRMTSPCLARRGMTBANKCOUNTRY == T005.LAND1
Currency of Special Arrangement: Nominal Value
  • Client
  • Currency of Special Arrangement: Nominal Value
  • I_AGREEMENTSPECIALARRANGEMENT.MANDT == TCURC.MANDT
  • I_AGREEMENTSPECIALARRANGEMENT.AGRMTSPCLARRGMTNOMINALCURRENCY == TCURC.WAERS