C_CntrlPurReqnHdrWrkflwAprvEml

DDL: C_CNTRLPURREQNHDRWRKFLWAPRVEML SQL: CTRLPURREQHWFAEM Type: view CONSUMPTION
19 Fields 1 Data Sources 1 Associations

Central PurReq HDR Wrkflw AppEmail Notif

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CTRLPURREQHWFAEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central PurReq HDR Wrkflw AppEmail Notif 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
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view

Fields (19)

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
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_CntrlPurReqnHdrWrkflwAprvEml.
-- 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: CTRLPURREQHWFAEM

CREATE VIEW C_CntrlPurReqnHdrWrkflwAprvEml 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,
  _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_PurReqnFacts2 AS _PurReqnFacts2 ON _PurReqnFacts2.PurchaseRequisition = _WorkflowTaskApplObject.SAPBusinessObjectNodeKey1  -- association [0..1]
;

Learn More