What is A_PurchaseRequisitionItem in SAP S/4HANA?

A_PurchaseRequisitionItem is a composite CDS view in SAP S/4HANA. Item It contains 112 fields.

Which tables does A_PurchaseRequisitionItem read from?

A_PurchaseRequisitionItem reads data from: I_Purchaserequisitionitem.

What VDM layer is A_PurchaseRequisitionItem?

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

A_PurchaseRequisitionItem

DDL: A_PURCHASEREQUISITIONITEM SQL: APURREQITM Type: view COMPOSITE

112 Fields 1 Data Sources 7 Associations

Item

A_PurchaseRequisitionItem is a Composite CDS View that provides data about "Item" in SAP S/4HANA. It reads from 1 data source (I_Purchaserequisitionitem) and exposes 112 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_Purchaserequisitionitem	I_Purchaserequisitionitem	from

Associations (7)

Cardinality	Target	Alias	Condition
[1..1]	A_PurchaseRequisitionHeader	_PurchaseReqn	`_PurchaseReqn.PurchaseRequisition = $projection.PurchaseRequisition`
[0..*]	A_PurReqnAcctAssgmt	_PurchaseReqnAcctAssgmt	`_PurchaseReqnAcctAssgmt.PurchaseRequisition = $projection.PurchaseRequisition and _PurchaseReqnAcctAssgmt.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem`
[0..1]	A_PurReqAddDelivery	_PurchaseReqnDeliveryAddress	`_PurchaseReqnDeliveryAddress.PurchaseRequisition = $projection.PurchaseRequisition and _PurchaseReqnDeliveryAddress.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem`
[0..*]	A_PurchaseReqnItemText	_PurchaseReqnItemText	`_PurchaseReqnItemText.PurchaseRequisition = $projection.PurchaseRequisition and _PurchaseReqnItemText.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem`
[0..1]	I_Supplier	_Subcontractor	`I_Purchaserequisitionitem.Subcontractor = _Subcontractor.Supplier`
[0..1]	I_Customer	_Customer	`I_Purchaserequisitionitem.PurReqnReceivingCustomer = _Customer.Customer ----Extension`
[0..1]	E_Purchaserequisitionitem	_PurchaseReqnItemExtension	`_PurchaseReqnItemExtension.PurchaseRequisition = $projection.PurchaseRequisition and _PurchaseReqnItemExtension.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem`

Annotations (15)

