I_SuplrGEvalEmailTmplAPI02

@AbapCatalog.sqlViewName: 'IGEVALMAILTAPI02'
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ObjectModel.supportedCapabilities: 
[ #OUTPUT_EMAIL_DATA_PROVIDER ]
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA') 
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Email Template for Eval Notification'

define view I_SuplrGEvalEmailTmplAPI02 with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : /srmsmc/language_parameter
  as select  distinct from I_SupplierEvalResponse as response 
   join  I_SupplierEvalRspAppraiser   appraiser on appraiser.SuplrEvalRspUUID = response.SuplrEvalRspUUID
    left outer join  I_BusinessUser   businessuser on appraiser.UserID = businessuser.UserID and businessuser.IsBusinessPurposeCompleted = '' 
    left outer join  I_FormOfAddressText  formofaddressname on formofaddressname.FormOfAddress = businessuser.FormOfAddress and formofaddressname.Language = $parameters.P_Language
{ 

  key response.SuplrEvalRspUUID,
      cast(ltrim(response.SupplierEvalResponse,'0') as /srmsmc/evaluation_response_id) as SupplierEvalResponse,
      response.SuplrEvalRspName,
      @Semantics.businessDate.from: true
      response.SuplrEvalStartDate, 
      @Semantics.businessDate.to: true
      response.SuplrEvalEndDate, 
      cast(response.CreatedByUser as /srmsmc/created_by ) as CreatedByUser,
      response.CreationDateTime,
      cast(response.LastChangedByUser as /srmsmc/last_changed_by ) as LastChangedByUser,
      response.LastChangeDateTime,
      response.Language,
      cast(response._CreatedByUser._BusinessPartner[IsBusinessPurposeCompleted = ''].BusinessPartnerFullName as /srmsmc/created_by_user_desc)     as CreatedByUserDescription,
      cast(response._LastChangedByUser._BusinessPartner[IsBusinessPurposeCompleted = ''].BusinessPartnerFullName as /srmsmc/last_changed_by_desc) as LastChangedByUserName,
      formofaddressname.FormOfAddressName as FormOfAddressName,
      businessuser.FirstName,
      businessuser.LastName as FamilyName,
      cast(response._Supplier._BusinessPartner[IsBusinessPurposeCompleted = ''].BusinessPartnerFullName as /srmsmc/company_name ) as BusinessPartnerFullName
}