CMS_CAG_POR SAP table for – Collateral Agreement Portion details

Here we would like to draw your attention to CMS_CAG_POR 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_POR is a SAP standard transp table used for storing Collateral Agreement Portion details related data in SAP. It comes under the package CMS_CORE.

SAP CMS_CAG_POR table

Table CMS_CAG_POR technical data

TableCMS_CAG_POR
Data storingCollateral Agreement Portion details
ModuleFS
Sub ModuleFS-CMS-MD
SAP PackageCMS_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_CAG_POR 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_POR 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_POR
    Its a key field.
  • CAG_POR_GUID : GUID for Table CMS_CAG_POR
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link to CMS_CAG Table
  • CAG_GUID : GUID for Table CMS_CAG
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Collateral Agreement Portion details
  • .INCLUDE : Basic details for Portions
  • PORTIONID : Identification of the Collateral Agreement Portion
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PORTION_VALUE : Value of the Collateral Agreement Portion
    Its data type is CURR (Currency Field) with field length 17
  • PCT_CAGMT_VALUE : Size of Collateral Agreement Portion in Collateral Agreement
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • IND_BLOCKING_TYP : Blocking Category for Collateral Agreement Portion
    Its data type is CHAR (Character String) with field length 2
  • BLOCKING_REASON : Portion Restriction
    Its data type is CHAR (Character String) with field length 6
  • REF_CAGMTID : Collateral Agreement ID based on another Colateral Agreement
    Its data type is CHAR (Character String) with field length 40
  • PRIORITY_PORTION : Specifies Ranking Ratio for Portion of Collateral Agreement
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • IND_RBL_TYP : Indicator for Receivable Type
    Its data type is CHAR (Character String) with field length 2
  • FILE_NUM : Serial Number of the Record in a Physical Location
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Portion Assignment details
  • IND_ASGMT : Role in which Collateral Agreement Portion is Assigned
    Its data type is CHAR (Character String) with field length 2
  • ASGMT_DATE : Date on which Collateral Agreement Portion is Assignment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INT_START_DATE : Start Date for Land Charge Interest Calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Collateral Agreement Portion Dates (DB Format )
  • VALID_FROM : Date from which Collateral Agreement Portion Stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALID_TO : Date until which Collateral Agreement Portion Stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .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