SMTG_TMPL_HDR

Transparent Table System Table (transport)
8 Fields 3 CDS Views

Email Template Header

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_RblsMgmtEmailTemplate view from BASIC Email Templates
SMTGTemplateCounter view from Counter for the available Templates
SMTGTemplateHeader view from Email Template Header

Fields (8)

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
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]
    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