I_SuplrQuotationItemEnhWD

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_SuplrQuotationItemEnhWD.
-- 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: IMMQTNITEMENHWD

CREATE VIEW I_SuplrQuotationItemEnhWD AS
SELECT
  Document.SupplierQuotation AS SupplierQuotation,
  Document.SupplierQuotationItem AS SupplierQuotationItem,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  Document.Material AS Material,
  Document.ProductType AS ProductType,
  Document.ManufacturerMaterial AS ManufacturerMaterial,
  Document.SupplierMaterialNumber AS SupplierMaterialNumber,
  Document.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  Document.Manufacturer AS Manufacturer,
  Document.MaterialGroup AS MaterialGroup,
  Document.Plant AS Plant,
  Document.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  Document.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  Document.AddressID AS AddressID,
  Document.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  Document.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  Document.AwardedQuantity AS AwardedQuantity,
  Document.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  Document.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  Document.OrderPriceUnit AS OrderPriceUnit,
  Document.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  Document.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  Document.OrderQuantityUnit AS OrderQuantityUnit,
  Document.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  Document.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  Document.PurgDocPriceDate AS PurgDocPriceDate,
  Document.BaseUnit AS BaseUnit,
  Document.NetAmount AS NetAmount,
  Document.GrossAmount AS GrossAmount,
  Document.EffectiveAmount AS EffectiveAmount,
  Document.NetPriceAmount AS NetPriceAmount,
  Document.NetPriceQuantity AS NetPriceQuantity,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.RequestForQuotation AS RequestForQuotation,
  Document.RequestForQuotationItem AS RequestForQuotationItem,
  Document.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  Document.PurchasingInfoRecordUpdateCode AS PurchasingInfoRecordUpdateCode,
  Document.PurchasingInfoRecord AS PurchasingInfoRecord,
  Document.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  Document.PurchasingParentItem AS PurchasingParentItem,
  Document.IsStatisticalItem AS IsStatisticalItem,
  cast( '' as rsnodeext ) AS HierarchyNode,
  cast( '' as rsnodeext ) AS HierarchyParentNode,
  cast( 0 as abap.int4 ) AS HierarchyLevel,
  cast(0 as abap.int4 ) AS HierarchyNodeSubTreeSize,
  cast( '' as abap.char(22) ) AS HierarchyDrillState,
  cast( 0 as abap.int8 ) AS HierarchyNodeOrdinalNumber,
  Document.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  Document.PurgDocAggrgdSubitemCategory AS PurgDocAggrgdSubitemCategory,
  Document.PurgExternalSortNumber AS PurgExternalSortNumber
FROM I_SupplierQuotationItemEnh AS Document
LEFT OUTER JOIN I_SuplrQuotationEnhWD AS _SuplrQuotationEnhWD ON _SuplrQuotationEnhWD.SupplierQuotation = SupplierQuotation  -- association [1..1]
LEFT OUTER JOIN I_QTNPricingElementWD AS _QTNPricingElementWD ON _QTNPricingElementWD.SupplierQuotation = SupplierQuotation AND _QTNPricingElementWD.SupplierQuotationItem = SupplierQuotationItem  -- association [1..*]
LEFT OUTER JOIN I_RFQItemEnhanced AS _RequestForQuotationItem ON _RequestForQuotationItem.RequestForQuotation = RequestForQuotation AND _RequestForQuotationItem.RequestForQuotationItem = RequestForQuotationItem  -- association [0..1]
LEFT OUTER JOIN I_AddressTP AS _AddressTP ON _AddressTP.AddressID = ItemDeliveryAddressID  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _RequestQtnItemExtension ON SupplierQuotation = _RequestQtnItemExtension.PurchasingDocument AND SupplierQuotationItem = _RequestQtnItemExtension.PurchasingDocumentItem  -- association [1..1]
;