CRMD_FSM_TM_ELM

Transparent Table Application Table
49 Fields 2 CDS Views

FSM Checklist: Template Elements

CRMD_FSM_TM_ELM is an SAP database table in S/4HANA. FSM Checklist: Template Elements. It contains 49 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 (49)

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
tmp_elm_dummy_ps CHAR1 Single-Character Flag

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]
    TMP_ELM_DUMMY_PS,         -- Single-Character Flag [CHAR1]
    PRIMARY KEY (MANDT, TEMPLATE_ID, ELEMENT_ID)
);

Learn More