SMTGTemplateHeader

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SMTGTemplateHeader.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SMTG_V_TMPL_HDR

CREATE VIEW SMTGTemplateHeader AS
SELECT
  Header.id AS Id,
  Header.version AS Version,
  Header.original_id AS OriginalId,
  Header.smtg_version AS SMTGVersion,
  Header.cds_view AS CDSView,
  Header.is_predelivered AS IsPredelivered,
  Header.crea_user_acct AS CreatedByUser,
  cast( Header.crea_user_acct as abap.char( 80 ) ) AS CreatedByUserDescription,
  Header.crea_date_time AS CreationDateTime,
  Header.lst_ch_user_acct AS LastChangedByUser,
  cast( Header.lst_ch_user_acct as abap.char( 80 ) ) AS LastChangedByUserDescription,
  Header.lst_ch_date_time AS LastChangeDateTime,
  Texts,
  Contents
FROM smtg_tmpl_hdr AS Header
;