I_SrcgSuplrListEmailTemplate

DDL: I_SRCGSUPLRLISTEMAILTEMPLATE SQL: ISRCGSLMAILTMP Type: view COMPOSITE Package: VDM_MM_PUR_INSTSL

Email Template for Srcg Supplier List

I_SrcgSuplrListEmailTemplate is a Composite CDS View that provides data about "Email Template for Srcg Supplier List" in SAP S/4HANA. It reads from 3 data sources (I_SourcingSupplierList, I_WorkflowTask, I_WorkflowTaskApplObject) and exposes 24 fields with key field WorkflowTaskInternalID. Part of development package VDM_MM_PUR_INSTSL.

3 data source(s) 24 fields

Data Sources (3)

SourceAliasJoin Type
I_SourcingSupplierList _SourcingSupplierList inner
I_WorkflowTask _WorkflowTask from
I_WorkflowTaskApplObject _WorkflowTaskApplObject inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISRCGSLMAILTMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Email Template for Srcg Supplier List view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
SourcingSupplierList I_SourcingSupplierList SourcingSupplierList
SourcingSupplierListName I_SourcingSupplierList SourcingSupplierListName
SupplierListReferenceObject I_SourcingSupplierList SupplierListReferenceObject
WorkflowTaskType I_WorkflowTask WorkflowTaskType
WorkflowTaskPriority I_WorkflowTask WorkflowTaskPriority
WorkflowTaskStatus I_WorkflowTask WorkflowTaskStatus
WrkflwTskCreationUTCDateTime I_WorkflowTask WrkflwTskCreationUTCDateTime
WrkflwTskCompletionUTCDateTime I_WorkflowTask WrkflwTskCompletionUTCDateTime
TopLevelWorkflowTask I_WorkflowTask TopLevelWorkflowTask
ParentWorkflowTask I_WorkflowTask ParentWorkflowTask
WorkflowTaskCreatedByUser I_WorkflowTask WorkflowTaskCreatedByUser
WorkflowTaskCurrentUser I_WorkflowTask WorkflowTaskCurrentUser
WorkflowTaskDefinition I_WorkflowTask WorkflowTaskDefinition
WorkflowTaskDefinitionObjType I_WorkflowTask WorkflowTaskDefinitionObjType
WorkflowTaskDefinitionObject I_WorkflowTask WorkflowTaskDefinitionObject
TopLevelWorkflowTaskDefinition I_WorkflowTask TopLevelWorkflowTaskDefinition
TopLevelWrkflwTskDefObjType I_WorkflowTask TopLevelWrkflwTskDefObjType
TopLevelWrkflwTskDefObject I_WorkflowTask TopLevelWrkflwTskDefObject
WorkflowTaskStepType I_WorkflowTask WorkflowTaskStepType
WorkflowTaskProcessorRole I_WorkflowTask WorkflowTaskProcessorRole
WorkflowTaskDefinitionVersion I_WorkflowTask WorkflowTaskDefinitionVersion
WorkflowTaskDefinitionType I_WorkflowTask WorkflowTaskDefinitionType
WorkflowTaskResult I_WorkflowTask WorkflowTaskResult 
@AbapCatalog.sqlViewName: 'ISRCGSLMAILTMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Email Template for Srcg Supplier List'
define view I_SrcgSuplrListEmailTemplate
  as select from            I_WorkflowTask           as _WorkflowTask
    inner join I_WorkflowTaskApplObject as _WorkflowTaskApplObject on  _WorkflowTaskApplObject.WorkflowTaskInternalID = _WorkflowTask.WorkflowTaskInternalID
                                                                                and _WorkflowTaskApplObject.WorkflowObjectRole     = '01'

    inner join I_SourcingSupplierList   as _SourcingSupplierList   on _SourcingSupplierList.SourcingSupplierList = _WorkflowTaskApplObject.TechnicalWrkflwObject

  //        left outer to one join  z_sbl_workflowtaskresult as _sbl_workflowtaskresult on _WorkflowTask.WorkflowTaskInternalID = _sbl_workflowtaskresult.WorkflowTaskInternalID

{
  key _WorkflowTask.WorkflowTaskInternalID,
      _SourcingSupplierList.SourcingSupplierList,
      _SourcingSupplierList.SourcingSupplierListName,
      _SourcingSupplierList.SupplierListReferenceObject,
      _WorkflowTask.WorkflowTaskType,
      _WorkflowTask.WorkflowTaskPriority,
      _WorkflowTask.WorkflowTaskStatus,
      _WorkflowTask.WrkflwTskCreationUTCDateTime,
      _WorkflowTask.WrkflwTskCompletionUTCDateTime,
      _WorkflowTask.TopLevelWorkflowTask,
      _WorkflowTask.ParentWorkflowTask,
      _WorkflowTask.WorkflowTaskCreatedByUser,
      _WorkflowTask.WorkflowTaskCurrentUser,
      _WorkflowTask.WorkflowTaskDefinition,
      _WorkflowTask.WorkflowTaskDefinitionObjType,
      _WorkflowTask.WorkflowTaskDefinitionObject,
      _WorkflowTask.TopLevelWorkflowTaskDefinition,
      _WorkflowTask.TopLevelWrkflwTskDefObjType,
      _WorkflowTask.TopLevelWrkflwTskDefObject,
      _WorkflowTask.WorkflowTaskStepType,
      _WorkflowTask.WorkflowTaskProcessorRole,
      _WorkflowTask.WorkflowTaskDefinitionVersion,
      _WorkflowTask.WorkflowTaskDefinitionType,
      _WorkflowTask.WorkflowTaskResult
      //                  _sbl_workflowtaskresult.WorkflowTaskResult,

      //

      //                  case _sbl_workflowtaskresult.WorkflowTaskResult

      //                    when 'RELEASED' then 'approved'

      //                    when 'REJECTED' then 'rejected'

      //                    else ''

      //                  end as SupplierListWFLResult



}
//where _WorkflowTask.WorkflowTaskType = 'W'

Learn More