What is I_ProcmtHubPurOrdItmAPI01 in SAP S/4HANA?

I_ProcmtHubPurOrdItmAPI01 is a basic CDS view in SAP S/4HANA. Centrally Managed Purchase Order Item It contains 125 fields.

Which tables does I_ProcmtHubPurOrdItmAPI01 read from?

I_ProcmtHubPurOrdItmAPI01 reads data from: I_CentralPurchaseOrderItem.

What VDM layer is I_ProcmtHubPurOrdItmAPI01?

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

I_ProcmtHubPurOrdItmAPI01

DDL: I_PROCMTHUBPURORDITMAPI01 SQL: IPRCHBPOIAPI01 Type: view BASIC

125 Fields 1 Data Sources 1 Associations

Centrally Managed Purchase Order Item

I_ProcmtHubPurOrdItmAPI01 (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_ProcmtHubPurOrdItmAPI01 is a Basic CDS View that provides data about "Centrally Managed Purchase Order Item" in SAP S/4HANA. It reads from 1 data source (I_CentralPurchaseOrderItem) and exposes 125 fields with key fields PurchaseOrder, PurchaseOrderItem, ExtSourceSystem. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Centrally Managed Purchase Orders
Status	Released

Purpose
This CDS view provides general information about the centrally managed purchase order items. This CDS view provides the prerequisites for answering the following business questions: What is the purchase order item number? What is the associated purchase order? What is the material and material group of the purchase order item? What is the net price and price unit of the purchase order item? What is the target quantity of the purchase order item? What is the document currency of the purchase order item? What is the tax code for the purchase order item? What is the connected system of the purchase order item?

Prerequisites
You must have a role based on the SAP_BR_CENTRAL_PURCHASER business role template.

Structure
Object types This view relates to the following SAP object types: PrmtHbRpldPurchaseOrderItem Measures and attributes Some important measures and attributes are: Purchase Order Number Purchase Order Item Number Purchasing Document Category Material Group Product Type Target Quantity Connected System

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-HUB-PO
Capabilities	Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
Package	Sourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_CentralPurchaseOrderItem	I_CentralPurchaseOrderItem	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_ProcmtHubPurOrdHdrAPI01	_ProcmtHubPurchaseOrderHeader	`$projection.PurchaseOrder = _ProcmtHubPurchaseOrderHeader.PurchaseOrder and $projection.ExtSourceSystem = _ProcmtHubPurchaseOrderHeader.ExtSourceSystem`

Annotations (11)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	IPRCHBPOIAPI01	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#BASIC	view
EndUserText.label	Centrally Managed Purchase Order Item	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (125)

Key	Field	Source Field	Description
KEY	PurchaseOrder	PurchaseOrder	Purchasing Document Number
KEY	PurchaseOrderItem	PurchaseOrderItem	Item Number of Purchasing Document
KEY	ExtSourceSystem	ExtSourceSystem	Connected System ID
	PurchasingDocumentCategory	PurchasingDocumentCategory	Purchasing Document Category
	DocumentCurrency	DocumentCurrency	Document Currency
	PurchasingDocumentDeletionCode	PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document
	RequisitionerName	RequisitionerName	Name of requisitioner/requester
	MaterialGroup	MaterialGroup	Material Group
	Material	Material	Material Number
	MaterialType	MaterialType	Material Type
	SupplierMaterialNumber	SupplierMaterialNumber	Material Number Used by Supplier
	SupplierSubrange	SupplierSubrange	Supplier Subrange
	ManufacturerPartNmbr	ManufacturerPartNmbr	Manufacturer Part Number
	Manufacturer	Manufacturer	Number of a Manufacturer
	ManufacturerMaterial	ManufacturerMaterial	Material number
	PurchaseOrderItemText	PurchaseOrderItemText	Short Text
	ProductType	ProductType	Product Type Group
	ArticleCategory	ArticleCategory	Material Category
	CrossPlantConfigurableProduct	CrossPlantConfigurableProduct	Cross-Plant Configurable Material
	BaseUnit	BaseUnit	Base Unit of Measure
	PurchaseOrderItemCategory	PurchaseOrderItemCategory	Item category in purchasing document
	CommodityCode	CommodityCode	Commodity Code
	MaterialFreightGroup	MaterialFreightGroup	Material Freight Group
	ItemVolumeUnit	ItemVolumeUnit	Volume Unit
	ItemWeightUnit	ItemWeightUnit	Unit of Weight
	InternationalArticleNumber	InternationalArticleNumber	International Article Number (EAN/UPC)
	PlndOrderReplnmtElmntType	PlndOrderReplnmtElmntType	Kanban Indicator
	ProductPurchasePointsQtyUnit	ProductPurchasePointsQtyUnit	Points Unit
	CompanyCode	CompanyCode	Receiver Company Code
	Plant	Plant	Valuation Area
	StorageLocation	StorageLocation	Storage Location
	ManualDeliveryAddressID	ManualDeliveryAddressID	Manual address number in purchasing document item
	ReferenceDeliveryAddressID	ReferenceDeliveryAddressID	Number of delivery address
	IsCompletelyDelivered	IsCompletelyDelivered	"Delivery Completed" Indicator
	UnderdelivTolrtdLmtRatioInPct	UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance
	PlannedDeliveryDurationInDays	PlannedDeliveryDurationInDays	Planned Delivery Time in Days
	GoodsReceiptDurationInDays	GoodsReceiptDurationInDays	Goods receipt processing time in days
	PartialDeliveryIsAllowed	PartialDeliveryIsAllowed	Partial Delivery at Item Level (Stock Transfer)
	GoodsReceiptLatestCreationDate	GoodsReceiptLatestCreationDate	Latest Possible Goods Receipt
	OverdelivTolrtdLmtRatioInPct	OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance
	Customer	Customer	Sold-to Party
	Subcontractor	Subcontractor	Supplier to be Supplied/Who is to Receive Delivery
	SupplierIsSubcontractor	SupplierIsSubcontractor	Subcontracting Supplier
	ServicePerformer	ServicePerformer	Service Performer
	ProductPurchasePointsQty	ProductPurchasePointsQty	Number of Points
	PurchaseOrderQuantityUnit	PurchaseOrderQuantityUnit	Purchase Order Unit of Measure
	OrderItemQtyToBaseQtyNmrtr	OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit
	OrderItemQtyToBaseQtyDnmntr	OrderItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit
	NetPriceQuantity	NetPriceQuantity	Price Unit
	IsFinallyInvoiced	IsFinallyInvoiced	Final Invoice Indicator
	GoodsReceiptIsExpected	GoodsReceiptIsExpected	Goods Receipt Indicator
	InvoiceIsExpected	InvoiceIsExpected	Invoice Receipt Indicator
	InvoiceIsGoodsReceiptBased	InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification
	EvaldRcptSettlmtIsAllowed	EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)
	UnlimitedOverdeliveryIsAllowed	UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed
	PurchaseContractItem	PurchaseContractItem	Item Number of Principal Purchase Agreement
	PurchaseContract	PurchaseContract	Number of principal purchase agreement
	PurchaseRequisition	PurchaseRequisition	Purchase Requisition Number
	RequirementTracking	RequirementTracking	Requirement Tracking Number
	PurchaseRequisitionItem	PurchaseRequisitionItem	Item number of purchase requisition
	PurchasingParentItem	PurchasingParentItem	Higher-Level Item in Purchasing Documents
	OrderPriceUnit	OrderPriceUnit	Order Price Unit (Purchasing)
	PriceIsToBePrinted	PriceIsToBePrinted	Price Printout
	PartialInvoiceDistribution	PartialInvoiceDistribution	Partial invoice indicator
	MultipleAcctAssgmtDistribution	MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment
	PricingDateControl	PricingDateControl	Price Determination (Pricing) Date Control
	IncotermsClassification	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsLocation1	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	IncotermsLocation2	Incoterms Location 2
	AccountAssignmentCategory	AccountAssignmentCategory	Account Assignment Category
	ProfitCenter	ProfitCenter	Profit Center
	ConsumptionPosting	ConsumptionPosting	Consumption Posting
	IsStatisticalItem	IsStatisticalItem	Statisticl.Indicator
	IsReturnsItem	IsReturnsItem	Returns Item
	PurchasingOrderReason	PurchasingOrderReason	Reason for Ordering
	IntrastatServiceCode	IntrastatServiceCode	Intrastat Service Code
	DiscountInKindEligibility	DiscountInKindEligibility	Material qualifies for discount in kind
	PurgItemIsBlockedForDelivery	PurgItemIsBlockedForDelivery	Item blocked for SD delivery
	SupplierConfirmationControlKey	SupplierConfirmationControlKey	Confirmation Control Key
	PriorSupplier	PriorSupplier	Prior Supplier
	PurchasingInfoRecord	PurchasingInfoRecord	Number of purchasing info record
	NetAmount	NetAmount	Net Order Value in PO Currency
	GrossAmount	GrossAmount	Gross order value in PO currency
	EffectiveAmount	EffectiveAmount	Effective value of item
	Subtotal1Amount	Subtotal1Amount	Subtotal 1 from Pricing Procedure for Price Element
	Subtotal2Amount	Subtotal2Amount	Subtotal 2 from Pricing Procedure for Price Element
	Subtotal3Amount	Subtotal3Amount	Subtotal 3 from Pricing Procedure for Price Element
	Subtotal4Amount	Subtotal4Amount	Subtotal 4 from Pricing Procedure for Price Element
	Subtotal5Amount	Subtotal5Amount	Subtotal 5 from Pricing Procedure for Price Element
	Subtotal6Amount	Subtotal6Amount	Subtotal 6 from Pricing Procedure for Price Element
	NetPriceAmount	NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
	OrderQuantity	OrderQuantity	Purchase Order Quantity
	ItemVolume	ItemVolume	Volume
	ItemGrossWeight	ItemGrossWeight	Gross Weight
	ItemNetWeight	ItemNetWeight	Net Weight
	OrderPriceUnitToOrderUnitNmrtr	OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit
	OrdPriceUnitToOrderUnitDnmntr	OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit
	GoodsReceiptIsNonValuated	GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated
	TaxCode	TaxCode	Tax on sales/purchases code
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	ShippingInstruction	ShippingInstruction	Shipping Instructions
	NonDeductibleInputTaxAmount	NonDeductibleInputTaxAmount	Non-deductible input tax
	StockType	StockType	Stock Type
	ValuationType	ValuationType	Valuation Type
	ValuationCategory	ValuationCategory	Valuation Category
	ItemIsRejectedBySupplier	ItemIsRejectedBySupplier	Rejection Indicator
	PurgDocPriceDate	PurgDocPriceDate	Date of Price Determination
	PurgDocReleaseOrderQuantity	PurgDocReleaseOrderQuantity	Standard release order quantity
	EarmarkedFunds	EarmarkedFunds	Document Number for Earmarked Funds
	EarmarkedFundsItem	EarmarkedFundsItem	Earmarked Funds: Document Item
	InventorySpecialStockType	InventorySpecialStockType	Special Stock Indicator
	DeliveryDocumentType	DeliveryDocumentType	Delivery Type for Returns to Supplier
	IssuingStorageLocation	IssuingStorageLocation	Issuing Storage Location for Stock Transport Order
	AllocationTable	AllocationTable	Allocation Table
	AllocationTableItem	AllocationTableItem	Allocation Table Item
	RetailPromotion	RetailPromotion	Retail Promotion
	DownPaymentType	DownPaymentType	Down Payment Indicator
	DownPaymentPercentageOfTotAmt	DownPaymentPercentageOfTotAmt	Down Payment Percentage
	DownPaymentAmount	DownPaymentAmount	Down Payment Amount in Document Currency
	DownPaymentDueDate	DownPaymentDueDate	Due Date for Down Payment
	ExpectedOverallLimitAmount	ExpectedOverallLimitAmount	Expected Value of Overall Limit
	OverallLimitAmount	OverallLimitAmount	Overall Limit
	RequirementSegment	RequirementSegment	Requirement Segment
	_ProcmtHubPurchaseOrderHeader	_ProcmtHubPurchaseOrderHeader

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 I_ProcmtHubPurOrdItmAPI01.
-- 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: IPRCHBPOIAPI01

