I_SrvcChecklistTemplateEnhcd

DDL: I_SRVCCHECKLISTTEMPLATEENHCD Type: view_entity COMPOSITE
18 Fields 1 Data Sources 5 Associations

Checklist Template Enhanced

I_SrvcChecklistTemplateEnhcd is a Composite CDS View that provides data about "Checklist Template Enhanced" in SAP S/4HANA. It reads from 1 data source (I_ServiceChecklistTemplate) and exposes 18 fields with key field ServiceChecklistTemplate. It has 5 associations to related views.

SAP Help Documentation

CategoryIntegration with SAP Field Service Management
StatusTemplate status
Purpose
This CDS view in combination with the CDS views I_SrvcChklstTmplElement and I_SrvcChecklistInstanceEnhcd helps users to answer the below business questions. This CDS view provides the data to answer the following business questions: Which equipment/activity is frequently repaired? How many templates are being filled by technicians? What is the most common reason for repair?

Prerequisites
Authorizations Users who want to use this CDS view must have the authorization object CRMS4_FSMC assigned. This authorization object is for checklists in SAP Field Service Management.

Structure
Important fields in this view include the following: Field Name Description ServiceChecklistTemplate Template ID SrvcChklstTmplStatus Template status FSMChecklistTemplateUUID Reference of the template UUID in SAP Field Service Management FSMChecklistCategoryUUID Reference of the UUID of the category in SAP Field Service Management SrvcChklstTmplVersion Template version number SrvcChklstLanguage Template language

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_ServiceChecklistTemplate I_ServiceChecklistTemplate from

Associations (5)

CardinalityTargetAliasCondition
[1..*] I_SrvcChklstTmplElement _TemplateElement $projection.ServiceChecklistTemplate = _TemplateElement.ServiceChecklistTemplate
[1..*] I_SrvcChklstTmplSubElement _SubElements $projection.ServiceChecklistTemplate = _SubElements.ServiceChecklistTemplate and _SubElements.SrvcChklstTmplParentElement = '0000'
[1..*] I_SrvcChecklistInstanceEnhcd _Instances $projection.ServiceChecklistTemplate = _Instances.ServiceChecklistTemplate
[0..*] I_SrvcChklstTmplText _SrvcChklstTmplText $projection.ServiceChecklistTemplate = _SrvcChklstTmplText.ServiceChecklistTemplate
[0..1] E_ServiceChecklistTemplate _SrvcChklstTmplExtn $projection.ServiceChecklistTemplate = _SrvcChklstTmplExtn.ServiceChecklistTemplate

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Checklist Template Enhanced 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 (18)

KeyFieldSource TableSource FieldDescription
KEY ServiceChecklistTemplate ServiceChecklistTemplate Template LinkID
SrvcChklstTmplStatus SrvcChklstTmplStatus Workflow Status
SrvcChklstTmplCategory SrvcChklstTmplCategory TemplateCategoryID
SrvcChklstCreationDateTime SrvcChklstCreationDateTime Uploaded On
SrvcChklstCreatedByUser SrvcChklstCreatedByUser Version Created By
SrvcChklstChangedDateTime SrvcChklstChangedDateTime Timestamp
SrvcChklstChangedByUser SrvcChklstChangedByUser Username
FSMChecklistTemplateUUID FSMChecklistTemplateUUID FSM Template ID
FSMChecklistCategoryUUID FSMChecklistCategoryUUID FSM Category ID
SrvcChklstTmplVersion SrvcChklstTmplVersion XML Vers.
SrvcChklstLanguage SrvcChklstLanguage Language
FSMChecklistTemplateGroupUUID FSMChecklistTemplateGroupUUID
_TemplateElement _TemplateElement
_SubElements _SubElements
_Instances _Instances
_SrvcChklstTmplStatus _SrvcChklstTmplStatus
_SrvcChklstTmplText _SrvcChklstTmplText
_SrvcChklstTmplCategory _SrvcChklstTmplCategory

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_SrvcChecklistTemplateEnhcd.
-- 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_SrvcChecklistTemplateEnhcd AS
SELECT
  ServiceChecklistTemplate,
  SrvcChklstTmplStatus,
  SrvcChklstTmplCategory,
  SrvcChklstCreationDateTime,
  SrvcChklstCreatedByUser,
  SrvcChklstChangedDateTime,
  SrvcChklstChangedByUser,
  FSMChecklistTemplateUUID,
  FSMChecklistCategoryUUID,
  SrvcChklstTmplVersion,
  SrvcChklstLanguage,
  FSMChecklistTemplateGroupUUID
FROM I_ServiceChecklistTemplate
LEFT OUTER JOIN I_SrvcChklstTmplElement AS _TemplateElement ON ServiceChecklistTemplate = _TemplateElement.ServiceChecklistTemplate  -- association [1..*]
LEFT OUTER JOIN I_SrvcChklstTmplSubElement AS _SubElements ON ServiceChecklistTemplate = _SubElements.ServiceChecklistTemplate AND _SubElements.SrvcChklstTmplParentElement = '0000'  -- association [1..*]
LEFT OUTER JOIN I_SrvcChecklistInstanceEnhcd AS _Instances ON ServiceChecklistTemplate = _Instances.ServiceChecklistTemplate  -- association [1..*]
LEFT OUTER JOIN I_SrvcChklstTmplText AS _SrvcChklstTmplText ON ServiceChecklistTemplate = _SrvcChklstTmplText.ServiceChecklistTemplate  -- association [0..*]
LEFT OUTER JOIN E_ServiceChecklistTemplate AS _SrvcChklstTmplExtn ON ServiceChecklistTemplate = _SrvcChklstTmplExtn.ServiceChecklistTemplate  -- association [0..1]
;

Learn More