CRMD_FSM_TM_ELM
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_SrvcChklstTmplElement | view_entity | from | EXTENSION | Checklist Template Elements - Extension |
| I_SrvcChklstTmplElement | view_entity | from | BASIC | Checklist Template Elements |
Fields (48)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA