What is I_PrmtHbRpldPurReqnItemAPI01 in SAP S/4HANA?

I_PrmtHbRpldPurReqnItemAPI01 is a basic CDS view in SAP S/4HANA. Replicated Purchase Requisition Item It contains 76 fields.

Which tables does I_PrmtHbRpldPurReqnItemAPI01 read from?

I_PrmtHbRpldPurReqnItemAPI01 reads data from: I_PrmtHbRpldPurchaseReqnItem.

What VDM layer is I_PrmtHbRpldPurReqnItemAPI01?

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

I_PrmtHbRpldPurReqnItemAPI01

DDL: I_PRMTHBRPLDPURREQNITEMAPI01 SQL: IPRMTHBPRITAPI01 Type: view BASIC

76 Fields 1 Data Sources 1 Associations

Replicated Purchase Requisition Item

I_PrmtHbRpldPurReqnItemAPI01 (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_PrmtHbRpldPurReqnItemAPI01 is a Basic CDS View that provides data about "Replicated Purchase Requisition Item" in SAP S/4HANA. It reads from 1 data source (I_PrmtHbRpldPurchaseReqnItem) and exposes 76 fields with key fields ProcmtHubPurchaseRequisition, ProcmtHubPurRequisitionItem, ProcurementHubSourceSystem. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Replicated Purchase Requisitions
Status	Released

Purpose
This CDS view provides general information about the replicated purchase requisition. This CDS view provides the prerequisites for answering the following business questions: What is the purchase requisition item number? What is the purchase requisition item type? When was the purchase requisition item created? Who created the purchase requisition item? What is the connected system in which the purchase requisition item was created? What is the purchasing organization, purchasing group, supplier associated with the purchase requisition item? What is the processing status of the purchase requisition item? What is the release status of the purchase requisition item? Which plant has the highest demand for a material? Which are the purchase requisition items with a given release status? How many purchase requisition items are due to be delivered during a certain time period?

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: PrmtHbRpldPurchaseRequisition Main parameters and filters of the CDS view The main parameters and filters are as follows: Purchase Requisition Purchase Requisition Item Number Connected System Measures and attributes Some important measures and attributes are: Purchase Requisition Number Source System Purchase Requisition Type Processing Status Plant Product Purchasing Group Item Description Delivery Date Quantity Base Unit Item Currency

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-HUB-PR
Capabilities	Data Source in SQL Select
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_PrmtHbRpldPurchaseReqnItem	I_PrmtHbRpldPurchaseReqnItem	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	E_PrmtHbRpldPurchaseReqnItem	_PrmtHbRpldPurchaseReqnItem	`_PrmtHbRpldPurchaseReqnItem.ProcmtHubPurchaseRequisition = $projection.ProcmtHubPurchaseRequisition and _PrmtHbRpldPurchaseReqnItem.ProcmtHubPurRequisitionItem = $projection.ProcmtHubPurRequisitionItem and _PrmtHbRpldPurchaseReqnItem.ProcurementHubSourceSystem = $projection.ProcurementHubSourceSystem`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	IPRMTHBPRITAPI01	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Replicated Purchase Requisition Item	view
VDM.viewType	#BASIC	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.supportedCapabilities	#SQL_DATA_SOURCE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AbapCatalog.preserveKey	true	view

Fields (76)

Key	Field	Source Field	Description
KEY	ProcmtHubPurchaseRequisition	ProcmtHubPurchaseRequisition	Purchase Requisition Number
KEY	ProcmtHubPurRequisitionItem	ProcmtHubPurRequisitionItem	Item number of purchase requisition
KEY	ProcurementHubSourceSystem	ProcurementHubSourceSystem	Connected System ID
	ProcmtHubPurRequisitionType	ProcmtHubPurRequisitionType	Purchase Requisition Document Type
	ProcessingStatus	ProcessingStatus	Processing status of purchase requisition
	ProcmtHubPurchasingGroup	ProcmtHubPurchasingGroup	Purchasing Group
	PurchaseRequisitionItemText	PurchaseRequisitionItemText	Short Text
	ProcmtHubProduct	ProcmtHubProduct	Material Number
	ProcmtHubPlant	ProcmtHubPlant	Plant
	ProcmtHubProductGroup	ProcmtHubProductGroup	Material Group
	RequestedQuantity	RequestedQuantity	Purchase requisition quantity
	BaseUnit	BaseUnit	Purchase requisition unit of measure
	DeliveryDate	DeliveryDate	Item Delivery Date
	CreationDate	CreationDate	Requisition (request) date
	PurchaseRequisitionPrice	PurchaseRequisitionPrice	Price in Purchase Requisition
	IsDeleted	IsDeleted	Deletion Indicator in Purchasing Document
	ProcmtHubAcctAssgmtCategory	ProcmtHubAcctAssgmtCategory	Account Assignment Category
	ProcmtHubPurgDocItmCategory	ProcmtHubPurgDocItmCategory	Item category in purchasing document
	GoodsReceiptIsExpected	GoodsReceiptIsExpected	Goods Receipt Indicator
	InvoiceIsExpected	InvoiceIsExpected	Invoice Receipt Indicator
	ProcmtHubSupplier	ProcmtHubSupplier	Desired Vendor
	ProcmtHubFixedSupplier	ProcmtHubFixedSupplier	Fixed Vendor
	PurReqnItemCurrency	PurReqnItemCurrency	Currency Key
	IsPurReqnBlocked	IsPurReqnBlocked	Purchase Requisition Blocked
	ProductType	ProductType	Product Type Group
	RequisitionerName	RequisitionerName	Name of requisitioner/requester
	ProcmtHubCreatedByUser	ProcmtHubCreatedByUser	Name of Person Responsible for Creating the Object
	PurchaseRequisitionIsFixed	PurchaseRequisitionIsFixed	Purchase requisition is fixed
	LastChangedDate	LastChangedDate	Last Changed On
	ProcmtHubSupplierProductNumber	ProcmtHubSupplierProductNumber	Material Number Used by Supplier
	ProcmtHubBatch	ProcmtHubBatch	Batch Number
	ProcmtHubRequirementTracking	ProcmtHubRequirementTracking	Requirement Tracking Number
	PurReqnItemBlockingReason	PurReqnItemBlockingReason	Reason for Item Block
	MaterialRevisionLevel		Revision Level
	MaterialRevisionLevel_2	MaterialRevisionLevel	Revision Level
	IsClosed	IsClosed	Purchase requisition closed
	MaterialPlannedDeliveryDurn	MaterialPlannedDeliveryDurn	Planned Delivery Time in Days
	MaterialGoodsReceiptDuration	MaterialGoodsReceiptDuration	Goods receipt processing time in days
	PurchaseOrderPriceType	PurchaseOrderPriceType	Use Requisition Price in Purchase Order
	GoodsReceiptIsNonValuated	GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated
	ProcmtHubSupplyingPlant	ProcmtHubSupplyingPlant	Supplying (issuing) plant in case of stock transport order
	ProcmtHubPurchaseContract	ProcmtHubPurchaseContract	Number of principal purchase agreement
	ProcmtHubPurchaseContractItem	ProcmtHubPurchaseContractItem	Item Number of Principal Purchase Agreement
	ProcmtHubPurchasingInfoRecord	ProcmtHubPurchasingInfoRecord	Number of purchasing info record
	ProcmtHubMRPController	ProcmtHubMRPController	MRP Controller
	PurReqnOrigin	PurReqnOrigin	Creation indicator (purchase requisition/schedule lines)
	ProcmtHubPurchasingOrg	ProcmtHubPurchasingOrg	Purchasing Organization
	ServicePerformer	ServicePerformer	Service Performer
	PerformancePeriodStartDate	PerformancePeriodStartDate	Start Date for Period of Performance
	PerformancePeriodEndDate	PerformancePeriodEndDate	End Date for Period of Performance
	PurchaseRequisitionReleaseDate	PurchaseRequisitionReleaseDate	Purchase Requisition Release Date
	OrderedQuantity	OrderedQuantity	Quantity ordered against this purchase requisition
	PurReqnPriceQuantity	PurReqnPriceQuantity	Price unit
	ProcmtHubCompanyCode	ProcmtHubCompanyCode	Company Code
	PurReqnReleaseStatus	PurReqnReleaseStatus	Requisition Processing State
	PreferredSupplierName	PreferredSupplierName	Name 1
	ProcmtHubSupplierName	ProcmtHubSupplierName	Name of Supplier
	LastChangeDateTime	LastChangeDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	ProcmtHubServicePackage	ProcmtHubServicePackage	Package number
	StorageLocation	StorageLocation	Storage Location
	curr212endasItemNetAmount
	ExpectedOverallLimitAmount	ExpectedOverallLimitAmount	Expected Value of Overall Limit
	OverallLimitAmount	OverallLimitAmount	Overall Limit
	ConsumptionPosting	ConsumptionPosting	Consumption Posting
	SourceOfSupplyIsAssigned	SourceOfSupplyIsAssigned	Assigned Source of Supply
	UserDescription	UserDescription	Full Name of Person
	IsEndOfPurposeBlocked	IsEndOfPurposeBlocked	Business Purpose Completed
	HasAttachment	HasAttachment	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
	HasNote	HasNote	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
	PurchaseReqnItemUniqueID	PurchaseReqnItemUniqueID	Unique Identifier for Purchasing Document Node
	PurReqnExternalSystemId	PurReqnExternalSystemId	Connected System ID
	PurReqnCmpltnsCat	PurReqnCmpltnsCat	Category of Incompleteness
	ItemDeliveryAddressID	ItemDeliveryAddressID	Number of delivery address
	ProcmtHubPurgObjCtrlInd	ProcmtHubPurgObjCtrlInd	Control indicator for purchasing document type
	ProcmtHubPrpsdFllwOnDoc	ProcmtHubPrpsdFllwOnDoc	Purchasing Document Number
	ProcmtHubPrpsdFllwOnDocCat	ProcmtHubPrpsdFllwOnDocCat	Purchasing Document Category

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_PrmtHbRpldPurReqnItemAPI01.
-- 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: IPRMTHBPRITAPI01

CREATE VIEW I_PrmtHbRpldPurReqnItemAPI01 AS
SELECT
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  ProcurementHubSourceSystem,
  ProcmtHubPurRequisitionType,
  ProcessingStatus,
  ProcmtHubPurchasingGroup,
  PurchaseRequisitionItemText,
  ProcmtHubProduct,
  ProcmtHubPlant,
  ProcmtHubProductGroup,
  RequestedQuantity,
  BaseUnit,
  DeliveryDate,
  CreationDate,
  PurchaseRequisitionPrice,
  IsDeleted,
  ProcmtHubAcctAssgmtCategory,
  ProcmtHubPurgDocItmCategory,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  ProcmtHubSupplier,
  ProcmtHubFixedSupplier,
  PurReqnItemCurrency,
  IsPurReqnBlocked,
  ProductType,
  RequisitionerName,
  ProcmtHubCreatedByUser,
  PurchaseRequisitionIsFixed,
  LastChangedDate,
  ProcmtHubSupplierProductNumber,
  ProcmtHubBatch,
  ProcmtHubRequirementTracking,
  PurReqnItemBlockingReason,
  cast(MaterialRevisionLevel as revlv) AS MaterialRevisionLevel,
  MaterialRevisionLevel AS MaterialRevisionLevel_2,
  IsClosed,
  MaterialPlannedDeliveryDurn,
  MaterialGoodsReceiptDuration,
  PurchaseOrderPriceType,
  GoodsReceiptIsNonValuated,
  ProcmtHubSupplyingPlant,
  ProcmtHubPurchaseContract,
  ProcmtHubPurchaseContractItem,
  ProcmtHubPurchasingInfoRecord,
  ProcmtHubMRPController,
  PurReqnOrigin,
  ProcmtHubPurchasingOrg,
  ServicePerformer,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  PurchaseRequisitionReleaseDate,
  OrderedQuantity,
  PurReqnPriceQuantity,
  ProcmtHubCompanyCode,
  PurReqnReleaseStatus,
  PreferredSupplierName,
  ProcmtHubSupplierName,
  LastChangeDateTime,
  ProcmtHubServicePackage,
  StorageLocation,
  case when PurReqnPriceQuantity = 0 then cast( RequestedQuantity * PurchaseRequisitionPrice as abap.curr(21,2)) when ProcmtHubPurgDocItmCategory = 'A' then ExpectedOverallLimitAmount else cast( division(RequestedQuantity * PurchaseRequisitionPrice , PurReqnPriceQuantity, 2) as abap.curr(21,2)) end as ItemNetAmount AS curr212endasItemNetAmount,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  ConsumptionPosting,
  SourceOfSupplyIsAssigned,
  UserDescription,
  IsEndOfPurposeBlocked,
  HasAttachment,
  HasNote,
  PurchaseReqnItemUniqueID,
  PurReqnExternalSystemId,
  PurReqnCmpltnsCat,
  ItemDeliveryAddressID,
  ProcmtHubPurgObjCtrlInd,
  ProcmtHubPrpsdFllwOnDoc,
  ProcmtHubPrpsdFllwOnDocCat
FROM I_PrmtHbRpldPurchaseReqnItem
LEFT OUTER JOIN E_PrmtHbRpldPurchaseReqnItem AS _PrmtHbRpldPurchaseReqnItem ON _PrmtHbRpldPurchaseReqnItem.ProcmtHubPurchaseRequisition = ProcmtHubPurchaseRequisition AND _PrmtHbRpldPurchaseReqnItem.ProcmtHubPurRequisitionItem = ProcmtHubPurRequisitionItem AND _PrmtHbRpldPurchaseReqnItem.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
;

Depth:

I_PrmtHbRpldPurReqnItemAPI01 view

I_PrmtHbRpldPurchaseReqnItem view