1. SAP Tutorial
  2. Financial Services

CMS_CHG SAP table for – Asset – Collateral Agreement Relationship

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

SAP CMS_CHG table

Table CMS_CHG technical data

TableCMS_CHG
Data storingAsset – Collateral Agreement Relationship
ModuleFS
Sub ModuleFS-CMS-MD
SAP PackageCMS_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_CHG 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_CHG 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_CHG
    Its a key field.
  • CHG_GUID : GUID for Table CMS_CHG
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link to CMS_AST Table
  • AST_GUID : GUID for Table CMS_AST
    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 : Asset-Collateral Agreement Relationship
  • .INCLUDE : Charge details
  • DESCRIPTION : Description for Charges
    Its data type is CHAR (Character String) with field length 30
  • RANKING_ORDER : Ranking of a Collateral Agreement in an Asset
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SEQUENCE : Sequence of an Asset in a Collateral agreement
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Registration data of a charge
  • REG_ENTRY_NO : Register Number
    Its data type is CHAR (Character String) with field length 32
  • REG_DATE : Date on which the Land Charge was Registered
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Asset data in a Charge
  • AST_PART_NR : Numerator in Business Partner Share of Asset
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • AST_PART_DN : Denominator in the Business Partner Share of Asset
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • AST_QTY : Size of the Asset used as Charge
    Its data type is QUAN (Quantity field) with field length 13
  • AST_VALUE : Amount of Asset used as Charge
    Its data type is CURR (Currency Field) with field length 17
  • .INCLUDE : Assessment data of a Charge
  • ASMT_AMT : Assessment amount of a charge
    Its data type is CURR (Currency Field) with field length 17
  • ASMT_CURR : CMS_DTE_CHG_ASMT_CURR
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ASMT_DATE : Date of assessment
    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

    • CMS_CHG related tables

    • TCMS_PRD : Product description
    • TCMS_COST_TYP : Cost type table
    • CMS_PRD_BP : Product- Business Partner Relationship
    • CMS_CAG_RBL : Collateral Agreement – Receivable Link Details
    • TCMS_CAG_ORG : Group table for Collateral Agreement Number ranges
    • TCMS_CAG_BLKRS_T : Reason for portion being blocked (text table)
    • CMS_ACG : Approved Coverage Gap Details
    • TCMS_CAG_SA_CT : Special Arrangement Categories
    • TCMS_CAG_SA_TY_T : Special Arrangement Type Text
    • TCMS_SAS_TYP_T : Sub-asset type (text table)
    • CMS_CAG_POR : Collateral Agreement Portion details
    • TCMS_PRD_CAG : Product type -Collateral Agreement type Relationship
    • TCMS_AST_TYP_T : Asset Type (Text Table)
    • TCMS_CHG_TYP : Asset – Collateral agreement type relationship
    • TCMS_CAG_RNPER : Min notice period reqd before exercising termination rights
    • CMS_CAG_DOC : Collateral Agreement Documents
    • TCMS_PRD_CAT_T : Product Category (Text Table)
    • CMS_CAG_BP : Collateral Agreement-Business Partner Relationship
    • TCMS_CAG_BREAS : Reason for the portion being blocked
    • TCMS_BANKAREA_T : Text: Bankarea

    CMS_CHG related transaction codes under SAP package CMS_CORE

    • CMS_CAG_02 : Change Collateral Agreement
    • CMS_CUS_14 : Product Sets
    • CMS_CUS_BDT_106 : CMS-Cust: Notes on Roles
    • CMS_CUS_BDT_013 : CMS Control: BP Roles
    • CMS_CUS_BDT_101 : CMS Cust: BP Role Field Grouping
    • CMS_CUS_BDT_006 : CMS Control: Screen Seq.
    • CMS_CUS_BDT_001 : CMS Control: Applications
    • CMSORG : Organizational Unit in CMS
    • CMS_CUS_BDT_023 : CMS Tax: Data Sets
    • CMS_CAG_03 : Display Collateral Agreement
    • CMS_CUS_BDT_105 : CMS-Cust:Fld.modif.exter.application
    • CMS_CUS_BDT_107 : CMS Cust: Where-Used List
    • CMS_CUS_02 : Credit Systems
    • CMS_CUS_BDT_020 : CMS Control: Search Help
    • CMS_CUS_BDT_100 : CMS Cust: Field Grouping Activity
    • CMS_CUS_ACG_REL : Assign Rel Object to Rel Procedure
    • CMS_CUS_BDT_017 : CMS-Control: External applications
    • CMS_CUS_03 : Risk Codes
    • CMS_CUS_BDT_007 : CMS Control: Events
    • CMS_CUS_01 : Object Systems

    Related References

    Related Tutorials

    TCMS_CHG_TYP SAP table for – Asset – Collateral agreement type relationship

    TCMS_CHG_TYP table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Asset...

    CMS_CAG_BP SAP table for – Collateral Agreement-Business Partner Relationship

    CMS_CAG_BP table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Collateral...

    TCMS_PRD_CAG SAP table for – Product type -Collateral Agreement type Relationship

    TCMS_PRD_CAG table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Product...

    CMS_CAG_03 SAP tcode for – Display Collateral Agreement

    CMS_CAG_03 tcode in SAP FS (Collateral Management System in FS) module. This transaction code is used for Display Collateral Agreement....

    CMS_CAG_02 SAP tcode for – Change Collateral Agreement

    CMS_CAG_02 tcode in SAP FS (Collateral Management System in FS) module. This transaction code is used for Change Collateral Agreement....

    CMS_CAG_POR SAP table for – Collateral Agreement Portion details

    CMS_CAG_POR table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Collateral...

    TCMS_CAG_TYP_T SAP table for – Collateral Agreement type text elements

    TCMS_CAG_TYP_T table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Collateral...

    «
    »