I_SuplrQuotationItemCompareTP

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_SuplrQuotationItemCompareTP.
-- 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: IQTNITEMCOMPTP

CREATE VIEW I_SuplrQuotationItemCompareTP AS
SELECT
  _SupplierQuotationItem.SupplierQuotation AS SupplierQuotation,
  _SupplierQuotationItem.RequestForQuotation AS RequestForQuotation,
  _SupplierQuotationItem.SupplierQuotationItem AS SupplierQuotationItem,
  _SupplierQuotationItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _SupplierQuotationItem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  _SupplierQuotationItem.Material AS Material,
  _SupplierQuotationItem.ProductType AS ProductType,
  _SupplierQuotationItem.ManufacturerMaterial AS ManufacturerMaterial,
  _SupplierQuotationItem.MaterialGroup AS MaterialGroup,
  _SupplierQuotationItem.Plant AS Plant,
  _ScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  cast( _ScheduleLine.ScheduleLineOrderQuantity as vdm_quotation_quantity preserving type) AS QuotationQuantity,
  _ScheduleLine.AwardedQuantity AS AwardedQuantity,
  _ScheduleLine.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _ScheduleLine.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _SupplierQuotationItem.OrderPriceUnit AS OrderPriceUnit,
  _SupplierQuotationItem.OrderQuantityUnit AS OrderQuantityUnit,
  _SupplierQuotationItem.NetAmount AS NetAmount,
  _SupplierQuotationItem.GrossAmount AS GrossAmount,
  _SupplierQuotationItem.NetPriceAmount AS NetPriceAmount,
  _SupplierQuotationItem.NetPriceQuantity AS NetPriceQuantity,
  _SupplierQuotationItem.DocumentCurrency AS DocumentCurrency,
  _SupplierQuotationItem.PurchaseRequisition AS PurchaseRequisition,
  _SupplierQuotationItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _SupplierQuotationItem.RequestForQuotationItem AS RequestForQuotationItem,
  _SupplierQuotationItem.IsInfoRecordUpdated AS PurchasingInfoRecordUpdateCode,
  _SupplierQuotationItem.PurchasingInfoRecord AS PurchasingInfoRecord
FROM I_SupplierQuotationItem AS _SupplierQuotationItem
LEFT OUTER JOIN I_SupplierQuotationCompareTP AS _SupplierQuotationCompare ON SupplierQuotation = _SupplierQuotationCompare.SupplierQuotation AND RequestForQuotation = _SupplierQuotationCompare.RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_SuplrQtnScheduleLineEnh AS _ScheduleLine ON _ScheduleLine.SupplierQuotation = SupplierQuotation AND _ScheduleLine.SupplierQuotationItem = SupplierQuotationItem AND _ScheduleLine.ScheduleLine = '0001'  -- association [0..1]
LEFT OUTER JOIN I_RFQCompareTP AS _RFQCompare ON RequestForQuotation = _RFQCompare.RequestForQuotation  -- association [1..1]
;