What is C_CntrlPurContrItemHierarchyTP in SAP S/4HANA?

C_CntrlPurContrItemHierarchyTP is a consumption CDS view in SAP S/4HANA. Central Purchase Contract Item Hierarchy It contains 97 fields.

Which tables does C_CntrlPurContrItemHierarchyTP read from?

C_CntrlPurContrItemHierarchyTP reads data from: I_CntrlPurchaseContractItemTP.

What VDM layer is C_CntrlPurContrItemHierarchyTP?

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

C_CntrlPurContrItemHierarchyTP

DDL: C_CNTRLPURCONTRITEMHIERARCHYTP SQL: CCEPUCOITMHIERTP Type: view CONSUMPTION

97 Fields 1 Data Sources 6 Associations

Central Purchase Contract Item Hierarchy

C_CntrlPurContrItemHierarchyTP is a Consumption CDS View that provides data about "Central Purchase Contract Item Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurchaseContractItemTP) and exposes 97 fields with key fields CentralPurchaseContractItem, CentralPurchaseContract. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CntrlPurchaseContractItemTP	I_CntrlPurchaseContractItemTP	from

Associations (6)

Cardinality	Target	Alias	Condition
[1..1]	C_CentralPurchaseContractTP	_CentralPurchaseContractTP	`$projection.CentralPurchaseContract = _CentralPurchaseContractTP.CentralPurchaseContract`
[0..1]	C_MM_MaterialGroupValueHelp	_MaterialGroupValueHelp	`_MaterialGroupValueHelp.MaterialGroup = $projection.MaterialGroup`
[0..1]	I_PurgDocumentItemCategoryText	_PurgDocumentItemCategoryText	`$projection.PurchasingDocumentItemCategory = _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory and _PurgDocumentItemCategoryText.Language = $session.system_language`
[1..1]	C_Mm_ConfirmationControlVH	_ConfirmationControlVH	`$projection.SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey`
[1..1]	I_PurCtrStockType	_PurCtrStockType	`$projection.StockType = _PurCtrStockType.StockType`
[1..*]	I_Purcontracttaxcodevh	_Purcontracttaxcodevh	`$projection.TaxCode = _Purcontracttaxcodevh.TaxCode`

Annotations (22)

Name	Value	Level
AbapCatalog.sqlViewName	CCEPUCOITMHIERTP	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ClientHandling.type	#CLIENT_DEPENDENT	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
Search.searchable	true	view
ObjectModel.query.implementedBy	ABAP:CL_MM_PUR_CCTR_HIER_QUERY	view
EndUserText.label	Central Purchase Contract Item Hierarchy	view
ObjectModel.createEnabled	true	view
ObjectModel.deleteEnabled	false	view
ObjectModel.updateEnabled	true	view
UI.headerInfo.typeName	Central Purchase Contract Item	view
UI.headerInfo.typeNamePlural	Central Purchase Contract Items	view
UI.headerInfo.title.value	CentralPurchaseContractItem	view
UI.headerInfo.title.label	Central Contract Item	view
UI.headerInfo.description.value	CentralPurchaseContractItem	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (97)

