What is I_PPS_PurOrdWorkflowDetail in SAP S/4HANA?

I_PPS_PurOrdWorkflowDetail is a composite CDS view in SAP S/4HANA. PPS Purchase Order Workflow details It contains 7 fields.

What VDM layer is I_PPS_PurOrdWorkflowDetail?

I_PPS_PurOrdWorkflowDetail is classified as a Composite view that combines data from multiple basic views.

I_PPS_PurOrdWorkflowDetail

DDL: I_PPS_PURORDWORKFLOWDETAIL Type: view_entity COMPOSITE

7 Fields 2 Associations

PPS Purchase Order Workflow details

I_PPS_PurOrdWorkflowDetail is a Composite CDS View that provides data about "PPS Purchase Order Workflow details" in SAP S/4HANA. It has 2 associations to related views.

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_PPS_PurgOrdDocWrkflwObjIdfr	_PurgDocWrkflwObjIdfr	`_PurgDocWrkflwObjIdfr.TechnicalWrkflwObject = $projection.TechnicalWrkflwObject`
[0..1]	I_PPS_WorkflowExtStatusText	_WorkflowStatusText	`_WorkflowStatusText.WorkflowTaskStatus = $projection.PPSPurgDocApprovalStatus and _WorkflowStatusText.Language = $session.system_language`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	PPS Purchase Order Workflow details	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	false	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view

Fields (7)

Key	Field	Source Table	Source Field	Description
KEY	WorkflowTaskInternalID		WorkflowTaskInternalID	Work Item ID
	PurchasingDocument	_PurgDocWrkflwObjIdfr	PurchasingDocument	Purchasing Document
	TechnicalWrkflwObject		TechnicalWrkflwObject
	TechnicalWrkflwObjectType		TechnicalWrkflwObjectType
	PPSPurgDocApprovalStatus		PPSPurgDocApprovalStatus
	PPSPurgDocApprovalStatusText
	PPSPurgDocApprovalDate		PPSPurgDocApprovalDate

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 I_PPS_PurOrdWorkflowDetail.
-- 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.

CREATE VIEW I_PPS_PurOrdWorkflowDetail AS
SELECT
  WorkflowTaskInternalID,
  _PurgDocWrkflwObjIdfr.PurchasingDocument AS PurchasingDocument,
  TechnicalWrkflwObject,
  TechnicalWrkflwObjectType,
  PPSPurgDocApprovalStatus,
  cast(_WorkflowStatusText.WorkflowTaskStatusDesc as pps_e_wf_approval_status_name ) AS PPSPurgDocApprovalStatusText,
  PPSPurgDocApprovalDate
LEFT OUTER JOIN I_PPS_PurgOrdDocWrkflwObjIdfr AS _PurgDocWrkflwObjIdfr ON _PurgDocWrkflwObjIdfr.TechnicalWrkflwObject = TechnicalWrkflwObject  -- association [0..1]
LEFT OUTER JOIN I_PPS_WorkflowExtStatusText AS _WorkflowStatusText ON _WorkflowStatusText.WorkflowTaskStatus = PPSPurgDocApprovalStatus AND _WorkflowStatusText.Language = $session.system_language  -- association [0..1]
;

Depth:

I_PPS_PurOrdWorkflowDetail view_entity