I_SuplrActyTaskEmailTmplAPI01

DDL: I_SUPLRACTYTASKEMAILTMPLAPI01 SQL: ITSKMAILTAPI01 Type: view COMPOSITE

Email Template for Task Notification

I_SuplrActyTaskEmailTmplAPI01 is a Composite CDS View that provides data about "Email Template for Task Notification" in SAP S/4HANA. It reads from 2 data sources (I_BusinessUser, I_FormOfAddressText) and exposes 16 fields with key field SuplrActyTaskUUID.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessUser I_BusinessUser left_outer
I_FormOfAddressText I_FormOfAddressText left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITSKMAILTAPI01 view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Email Template for Task Notification view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SuplrActyTaskUUID Task SuplrActyTaskUUID
SupplierActivityTask
SuplrActyTaskName Task SuplrActyTaskName
EndDate Task EndDate
CreationDateTime Task CreationDateTime
CreatedByUser
LastChangeDateTime Task LastChangeDateTime
LastChangedByUser
Language Task Language
CreatedByUserDescription
LastChangedByUserName
SuplrActyName
SuplrActyTaskPriorityName
FormOfAddressName formofaddressname FormOfAddressName
FirstName businessuser FirstName
FamilyName businessuser LastName 
@AbapCatalog.sqlViewName: 'ITSKMAILTAPI01'
@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 Task Notification'

define view I_SuplrActyTaskEmailTmplAPI01  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : /srmsmc/language_parameter
  as select distinct from    I_SupplierActivityTask as Task
    join I_SupplierActivityTskProcessor processor on processor.SuplrActyTaskUUID = Task.SuplrActyTaskUUID
    left outer join  I_BusinessUser   businessuser on processor.UserID = businessuser.UserID and businessuser.IsBusinessPurposeCompleted = '' 
    left outer join  I_FormOfAddressText  formofaddressname on formofaddressname.FormOfAddress = businessuser.FormOfAddress and formofaddressname.Language = $parameters.P_Language
{
  key Task.SuplrActyTaskUUID,
      cast(ltrim(Task.SupplierActivityTask,'0') as /srmsmc/task_id )                                                                          as SupplierActivityTask,
      Task.SuplrActyTaskName,
      Task.EndDate,
      Task.CreationDateTime,
      cast(Task.CreatedByUser as /srmsmc/created_by ) as CreatedByUser,
      Task.LastChangeDateTime,
      cast(Task.LastChangedByUser as /srmsmc/last_changed_by ) as LastChangedByUser,
      Task.Language,
      cast(Task._CreatedByUser._BusinessPartner[IsBusinessPurposeCompleted = ''].BusinessPartnerFullName as /srmsmc/created_by_user_desc)     as CreatedByUserDescription,
      cast(Task._LastChangedByUser._BusinessPartner[IsBusinessPurposeCompleted = ''].BusinessPartnerFullName as /srmsmc/last_changed_by_desc) as LastChangedByUserName,
      Task._SupplierActivity._SupplierActivity.SuplrActyName,
      Task._SupplierActivityTaskPrio._SupplierActivityTaskPrioText[1:Language=$parameters.P_Language].SuplrActyTaskPriorityName,
      formofaddressname.FormOfAddressName as FormOfAddressName,
      businessuser.FirstName as FirstName,
      businessuser.LastName as FamilyName
}

Learn More