What is I_SrvcChklstTmplSubElement in SAP S/4HANA?

I_SrvcChklstTmplSubElement is a composite CDS view in SAP S/4HANA. Checklist Template Subelements It contains 46 fields.

Which tables does I_SrvcChklstTmplSubElement read from?

I_SrvcChklstTmplSubElement reads data from: I_SrvcChklstTmplElement.

What VDM layer is I_SrvcChklstTmplSubElement?

I_SrvcChklstTmplSubElement is classified as a Composite view that combines data from multiple basic views.

I_SrvcChklstTmplSubElement

DDL: I_SRVCCHKLSTTMPLSUBELEMENT Type: view_entity COMPOSITE Package: CRMS4_FSM_CHECKLIST_INT

46 Fields 1 Data Sources 4 Associations

Checklist Template Subelements

I_SrvcChklstTmplSubElement is a Composite CDS View that provides data about "Checklist Template Subelements" in SAP S/4HANA. It reads from 1 data source (I_SrvcChklstTmplElement) and exposes 46 fields with key fields ServiceChecklistTemplate, SrvcChecklistTemplateElement. It has 4 associations to related views. Part of development package CRMS4_FSM_CHECKLIST_INT.

Data Sources (1)

Source	Alias	Join Type
I_SrvcChklstTmplElement	Temp_Element	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..*]	I_SrvcChklstTmplSubElement	_SubElements	`$projection.ServiceChecklistTemplate = _SubElements.ServiceChecklistTemplate and $projection.SrvcChecklistTemplateElement = _SubElements.SrvcChklstTmplParentElement and $projection.SrvcChklstTmplElementType = 'C3'`
[1..*]	I_SrvcChklstTmplDropdownOption	_DropdownOptions	`$projection.ServiceChecklistTemplate = _DropdownOptions.ServiceChecklistTemplate and $projection.SrvcChecklistTemplateElement = _DropdownOptions.SrvcChklstTmplParentElement and $projection.SrvcChklstTmplElementType = 'D2'`
[1..*]	I_SrvcChklstTmplTableElement	_TableElements	`$projection.ServiceChecklistTemplate = _TableElements.ServiceChecklistTemplate and ( $projection.SrvcChecklistTemplateElement = _TableElements.SvCklTmpElmGrandparentElement or $projection.SrvcChecklistTemplateElement = _TableElements.SrvcChklstTmplParentElement ) and $projection.SrvcChklstTmplElementType = 'T2'`
[1..*]	I_SrvcChklstTmplSubElement	_SeriesElements	`$projection.ServiceChecklistTemplate = _SeriesElements.ServiceChecklistTemplate and $projection.SrvcChecklistTemplateElement = _SeriesElements.SrvcChklstTmplParentElement and $projection.SrvcChklstTmplElementType = 'S2'`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Checklist Template Subelements	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.modelingPattern	#NONE	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	ServiceChecklistTemplate	I_SrvcChklstTmplElement	ServiceChecklistTemplate	Template LinkID
KEY	SrvcChecklistTemplateElement	I_SrvcChklstTmplElement	SrvcChecklistTemplateElement	OAN Element ID
	SrvcChklstTmplParentElement	I_SrvcChklstTmplElement	SrvcChklstTmplParentElement	Parent Id
	SrvcChklstTmplElmntSqncNmbrVal	I_SrvcChklstTmplElement	SrvcChklstTmplElmntSqncNmbrVal	Tank ID
	SrvcChklstTmplElementType	I_SrvcChklstTmplElement	SrvcChklstTmplElementType	Worklist Type
	SrvcChklstTmplElementSubtype	I_SrvcChklstTmplElement	SrvcChklstTmplElementSubtype	Version Profile
	SrvcChklstTmplFSMElement	I_SrvcChklstTmplElement	SrvcChklstTmplFSMElement	FSM Element ID
	SrvcChklstTmplElmntMinRowsVal	I_SrvcChklstTmplElement	SrvcChklstTmplElmntMinRowsVal	Min. number of rows
	SrvcChklstTmplElmntMaxRowsVal	I_SrvcChklstTmplElement	SrvcChklstTmplElmntMaxRowsVal	Max. number of rows
	SrvcChklstTmplElmntIsRequired	I_SrvcChklstTmplElement	SrvcChklstTmplElmntIsRequired	Required
	SrvcChklstTmplElmntIsReadOnly	I_SrvcChklstTmplElement	SrvcChklstTmplElmntIsReadOnly	Yes/No
	SrvcChklstTmplElmntTblColIndex	I_SrvcChklstTmplElement	SrvcChklstTmplElmntTblColIndex	Table Column Index
	SrvcChklstTmplElmntDfltValue	I_SrvcChklstTmplElement	SrvcChklstTmplElmntDfltValue	Value
	SrvcChklstTmplElementStyle	I_SrvcChklstTmplElement	SrvcChklstTmplElementStyle	Style
	SrvcChklstTmplElementMinValue	I_SrvcChklstTmplElement	SrvcChklstTmplElementMinValue	Minimum Value
	SrvcChklstTmplElementMaxValue	I_SrvcChklstTmplElement	SrvcChklstTmplElementMaxValue	Maximum Value
	SrvcChklstTmplElmntRangeValue	I_SrvcChklstTmplElement	SrvcChklstTmplElmntRangeValue	Range
	SrvcChklstTmplElmntExprValue	I_SrvcChklstTmplElement	SrvcChklstTmplElmntExprValue	Expression
	SrvcChklstTmplElmntLeftSymbol	I_SrvcChklstTmplElement	SrvcChklstTmplElmntLeftSymbol	Symbol Left
	SrvcChklstTmplElmntRightSymbol	I_SrvcChklstTmplElement	SrvcChklstTmplElmntRightSymbol	Symbol Right
	SrvcChklstTmplElmntSignalWord	I_SrvcChklstTmplElement	SrvcChklstTmplElmntSignalWord	Singal Word
	SrvcChklstTmplElmntAttchTypes	I_SrvcChklstTmplElement	SrvcChklstTmplElmntAttchTypes	Atchmnt AllowedTypes
	SvCklTmpElmMltplAttchsAreAllwd	I_SrvcChklstTmplElement	SvCklTmpElmMltplAttchsAreAllwd	Multiple Attachments
	SvCklTmpElmBarcodeIsAllowed	I_SrvcChklstTmplElement	SvCklTmpElmBarcodeIsAllowed	Allow Barcodes
	SvCklTmpElmOutOfRangeIsAllowed	I_SrvcChklstTmplElement	SvCklTmpElmOutOfRangeIsAllowed	Out of Range Values
	SrvcChklstTmplElmntAttchUUID	I_SrvcChklstTmplElement	SrvcChklstTmplElmntAttchUUID	Doc. ID
	SrvcChklstTmplElmntAttchName	I_SrvcChklstTmplElement	SrvcChklstTmplElmntAttchName	Attachment Name
	SrvcChklstTmplElmntFltrType	I_SrvcChklstTmplElement	SrvcChklstTmplElmntFltrType	KPI Filter
	SrvcChklstTmplElmntFltrSubtype	I_SrvcChklstTmplElement	SrvcChklstTmplElmntFltrSubtype	Filter value
	SrvcChklstTmplElmntPicIsAllwd	I_SrvcChklstTmplElement	SrvcChklstTmplElmntPicIsAllwd	Is Picture Allowed
	SrvcChklstTmplElmntLinkdPicker	I_SrvcChklstTmplElement	SrvcChklstTmplElmntLinkdPicker	Linked Picker
	SvCklTmpElmLinkdPickerRelation	I_SrvcChklstTmplElement	SvCklTmpElmLinkdPickerRelation	Linked Pikr Relation
	SrvcChklstTmplElmntMaxDecimals	I_SrvcChklstTmplElement	SrvcChklstTmplElmntMaxDecimals	Maximum num. decimal
	SrvcChklstTmplElmntMinDecimals	I_SrvcChklstTmplElement	SrvcChklstTmplElmntMinDecimals	Minimum num. decimal
	SvCklTmpElmMultiLineIsAllowed	I_SrvcChklstTmplElement	SvCklTmpElmMultiLineIsAllowed	Allow Multiple Lines
	SvCklTmpElmObjPickerObjectType	I_SrvcChklstTmplElement	SvCklTmpElmObjPickerObjectType	Object Pkr Obj. Type
	SrvcChklstTmplElmntRangeType	I_SrvcChklstTmplElement	SrvcChklstTmplElmntRangeType	Range Type
	SrvcChklstTmplElmntSelectedIdx	I_SrvcChklstTmplElement	SrvcChklstTmplElmntSelectedIdx	Selected Index
	SrvcChklstTmplElmntIsSeldOnce	I_SrvcChklstTmplElement	SrvcChklstTmplElmntIsSeldOnce	Selected Once
	SvCklTmpElmVisibilityCndnVal	I_SrvcChklstTmplElement	SvCklTmpElmVisibilityCndnVal	Visibility Condition
	SrvcChklstTmplElmntIsInternal	I_SrvcChklstTmplElement	SrvcChklstTmplElmntIsInternal	TRUE
	ServiceChecklistTmplElmntValue	I_SrvcChklstTmplElement	ServiceChecklistTmplElmntValue	Value
	_SubElements		_SubElements
	_DropdownOptions		_DropdownOptions
	_TableElements		_TableElements
	_SeriesElements		_SeriesElements

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_SrvcChklstTmplSubElement.
-- 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_SrvcChklstTmplSubElement AS
SELECT
  Temp_Element.ServiceChecklistTemplate AS ServiceChecklistTemplate,
  Temp_Element.SrvcChecklistTemplateElement AS SrvcChecklistTemplateElement,
  Temp_Element.SrvcChklstTmplParentElement AS SrvcChklstTmplParentElement,
  Temp_Element.SrvcChklstTmplElmntSqncNmbrVal AS SrvcChklstTmplElmntSqncNmbrVal,
  Temp_Element.SrvcChklstTmplElementType AS SrvcChklstTmplElementType,
  Temp_Element.SrvcChklstTmplElementSubtype AS SrvcChklstTmplElementSubtype,
  Temp_Element.SrvcChklstTmplFSMElement AS SrvcChklstTmplFSMElement,
  Temp_Element.SrvcChklstTmplElmntMinRowsVal AS SrvcChklstTmplElmntMinRowsVal,
  Temp_Element.SrvcChklstTmplElmntMaxRowsVal AS SrvcChklstTmplElmntMaxRowsVal,
  Temp_Element.SrvcChklstTmplElmntIsRequired AS SrvcChklstTmplElmntIsRequired,
  Temp_Element.SrvcChklstTmplElmntIsReadOnly AS SrvcChklstTmplElmntIsReadOnly,
  Temp_Element.SrvcChklstTmplElmntTblColIndex AS SrvcChklstTmplElmntTblColIndex,
  Temp_Element.SrvcChklstTmplElmntDfltValue AS SrvcChklstTmplElmntDfltValue,
  Temp_Element.SrvcChklstTmplElementStyle AS SrvcChklstTmplElementStyle,
  Temp_Element.SrvcChklstTmplElementMinValue AS SrvcChklstTmplElementMinValue,
  Temp_Element.SrvcChklstTmplElementMaxValue AS SrvcChklstTmplElementMaxValue,
  Temp_Element.SrvcChklstTmplElmntRangeValue AS SrvcChklstTmplElmntRangeValue,
  Temp_Element.SrvcChklstTmplElmntExprValue AS SrvcChklstTmplElmntExprValue,
  Temp_Element.SrvcChklstTmplElmntLeftSymbol AS SrvcChklstTmplElmntLeftSymbol,
  Temp_Element.SrvcChklstTmplElmntRightSymbol AS SrvcChklstTmplElmntRightSymbol,
  Temp_Element.SrvcChklstTmplElmntSignalWord AS SrvcChklstTmplElmntSignalWord,
  Temp_Element.SrvcChklstTmplElmntAttchTypes AS SrvcChklstTmplElmntAttchTypes,
  Temp_Element.SvCklTmpElmMltplAttchsAreAllwd AS SvCklTmpElmMltplAttchsAreAllwd,
  Temp_Element.SvCklTmpElmBarcodeIsAllowed AS SvCklTmpElmBarcodeIsAllowed,
  Temp_Element.SvCklTmpElmOutOfRangeIsAllowed AS SvCklTmpElmOutOfRangeIsAllowed,
  Temp_Element.SrvcChklstTmplElmntAttchUUID AS SrvcChklstTmplElmntAttchUUID,
  Temp_Element.SrvcChklstTmplElmntAttchName AS SrvcChklstTmplElmntAttchName,
  Temp_Element.SrvcChklstTmplElmntFltrType AS SrvcChklstTmplElmntFltrType,
  Temp_Element.SrvcChklstTmplElmntFltrSubtype AS SrvcChklstTmplElmntFltrSubtype,
  Temp_Element.SrvcChklstTmplElmntPicIsAllwd AS SrvcChklstTmplElmntPicIsAllwd,
  Temp_Element.SrvcChklstTmplElmntLinkdPicker AS SrvcChklstTmplElmntLinkdPicker,
  Temp_Element.SvCklTmpElmLinkdPickerRelation AS SvCklTmpElmLinkdPickerRelation,
  Temp_Element.SrvcChklstTmplElmntMaxDecimals AS SrvcChklstTmplElmntMaxDecimals,
  Temp_Element.SrvcChklstTmplElmntMinDecimals AS SrvcChklstTmplElmntMinDecimals,
  Temp_Element.SvCklTmpElmMultiLineIsAllowed AS SvCklTmpElmMultiLineIsAllowed,
  Temp_Element.SvCklTmpElmObjPickerObjectType AS SvCklTmpElmObjPickerObjectType,
  Temp_Element.SrvcChklstTmplElmntRangeType AS SrvcChklstTmplElmntRangeType,
  Temp_Element.SrvcChklstTmplElmntSelectedIdx AS SrvcChklstTmplElmntSelectedIdx,
  Temp_Element.SrvcChklstTmplElmntIsSeldOnce AS SrvcChklstTmplElmntIsSeldOnce,
  Temp_Element.SvCklTmpElmVisibilityCndnVal AS SvCklTmpElmVisibilityCndnVal,
  Temp_Element.SrvcChklstTmplElmntIsInternal AS SrvcChklstTmplElmntIsInternal,
  Temp_Element.ServiceChecklistTmplElmntValue AS ServiceChecklistTmplElmntValue
