C_PurReqnHdrWrkflwApprvlEml

DDL: C_PURREQNHDRWRKFLWAPPRVLEML SQL: CPURREQHDRWFEML Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Purchase Requsition Header Workflow email notific

C_PurReqnHdrWrkflwApprvlEml is a Consumption CDS View that provides data about "Purchase Requsition Header Workflow email notific" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 18 fields with key field WorkflowTaskInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_PurReqnFacts1 _PurReqnFacts2 _PurReqnFacts2.PurchaseRequisition = _WorkflowTaskApplObject.SAPBusinessObjectNodeKey1

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPURREQHDRWFEML view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Requsition Header Workflow email notific 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
AccessControl.personalData.blocking #REQUIRED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID Work Item ID
PurchaseRequisition _PurchaseRequisitionItem PurchaseRequisition Requisition
PurReqnReleaseStatus _PurchaseRequisitionItem PurReqnReleaseStatus Proc.state
PurchaseRequisitionType _PurchaseRequisitionItem PurchaseRequisitionType Order Type
PurchaseRequisitionItemText _PurchaseRequisitionItem PurchaseRequisitionItemText Short Text
PurchasingDocumentCategory _PurchaseRequisitionItem PurchasingDocumentCategory Doc. Category
PurchasingOrganization _PurchaseRequisitionItem PurchasingOrganization Purchasing Organization
PurchasingGroup _PurchaseRequisitionItem PurchasingGroup Purchasing Group
Plant _PurchaseRequisitionItem Plant Valuation Area
CreationDate _PurchaseRequisitionItem CreationDate Time Stamp
RequisitionerNameendasRequisitionerName
CreatedByUser _PurchaseRequisitionItem CreatedByUser User Name
PurReqCreationDate _PurchaseRequisitionItem PurReqCreationDate Requisn Date
PurReqnTotalAmountInDspCrcy _PurReqnFacts2 PurReqnTotalAmountInDspCrcy
DisplayCurrency _PurReqnFacts2 DisplayCurrency Display Currency
NumberOfItems _PurReqnFacts2 NumberOfItems
WorkflowTaskResultReason
WorkflowTaskResultReasonText

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_PurReqnHdrWrkflwApprvlEml.
-- 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: CPURREQHDRWFEML

CREATE VIEW C_PurReqnHdrWrkflwApprvlEml AS
SELECT
  _Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _PurchaseRequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseRequisitionItem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _PurchaseRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  _PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _PurchaseRequisitionItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchaseRequisitionItem.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseRequisitionItem.PurchasingGroup AS PurchasingGroup,
  _PurchaseRequisitionItem.Plant AS Plant,
  _PurchaseRequisitionItem.CreationDate AS CreationDate,
  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,
  _PurReqnFacts2.PurReqnTotalAmountInDspCrcy AS PurReqnTotalAmountInDspCrcy,
  _PurReqnFacts2.DisplayCurrency AS DisplayCurrency,
  _PurReqnFacts2.NumberOfItems AS NumberOfItems,
  _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
LEFT OUTER JOIN P_PurReqnFacts1 AS _PurReqnFacts2 ON _PurReqnFacts2.PurchaseRequisition = _WorkflowTaskApplObject.SAPBusinessObjectNodeKey1  -- association [0..1]
;

Learn More