I_SrvcChklstTmplText

DDL: I_SRVCCHKLSTTMPLTEXT Type: view_entity BASIC Package: CRMS4_FSM_CHECKLIST_INT
6 Fields 1 Data Sources

Checklist Template - Text

I_SrvcChklstTmplText (Basic)

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

Sales

I_SrvcChklstTmplText is a Basic CDS View that provides data about "Checklist Template - Text" in SAP S/4HANA. It reads from 1 data source (crmd_fsm_tm_hdrt) and exposes 6 fields with key fields ServiceChecklistTemplate, 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_hdrt crmd_fsm_tm_hdrt from

Annotations (10)

NameValueLevelField
EndUserText.label Checklist Template - 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 (6)

KeyFieldSource TableSource FieldDescription
KEY ServiceChecklistTemplate template_id Template LinkID
KEY SrvcChklstLanguage spras Off. Language
SrvcChklstTmplName name Template Name
SrvcChklstTmplDescription description FSM Template Description
SrvcChklstTmplCategoryName category_name FSM Category Name
SrvcChklstTmplTagsString tags Template Tags

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_SrvcChklstTmplText.
-- 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_SrvcChklstTmplText AS
SELECT
  template_id AS ServiceChecklistTemplate,
  spras AS SrvcChklstLanguage,
  name AS SrvcChklstTmplName,
  description AS SrvcChklstTmplDescription,
  category_name AS SrvcChklstTmplCategoryName,
  tags AS SrvcChklstTmplTagsString
FROM crmd_fsm_tm_hdrt
;

Learn More