SAP CMS_RIG CMS: Rights table. Includes claims, patents, other rights. Table data and field list

CMS_RIG is a standard SAP Table which is used to store CMS: Rights table. Includes claims, patents, other rights. data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_RIG table consists of various fields, each holding specific information or linking keys about CMS: Rights table. Includes claims, patents, other rights. data available in SAP. These include RIG_GUID (Rights GUID), RIG_CATEGORY (Object Category), RIG_TYP (Right Type), RIG_ID (Rights ID)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMS_RIG table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP CMS_RIG table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_RIG table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
RIG_GUID	Rights GUID	CMS_DTE_RIG_GUID	RAW	16			SYSUUID
RIG_CATEGORY	Object Category	CMS_DTE_OMS_OBJ_CAT	CHAR	6	Assigned to domain		CMS_OBJ_CAT
RIG_TYP	Right Type	CMS_DTE_RIG_TYP	CHAR	6			CMS_RIG_TYP
RIG_ID	Rights ID	CMS_DTE_RIG_ID	CHAR	40		ALPHA	CMS_MOV_ID
ADD_DESCR	Additional description of the right	CMS_DTE_CLM_DESC	CHAR	30			CMS_DSC
DURATION_BEGIN	Start date of the right	CMS_DTE_RIG_BEGIN	DATS	8			CMS_DATE
DURATION_END	Validity End Date of the Right or Patent	CMS_DTE_RIG_END	DATS	8			CMS_DATE
CLASSIFICATION	Classification	CMS_DTE_MOV_TYPE_FEAT	CHAR	6	TCMS_OMS_FEAT		CMS_MOV_TYPE_FEAT
EXT_ITM_NO	Ext. Item no / Number for identification of the objects	CMS_DTE_OMS_EXT_ITM_NO	CHAR	40		ALPHA	CMS_OMS_ID
EXT_REFERENCE	Reference number for the legacy system	CMS_DTE_OMS_REF_ID	CHAR	32			CMS_OMS_REFID
NOTAR_DATE	Notarization Date	CMS_DTE_RIG_NOT_DAT	DATS	8			DATUM
REGIS_DATE	Date of Patent Registration	CMS_DTE_RIG_REG_DAT	DATS	8			DATUM
PATENT_NO	Patent Number	CMS_DTE_RIG_PATENT_NO	CHAR	40			CMS_OMS_ID
REGISTRY_NO	No. of the Register in the Patent Office	CMS_DTE_RIG_REG_NO	CHAR	20			CMS_RIG_REG_NO
PATENT_OFFICE	Patent Office	CMS_DTE_RIG_PT_OFF	CHAR	30			CMS_DSC
ADD_PPTY_RIG	Additional Property Rights that are Available	CMS_DTE_RIG_AV_PTY	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
PAT_PARENT_GUID	Links to Parent Patent - GUID of the Parent	CMS_DTE_PARENT_GUID	RAW	16			SYSUUID
DUE_DATE	Due date of a claim	CMS_DTE_CLM_DUE_DATE	DATS	8			DATUM
COMPOSITION	Composition of the claim	CMS_DTE_CLM_COMP	CHAR	30			CMS_DSC
SAV_SUM	Savings sum in Percentage (In building savings contracts)	CMS_DTE_CLM_SAV_SUM	DEC	10(6)			CMS_SEC_PCT
PROVBADDEBT_AMT	Provision doubtful debt amount	CMS_DTE_CLM_DBTDBT_AMT	CURR	17(2)			CMS_AMOUNT
PROVBADDEBT_CURR	Currency of Provision of doubfull debt	CMS_DTE_CLM_DBTDBT_CURR	CUKY	5	Assigned to domain		WAERS
ADDR_ID	Address of the object (for build.sav.contr./rental claim)	CMS_DTE_CLM_ADDRESS	CHAR	10	Assigned to domain	ALPHA	AD_ADDRNUM		ADMC
ACC_NUMBER	Account number	CMS_DTE_CLM_ACC_NUMBER	CHAR	35			BANKN35
BANK_COUNTRY_KEY	Bank country key	CMS_DTE_CLM_BNK_CTRY_KY	CHAR	3	T005		LAND1
BANK_KEY	Bank Key	CMS_DTE_CLM_BNK_KEY	CHAR	15			BANKK	BNK
BANK_CTRL_KEY	Bank Control Key	BKONT	CHAR	2			BKONT
ADMIN_ORG_UNIT	Administration Organizational Unit	CMS_DTE_ADMINORG	CHAR	12			TEXT12	CMS_ADMINORG
BANKAREA	Bank Area in Collateral Management	CMS_DTE_BANKAREA	CHAR	4	Assigned to domain		CMS_BANKAREA	CMS_BANKAREA
CREATED_BY	Login ID of the User who created the Record	CMS_DTE_USER	CHAR	12			CMS_USER
CREATED_AT	Creation Timestamp	CMS_DTE_CREATED_AT	DEC	15			TZNTSTMPS
CHANGED_BY	Last Changed By	CMS_DTE_LAST_CHNG_USER	CHAR	12			CMS_USER
CHANGED_AT	Change Timestamp	CMS_DTE_CHANGED_AT	DEC	15			TZNTSTMPS
SOURCEOFENTRY	Source of Entry	CMS_DTE_SOURCE_OF_ENTRY	CHAR	32			CMS_SOURCE

Key field

Non-key field

< CMS_RE_STR_VALUATION_DATA - Valuation data CMS_SEC_ACC - Securities account details >

How do I retrieve data from SAP table CMS_RIG using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_RIG to SELECT all data from the table
DATA: WA_CMS_RIG TYPE CMS_RIG.

SELECT SINGLE *
FROM CMS_RIG
INTO CORRESPONDING FIELDS OF WA_CMS_RIG
WHERE...

How to access SAP table CMS_RIG

Within an ECC or HANA version of SAP you can also view further information about CMS_RIG and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).