C_ServiceOrderTemplateVH

@AbapCatalog.sqlViewName: 'CSRVORDTMPLVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@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
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@Search: {
  searchable: true
}
@Consumption.ranked:true
define view 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,
      _RespEmployee.BusinessPartnerName as ResponsibleEmployeeName,

      /************************************************/
      /*
         The below fields are required for Maintenance Plan and is UI hidden in Service Order Templates
      */
      @UI.hidden: true
      _ServiceDocRefObj.ProductID,

      @UI.hidden: true
      case _ServiceDocRefObj.ServiceReferenceObjectType
               when 'B' then cast (_ServiceDocRefObj.FunctionalLocation as eams_tec_obj)
               when 'C' then cast (_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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTREFOBJECT",
"I_SERVICEDOCUMENTTYPE",
"I_SERVICEDOCUMENTTYPETEXT"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENTREFOBJECT"
],
"BASE":
[
"I_SERVICEDOCUMENTENHCD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/