CMS_INS_PSN

Transparent Table Application Table
18 Fields 2 CDS Views

Insurance - Specifications of Persons

CMS_INS_PSN is an SAP database table in S/4HANA. Insurance - Specifications of Persons. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ColltrlInsurPersnSpec view from BASIC Specification of Persn for Colltrl Insur
I_InsurancePersonSpecification view from BASIC Insurance Specification of Persons

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ins_psn_guid CMS_DTE_INS_PSN_GUID InsPsnGUID
ins_guid CMS_DTE_INS_GUID Ins. GUID
insrd_prsn_nm CMS_DTE_INS_PRSN_NAME Insured person
prsn_status CMS_DTE_INS_STATUS InsuranceStatus
prsn_status_dt CMS_DTE_INS_STATUS_DT Ins status date
spec_ins_rnk_pr CMS_DTE_INS_SPEC_RNK_PRSN Rank
insured_rsk CMS_DTE_INS_RSK Insured risk
sgle_prm CMS_DTE_INS_SGLE_PRM Sing. prm. ins.
sgle_prm_cky CMS_DTE_INS_SGLE_PRM_CKY Currency
one_tme_con CMS_DTE_INS_ONE_TME_CON Unused amount
one_tme_con_cky CMS_DTE_INS_ONE_TM_CON_CKY Currency
renew_dat CMS_DTE_INS_RENEW_DAT Renewal date
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

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.

-- Insurance - Specifications of Persons
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_INS_PSN (
    MANDT,            -- Client [MANDT]
    INS_PSN_GUID,     -- InsPsnGUID [CMS_DTE_INS_PSN_GUID]
    INS_GUID,         -- Ins. GUID [CMS_DTE_INS_GUID]
    INSRD_PRSN_NM,    -- Insured person [CMS_DTE_INS_PRSN_NAME]
    PRSN_STATUS,      -- InsuranceStatus [CMS_DTE_INS_STATUS]
    PRSN_STATUS_DT,   -- Ins status date [CMS_DTE_INS_STATUS_DT]
    SPEC_INS_RNK_PR,  -- Rank [CMS_DTE_INS_SPEC_RNK_PRSN]
    INSURED_RSK,      -- Insured risk [CMS_DTE_INS_RSK]
    SGLE_PRM,         -- Sing. prm. ins. [CMS_DTE_INS_SGLE_PRM]
    SGLE_PRM_CKY,     -- Currency [CMS_DTE_INS_SGLE_PRM_CKY]
    ONE_TME_CON,      -- Unused amount [CMS_DTE_INS_ONE_TME_CON]
    ONE_TME_CON_CKY,  -- Currency [CMS_DTE_INS_ONE_TM_CON_CKY]
    RENEW_DAT,        -- Renewal date [CMS_DTE_INS_RENEW_DAT]
    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]
    PRIMARY KEY (MANDT, INS_PSN_GUID)
);

Learn More