C_ServiceOrderTemplateVH
List of Service Templates
C_ServiceOrderTemplateVH is a Consumption CDS View that provides data about "List of Service Templates" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentEnhcd) and exposes 22 fields with key field ServiceDocument. Part of development package CRMS4_SERV_FIORI_UI.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ServiceDocumentEnhcd | I_ServiceDocumentEnhcd | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | List of Service Templates | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| Search.searchable | true | view | |
| Consumption.ranked | true | view |
Fields (22)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ServiceDocument | ServiceDocument | ||
| ServiceDocumentDescription | ServiceDocumentDescription | |||
| ServiceObjectType | ServiceObjectType | |||
| ServiceDocumentType | ServiceDocumentType | |||
| ServiceDocumentTypeName | ||||
| ResponsibleEmployee | ResponsibleEmployee | |||
| ResponsibleEmployeeName | ||||
| ProductID | ||||
| ServiceDocumentIsReleased | ServiceDocumentIsReleased | |||
| ServiceDocumentHasError | ServiceDocumentHasError | |||
| SrvcDocTemplateSearchTermText | SrvcDocTemplateSearchTermText | |||
| ServiceOrganization | ServiceOrganization | |||
| SalesOrganization | SalesOrganization | |||
| DistributionChannel | DistributionChannel | |||
| Division | Division | |||
| SalesOffice | SalesOffice | |||
| SalesGroup | SalesGroup | |||
| SalesOrganizationOrgUnitID | SalesOrganizationOrgUnitID | |||
| SalesOfficeOrgUnitID | SalesOfficeOrgUnitID | |||
| SalesGroupOrgUnitID | SalesGroupOrgUnitID | |||
| ServiceDocumentTemplateType | ServiceDocumentTemplateType | |||
| _ServiceDocRefObj | _ServiceDocRefObj |
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'List of Service Templates'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.dataCategory: #VALUE_HELP
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #REQUIRED
@Search: {
searchable: true
}
@Consumption.ranked:true
define view entity C_ServiceOrderTemplateVH
as select from I_ServiceDocumentEnhcd
// association [0..1] to I_ServiceDocumentStatus as _ServiceDocumentOrdStatus on $projection.ServiceDocumentStatus = _ServiceDocumentOrdStatus.ServiceDocumentStatus
{
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.8 }
key ServiceDocument,
ServiceDocumentDescription,
ServiceObjectType,
// @UI.textArrangement: #TEXT_FIRST
// @ObjectModel.foreignKey.association: '_ServiceDocumentOrdStatus'
// // @ObjectModel.text.element: ['ServiceDocumentStatusName']
// ServiceDocumentStatus,
// // @Semantics.text: true
// // @UI.hidden: true
// // _ServiceDocumentStatus._ServiceDocumentStatusText[1:Language = $session.system_language].ServiceDocumentStatusName as ServiceDocumentStatusName,
@UI.textArrangement: #TEXT_FIRST
@ObjectModel.text.element: ['ServiceDocumentTypeName']
ServiceDocumentType,
_ServiceDocumentType._ServiceDocumentTypeText[1:Language = $session.system_language].ServiceDocumentTypeName,
ResponsibleEmployee,
I_ServiceDocumentEnhcd._RespEmployee.BusinessPartnerName as ResponsibleEmployeeName,
/************************************************/
/*
The below fields are required for Maintenance Plan and is UI hidden in Service Order Templates
*/
@UI.hidden: true
I_ServiceDocumentEnhcd._ServiceDocRefObj.ProductID,
@UI.hidden: true
case I_ServiceDocumentEnhcd._ServiceDocRefObj.ServiceReferenceObjectType
when 'B' then cast (I_ServiceDocumentEnhcd._ServiceDocRefObj.FunctionalLocation as eams_tec_obj)
when 'C' then cast (I_ServiceDocumentEnhcd._ServiceDocRefObj.Equipment as eams_tec_obj)
end as TechnicalObject,
@UI.hidden: true
ServiceDocumentIsReleased,
@UI.hidden: true
ServiceDocumentHasError,
@UI.hidden: true
SrvcDocTemplateSearchTermText,
/***********************************************/
ServiceOrganization,
SalesOrganization,
DistributionChannel,
Division,
SalesOffice,
SalesGroup,
SalesOrganizationOrgUnitID,
SalesOfficeOrgUnitID,
SalesGroupOrgUnitID,
ServiceDocumentTemplateType,
_ServiceDocRefObj
//_ServiceDocumentOrdStatus
}
where
ServiceDocumentTemplateType <> ' '
and ServiceDocumentStatus = 'D'
and ServiceObjectType = 'BUS2000116'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA