What is C_PPS_PurOrderItemHierarchyTP in SAP S/4HANA?

C_PPS_PurOrderItemHierarchyTP is a consumption CDS view in SAP S/4HANA. Purchase Order Hierarchy Item It contains 147 fields.

Which tables does C_PPS_PurOrderItemHierarchyTP read from?

C_PPS_PurOrderItemHierarchyTP reads data from: R_PPS_PurchaseOrderItemTP.

What VDM layer is C_PPS_PurOrderItemHierarchyTP?

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

C_PPS_PurOrderItemHierarchyTP

DDL: C_PPS_PURORDERITEMHIERARCHYTP Type: view_entity CONSUMPTION

147 Fields 1 Data Sources 7 Associations 1 OData Services

Purchase Order Hierarchy Item

C_PPS_PurOrderItemHierarchyTP is a Consumption CDS View that provides data about "Purchase Order Hierarchy Item" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurchaseOrderItemTP) and exposes 147 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 7 associations to related views. It is exposed through 1 OData service (UI_PPS_PURCHASE_ORDER).

Data Sources (1)

Source	Alias	Join Type
R_PPS_PurchaseOrderItemTP	R_PPS_PurchaseOrderItemTP	projection

Associations (7)

Cardinality	Target	Alias	Condition
[0..1]	C_MM_MaterialGroupValueHelp	_MaterialGroupValueHelp	`_MaterialGroupValueHelp.MaterialGroup = $projection.MaterialGroup`
[0..*]	C_PurOrdSupplierConfirmation	_PurOrdSupplierConfirmation	`_PurOrdSupplierConfirmation.PurchaseOrder = $projection.PurchaseOrder and _PurOrdSupplierConfirmation.PurchaseOrderItem = $projection.PurchaseOrderItem`
[0..*]	C_PurchaseOrderProcessFlow	_PurchaseOrderProcessFlow	`_PurchaseOrderProcessFlow.PurchaseOrder = $projection.PurchaseOrder and _PurchaseOrderProcessFlow.PurchaseOrderItem = $projection.PurchaseOrderItem`
[0..1]	I_SupplierConfControlKey	_SupplierConfControlKey	`_SupplierConfControlKey.SupplierConfirmationControlKey = $projection.SupplierConfirmationControlKey`
[0..1]	C_PPS_PurgDocTolKeyQuickView	_ToleranceKey	`$projection.PPSDeliveryToleranceKey = _ToleranceKey.PPSDeliveryToleranceKey`
[0..*]	C_PPS_PurOrdDocumentHistoryC	_PurchaseOrderDocumentHistory	`$projection.PurchaseOrder = _PurchaseOrderDocumentHistory.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderDocumentHistory.PurchaseOrderItem`
[0..1]	C_MM_PlantValueHelp	_PlantValueHelp	`_PlantValueHelp.Plant = $projection.Plant and _PlantValueHelp.PurchasingOrganization = $projection.purchasingorganization`

Annotations (9)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
EndUserText.label	Purchase Order Hierarchy Item	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.representativeKey	PurchaseOrderItem	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.query.implementedBy	ABAP:CL_PPS_PUR_PO_QC_HIER_ITEMS	view
Metadata.allowExtensions	true	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_PPS_PURCHASE_ORDER	UI_PPS_PURCHASE_ORDER_V2	V2	C1	NOT_RELEASED

