I_PurReqnItemEmailTemplate

DDL: I_PURREQNITEMEMAILTEMPLATE SQL: IPUREQITMAILTMP Type: view COMPOSITE Package: VDM_MM_PUR

Email Template for PurchaseReqn Obsolete

I_PurReqnItemEmailTemplate is a Composite CDS View that provides data about "Email Template for PurchaseReqn Obsolete" in SAP S/4HANA. It reads from 2 data sources (P_purreqemailtemplateitm, I_WorkflowTask) and exposes 26 fields with key field WorkflowTaskInternalID. It has 1 association to related views. Part of development package VDM_MM_PUR.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
P_purreqemailtemplateitm _PurReqEmailTempItem inner
I_WorkflowTask _WorkflowTask from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurchaseRequisitionItemAPI01 _PurchaseRequisitionItemAPI01 _PurchaseRequisitionItemAPI01.PurchaseRequisition = _PurReqEmailTempItem.Purchaserequisition and _PurchaseRequisitionItemAPI01.PurchaseRequisitionItem = _PurReqEmailTempItem.PurchaseRequisitionItem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPUREQITMAILTMP 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 PurchaseReqn Obsolete view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
PurchaseRequisition P_purreqemailtemplateitm Purchaserequisition
PurchaseRequisitionItem P_purreqemailtemplateitm PurchaseRequisitionItem
PurchaseRequisitionItemText _PurchaseRequisitionItemAPI01 PurchaseRequisitionItemText
RequisitionerName _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
_PurchaseRequisitionItemAPI01 _PurchaseRequisitionItemAPI01 
@AbapCatalog.sqlViewName:'IPUREQITMAILTMP'
@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 PurchaseReqn Obsolete'
define view I_PurReqnItemEmailTemplate
  as select from    I_WorkflowTask              as _WorkflowTask
    inner join P_purreqemailtemplateitm    as _PurReqEmailTempItem on  _PurReqEmailTempItem.WorkflowTaskInternalID = _WorkflowTask.WorkflowTaskInternalID
                                                                        and _PurReqEmailTempItem.WorkflowObjectRole     = '01'

    association [0..1] to  I_PurchaseRequisitionItemAPI01 as _PurchaseRequisitionItemAPI01   on  _PurchaseRequisitionItemAPI01.PurchaseRequisition     = _PurReqEmailTempItem.Purchaserequisition
                                                                                            and _PurchaseRequisitionItemAPI01.PurchaseRequisitionItem = _PurReqEmailTempItem.PurchaseRequisitionItem

{
  key _WorkflowTask.WorkflowTaskInternalID,
      _PurReqEmailTempItem.Purchaserequisition  as PurchaseRequisition ,
      _PurReqEmailTempItem.PurchaseRequisitionItem ,
      _PurchaseRequisitionItemAPI01.PurchaseRequisitionItemText,
      _PurchaseRequisitionItemAPI01.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,
      _PurchaseRequisitionItemAPI01
     
      
}

Learn More