What is I_RequestForQuotationItem in SAP S/4HANA?

I_RequestForQuotationItem is a basic CDS view in SAP S/4HANA. Request For Quotation Item It contains 46 fields.

Which tables does I_RequestForQuotationItem read from?

I_RequestForQuotationItem reads data from: R_PurchasingDocumentItem.

What VDM layer is I_RequestForQuotationItem?

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

I_RequestForQuotationItem

DDL: I_REQUESTFORQUOTATIONITEM SQL: IMMRFQITEM Type: view BASIC

46 Fields 1 Data Sources 6 Associations

Request For Quotation Item

I_RequestForQuotationItem is a Basic CDS View that provides data about "Request For Quotation Item" in SAP S/4HANA. It reads from 1 data source (R_PurchasingDocumentItem) and exposes 46 fields with key fields RequestForQuotation, RequestForQuotationItem. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
R_PurchasingDocumentItem	R_PurchasingDocumentItem	from

Associations (6)

Cardinality	Target	Alias	Condition
[1..1]	I_RequestForQuotation	_RequestForQuotation	`$projection.RequestForQuotation = _RequestForQuotation.RequestForQuotation`
[0..1]	I_PurchasingDocumentCategory	_PurchasingDocumentCategory	`$projection.PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory`
[0..1]	I_IncotermsClassification	_IncotermsClassification	`$projection.IncotermsClassification = _IncotermsClassification.IncotermsClassification`
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`
[0..1]	I_UnitOfMeasure	_OrderQuantityUnit	`$projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure`
[0..*]	I_SupplierQuotationItem	_SupplierQuotationItem	`$projection.RequestForQuotation = _SupplierQuotationItem.RequestForQuotation and $projection.RequestForQuotationItem = _SupplierQuotationItem.RequestForQuotationItem`

Annotations (11)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	RequestForQuotationItem	view
ObjectModel.semanticKey	RequestForQuotationItem	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
EndUserText.label	Request For Quotation Item	view
VDM.viewType	#BASIC	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
AbapCatalog.sqlViewName	IMMRFQITEM	view

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	RequestForQuotation	R_PurchasingDocumentItem	PurchasingDocument	Purchasing Document
KEY	RequestForQuotationItem
	PurchasingDocumentCategory	R_PurchasingDocumentItem	PurchasingDocumentCategory	Doc. Category
	PurchasingDocumentItemText	R_PurchasingDocumentItem	PurchasingDocumentItemText	Short Text
	Material	R_PurchasingDocumentItem	Material	Vehicle Model
	ProductType		ProductType	Product Type Group
	ManufacturerMaterial
	ManufacturerPartNmbr	R_PurchasingDocumentItem	ManufacturerPartNmbr	Mfr Part Number
	Manufacturer	R_PurchasingDocumentItem	Manufacturer	Manufacturer
	MaterialGroup	R_PurchasingDocumentItem	MaterialGroup	Product Group
	Plant	R_PurchasingDocumentItem	Plant	Valuation Area
	ManualDeliveryAddressID	R_PurchasingDocumentItem	ManualDeliveryAddressID	Address Number
	ReferenceDeliveryAddressID	R_PurchasingDocumentItem	ReferenceDeliveryAddressID	Reference Address
	IncotermsClassification	R_PurchasingDocumentItem	IncotermsClassification	Incoterms
	IncotermsTransferLocation	R_PurchasingDocumentItem	IncotermsTransferLocation	Incoterms 2
	IncotermsLocation1	R_PurchasingDocumentItem	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	R_PurchasingDocumentItem	IncotermsLocation2	Inco. Location2
	OrderQuantityUnit	R_PurchasingDocumentItem	OrderQuantityUnit	Sales Unit
	OrderItemQtyToBaseQtyNmrtr	R_PurchasingDocumentItem	OrderItemQtyToBaseQtyNmrtr	Equal To
	OrderItemQtyToBaseQtyDnmntr	R_PurchasingDocumentItem	OrderItemQtyToBaseQtyDnmntr	Denominator
	BaseUnit	R_PurchasingDocumentItem	BaseUnit	Unit of Measure
	PurchaseRequisition	R_PurchasingDocumentItem	PurchaseRequisition	Requisition
	PurchaseRequisitionItem	R_PurchasingDocumentItem	PurchaseRequisitionItem	Requisn. item
	IsInfoRecordUpdated	R_PurchasingDocumentItem	PurchasingInfoRecordUpdateCode	InfoUpdate
	RequirementTracking	R_PurchasingDocumentItem	RequirementTracking	Tracking Number
	PurchasingDocumentItemCategory	R_PurchasingDocumentItem	PurchasingDocumentItemCategory	Item Category
	PurchasingParentItem	R_PurchasingDocumentItem	PurchasingParentItem	Parent Item No
	PurgDocAggrgdSubitemCategory	R_PurchasingDocumentItem	PurgDocAggrgdSubitemCategory	Sub-items
	IsStatisticalItem	R_PurchasingDocumentItem	IsStatisticalItem	Statisticl.Indicator
	PurgExternalSortNumber	R_PurchasingDocumentItem	PurgExternalSortNumber	External Sort No.
	PurgConfigurableItemNumber	R_PurchasingDocumentItem	PurgConfigurableItemNumber	Hierarchy Number
	_RequestForQuotation		_RequestForQuotation
	_IncotermsClassification		_IncotermsClassification
	_PurchasingDocumentCategory		_PurchasingDocumentCategory
	_Material		_Material
	_ManufacturerMaterial		_ManufacturerMaterial
	_ProductType	R_PurchasingDocumentItem	_ProductType
	_Manufacturer		_Manufacturer
	_MaterialGroup		_MaterialGroup
	_Plant		_Plant
	_ManualDeliveryAddress_2		_ManualDeliveryAddress_2
	_ReferenceDeliveryAddress_2		_ReferenceDeliveryAddress_2
	_BaseUnit		_BaseUnit
	_OrderQuantityUnit		_OrderQuantityUnit
	_SupplierQuotationItem		_SupplierQuotationItem
	_PurgDocumentItemCategory		_PurgDocumentItemCategory

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_RequestForQuotationItem.
-- 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: IMMRFQITEM

CREATE VIEW I_RequestForQuotationItem AS
SELECT
  R_PurchasingDocumentItem.PurchasingDocument AS RequestForQuotation,
  cast (R_PurchasingDocumentItem.PurchasingDocumentItem as vdm_requestforquotationitem preserving type) AS RequestForQuotationItem,
  R_PurchasingDocumentItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  R_PurchasingDocumentItem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  R_PurchasingDocumentItem.Material AS Material,
  ProductType,
  cast (R_PurchasingDocumentItem.ManufacturerMaterial as vdm_manufacturer_material preserving type) AS ManufacturerMaterial,
  R_PurchasingDocumentItem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  R_PurchasingDocumentItem.Manufacturer AS Manufacturer,
  R_PurchasingDocumentItem.MaterialGroup AS MaterialGroup,
  R_PurchasingDocumentItem.Plant AS Plant,
  R_PurchasingDocumentItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  R_PurchasingDocumentItem.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  R_PurchasingDocumentItem.IncotermsClassification AS IncotermsClassification,
  R_PurchasingDocumentItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  R_PurchasingDocumentItem.IncotermsLocation1 AS IncotermsLocation1,
  R_PurchasingDocumentItem.IncotermsLocation2 AS IncotermsLocation2,
  R_PurchasingDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  R_PurchasingDocumentItem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  R_PurchasingDocumentItem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  R_PurchasingDocumentItem.BaseUnit AS BaseUnit,
  R_PurchasingDocumentItem.PurchaseRequisition AS PurchaseRequisition,
  R_PurchasingDocumentItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  R_PurchasingDocumentItem.PurchasingInfoRecordUpdateCode AS IsInfoRecordUpdated,
  R_PurchasingDocumentItem.RequirementTracking AS RequirementTracking,
  R_PurchasingDocumentItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  R_PurchasingDocumentItem.PurchasingParentItem AS PurchasingParentItem,
  R_PurchasingDocumentItem.PurgDocAggrgdSubitemCategory AS PurgDocAggrgdSubitemCategory,
  R_PurchasingDocumentItem.IsStatisticalItem AS IsStatisticalItem,
  R_PurchasingDocumentItem.PurgExternalSortNumber AS PurgExternalSortNumber,
  R_PurchasingDocumentItem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  R_PurchasingDocumentItem._ProductType AS _ProductType
FROM R_PurchasingDocumentItem
LEFT OUTER JOIN I_RequestForQuotation AS _RequestForQuotation ON RequestForQuotation = _RequestForQuotation.RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SupplierQuotationItem AS _SupplierQuotationItem ON RequestForQuotation = _SupplierQuotationItem.RequestForQuotation AND RequestForQuotationItem = _SupplierQuotationItem.RequestForQuotationItem  -- association [0..*]
;

Depth:

I_RequestForQuotationItem view

R_PurchasingDocumentItem view