I_SESWorkflowEmailDeadline

DDL: I_SESWORKFLOWEMAILDEADLINE SQL: ISESWFEMLDL Type: view COMPOSITE
17 Fields 2 Data Sources 1 Associations

Email Template for Service Entry Sheet Workflow Deadline

I_SESWorkflowEmailDeadline (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_SESWorkflowEmailDeadline is a Composite CDS View that provides data about "Email Template for Service Entry Sheet Workflow Deadline" in SAP S/4HANA. It reads from 2 data sources (I_WorkflowTask, I_WorkflowTaskApplObject) and exposes 17 fields with key field WorkflowTaskInternalID. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Operational Procurement
Purpose
This CDS view is used as a data source to create email templates for missed deadlines in your workflow scenarios for service entry sheets. It contains data related to the header data of service entry sheets and the approval status. This CDS view provides the data to answer the following business questions: Which service entry sheets are currently in process of a workflow? What is the current approval status of a service entry sheet? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations The following business catalog needs to be assigned to a user to be able to use this CDS view: SAP_BR_PURCHASING_MANAGER Users who want to use this CDS view must have the following authorization objects assigned: M_SES_EKO (Purchasing Organization in Service Entry Sheet) M_SES_EKG (Purchasing Group in Service Entry Sheet)

Structure
Business Objects This view is built on the following business object: Service Entry Sheet (Lean Services) Important Fields Important fields in this view include the following: Field Name Description ServiceEntrySheet ID of the service entry sheet ServiceEntrySheetName Name of the service entry sheet

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-SVC-SES
CapabilitiesOutput: Email Data Provider
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is used as a data source to create email templates for missed deadlines in your workflow scenarios for service entry sheets. It contains data related to the header data of service entry sheets and the approval status.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>Which service entry sheets are currently in process of a workflow?</p></li> <li><p>What is the current approval status of a service entry sheet?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (2)

SourceAliasJoin Type
I_WorkflowTask _WorkflowTask from
I_WorkflowTaskApplObject _WorkflowTaskApplObject inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ServiceEntrySheetBasic _ServiceEntrySheet _ServiceEntrySheet.ServiceEntrySheet = _WorkflowTaskApplObject.SAPBusinessObjectNodeKey1 and _WorkflowTaskApplObject.WorkflowTaskInternalID is not null

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISESWFEMLDL view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.supportedCapabilities #OUTPUT_EMAIL_DATA_PROVIDER view
ObjectModel.modelingPattern #OUTPUT_EMAIL_DATA_PROVIDER view
EndUserText.label Email Template for Service Entry Sheet Workflow Deadline view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID Work Item ID
SAPObjectNodeRepresentation I_WorkflowTaskApplObject SAPObjectNodeRepresentation SAP Object Node Type
SuplrInvcWrkflwTaskDesc Work item text
SuplrInvcWrkflwTaskType I_WorkflowTask WorkflowTaskType Work Item Type
SuplrInvcWrkflwTskTypeDesc Work Item Type
SuplrInvcWrkflwTaskStatus I_WorkflowTask WorkflowTaskStatus Processing Status of a Work Item
SuplrInvcWrkflwTskStatusDesc Workflow: Work Item Status
WorkflowTaskCreatedByUser I_WorkflowTask WorkflowTaskCreatedByUser User Who Created the Work Item
SuplrInvcWrkflwTskCrtnDateTime I_WorkflowTask WrkflwTskCreationUTCDateTime Workflow: Creation Time Stamp
WorkflowTaskCurrentUser I_WorkflowTask WorkflowTaskCurrentUser Actual Agent of Work Item
FullName _User UserDescription User Description
WorkflowTaskDefinition I_WorkflowTask WorkflowTaskDefinition Task ID
WorkflowTaskDueUTCDateTime _TaskDueDate WorkflowTaskDueUTCDateTime Latest End Time for Work Item
ServiceEntrySheet _ServiceEntrySheet ServiceEntrySheet Service Entry Sheet
ServiceEntrySheetName _ServiceEntrySheet ServiceEntrySheetName Name of Service Entry Sheet
PurchasingOrganization _ServiceEntrySheet PurchasingOrganization Purchasing Organization
PurchasingGroup _ServiceEntrySheet PurchasingGroup Purchasing Group

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SESWorkflowEmailDeadline.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISESWFEMLDL

CREATE VIEW I_SESWorkflowEmailDeadline AS
SELECT
  _WorkflowTask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _WorkflowTaskApplObject.SAPObjectNodeRepresentation AS SAPObjectNodeRepresentation,
  _WorkflowTask._TaskTitle[1:Language=$session.system_language].WorkflowTaskName AS SuplrInvcWrkflwTaskDesc,
  _WorkflowTask.WorkflowTaskType AS SuplrInvcWrkflwTaskType,
  _WorkflowTask._TaskType._Text[1:Language=$session.system_language].WorkflowTaskTypeDesc AS SuplrInvcWrkflwTskTypeDesc,
  _WorkflowTask.WorkflowTaskStatus AS SuplrInvcWrkflwTaskStatus,
  _WorkflowTask._TaskStatus._Text[1:Language=$session.system_language].WorkflowTaskStatusDesc AS SuplrInvcWrkflwTskStatusDesc,
  _WorkflowTask.WorkflowTaskCreatedByUser AS WorkflowTaskCreatedByUser,
  _WorkflowTask.WrkflwTskCreationUTCDateTime AS SuplrInvcWrkflwTskCrtnDateTime,
  _WorkflowTask.WorkflowTaskCurrentUser AS WorkflowTaskCurrentUser,
  _User.UserDescription AS FullName,
  _WorkflowTask.WorkflowTaskDefinition AS WorkflowTaskDefinition,
  _TaskDueDate.WorkflowTaskDueUTCDateTime AS WorkflowTaskDueUTCDateTime,
  _ServiceEntrySheet.ServiceEntrySheet AS ServiceEntrySheet,
  _ServiceEntrySheet.ServiceEntrySheetName AS ServiceEntrySheetName,
  _ServiceEntrySheet.PurchasingOrganization AS PurchasingOrganization,
  _ServiceEntrySheet.PurchasingGroup AS PurchasingGroup
FROM I_WorkflowTask AS _WorkflowTask
INNER JOIN I_WorkflowTaskApplObject AS _WorkflowTaskApplObject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ServiceEntrySheetBasic AS _ServiceEntrySheet ON _ServiceEntrySheet.ServiceEntrySheet = _WorkflowTaskApplObject.SAPBusinessObjectNodeKey1 AND _WorkflowTaskApplObject.WorkflowTaskInternalID is not null  -- association [0..1]
;

Learn More