SMTG_TMPL_HDR

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

Email Template Header

SMTG_TMPL_HDR is an SAP database table in S/4HANA. Email Template Header. It contains 8 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 Root View for Email Template
SMTG_LANG_VRS_OBJ_ACTIVE_SMTG view_entity from SMTG Relations: ABAP Language Version of Active Objects
SMTG_LANG_VRS_OBJ_EDIT_SMTG view_entity from SMTG: CDS View Entity for Editing of Single Objects
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