I_SuplrInvcWrkflwEmlDeadLine

DDL: I_SUPLRINVCWRKFLWEMLDEADLINE SQL: ISIWFEMLDL Type: view COMPOSITE
21 Fields 2 Data Sources

Supplier Invoice Details for Workflow Deadline Email

I_SuplrInvcWrkflwEmlDeadLine (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_SuplrInvcWrkflwEmlDeadLine is a Composite CDS View that provides data about "Supplier Invoice Details for Workflow Deadline Email" in SAP S/4HANA. It reads from 2 data sources (I_WorkflowTask, I_WorkflowTaskApplObject) and exposes 21 fields with key field WorkflowTaskInternalID.

SAP Help Documentation

CategoryCDS Views for Invoice Processing
Data CategoryN/A
Purpose
This CDS view is used as a data source to create email templates for missed deadlines in your supplier invoice workflow scenarios. It contains data related to the supplier invoices header data and the workflow status. This CDS view provides the data to answer the following business questions: Which supplier invoices are currently in process of a workflow? What is the current workflow status of a supplier invoice? 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 Users who want to use this CDS view must have the following authorization objects assigned: M_RECH_BUK

Structure
Parameters SupplierInvoice (key) used to search for a supplier invoice. FiscalYear (key) used to search a the supplier invoice.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-IV-INT-WF
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select
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 supplier invoice workflow scenarios. It contains data related to the supplier invoices header data and the workflow status.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>Which supplier invoices are currently in process of a workflow? </p></li> <li><p>What is the current workflow status of a supplier invoice?</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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISIWFEMLDL view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK 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
EndUserText.label Supplier Invoice Details for Workflow Deadline Email view

Fields (21)

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 Latest End Time for Work Item
SupplierInvoice _SupplierInvoice SupplierInvoice Document Number of an Invoice Document
FiscalYear _SupplierInvoice FiscalYear G/L Fiscal Year
CompanyCode _SupplierInvoice CompanyCode Receiver Company Code
CompanyCodeName _CompanyCodeText CompanyCodeName Name of Company Code or Company
InvoicingParty _SupplierInvoice InvoicingParty Different Invoicing Party
SupplierName _SupplierText SupplierName Name of Supplier
InvoiceGrossAmount _SupplierInvoice InvoiceGrossAmount Gross Invoice Amount in Document Currency
DocumentCurrency _SupplierInvoice DocumentCurrency Document Currency

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_SuplrInvcWrkflwEmlDeadLine.
-- 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: ISIWFEMLDL

CREATE VIEW I_SuplrInvcWrkflwEmlDeadLine 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,
  _WorkflowTask._TaskDueDate.WorkflowTaskDueUTCDateTime AS WorkflowTaskDueUTCDateTime,
  _SupplierInvoice.SupplierInvoice AS SupplierInvoice,
  _SupplierInvoice.FiscalYear AS FiscalYear,
  _SupplierInvoice.CompanyCode AS CompanyCode,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  _SupplierInvoice.InvoicingParty AS InvoicingParty,
  _SupplierText.SupplierName AS SupplierName,
  _SupplierInvoice.InvoiceGrossAmount AS InvoiceGrossAmount,
  _SupplierInvoice.DocumentCurrency AS DocumentCurrency
FROM I_WorkflowTask AS _WorkflowTask
INNER JOIN I_WorkflowTaskApplObject AS _WorkflowTaskApplObject ON /* join condition not captured in parsed metadata */
;

Learn More