R_SrvcChklstTmplCategoryTP

DDL: R_SRVCCHKLSTTMPLCATEGORYTP Type: view_entity TRANSACTIONAL Package: CRMS4_FSM_CHECKLIST_INT
8 Fields 1 Data Sources 1 Associations

Checklist Template Category - TP

R_SrvcChklstTmplCategoryTP is a Transactional CDS View that provides data about "Checklist Template Category - TP" in SAP S/4HANA. It reads from 1 data source (I_SrvcChklstTmplCategory) and exposes 8 fields with key field SrvcChklstTmplCategory. It has 1 association to related views. Part of development package CRMS4_FSM_CHECKLIST_INT.

Data Sources (1)

SourceAliasJoin Type
I_SrvcChklstTmplCategory I_SrvcChklstTmplCategory from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_ServiceChecklistTemplateTP _ServiceChecklistTemplate $projection.SrvcChklstTmplCategory = _ServiceChecklistTemplate.SrvcChklstTmplCategory

Annotations (11)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SrvcChklstTmplCategory SrvcChklstTmplCategory TemplateCategoryID
FSMChecklistCategoryUUID FSMChecklistCategoryUUID FSM Category ID
SrvcChklstTmplCategoryName SrvcChklstTmplCategoryName Text
SrvcChklstCreationDateTime SrvcChklstCreationDateTime Uploaded On
SrvcChklstCreatedByUser SrvcChklstCreatedByUser Version Created By
SrvcChklstChangedDateTime SrvcChklstChangedDateTime Timestamp
SrvcChklstChangedByUser SrvcChklstChangedByUser Username
_ServiceChecklistTemplate _ServiceChecklistTemplate

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_SrvcChklstTmplCategoryTP.
-- 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_SrvcChklstTmplCategoryTP AS
SELECT
  SrvcChklstTmplCategory,
  FSMChecklistCategoryUUID,
  SrvcChklstTmplCategoryName,
  SrvcChklstCreationDateTime,
  SrvcChklstCreatedByUser,
  SrvcChklstChangedDateTime,
  SrvcChklstChangedByUser
FROM I_SrvcChklstTmplCategory
LEFT OUTER JOIN R_ServiceChecklistTemplateTP AS _ServiceChecklistTemplate ON SrvcChklstTmplCategory = _ServiceChecklistTemplate.SrvcChklstTmplCategory  -- association [0..*]
;

Learn More