CMS_RIG SAP table for – CMS: Rights table. Includes claims, patents, other rights.

Here we would like to draw your attention to CMS_RIG 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_RIG is a SAP standard transp table used for storing CMS: Rights table. Includes claims, patents, other rights. related data in SAP. It comes under the package CMS_OMS_RIG.

SAP CMS_RIG table

Table CMS_RIG technical data

TableCMS_RIG
Data storingCMS: Rights table. Includes claims, patents, other rights.
ModuleFS
Sub ModuleFS-CMS-MD-RIG
SAP PackageCMS_OMS_RIG
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_RIG 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_RIG table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Rights primary key
    Its a key field.
  • RIG_GUID : Rights GUID
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Semantic Key for insurance
  • RIG_CATEGORY : Object Category
    Its data type is CHAR (Character String) with field length 6
  • RIG_TYP : Right Type
    Its data type is CHAR (Character String) with field length 6
  • RIG_ID : Rights ID
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Right Specific data
  • .INCLUDE : Rights Common data
  • ADD_DESCR : Additional description of the right
    Its data type is CHAR (Character String) with field length 30
  • DURATION_BEGIN : Start date of the right
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DURATION_END : Validity End Date of the Right or Patent
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CLASSIFICATION : Classification
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Common OMS data
  • EXT_ITM_NO : Ext. Item no / Number for identification of the objects
    Its data type is CHAR (Character String) with field length 40
  • EXT_REFERENCE : Reference number for the legacy system
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Right Specific data
  • NOTAR_DATE : Notarization Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REGIS_DATE : Date of Patent Registration
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PATENT_NO : Patent Number
    Its data type is CHAR (Character String) with field length 40
  • REGISTRY_NO : No. of the Register in the Patent Office
    Its data type is CHAR (Character String) with field length 20
  • PATENT_OFFICE : Patent Office
    Its data type is CHAR (Character String) with field length 30
  • ADD_PPTY_RIG : Additional Property Rights that are Available
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Link to rights primary key
  • PAT_PARENT_GUID : Links to Parent Patent – GUID of the Parent
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Claim data
  • DUE_DATE : Due date of a claim
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • COMPOSITION : Composition of the claim
    Its data type is CHAR (Character String) with field length 30
  • SAV_SUM : Savings sum in Percentage (In building savings contracts)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PROVBADDEBT_AMT : Provision doubtful debt amount
    Its data type is CURR (Currency Field) with field length 17
  • PROVBADDEBT_CURR : Currency of Provision of doubfull debt
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Address ID
  • ADDR_ID : Address of the object (for build.sav.contr./rental claim)
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Account Details
  • ACC_NUMBER : Account number
    Its data type is CHAR (Character String) with field length 35
  • BANK_COUNTRY_KEY : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • BANK_KEY : Bank Key
    Its data type is CHAR (Character String) with field length 15
  • BANK_CTRL_KEY : Bank Control Key
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Administrative organization unit
  • ADMIN_ORG_UNIT : Administration Organizational Unit
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Bank area
  • BANKAREA : Bank Area in Collateral Management
    Its data type is CHAR (Character String) with field length 4
  • .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