C_PurReqnItmWrkflwDeadlineEml
Purchase Requsition Workflow deadline email notification
C_PurReqnItmWrkflwDeadlineEml is a Consumption CDS View that provides data about "Purchase Requsition Workflow deadline email notification" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 85 fields with key field WorkflowTaskInternalID. It has 1 association to related views.
SAP Help Documentation
| Category | CDS Views for Purchase Requisitions |
|---|---|
| Status | Purchase Requisition Release Status |
Purpose
This CDS view is intended to provide data to send an automated email notification when a workflow deadline is reached for a Purchase Requisition (PR) item.
Prerequisites
Users who want to use this CDS view must have the following authorization objects assigned: M_BANF_BSA PurchaseRequisitionType in Purchase Order M_BANF_WRK Plant in Purchase Order M_BANF_EKO Purchasing Organization in Purchase Order M_BANF_EKG Purchasing Group in Purchase Order
Structure
Business Objects This view is built on the Purchase Requisition business object. Important Fields Important fields in this view include the following: Field Name Description WorkflowTaskInternalID Workflow Task Internal ID PurchaseRequisition Purchase Requisition Number PurchaseRequisitionItem Purchase Requisition Item Number PurchaseReqnItemUniqueID Purchase Requisition Item Unique ID PurchasingDocument Purchasing Document Number PurchasingDocumentItem Purchasing Document Item Number PurReqnReleaseStatus Purchase Requisition Release Status PurchaseRequisitionType Purchase Requisition Type PurReqnWrkflwTskCrtnUTCTime Purchase requisition work flow task creation time
This CDS view is intended to provide data to send an automated email notification when a workflow deadline is reached for a Purchase Requisition (PR) item.
Prerequisites
Users who want to use this CDS view must have the following authorization objects assigned: M_BANF_BSA PurchaseRequisitionType in Purchase Order M_BANF_WRK Plant in Purchase Order M_BANF_EKO Purchasing Organization in Purchase Order M_BANF_EKG Purchasing Group in Purchase Order
Structure
Business Objects This view is built on the Purchase Requisition business object. Important Fields Important fields in this view include the following: Field Name Description WorkflowTaskInternalID Workflow Task Internal ID PurchaseRequisition Purchase Requisition Number PurchaseRequisitionItem Purchase Requisition Item Number PurchaseReqnItemUniqueID Purchase Requisition Item Unique ID PurchasingDocument Purchasing Document Number PurchasingDocumentItem Purchasing Document Item Number PurReqnReleaseStatus Purchase Requisition Release Status PurchaseRequisitionType Purchase Requisition Type PurReqnWrkflwTskCrtnUTCTime Purchase requisition work flow task creation time
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_WorkflowTask | _Workflowtask | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_WorkflowTaskURL | _WorkflowTaskURL | $projection.WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CMMPURREQWFLEML | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Purchase Requsition Workflow deadline email notification | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.supportedCapabilities | #OUTPUT_EMAIL_DATA_PROVIDER | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (85)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | WorkflowTaskInternalID | I_WorkflowTask | WorkflowTaskInternalID | Work Item ID |
| PurchaseRequisition | _PurchaseRequisitionItem | PurchaseRequisition | Requisition | |
| PurchaseRequisitionItem | _PurchaseRequisitionItem | PurchaseRequisitionItem | Requisn. item | |
| PurchaseReqnItemUniqueID | _PurchaseRequisitionItem | PurchaseReqnItemUniqueID | Purch. Doc. ID | |
| PurchasingDocument | _PurchaseRequisitionItem | PurchasingDocument | Purchasing Document | |
| PurchasingDocumentItem | _PurchaseRequisitionItem | PurchasingDocumentItem | Purchasing Doc. Item | |
| PurReqnReleaseStatus | _PurchaseRequisitionItem | PurReqnReleaseStatus | Proc.state | |
| PurchaseRequisitionType | _PurchaseRequisitionItem | PurchaseRequisitionType | Order Type | |
| PurchasingDocumentSubtype | _PurchaseRequisitionItem | PurchasingDocumentSubtype | Control | |
| PurchasingDocumentItemCategory | _PurchaseRequisitionItem | PurchasingDocumentItemCategory | Item Category | |
| PurchaseRequisitionItemText | _PurchaseRequisitionItem | PurchaseRequisitionItemText | Short Text | |
| AccountAssignmentCategory | _PurchaseRequisitionItem | AccountAssignmentCategory | Acct Assgmt Cat | |
| Material | _PurchaseRequisitionItem | Material | Vehicle Model | |
| MaterialGroup | _PurchaseRequisitionItem | MaterialGroup | Product Group | |
| PurchasingDocumentCategory | _PurchaseRequisitionItem | PurchasingDocumentCategory | Doc. Category | |
| RequestedQuantity | _PurchaseRequisitionItem | RequestedQuantity | Requested Quantity | |
| BaseUnit | _PurchaseRequisitionItem | BaseUnit | Unit of Measure | |
| PurchaseRequisitionPrice | _PurchaseRequisitionItem | PurchaseRequisitionPrice | Valuation Price | |
| PurReqnPriceQuantity | _PurchaseRequisitionItem | PurReqnPriceQuantity | Price unit | |
| MaterialGoodsReceiptDuration | _PurchaseRequisitionItem | MaterialGoodsReceiptDuration | GR proc. time | |
| PurchaseRequisitionReleaseDate | _PurchaseRequisitionItem | PurchaseRequisitionReleaseDate | Release Date | |
| PurchasingOrganization | _PurchaseRequisitionItem | PurchasingOrganization | Purchasing Organization | |
| PurchasingGroup | _PurchaseRequisitionItem | PurchasingGroup | Purchasing Group | |
| Plant | _PurchaseRequisitionItem | Plant | Valuation Area | |
| SourceOfSupplyIsAssigned | _PurchaseRequisitionItem | SourceOfSupplyIsAssigned | Assigned | |
| SupplyingPlant | _PurchaseRequisitionItem | SupplyingPlant | Supplying Plant | |
| OrderedQuantity | _PurchaseRequisitionItem | OrderedQuantity | Quantity | |
| PurReqnLimitConsumptionAmt | _PurchaseRequisitionItem | PurReqnLimitConsumptionAmt | Consumption Value | |
| DeliveryDate | _PurchaseRequisitionItem | DeliveryDate | Delivery Date | |
| CreationDate | _PurchaseRequisitionItem | CreationDate | Time Stamp | |
| ProcessingStatus | _PurchaseRequisitionItem | ProcessingStatus | Worklist Status | |
| PurchasingInfoRecord | _PurchaseRequisitionItem | PurchasingInfoRecord | Info Record | |
| Supplier | _PurchaseRequisitionItem | Supplier | Supplier | |
| FixedSupplier | _PurchaseRequisitionItem | FixedSupplier | Fixed Vendor | |
| RequisitionerNameendasRequisitionerName | ||||
| CreatedByUser | _PurchaseRequisitionItem | CreatedByUser | User Name | |
| PurReqCreationDate | _PurchaseRequisitionItem | PurReqCreationDate | Requisn Date | |
| DeliveryAddressID | _PurchaseRequisitionItem | DeliveryAddressID | Address | |
| ManualDeliveryAddressID | _PurchaseRequisitionItem | ManualDeliveryAddressID | Address Number | |
| PurReqnItemCurrency | _PurchaseRequisitionItem | PurReqnItemCurrency | Currency | |
| MaterialPlannedDeliveryDurn | _PurchaseRequisitionItem | MaterialPlannedDeliveryDurn | Pl. Deliv. Time | |
| DelivDateCategory | _PurchaseRequisitionItem | DelivDateCategory | Delivery Date | |
| MultipleAcctAssgmtDistribution | _PurchaseRequisitionItem | MultipleAcctAssgmtDistribution | Distribution | |
| StorageLocation | _PurchaseRequisitionItem | StorageLocation | StorageLocation | |
| PurReqnSSPRequestor | _PurchaseRequisitionItem | PurReqnSSPRequestor | Requestor | |
| PurReqnSSPAuthor | _PurchaseRequisitionItem | PurReqnSSPAuthor | Author | |
| PurchaseContract | _PurchaseRequisitionItem | PurchaseContract | Purchasing Doc. | |
| PurReqnSourceOfSupplyType | _PurchaseRequisitionItem | PurReqnSourceOfSupplyType | Doc. Category | |
| PurchaseContractItem | _PurchaseRequisitionItem | PurchaseContractItem | Item | |
| ConsumptionPosting | _PurchaseRequisitionItem | ConsumptionPosting | Consumption Posting | |
| PurReqnOrigin | _PurchaseRequisitionItem | PurReqnOrigin | Creation ind. | |
| PurReqnSSPCatalog | _PurchaseRequisitionItem | PurReqnSSPCatalog | Web Service ID | |
| PurReqnSSPCatalogItem | _PurchaseRequisitionItem | PurReqnSSPCatalogItem | Catalog Item | |
| PurReqnSSPCrossCatalogItem | _PurchaseRequisitionItem | PurReqnSSPCrossCatalogItem | Catalog item key | |
| IsPurReqnBlocked | _PurchaseRequisitionItem | IsPurReqnBlocked | Blocking Ind. | |
| ItemDeliveryAddressID | _PurchaseRequisitionItem | ItemDeliveryAddressID | Address | |
| Language | _PurchaseRequisitionItem | Language | Report Text Language | |
| IsClosed | _PurchaseRequisitionItem | IsClosed | Closed | |
| ReleaseIsNotCompleted | _PurchaseRequisitionItem | ReleaseIsNotCompleted | Subj.to Release | |
| ServicePerformer | _PurchaseRequisitionItem | ServicePerformer | Service Performer | |
| PurchaseRequisitionStatus | _PurchaseRequisitionItem | PurchaseRequisitionStatus | Release State | |
| PerformancePeriodStartDate | _PurchaseRequisitionItem | PerformancePeriodStartDate | Start of Performance Period | |
| PerformancePeriodEndDate | _PurchaseRequisitionItem | PerformancePeriodEndDate | End of Performance Period | |
| CompanyCode | _PurchaseRequisitionItem | CompanyCode | Receiver Company Code | |
| SupplierMaterialNumber | _PurchaseRequisitionItem | SupplierMaterialNumber | Supp. Mat. No. | |
| Batch | _PurchaseRequisitionItem | Batch | Lot No. | |
| MinRemainingShelfLife | _PurchaseRequisitionItem | MinRemainingShelfLife | Rem. Shelf Life | |
| ItemNetAmount | _PurchaseRequisitionItem | ItemNetAmount | Tot. val. rel. | |
| GoodsReceiptIsExpected | _PurchaseRequisitionItem | GoodsReceiptIsExpected | Goods Receipt | |
| InvoiceIsExpected | _PurchaseRequisitionItem | InvoiceIsExpected | Invoice Receipt | |
| GoodsReceiptIsNonValuated | _PurchaseRequisitionItem | GoodsReceiptIsNonValuated | GR Non-Valuated | |
| RequirementTracking | _PurchaseRequisitionItem | RequirementTracking | Tracking Number | |
| MRPController | _PurchaseRequisitionItem | MRPController | MRP Controller | |
| PurchaseRequisitionIsFixed | _PurchaseRequisitionItem | PurchaseRequisitionIsFixed | "Fixed" ind. | |
| AddressID | _PurchaseRequisitionItem | AddressID | Ship-to address | |
| LastChangeDateTime | _PurchaseRequisitionItem | LastChangeDateTime | Timestamp | |
| PurReqnWrkflwTskCrtnUTCDate | ||||
| PurReqnWrkflwTskCrtnUTCTime | ||||
| PurReqnWrkflwTaskDueUTCDate | ||||
| PurReqnWrkflwTaskDueUTCTime | ||||
| WorkflowTaskURL | _WorkflowTaskURL | WorkflowTaskURL | ||
| PurchasingOrganizationName | _PurchaseRequisitionItem | PurchasingOrganizationName | Purch. Org. Name | |
| PurchasingGroupName | _PurchaseRequisitionItem | PurchasingGroupName | Purchasing Grp. Name | |
| SupplierName | _PurchaseRequisitionItem | SupplierName | Supplier Name | |
| FixedSupplierName | _PurchaseRequisitionItem | FixedSupplierName | Name of Supplier |
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 C_PurReqnItmWrkflwDeadlineEml.
-- 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: CMMPURREQWFLEML
CREATE VIEW C_PurReqnItmWrkflwDeadlineEml AS
SELECT
_Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
_PurchaseRequisitionItem.PurchaseRequisition AS PurchaseRequisition,
_PurchaseRequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
_PurchaseRequisitionItem.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
_PurchaseRequisitionItem.PurchasingDocument AS PurchasingDocument,
_PurchaseRequisitionItem.PurchasingDocumentItem AS PurchasingDocumentItem,
_PurchaseRequisitionItem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
_PurchaseRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
_PurchaseRequisitionItem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
_PurchaseRequisitionItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
_PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
_PurchaseRequisitionItem.AccountAssignmentCategory AS AccountAssignmentCategory,
_PurchaseRequisitionItem.Material AS Material,
_PurchaseRequisitionItem.MaterialGroup AS MaterialGroup,
_PurchaseRequisitionItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
_PurchaseRequisitionItem.RequestedQuantity AS RequestedQuantity,
_PurchaseRequisitionItem.BaseUnit AS BaseUnit,
_PurchaseRequisitionItem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
_PurchaseRequisitionItem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
_PurchaseRequisitionItem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
_PurchaseRequisitionItem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
_PurchaseRequisitionItem.PurchasingOrganization AS PurchasingOrganization,
_PurchaseRequisitionItem.PurchasingGroup AS PurchasingGroup,
_PurchaseRequisitionItem.Plant AS Plant,
_PurchaseRequisitionItem.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
_PurchaseRequisitionItem.SupplyingPlant AS SupplyingPlant,
_PurchaseRequisitionItem.OrderedQuantity AS OrderedQuantity,
_PurchaseRequisitionItem.PurReqnLimitConsumptionAmt AS PurReqnLimitConsumptionAmt,
_PurchaseRequisitionItem.DeliveryDate AS DeliveryDate,
_PurchaseRequisitionItem.CreationDate AS CreationDate,
_PurchaseRequisitionItem.ProcessingStatus AS ProcessingStatus,
_PurchaseRequisitionItem.PurchasingInfoRecord AS PurchasingInfoRecord,
_PurchaseRequisitionItem.Supplier AS Supplier,
_PurchaseRequisitionItem.FixedSupplier AS FixedSupplier,
case when (_PurchaseRequisitionItem._Employee.EmployeeFullName is not initial) then _PurchaseRequisitionItem._Employee.EmployeeFullName else _PurchaseRequisitionItem.RequisitionerName end as RequisitionerName AS RequisitionerNameendasRequisitionerName,
_PurchaseRequisitionItem.CreatedByUser AS CreatedByUser,
_PurchaseRequisitionItem.PurReqCreationDate AS PurReqCreationDate,
_PurchaseRequisitionItem.DeliveryAddressID AS DeliveryAddressID,
_PurchaseRequisitionItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
_PurchaseRequisitionItem.PurReqnItemCurrency AS PurReqnItemCurrency,
_PurchaseRequisitionItem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
_PurchaseRequisitionItem.DelivDateCategory AS DelivDateCategory,
_PurchaseRequisitionItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
_PurchaseRequisitionItem.StorageLocation AS StorageLocation,
_PurchaseRequisitionItem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
_PurchaseRequisitionItem.PurReqnSSPAuthor AS PurReqnSSPAuthor,
_PurchaseRequisitionItem.PurchaseContract AS PurchaseContract,
_PurchaseRequisitionItem.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
_PurchaseRequisitionItem.PurchaseContractItem AS PurchaseContractItem,
_PurchaseRequisitionItem.ConsumptionPosting AS ConsumptionPosting,
_PurchaseRequisitionItem.PurReqnOrigin AS PurReqnOrigin,
_PurchaseRequisitionItem.PurReqnSSPCatalog AS PurReqnSSPCatalog,
_PurchaseRequisitionItem.PurReqnSSPCatalogItem AS PurReqnSSPCatalogItem,
_PurchaseRequisitionItem.PurReqnSSPCrossCatalogItem AS PurReqnSSPCrossCatalogItem,
_PurchaseRequisitionItem.IsPurReqnBlocked AS IsPurReqnBlocked,
_PurchaseRequisitionItem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
_PurchaseRequisitionItem.Language AS Language,
_PurchaseRequisitionItem.IsClosed AS IsClosed,
_PurchaseRequisitionItem.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
_PurchaseRequisitionItem.ServicePerformer AS ServicePerformer,
_PurchaseRequisitionItem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
_PurchaseRequisitionItem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
_PurchaseRequisitionItem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
_PurchaseRequisitionItem.CompanyCode AS CompanyCode,
_PurchaseRequisitionItem.SupplierMaterialNumber AS SupplierMaterialNumber,
_PurchaseRequisitionItem.Batch AS Batch,
_PurchaseRequisitionItem.MinRemainingShelfLife AS MinRemainingShelfLife,
_PurchaseRequisitionItem.ItemNetAmount AS ItemNetAmount,
_PurchaseRequisitionItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
_PurchaseRequisitionItem.InvoiceIsExpected AS InvoiceIsExpected,
_PurchaseRequisitionItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
_PurchaseRequisitionItem.RequirementTracking AS RequirementTracking,
_PurchaseRequisitionItem.MRPController AS MRPController,
_PurchaseRequisitionItem.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
_PurchaseRequisitionItem.AddressID AS AddressID,
_PurchaseRequisitionItem.LastChangeDateTime AS LastChangeDateTime,
cast(tstmp_to_dats( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) AS PurReqnWrkflwTskCrtnUTCDate,
cast(tstmp_to_tims( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) AS PurReqnWrkflwTskCrtnUTCTime,
cast(tstmp_to_dats( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_led ) AS PurReqnWrkflwTaskDueUTCDate,
cast(tstmp_to_tims( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_let ) AS PurReqnWrkflwTaskDueUTCTime,
_WorkflowTaskURL.WorkflowTaskURL AS WorkflowTaskURL,
_PurchaseRequisitionItem.PurchasingOrganizationName AS PurchasingOrganizationName,
_PurchaseRequisitionItem.PurchasingGroupName AS PurchasingGroupName,
_PurchaseRequisitionItem.SupplierName AS SupplierName,
_PurchaseRequisitionItem.FixedSupplierName AS FixedSupplierName
FROM I_WorkflowTask AS _Workflowtask
LEFT OUTER JOIN I_WorkflowTaskURL AS _WorkflowTaskURL ON WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA