CMS_RIG

Transparent Table Application Table
37 Fields 2 CDS Views

CMS: Rights table. Includes claims, patents, other rights.

CMS_RIG is an SAP database table in S/4HANA. CMS: Rights table. Includes claims, patents, other rights.. It contains 37 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_RightsObjectData view from BASIC Rights Object Details
I_RightsObjectMasterData view from BASIC Rights Object Details

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rig_guid CMS_DTE_RIG_GUID Rights GUID
rig_category CMS_DTE_OMS_OBJ_CAT Object Category
rig_typ CMS_DTE_RIG_TYP Right Type
rig_id CMS_DTE_RIG_ID Rights ID
add_descr CMS_DTE_CLM_DESC Description
duration_begin CMS_DTE_RIG_BEGIN Valid from
duration_end CMS_DTE_RIG_END Valid to
classification CMS_DTE_MOV_TYPE_FEAT Classification
ext_itm_no CMS_DTE_OMS_EXT_ITM_NO Ext. item no
ext_reference CMS_DTE_OMS_REF_ID Ext Ref Number
notar_date CMS_DTE_RIG_NOT_DAT Notarization Dt
regis_date CMS_DTE_RIG_REG_DAT Registration Dt
patent_no CMS_DTE_RIG_PATENT_NO Patent Number
registry_no CMS_DTE_RIG_REG_NO Registry Number
patent_office CMS_DTE_RIG_PT_OFF Patent Office
add_ppty_rig CMS_DTE_RIG_AV_PTY Addn. Prop. Rig
pat_parent_guid CMS_DTE_PARENT_GUID Links to Parent Patent - GUID of the Parent
due_date CMS_DTE_CLM_DUE_DATE Due Date
composition CMS_DTE_CLM_COMP Claim Compsn.
sav_sum CMS_DTE_CLM_SAV_SUM Sav. sum in %
provbaddebt_amt CMS_DTE_CLM_DBTDBT_AMT Debt amount
provbaddebt_curr CMS_DTE_CLM_DBTDBT_CURR Currency
addr_id CMS_DTE_CLM_ADDRESS Address number
acc_number CMS_DTE_CLM_ACC_NUMBER Acc. number
bank_country_key CMS_DTE_CLM_BNK_CTRY_KY Ctry/Region Key
bank_key CMS_DTE_CLM_BNK_KEY Bank key
bank_ctrl_key BKONT Control Key
admin_org_unit CMS_DTE_ADMINORG AdminOrg
bankarea CMS_DTE_BANKAREA Bankarea
created_by CMS_DTE_USER Created by
created_at CMS_DTE_CREATED_AT Created At
changed_by CMS_DTE_LAST_CHNG_USER Last Changed by
changed_at CMS_DTE_CHANGED_AT Changed At
sourceofentry CMS_DTE_SOURCE_OF_ENTRY Source Of Entry
bupr_id CMS_DTE_BUPR_ID Bus. Process ID
bupr_type_code CMS_DTE_BUPR_TYP_CODE BusProcess Code

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- CMS: Rights table. Includes claims, patents, other rights.
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_RIG (
    MANDT,             -- Client [MANDT]
    RIG_GUID,          -- Rights GUID [CMS_DTE_RIG_GUID]
    RIG_CATEGORY,      -- Object Category [CMS_DTE_OMS_OBJ_CAT]
    RIG_TYP,           -- Right Type [CMS_DTE_RIG_TYP]
    RIG_ID,            -- Rights ID [CMS_DTE_RIG_ID]
    ADD_DESCR,         -- Description [CMS_DTE_CLM_DESC]
    DURATION_BEGIN,    -- Valid from [CMS_DTE_RIG_BEGIN]
    DURATION_END,      -- Valid to [CMS_DTE_RIG_END]
    CLASSIFICATION,    -- Classification [CMS_DTE_MOV_TYPE_FEAT]
    EXT_ITM_NO,        -- Ext. item no [CMS_DTE_OMS_EXT_ITM_NO]
    EXT_REFERENCE,     -- Ext Ref Number [CMS_DTE_OMS_REF_ID]
    NOTAR_DATE,        -- Notarization Dt [CMS_DTE_RIG_NOT_DAT]
    REGIS_DATE,        -- Registration Dt [CMS_DTE_RIG_REG_DAT]
    PATENT_NO,         -- Patent Number [CMS_DTE_RIG_PATENT_NO]
    REGISTRY_NO,       -- Registry Number [CMS_DTE_RIG_REG_NO]
    PATENT_OFFICE,     -- Patent Office [CMS_DTE_RIG_PT_OFF]
    ADD_PPTY_RIG,      -- Addn. Prop. Rig [CMS_DTE_RIG_AV_PTY]
    PAT_PARENT_GUID,   -- Links to Parent Patent - GUID of the Parent [CMS_DTE_PARENT_GUID]
    DUE_DATE,          -- Due Date [CMS_DTE_CLM_DUE_DATE]
    COMPOSITION,       -- Claim Compsn. [CMS_DTE_CLM_COMP]
    SAV_SUM,           -- Sav. sum in % [CMS_DTE_CLM_SAV_SUM]
    PROVBADDEBT_AMT,   -- Debt amount [CMS_DTE_CLM_DBTDBT_AMT]
    PROVBADDEBT_CURR,  -- Currency [CMS_DTE_CLM_DBTDBT_CURR]
    ADDR_ID,           -- Address number [CMS_DTE_CLM_ADDRESS]
    ACC_NUMBER,        -- Acc. number [CMS_DTE_CLM_ACC_NUMBER]
    BANK_COUNTRY_KEY,  -- Ctry/Region Key [CMS_DTE_CLM_BNK_CTRY_KY]
    BANK_KEY,          -- Bank key [CMS_DTE_CLM_BNK_KEY]
    BANK_CTRL_KEY,     -- Control Key [BKONT]
    ADMIN_ORG_UNIT,    -- AdminOrg [CMS_DTE_ADMINORG]
    BANKAREA,          -- Bankarea [CMS_DTE_BANKAREA]
    CREATED_BY,        -- Created by [CMS_DTE_USER]
    CREATED_AT,        -- Created At [CMS_DTE_CREATED_AT]
    CHANGED_BY,        -- Last Changed by [CMS_DTE_LAST_CHNG_USER]
    CHANGED_AT,        -- Changed At [CMS_DTE_CHANGED_AT]
    SOURCEOFENTRY,     -- Source Of Entry [CMS_DTE_SOURCE_OF_ENTRY]
    BUPR_ID,           -- Bus. Process ID [CMS_DTE_BUPR_ID]
    BUPR_TYPE_CODE,    -- BusProcess Code [CMS_DTE_BUPR_TYP_CODE]
    PRIMARY KEY (MANDT, RIG_GUID)
);

Learn More