I_ServiceChecklistTemplate

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 I_ServiceChecklistTemplate.
-- 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.

CREATE VIEW I_ServiceChecklistTemplate AS
SELECT
  template_id AS ServiceChecklistTemplate,
  status AS SrvcChklstTmplStatus,
  category_id AS SrvcChklstTmplCategory,
  created_at AS SrvcChklstCreationDateTime,
  created_by AS SrvcChklstCreatedByUser,
  last_changed_at AS SrvcChklstChangedDateTime,
  last_changed_by AS SrvcChklstChangedByUser,
  fsm_templateuuid AS FSMChecklistTemplateUUID,
  fsm_categoryuuid AS FSMChecklistCategoryUUID,
  version AS SrvcChklstTmplVersion,
  source_language AS SrvcChklstLanguage
FROM crmd_fsm_tm_hdr
LEFT OUTER JOIN I_SrvcChklstTmplText AS _SrvcChklstTmplText ON ServiceChecklistTemplate = _SrvcChklstTmplText.ServiceChecklistTemplate  -- association [0..*]
LEFT OUTER JOIN I_SrvcChklstTmplStatus AS _SrvcChklstTmplStatus ON SrvcChklstTmplStatus = _SrvcChklstTmplStatus.SrvcChklstTmplStatus  -- association [0..1]
LEFT OUTER JOIN E_ServiceChecklistTemplate AS _SrvcChklstTmplExtn ON ServiceChecklistTemplate = _SrvcChklstTmplExtn.ServiceChecklistTemplate  -- association [0..1]
LEFT OUTER JOIN I_SrvcChklstTmplCategory AS _SrvcChklstTmplCategory ON SrvcChklstTmplCategory = _SrvcChklstTmplCategory.SrvcChklstTmplCategory  -- association [0..1]
;