Key	Field	Source Table	Source Field	Description
KEY	CentralPurchaseContractItem		CentralPurchaseContractItem	Item in Central Purchase Contract
KEY	CentralPurchaseContract		CentralPurchaseContract	Purchasing Doc.
	PurgConfigurableItemNumber		PurgConfigurableItemNumber	Hierarchy Number
	PurchasingCentralMaterial		PurchasingCentralMaterial	Material
	Material		Material	Vehicle Model
	PurchaseContractItemText		PurchaseContractItemText	Short Text
	ContractNetPriceAmount		ContractNetPriceAmount	Net Price
	OrderPriceUnit		OrderPriceUnit	Order Price Un.
	VolumeUnit		VolumeUnit	Volume Unit
	OrderQuantityUnit		OrderQuantityUnit	Sales Unit
	MaterialGroup		MaterialGroup	Product Group
	Customer		Customer	Sold-to Party
	Subcontractor		Subcontractor	Supplier
	ReferenceDeliveryAddressID		ReferenceDeliveryAddressID	Reference Address
	ManualDeliveryAddressID		ManualDeliveryAddressID	Address Number
	Plant		Plant	Valuation Area
	StorageLocation		StorageLocation	StorageLocation
	AccountAssignmentCategory		AccountAssignmentCategory	Acct Assgmt Cat
	GoodsReceiptIsExpected		GoodsReceiptIsExpected	Goods Receipt
	NetPriceQuantity		NetPriceQuantity	Price Unit
	MultipleAcctAssgmtDistribution		MultipleAcctAssgmtDistribution	Distribution
	PartialInvoiceDistribution		PartialInvoiceDistribution	Partial invoice
	TargetQuantity		TargetQuantity	Target Quantity
	TargetAmount		TargetAmount	Target Value
	CntrlPurContrItmTargetAmount		CntrlPurContrItmTargetAmount	Item Target Value
	DocumentCurrency		DocumentCurrency	Document Currency
	OrdPriceUnitToOrderUnitDnmntr		OrdPriceUnitToOrderUnitDnmntr	Quantity Conversion Denominator
	OrderPriceUnitToOrderUnitNmrtr		OrderPriceUnitToOrderUnitNmrtr	Quantity Conversion Numerator
	PurchasingDocumentTypeName	_CentralPurchaseContractTP	PurchasingDocumentTypeName	Description
	PurchaseContractType	_CentralPurchaseContractTP	PurchaseContractType	Order Type
	PurchasingDocumentItemCategory		PurchasingDocumentItemCategory	Item Category
	PurgDocItemCategoryName	_PurgDocumentItemCategoryText	PurgDocItemCategoryName	Text for ItCat.
	SupplierMaterialNumber		SupplierMaterialNumber	Supp. Mat. No.
	EvaldRcptSettlmtIsAllowed		EvaldRcptSettlmtIsAllowed	ERS
	UnderdelivTolrtdLmtRatioInPct		UnderdelivTolrtdLmtRatioInPct	Underdel. Tol.
	PriceIsToBePrinted		PriceIsToBePrinted	Print Price
	SupplierConfirmationControlKey		SupplierConfirmationControlKey	Conf. Control
	OverdelivTolrtdLmtRatioInPct		OverdelivTolrtdLmtRatioInPct	Overdeliv. Tol.
	UnlimitedOverdeliveryIsAllowed		UnlimitedOverdeliveryIsAllowed	Unlimited Tol.
	InvoiceIsExpected		InvoiceIsExpected	Invoice Receipt
	InvoiceIsGoodsReceiptBased		InvoiceIsGoodsReceiptBased	GR-Based IV
	PurgDocPriceDate		PurgDocPriceDate	Price Date
	IsInfoRecordUpdated		IsInfoRecordUpdated	InfoUpdate
	PurgDocReleaseOrderQuantity		PurgDocReleaseOrderQuantity	Stand. Rel. Order. Qty
	PurgDocOrderAcknNumber		PurgDocOrderAcknNumber	Order Acknowl.
	PurgDocEstimatedPrice		PurgDocEstimatedPrice	Estimated Price
	IsInfoAtRegistration		IsInfoAtRegistration	Info at Registration
	NoDaysReminder1		NoDaysReminder1	1st Rem./Exped.
	NoDaysReminder2		NoDaysReminder2	2nd Rem./Exped.
	NoDaysReminder3		NoDaysReminder3	3rd Rem./Exped.
	PlannedDeliveryDurationInDays		PlannedDeliveryDurationInDays	Plnd dely time
	StockType		StockType	Stock Type
	TaxCode		TaxCode	Tax Code
	RequirementTracking		RequirementTracking	Tracking Number
	IsOrderAcknRqd		IsOrderAcknRqd	Acknowl. Reqd.
	ShippingInstruction		ShippingInstruction	Shipping Instr.
	GoodsReceiptIsNonValuated		GoodsReceiptIsNonValuated	GR Non-Valuated
	ServicePerformer		ServicePerformer	Service Performer
	ProductType		ProductType	Product Type Group
	MaterialType		MaterialType	Material Type
	FormattedPurchaseContractItem		FormattedPurchaseContractItem	Contract / Item No.
	PurchaseRequisition		PurchaseRequisition	Requisition
	PurchaseRequisitionItem		PurchaseRequisitionItem	Requisn. item
	PurchasingContractDeletionCode		PurchasingContractDeletionCode	Del. Indicator
	TextIsDeleted		TextIsDeleted	Deleted
	OutlineAgrmtItmBlockedText		OutlineAgrmtItmBlockedText	Boolean Variable (X = True, - = False, Space = Unknown)
	PurgDocItmBlkRsnCode		PurgDocItmBlkRsnCode	Block Reason ID
	PurgDocItmBlkRsnDesc	_PurgDocItmBlkRsnCodesVH	PurgDocItmBlkRsnDesc
	PurgDocItemRenegotiationStatus		PurgDocItemRenegotiationStatus	Renegotiation Status
	PurgDocItmRenegotiationStsDesc	_PurgDocItemRenegttnStsText	PurgDocItmRenegotiationStsDesc
	ProcmtHubRefcdConnectedSystem		ProcmtHubRefcdConnectedSystem	Source Connected Sys
	IsEndOfPurposeBlocked		IsEndOfPurposeBlocked	Busin. Purp. Cmpltd.
	PurchasingDocumentItemUniqueID		PurchasingDocumentItemUniqueID	Document Item
	CntrlPurContrGRConsumptionPct		CntrlPurContrGRConsumptionPct
	ReleaseOrderItemQuantityUnit		ReleaseOrderItemQuantityUnit	Release Order Quantity Unit
	CntrlPurContractGRQuantity		CntrlPurContractGRQuantity	Central Contract GR Quantity
	ReleaseOrderCurrency		ReleaseOrderCurrency	Release Order Currency
	CntrlPurContractGRAmount		CntrlPurContractGRAmount	Central Contract GR Amount
	PurchasingParentItem		PurchasingParentItem	Parent Item No
	IsStatisticalItem		IsStatisticalItem	Statisticl.Indicator
	HierarchyNode		HierarchyNode	Node
	HierarchyParentNode		HierarchyParentNode	Hier.node
	HierarchyLevel		HierarchyLevel	Hierarchy Level
	HierarchyNodeSubTreeSize		HierarchyNodeSubTreeSize	Descendant Count
	HierarchyDrillState			Drill State
	HierarchyNodeOrdinalNumber		HierarchyNodeOrdinalNumber	Node Number
	IsOutline		IsOutline	Item Set
	PurgExternalSortNumber		PurgExternalSortNumber	External Sort No.
	_CentralPurchaseContractTP		_CentralPurchaseContractTP
	_DocumentCurrency		_DocumentCurrency
	_ManualDeliveryAddress		_ManualDeliveryAddress
	_PurgDocumentItemCategory		_PurgDocumentItemCategory
	_StorageLocation		_StorageLocation
	_MaterialGroupValueHelp		_MaterialGroupValueHelp
	_ConfirmationControlVH		_ConfirmationControlVH
	_PurCtrStockType		_PurCtrStockType
	_Purcontracttaxcodevh		_Purcontracttaxcodevh

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_CntrlPurContrItemHierarchyTP.
-- 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: CCEPUCOITMHIERTP

