CMS_CAG_SA SAP table for – Special Arrangements

Here we would like to draw your attention to CMS_CAG_SA table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_CAG_SA is a SAP standard transp table used for storing Special Arrangements related data in SAP. It comes under the package CMS_CORE.

SAP CMS_CAG_SA table

Table CMS_CAG_SA technical data

TableCMS_CAG_SA
Data storingSpecial Arrangements
ModuleFS
Sub ModuleFS-CMS-MD
SAP PackageCMS_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_CAG_SA Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_CAG_SA table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary Key for CMS_CAG_SA
    Its a key field.
  • CAG_SA_GUID : Primary key for CMS_CAG_SA
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link Key for CMS_CAG_SA
  • REF_GUID : Link Key for CMS_CAG_SA
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Special Arrangement Details
  • SA_TYPE : Special Arrangement Type
    Its data type is CHAR (Character String) with field length 6
  • SA_ID : Special Arrangement ID
    Its data type is CHAR (Character String) with field length 40
  • PROC_STAT : Processing Status of Special Arrangement
    Its data type is CHAR (Character String) with field length 2
  • LEGAL_STAT : Special Arrangement Legal Status
    Its data type is CHAR (Character String) with field length 2
  • VALID_FROM : Date from which Special Arrangement Stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALID_TO : Date from which Special Arrangement Stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NOM_VALUE : Special Arrangement Nominal Value
    Its data type is CURR (Currency Field) with field length 17
  • NOM_VALUE_CURR : Currency of Special Arrangement: Nominal Value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ASMT_AMT : Special Arrangement Assessment Amount
    Its data type is CURR (Currency Field) with field length 17
  • ASMT_AMT_CURR : Currency of Special Arrangement: Assessment Amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BANK_CTRY : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • BANK_KEY : Bank Keys
    Its data type is CHAR (Character String) with field length 15
  • BANK_ACCT : Bank account number
    Its data type is CHAR (Character String) with field length 35
  • BANK_CTRL_KEY : Bank Control Key
    Its data type is CHAR (Character String) with field length 2
  • REF_AGMT_ID : Pruchase Agreement ID of a Special Arrangement
    Its data type is CHAR (Character String) with field length 40
  • REF_AGMT_DATE : Purchase Agreement Date of Special Arrangement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DESCRIPTION : Description for Special Arrangement
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Stucture to record history of changes in all application tab
  • CREATED_BY : Login ID of the User who created the Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_AT : Creation Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Change Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOURCEOFENTRY : Source of Entry
    Its data type is CHAR (Character String) with field length 32