What is I_SrvcChklstTmplTableElement in SAP S/4HANA?

I_SrvcChklstTmplTableElement is a composite CDS view in SAP S/4HANA. Checklist Template Table Elements It contains 45 fields.

Which tables does I_SrvcChklstTmplTableElement read from?

I_SrvcChklstTmplTableElement reads data from: I_SrvcChklstTmplElement, I_SrvcChklstTmplElement, I_SrvcChklstTmplElement.

What VDM layer is I_SrvcChklstTmplTableElement?

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

I_SrvcChklstTmplTableElement

DDL: I_SRVCCHKLSTTMPLTABLEELEMENT Type: view_entity COMPOSITE

45 Fields 3 Data Sources

Checklist Template Table Elements

I_SrvcChklstTmplTableElement is a Composite CDS View that provides data about "Checklist Template Table Elements" in SAP S/4HANA. It reads from 3 data sources (I_SrvcChklstTmplElement, I_SrvcChklstTmplElement, I_SrvcChklstTmplElement) and exposes 45 fields with key fields ServiceChecklistTemplate, SrvcChecklistTemplateElement.

Data Sources (3)

Source	Alias	Join Type
I_SrvcChklstTmplElement	GrandparentElmnt	inner
I_SrvcChklstTmplElement	ParentElement	from
I_SrvcChklstTmplElement	TmplElement	inner

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Checklist Template Table Elements	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 (45)

