What is A_SupplierQuotationItem in SAP S/4HANA?

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

Which tables does A_SupplierQuotationItem read from?

A_SupplierQuotationItem reads data from: I_SupplierQuotationItemEnh.

What VDM layer is A_SupplierQuotationItem?

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

A_SupplierQuotationItem

DDL: A_SUPPLIERQUOTATIONITEM SQL: AMMQTNITEMENH Type: view COMPOSITE

40 Fields 1 Data Sources 2 Associations

Item

A_SupplierQuotationItem is a Composite CDS View that provides data about "Item" in SAP S/4HANA. It reads from 1 data source (I_SupplierQuotationItemEnh) and exposes 40 fields with key fields SupplierQuotation, SupplierQuotationItem. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_SupplierQuotationItemEnh	I_SupplierQuotationItemEnh	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	A_SupplierQuotation	_SupplierQuotation	`$projection.SupplierQuotation = _SupplierQuotation.SupplierQuotation --Extension`
[1..1]	E_PurchasingDocumentItem	_Extension	`$projection.SupplierQuotation = _Extension.PurchasingDocument and $projection.SupplierQuotationItem = _Extension.PurchasingDocumentItem`

Annotations (12)

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

Fields (40)

Key	Field	Source Table	Source Field	Description
KEY	SupplierQuotation	I_SupplierQuotationItemEnh	SupplierQuotation	RFQ
KEY	SupplierQuotationItem	I_SupplierQuotationItemEnh	SupplierQuotationItem	Supplier Quotation Item
	PurchasingDocumentCategory	I_SupplierQuotationItemEnh	PurchasingDocumentCategory	Doc. Category
	PurchasingDocumentItemText	I_SupplierQuotationItemEnh	PurchasingDocumentItemText	Short Text
	Material	I_SupplierQuotationItemEnh	Material	Vehicle Model
	ManufacturerMaterial	I_SupplierQuotationItemEnh	ManufacturerMaterial	MPN: Material
	SupplierMaterialNumber	I_SupplierQuotationItemEnh	SupplierMaterialNumber	Supp. Mat. No.
	ManufacturerPartNmbr	I_SupplierQuotationItemEnh	ManufacturerPartNmbr	Mfr Part Number
	Manufacturer	I_SupplierQuotationItemEnh	Manufacturer	Manufacturer
	MaterialGroup	I_SupplierQuotationItemEnh	MaterialGroup	Product Group
	Plant	I_SupplierQuotationItemEnh	Plant	Valuation Area
	IncotermsClassification	I_SupplierQuotationItemEnh	IncotermsClassification	Incoterms
	IncotermsTransferLocation	I_SupplierQuotationItemEnh	IncotermsTransferLocation	Incoterms 2
	IncotermsLocation1	I_SupplierQuotationItemEnh	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	I_SupplierQuotationItemEnh	IncotermsLocation2	Inco. Location2
	ScheduleLineDeliveryDate	I_SupplierQuotationItemEnh	ScheduleLineDeliveryDate	Delivery Date
	ScheduleLineOrderQuantity	I_SupplierQuotationItemEnh	ScheduleLineOrderQuantity	Scheduled Qty
	AwardedQuantity	I_SupplierQuotationItemEnh	AwardedQuantity	Awarded Quantity
	OrderPriceUnit	I_SupplierQuotationItemEnh	OrderPriceUnit	Order Price Un.
	ProductType	I_SupplierQuotationItemEnh	ProductType	Product Type Group
	PerformancePeriodStartDate	I_SupplierQuotationItemEnh	PerformancePeriodStartDate	Start of Performance Period
	PerformancePeriodEndDate	I_SupplierQuotationItemEnh	PerformancePeriodEndDate	End of Performance Period
	OrderPriceUnitToOrderUnitNmrtr	I_SupplierQuotationItemEnh	OrderPriceUnitToOrderUnitNmrtr	Quantity Conversion Numerator
	OrdPriceUnitToOrderUnitDnmntr	I_SupplierQuotationItemEnh	OrdPriceUnitToOrderUnitDnmntr	Quantity Conversion Denominator
	OrderQuantityUnit		OrderQuantityUnit	Sales Unit
	OrderItemQtyToBaseQtyNmrtr		OrderItemQtyToBaseQtyNmrtr	Equal To
	OrderItemQtyToBaseQtyDnmntr		OrderItemQtyToBaseQtyDnmntr	Denominator
	PurgDocPriceDate		PurgDocPriceDate	Price Date
	BaseUnit		BaseUnit	Unit of Measure
	NetAmount	I_SupplierQuotationItemEnh	NetAmount	Stated Amount
	NetPriceAmount	I_SupplierQuotationItemEnh	NetPriceAmount	Net Price
	NetPriceQuantity	I_SupplierQuotationItemEnh	NetPriceQuantity	Price Unit
	DocumentCurrency	I_SupplierQuotationItemEnh	DocumentCurrency	Document Currency
	PurchaseRequisition	I_SupplierQuotationItemEnh	PurchaseRequisition	Requisition
	PurchaseRequisitionItem	I_SupplierQuotationItemEnh	PurchaseRequisitionItem	Requisn. item
	RequestForQuotation	I_SupplierQuotationItemEnh	RequestForQuotation	RFQ
	RequestForQuotationItem	I_SupplierQuotationItemEnh	RequestForQuotationItem	RFQ Item
	IsInfoRecordUpdated	I_SupplierQuotationItemEnh	IsInfoRecordUpdated	InfoUpdate
	PurchasingInfoRecord	I_SupplierQuotationItemEnh	PurchasingInfoRecord	Info Record
	_SupplierQuotation		_SupplierQuotation

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_SupplierQuotationItem.
-- 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: AMMQTNITEMENH

