I_RFQItemEnhanced

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_RFQItemEnhanced.
-- 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: IMMRFQITEMENH

CREATE VIEW I_RFQItemEnhanced AS
SELECT
  I_RequestForQuotationItem.RequestForQuotation AS RequestForQuotation,
  I_RequestForQuotationItem.RequestForQuotationItem AS RequestForQuotationItem,
  I_RequestForQuotationItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_RequestForQuotationItem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  I_RequestForQuotationItem.Material AS Material,
  I_RequestForQuotationItem.ProductType AS ProductType,
  I_RequestForQuotationItem.ManufacturerMaterial AS ManufacturerMaterial,
  I_RequestForQuotationItem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  I_RequestForQuotationItem.Manufacturer AS Manufacturer,
  I_RequestForQuotationItem.MaterialGroup AS MaterialGroup,
  I_RequestForQuotationItem.Plant AS Plant,
  I_RequestForQuotationItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  I_RequestForQuotationItem.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  _Plant.AddressID AS AddressID,
  I_RequestForQuotationItem.IncotermsClassification AS IncotermsClassification,
  I_RequestForQuotationItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_RequestForQuotationItem.IncotermsLocation1 AS IncotermsLocation1,
  I_RequestForQuotationItem.IncotermsLocation2 AS IncotermsLocation2,
  _RFQScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  cast( _RFQScheduleLine.ScheduleLineOrderQuantity as vdm_requested_quantity preserving type ) AS ScheduleLineOrderQuantity,
  _RFQScheduleLine.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _RFQScheduleLine.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_RequestForQuotationItem.OrderQuantityUnit AS OrderQuantityUnit,
  I_RequestForQuotationItem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  I_RequestForQuotationItem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  I_RequestForQuotationItem.BaseUnit AS BaseUnit,
  I_RequestForQuotationItem.PurchaseRequisition AS PurchaseRequisition,
  I_RequestForQuotationItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_RequestForQuotationItem.IsInfoRecordUpdated AS PurchasingInfoRecordUpdateCode,
  I_RequestForQuotationItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  I_RequestForQuotationItem._IncotermsClassification AS _IncotermsClassification,
  I_RequestForQuotationItem._MaterialGroup AS _MaterialGroup,
  I_RequestForQuotationItem._Material AS _Material,
  I_RequestForQuotationItem._ManufacturerMaterial AS _ManufacturerMaterial,
  I_RequestForQuotationItem._BaseUnit AS _BaseUnit,
  I_RequestForQuotationItem._Manufacturer AS _Manufacturer,
  I_RequestForQuotationItem._ProductType AS _ProductType,
  I_RequestForQuotationItem._Plant AS _Plant,
  I_RequestForQuotationItem._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  I_RequestForQuotationItem._OrderQuantityUnit AS _OrderQuantityUnit,
  I_RequestForQuotationItem._PurgDocumentItemCategory AS _PurgDocumentItemCategory,
  I_RequestForQuotationItem.PurchasingParentItem AS PurchasingParentItem,
  I_RequestForQuotationItem.IsStatisticalItem AS IsStatisticalItem,
  I_RequestForQuotationItem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  I_RequestForQuotationItem.PurgDocAggrgdSubitemCategory AS PurgDocAggrgdSubitemCategory,
  I_RequestForQuotationItem.PurgExternalSortNumber AS PurgExternalSortNumber
FROM I_RequestForQuotationItem
LEFT OUTER JOIN I_RequestForQuotationEnhanced AS _RequestForQuotation ON RequestForQuotation = _RequestForQuotation.RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_RFQScheduleLineEnhanced AS _RFQScheduleLine ON RequestForQuotation = _RFQScheduleLine.RequestForQuotation AND RequestForQuotationItem = _RFQScheduleLine.RequestForQuotationItem AND _RFQScheduleLine.ScheduleLine = '0001'  -- association [0..1]
LEFT OUTER JOIN I_SupplierQuotationItemEnh AS _SupplierQuotationItem ON RequestForQuotation = _SupplierQuotationItem.RequestForQuotation AND RequestForQuotationItem = _SupplierQuotationItem.RequestForQuotationItem  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _RequestQtnItemExtension ON RequestForQuotation = _RequestQtnItemExtension.PurchasingDocument AND RequestForQuotationItem = _RequestQtnItemExtension.PurchasingDocumentItem  -- association [1..1]
;