Key	Field	Source Table	Source Field	Description
KEY	ServiceChecklistTemplate	I_SrvcChklstTmplElement	ServiceChecklistTemplate	Template LinkID
KEY	SrvcChecklistTemplateElement	I_SrvcChklstTmplElement	SrvcChecklistTemplateElement	OAN Element ID
	SrvcChklstTmplFSMElement	I_SrvcChklstTmplElement	SrvcChklstTmplFSMElement	FSM Element ID
	SrvcChklstTmplParentElement	I_SrvcChklstTmplElement	SrvcChklstTmplParentElement	Parent Id
	SvCklTmpElmFSMParentElement	I_SrvcChklstTmplElement	SrvcChklstTmplFSMElement	FSM Element ID
	SvCklTmpElmGrandparentElement	I_SrvcChklstTmplElement	SrvcChecklistTemplateElement	OAN Element ID
	SvCklTmpElmFSMGrandparentElmnt	I_SrvcChklstTmplElement	SrvcChklstTmplFSMElement	FSM Element ID
	SrvcChklstTmplElmntSqncNmbrVal	I_SrvcChklstTmplElement	SrvcChklstTmplElmntSqncNmbrVal	Tank ID
	SrvcChklstTmplElementType	I_SrvcChklstTmplElement	SrvcChklstTmplElementType	Worklist Type
	SrvcChklstTmplElementSubtype	I_SrvcChklstTmplElement	SrvcChklstTmplElementSubtype	Version Profile
	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

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_SrvcChklstTmplTableElement.
-- 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_SrvcChklstTmplTableElement AS
SELECT
  TmplElement.ServiceChecklistTemplate AS ServiceChecklistTemplate,
  TmplElement.SrvcChecklistTemplateElement AS SrvcChecklistTemplateElement,
  TmplElement.SrvcChklstTmplFSMElement AS SrvcChklstTmplFSMElement,
  TmplElement.SrvcChklstTmplParentElement AS SrvcChklstTmplParentElement,
  ParentElement.SrvcChklstTmplFSMElement AS SvCklTmpElmFSMParentElement,
  GrandparentElmnt.SrvcChecklistTemplateElement AS SvCklTmpElmGrandparentElement,
  GrandparentElmnt.SrvcChklstTmplFSMElement AS SvCklTmpElmFSMGrandparentElmnt,
  TmplElement.SrvcChklstTmplElmntSqncNmbrVal AS SrvcChklstTmplElmntSqncNmbrVal,
  TmplElement.SrvcChklstTmplElementType AS SrvcChklstTmplElementType,
  TmplElement.SrvcChklstTmplElementSubtype AS SrvcChklstTmplElementSubtype,
  TmplElement.SrvcChklstTmplElmntMinRowsVal AS SrvcChklstTmplElmntMinRowsVal,
  TmplElement.SrvcChklstTmplElmntMaxRowsVal AS SrvcChklstTmplElmntMaxRowsVal,
  TmplElement.SrvcChklstTmplElmntIsRequired AS SrvcChklstTmplElmntIsRequired,
  TmplElement.SrvcChklstTmplElmntIsReadOnly AS SrvcChklstTmplElmntIsReadOnly,
  TmplElement.SrvcChklstTmplElmntTblColIndex AS SrvcChklstTmplElmntTblColIndex,
  TmplElement.SrvcChklstTmplElmntDfltValue AS SrvcChklstTmplElmntDfltValue,
  TmplElement.SrvcChklstTmplElementStyle AS SrvcChklstTmplElementStyle,
  TmplElement.SrvcChklstTmplElementMinValue AS SrvcChklstTmplElementMinValue,
  TmplElement.SrvcChklstTmplElementMaxValue AS SrvcChklstTmplElementMaxValue,
  TmplElement.SrvcChklstTmplElmntRangeValue AS SrvcChklstTmplElmntRangeValue,
  TmplElement.SrvcChklstTmplElmntExprValue AS SrvcChklstTmplElmntExprValue,
  TmplElement.SrvcChklstTmplElmntLeftSymbol AS SrvcChklstTmplElmntLeftSymbol,
  TmplElement.SrvcChklstTmplElmntRightSymbol AS SrvcChklstTmplElmntRightSymbol,
  TmplElement.SrvcChklstTmplElmntSignalWord AS SrvcChklstTmplElmntSignalWord,
  TmplElement.SrvcChklstTmplElmntAttchTypes AS SrvcChklstTmplElmntAttchTypes,
  TmplElement.SvCklTmpElmMltplAttchsAreAllwd AS SvCklTmpElmMltplAttchsAreAllwd,
  TmplElement.SvCklTmpElmBarcodeIsAllowed AS SvCklTmpElmBarcodeIsAllowed,
  TmplElement.SvCklTmpElmOutOfRangeIsAllowed AS SvCklTmpElmOutOfRangeIsAllowed,
  TmplElement.SrvcChklstTmplElmntAttchUUID AS SrvcChklstTmplElmntAttchUUID,
  TmplElement.SrvcChklstTmplElmntAttchName AS SrvcChklstTmplElmntAttchName,
  TmplElement.SrvcChklstTmplElmntFltrType AS SrvcChklstTmplElmntFltrType,
  TmplElement.SrvcChklstTmplElmntFltrSubtype AS SrvcChklstTmplElmntFltrSubtype,
  TmplElement.SrvcChklstTmplElmntPicIsAllwd AS SrvcChklstTmplElmntPicIsAllwd,
  TmplElement.SrvcChklstTmplElmntLinkdPicker AS SrvcChklstTmplElmntLinkdPicker,
  TmplElement.SvCklTmpElmLinkdPickerRelation AS SvCklTmpElmLinkdPickerRelation,
  TmplElement.SrvcChklstTmplElmntMaxDecimals AS SrvcChklstTmplElmntMaxDecimals,
  TmplElement.SrvcChklstTmplElmntMinDecimals AS SrvcChklstTmplElmntMinDecimals,
  TmplElement.SvCklTmpElmMultiLineIsAllowed AS SvCklTmpElmMultiLineIsAllowed,
  TmplElement.SvCklTmpElmObjPickerObjectType AS SvCklTmpElmObjPickerObjectType,
  TmplElement.SrvcChklstTmplElmntRangeType AS SrvcChklstTmplElmntRangeType,
  TmplElement.SrvcChklstTmplElmntSelectedIdx AS SrvcChklstTmplElmntSelectedIdx,
  TmplElement.SrvcChklstTmplElmntIsSeldOnce AS SrvcChklstTmplElmntIsSeldOnce,
  TmplElement.SvCklTmpElmVisibilityCndnVal AS SvCklTmpElmVisibilityCndnVal,
  TmplElement.SrvcChklstTmplElmntIsInternal AS SrvcChklstTmplElmntIsInternal,
  TmplElement.ServiceChecklistTmplElmntValue AS ServiceChecklistTmplElmntValue
FROM I_SrvcChklstTmplElement AS ParentElement
INNER JOIN I_SrvcChklstTmplElement AS TmplElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_SrvcChklstTmplElement AS GrandparentElmnt ON /* join condition not captured in parsed metadata */
;

Depth:

I_SrvcChklstTmplTableElement view_entity