CMS_REL SAP table for – Relationship details

Here we would like to draw your attention to CMS_REL 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_REL is a SAP standard transp table used for storing Relationship details related data in SAP. It comes under the package CMS_COMMON.

SAP CMS_REL table

Table CMS_REL technical data

TableCMS_REL
Data storingRelationship details
ModuleFS
Sub ModuleFS-CMS
SAP PackageCMS_COMMON
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_REL 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_REL 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_REL
    Its a key field.
  • REL_GUID : GUID for Table CMS_REL
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link keys for table CMS_REL
  • REL_TYP : Relationship type
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Relationship Source Link Key
  • SOURCE_GUID : Relationship Source GUID
    Its data type is RAW (Byte string) with field length 16
  • SRC_SEC_GUID : Relationship Source Secondary GUID
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Relationship Destination Link Key
  • DESTINATION_GUID : Relationship destination GUID
    Its data type is RAW (Byte string) with field length 16
  • DST_SEC_GUID : Relationship destination GUID
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Relationship data
  • .INCLUDE : Relationship dates(DB Format)
  • VALID_FROM : Date from which the relationship came into effect
    Its data type is NUMC (Character String with Digits Only) with field length 15
  • VALID_TO : Date until which the relationship stands valid
    Its data type is NUMC (Character String with Digits Only) with field length 15
  • .INCLUDE : Relationship Details
  • REL_RANK : Relationship Rank-Order of the source linked to destination
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REL_PRIORITY : Priority of a Relationship
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CALC_TYP : Calculation type for relations of collateral agreements
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Realtionship Object data
  • REL_OBJ : Relationship Object
    Its data type is CHAR (Character String) with field length 6
  • .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