What is I_CntrlPurContractItemAPI01 in SAP S/4HANA?

I_CntrlPurContractItemAPI01 is a composite CDS view in SAP S/4HANA. Item in Central Purchase Contract It contains 46 fields.

Which tables does I_CntrlPurContractItemAPI01 read from?

I_CntrlPurContractItemAPI01 reads data from: I_CntrlPurchaseContractItem.

What VDM layer is I_CntrlPurContractItemAPI01?

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

I_CntrlPurContractItemAPI01

DDL: I_CNTRLPURCONTRACTITEMAPI01 SQL: ICNTRLPCTRIAPI01 Type: view COMPOSITE

46 Fields 1 Data Sources 2 Associations

Item in Central Purchase Contract

I_CntrlPurContractItemAPI01 (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_CntrlPurContractItemAPI01 is a Composite CDS View that provides data about "Item in Central Purchase Contract" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurchaseContractItem) and exposes 46 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Central Purchase Contracts
Status	Released

Purpose
This CDS view provides general information about the item of a central purchase contract. This CDS view provides the prerequisites for answering the following business questions: What is the material and material group of the item of the central purchase contract? What is the associated central purchase contract? What is the net price and price unit of the item of the central purchase contract? What is the target amount and quantity of the item of the central purchase contract? What is the document currency of the item of the central purchase contract? What is the tax code for the item of the central purchase contract?

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: I_CentralPurchaseContractAPI01 Measures and attributes Some important measures and attributes are: Central Purchase Contract Central Purchase Contract Item Purchasing Document Item Category Material Group Product Type Target Quantity Net Price Quantity

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-HUB-CTR
Capabilities	Data Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities
Package	Sourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides general information about the item of a central purchase contract.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the material and material group of the item of the central purchase contract?</p></li> <li><p>What is the associated central purchase contract?</p></li> <li><p>What is the net price and price unit of the item of the central purchase contract? </p></li> <li><p>What is the target amount and quantity of the item of the central purchase contract?</p></li> <li><p>What is the document currency of the item of the central purchase contract?</p></li> <li><p>What is the tax code for the item of the central purchase contract?</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_CntrlPurchaseContractItem	I_CntrlPurchaseContractItem	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_CentralPurchaseContractAPI01	_CentralPurchaseContract	`$projection.CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract`
[1..*]	I_CntrlPurContrDistribution	_CntrlPurConItmDistribution	`$projection.CentralPurchaseContract = _CntrlPurConItmDistribution.CentralPurchaseContract and $projection.CentralPurchaseContractItem = _CntrlPurConItmDistribution.CentralPurchaseContractItem`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	ICNTRLPCTRIAPI01	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Item in Central Purchase Contract	view
AbapCatalog.preserveKey	true	view

Fields (46)

