What is I_PurchaseContractItemAPI01 in SAP S/4HANA?

I_PurchaseContractItemAPI01 is a composite CDS view in SAP S/4HANA. Purchase Contract Item It contains 69 fields.

Which tables does I_PurchaseContractItemAPI01 read from?

I_PurchaseContractItemAPI01 reads data from: I_PurchaseContractItem.

What VDM layer is I_PurchaseContractItemAPI01?

I_PurchaseContractItemAPI01 is classified as a Composite view that combines data from multiple basic views.

I_PurchaseContractItemAPI01

DDL: I_PURCHASECONTRACTITEMAPI01 SQL: IPURCONTRITEMAPI Type: view COMPOSITE

69 Fields 1 Data Sources 3 Associations

Purchase Contract Item

I_PurchaseContractItemAPI01 (Composite)

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

Sourcing & Procurement

I_PurchaseContractItemAPI01 is a Composite CDS View that provides data about "Purchase Contract Item" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 69 fields with key fields PurchaseContract, PurchaseContractItem. It has 3 associations to related views.

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-OA-CON
Capabilities	Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
Package	Sourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides all the information related to the business object Purchase Contract Item and also provides the prerequisites for answering the following business questions:</p> <ul><li><p>What is the material, material description, and material group of the contract item?</p></li> <li><p>What is the account assignment category for the contract item?</p></li> <li><p>What is the net price and price unit of the contract item?</p></li> <li><p>For which plant is the contract item created?</p></li> <li><p>What is the storage location of the contract item?</p></li> <li><p>What is the tax code for the contract item?</p></li> <li><p>Is the purchase contract item a flat item or a hierarchy item?</p></li> <li><p>Is the purchase contract item an item set or a functional item?</p></li> <li><p>What is the parent item number of the purchase contract item?</p></li> </ul>

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_PurchaseContractItem	I_PurchaseContractItem	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_PurchaseContractAPI01	_PurchaseContractAPI01	`$projection.PurchaseContract = _PurchaseContractAPI01.PurchaseContract`
[1..1]	I_PurchasingCategoryMatlGroup	_PurchasingCategoryMatlGroup	`$projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup`
[0..1]	E_PurchasingDocumentItem	_ItemExtension	`$projection.PurchaseContract = _ItemExtension.PurchasingDocument and $projection.PurchaseContractItem = _ItemExtension.PurchasingDocumentItem`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	IPURCONTRITEMAPI	view
VDM.viewType	#COMPOSITE	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Purchase Contract Item	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (69)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseContract	I_PurchaseContractItem	PurchaseContract	Purchasing Contract Header
KEY	PurchaseContractItem	I_PurchaseContractItem	PurchaseContractItem	Item Number of Purchasing Contract
	Material	I_PurchaseContractItem	Material	Material Number
	PurchaseContractItemText	I_PurchaseContractItem	PurchaseContractItemText	Short Text
	ContractNetPriceAmount	I_PurchaseContractItem	ContractNetPriceAmount	Net Price in Purchasing Document (in Document Currency)
	OrderPriceUnit	I_PurchaseContractItem	OrderPriceUnit	Order Price Unit (Purchasing)
	VolumeUnit	I_PurchaseContractItem	VolumeUnit	Volume Unit
	OrderQuantityUnit	I_PurchaseContractItem	OrderQuantityUnit	Purchase Order Unit of Measure
	MaterialGroup	I_PurchaseContractItem	MaterialGroup	Material Group
	Customer	I_PurchaseContractItem	Customer	Sold-to Party
	Subcontractor	I_PurchaseContractItem	Subcontractor	Supplier to be Supplied/Who is to Receive Delivery
	ReferenceDeliveryAddressID	I_PurchaseContractItem	ReferenceDeliveryAddressID	Reference Delivery Address
	ManualDeliveryAddressID	I_PurchaseContractItem	ManualDeliveryAddressID	Manual address number in purchasing document item
	DeliveryAddressID			Contact Card Address (with output conversion)
	DeliveryAddressID_2	I_PurchaseContractItem	DeliveryAddressID	Address
	Plant	I_PurchaseContractItem	Plant	Valuation Area
	StorageLocation	I_PurchaseContractItem	StorageLocation	Storage Location
	AccountAssignmentCategory	I_PurchaseContractItem	AccountAssignmentCategory	Account Assignment Category
	GoodsReceiptIsExpected	I_PurchaseContractItem	GoodsReceiptIsExpected	Goods Receipt Indicator
	NetPriceQuantity	I_PurchaseContractItem	NetPriceQuantity	Price Unit
	MultipleAcctAssgmtDistribution	I_PurchaseContractItem	MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment
	TargetQuantity	I_PurchaseContractItem	TargetQuantity	Target Quantity
	TargetAmount	I_PurchaseContractItem	TargetAmount	Target Value for Outline Agreement in Document Currency
	DocumentCurrency	I_PurchaseContractItem	DocumentCurrency	Document Currency
	OrdPriceUnitToOrderUnitDnmntr	I_PurchaseContractItem	OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit
	OrderPriceUnitToOrderUnitNmrtr	I_PurchaseContractItem	OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit
	PurchasingDocumentItemCategory	I_PurchaseContractItem	PurchasingDocumentItemCategory	Item category in purchasing document
	SupplierMaterialNumber	I_PurchaseContractItem	SupplierMaterialNumber	Material Number Used by Supplier
	EvaldRcptSettlmtIsAllowed	I_PurchaseContractItem	EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)
	UnderdelivTolrtdLmtRatioInPct	I_PurchaseContractItem	UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance
	PriceIsToBePrinted	I_PurchaseContractItem	PriceIsToBePrinted	Price Printout
	SupplierConfirmationControlKey	I_PurchaseContractItem	SupplierConfirmationControlKey	Confirmation Control Key
	OverdelivTolrtdLmtRatioInPct	I_PurchaseContractItem	OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance
	UnlimitedOverdeliveryIsAllowed	I_PurchaseContractItem	UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed
	InvoiceIsExpected	I_PurchaseContractItem	InvoiceIsExpected	Invoice Receipt Indicator
	InvoiceIsGoodsReceiptBased	I_PurchaseContractItem	InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification
	PurgDocPriceDate	I_PurchaseContractItem	PurgDocPriceDate	Date of Price Determination
	IsInfoRecordUpdated	I_PurchaseContractItem	IsInfoRecordUpdated	Indicator: Update Info Record
	PurchasingInfoRecordUpdateCode	I_PurchaseContractItem	PurchasingInfoRecordUpdateCode	Indicator: Update Info Record
	PurgDocReleaseOrderQuantity	I_PurchaseContractItem	PurgDocReleaseOrderQuantity	Standard release order quantity
	PurgDocOrderAcknNumber	I_PurchaseContractItem	PurgDocOrderAcknNumber	Order Acknowledgment Number
	PurgDocEstimatedPrice	I_PurchaseContractItem	PurgDocEstimatedPrice	Indicator: Estimated Price
	IsInfoAtRegistration	I_PurchaseContractItem	IsInfoAtRegistration	Info at Registration
	NoDaysReminder1	I_PurchaseContractItem	NoDaysReminder1	Number of Days for First Reminder/Expediter
	NoDaysReminder2	I_PurchaseContractItem	NoDaysReminder2	Number of Days for Second Reminder/Expediter
	NoDaysReminder3	I_PurchaseContractItem	NoDaysReminder3	Number of Days for Third Reminder/Expediter
	StockType	I_PurchaseContractItem	StockType	Stock Type
	TaxCode	I_PurchaseContractItem	TaxCode	Tax on sales/purchases code
	RequirementTracking	I_PurchaseContractItem	RequirementTracking	Requirement Tracking Number
	IsOrderAcknRqd	I_PurchaseContractItem	IsOrderAcknRqd	Order Acknowledgment Requirement
	ShippingInstruction	I_PurchaseContractItem	ShippingInstruction	Shipping Instructions
	ShippingType	I_PurchaseContractItem	ShippingType	Shipping Type
	GoodsReceiptIsNonValuated	I_PurchaseContractItem	GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated
	ServicePerformer	I_PurchaseContractItem	ServicePerformer	Service Performer
	ProductType	I_PurchaseContractItem	ProductType	Product Type Group
	ProductTypeCode	I_PurchaseContractItem	ProductTypeCode	Product Type Group
	MaterialType	I_PurchaseContractItem	MaterialType	Material Type
	FormattedPurchaseContractItem	I_PurchaseContractItem	FormattedPurchaseContractItem	Char 15
	PurchaseContractItemFormatted	I_PurchaseContractItem	PurchaseContractItemFormatted	Char 15
	PurchasingContractDeletionCode	I_PurchaseContractItem	PurchasingContractDeletionCode	Deletion Indicator in Purchasing Document
	PurchaseContractItemUniqueID	I_PurchaseContractItem	PurchaseContractItemUniqueID	Concatenation of EBELN and EBELP
	PurchasingParentItem	I_PurchaseContractItem	PurchasingParentItem	Higher-Level Item in Purchasing Documents
	IsStatisticalItem	I_PurchaseContractItem	IsStatisticalItem	Statisticl.Indicator
	PurgConfigurableItemNumber	I_PurchaseContractItem	PurgConfigurableItemNumber	Hierarchy Number
	PurgDocAggrgdSubitemCategory	I_PurchaseContractItem	PurgDocAggrgdSubitemCategory	Subitems Exist
	PurgExternalSortNumber	I_PurchaseContractItem	PurgExternalSortNumber	External Sort Number
	PurchasingCategory			Purchasing Category ID
	PurgCatName			Name of Purchasing Category
	_PurchaseContractAPI01		_PurchaseContractAPI01

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_PurchaseContractItemAPI01.
-- 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: IPURCONTRITEMAPI

