What is I_PurchaseContractItemAPI01 in SAP S/4HANA?

I_PurchaseContractItemAPI01 is a composite CDS view in SAP S/4HANA. Purchase Contract Item It contains 87 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 Package: VDM_MM_PUR_CON

87 Fields 1 Data Sources 3 Associations

Purchase Contract Item

I_PurchaseContractItemAPI01 (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public 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 87 fields with key fields PurchaseContract, PurchaseContractItem. It has 3 associations to related views. Part of development package VDM_MM_PUR_CON.

SAP API Hub

Category	Composite
State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-OA-CON-2CL
Capabilities	Data Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)	Yes
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Sourcing and Procurement for SAP S/4HANA Cloud Public 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 contract item a flat service item?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public 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.PurchaseContract = _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 (87)

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
	PlannedDeliveryDurationInDays	I_PurchaseContractItem	PlannedDeliveryDurationInDays	Planned Delivery Time in Days
	GoodsReceiptDurationInDays	I_PurchaseContractItem	GoodsReceiptDurationInDays	Goods receipt processing time in days
	CompanyCode	I_PurchaseContractItem	CompanyCode	Receiver Company Code
	PurchaseContractType	I_PurchaseContractItem	PurchaseContractType	Purchasing Document Type
	IsToBeAcceptedAtOrigin	I_PurchaseContractItem	IsToBeAcceptedAtOrigin	Acceptance At Origin
	PartialInvoiceDistribution	I_PurchaseContractItem	PartialInvoiceDistribution	Partial invoice indicator
	IncotermsClassification	I_PurchaseContractItem	IncotermsClassification	Incoterms (Part 1)
	IncotermsLocation1	I_PurchaseContractItem	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	I_PurchaseContractItem	IncotermsLocation2	Incoterms Location 2
	SupplierSubrange	I_PurchaseContractItem	SupplierSubrange	Supplier Subrange
	PurchasingInfoRecord	I_PurchaseContractItem	PurchasingInfoRecord	Purchasing Info Record Number
	TaxCountry	I_PurchaseContractItem	TaxCountry	Tax Reporting Country/Region
	TaxDeterminationDate	I_PurchaseContractItem	TaxDeterminationDate	Date for Determining Tax Rates
	PurchaseRequisition	I_PurchaseContractItem	PurchaseRequisition	Purchase Requisition Number
	PurchaseRequisitionItem	I_PurchaseContractItem	PurchaseRequisitionItem	Item Number of Purchase Requisition
	PurContractItmReplnmtElmntType	I_PurchaseContractItem	PurContractItmReplnmtElmntType	Kanban Indicator
	PurgProdCmplncSupplierStatus	I_PurchaseContractItem	PurgProdCmplncSupplierStatus	Product Compliance Supplier Check Status (Item)
	PurchasingIsCatalogRelevant	I_PurchaseContractItem	PurchasingIsCatalogRelevant	Indicator for Purchasing Document Catalog Item
	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.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  I_PurchaseContractItem.GoodsReceiptDurationInDays AS GoodsReceiptDurationInDays,
  I_PurchaseContractItem.CompanyCode AS CompanyCode,
  I_PurchaseContractItem.PurchaseContractType AS PurchaseContractType,
  I_PurchaseContractItem.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  I_PurchaseContractItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  I_PurchaseContractItem.IncotermsClassification AS IncotermsClassification,
  I_PurchaseContractItem.IncotermsLocation1 AS IncotermsLocation1,
  I_PurchaseContractItem.IncotermsLocation2 AS IncotermsLocation2,
  I_PurchaseContractItem.SupplierSubrange AS SupplierSubrange,
  I_PurchaseContractItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_PurchaseContractItem.TaxCountry AS TaxCountry,
  I_PurchaseContractItem.TaxDeterminationDate AS TaxDeterminationDate,
  I_PurchaseContractItem.PurchaseRequisition AS PurchaseRequisition,
  I_PurchaseContractItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_PurchaseContractItem.PurContractItmReplnmtElmntType AS PurContractItmReplnmtElmntType,
  I_PurchaseContractItem.PurgProdCmplncSupplierStatus AS PurgProdCmplncSupplierStatus,
  I_PurchaseContractItem.PurchasingIsCatalogRelevant AS PurchasingIsCatalogRelevant,
  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 PurchaseContract = _ItemExtension.PurchasingDocumentItem  -- association [0..1]
;

Depth:

I_PurchaseContractItemAPI01 view

I_PurchaseContractItem view

C_PurchaseContractItemDEX view