What is P_Purrequisitionitem in SAP S/4HANA?

P_Purrequisitionitem is a composite CDS view in SAP S/4HANA. It contains 140 fields.

Which tables does P_Purrequisitionitem read from?

P_Purrequisitionitem reads data from: I_Purreqnsspitem.

What VDM layer is P_Purrequisitionitem?

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

P_Purrequisitionitem

DDL: P_PURREQUISITIONITEM SQL: PPRSSPITEMEXT Type: view COMPOSITE

140 Fields 1 Data Sources

P_Purrequisitionitem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Purreqnsspitem) and exposes 140 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (1)

Source	Alias	Join Type
I_Purreqnsspitem	I_Purreqnsspitem	from

Annotations (9)

Name	Value	Level
VDM.private	true	view
VDM.viewType	#COMPOSITE	view
AbapCatalog.sqlViewName	PPRSSPITEMEXT	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	PurchaseRequisitionItem	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (140)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseRequisition	I_Purreqnsspitem	PurchaseRequisition	Requisition
KEY	PurchaseRequisitionItem	I_Purreqnsspitem	PurchaseRequisitionItem	Requisn. item
	PurchasingDocument	I_Purreqnsspitem	PurchasingDocument	Purchasing Document
	PurchasingDocumentItem	I_Purreqnsspitem	PurchasingDocumentItem	Purchasing Doc. Item
	PurReqnReleaseStatus	I_Purreqnsspitem	PurReqnReleaseStatus	Proc.state
	PurchaseRequisitionType	I_Purreqnsspitem	PurchaseRequisitionType	Order Type
	PurchasingDocumentItemCategory	I_Purreqnsspitem	PurchasingDocumentItemCategory	Item Category
	PurchaseRequisitionItemText	I_Purreqnsspitem	PurchaseRequisitionItemText	Short Text
	AccountAssignmentCategory	I_Purreqnsspitem	AccountAssignmentCategory	Acct Assgmt Cat
	Material	I_Purreqnsspitem	Material	Vehicle Model
	MaterialGroup	I_Purreqnsspitem	MaterialGroup	Product Group
	PurchasingDocumentCategory	I_Purreqnsspitem	PurchasingDocumentCategory	Doc. Category
	RequestedQuantity	I_Purreqnsspitem	RequestedQuantity	Requested Quantity
	BaseUnit	I_Purreqnsspitem	BaseUnit	Unit of Measure
	PurchaseRequisitionPrice	I_Purreqnsspitem	PurchaseRequisitionPrice	Valuation Price
	PurReqnPriceQuantity	I_Purreqnsspitem	PurReqnPriceQuantity	Price unit
	MaterialGoodsReceiptDuration	I_Purreqnsspitem	MaterialGoodsReceiptDuration	GR proc. time
	ReleaseCode	I_Purreqnsspitem	ReleaseCode	Release ind.
	PurchaseRequisitionReleaseDate	I_Purreqnsspitem	PurchaseRequisitionReleaseDate	Release Date
	PurchasingOrganization	I_Purreqnsspitem	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	I_Purreqnsspitem	PurchasingGroup	Purchasing Group
	Plant	I_Purreqnsspitem	Plant	Valuation Area
	SourceOfSupplyIsAssigned	I_Purreqnsspitem	SourceOfSupplyIsAssigned	Assigned
	SupplyingPlant	I_Purreqnsspitem	SupplyingPlant	Supplying Plant
	OrderedQuantity	I_Purreqnsspitem	OrderedQuantity	Quantity
	DeliveryDate	I_Purreqnsspitem	DeliveryDate	Delivery Date
	CreationDate	I_Purreqnsspitem	CreationDate	Time Stamp
	ProcessingStatus	I_Purreqnsspitem	ProcessingStatus	Worklist Status
	PurchasingInfoRecord	I_Purreqnsspitem	PurchasingInfoRecord	Info Record
	Supplier	I_Purreqnsspitem	Supplier	Supplier
	IsDeleted	I_Purreqnsspitem	IsDeleted	TRUE
	FixedSupplier	I_Purreqnsspitem	FixedSupplier	Fixed Vendor
	RequisitionerName	I_Purreqnsspitem	RequisitionerName	Requisitioner
	CreatedByUser	I_Purreqnsspitem	CreatedByUser	User Name
	PurReqCreationDate	I_Purreqnsspitem	PurReqCreationDate	Requisn Date
	ManualDeliveryAddressID	I_Purreqnsspitem	ManualDeliveryAddressID	Address Number
	PlantAddressID	I_Purreqnsspitem	PlantAddressID	Address
	PurReqnItemCurrency	I_Purreqnsspitem	PurReqnItemCurrency	Currency
	MaterialPlannedDeliveryDurn	I_Purreqnsspitem	MaterialPlannedDeliveryDurn	Pl. Deliv. Time
	DelivDateCategory	I_Purreqnsspitem	DelivDateCategory	Delivery Date
	MultipleAcctAssgmtDistribution	I_Purreqnsspitem	MultipleAcctAssgmtDistribution	Distribution
	StorageLocation	I_Purreqnsspitem	StorageLocation	StorageLocation
	PurReqnSSPRequestor	I_Purreqnsspitem	PurReqnSSPRequestor	Requestor
	PurReqnSSPAuthor	I_Purreqnsspitem	PurReqnSSPAuthor	Author
	PurchaseContract	I_Purreqnsspitem	PurchaseContract	Purchasing Doc.
	PurReqnSourceOfSupplyType	I_Purreqnsspitem	PurReqnSourceOfSupplyType	Doc. Category
	PurchaseContractItem	I_Purreqnsspitem	PurchaseContractItem	Item
	ConsumptionPosting	I_Purreqnsspitem	ConsumptionPosting	Consumption Posting
	PurReqnOrigin	I_Purreqnsspitem	PurReqnOrigin	Creation ind.
	PurReqnSSPCatalog	I_Purreqnsspitem	PurReqnSSPCatalog	Web Service ID
	PurReqnSSPCatalogItem	I_Purreqnsspitem	PurReqnSSPCatalogItem	Catalog Item
	PurReqnSSPCrossCatalogItem	I_Purreqnsspitem	PurReqnSSPCrossCatalogItem	Catalog item key
	IsPurReqnBlocked	I_Purreqnsspitem	IsPurReqnBlocked	Blocking Ind.
	ItemDeliveryAddressID	I_Purreqnsspitem	ItemDeliveryAddressID	Address
	Language	I_Purreqnsspitem	Language	Report Text Language
	IsClosed	I_Purreqnsspitem	IsClosed	Closed
	ReleaseIsNotCompleted	I_Purreqnsspitem	ReleaseIsNotCompleted	Subj.to Release
	ServicePerformer	I_Purreqnsspitem	ServicePerformer	Service Performer
	ProductType	I_Purreqnsspitem	ProductType	Product Type Group
	PurchaseRequisitionStatus	I_Purreqnsspitem	PurchaseRequisitionStatus	Release State
	ReleaseStrategy	I_Purreqnsspitem	ReleaseStrategy	Rel. strategy
	PerformancePeriodStartDate	I_Purreqnsspitem	PerformancePeriodStartDate	Start of Performance Period
	PerformancePeriodEndDate	I_Purreqnsspitem	PerformancePeriodEndDate	End of Performance Period
	CompanyCode	I_Purreqnsspitem	CompanyCode	Receiver Company Code
	SupplierMaterialNumber	I_Purreqnsspitem	SupplierMaterialNumber	Supp. Mat. No.
	Batch	I_Purreqnsspitem	Batch	Lot No.
	MaterialRevisionLevel	I_Purreqnsspitem	MaterialRevisionLevel	Revision Level
	MinRemainingShelfLife	I_Purreqnsspitem	MinRemainingShelfLife	Rem. Shelf Life
	ItemNetAmount	I_Purreqnsspitem	ItemNetAmount	Tot. val. rel.
	GoodsReceiptIsExpected	I_Purreqnsspitem	GoodsReceiptIsExpected	Goods Receipt
	InvoiceIsExpected	I_Purreqnsspitem	InvoiceIsExpected	Invoice Receipt
	GoodsReceiptIsNonValuated	I_Purreqnsspitem	GoodsReceiptIsNonValuated	GR Non-Valuated
	RequirementTracking	I_Purreqnsspitem	RequirementTracking	Tracking Number
	MRPController	I_Purreqnsspitem	MRPController	MRP Controller
	PurchaseRequisitionIsFixed	I_Purreqnsspitem	PurchaseRequisitionIsFixed	"Fixed" ind.
	IsPurReqnCmplt	I_Purreqnsspitem	IsPurReqnCmplt	Incomplete
	PurReqnCmpltnsCat	I_Purreqnsspitem	PurReqnCmpltnsCat	Incompl. Cat.
	Reservation	I_Purreqnsspitem	Reservation	Reservation
	ExtMaterialForPurg	I_Purreqnsspitem	ExtMaterialForPurg	Material
	ExtFixedSupplierForPurg	I_Purreqnsspitem	ExtFixedSupplierForPurg	Fixed Supplier
	ExtDesiredSupplierForPurg	I_Purreqnsspitem	ExtDesiredSupplierForPurg	Desired Supplier
	ExtContractForPurg	I_Purreqnsspitem	ExtContractForPurg	Contract
	ExtContractItemForPurg	I_Purreqnsspitem	ExtContractItemForPurg	Item
	ExtInfoRecordForPurg	I_Purreqnsspitem	ExtInfoRecordForPurg	Info Record
	ExtPlantForPurg	I_Purreqnsspitem	ExtPlantForPurg	Plant
	ProcmtHubStorageLocation	I_Purreqnsspitem	ProcmtHubStorageLocation
	ExtCompanyCodeForPurg	I_Purreqnsspitem	ExtCompanyCodeForPurg	Company Code
	ExtPurgOrgForPurg	I_Purreqnsspitem	ExtPurgOrgForPurg	Purch. Organization
	ExtSourceSystem	I_Purreqnsspitem	ExtSourceSystem	Connected System ID
	Manufacturer	I_Purreqnsspitem	Manufacturer	Manufacturer
	ManufacturerPartNmbr	I_Purreqnsspitem	ManufacturerPartNmbr	Mfr Part Number
	ManufacturerMaterial	I_Purreqnsspitem	ManufacturerMaterial	MPN: Material
	ExtContractForOverallLimit	I_Purreqnsspitem	ExtContractForOverallLimit
	ExtContractItemForOverallLimit	I_Purreqnsspitem	ExtContractItemForOverallLimit
	ExternalApprovalStatus	I_Purreqnsspitem	ExternalApprovalStatus	Ext Prcsng. Status
	ExtPurchaseRequisitionType	I_Purreqnsspitem	ExtPurchaseRequisitionType	PR DocTyp of ConnSys
	ProcmtHubRefDeliveryAddressID	I_Purreqnsspitem	ProcmtHubRefDeliveryAddressID
	ProcurementHubSourceSystem	I_Purreqnsspitem	ProcurementHubSourceSystem	Connected System ID
	BusinessUser	I_Purreqnsspitem	BusinessUser	User Name
	IsActiveEntity
	PurReqnIsValdInCntrlReqnProcg	I_Purreqnsspitem	PurReqnIsValdInCntrlReqnProcg	Is Central PR Procg.
	_AccAssgnmtCategory	I_Purreqnsspitem	_AccAssgnmtCategory
	DeliveryAddressID	I_Purreqnsspitem	DeliveryAddressID	Address
	_Address	I_Purreqnsspitem	_Address
	_CurrentDfltFaxNumber	I_Purreqnsspitem	_CurrentDfltFaxNumber
	_CurrentDfltEmailAddress	I_Purreqnsspitem	_CurrentDfltEmailAddress
	_PhoneNumber	I_Purreqnsspitem	_PhoneNumber
	_CalcFields	I_Purreqnsspitem	_CalcFields
	_Currency	I_Purreqnsspitem	_Currency
	_Material	I_Purreqnsspitem	_Material
	_MaterialGroup	I_Purreqnsspitem	_MaterialGroup
	_Plant	I_Purreqnsspitem	_Plant
	_PurchaseOrder	I_Purreqnsspitem	_PurchaseOrder
	_PurchaseRequisition	I_Purreqnsspitem	_PurchaseRequisition
	_PurchasingDocumentType	I_Purreqnsspitem	_PurchasingDocumentType
	_PurchasingGroup	I_Purreqnsspitem	_PurchasingGroup
	_PurchasingInfoRecord	I_Purreqnsspitem	_PurchasingInfoRecord
	_PurchasingOrganization	I_Purreqnsspitem	_PurchasingOrganization
	_PurReqnAcctAssgmt	I_Purreqnsspitem	_PurReqnAcctAssgmt
	_StorageLocation	I_Purreqnsspitem	_StorageLocation
	_Supplier	I_Purreqnsspitem	_Supplier
	_SupplyingPlant	I_Purreqnsspitem	_SupplyingPlant
	_UnitOfMeasure	I_Purreqnsspitem	_UnitOfMeasure
	ExpectedOverallLimitAmount	I_Purreqnsspitem	ExpectedOverallLimitAmount	Expected Value
	OverallLimitAmount	I_Purreqnsspitem	OverallLimitAmount	Overall Limit
	CommitmentItem
	FundsCenter	I_Purreqnsspitem	FundsCenter	Funds Center
	Fund	I_Purreqnsspitem	Fund	Sender Fund
	GrantID	I_Purreqnsspitem	GrantID	Sender Grant
	FunctionalArea	I_Purreqnsspitem	FunctionalArea	Sendr Fctl Area
	EarmarkedFundsDocument	I_Purreqnsspitem	EarmarkedFundsDocument	Earmarked Funds
	EarmarkedFundsDocumentItem	I_Purreqnsspitem	EarmarkedFundsDocumentItem	Document Item
	BudgetPeriod	I_Purreqnsspitem	BudgetPeriod	Budget Period
	CostCenter	I_Purreqnsspitem	CostCenter	Cost Center
	GLAccount	I_Purreqnsspitem	GLAccount	General Ledger
	FundedProgram	I_Purreqnsspitem	FundedProgram	Funded Program
	PurchaseOrderPriceType	I_Purreqnsspitem	PurchaseOrderPriceType	PO price
	TaxCode	I_Purreqnsspitem	TaxCode	Tax Code
	PurchaseReqnItemUniqueID	I_Purreqnsspitem	PurchaseReqnItemUniqueID	Purch. Doc. ID
	CntrlReqnIsRpldBfrApprvl	I_Purreqnsspitem	CntrlReqnIsRpldBfrApprvl

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 P_Purrequisitionitem.
-- 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: PPRSSPITEMEXT

