CRMD_FSM_TM_HDR

Transparent Table Application Table
15 Fields 2 CDS Views

FSM Checklist: Template Header

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ServiceChecklistTemplate view_entity from EXTENSION Checklist Template - Extension
I_ServiceChecklistTemplate view_entity from BASIC Checklist Template

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY template_id crms4_fsm_tmplt_id Template ID
source_language crms4_fsm_langu Language
status crms4_fsm_template_status Template Status
category_id crms4_fsm_tmpl_catg_id TemplateCategoryID
created_at crms4_fsm_chklst_created_at Created At
created_by crms4_fsm_chklst_created_by Created By
last_changed_at crms4_fsm_chklst_changed_at Last Changed At
last_changed_by crms4_fsm_chklst_changed_by Changed By
fsm_templateuuid crms4_fsm_chklst_tmpl_id FSM Template ID
fsm_categoryuuid crms4_fsm_chklst_catg_id FSM Category ID
fsm_account crms4_fsm_acount_id Account ID
fsm_company crms4_fsm_compny_id Company ID
requestuuid crms4_fsm_chklst_reqst_id Request ID
version crms4_fsm_version Version

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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMD_FSM_TM_HDR (
    MANDT,             -- Client [mandt]
    TEMPLATE_ID,       -- Template ID [crms4_fsm_tmplt_id]
    SOURCE_LANGUAGE,   -- Language [crms4_fsm_langu]
    STATUS,            -- Template Status [crms4_fsm_template_status]
    CATEGORY_ID,       -- TemplateCategoryID [crms4_fsm_tmpl_catg_id]
    CREATED_AT,        -- Created At [crms4_fsm_chklst_created_at]
    CREATED_BY,        -- Created By [crms4_fsm_chklst_created_by]
    LAST_CHANGED_AT,   -- Last Changed At [crms4_fsm_chklst_changed_at]
    LAST_CHANGED_BY,   -- Changed By [crms4_fsm_chklst_changed_by]
    FSM_TEMPLATEUUID,  -- FSM Template ID [crms4_fsm_chklst_tmpl_id]
    FSM_CATEGORYUUID,  -- FSM Category ID [crms4_fsm_chklst_catg_id]
    FSM_ACCOUNT,       -- Account ID [crms4_fsm_acount_id]
    FSM_COMPANY,       -- Company ID [crms4_fsm_compny_id]
    REQUESTUUID,       -- Request ID [crms4_fsm_chklst_reqst_id]
    VERSION,           -- Version [crms4_fsm_version]
    PRIMARY KEY (MANDT, TEMPLATE_ID)
);

Learn More