CREATE VIEW I_ProcmtHubPurOrdItmAPI01 AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  ExtSourceSystem,
  PurchasingDocumentCategory,
  DocumentCurrency,
  PurchasingDocumentDeletionCode,
  RequisitionerName,
  MaterialGroup,
  Material,
  MaterialType,
  SupplierMaterialNumber,
  SupplierSubrange,
  ManufacturerPartNmbr,
  Manufacturer,
  ManufacturerMaterial,
  PurchaseOrderItemText,
  ProductType,
  ArticleCategory,
  CrossPlantConfigurableProduct,
  BaseUnit,
  PurchaseOrderItemCategory,
  CommodityCode,
  MaterialFreightGroup,
  ItemVolumeUnit,
  ItemWeightUnit,
  InternationalArticleNumber,
  PlndOrderReplnmtElmntType,
  ProductPurchasePointsQtyUnit,
  CompanyCode,
  Plant,
  StorageLocation,
  ManualDeliveryAddressID,
  ReferenceDeliveryAddressID,
  IsCompletelyDelivered,
  UnderdelivTolrtdLmtRatioInPct,
  PlannedDeliveryDurationInDays,
  GoodsReceiptDurationInDays,
  PartialDeliveryIsAllowed,
  GoodsReceiptLatestCreationDate,
  OverdelivTolrtdLmtRatioInPct,
  Customer,
  Subcontractor,
  SupplierIsSubcontractor,
  ServicePerformer,
  ProductPurchasePointsQty,
  PurchaseOrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  NetPriceQuantity,
  IsFinallyInvoiced,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  EvaldRcptSettlmtIsAllowed,
  UnlimitedOverdeliveryIsAllowed,
  PurchaseContractItem,
  PurchaseContract,
  PurchaseRequisition,
  RequirementTracking,
  PurchaseRequisitionItem,
  PurchasingParentItem,
  OrderPriceUnit,
  PriceIsToBePrinted,
  PartialInvoiceDistribution,
  MultipleAcctAssgmtDistribution,
  PricingDateControl,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  AccountAssignmentCategory,
  ProfitCenter,
  ConsumptionPosting,
  IsStatisticalItem,
  IsReturnsItem,
  PurchasingOrderReason,
  IntrastatServiceCode,
  DiscountInKindEligibility,
  PurgItemIsBlockedForDelivery,
  SupplierConfirmationControlKey,
  PriorSupplier,
  PurchasingInfoRecord,
  NetAmount,
  GrossAmount,
  EffectiveAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  NetPriceAmount,
  OrderQuantity,
  ItemVolume,
  ItemGrossWeight,
  ItemNetWeight,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  GoodsReceiptIsNonValuated,
  TaxCode,
  TaxJurisdiction,
  ShippingInstruction,
  NonDeductibleInputTaxAmount,
  StockType,
  ValuationType,
  ValuationCategory,
  ItemIsRejectedBySupplier,
  PurgDocPriceDate,
  PurgDocReleaseOrderQuantity,
  EarmarkedFunds,
  EarmarkedFundsItem,
  InventorySpecialStockType,
  DeliveryDocumentType,
  IssuingStorageLocation,
  AllocationTable,
  AllocationTableItem,
  RetailPromotion,
  DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  DownPaymentAmount,
  DownPaymentDueDate,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  RequirementSegment
FROM I_CentralPurchaseOrderItem
LEFT OUTER JOIN I_ProcmtHubPurOrdHdrAPI01 AS _ProcmtHubPurchaseOrderHeader ON PurchaseOrder = _ProcmtHubPurchaseOrderHeader.PurchaseOrder AND ExtSourceSystem = _ProcmtHubPurchaseOrderHeader.ExtSourceSystem  -- association [1..1]
;

Depth:

I_ProcmtHubPurOrdItmAPI01 view

I_CentralPurchaseOrderItem view