C_CntrlPurReqnHdrWrkflwDdlnEml

DDL: C_CNTRLPURREQNHDRWRKFLWDDLNEML SQL: CTRLPURREQHWFEML Type: view CONSUMPTION
22 Fields 1 Data Sources 2 Associations

Central PurchaseRequisition HDR Wrkflw Deadline Email Notif

C_CntrlPurReqnHdrWrkflwDdlnEml is a Consumption CDS View that provides data about "Central PurchaseRequisition HDR Wrkflw Deadline Email Notif" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 22 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_PurReqnFacts1 _PurReqnFacts2 _PurReqnFacts2.PurchaseRequisition = _WorkflowTaskApplObject.SAPBusinessObjectNodeKey1

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CTRLPURREQHWFEML view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central PurchaseRequisition 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 (22)

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
CreationDate _PurchaseRequisitionItem CreationDate Time Stamp
RequisitionerName _PurchaseRequisitionItem RequisitionerName Requisitioner
CreatedByUser _PurchaseRequisitionItem CreatedByUser User Name
PurReqCreationDate _PurchaseRequisitionItem PurReqCreationDate Requisn Date
ProcurementHubSourceSystem _PurchaseRequisitionItem ProcurementHubSourceSystem Connected System ID
ExtPurgOrgForPurg _PurchaseRequisitionItem ExtPurgOrgForPurg Purch. Organization
ExtCompanyCodeForPurg _PurchaseRequisitionItem ExtCompanyCodeForPurg Company Code
ExtPlantForPurg _PurchaseRequisitionItem ExtPlantForPurg Plant
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_CntrlPurReqnHdrWrkflwDdlnEml.
-- 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: CTRLPURREQHWFEML

CREATE VIEW C_CntrlPurReqnHdrWrkflwDdlnEml 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.CreationDate AS CreationDate,
  _PurchaseRequisitionItem.RequisitionerName AS RequisitionerName,
  _PurchaseRequisitionItem.CreatedByUser AS CreatedByUser,
  _PurchaseRequisitionItem.PurReqCreationDate AS PurReqCreationDate,
  _PurchaseRequisitionItem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _PurchaseRequisitionItem.ExtPurgOrgForPurg AS ExtPurgOrgForPurg,
  _PurchaseRequisitionItem.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  _PurchaseRequisitionItem.ExtPlantForPurg AS ExtPlantForPurg,
  _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_PurReqnFacts1 AS _PurReqnFacts2 ON _PurReqnFacts2.PurchaseRequisition = _WorkflowTaskApplObject.SAPBusinessObjectNodeKey1  -- association [0..1]
;

Learn More