R_SrvcChklstInstceValueTP

DDL: R_SRVCCHKLSTINSTCEVALUETP Type: view_entity TRANSACTIONAL Package: CRMS4_FSM_CHECKLIST_INT
16 Fields 1 Data Sources

Checklist Instance Values - TP

R_SrvcChklstInstceValueTP is a Transactional CDS View that provides data about "Checklist Instance Values - TP" in SAP S/4HANA. It reads from 1 data source (I_SrvcChklstInstceValue) and exposes 16 fields with key fields ServiceChecklistInstance, SrvcChecklistTemplateElement, SrvcChklstInstceElmntOccren. Part of development package CRMS4_FSM_CHECKLIST_INT.

Data Sources (1)

SourceAliasJoin Type
I_SrvcChklstInstceValue I_SrvcChklstInstceValue from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Checklist Instance Values - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey SrvcChecklistTemplateElement view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name SrvcChklstInstceValue view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ServiceChecklistInstance ServiceChecklistInstance Instance ID
KEY SrvcChecklistTemplateElement SrvcChecklistTemplateElement OAN Element ID
KEY SrvcChklstInstceElmntOccren SrvcChklstInstceElmntOccren Sequence Number
SrvcChklstInstceElmntValueType SrvcChklstInstceElmntValueType Value Type
SrvcChklstInstceElmntSeriesIdx SrvcChklstInstceElmntSeriesIdx Series Index
SrvcChklstInstceElmntTblRowIdx SrvcChklstInstceElmntTblRowIdx Table Row
SrvcChklstInstceStateElmntIdx SrvcChklstInstceStateElmntIdx State Element Index
SrvcChklstInstceAttchPickerIdx SrvcChklstInstceAttchPickerIdx Atchmnt. PickerIndex
NrOfSvCklInstceStateElements NrOfSvCklInstceStateElements State Element Quan.
SrvcChklstInstceElementValue SrvcChklstInstceElementValue Value
SrvcChklstInstceElmntDesc SrvcChklstInstceElmntDesc Element Description
SrvcChklstInstceElmntComment SrvcChklstInstceElmntComment Element Comment
SrvcChklstInstceElmntImage SrvcChklstInstceElmntImage Element Image
SrvcChklstInstceElmntItem SrvcChklstInstceElmntItem Element Item
SrvcChklstLanguage SrvcChklstLanguage Report Text Language
_ServiceChecklistInstance _ServiceChecklistInstance

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 R_SrvcChklstInstceValueTP.
-- 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 R_SrvcChklstInstceValueTP AS
SELECT
  ServiceChecklistInstance,
  SrvcChecklistTemplateElement,
  SrvcChklstInstceElmntOccren,
  SrvcChklstInstceElmntValueType,
  SrvcChklstInstceElmntSeriesIdx,
  SrvcChklstInstceElmntTblRowIdx,
  SrvcChklstInstceStateElmntIdx,
  SrvcChklstInstceAttchPickerIdx,
  NrOfSvCklInstceStateElements,
  SrvcChklstInstceElementValue,
  SrvcChklstInstceElmntDesc,
  SrvcChklstInstceElmntComment,
  SrvcChklstInstceElmntImage,
  SrvcChklstInstceElmntItem,
  SrvcChklstLanguage
FROM I_SrvcChklstInstceValue
;

Learn More