TCMS_SHP_TYP

Transparent Table Customizing Table
19 Fields 1 CDS Views

Customizing table for Ship type

TCMS_SHP_TYP is an SAP database table in S/4HANA. Customizing table for Ship type. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ShipObjectType view from BASIC Ship Type

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY shp_type CMS_DTE_SHP_TYP Ship Type
asset_type CMS_DTE_AST_TYP Asset Type
proc_cky CMS_DTE_PCN_PROC_CKY Proc Cntrl Key
fstat_var CMS_DTE_FSTAT_VAR Object Screen
unit_valn_freq CMS_DTE_SHP_IND_FREQUENCY Reval Frequency
period_valn_freq CMS_DTE_SHP_VALN_FREQ_PERIOD Valn period
sfty_dscnt CMS_DTE_SHP_SAFETY_DSCNT Safety disc (%)
bpf_set CMS_DTE_BPF_SET BPF set
doc_set CMS_DTE_DOC_SET Doc typ Set
val_set CMS_DTE_VALUE_SET Value set
ins_set CMS_DTE_INS_SET Insurance Set
lending_rate1 CMS_DTE_SHP_LRTE_PCT1 Rate 1
lending_rate2 CMS_DTE_SHP_LRTE_PCT2 Rate 2
lending_rate3 CMS_DTE_SHP_LRTE_PCT3 Rate 3
lending_rate4 CMS_DTE_SHP_LRTE_PCT4 Rate 4
lending_rate5 CMS_DTE_SHP_LRTE_PCT5 Rate 5
cor_grp CMS_DTE_COR_GRP Corr Group.
cor_role CMS_DTE_COR_ROLE Corresp. Role

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.

-- Customizing table for Ship type
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCMS_SHP_TYP (
    MANDT,             -- Client [MANDT]
    SHP_TYPE,          -- Ship Type [CMS_DTE_SHP_TYP]
    ASSET_TYPE,        -- Asset Type [CMS_DTE_AST_TYP]
    PROC_CKY,          -- Proc Cntrl Key [CMS_DTE_PCN_PROC_CKY]
    FSTAT_VAR,         -- Object Screen [CMS_DTE_FSTAT_VAR]
    UNIT_VALN_FREQ,    -- Reval Frequency [CMS_DTE_SHP_IND_FREQUENCY]
    PERIOD_VALN_FREQ,  -- Valn period [CMS_DTE_SHP_VALN_FREQ_PERIOD]
    SFTY_DSCNT,        -- Safety disc (%) [CMS_DTE_SHP_SAFETY_DSCNT]
    BPF_SET,           -- BPF set [CMS_DTE_BPF_SET]
    DOC_SET,           -- Doc typ Set [CMS_DTE_DOC_SET]
    VAL_SET,           -- Value set [CMS_DTE_VALUE_SET]
    INS_SET,           -- Insurance Set [CMS_DTE_INS_SET]
    LENDING_RATE1,     -- Rate 1 [CMS_DTE_SHP_LRTE_PCT1]
    LENDING_RATE2,     -- Rate 2 [CMS_DTE_SHP_LRTE_PCT2]
    LENDING_RATE3,     -- Rate 3 [CMS_DTE_SHP_LRTE_PCT3]
    LENDING_RATE4,     -- Rate 4 [CMS_DTE_SHP_LRTE_PCT4]
    LENDING_RATE5,     -- Rate 5 [CMS_DTE_SHP_LRTE_PCT5]
    COR_GRP,           -- Corr Group. [CMS_DTE_COR_GRP]
    COR_ROLE,          -- Corresp. Role [CMS_DTE_COR_ROLE]
    PRIMARY KEY (MANDT, SHP_TYPE)
);

Learn More