Fields (147)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseOrder		PurchaseOrder	Purchasing Document
KEY	PurchaseOrderItem		PurchaseOrderItem	Purchasing Document Item
	Material		Material	Vehicle Model
	Plant		Plant	Valuation Area
	PlantName		PlantName	Plant Name
	OrderQuantity		OrderQuantity	Quantity
	NetPriceAmount		NetPriceAmount	Net Price
	DocumentCurrency		DocumentCurrency	Document Currency
	PurchaseOrderQuantityUnit		PurchaseOrderQuantityUnit	Order Unit
	PurchaseOrderItemCategory		PurchaseOrderItemCategory	Item Category
	PurOrdExternalItemCategory		PurOrdExternalItemCategory	Item Type
	PurOrdItemCategoryName		PurOrdItemCategoryName	Text for ItCat.
	ManufacturerMaterial		ManufacturerMaterial	MPN: Material
	MaterialName		MaterialName	Material Description
	PurchasingDocumentDeletionCode		PurchasingDocumentDeletionCode	Del. Indicator
	IsDeleted		IsDeleted	Deletion Indicator
	IsBlocked		IsBlocked	Blocked
	MaterialGroup		MaterialGroup	Product Group
	MaterialGroupName		MaterialGroupName	prod Grp Desc.
	BatchBySupplier		BatchBySupplier	Supplier Batch
	Batch		Batch	Lot No.
	PurchaseOrderItemText		PurchaseOrderItemText	Short Text
	ProductTypeCode		ProductTypeCode	Product Type Group
	ProductTypeName		ProductTypeName	Description
	CompanyCode		CompanyCode	Receiver Company Code
	StorageLocation		StorageLocation	StorageLocation
	NetPriceQuantity		NetPriceQuantity	Price Unit
	IsCompletelyDelivered		IsCompletelyDelivered	Is completely delivered
	IsFinallyInvoiced		IsFinallyInvoiced	Final Invoice
	LastChangedDate		LastChangedDate	Created On
	PurgConfigurableItemNumber		PurgConfigurableItemNumber	Hierarchy Number
	GoodsReceiptIsExpected		GoodsReceiptIsExpected	Goods Receipt
	InvoiceIsExpected		InvoiceIsExpected	Invoice Receipt
	IsOrderAcknRqd		IsOrderAcknRqd	Acknowl. Reqd.
	InvoiceIsGoodsReceiptBased		InvoiceIsGoodsReceiptBased	GR-Based IV
	PurchaseContractItem		PurchaseContractItem	Item
	PurchaseContract		PurchaseContract	Purchasing Doc.
	PurchaseRequisition		PurchaseRequisition	Requisition
	PurchaseRequisitionItem		PurchaseRequisitionItem	Requisn. item
	EvaldRcptSettlmtIsAllowed		EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement
	ServicePerformer		ServicePerformer	Service Performer
	OrderPriceUnit		OrderPriceUnit	Order Price Un.
	PurchasingParentItem		PurchasingParentItem	Parent Item No
	IncotermsClassification		IncotermsClassification	Incoterms
	IncotermsClassificationName		IncotermsClassificationName	Incoterms Classification Description
	IncotermsLocation1		IncotermsLocation1	Inco. Location1
	IncotermsLocation2		IncotermsLocation2	Inco. Location2
	IntrastatServiceCode		IntrastatServiceCode	Intrastat Srvc. Code
	CommodityCode		CommodityCode	Commodity Code
	SupplierConfirmationControlKey		SupplierConfirmationControlKey	Conf. Control
	PurgDocOrderAcknNumber		PurgDocOrderAcknNumber	Order Acknowl.
	AccountAssignmentCategory		AccountAssignmentCategory	Account Assignment Category
	MultipleAcctAssgmtDistribution		MultipleAcctAssgmtDistribution	Distribution
	MultipleAcctAssgmtDistrName
	PartialInvoiceDistribution		PartialInvoiceDistribution	Partial invoice
	PartialInvoiceDistributionName	_PartialInvoiceIndicator	PartialInvoiceDistributionName
	virtualAcctAssgmtUndistributedQtymenge_d			Undistributed Quantity
	virtualAcctAssgmtUndistributedAmtbwert			Undistributed Amount
	virtualAcctAssgmtUndistributedPctvproz			Undistributed Percentage
	virtualUICT_AcctAssgmtUndistriQtyboolean
	virtualUICT_AcctAssgmtUndistriAmtboolean
	virtualUICT_PartInvcDistributionboolean
	virtualUICT_AcctAssgmtUndistriPctboolean
	PurchasingInfoRecord		PurchasingInfoRecord	Info Record
	SupplierMaterialNumber		SupplierMaterialNumber	Supplier Material Number
	PPSSmartNumberHeader		PPSSmartNumberHeader	Smart Number
	NetAmount		NetAmount	Stated Amount
	GoodsReceiptIsNonValuated		GoodsReceiptIsNonValuated	GR Non-Valuated
	TaxCalculationProcedure		TaxCalculationProcedure	Tax Procedure
	TaxCode		TaxCode	Tax Code
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	TaxCountry		TaxCountry	Tax Ctry/Reg.
	TaxDeterminationDate		TaxDeterminationDate	Tx Determination Dte
	ShippingInstruction		ShippingInstruction	Shipping Instr.
	ItemIsRejectedBySupplier		ItemIsRejectedBySupplier	Rejection Ind.
	PurchasingInfoRecordUpdateCode		PurchasingInfoRecordUpdateCode	InfoUpdate
	PurgExternalSortNumber		PurgExternalSortNumber	External Sort No.
	ExpectedOverallLimitAmount		ExpectedOverallLimitAmount	Expected Value
	OverallLimitAmount		OverallLimitAmount	Overall Limit
	PurContractForOverallLimit		PurContractForOverallLimit	Contract For Limit
	Fund		Fund	Sender Fund
	BudgetPeriod		BudgetPeriod	Budget Period
	FundsCenter		FundsCenter	Funds Center
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	GrantID		GrantID	Sender Grant
	EarmarkedFundsDocument		EarmarkedFundsDocument	Earmarked Funds
	EarmarkedFundsDocumentItem		EarmarkedFundsDocumentItem	Document Item
	CostCenter		CostCenter	Cost Center
	GLAccount		GLAccount	General Ledger
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	BR_MaterialOrigin		BR_MaterialOrigin	Material Origin
	BR_MaterialUsage		BR_MaterialUsage	Material Usage
	BR_CFOPCategory		BR_CFOPCategory	Mat. category
	BR_NCM		BR_NCM	NCM Code
	WBSElementExternalID		WBSElementExternalID	WBS Element External ID
	InfoRecordIsToBeUpdated		InfoRecordIsToBeUpdated	InfoUpdate
	IN_GSTControlCode		IN_GSTControlCode	NCM Code
	BR_IsProducedInHouse		BR_IsProducedInHouse	Prod. in-house
	ConsumptionPosting		ConsumptionPosting	Consumption Posting
	PurchasingDeliveryAddressType		PurchasingDeliveryAddressType	Delivery Addr Type
	IncotermsVersion	_PurchaseOrder	IncotermsVersion	Inco. Version
	PurchasingOrganization	_PurchaseOrder	PurchasingOrganization	Purchasing Organization
	Supplier	_PurchaseOrder	Supplier	Supplier
	PPSPurOrderItemStatus		PPSPurOrderItemStatus	Item Status
	PPSPurOrderItemStatusText		PPSPurOrderItemStatusText	Pur. Doc. Stat. Name
	PPSPurOrdItemStatusCriticality		PPSPurOrdItemStatusCriticality
	virtualAccountAssignmentIsAddableboolean
	virtualScheduleLineIsAddableboolean
	PPSPerdOfPerfStartDate		PPSPerdOfPerfStartDate	Period of Performance Start Date
	PPSPerdOfPerfEndDate		PPSPerdOfPerfEndDate	Period of Performance End Date
	PPSSmartNumberItem		PPSSmartNumberItem	Smart Number
	PPSSmartNumberItemIsManual		PPSSmartNumberItemIsManual	Checkbox
	PPSConfigurableLineItemNumber		PPSConfigurableLineItemNumber	Configurable Item Number
	PPSDeliveryToleranceKey		PPSDeliveryToleranceKey	Tolerance Key
	PPSIsOptionalItem		PPSIsOptionalItem	Optional Item
	PPSOptionalItemStatus		PPSOptionalItemStatus	Optional Item Status
	PPSOptionExerciseStartDate		PPSOptionExerciseStartDate	Exercise Period Start Date
	PPSOptionExerciseEndDate		PPSOptionExerciseEndDate	Exercise Period End Date
	_PurgDocumentItemCategory		_PurgDocumentItemCategory
	_MaterialGroupValueHelp		_MaterialGroupValueHelp
	_PurOrdSupplierConfirmation		_PurOrdSupplierConfirmation
	_PurchaseOrderProcessFlow		_PurchaseOrderProcessFlow
	_SupplierConfControlKey		_SupplierConfControlKey
	PurchasingIsItemSet		PurchasingIsItemSet	Item Set
	PurchasingHierarchyNode		PurchasingHierarchyNode	Hier.node
	HierarchyParentNode		HierarchyParentNode	Hier.node
	HierarchyLevel		HierarchyLevel	Hierarchy Level
	HierarchyNodeSubTreeSize		HierarchyNodeSubTreeSize	Descendant Count
	HierarchyDrillState		HierarchyDrillState	Drill State
	HierarchyNodeOrdinalNumber		HierarchyNodeOrdinalNumber	Node Number
	PurgDocAggrgdSubitemCategory		PurgDocAggrgdSubitemCategory	Sub-items
	ConditionType		ConditionType	Condition type
	PurgDocNetAmount		PurgDocNetAmount	Net Value
	ConditionQuantity		ConditionQuantity	Pricing Unit
	ConditionQuantityUnit		ConditionQuantityUnit	Unit of Measure
	ConditionTypeName	_ConditionTypeText	ConditionTypeName	Name
	virtualUICT_AccAssCategoryFieldsboolean
	virtualUICT_PurgDocItmIsNotOptnlboolean
	virtualUICT_OptionsIsNotEnabledboolean
	virtualUICT_PurOrderItemNetAmountboolean
	virtualUICT_HideSmartNumberItemboolean
	virtualUICT_HideProcessFlowFacetboolean
	virtualUICT_HidePricingFacetboolean
	_ToleranceKey		_ToleranceKey
	_PurchaseOrderDocumentHistory		_PurchaseOrderDocumentHistory
	_Plant		_Plant
	_PlantValueHelp		_PlantValueHelp

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_PPS_PurOrderItemHierarchyTP.
-- 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.

CREATE VIEW C_PPS_PurOrderItemHierarchyTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  Material,
  Plant,
  PlantName,
  OrderQuantity,
  NetPriceAmount,
  DocumentCurrency,
  PurchaseOrderQuantityUnit,
  PurchaseOrderItemCategory,
  PurOrdExternalItemCategory,
  PurOrdItemCategoryName,
  ManufacturerMaterial,
  MaterialName,
  PurchasingDocumentDeletionCode,
  IsDeleted,
  IsBlocked,
  MaterialGroup,
  MaterialGroupName,
  BatchBySupplier,
  Batch,
  PurchaseOrderItemText,
  ProductTypeCode,
  ProductTypeName,
  CompanyCode,
  StorageLocation,
  NetPriceQuantity,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  LastChangedDate,
  PurgConfigurableItemNumber,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  IsOrderAcknRqd,
  InvoiceIsGoodsReceiptBased,
  PurchaseContractItem,
  PurchaseContract,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  EvaldRcptSettlmtIsAllowed,
  ServicePerformer,
  OrderPriceUnit,
  PurchasingParentItem,
  IncotermsClassification,
  IncotermsClassificationName,
  IncotermsLocation1,
  IncotermsLocation2,
  IntrastatServiceCode,
  CommodityCode,
  SupplierConfirmationControlKey,
  PurgDocOrderAcknNumber,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  _MultipleAcctAssgmtDistrText[1:Language = $session.system_language].MultipleAcctAssgmtDistrName AS MultipleAcctAssgmtDistrName,
  PartialInvoiceDistribution,
  _PartialInvoiceIndicator.PartialInvoiceDistributionName AS PartialInvoiceDistributionName,
  virtual AcctAssgmtUndistributedQty : menge_d AS virtualAcctAssgmtUndistributedQtymenge_d,
  virtual AcctAssgmtUndistributedAmt : bwert AS virtualAcctAssgmtUndistributedAmtbwert,
  virtual AcctAssgmtUndistributedPct : vproz AS virtualAcctAssgmtUndistributedPctvproz,
  virtual UICT_AcctAssgmtUndistriQty : boolean AS virtualUICT_AcctAssgmtUndistriQtyboolean,
  virtual UICT_AcctAssgmtUndistriAmt : boolean AS virtualUICT_AcctAssgmtUndistriAmtboolean,
  virtual UICT_PartInvcDistribution : boolean AS virtualUICT_PartInvcDistributionboolean,
  virtual UICT_AcctAssgmtUndistriPct : boolean AS virtualUICT_AcctAssgmtUndistriPctboolean,
  PurchasingInfoRecord,
  SupplierMaterialNumber,
  PPSSmartNumberHeader,
  NetAmount,
  GoodsReceiptIsNonValuated,
  TaxCalculationProcedure,
  TaxCode,
  TaxJurisdiction,
  TaxCountry,
  TaxDeterminationDate,
  ShippingInstruction,
  ItemIsRejectedBySupplier,
  PurchasingInfoRecordUpdateCode,
  PurgExternalSortNumber,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  PurContractForOverallLimit,
  Fund,
  BudgetPeriod,
  FundsCenter,
  FunctionalArea,
  GrantID,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  CostCenter,
  GLAccount,
  WBSElementInternalID,
  BR_MaterialOrigin,
  BR_MaterialUsage,
  BR_CFOPCategory,
  BR_NCM,
  WBSElementExternalID,
  InfoRecordIsToBeUpdated,
  IN_GSTControlCode,
  BR_IsProducedInHouse,
  ConsumptionPosting,
  PurchasingDeliveryAddressType,
  _PurchaseOrder.IncotermsVersion AS IncotermsVersion,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.Supplier AS Supplier,
  PPSPurOrderItemStatus,
  PPSPurOrderItemStatusText,
  PPSPurOrdItemStatusCriticality,
  virtual AccountAssignmentIsAddable : boolean AS virtualAccountAssignmentIsAddableboolean,
  virtual ScheduleLineIsAddable : boolean AS virtualScheduleLineIsAddableboolean,
  PPSPerdOfPerfStartDate,
  PPSPerdOfPerfEndDate,
  PPSSmartNumberItem,
  PPSSmartNumberItemIsManual,
  PPSConfigurableLineItemNumber,
  PPSDeliveryToleranceKey,
  PPSIsOptionalItem,
  PPSOptionalItemStatus,
  PPSOptionExerciseStartDate,
  PPSOptionExerciseEndDate,
  PurchasingIsItemSet,
  PurchasingHierarchyNode,
  HierarchyParentNode,
  HierarchyLevel,
  HierarchyNodeSubTreeSize,
  HierarchyDrillState,
  HierarchyNodeOrdinalNumber,
  PurgDocAggrgdSubitemCategory,
  ConditionType,
  PurgDocNetAmount,
  ConditionQuantity,
  ConditionQuantityUnit,
  _ConditionTypeText.ConditionTypeName AS ConditionTypeName,
  virtual UICT_AccAssCategoryFields : boolean AS virtualUICT_AccAssCategoryFieldsboolean,
  virtual UICT_PurgDocItmIsNotOptnl : boolean AS virtualUICT_PurgDocItmIsNotOptnlboolean,
  virtual UICT_OptionsIsNotEnabled : boolean AS virtualUICT_OptionsIsNotEnabledboolean,
  virtual UICT_PurOrderItemNetAmount : boolean AS virtualUICT_PurOrderItemNetAmountboolean,
  virtual UICT_HideSmartNumberItem : boolean AS virtualUICT_HideSmartNumberItemboolean,
  virtual UICT_HideProcessFlowFacet : boolean AS virtualUICT_HideProcessFlowFacetboolean,
  virtual UICT_HidePricingFacet : boolean AS virtualUICT_HidePricingFacetboolean
