CRMD_FSM_TM_HDR

Transparent Table Application Table
16 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 16 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 (16)

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
fsm_template_grp_uuid crms4_fsm_chklst_template_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]
    FSM_TEMPLATE_GRP_UUID,  -- crms4_fsm_chklst_template_id
    REQUESTUUID,            -- Request ID [crms4_fsm_chklst_reqst_id]
    VERSION,                -- Version [crms4_fsm_version]
    PRIMARY KEY (MANDT, TEMPLATE_ID)
);

Learn More