I_SrvcChklstInstceValue

DDL: I_SRVCCHKLSTINSTCEVALUE Type: view_entity BASIC
15 Fields 1 Data Sources 1 Associations

Checklist Instance Values

I_SrvcChklstInstceValue is a Basic CDS View that provides data about "Checklist Instance Values" in SAP S/4HANA. It reads from 1 data source (crmd_fsm_in_elm) and exposes 15 fields with key fields ServiceChecklistInstance, SrvcChecklistTemplateElement, SrvcChklstInstceElmntOccren. It has 1 association to related views.

SAP Help Documentation

CategoryIntegration with SAP Field Service Management
Purpose
This CDS view along with the CDS views I_SrvcChklstTmplElement and I_SrvcChecklistInstanceEnhcd helps users to identify the values entered by the technician at the customer site. This CDS view provides the data to answer the following business questions: What is the cause for the equipment repair activity? What are the recordings from the customer site that the technician has noted for the repair activity?

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 ServiceChecklistInstance Instance ID SrvcChecklistTemplateElement Template element ID SrvcChklstInstceElmntOccren Occurrence of the element SrvcChklstInstceElmntSeriesIdx Series index SrvcChklstInstceElmntTblRowIdx Table row index SrvcChklstInstceStateElmntIdx State element index SrvcChklstInstceAttchPickerIdx Attachment picker index NrOfSvCklInstceStateElements Quantity of elements chosen in the state element SrvcChklstInstceElementValue Element value SrvcChklstInstceElmntDesc Element description SrvcChklstInstceElmntComment Element comment SrvcChklstInstceElmntItem Item ID

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
crmd_fsm_in_elm crmd_fsm_in_elm from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_SrvcChklstInstceValue _SrvcChklstInstceValueExtn $projection.ServiceChecklistInstance = _SrvcChklstInstceValueExtn.ServiceChecklistInstance and $projection.SrvcChecklistTemplateElement = _SrvcChklstInstceValueExtn.SrvcChecklistTemplateElement and $projection.SrvcChklstInstceElmntOccren = _SrvcChklstInstceValueExtn.SrvcChklstInstceElmntOccren

Annotations (9)

NameValueLevelField
EndUserText.label Checklist Instance Values view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC 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 #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ServiceChecklistInstance instance_id Instance ID
KEY SrvcChecklistTemplateElement element_id OAN Element ID
KEY SrvcChklstInstceElmntOccren elm_occurence Sequence Number
SrvcChklstInstceElmntValueType value_type Value Type
SrvcChklstInstceElmntSeriesIdx series_index Series Index
SrvcChklstInstceElmntTblRowIdx table_row Table Row
SrvcChklstInstceStateElmntIdx state_elm_index State Element Index
SrvcChklstInstceAttchPickerIdx atchmnt_pkr_index Atchmnt. PickerIndex
NrOfSvCklInstceStateElements state_elm_quan State Element Quan.
SrvcChklstInstceElementValue elm_value Value
SrvcChklstInstceElmntDesc elm_description Element Description
SrvcChklstInstceElmntComment elm_comment Element Comment
SrvcChklstInstceElmntImage elm_image Element Image
SrvcChklstInstceElmntItem elm_item Element Item
SrvcChklstLanguage language Report Text Language

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_SrvcChklstInstceValue.
-- 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_SrvcChklstInstceValue AS
SELECT
  instance_id AS ServiceChecklistInstance,
  element_id AS SrvcChecklistTemplateElement,
  elm_occurence AS SrvcChklstInstceElmntOccren,
  value_type AS SrvcChklstInstceElmntValueType,
  series_index AS SrvcChklstInstceElmntSeriesIdx,
  table_row AS SrvcChklstInstceElmntTblRowIdx,
  state_elm_index AS SrvcChklstInstceStateElmntIdx,
  atchmnt_pkr_index AS SrvcChklstInstceAttchPickerIdx,
  state_elm_quan AS NrOfSvCklInstceStateElements,
  elm_value AS SrvcChklstInstceElementValue,
  elm_description AS SrvcChklstInstceElmntDesc,
  elm_comment AS SrvcChklstInstceElmntComment,
  elm_image AS SrvcChklstInstceElmntImage,
  elm_item AS SrvcChklstInstceElmntItem,
  language AS SrvcChklstLanguage
FROM crmd_fsm_in_elm
LEFT OUTER JOIN E_SrvcChklstInstceValue AS _SrvcChklstInstceValueExtn ON ServiceChecklistInstance = _SrvcChklstInstceValueExtn.ServiceChecklistInstance AND SrvcChecklistTemplateElement = _SrvcChklstInstceValueExtn.SrvcChecklistTemplateElement AND SrvcChklstInstceElmntOccren = _SrvcChklstInstceValueExtn.SrvcChklstInstceElmntOccren  -- association [0..1]
;

Learn More