CRMD_FSM_TM_ELM

Transparent Table Application Table

FSM Checklist: Template Elements

CRMD_FSM_TM_ELM is an SAP database table in S/4HANA. FSM Checklist: Template Elements. It contains 48 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrvcChklstTmplElement view_entity from EXTENSION Checklist Template Elements - Extension
I_SrvcChklstTmplElement view_entity from BASIC Checklist Template Elements

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY template_id crms4_fsm_tmplt_id Template ID
KEY element_id crms4_fsm_element_id Element Id
parent_element_id crms4_fsm_par_element_id Parent Element ID
seqnr crms4_fsm_seqnr Sequence Number
type crms4_fsm_element_type Element Type
subtype crms4_fsm_element_subtype Element Subtype
fsm_element_id crms4_fsm_ext_element_id FSM Element ID
min_rows crms4_fsm_table_min_row Min. number of rows
max_rows crms4_fsm_table_max_row Max. number of rows
required crms4_fsm_elm_required Required
readonly crms4_fsm_elm_readonly Read Only
table_col_index crms4_fsm_tbl_col_index Table Column Index
default_value crms4_fsm_elm_dflt_value Default Value
style crms4_fsm_elm_style Style
min_value crms4_fsm_elm_min_val Minimum Value
max_value crms4_fsm_elm_max_val Maximum Value
range crms4_fsm_elm_range Range
expression crms4_fsm_elm_expression Expression
symbol_left crms4_fsm_elm_symbol_left Symbol Left
symbol_right crms4_fsm_elm_symbol_right Symbol Right
signal_word crms4_fsm_elm_sign_word Singal Word
atchmt_alwd_types crms4_fsm_atchmt_alwd_types Atchmnt AllowedTypes
allow_multiple_atch crms4_fsm_elm_alw_mul_atch Multiple Attachments
allow_barcode crms4_fsm_elm_allow_barcode Allow Barcodes
allow_outofrange_values crms4_fsm_elm_alw_oor_val Out of Range Values
attachment_id crms4_fsm_elm_atch_guid Attachment Guid
attachment_name crms4_fsm_elm_atchmnt_name Attachment Name
filter crms4_fsm_elm_filter Filter
filtervalue crms4_fsm_elm_filter_val Filter value
ispictureallowed crms4_fsm_elm_is_pic_alwd Is Picture Allowed
linkedpicker crms4_fsm_elm_linked_pkr Linked Picker
linkedpickerrelation crms4_fsm_elm_lnkd_pkr_rel Linked Pikr Relation
max_decimals crms4_fsm_elm_max_decimals Maximum num. decimal
min_decimals crms4_fsm_elm_min_decimals Minimum num. decimal
allow_multi_line crms4_fsm_elm_alw_mult_line Allow Multiple Lines
obj_pikr_objtype crms4_fsm_elm_obj_pikr_objtype Object Pkr Obj. Type
range_type crms4_fsm_elm_range_typ Range Type
selected_index crms4_fsm_elm_selected_ind Selected Index
selected_once crms4_fsm_elm_selected_once Selected Once
visibility_cond crms4_fsm_elm_visib_cond Visibility Condition
internal crms4_fsm_elm_internal Internal
allow_manual_entry crms4_fsm_elm_alw_man_entry Allow Manual Entry
is_accuracy_must crms4_fsm_elm_is_accu_mst Is accuracy must
allow_altitude_capture crms4_fsm_elm_alw_alt_capt Altitude Capture
allow_multi_location crms4_fsm_elm_alw_mult_loc Allow mult. location
accuracy crms4_fsm_elm_accuracy Accuracy
elm_value crms4_fsm_value Value

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: Template Elements
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMD_FSM_TM_ELM (
    MANDT,                    -- Client [mandt]
    TEMPLATE_ID,              -- Template ID [crms4_fsm_tmplt_id]
    ELEMENT_ID,               -- Element Id [crms4_fsm_element_id]
    PARENT_ELEMENT_ID,        -- Parent Element ID [crms4_fsm_par_element_id]
    SEQNR,                    -- Sequence Number [crms4_fsm_seqnr]
    TYPE,                     -- Element Type [crms4_fsm_element_type]
    SUBTYPE,                  -- Element Subtype [crms4_fsm_element_subtype]
    FSM_ELEMENT_ID,           -- FSM Element ID [crms4_fsm_ext_element_id]
    MIN_ROWS,                 -- Min. number of rows [crms4_fsm_table_min_row]
    MAX_ROWS,                 -- Max. number of rows [crms4_fsm_table_max_row]
    REQUIRED,                 -- Required [crms4_fsm_elm_required]
    READONLY,                 -- Read Only [crms4_fsm_elm_readonly]
    TABLE_COL_INDEX,          -- Table Column Index [crms4_fsm_tbl_col_index]
    DEFAULT_VALUE,            -- Default Value [crms4_fsm_elm_dflt_value]
    STYLE,                    -- Style [crms4_fsm_elm_style]
    MIN_VALUE,                -- Minimum Value [crms4_fsm_elm_min_val]
    MAX_VALUE,                -- Maximum Value [crms4_fsm_elm_max_val]
    RANGE,                    -- Range [crms4_fsm_elm_range]
    EXPRESSION,               -- Expression [crms4_fsm_elm_expression]
    SYMBOL_LEFT,              -- Symbol Left [crms4_fsm_elm_symbol_left]
    SYMBOL_RIGHT,             -- Symbol Right [crms4_fsm_elm_symbol_right]
    SIGNAL_WORD,              -- Singal Word [crms4_fsm_elm_sign_word]
    ATCHMT_ALWD_TYPES,        -- Atchmnt AllowedTypes [crms4_fsm_atchmt_alwd_types]
    ALLOW_MULTIPLE_ATCH,      -- Multiple Attachments [crms4_fsm_elm_alw_mul_atch]
    ALLOW_BARCODE,            -- Allow Barcodes [crms4_fsm_elm_allow_barcode]
    ALLOW_OUTOFRANGE_VALUES,  -- Out of Range Values [crms4_fsm_elm_alw_oor_val]
    ATTACHMENT_ID,            -- Attachment Guid [crms4_fsm_elm_atch_guid]
    ATTACHMENT_NAME,          -- Attachment Name [crms4_fsm_elm_atchmnt_name]
    FILTER,                   -- Filter [crms4_fsm_elm_filter]
    FILTERVALUE,              -- Filter value [crms4_fsm_elm_filter_val]
    ISPICTUREALLOWED,         -- Is Picture Allowed [crms4_fsm_elm_is_pic_alwd]
    LINKEDPICKER,             -- Linked Picker [crms4_fsm_elm_linked_pkr]
    LINKEDPICKERRELATION,     -- Linked Pikr Relation [crms4_fsm_elm_lnkd_pkr_rel]
    MAX_DECIMALS,             -- Maximum num. decimal [crms4_fsm_elm_max_decimals]
    MIN_DECIMALS,             -- Minimum num. decimal [crms4_fsm_elm_min_decimals]
    ALLOW_MULTI_LINE,         -- Allow Multiple Lines [crms4_fsm_elm_alw_mult_line]
    OBJ_PIKR_OBJTYPE,         -- Object Pkr Obj. Type [crms4_fsm_elm_obj_pikr_objtype]
    RANGE_TYPE,               -- Range Type [crms4_fsm_elm_range_typ]
    SELECTED_INDEX,           -- Selected Index [crms4_fsm_elm_selected_ind]
    SELECTED_ONCE,            -- Selected Once [crms4_fsm_elm_selected_once]
    VISIBILITY_COND,          -- Visibility Condition [crms4_fsm_elm_visib_cond]
    INTERNAL,                 -- Internal [crms4_fsm_elm_internal]
    ALLOW_MANUAL_ENTRY,       -- Allow Manual Entry [crms4_fsm_elm_alw_man_entry]
    IS_ACCURACY_MUST,         -- Is accuracy must [crms4_fsm_elm_is_accu_mst]
    ALLOW_ALTITUDE_CAPTURE,   -- Altitude Capture [crms4_fsm_elm_alw_alt_capt]
    ALLOW_MULTI_LOCATION,     -- Allow mult. location [crms4_fsm_elm_alw_mult_loc]
    ACCURACY,                 -- Accuracy [crms4_fsm_elm_accuracy]
    ELM_VALUE,                -- Value [crms4_fsm_value]
    PRIMARY KEY (MANDT, TEMPLATE_ID, ELEMENT_ID)
);