CRMD_FSM_IN_ELM

Transparent Table Application Table

FSM Checklist: Instance Element Values

CRMD_FSM_IN_ELM is an SAP database table in S/4HANA. FSM Checklist: Instance Element Values. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrvcChklstInstceValue view_entity from EXTENSION Checklist Instance Value - Extension
I_SrvcChklstInstceValue view_entity from BASIC Checklist Instance Values

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY instance_id crms4_fsm_inst_id Instance ID
KEY element_id crms4_fsm_element_id Element Id
KEY elm_occurence crms4_fsm_seqnr Sequence Number
value_type crms4_fsm_value_type Value Type
series_index crms4_fsm_elm_series_index Series Index
table_row crms4_fsm_elm_table_row Table Row
state_elm_index crms4_fsm_elm_state_index State Element Index
atchmnt_pkr_index crms4_fsm_elm_atmt_pkr_index Atchmnt. PickerIndex
state_elm_quan crms4_fsm_elm_state_quan State Element Quan.
elm_value crms4_fsm_elm_val Element Value
elm_description crms4_fsm_elm_desc Element Description
elm_comment crms4_fsm_elm_comnt Element Comment
elm_image crms4_fsm_elm_image Element Image
elm_item crms4_fsm_elm_item Element Item
language crms4_fsm_langu Language

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.

-- FSM Checklist: Instance Element Values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMD_FSM_IN_ELM (
    MANDT,              -- Client [mandt]
    INSTANCE_ID,        -- Instance ID [crms4_fsm_inst_id]
    ELEMENT_ID,         -- Element Id [crms4_fsm_element_id]
    ELM_OCCURENCE,      -- Sequence Number [crms4_fsm_seqnr]
    VALUE_TYPE,         -- Value Type [crms4_fsm_value_type]
    SERIES_INDEX,       -- Series Index [crms4_fsm_elm_series_index]
    TABLE_ROW,          -- Table Row [crms4_fsm_elm_table_row]
    STATE_ELM_INDEX,    -- State Element Index [crms4_fsm_elm_state_index]
    ATCHMNT_PKR_INDEX,  -- Atchmnt. PickerIndex [crms4_fsm_elm_atmt_pkr_index]
    STATE_ELM_QUAN,     -- State Element Quan. [crms4_fsm_elm_state_quan]
    ELM_VALUE,          -- Element Value [crms4_fsm_elm_val]
    ELM_DESCRIPTION,    -- Element Description [crms4_fsm_elm_desc]
    ELM_COMMENT,        -- Element Comment [crms4_fsm_elm_comnt]
    ELM_IMAGE,          -- Element Image [crms4_fsm_elm_image]
    ELM_ITEM,           -- Element Item [crms4_fsm_elm_item]
    LANGUAGE,           -- Language [crms4_fsm_langu]
    PRIMARY KEY (MANDT, INSTANCE_ID, ELEMENT_ID, ELM_OCCURENCE)
);