What is P_PDRELATION in SAP S/4HANA?

P_PDRELATION is a basic CDS view in SAP S/4HANA. PD Relation It contains 10 fields.

Which tables does P_PDRELATION read from?

P_PDRELATION reads data from: hrp1001, t77s0.

What VDM layer is P_PDRELATION?

P_PDRELATION is classified as a Basic (interface) view providing a 1:1 representation of a database table.

P_PDRELATION

DDL: P_PDRELATION SQL: PPDRELATION Type: view BASIC Package: VDM_SHCM_EMPLOYEE

10 Fields 2 Data Sources

PD Relation

P_PDRELATION is a Basic CDS View that provides data about "PD Relation" in SAP S/4HANA. It reads from 2 data sources (hrp1001, t77s0) and exposes 10 fields with key fields PlanVersion, ObjectType, ObjectID, RelationShipDirection, ReleationShip. Part of development package VDM_SHCM_EMPLOYEE.

Data Sources (2)

Source	Alias	Join Type
hrp1001	relation	from
t77s0	systemtable	inner

Annotations (3)

Name	Value	Level
VDM.private	true	view
AbapCatalog.sqlViewName	PPDRELATION	view
VDM.viewType	#BASIC	view

Fields (10)

Key	Field	Source Table	Source Field	Description
KEY	PlanVersion	hrp1001	plvar	Plan version
KEY	ObjectType	hrp1001	otype	Type of Val.
KEY	ObjectID	hrp1001	objid	Work Center
KEY	RelationShipDirection	hrp1001	rsign	Relationship
KEY	ReleationShip	hrp1001	relat	Relnship
	RelationStatus	hrp1001	istat	System status
	StartDate	hrp1001	begda	Valid From
	EndDate	hrp1001	endda	Valid To
	RelatedObjectType	hrp1001	sclas	Rel.obj.type
	RelatedObjectID	hrp1001	sobid	ID rel.object

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_PDRELATION.
-- 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: PPDRELATION

CREATE VIEW P_PDRELATION AS
SELECT
  relation.plvar AS PlanVersion,
  relation.otype AS ObjectType,
  relation.objid AS ObjectID,
  relation.rsign AS RelationShipDirection,
  relation.relat AS ReleationShip,
  relation.istat AS RelationStatus,
  relation.begda AS StartDate,
  relation.endda AS EndDate,
  relation.sclas AS RelatedObjectType,
  relation.sobid AS RelatedObjectID
FROM hrp1001 AS relation
INNER JOIN t77s0 AS systemtable ON /* join condition not captured in parsed metadata */
;

Depth:

P_PDRELATION view