CREATE VIEW A_SupplierQuotationItem AS
SELECT
  I_SupplierQuotationItemEnh.SupplierQuotation AS SupplierQuotation,
  I_SupplierQuotationItemEnh.SupplierQuotationItem AS SupplierQuotationItem,
  I_SupplierQuotationItemEnh.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_SupplierQuotationItemEnh.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  I_SupplierQuotationItemEnh.Material AS Material,
  I_SupplierQuotationItemEnh.ManufacturerMaterial AS ManufacturerMaterial,
  I_SupplierQuotationItemEnh.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_SupplierQuotationItemEnh.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  I_SupplierQuotationItemEnh.Manufacturer AS Manufacturer,
  I_SupplierQuotationItemEnh.MaterialGroup AS MaterialGroup,
  I_SupplierQuotationItemEnh.Plant AS Plant,
  I_SupplierQuotationItemEnh.IncotermsClassification AS IncotermsClassification,
  I_SupplierQuotationItemEnh.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_SupplierQuotationItemEnh.IncotermsLocation1 AS IncotermsLocation1,
  I_SupplierQuotationItemEnh.IncotermsLocation2 AS IncotermsLocation2,
  I_SupplierQuotationItemEnh.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  I_SupplierQuotationItemEnh.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  I_SupplierQuotationItemEnh.AwardedQuantity AS AwardedQuantity,
  I_SupplierQuotationItemEnh.OrderPriceUnit AS OrderPriceUnit,
  I_SupplierQuotationItemEnh.ProductType AS ProductType,
  I_SupplierQuotationItemEnh.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_SupplierQuotationItemEnh.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_SupplierQuotationItemEnh.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  I_SupplierQuotationItemEnh.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  OrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  PurgDocPriceDate,
  BaseUnit,
  I_SupplierQuotationItemEnh.NetAmount AS NetAmount,
  I_SupplierQuotationItemEnh.NetPriceAmount AS NetPriceAmount,
  I_SupplierQuotationItemEnh.NetPriceQuantity AS NetPriceQuantity,
  I_SupplierQuotationItemEnh.DocumentCurrency AS DocumentCurrency,
  I_SupplierQuotationItemEnh.PurchaseRequisition AS PurchaseRequisition,
  I_SupplierQuotationItemEnh.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_SupplierQuotationItemEnh.RequestForQuotation AS RequestForQuotation,
  I_SupplierQuotationItemEnh.RequestForQuotationItem AS RequestForQuotationItem,
  I_SupplierQuotationItemEnh.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  I_SupplierQuotationItemEnh.PurchasingInfoRecord AS PurchasingInfoRecord
FROM I_SupplierQuotationItemEnh
LEFT OUTER JOIN A_SupplierQuotation AS _SupplierQuotation ON SupplierQuotation = _SupplierQuotation.SupplierQuotation  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _Extension ON SupplierQuotation = _Extension.PurchasingDocument AND SupplierQuotationItem = _Extension.PurchasingDocumentItem  -- association [1..1]
;

Depth:

A_SupplierQuotationItem view

I_SupplierQuotationItemEnh view