What is P_PurchaseOrderStatus in SAP S/4HANA?

P_PurchaseOrderStatus is a consumption CDS view in SAP S/4HANA. Status logic for PO It contains 6 fields.

Which tables does P_PurchaseOrderStatus read from?

P_PurchaseOrderStatus reads data from: I_PurchaseOrderStatus.

What VDM layer is P_PurchaseOrderStatus?

P_PurchaseOrderStatus is classified as a Consumption view optimized for specific business scenarios and reporting.

P_PurchaseOrderStatus

DDL: P_PURCHASEORDERSTATUS SQL: PPOORDSTAT Type: view CONSUMPTION

6 Fields 1 Data Sources 1 Associations

Status logic for PO

P_PurchaseOrderStatus is a Consumption CDS View that provides data about "Status logic for PO" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderStatus) and exposes 6 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_PurchaseOrderStatus	I_PurchaseOrderStatus	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_PurchaseOrderItem	_PurchaseOrderItem	`$projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	PPOORDSTAT	view
EndUserText.label	Status logic for PO	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
VDM.private	true	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	P_purgdocconf	view

Fields (6)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseOrder		PurchaseOrder	Purchasing Document
KEY	PurchaseOrderItem	_PurchaseOrderItem	PurchaseOrderItem	Purchasing Document Item
	SupplierConfirmationControlKey	_PurchaseOrderItem	SupplierConfirmationControlKey	Conf. Control
	PurchaseOrderType		PurchaseOrderType	PO Type
	PurchasingOrganization		PurchasingOrganization	Purchasing Organization
	PurchasingGroup		PurchasingGroup	Purchasing Group

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 P_PurchaseOrderStatus.
-- 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: PPOORDSTAT

CREATE VIEW P_PurchaseOrderStatus AS
SELECT
  PurchaseOrder,
  _PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  _PurchaseOrderItem.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  PurchaseOrderType,
  PurchasingOrganization,
  PurchasingGroup
FROM I_PurchaseOrderStatus
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
;

Depth:

P_PurchaseOrderStatus view

I_PurchaseOrderStatus view