FROM R_PPS_PurchaseOrderItemTP
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_PurOrdSupplierConfirmation AS _PurOrdSupplierConfirmation ON _PurOrdSupplierConfirmation.PurchaseOrder = PurchaseOrder AND _PurOrdSupplierConfirmation.PurchaseOrderItem = PurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN C_PurchaseOrderProcessFlow AS _PurchaseOrderProcessFlow ON _PurchaseOrderProcessFlow.PurchaseOrder = PurchaseOrder AND _PurchaseOrderProcessFlow.PurchaseOrderItem = PurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SupplierConfControlKey AS _SupplierConfControlKey ON _SupplierConfControlKey.SupplierConfirmationControlKey = SupplierConfirmationControlKey  -- association [0..1]
LEFT OUTER JOIN C_PPS_PurgDocTolKeyQuickView AS _ToleranceKey ON PPSDeliveryToleranceKey = _ToleranceKey.PPSDeliveryToleranceKey  -- association [0..1]
LEFT OUTER JOIN C_PPS_PurOrdDocumentHistoryC AS _PurchaseOrderDocumentHistory ON PurchaseOrder = _PurchaseOrderDocumentHistory.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderDocumentHistory.PurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValueHelp ON _PlantValueHelp.Plant = Plant AND _PlantValueHelp.PurchasingOrganization = purchasingorganization  -- association [0..1]
;

Depth:

C_PPS_PurOrderItemHierarchyTP view_entity

R_PPS_PurchaseOrderItemTP view_entity