C_PurReqnHdrWrkflwDeadlineEml

DDL: C_PURREQNHDRWRKFLWDEADLINEEML SQL: CPURREQHWFDLEML Type: view CONSUMPTION
21 Fields 1 Data Sources 2 Associations

PurchaseRequsition HDR Wrkflw deadline email notif

C_PurReqnHdrWrkflwDeadlineEml is a Consumption CDS View that provides data about "PurchaseRequsition HDR Wrkflw deadline email notif" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 21 fields with key field WorkflowTaskInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_WorkflowTaskURL _WorkflowTaskURL $projection.WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID
[0..1] P_PurReqnFacts2 _PurReqnFacts2 _PurReqnFacts2.PurchaseRequisition = _WorkflowTaskApplObject.SAPBusinessObjectNodeKey1

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPURREQHWFDLEML view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PurchaseRequsition HDR Wrkflw deadline 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
AccessControl.personalData.blocking #REQUIRED view

Fields (21)

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
PurReqnWrkflwTskCrtnUTCDate
PurReqnWrkflwTskCrtnUTCTime
PurReqnWrkflwTaskDueUTCDate
PurReqnWrkflwTaskDueUTCTime
WorkflowTaskURL _WorkflowTaskURL WorkflowTaskURL

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_PurReqnHdrWrkflwDeadlineEml.
-- 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: CPURREQHWFDLEML

CREATE VIEW C_PurReqnHdrWrkflwDeadlineEml 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,
  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
FROM I_WorkflowTask AS _Workflowtask
LEFT OUTER JOIN I_WorkflowTaskURL AS _WorkflowTaskURL ON WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID  -- association [0..1]
LEFT OUTER JOIN P_PurReqnFacts2 AS _PurReqnFacts2 ON _PurReqnFacts2.PurchaseRequisition = _WorkflowTaskApplObject.SAPBusinessObjectNodeKey1  -- association [0..1]
;

Learn More