R_ServiceChecklistTemplateTP

DDL: R_SERVICECHECKLISTTEMPLATETP Type: view_entity TRANSACTIONAL Package: CRMS4_FSM_CHECKLIST_INT
18 Fields 1 Data Sources 3 Associations

Service Checklist Template - TP

R_ServiceChecklistTemplateTP is a Transactional CDS View that provides data about "Service Checklist Template - TP" in SAP S/4HANA. It reads from 1 data source (I_ServiceChecklistTemplate) and exposes 18 fields with key field ServiceChecklistTemplate. It has 3 associations to related views. Part of development package CRMS4_FSM_CHECKLIST_INT.

Data Sources (1)

SourceAliasJoin Type
I_ServiceChecklistTemplate I_ServiceChecklistTemplate from

Associations (3)

CardinalityTargetAliasCondition
[0..1] R_SrvcChklstTmplCategoryTP _SrvcChklstTmplCategory $projection.SrvcChklstTmplCategory = _SrvcChklstTmplCategory.SrvcChklstTmplCategory
[0..*] R_SrvcChklstTmplTextTP _SrvcChklstTmplText
[0..*] R_SrvcChklstTmplElementTP _SrvcChklstTmplElement

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Service Checklist Template - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey ServiceChecklistTemplate view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ServiceChecklistTemplate 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
FSMAccount FSMAccount Account ID
FSMCompany FSMCompany Company ID
FSMChecklistTemplateGroupUUID FSMChecklistTemplateGroupUUID
FSMChecklistRequest FSMChecklistRequest Request ID
SrvcChklstTmplVersion SrvcChklstTmplVersion XML Vers.
SrvcChklstLanguage SrvcChklstLanguage Language
_SrvcChklstTmplText _SrvcChklstTmplText
_SrvcChklstTmplElement _SrvcChklstTmplElement
_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 R_ServiceChecklistTemplateTP.
-- 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_ServiceChecklistTemplateTP AS
SELECT
  ServiceChecklistTemplate,
  SrvcChklstTmplStatus,
  SrvcChklstTmplCategory,
  SrvcChklstCreationDateTime,
  SrvcChklstCreatedByUser,
  SrvcChklstChangedDateTime,
  SrvcChklstChangedByUser,
  FSMChecklistTemplateUUID,
  FSMChecklistCategoryUUID,
  FSMAccount,
  FSMCompany,
  FSMChecklistTemplateGroupUUID,
  FSMChecklistRequest,
  SrvcChklstTmplVersion,
  SrvcChklstLanguage
FROM I_ServiceChecklistTemplate
LEFT OUTER JOIN R_SrvcChklstTmplCategoryTP AS _SrvcChklstTmplCategory ON SrvcChklstTmplCategory = _SrvcChklstTmplCategory.SrvcChklstTmplCategory  -- association [0..1]
LEFT OUTER JOIN R_SrvcChklstTmplTextTP AS _SrvcChklstTmplText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcChklstTmplElementTP AS _SrvcChklstTmplElement ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More