I_SrvcChklstTmplElement

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_SrvcChklstTmplElement.
-- 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_SrvcChklstTmplElement AS
SELECT
  template_id AS ServiceChecklistTemplate,
  element_id AS SrvcChecklistTemplateElement,
  parent_element_id AS SrvcChklstTmplParentElement,
  seqnr AS SrvcChklstTmplElmntSqncNmbrVal,
  type AS SrvcChklstTmplElementType,
  subtype AS SrvcChklstTmplElementSubtype,
  fsm_element_id AS SrvcChklstTmplFSMElement,
  min_rows AS SrvcChklstTmplElmntMinRowsVal,
  max_rows AS SrvcChklstTmplElmntMaxRowsVal,
  required AS SrvcChklstTmplElmntIsRequired,
  readonly AS SrvcChklstTmplElmntIsReadOnly,
  table_col_index AS SrvcChklstTmplElmntTblColIndex,
  default_value AS SrvcChklstTmplElmntDfltValue,
  style AS SrvcChklstTmplElementStyle,
  min_value AS SrvcChklstTmplElementMinValue,
  max_value AS SrvcChklstTmplElementMaxValue,
  range AS SrvcChklstTmplElmntRangeValue,
  expression AS SrvcChklstTmplElmntExprValue,
  symbol_left AS SrvcChklstTmplElmntLeftSymbol,
  symbol_right AS SrvcChklstTmplElmntRightSymbol,
  signal_word AS SrvcChklstTmplElmntSignalWord,
  atchmt_alwd_types AS SrvcChklstTmplElmntAttchTypes,
  allow_multiple_atch AS SvCklTmpElmMltplAttchsAreAllwd,
  allow_barcode AS SvCklTmpElmBarcodeIsAllowed,
  allow_outofrange_values AS SvCklTmpElmOutOfRangeIsAllowed,
  attachment_id AS SrvcChklstTmplElmntAttchUUID,
  attachment_name AS SrvcChklstTmplElmntAttchName,
  filter AS SrvcChklstTmplElmntFltrType,
  filtervalue AS SrvcChklstTmplElmntFltrSubtype,
  ispictureallowed AS SrvcChklstTmplElmntPicIsAllwd,
  linkedpicker AS SrvcChklstTmplElmntLinkdPicker,
  linkedpickerrelation AS SvCklTmpElmLinkdPickerRelation,
  max_decimals AS SrvcChklstTmplElmntMaxDecimals,
  min_decimals AS SrvcChklstTmplElmntMinDecimals,
  allow_multi_line AS SvCklTmpElmMultiLineIsAllowed,
  obj_pikr_objtype AS SvCklTmpElmObjPickerObjectType,
  range_type AS SrvcChklstTmplElmntRangeType,
  selected_index AS SrvcChklstTmplElmntSelectedIdx,
  selected_once AS SrvcChklstTmplElmntIsSeldOnce,
  visibility_cond AS SvCklTmpElmVisibilityCndnVal,
  internal AS SrvcChklstTmplElmntIsInternal,
  allow_manual_entry AS SvCklTmpElmMnlEntryIsAllowed,
  is_accuracy_must AS SvCklTmpElmAccuracyIsMet,
  allow_altitude_capture AS SvCklTmpElmAltdCaptrIsAllowed,
  allow_multi_location AS SvCklTmpElmMltplLocAreAllowed,
  accuracy AS SvCklTmpElmAccuracyValue,
  elm_value AS ServiceChecklistTmplElmntValue
FROM crmd_fsm_tm_elm
LEFT OUTER JOIN I_SrvcChklstTmplElmntText AS _SrvcChklstTmplElmntText ON ServiceChecklistTemplate = _SrvcChklstTmplElmntText.ServiceChecklistTemplate AND SrvcChecklistTemplateElement = _SrvcChklstTmplElmntText.SrvcChecklistTemplateElement  -- association [0..*]
LEFT OUTER JOIN I_SrvcChklstTmplElmntType AS _SrvcChklstTmplElmntType ON SrvcChklstTmplElementType = _SrvcChklstTmplElmntType.SrvcChklstTmplElementType  -- association [0..1]
LEFT OUTER JOIN E_SrvcChklstTmplElement AS _SrvcChklstTmplElementExtn ON ServiceChecklistTemplate = _SrvcChklstTmplElementExtn.ServiceChecklistTemplate AND SrvcChecklistTemplateElement = _SrvcChklstTmplElementExtn.SrvcChecklistTemplateElement  -- association [0..1]
;