I_SrvcChklstTmplElmntText

DDL: I_SRVCCHKLSTTMPLELMNTTEXT Type: view_entity BASIC Package: CRMS4_FSM_CHECKLIST_INT
8 Fields 1 Data Sources

Checklist Template Elements - Text

I_SrvcChklstTmplElmntText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sales

I_SrvcChklstTmplElmntText is a Basic CDS View that provides data about "Checklist Template Elements - Text" in SAP S/4HANA. It reads from 1 data source (crmd_fsm_tm_elmt) and exposes 8 fields with key fields ServiceChecklistTemplate, SrvcChecklistTemplateElement, SrvcChklstLanguage. Part of development package CRMS4_FSM_CHECKLIST_INT.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSales
Application ComponentCRM-S4-INT-FSM-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageSales for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
crmd_fsm_tm_elmt crmd_fsm_tm_elmt from

Annotations (10)

NameValueLevelField
EndUserText.label Checklist Template Elements - Text 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 #MASTER view
ObjectModel.dataCategory #TEXT view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ServiceChecklistTemplate template_id Template LinkID
KEY SrvcChecklistTemplateElement element_id OAN Element ID
KEY SrvcChklstLanguage spras Off. Language
SrvcChklstTmplElmntName name Element Name
SrvcChklstTmplElmntValueText value Value from table
SrvcChklstTmplElmntTitle title Element Title
SrvcChklstTmplElmntDescription description Element Description
SrvcChklstTmplElmntDisplayName displayname Element Display Name

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_SrvcChklstTmplElmntText.
-- 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_SrvcChklstTmplElmntText AS
SELECT
  template_id AS ServiceChecklistTemplate,
  element_id AS SrvcChecklistTemplateElement,
  spras AS SrvcChklstLanguage,
  name AS SrvcChklstTmplElmntName,
  value AS SrvcChklstTmplElmntValueText,
  title AS SrvcChklstTmplElmntTitle,
  description AS SrvcChklstTmplElmntDescription,
  displayname AS SrvcChklstTmplElmntDisplayName
FROM crmd_fsm_tm_elmt
;

Learn More