CREATE VIEW C_CntrlPurContrItemHierarchyTP AS
SELECT
  CentralPurchaseContractItem,
  CentralPurchaseContract,
  PurgConfigurableItemNumber,
  PurchasingCentralMaterial,
  Material,
  PurchaseContractItemText,
  ContractNetPriceAmount,
  OrderPriceUnit,
  VolumeUnit,
  OrderQuantityUnit,
  MaterialGroup,
  Customer,
  Subcontractor,
  ReferenceDeliveryAddressID,
  ManualDeliveryAddressID,
  Plant,
  StorageLocation,
  AccountAssignmentCategory,
  GoodsReceiptIsExpected,
  NetPriceQuantity,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  TargetQuantity,
  TargetAmount,
  CntrlPurContrItmTargetAmount,
  DocumentCurrency,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  _CentralPurchaseContractTP.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _CentralPurchaseContractTP.PurchaseContractType AS PurchaseContractType,
  PurchasingDocumentItemCategory,
  _PurgDocumentItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  SupplierMaterialNumber,
  EvaldRcptSettlmtIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  PriceIsToBePrinted,
  SupplierConfirmationControlKey,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  PurgDocPriceDate,
  IsInfoRecordUpdated,
  PurgDocReleaseOrderQuantity,
  PurgDocOrderAcknNumber,
  PurgDocEstimatedPrice,
  IsInfoAtRegistration,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  PlannedDeliveryDurationInDays,
  StockType,
  TaxCode,
  RequirementTracking,
  IsOrderAcknRqd,
  ShippingInstruction,
  GoodsReceiptIsNonValuated,
  ServicePerformer,
  ProductType,
  MaterialType,
  FormattedPurchaseContractItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchasingContractDeletionCode,
  TextIsDeleted,
  OutlineAgrmtItmBlockedText,
  PurgDocItmBlkRsnCode,
  _PurgDocItmBlkRsnCodesVH.PurgDocItmBlkRsnDesc AS PurgDocItmBlkRsnDesc,
  PurgDocItemRenegotiationStatus,
  _PurgDocItemRenegttnStsText.PurgDocItmRenegotiationStsDesc AS PurgDocItmRenegotiationStsDesc,
  ProcmtHubRefcdConnectedSystem,
  IsEndOfPurposeBlocked,
  PurchasingDocumentItemUniqueID,
  CntrlPurContrGRConsumptionPct,
  ReleaseOrderItemQuantityUnit,
  CntrlPurContractGRQuantity,
  ReleaseOrderCurrency,
  CntrlPurContractGRAmount,
  PurchasingParentItem,
  IsStatisticalItem,
  HierarchyNode,
  HierarchyParentNode,
  HierarchyLevel,
  HierarchyNodeSubTreeSize,
  cast( HierarchyDrillState as abap.char( 22 ) ) AS HierarchyDrillState,
  HierarchyNodeOrdinalNumber,
  IsOutline,
  PurgExternalSortNumber
FROM I_CntrlPurchaseContractItemTP
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON CentralPurchaseContract = _CentralPurchaseContractTP.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurgDocumentItemCategoryText ON PurchasingDocumentItemCategory = _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory AND _PurgDocumentItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_Mm_ConfirmationControlVH AS _ConfirmationControlVH ON SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey  -- association [1..1]
LEFT OUTER JOIN I_PurCtrStockType AS _PurCtrStockType ON StockType = _PurCtrStockType.StockType  -- association [1..1]
LEFT OUTER JOIN I_Purcontracttaxcodevh AS _Purcontracttaxcodevh ON TaxCode = _Purcontracttaxcodevh.TaxCode  -- association [1..*]
;

Depth:

C_CntrlPurContrItemHierarchyTP view

I_CntrlPurchaseContractItemTP view