SMTG_TMPL_HDR

Transparent Table System Table (transport)
12 Fields 6 CDS Views

Email Template Header

SMTG_TMPL_HDR is an SAP database table in S/4HANA. Email Template Header. It contains 12 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_RblsMgmtEmailTemplate view from BASIC Email Templates
R_SMTG_EmailTemplateTP view_entity from
SMTG_LANG_VRS_OBJ_ACTIVE_SMTG view_entity from
SMTG_LANG_VRS_OBJ_EDIT_SMTG view_entity from
SMTGTemplateCounter view from Counter for the available Templates
SMTGTemplateHeader view from Email Template Header

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY id SMTG_TMPL_ID Email Template
KEY version R3STATE Program Status
cds_view SMTG_CDS_VIEW CDS View
is_predelivered SMTG_IS_PREDELIVERED Predelivered
crea_date_time SMTG_CREATE_TIMESTAMP Creation Time
crea_user_acct SMTG_CREATE_USER_ID Creating User ID
lst_ch_date_time SMTG_CHANGE_TIMESTAMP Last Change Time
lst_ch_user_acct SMTG_CHANGE_USER_ID Last Change User ID
parent_id SMTG_TMPL_ID Email Template
original_id SMTG_TMPL_ID Email Template
abap_language_version ABAP_LANGUAGE_VERSION Language Version
smtg_version SMTG_VERSION SMTG 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.

-- Email Template Header
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SMTG_TMPL_HDR (
    ID,                     -- Email Template [SMTG_TMPL_ID]
    VERSION,                -- Program Status [R3STATE]
    CDS_VIEW,               -- CDS View [SMTG_CDS_VIEW]
    IS_PREDELIVERED,        -- Predelivered [SMTG_IS_PREDELIVERED]
    CREA_DATE_TIME,         -- Creation Time [SMTG_CREATE_TIMESTAMP]
    CREA_USER_ACCT,         -- Creating User ID [SMTG_CREATE_USER_ID]
    LST_CH_DATE_TIME,       -- Last Change Time [SMTG_CHANGE_TIMESTAMP]
    LST_CH_USER_ACCT,       -- Last Change User ID [SMTG_CHANGE_USER_ID]
    PARENT_ID,              -- Email Template [SMTG_TMPL_ID]
    ORIGINAL_ID,            -- Email Template [SMTG_TMPL_ID]
    ABAP_LANGUAGE_VERSION,  -- Language Version [ABAP_LANGUAGE_VERSION]
    SMTG_VERSION,           -- SMTG Version [SMTG_VERSION]
    PRIMARY KEY (ID, VERSION)
);

Learn More