The CMS_RIG table in SAP ERP or S/4HANA stores CMS: Rights table. Includes claims, patents, other rights. data. There are total 37 fields in CMS_RIG table. The CMS: Rights table. Includes claims, patents, other rights. table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMS_RIG table. It is in Collateral Management Rights (CMS_OMS_RIG) ABAP package and is part of the Rights (FS-CMS-MD-RIG) module.
SAP CMS_RIG Table Fields
Following is the list of fields that are available in SAP CMS_RIG table. The primary key fields of the table are MANDT (Client), RIG_GUID (Rights GUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| RIG_GUID | Rights GUID | CMS_DTE_RIG_GUID | RAW (16) | |
| RIG_CATEGORY | Object Category | CMS_DTE_OMS_OBJ_CAT | CHAR (6) | |
| RIG_TYP | Right Type | CMS_DTE_RIG_TYP | CHAR (6) | |
| RIG_ID | Rights ID | CMS_DTE_RIG_ID | CHAR (40) | |
| ADD_DESCR | Additional description of the right | CMS_DTE_CLM_DESC | CHAR (30) | |
| DURATION_BEGIN | Start date of the right | CMS_DTE_RIG_BEGIN | DATS (8) | |
| DURATION_END | Validity End Date of the Right or Patent | CMS_DTE_RIG_END | DATS (8) | |
| CLASSIFICATION | Classification | CMS_DTE_MOV_TYPE_FEAT | TCMS_OMS_FEAT | CHAR (6) |
| EXT_ITM_NO | Ext. Item no / Number for identification of the objects | CMS_DTE_OMS_EXT_ITM_NO | CHAR (40) | |
| EXT_REFERENCE | Reference number for the legacy system | CMS_DTE_OMS_REF_ID | CHAR (32) | |
| NOTAR_DATE | Notarization Date | CMS_DTE_RIG_NOT_DAT | DATS (8) | |
| REGIS_DATE | Date of Patent Registration | CMS_DTE_RIG_REG_DAT | DATS (8) | |
| PATENT_NO | Patent Number | CMS_DTE_RIG_PATENT_NO | CHAR (40) | |
| REGISTRY_NO | No. of the Register in the Patent Office | CMS_DTE_RIG_REG_NO | CHAR (20) | |
| PATENT_OFFICE | Patent Office | CMS_DTE_RIG_PT_OFF | CHAR (30) | |
| ADD_PPTY_RIG | Additional Property Rights that are Available | CMS_DTE_RIG_AV_PTY | TCMS_ATT_ID_TY | CHAR (6) |
| PAT_PARENT_GUID | Links to Parent Patent – GUID of the Parent | CMS_DTE_PARENT_GUID | RAW (16) | |
| DUE_DATE | Due date of a claim | CMS_DTE_CLM_DUE_DATE | DATS (8) | |
| COMPOSITION | Composition of the claim | CMS_DTE_CLM_COMP | CHAR (30) | |
| SAV_SUM | Savings sum in Percentage (In building savings contracts) | CMS_DTE_CLM_SAV_SUM | DEC (10) | |
| PROVBADDEBT_AMT | Provision doubtful debt amount | CMS_DTE_CLM_DBTDBT_AMT | CURR (17) | |
| PROVBADDEBT_CURR | Currency of Provision of doubfull debt | CMS_DTE_CLM_DBTDBT_CURR | * | CUKY (5) |
| ADDR_ID | Address of the object (for build.sav.contr./rental claim) | CMS_DTE_CLM_ADDRESS | CHAR (10) | |
| ACC_NUMBER | Account number | CMS_DTE_CLM_ACC_NUMBER | CHAR (35) | |
| BANK_COUNTRY_KEY | Bank country key | CMS_DTE_CLM_BNK_CTRY_KY | T005 | CHAR (3) |
| BANK_KEY | Bank Key | CMS_DTE_CLM_BNK_KEY | CHAR (15) | |
| BANK_CTRL_KEY | Bank Control Key | BKONT | CHAR (2) | |
| ADMIN_ORG_UNIT | Administration Organizational Unit | CMS_DTE_ADMINORG | CHAR (12) | |
| BANKAREA | Bank Area in Collateral Management | CMS_DTE_BANKAREA | * | CHAR (4) |
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR (12) | |
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC (15) | |
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR (12) | |
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC (15) | |
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR (32) | |
| BUPR_ID | Business Process ID | CMS_DTE_BUPR_ID | RAW (16) | |
| BUPR_TYPE_CODE | Business Process Type Code | CMS_DTE_BUPR_TYP_CODE | CHAR (6) |
