P_EIT_UI_Template

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 P_EIT_UI_Template.
-- 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: PEITUITMPL

CREATE VIEW P_EIT_UI_Template AS
SELECT
  template_id AS TemplateId,
  template_version AS TemplateVersion,
  template_type AS TemplateType,
  template_file_name AS TemplateFileName,
  Description,
  provider_name AS ProviderName,
  source_template_id AS SourceTemplateId,
  source_download_number AS SourceDownloadNumber,
  company_url AS CompanyURL,
  imported_by AS ImportedBy,
  imported_at AS ImportedAt,
  last_changed_by AS LastChangedBy,
  last_changed_at AS LastChangedAt,
  Action,
  Status
FROM eit_imp_tmpl
LEFT OUTER JOIN I_Eit_Template_Action AS _Action ON _Action.Code = Action  -- association [0..1]
LEFT OUTER JOIN I_Eit_Template_Status AS _Status ON _Status.Status = Status  -- association [0..1]
LEFT OUTER JOIN P_EIT_User_Name AS _ImportedBy ON _ImportedBy.UserName = ImportedBy  -- association [0..1]
LEFT OUTER JOIN P_EIT_User_Name AS _LastChangedBy ON _LastChangedBy.UserName = LastChangedBy  -- association [0..1]
LEFT OUTER JOIN P_EIT_UI_Template_Status_UI AS _UIStatus ON _UIStatus.TemplateId = TemplateId AND _UIStatus.TemplateVersion = TemplateVersion  -- association [0..1]
LEFT OUTER JOIN P_EIT_Action_Log AS _ActionLogs ON _ActionLogs.TemplateId = TemplateId AND _ActionLogs.TemplateVersion = TemplateVersion  -- association [0..*]
LEFT OUTER JOIN P_EIT_UI_Template_Item AS _TemplateItems ON _TemplateItems.TemplateId = TemplateId AND _TemplateItems.TemplateVersion = TemplateVersion  -- association [0..*]
;