Key	Field	Source Field	Description
KEY	CentralPurchaseContract	CentralPurchaseContract	Central Purchase Contract
KEY	CentralPurchaseContractItem	CentralPurchaseContractItem	Item in Central Purchase Contract
	PurchasingDocumentItemCategory	PurchasingDocumentItemCategory	Item category in purchasing document
	FormattedPurchaseContractItem	FormattedPurchaseContractItem	Char15
	MaterialGroup	MaterialGroup	Material Group
	PurchasingCentralMaterial	PurchasingCentralMaterial	Material of External System
	ProcmtHubExtReferencedMaterial	ProcmtHubExtReferencedMaterial	Material of External System
	CntrlPurContractItemText	PurchaseContractItemText	Short Text
	ProductType	ProductType	Product Type Group
	NetPriceQuantity	NetPriceQuantity	Price Unit
	OrderPriceUnit	OrderPriceUnit	Order Price Unit (Purchasing)
	TargetQuantity	TargetQuantity	Target Quantity
	CntrlPurContrItmTargetAmount	CntrlPurContrItmTargetAmount	Target Value at Item Level in Procurement Hub
	ContractNetPriceAmount	ContractNetPriceAmount	Net Price in Purchasing Document (in Document Currency)
	OrderQuantityUnit	OrderQuantityUnit	Purchase Order Unit of Measure
	PurgDocReleaseOrderQuantity	PurgDocReleaseOrderQuantity	Standard release order quantity
	OrdPriceUnitToOrderUnitDnmntr	OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit
	OrderPriceUnitToOrderUnitNmrtr	OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit
	DocumentCurrency	DocumentCurrency	Document Currency
	NoDaysReminder1	NoDaysReminder1	Number of Days for First Reminder/Expediter
	NoDaysReminder2	NoDaysReminder2	Number of Days for Second Reminder/Expediter
	NoDaysReminder3	NoDaysReminder3	Number of Days for Third Reminder/Expediter
	PurgDocOrderAcknNumber	PurgDocOrderAcknNumber	Order Acknowledgment Number
	RequirementTracking	RequirementTracking	Requirement Tracking Number
	SupplierMaterialNumber	SupplierMaterialNumber	Material Number Used by Supplier
	IsOrderAcknRqd	IsOrderAcknRqd	Order Acknowledgment Requirement
	PurgDocEstimatedPrice	PurgDocEstimatedPrice	Indicator: Estimated Price
	PriceIsToBePrinted	PriceIsToBePrinted	Price Printout
	UnderdelivTolrtdLmtRatioInPct	UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance
	OverdelivTolrtdLmtRatioInPct	OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance
	UnlimitedOverdeliveryIsAllowed	UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed
	StockType	StockType	Stock Type
	TaxCode	TaxCode	Tax on sales/purchases code
	ShippingInstruction	ShippingInstruction	Shipping Instructions
	GoodsReceiptIsExpected	GoodsReceiptIsExpected	Goods Receipt Indicator
	GoodsReceiptIsNonValuated	GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated
	InvoiceIsExpected	InvoiceIsExpected	Invoice Receipt Indicator
	InvoiceIsGoodsReceiptBased	InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification
	EvaldRcptSettlmtIsAllowed	EvaldRcptSettlmtIsAllowed	Evaluated Receipt Settlement (ERS)
	PurchasingContractDeletionCode	PurchasingContractDeletionCode	Deletion Indicator in Purchasing Document
	ActivePurchasingDocument	ActivePurchasingDocument	Active Purchasing Document
	PurgDocItmBlkRsnCode	PurgDocItmBlkRsnCode	Blocking Reason - ID
	PurchasingParentItem	PurchasingParentItem	Higher-Level Item in Purchasing Documents
	IsOutline	IsStatisticalItem	Statisticl.Indicator
	_CentralPurchaseContract	_CentralPurchaseContract
	_CntrlPurConItmDistribution	_CntrlPurConItmDistribution

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_CntrlPurContractItemAPI01.
-- 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: ICNTRLPCTRIAPI01

CREATE VIEW I_CntrlPurContractItemAPI01 AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  PurchasingDocumentItemCategory,
  FormattedPurchaseContractItem,
  MaterialGroup,
  PurchasingCentralMaterial,
  ProcmtHubExtReferencedMaterial,
  PurchaseContractItemText AS CntrlPurContractItemText,
  ProductType,
  NetPriceQuantity,
  OrderPriceUnit,
  TargetQuantity,
  CntrlPurContrItmTargetAmount,
  ContractNetPriceAmount,
  OrderQuantityUnit,
  PurgDocReleaseOrderQuantity,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  DocumentCurrency,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  PurgDocOrderAcknNumber,
  RequirementTracking,
  SupplierMaterialNumber,
  IsOrderAcknRqd,
  PurgDocEstimatedPrice,
  PriceIsToBePrinted,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  StockType,
  TaxCode,
  ShippingInstruction,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  EvaldRcptSettlmtIsAllowed,
  PurchasingContractDeletionCode,
  ActivePurchasingDocument,
  PurgDocItmBlkRsnCode,
  PurchasingParentItem,
  IsStatisticalItem AS IsOutline
FROM I_CntrlPurchaseContractItem
LEFT OUTER JOIN I_CentralPurchaseContractAPI01 AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurContrDistribution AS _CntrlPurConItmDistribution ON CentralPurchaseContract = _CntrlPurConItmDistribution.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurConItmDistribution.CentralPurchaseContractItem  -- association [1..*]
;

Depth:

I_CntrlPurContractItemAPI01 view

I_CntrlPurchaseContractItem view