Name	Value	Level
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
AbapCatalog.sqlViewName	APURREQITM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Item	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	false	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (112)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseRequisition	I_Purchaserequisitionitem	PurchaseRequisition	Requisition
KEY	PurchaseRequisitionItem	I_Purchaserequisitionitem	PurchaseRequisitionItem	Requisn. item
	PurchasingDocument	I_Purchaserequisitionitem	PurchasingDocument	Purchasing Document
	PurchasingDocumentItem	I_Purchaserequisitionitem	PurchasingDocumentItem	Purchasing Doc. Item
	PurReqnReleaseStatus	I_Purchaserequisitionitem	PurReqnReleaseStatus	Proc.state
	PurchaseRequisitionType	I_Purchaserequisitionitem	PurchaseRequisitionType	Order Type
	PurchasingDocumentSubtype	I_Purchaserequisitionitem	PurchasingDocumentSubtype	Control
	PurchasingDocumentItemCategory	I_Purchaserequisitionitem	PurchasingDocumentItemCategory	Item Category
	PurchaseRequisitionItemText	I_Purchaserequisitionitem	PurchaseRequisitionItemText	Short Text
	AccountAssignmentCategory	I_Purchaserequisitionitem	AccountAssignmentCategory	Acct Assgmt Cat
	MaterialendasMaterial
	MaterialGroup	I_Purchaserequisitionitem	MaterialGroup	Product Group
	PurchasingDocumentCategory	I_Purchaserequisitionitem	PurchasingDocumentCategory	Doc. Category
	RequestedQuantity	I_Purchaserequisitionitem	RequestedQuantity	Requested Quantity
	BaseUnit	I_Purchaserequisitionitem	BaseUnit	Unit of Measure
	PurchaseRequisitionPrice	I_Purchaserequisitionitem	PurchaseRequisitionPrice	Valuation Price
	PurReqnPriceQuantity	I_Purchaserequisitionitem	PurReqnPriceQuantity	Price unit
	MaterialGoodsReceiptDuration	I_Purchaserequisitionitem	MaterialGoodsReceiptDuration	GR proc. time
	ReleaseCode	I_Purchaserequisitionitem	ReleaseCode	Release ind.
	PurchaseRequisitionReleaseDate	I_Purchaserequisitionitem	PurchaseRequisitionReleaseDate	Release Date
	PurchasingGroup	I_Purchaserequisitionitem	PurchasingGroup	Purchasing Group
	PlantendasPlant
	ExtCompanyCodeForPurgendasCompanyCode
	SourceOfSupplyIsAssigned	I_Purchaserequisitionitem	SourceOfSupplyIsAssigned	Assigned
	SupplyingPlant	I_Purchaserequisitionitem	SupplyingPlant	Supplying Plant
	OrderedQuantity	I_Purchaserequisitionitem	OrderedQuantity	Quantity
	DeliveryDate	I_Purchaserequisitionitem	DeliveryDate	Delivery Date
	CreationDate	I_Purchaserequisitionitem	CreationDate	Time Stamp
	ProcessingStatus	I_Purchaserequisitionitem	ProcessingStatus	Worklist Status
	ExternalApprovalStatus	I_Purchaserequisitionitem	ExternalApprovalStatus	Ext Prcsng. Status
	SupplierendasSupplier
	IsDeleted	I_Purchaserequisitionitem	IsDeleted	TRUE
	FixedSupplierendasFixedSupplier
	RequisitionerName	I_Purchaserequisitionitem	RequisitionerName	Requisitioner
	CreatedByUser	I_Purchaserequisitionitem	CreatedByUser	User Name
	PurReqCreationDate	I_Purchaserequisitionitem	PurReqCreationDate	Requisn Date
	AddressIDelseendasDeliveryAddressID
	ManualDeliveryAddressID	I_Purchaserequisitionitem	ManualDeliveryAddressID	Address Number
	PurReqnItemCurrency	I_Purchaserequisitionitem	PurReqnItemCurrency	Currency
	MaterialPlannedDeliveryDurn	I_Purchaserequisitionitem	MaterialPlannedDeliveryDurn	Pl. Deliv. Time
	DelivDateCategory	I_Purchaserequisitionitem	DelivDateCategory	Delivery Date
	MultipleAcctAssgmtDistribution	I_Purchaserequisitionitem	MultipleAcctAssgmtDistribution	Distribution
	StorageLocationendasStorageLocation
	PurReqnSSPRequestor	I_Purchaserequisitionitem	PurReqnSSPRequestor	Requestor
	PurReqnSSPAuthor	I_Purchaserequisitionitem	PurReqnSSPAuthor	Author
	PurchaseContractendasPurchaseContract
	PurReqnSourceOfSupplyType	I_Purchaserequisitionitem	PurReqnSourceOfSupplyType	Doc. Category
	ConsumptionPosting	I_Purchaserequisitionitem	ConsumptionPosting	Consumption Posting
	PurReqnOrigin	I_Purchaserequisitionitem	PurReqnOrigin	Creation ind.
	PurReqnSSPCatalog	I_Purchaserequisitionitem	PurReqnSSPCatalog	Web Service ID
	PurReqnSSPCatalogItem	I_Purchaserequisitionitem	PurReqnSSPCatalogItem	Catalog Item
	PurReqnSSPCrossCatalogItem	I_Purchaserequisitionitem	PurReqnSSPCrossCatalogItem	Catalog item key
	IsPurReqnBlocked	I_Purchaserequisitionitem	IsPurReqnBlocked	Blocking Ind.
	ItemDeliveryAddressID	I_Purchaserequisitionitem	ItemDeliveryAddressID	Address
	Language	I_Purchaserequisitionitem	Language	Report Text Language
	IsClosed	I_Purchaserequisitionitem	IsClosed	Closed
	ReleaseIsNotCompleted	I_Purchaserequisitionitem	ReleaseIsNotCompleted	Subj.to Release
	ServicePerformer	I_Purchaserequisitionitem	ServicePerformer	Service Performer
	ProductType	I_Purchaserequisitionitem	ProductType	Product Type Group
	PurchaseRequisitionStatus	I_Purchaserequisitionitem	PurchaseRequisitionStatus	Release State
	ReleaseStrategy	I_Purchaserequisitionitem	ReleaseStrategy	Rel. strategy
	PerformancePeriodStartDate	I_Purchaserequisitionitem	PerformancePeriodStartDate	Start of Performance Period
	PerformancePeriodEndDate	I_Purchaserequisitionitem	PerformancePeriodEndDate	End of Performance Period
	PurchaseOrderPriceType	I_Purchaserequisitionitem	PurchaseOrderPriceType	PO price
	SupplierMaterialNumber	I_Purchaserequisitionitem	SupplierMaterialNumber	Supp. Mat. No.
	Batch	I_Purchaserequisitionitem	Batch	Lot No.
	MaterialRevisionLevel
	MinRemainingShelfLife	I_Purchaserequisitionitem	MinRemainingShelfLife	Rem. Shelf Life
	ItemNetAmount	I_Purchaserequisitionitem	ItemNetAmount	Tot. val. rel.
	GoodsReceiptIsExpected	I_Purchaserequisitionitem	GoodsReceiptIsExpected	Goods Receipt
	InvoiceIsExpected	I_Purchaserequisitionitem	InvoiceIsExpected	Invoice Receipt
	GoodsReceiptIsNonValuated	I_Purchaserequisitionitem	GoodsReceiptIsNonValuated	GR Non-Valuated
	RequirementTracking	I_Purchaserequisitionitem	RequirementTracking	Tracking Number
	MRPController	I_Purchaserequisitionitem	MRPController	MRP Controller
	TaxCode	I_Purchaserequisitionitem	TaxCode	Tax Code
	PurchaseRequisitionIsFixed	I_Purchaserequisitionitem	PurchaseRequisitionIsFixed	"Fixed" ind.
	AddressID	I_Purchaserequisitionitem	AddressID	Ship-to address
	LastChangeDateTime	I_Purchaserequisitionitem	LastChangeDateTime	Timestamp
	Reservation	I_Purchaserequisitionitem	Reservation	Reservation
	ExpectedOverallLimitAmount	I_Purchaserequisitionitem	ExpectedOverallLimitAmount	Expected Value
	OverallLimitAmount	I_Purchaserequisitionitem	OverallLimitAmount	Overall Limit
	PurContractForOverallLimit	I_Purchaserequisitionitem	PurContractForOverallLimit	Contract For Limit
	PurContractItemForOverallLimit	I_Purchaserequisitionitem	PurContractItemForOverallLimit	PurCon Itm for Limit
	PurReqnExternalReference	I_Purchaserequisitionitem	PurReqnExternalReference	Purchase Req.
	PurReqnItemExternalReference	I_Purchaserequisitionitem	PurReqnItemExternalReference	Requisn. item
	PurReqnExternalSystemId	I_Purchaserequisitionitem	PurReqnExternalSystemId	External System ID
	PurReqnExternalSystemType	I_Purchaserequisitionitem	PurReqnExternalSystemType	External System Type
	PurReqnTypeExternalReference	I_Purchaserequisitionitem	PurReqnTypeExternalReference	Ext. Document Type
	PurReqnProcessingType	I_Purchaserequisitionitem	PurReqnProcessingType	Processing State
	PurReqnProcessingDateTime	I_Purchaserequisitionitem	PurReqnProcessingDateTime	Timestamp
	ExtMaterialForPurg	I_Purchaserequisitionitem	ExtMaterialForPurg	Material
	ExtFixedSupplierForPurg	I_Purchaserequisitionitem	ExtFixedSupplierForPurg	Fixed Supplier
	ExtDesiredSupplierForPurg	I_Purchaserequisitionitem	ExtDesiredSupplierForPurg	Desired Supplier
	ExtContractForPurg	I_Purchaserequisitionitem	ExtContractForPurg	Contract
	ExtContractItemForPurg	I_Purchaserequisitionitem	ExtContractItemForPurg	Item
	ExtInfoRecordForPurg	I_Purchaserequisitionitem	ExtInfoRecordForPurg	Info Record
	ExtPlantForPurg	I_Purchaserequisitionitem	ExtPlantForPurg	Plant
	ProcmtHubStorageLocation	I_Purchaserequisitionitem	ProcmtHubStorageLocation
	ExtCompanyCodeForPurg	I_Purchaserequisitionitem	ExtCompanyCodeForPurg	Company Code
	ExtPurgOrgForPurg	I_Purchaserequisitionitem	ExtPurgOrgForPurg	Purch. Organization
	ProcurementHubSourceSystem	I_Purchaserequisitionitem	ProcurementHubSourceSystem	Connected System ID
	ProcmtHubBackendBusSyst	I_Purchaserequisitionitem	ProcmtHubBackendBusSyst
	SSPAuthorExternalBPIdnNumber	I_Purchaserequisitionitem	SSPAuthorExternalBPIdnNumber	Author
	SSPReqrUserId	I_Purchaserequisitionitem	SSPReqrUserId
	IsOutline	I_Purchaserequisitionitem	IsOutline	Item Set
	PurchasingParentItem	I_Purchaserequisitionitem	PurchasingParentItem	Parent Item No
	PurgConfigurableItemNumber	I_Purchaserequisitionitem	PurgConfigurableItemNumber	Hierarchy Number
	PurgExternalSortNumber	I_Purchaserequisitionitem	PurgExternalSortNumber	External Sort No.
	_PurchaseReqn		_PurchaseReqn
	_PurchaseReqnAcctAssgmt		_PurchaseReqnAcctAssgmt
	_PurchaseReqnDeliveryAddress		_PurchaseReqnDeliveryAddress
	_PurchaseReqnItemText		_PurchaseReqnItemText

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 A_PurchaseRequisitionItem.
-- 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: APURREQITM

