What is P_PurgDocStatus in SAP S/4HANA?

P_PurgDocStatus is a consumption CDS view in SAP S/4HANA. Purchasing Document Status It contains 4 fields.

Which tables does P_PurgDocStatus read from?

P_PurgDocStatus reads data from: P_PurDocStat.

What VDM layer is P_PurgDocStatus?

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

P_PurgDocStatus

DDL: P_PURGDOCSTATUS SQL: PPURGDOCSTAT Type: view CONSUMPTION

4 Fields 1 Data Sources 1 Associations

Purchasing Document Status

P_PurgDocStatus is a Consumption CDS View that provides data about "Purchasing Document Status" in SAP S/4HANA. It reads from 1 data source (P_PurDocStat) and exposes 4 fields with key fields PurchasingDocument, PurchasingDocumentItem. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
P_PurDocStat	PurDocItemStatus	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_PurchasingDocumentStatus	_PDStatus	`_PDStatus.PurchasingDocumentStatus = PurDocItemStatus.PurchasingDocumentStatus`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	PPURGDOCSTAT	view
VDM.viewType	#CONSUMPTION	view
VDM.private	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
EndUserText.label	Purchasing Document Status	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	I_PurchasingDocumentStatusText	view

Fields (4)

Key	Field	Source Table	Source Field	Description
KEY	PurchasingDocument	P_PurDocStat	PurchasingDocument	Purchasing Document
KEY	PurchasingDocumentItem	P_PurDocStat	PurchasingDocumentItem	Purchasing Doc. Item
	PurchasingDocumentStatus	P_PurDocStat	PurchasingDocumentStatus	Short Description
	PurchasingDocumentStatusName

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_PurgDocStatus.
-- 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: PPURGDOCSTAT

CREATE VIEW P_PurgDocStatus AS
SELECT
  PurDocItemStatus.PurchasingDocument AS PurchasingDocument,
  PurDocItemStatus.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurDocItemStatus.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  _PDStatus._Text[1: Language = $session.system_language].PurchasingDocumentStatusName AS PurchasingDocumentStatusName
FROM P_PurDocStat AS PurDocItemStatus
LEFT OUTER JOIN I_PurchasingDocumentStatus AS _PDStatus ON _PDStatus.PurchasingDocumentStatus = PurDocItemStatus.PurchasingDocumentStatus  -- association [1..1]
;

Depth:

P_PurgDocStatus view

P_PurDocStat view