CREATE VIEW P_Purrequisitionitem AS
SELECT
  I_Purreqnsspitem.PurchaseRequisition AS PurchaseRequisition,
  I_Purreqnsspitem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_Purreqnsspitem.PurchasingDocument AS PurchasingDocument,
  I_Purreqnsspitem.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_Purreqnsspitem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  I_Purreqnsspitem.PurchaseRequisitionType AS PurchaseRequisitionType,
  I_Purreqnsspitem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  I_Purreqnsspitem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  I_Purreqnsspitem.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_Purreqnsspitem.Material AS Material,
  I_Purreqnsspitem.MaterialGroup AS MaterialGroup,
  I_Purreqnsspitem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_Purreqnsspitem.RequestedQuantity AS RequestedQuantity,
  I_Purreqnsspitem.BaseUnit AS BaseUnit,
  I_Purreqnsspitem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  I_Purreqnsspitem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  I_Purreqnsspitem.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  I_Purreqnsspitem.ReleaseCode AS ReleaseCode,
  I_Purreqnsspitem.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  I_Purreqnsspitem.PurchasingOrganization AS PurchasingOrganization,
  I_Purreqnsspitem.PurchasingGroup AS PurchasingGroup,
  I_Purreqnsspitem.Plant AS Plant,
  I_Purreqnsspitem.SourceOfSupplyIsAssigned AS SourceOfSupplyIsAssigned,
  I_Purreqnsspitem.SupplyingPlant AS SupplyingPlant,
  I_Purreqnsspitem.OrderedQuantity AS OrderedQuantity,
  I_Purreqnsspitem.DeliveryDate AS DeliveryDate,
  I_Purreqnsspitem.CreationDate AS CreationDate,
  I_Purreqnsspitem.ProcessingStatus AS ProcessingStatus,
  I_Purreqnsspitem.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_Purreqnsspitem.Supplier AS Supplier,
  I_Purreqnsspitem.IsDeleted AS IsDeleted,
  I_Purreqnsspitem.FixedSupplier AS FixedSupplier,
  I_Purreqnsspitem.RequisitionerName AS RequisitionerName,
  I_Purreqnsspitem.CreatedByUser AS CreatedByUser,
  I_Purreqnsspitem.PurReqCreationDate AS PurReqCreationDate,
  I_Purreqnsspitem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  I_Purreqnsspitem.PlantAddressID AS PlantAddressID,
  I_Purreqnsspitem.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_Purreqnsspitem.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  I_Purreqnsspitem.DelivDateCategory AS DelivDateCategory,
  I_Purreqnsspitem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  I_Purreqnsspitem.StorageLocation AS StorageLocation,
  I_Purreqnsspitem.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  I_Purreqnsspitem.PurReqnSSPAuthor AS PurReqnSSPAuthor,
  I_Purreqnsspitem.PurchaseContract AS PurchaseContract,
  I_Purreqnsspitem.PurReqnSourceOfSupplyType AS PurReqnSourceOfSupplyType,
  I_Purreqnsspitem.PurchaseContractItem AS PurchaseContractItem,
  I_Purreqnsspitem.ConsumptionPosting AS ConsumptionPosting,
  I_Purreqnsspitem.PurReqnOrigin AS PurReqnOrigin,
  I_Purreqnsspitem.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  I_Purreqnsspitem.PurReqnSSPCatalogItem AS PurReqnSSPCatalogItem,
  I_Purreqnsspitem.PurReqnSSPCrossCatalogItem AS PurReqnSSPCrossCatalogItem,
  I_Purreqnsspitem.IsPurReqnBlocked AS IsPurReqnBlocked,
  I_Purreqnsspitem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  I_Purreqnsspitem.Language AS Language,
  I_Purreqnsspitem.IsClosed AS IsClosed,
  I_Purreqnsspitem.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  I_Purreqnsspitem.ServicePerformer AS ServicePerformer,
  I_Purreqnsspitem.ProductType AS ProductType,
  I_Purreqnsspitem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  I_Purreqnsspitem.ReleaseStrategy AS ReleaseStrategy,
  I_Purreqnsspitem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_Purreqnsspitem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_Purreqnsspitem.CompanyCode AS CompanyCode,
  I_Purreqnsspitem.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_Purreqnsspitem.Batch AS Batch,
  I_Purreqnsspitem.MaterialRevisionLevel AS MaterialRevisionLevel,
  I_Purreqnsspitem.MinRemainingShelfLife AS MinRemainingShelfLife,
  I_Purreqnsspitem.ItemNetAmount AS ItemNetAmount,
  I_Purreqnsspitem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  I_Purreqnsspitem.InvoiceIsExpected AS InvoiceIsExpected,
  I_Purreqnsspitem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  I_Purreqnsspitem.RequirementTracking AS RequirementTracking,
  I_Purreqnsspitem.MRPController AS MRPController,
  I_Purreqnsspitem.PurchaseRequisitionIsFixed AS PurchaseRequisitionIsFixed,
  I_Purreqnsspitem.IsPurReqnCmplt AS IsPurReqnCmplt,
  I_Purreqnsspitem.PurReqnCmpltnsCat AS PurReqnCmpltnsCat,
  I_Purreqnsspitem.Reservation AS Reservation,
  I_Purreqnsspitem.ExtMaterialForPurg AS ExtMaterialForPurg,
  I_Purreqnsspitem.ExtFixedSupplierForPurg AS ExtFixedSupplierForPurg,
  I_Purreqnsspitem.ExtDesiredSupplierForPurg AS ExtDesiredSupplierForPurg,
  I_Purreqnsspitem.ExtContractForPurg AS ExtContractForPurg,
  I_Purreqnsspitem.ExtContractItemForPurg AS ExtContractItemForPurg,
  I_Purreqnsspitem.ExtInfoRecordForPurg AS ExtInfoRecordForPurg,
  I_Purreqnsspitem.ExtPlantForPurg AS ExtPlantForPurg,
  I_Purreqnsspitem.ProcmtHubStorageLocation AS ProcmtHubStorageLocation,
  I_Purreqnsspitem.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  I_Purreqnsspitem.ExtPurgOrgForPurg AS ExtPurgOrgForPurg,
  I_Purreqnsspitem.ExtSourceSystem AS ExtSourceSystem,
  I_Purreqnsspitem.Manufacturer AS Manufacturer,
  I_Purreqnsspitem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  I_Purreqnsspitem.ManufacturerMaterial AS ManufacturerMaterial,
  I_Purreqnsspitem.ExtContractForOverallLimit AS ExtContractForOverallLimit,
  I_Purreqnsspitem.ExtContractItemForOverallLimit AS ExtContractItemForOverallLimit,
  I_Purreqnsspitem.ExternalApprovalStatus AS ExternalApprovalStatus,
  I_Purreqnsspitem.ExtPurchaseRequisitionType AS ExtPurchaseRequisitionType,
  I_Purreqnsspitem.ProcmtHubRefDeliveryAddressID AS ProcmtHubRefDeliveryAddressID,
  I_Purreqnsspitem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  I_Purreqnsspitem.BusinessUser AS BusinessUser,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  I_Purreqnsspitem.PurReqnIsValdInCntrlReqnProcg AS PurReqnIsValdInCntrlReqnProcg,
  I_Purreqnsspitem._AccAssgnmtCategory AS _AccAssgnmtCategory,
  I_Purreqnsspitem.DeliveryAddressID AS DeliveryAddressID,
  I_Purreqnsspitem._Address AS _Address,
  I_Purreqnsspitem._CurrentDfltFaxNumber AS _CurrentDfltFaxNumber,
  I_Purreqnsspitem._CurrentDfltEmailAddress AS _CurrentDfltEmailAddress,
  I_Purreqnsspitem._PhoneNumber AS _PhoneNumber,
  I_Purreqnsspitem._CalcFields AS _CalcFields,
  I_Purreqnsspitem._Currency AS _Currency,
  I_Purreqnsspitem._Material AS _Material,
  I_Purreqnsspitem._MaterialGroup AS _MaterialGroup,
  I_Purreqnsspitem._Plant AS _Plant,
  I_Purreqnsspitem._PurchaseOrder AS _PurchaseOrder,
  I_Purreqnsspitem._PurchaseRequisition AS _PurchaseRequisition,
  I_Purreqnsspitem._PurchasingDocumentType AS _PurchasingDocumentType,
  I_Purreqnsspitem._PurchasingGroup AS _PurchasingGroup,
  I_Purreqnsspitem._PurchasingInfoRecord AS _PurchasingInfoRecord,
  I_Purreqnsspitem._PurchasingOrganization AS _PurchasingOrganization,
  I_Purreqnsspitem._PurReqnAcctAssgmt AS _PurReqnAcctAssgmt,
  I_Purreqnsspitem._StorageLocation AS _StorageLocation,
  I_Purreqnsspitem._Supplier AS _Supplier,
  I_Purreqnsspitem._SupplyingPlant AS _SupplyingPlant,
  I_Purreqnsspitem._UnitOfMeasure AS _UnitOfMeasure,
  I_Purreqnsspitem.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  I_Purreqnsspitem.OverallLimitAmount AS OverallLimitAmount,
  cast( I_Purreqnsspitem.CommitmentItemShortID as fipos ) AS CommitmentItem,
  I_Purreqnsspitem.FundsCenter AS FundsCenter,
  I_Purreqnsspitem.Fund AS Fund,
  I_Purreqnsspitem.GrantID AS GrantID,
  I_Purreqnsspitem.FunctionalArea AS FunctionalArea,
  I_Purreqnsspitem.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_Purreqnsspitem.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  I_Purreqnsspitem.BudgetPeriod AS BudgetPeriod,
  I_Purreqnsspitem.CostCenter AS CostCenter,
  I_Purreqnsspitem.GLAccount AS GLAccount,
  I_Purreqnsspitem.FundedProgram AS FundedProgram,
  I_Purreqnsspitem.PurchaseOrderPriceType AS PurchaseOrderPriceType,
  I_Purreqnsspitem.TaxCode AS TaxCode,
  I_Purreqnsspitem.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  I_Purreqnsspitem.CntrlReqnIsRpldBfrApprvl AS CntrlReqnIsRpldBfrApprvl
FROM I_Purreqnsspitem
;

Depth:

P_Purrequisitionitem view

I_Purreqnsspitem view

I_Purchaserequisitionitem_Wd view