I_SupplierQuotationItem

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_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: IMMQTNITEM

CREATE VIEW I_SupplierQuotationItem AS
SELECT
  R_PurchasingDocumentItem.PurchasingDocument AS SupplierQuotation,
  cast (R_PurchasingDocumentItem.PurchasingDocumentItem as vdm_supplierquotationitem preserving type) AS SupplierQuotationItem,
  R_PurchasingDocumentItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  R_PurchasingDocumentItem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  R_PurchasingDocumentItem.Material AS Material,
  ProductType,
  R_PurchasingDocumentItem.ManufacturerMaterial AS ManufacturerMaterial,
  R_PurchasingDocumentItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  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,
  OrderPriceUnit,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  OrderQuantity,
  PurgDocPriceDate,
  BaseUnit,
  cast(NetAmount as vdm_qtn_net_amount preserving type ) AS NetAmount,
  GrossAmount,
  EffectiveAmount,
  NetPriceAmount,
  NetPriceQuantity,
  R_PurchasingDocumentItem.DocumentCurrency AS DocumentCurrency,
  R_PurchasingDocumentItem.PurchaseRequisition AS PurchaseRequisition,
  R_PurchasingDocumentItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  R_PurchasingDocumentItem.RequestForQuotation AS RequestForQuotation,
  R_PurchasingDocumentItem.RequestForQuotationItem AS RequestForQuotationItem,
  R_PurchasingDocumentItem.PurchasingInfoRecordUpdateCode AS IsInfoRecordUpdated,
  R_PurchasingDocumentItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  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
FROM R_PurchasingDocumentItem
LEFT OUTER JOIN I_SupplierQuotation AS _SupplierQuotation ON SupplierQuotation = _SupplierQuotation.SupplierQuotation  -- association [1..1]
LEFT OUTER JOIN I_RequestForQuotationItem AS _RequestForQuotationItem ON RequestForQuotation = _RequestForQuotationItem.RequestForQuotation AND RequestForQuotationItem = _RequestForQuotationItem.RequestForQuotationItem  -- association [1..1]
;