C_ServiceOrderTemplateVH

DDL: C_SERVICEORDERTEMPLATEVH Type: view_entity CONSUMPTION Package: CRMS4_SERV_FIORI_UI

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)

SourceAliasJoin Type
I_ServiceDocumentEnhcd I_ServiceDocumentEnhcd from

Annotations (10)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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'