CREATE VIEW I_PurchaseContractItemAPI01 AS
SELECT
  I_PurchaseContractItem.PurchaseContract AS PurchaseContract,
  I_PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  I_PurchaseContractItem.Material AS Material,
  I_PurchaseContractItem.PurchaseContractItemText AS PurchaseContractItemText,
  I_PurchaseContractItem.ContractNetPriceAmount AS ContractNetPriceAmount,
  I_PurchaseContractItem.OrderPriceUnit AS OrderPriceUnit,
  I_PurchaseContractItem.VolumeUnit AS VolumeUnit,
  I_PurchaseContractItem.OrderQuantityUnit AS OrderQuantityUnit,
  I_PurchaseContractItem.MaterialGroup AS MaterialGroup,
  I_PurchaseContractItem.Customer AS Customer,
  I_PurchaseContractItem.Subcontractor AS Subcontractor,
  I_PurchaseContractItem.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  I_PurchaseContractItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  cast(I_PurchaseContractItem.DeliveryAddressID as contactcardaddress) AS DeliveryAddressID,
  I_PurchaseContractItem.DeliveryAddressID AS DeliveryAddressID_2,
  I_PurchaseContractItem.Plant AS Plant,
  I_PurchaseContractItem.StorageLocation AS StorageLocation,
  I_PurchaseContractItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_PurchaseContractItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  I_PurchaseContractItem.NetPriceQuantity AS NetPriceQuantity,
  I_PurchaseContractItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  I_PurchaseContractItem.TargetQuantity AS TargetQuantity,
  I_PurchaseContractItem.TargetAmount AS TargetAmount,
  I_PurchaseContractItem.DocumentCurrency AS DocumentCurrency,
  I_PurchaseContractItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  I_PurchaseContractItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  I_PurchaseContractItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  I_PurchaseContractItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_PurchaseContractItem.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  I_PurchaseContractItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  I_PurchaseContractItem.PriceIsToBePrinted AS PriceIsToBePrinted,
  I_PurchaseContractItem.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  I_PurchaseContractItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  I_PurchaseContractItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  I_PurchaseContractItem.InvoiceIsExpected AS InvoiceIsExpected,
  I_PurchaseContractItem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  I_PurchaseContractItem.PurgDocPriceDate AS PurgDocPriceDate,
  I_PurchaseContractItem.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  I_PurchaseContractItem.PurchasingInfoRecordUpdateCode AS PurchasingInfoRecordUpdateCode,
  I_PurchaseContractItem.PurgDocReleaseOrderQuantity AS PurgDocReleaseOrderQuantity,
  I_PurchaseContractItem.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  I_PurchaseContractItem.PurgDocEstimatedPrice AS PurgDocEstimatedPrice,
  I_PurchaseContractItem.IsInfoAtRegistration AS IsInfoAtRegistration,
  I_PurchaseContractItem.NoDaysReminder1 AS NoDaysReminder1,
  I_PurchaseContractItem.NoDaysReminder2 AS NoDaysReminder2,
  I_PurchaseContractItem.NoDaysReminder3 AS NoDaysReminder3,
  I_PurchaseContractItem.StockType AS StockType,
  I_PurchaseContractItem.TaxCode AS TaxCode,
  I_PurchaseContractItem.RequirementTracking AS RequirementTracking,
  I_PurchaseContractItem.IsOrderAcknRqd AS IsOrderAcknRqd,
  I_PurchaseContractItem.ShippingInstruction AS ShippingInstruction,
  I_PurchaseContractItem.ShippingType AS ShippingType,
  I_PurchaseContractItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  I_PurchaseContractItem.ServicePerformer AS ServicePerformer,
  I_PurchaseContractItem.ProductType AS ProductType,
  I_PurchaseContractItem.ProductTypeCode AS ProductTypeCode,
  I_PurchaseContractItem.MaterialType AS MaterialType,
  I_PurchaseContractItem.FormattedPurchaseContractItem AS FormattedPurchaseContractItem,
  I_PurchaseContractItem.PurchaseContractItemFormatted AS PurchaseContractItemFormatted,
  I_PurchaseContractItem.PurchasingContractDeletionCode AS PurchasingContractDeletionCode,
  I_PurchaseContractItem.PurchaseContractItemUniqueID AS PurchaseContractItemUniqueID,
  I_PurchaseContractItem.PurchasingParentItem AS PurchasingParentItem,
  I_PurchaseContractItem.IsStatisticalItem AS IsStatisticalItem,
  I_PurchaseContractItem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  I_PurchaseContractItem.PurgDocAggrgdSubitemCategory AS PurgDocAggrgdSubitemCategory,
  I_PurchaseContractItem.PurgExternalSortNumber AS PurgExternalSortNumber,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName
FROM I_PurchaseContractItem
LEFT OUTER JOIN I_PurchaseContractAPI01 AS _PurchaseContractAPI01 ON PurchaseContract = _PurchaseContractAPI01.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _ItemExtension ON PurchaseContract = _ItemExtension.PurchasingDocument AND PurchaseContractItem = _ItemExtension.PurchasingDocumentItem  -- association [0..1]
;

Depth:

I_PurchaseContractItemAPI01 view

I_PurchaseContractItem view

C_PurchaseContractItemDEX view