C_PurReqnItmWrkflwApprvlEml

DDL: C_PURREQNITMWRKFLWAPPRVLEML SQL: CPURREQITMWFEML Type: view CONSUMPTION
80 Fields 1 Data Sources

Purchase Requsition Item Workflow email notif

C_PurReqnItmWrkflwApprvlEml is a Consumption CDS View that provides data about "Purchase Requsition Item Workflow email notif" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 80 fields with key field WorkflowTaskInternalID.

SAP Help Documentation

CategoryCDS Views for Purchase Requisitions
StatusPurchase Requisition Release Status
Purpose
This CDS view provides purchasing-related workflow data for email notifications and is used to generate workflow approval emails for Purchase Requisition (PR) items. It provides all relevant PR item information needed to create the email content sent to approvers during the workflow.

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 PurchasingOrganization in Purchase Order M_BANF_EKG PurchasingGroup 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 WorkflowTaskResultReason Workflow Task Result Reason WorkflowTaskResultReasonText Workflow Task Result Reason Text

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPURREQITMWFEML view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Requsition Item Workflow email notif 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 (80)

KeyFieldSource TableSource FieldDescription
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
WorkflowTaskResultReason
WorkflowTaskResultReasonText
PurchasingOrganizationName _PurchaseRequisitionItem PurchasingOrganizationName Purch. Org. Name
PurchasingGroupName _PurchaseRequisitionItem PurchasingGroupName Purchasing Grp. Name

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_PurReqnItmWrkflwApprvlEml.
-- 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: CPURREQITMWFEML

CREATE VIEW C_PurReqnItmWrkflwApprvlEml 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,
  _Workflowtask._WorkflowTaskResult._WorkflowTaskResultReason._WorkflowTaskResultReasonText[1:Language=$session.system_language].WorkflowTaskResultReason AS WorkflowTaskResultReason,
  _Workflowtask._WorkflowTaskResult._WorkflowTaskResultReason._WorkflowTaskResultReasonText[1:Language=$session.system_language].WorkflowTaskResultReasonText AS WorkflowTaskResultReasonText,
  _PurchaseRequisitionItem.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchaseRequisitionItem.PurchasingGroupName AS PurchasingGroupName
FROM I_WorkflowTask AS _Workflowtask
;

Learn More