CREATE VIEW A_PurchaseRequisitionItem AS
SELECT
  I_Purchaserequisitionitem.PurchaseRequisition AS PurchaseRequisition,
  I_Purchaserequisitionitem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_Purchaserequisitionitem.PurchasingDocument AS PurchasingDocument,
  I_Purchaserequisitionitem.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_Purchaserequisitionitem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  I_Purchaserequisitionitem.PurchaseRequisitionType AS PurchaseRequisitionType,
  I_Purchaserequisitionitem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  I_Purchaserequisitionitem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  I_Purchaserequisitionitem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  I_Purchaserequisitionitem.AccountAssignmentCategory AS AccountAssignmentCategory,
  case I_Purchaserequisitionitem.Material when '' then I_Purchaserequisitionitem.ExtMaterialForPurg else I_Purchaserequisitionitem.Material end as Material AS MaterialendasMaterial,
  I_Purchaserequisitionitem.MaterialGroup AS MaterialGroup,
  I_Purchaserequisitionitem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_Purchaserequisitionitem.RequestedQuantity AS RequestedQuantity,
  I_Purchaserequisitionitem.BaseUnit AS BaseUnit,
  I_Purchaserequisitionitem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  I_Purchaserequisitionitem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  I_Purchaserequisitionitem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  I_Purchaserequisitionitem.ReleaseCode AS ReleaseCode,
  I_Purchaserequisitionitem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  I_Purchaserequisitionitem.PurchasingGroup AS PurchasingGroup,
  case I_Purchaserequisitionitem.Plant when '' then I_Purchaserequisitionitem.ExtPlantForPurg else I_Purchaserequisitionitem.Plant end as Plant AS PlantendasPlant,
  case I_Purchaserequisitionitem.ExtCompanyCodeForPurg when '' then I_Purchaserequisitionitem.CompanyCode else I_Purchaserequisitionitem.ExtCompanyCodeForPurg end as CompanyCode AS ExtCompanyCodeForPurgendasCompanyCode,
  I_Purchaserequisitionitem.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  I_Purchaserequisitionitem.SupplyingPlant AS SupplyingPlant,
  I_Purchaserequisitionitem.OrderedQuantity AS OrderedQuantity,
  I_Purchaserequisitionitem.DeliveryDate AS DeliveryDate,
  I_Purchaserequisitionitem.CreationDate AS CreationDate,
  I_Purchaserequisitionitem.ProcessingStatus AS ProcessingStatus,
  I_Purchaserequisitionitem.ExternalApprovalStatus AS ExternalApprovalStatus,
  case I_Purchaserequisitionitem.Supplier when '' then I_Purchaserequisitionitem.ExtDesiredSupplierForPurg else I_Purchaserequisitionitem.Supplier end as Supplier AS SupplierendasSupplier,
  I_Purchaserequisitionitem.IsDeleted AS IsDeleted,
  case I_Purchaserequisitionitem.FixedSupplier when '' then I_Purchaserequisitionitem.ExtFixedSupplierForPurg else I_Purchaserequisitionitem.FixedSupplier end as FixedSupplier AS FixedSupplierendasFixedSupplier,
  I_Purchaserequisitionitem.RequisitionerName AS RequisitionerName,
  I_Purchaserequisitionitem.CreatedByUser AS CreatedByUser,
  I_Purchaserequisitionitem.PurReqCreationDate AS PurReqCreationDate,
  case when I_Purchaserequisitionitem.ManualDeliveryAddressID <> '' then I_Purchaserequisitionitem.ManualDeliveryAddressID when I_Purchaserequisitionitem.ItemDeliveryAddressID <> '' then I_Purchaserequisitionitem.ItemDeliveryAddressID when I_Purchaserequisitionitem.Subcontractor <> '' then _Subcontractor.AddressID when I_Purchaserequisitionitem.PurReqnReceivingCustomer <> '' then _Customer.AddressID when I_Purchaserequisitionitem.ManualDeliveryAddressID = '' and I_Purchaserequisitionitem.ItemDeliveryAddressID = '' and Subcontractor = '' and PurReqnReceivingCustomer = '' and PurchasingDocumentItemCategory <> '5' then _Plant.AddressID else '' end as DeliveryAddressID AS AddressIDelseendasDeliveryAddressID,
  I_Purchaserequisitionitem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  I_Purchaserequisitionitem.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_Purchaserequisitionitem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  I_Purchaserequisitionitem.DelivDateCategory AS DelivDateCategory,
  I_Purchaserequisitionitem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  case I_Purchaserequisitionitem.StorageLocation when '' then I_Purchaserequisitionitem.ProcmtHubStorageLocation else I_Purchaserequisitionitem.StorageLocation end as StorageLocation AS StorageLocationendasStorageLocation,
  I_Purchaserequisitionitem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  I_Purchaserequisitionitem.PurReqnSSPAuthor AS PurReqnSSPAuthor,
  case I_Purchaserequisitionitem.PurchaseContract when '' then I_Purchaserequisitionitem.ExtContractForPurg else I_Purchaserequisitionitem.PurchaseContract end as PurchaseContract AS PurchaseContractendasPurchaseContract,
  I_Purchaserequisitionitem.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  I_Purchaserequisitionitem.ConsumptionPosting AS ConsumptionPosting,
  I_Purchaserequisitionitem.PurReqnOrigin AS PurReqnOrigin,
  I_Purchaserequisitionitem.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  I_Purchaserequisitionitem.PurReqnSSPCatalogItem AS PurReqnSSPCatalogItem,
  I_Purchaserequisitionitem.PurReqnSSPCrossCatalogItem AS PurReqnSSPCrossCatalogItem,
  I_Purchaserequisitionitem.IsPurReqnBlocked AS IsPurReqnBlocked,
  I_Purchaserequisitionitem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  I_Purchaserequisitionitem.Language AS Language,
  I_Purchaserequisitionitem.IsClosed AS IsClosed,
  I_Purchaserequisitionitem.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  I_Purchaserequisitionitem.ServicePerformer AS ServicePerformer,
  I_Purchaserequisitionitem.ProductType AS ProductType,
  I_Purchaserequisitionitem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  I_Purchaserequisitionitem.ReleaseStrategy AS ReleaseStrategy,
  I_Purchaserequisitionitem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_Purchaserequisitionitem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_Purchaserequisitionitem.PurchaseOrderPriceType AS PurchaseOrderPriceType,
  I_Purchaserequisitionitem.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_Purchaserequisitionitem.Batch AS Batch,
  cast( I_Purchaserequisitionitem.MaterialRevisionLevel as revlv ) AS MaterialRevisionLevel,
  I_Purchaserequisitionitem.MinRemainingShelfLife AS MinRemainingShelfLife,
  I_Purchaserequisitionitem.ItemNetAmount AS ItemNetAmount,
  I_Purchaserequisitionitem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  I_Purchaserequisitionitem.InvoiceIsExpected AS InvoiceIsExpected,
  I_Purchaserequisitionitem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  I_Purchaserequisitionitem.RequirementTracking AS RequirementTracking,
  I_Purchaserequisitionitem.MRPController AS MRPController,
  I_Purchaserequisitionitem.TaxCode AS TaxCode,
  I_Purchaserequisitionitem.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  I_Purchaserequisitionitem.AddressID AS AddressID,
  I_Purchaserequisitionitem.LastChangeDateTime AS LastChangeDateTime,
  I_Purchaserequisitionitem.Reservation AS Reservation,
  I_Purchaserequisitionitem.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  I_Purchaserequisitionitem.OverallLimitAmount AS OverallLimitAmount,
  I_Purchaserequisitionitem.PurContractForOverallLimit AS PurContractForOverallLimit,
  I_Purchaserequisitionitem.PurContractItemForOverallLimit AS PurContractItemForOverallLimit,
  I_Purchaserequisitionitem.PurReqnExternalReference AS PurReqnExternalReference,
  I_Purchaserequisitionitem.PurReqnItemExternalReference AS PurReqnItemExternalReference,
  I_Purchaserequisitionitem.PurReqnExternalSystemId AS PurReqnExternalSystemId,
  I_Purchaserequisitionitem.PurReqnExternalSystemType AS PurReqnExternalSystemType,
  I_Purchaserequisitionitem.PurReqnTypeExternalReference AS PurReqnTypeExternalReference,
  I_Purchaserequisitionitem.PurReqnProcessingType AS PurReqnProcessingType,
  I_Purchaserequisitionitem.PurReqnProcessingDateTime AS PurReqnProcessingDateTime,
  I_Purchaserequisitionitem.ExtMaterialForPurg AS ExtMaterialForPurg,
  I_Purchaserequisitionitem.ExtFixedSupplierForPurg AS ExtFixedSupplierForPurg,
  I_Purchaserequisitionitem.ExtDesiredSupplierForPurg AS ExtDesiredSupplierForPurg,
  I_Purchaserequisitionitem.ExtContractForPurg AS ExtContractForPurg,
  I_Purchaserequisitionitem.ExtContractItemForPurg AS ExtContractItemForPurg,
  I_Purchaserequisitionitem.ExtInfoRecordForPurg AS ExtInfoRecordForPurg,
  I_Purchaserequisitionitem.ExtPlantForPurg AS ExtPlantForPurg,
  I_Purchaserequisitionitem.ProcmtHubStorageLocation AS ProcmtHubStorageLocation,
  I_Purchaserequisitionitem.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  I_Purchaserequisitionitem.ExtPurgOrgForPurg AS ExtPurgOrgForPurg,
  I_Purchaserequisitionitem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  I_Purchaserequisitionitem.ProcmtHubBackendBusSyst AS ProcmtHubBackendBusSyst,
  I_Purchaserequisitionitem.SSPAuthorExternalBPIdnNumber AS SSPAuthorExternalBPIdnNumber,
  I_Purchaserequisitionitem.SSPReqrUserId AS SSPReqrUserId,
  I_Purchaserequisitionitem.IsOutline AS IsOutline,
  I_Purchaserequisitionitem.PurchasingParentItem AS PurchasingParentItem,
  I_Purchaserequisitionitem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  I_Purchaserequisitionitem.PurgExternalSortNumber AS PurgExternalSortNumber
FROM I_Purchaserequisitionitem
LEFT OUTER JOIN A_PurchaseRequisitionHeader AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN A_PurReqnAcctAssgmt AS _PurchaseReqnAcctAssgmt ON _PurchaseReqnAcctAssgmt.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnAcctAssgmt.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN A_PurReqAddDelivery AS _PurchaseReqnDeliveryAddress ON _PurchaseReqnDeliveryAddress.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnDeliveryAddress.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN A_PurchaseReqnItemText AS _PurchaseReqnItemText ON _PurchaseReqnItemText.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItemText.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Subcontractor ON I_Purchaserequisitionitem.Subcontractor = _Subcontractor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON I_Purchaserequisitionitem.PurReqnReceivingCustomer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN E_Purchaserequisitionitem AS _PurchaseReqnItemExtension ON _PurchaseReqnItemExtension.PurchaseRequisition = PurchaseRequisition AND _PurchaseReqnItemExtension.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
;

Depth:

A_PurchaseRequisitionItem view

I_Purchaserequisitionitem view