SAP CMS_INS_PSN table - Insurance - Specifications of Persons details in SAP

SAP CMS_INS_PSN table summary

Object Name: CMS_INS_PSN
Dictionary Type: Transparent table
Description: Insurance - Specifications of Persons

Field list for CMS_INS_PSN table on an S/4 SAP system

Details

CMS_INS_PSN-MANDT table field - Client ▼

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

CMS_INS_PSN-INS_PSN_GUID table field - Insurance Person GUID ▼

Description: Insurance Person GUID
Field Name: INS_PSN_GUID
Data Element: CMS_DTE_INS_PSN_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INS_PSN_GUID

CMS_INS_PSN-INS_GUID table field - Insurance GUID ▼

Description: Insurance GUID
Field Name: INS_GUID
Data Element: CMS_DTE_INS_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INS_GUID

CMS_INS_PSN-INSRD_PRSN_NM table field - Name of the insured person ▼

Description: Name of the insured person
Field Name: INSRD_PRSN_NM
Data Element: CMS_DTE_INS_PRSN_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CMS_INS_PER_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSRD_PRSN_NM

CMS_INS_PSN-PRSN_STATUS table field - Status of insurance ▼

Description: Status of insurance
Field Name: PRSN_STATUS
Data Element: CMS_DTE_INS_STATUS
Data Type: CHAR
length (Dec): 6(0)
Check table: TCMS_ATT_ID_TY
Conversion Routine:
Domain Name: CMS_ATT_ID_TYP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRSN_STATUS

CMS_INS_PSN-PRSN_STATUS_DT table field - Status date of insurance ▼

Description: Status date of insurance
Field Name: PRSN_STATUS_DT
Data Element: CMS_DTE_INS_STATUS_DT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRSN_STATUS_DT

CMS_INS_PSN-SPEC_INS_RNK_PR table field - Specification on the insurance rank of the person ▼

Description: Specification on the insurance rank of the person
Field Name: SPEC_INS_RNK_PR
Data Element: CMS_DTE_INS_SPEC_RNK_PRSN
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CMS_INS_SPEC_RNK_PRSN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPEC_INS_RNK_PR

CMS_INS_PSN-INSURED_RSK table field - Insured risk ▼

Description: Insured risk
Field Name: INSURED_RSK
Data Element: CMS_DTE_INS_RSK
Data Type: CHAR
length (Dec): 6(0)
Check table: TCMS_ATT_ID_TY
Conversion Routine:
Domain Name: CMS_ATT_ID_TYP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSURED_RSK

CMS_INS_PSN-SGLE_PRM table field - Insurance one time Cntribution /Single Premium insurance ▼

Description: Insurance one time Cntribution /Single Premium insurance
Field Name: SGLE_PRM
Data Element: CMS_DTE_INS_SGLE_PRM
Data Type: CURR
length (Dec): 17(2)
Check table:
Conversion Routine:
Domain Name: CMS_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SGLE_PRM

CMS_INS_PSN-SGLE_PRM_CKY table field - Currency ▼

Description: Currency
Field Name: SGLE_PRM_CKY
Data Element: CMS_DTE_INS_SGLE_PRM_CKY
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SGLE_PRM_CKY

CMS_INS_PSN-ONE_TME_CON table field - Undrawn(unused) one time contribution ▼

Description: Undrawn(unused) one time contribution
Field Name: ONE_TME_CON
Data Element: CMS_DTE_INS_ONE_TME_CON
Data Type: CURR
length (Dec): 17(2)
Check table:
Conversion Routine:
Domain Name: CMS_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ONE_TME_CON

CMS_INS_PSN-ONE_TME_CON_CKY table field - Currency ▼

Description: Currency
Field Name: ONE_TME_CON_CKY
Data Element: CMS_DTE_INS_ONE_TM_CON_CKY
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ONE_TME_CON_CKY

CMS_INS_PSN-RENEW_DAT table field - Renewal date(insurance premium) ▼

Description: Renewal date(insurance premium)
Field Name: RENEW_DAT
Data Element: CMS_DTE_INS_RENEW_DAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RENEW_DAT

CMS_INS_PSN-CREATED_BY table field - Login ID of the User who created the Record ▼

Description: Login ID of the User who created the Record
Field Name: CREATED_BY
Data Element: CMS_DTE_USER
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CMS_USER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_BY

CMS_INS_PSN-CREATED_AT table field - Creation Timestamp ▼

Description: Creation Timestamp
Field Name: CREATED_AT
Data Element: CMS_DTE_CREATED_AT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_AT

CMS_INS_PSN-CHANGED_BY table field - Last Changed By ▼

Description: Last Changed By
Field Name: CHANGED_BY
Data Element: CMS_DTE_LAST_CHNG_USER
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CMS_USER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGED_BY

CMS_INS_PSN-CHANGED_AT table field - Change Timestamp ▼

Description: Change Timestamp
Field Name: CHANGED_AT
Data Element: CMS_DTE_CHANGED_AT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGED_AT

CMS_INS_PSN-SOURCEOFENTRY table field - Source of Entry ▼

Description: Source of Entry
Field Name: SOURCEOFENTRY
Data Element: CMS_DTE_SOURCE_OF_ENTRY
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CMS_SOURCE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SOURCEOFENTRY

View list of all SAP tables(S4H/ECC)

Select data from SAP table