FROM I_SrvcChklstTmplElement AS Temp_Element
LEFT OUTER JOIN I_SrvcChklstTmplSubElement AS _SubElements ON ServiceChecklistTemplate = _SubElements.ServiceChecklistTemplate AND SrvcChecklistTemplateElement = _SubElements.SrvcChklstTmplParentElement AND SrvcChklstTmplElementType = 'C3'  -- association [1..*]
LEFT OUTER JOIN I_SrvcChklstTmplDropdownOption AS _DropdownOptions ON ServiceChecklistTemplate = _DropdownOptions.ServiceChecklistTemplate AND SrvcChecklistTemplateElement = _DropdownOptions.SrvcChklstTmplParentElement AND SrvcChklstTmplElementType = 'D2'  -- association [1..*]
LEFT OUTER JOIN I_SrvcChklstTmplTableElement AS _TableElements ON ServiceChecklistTemplate = _TableElements.ServiceChecklistTemplate AND ( SrvcChecklistTemplateElement = _TableElements.SvCklTmpElmGrandparentElement OR SrvcChecklistTemplateElement = _TableElements.SrvcChklstTmplParentElement ) AND SrvcChklstTmplElementType = 'T2'  -- association [1..*]
LEFT OUTER JOIN I_SrvcChklstTmplSubElement AS _SeriesElements ON ServiceChecklistTemplate = _SeriesElements.ServiceChecklistTemplate AND SrvcChecklistTemplateElement = _SeriesElements.SrvcChklstTmplParentElement AND SrvcChklstTmplElementType = 'S2'  -- association [1..*]
;

Depth:

I_SrvcChklstTmplSubElement view_entity

I_SrvcChklstTmplElement view_entity