What is C_PurOrdRefPurConItm in SAP S/4HANA?

C_PurOrdRefPurConItm is a consumption CDS view in SAP S/4HANA. Purchase Contract Item It contains 11 fields.

What VDM layer is C_PurOrdRefPurConItm?

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

C_PurOrdRefPurConItm

DDL: C_PURORDREFPURCONITM SQL: CPOREFTOPCON Type: view CONSUMPTION

11 Fields 1 Associations

Purchase Contract Item

C_PurOrdRefPurConItm is a Consumption CDS View that provides data about "Purchase Contract Item" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_PurchasingDocumentTypeText	_PurchasingDocumentTypeText	`$projection.PurchaseContractType = _PurchasingDocumentTypeText.PurchasingDocumentType and $projection.PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory`

Annotations (9)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Purchase Contract Item	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	CPOREFTOPCON	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (11)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseContract	P_AssocPurOrdItmPurConItm	PurchaseContract	Purchasing Doc.
KEY	PurchaseContractItem	P_AssocPurOrdItmPurConItm	PurchaseContractItem	Item
KEY	PurchaseOrder	P_AssocPurOrdItmPurConItm	PurchaseOrder	Purchasing Document
	OrderQuantityUnit		OrderQuantityUnit	Sales Unit
	ReleasedQuantity		ReleasedQuantity
	TargetQuantity		TargetQuantity	Target Quantity
	PurchaseContractType		PurchaseContractType	Order Type
	PurchasingDocumentCategory		PurchasingDocumentCategory	Doc. Category
	Plant		Plant	Valuation Area
	StorageLocation		StorageLocation	StorageLocation
	_PurchasingDocumentTypeText		_PurchasingDocumentTypeText

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_PurOrdRefPurConItm.
-- 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: CPOREFTOPCON

CREATE VIEW C_PurOrdRefPurConItm AS
SELECT
  P_AssocPurOrdItmPurConItm.PurchaseContract AS PurchaseContract,
  P_AssocPurOrdItmPurConItm.PurchaseContractItem AS PurchaseContractItem,
  P_AssocPurOrdItmPurConItm.PurchaseOrder AS PurchaseOrder,
  OrderQuantityUnit,
  ReleasedQuantity,
  TargetQuantity,
  PurchaseContractType,
  PurchasingDocumentCategory,
  Plant,
  StorageLocation
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchaseContractType = _PurchasingDocumentTypeText.PurchasingDocumentType AND PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory  -- association [0..*]
;

Depth:

C_PurOrdRefPurConItm view