C_PrmtHbRpldPurReqnItmAprvEml

DDL: C_PRMTHBRPLDPURREQNITMAPRVEML SQL: CPURRQNITAPREML Type: view CONSUMPTION
14 Fields 2 Data Sources

Purchase Requisition Itm Details for WF Approval Email

C_PrmtHbRpldPurReqnItmAprvEml (Consumption)

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

Sourcing & Procurement

C_PrmtHbRpldPurReqnItmAprvEml is a Consumption CDS View that provides data about "Purchase Requisition Itm Details for WF Approval Email" in SAP S/4HANA. It reads from 2 data sources (I_WorkflowTask, I_WorkflowTaskApplObject) and exposes 14 fields with key field WorkflowTaskInternalID.

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-HUB-PR
CapabilitiesOutput: Email Data Provider
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from
I_WorkflowTaskApplObject _WorkflowTaskApplObject inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPURRQNITAPREML view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Purchase Requisition Itm Details for WF Approval Email view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.supportedCapabilities #OUTPUT_EMAIL_DATA_PROVIDER view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID Work Item ID
ProcmtHubPurchaseRequisition _PurchaseRequisitionItem ProcmtHubPurchaseRequisition Purchase Requisition Number
ProcmtHubPurRequisitionItem _PurchaseRequisitionItem ProcmtHubPurRequisitionItem Item number of purchase requisition
ProcmtHubPurRequisitionType _PurchaseRequisitionItem ProcmtHubPurRequisitionType Purchase Requisition Document Type
ProcurementHubSourceSystem _PurchaseRequisitionItem ProcurementHubSourceSystem Connected System ID
PrmtHbWrkflwTskCrtnUTCDte Latest Start Date for Work Item
PrmtHbWrkflwTskCrtnUTCTme Latest start time for work item
PrmtHbWrkflwTskDuUTCDte Latest End Date for Work Item
PrmtHbWrkflwTskDuUTCTme Latest end time for work item
ProcmtHubSupplier _PurchaseRequisitionItem ProcmtHubSupplier Desired Vendor
CreatedByUserDescription _User UserDescription User Description
SupplierName _Supplier SupplierName Name of Supplier
WorkflowTaskResultReason Workflow: Decision Reason ID
WorkflowTaskResultReasonText Flexible Workflow: Decision Reason Text

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_PrmtHbRpldPurReqnItmAprvEml.
-- 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: CPURRQNITAPREML

CREATE VIEW C_PrmtHbRpldPurReqnItmAprvEml AS
SELECT
  _Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _PurchaseRequisitionItem.ProcmtHubPurchaseRequisition AS ProcmtHubPurchaseRequisition,
  _PurchaseRequisitionItem.ProcmtHubPurRequisitionItem AS ProcmtHubPurRequisitionItem,
  _PurchaseRequisitionItem.ProcmtHubPurRequisitionType AS ProcmtHubPurRequisitionType,
  _PurchaseRequisitionItem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  cast(tstmp_to_dats( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) AS PrmtHbWrkflwTskCrtnUTCDte,
  cast(tstmp_to_tims( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) AS PrmtHbWrkflwTskCrtnUTCTme,
  cast(tstmp_to_dats( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_led ) AS PrmtHbWrkflwTskDuUTCDte,
  cast(tstmp_to_tims( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_let ) AS PrmtHbWrkflwTskDuUTCTme,
  _PurchaseRequisitionItem.ProcmtHubSupplier AS ProcmtHubSupplier,
  _User.UserDescription AS CreatedByUserDescription,
  _Supplier.SupplierName AS SupplierName,
  _Workflowtask._WorkflowTaskResult._WorkflowTaskResultReason._WorkflowTaskResultReasonText[1:Language=$session.system_language].WorkflowTaskResultReason AS WorkflowTaskResultReason,
  _Workflowtask._WorkflowTaskResult._WorkflowTaskResultReason._WorkflowTaskResultReasonText[1:Language=$session.system_language].WorkflowTaskResultReasonText AS WorkflowTaskResultReasonText
FROM I_WorkflowTask AS _Workflowtask
INNER JOIN I_WorkflowTaskApplObject AS _WorkflowTaskApplObject ON /* join condition not captured in parsed metadata */
;

Learn More