I_PurRequisitionEmailTemplate

DDL: I_PURREQUISITIONEMAILTEMPLATE SQL: IPUREQMAILTMP Type: view COMPOSITE

Email Template for Purchase Requisition

I_PurRequisitionEmailTemplate is a Composite CDS View that provides data about "Email Template for Purchase Requisition" in SAP S/4HANA. It reads from 3 data sources (I_PurchaseRequisitionItemAPI01, P_purreqemailtemplatehdr, I_WorkflowTask) and exposes 25 fields with key field WorkflowTaskInternalID.

3 data source(s) 25 fields

Data Sources (3)

SourceAliasJoin Type
I_PurchaseRequisitionItemAPI01 _PurReqApi01 left_outer
P_purreqemailtemplatehdr _PurReqEmailTempHdr left_outer
I_WorkflowTask _WorkflowTask from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPUREQMAILTMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C 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 Purchase Requisition view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
PurchaseRequisition I_PurchaseRequisitionItemAPI01 PurchaseRequisition
PurchaseRequisitionItem I_PurchaseRequisitionItemAPI01 PurchaseRequisitionItem
PurchaseRequisitionItemText I_PurchaseRequisitionItemAPI01 PurchaseRequisitionItemText
RequisitionerName I_PurchaseRequisitionItemAPI01 RequisitionerName
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: 'IPUREQMAILTMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Email Template for Purchase Requisition'

define view I_PurRequisitionEmailTemplate
  as select from    I_WorkflowTask              as _WorkflowTask
    left outer join P_purreqemailtemplatehdr    as _PurReqEmailTempHdr on  _PurReqEmailTempHdr.WorkflowTaskInternalID = _WorkflowTask.WorkflowTaskInternalID
                                                                       and _PurReqEmailTempHdr.WorkflowObjectRole     = '01'

    left outer join I_PurchaseRequisitionItemAPI01 as _PurReqApi01        on _PurReqApi01.PurchaseRequisition = _PurReqEmailTempHdr.Purchaserequisition

{
  key _WorkflowTask.WorkflowTaskInternalID,
      _PurReqApi01.PurchaseRequisition,
      _PurReqApi01.PurchaseRequisitionItem,
      _PurReqApi01.PurchaseRequisitionItemText,
      _PurReqApi01.RequisitionerName,
      _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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEREQUISITIONITEMAPI01",
"I_WORKFLOWTASK",
"P_PURREQEMAILTEMPLATEHDR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More