I_RFQItemEnhWD

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_RFQItemEnhWD.
-- 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: IMMRFQITEMENHWD

CREATE VIEW I_RFQItemEnhWD AS
SELECT
  Document.RequestForQuotationItem AS RequestForQuotationItem,
  Document.RequestForQuotation AS RequestForQuotation,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  Document.Material AS Material,
  Document.ProductType AS ProductType,
  Document.ManufacturerMaterial AS ManufacturerMaterial,
  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.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  Document.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  Document.OrderQuantityUnit AS OrderQuantityUnit,
  Document.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  Document.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  Document.BaseUnit AS BaseUnit,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  Document.PurchasingInfoRecordUpdateCode AS PurchasingInfoRecordUpdateCode,
  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,
  Document._IncotermsClassification AS _IncotermsClassification,
  Document._MaterialGroup AS _MaterialGroup,
  Document._Material AS _Material,
  Document._ManufacturerMaterial AS _ManufacturerMaterial,
  Document._Plant AS _Plant,
  Document._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  Document._OrderQuantityUnit AS _OrderQuantityUnit,
  Document._PurgDocumentItemCategory AS _PurgDocumentItemCategory,
  Document._BaseUnit AS _BaseUnit,
  Document._Manufacturer AS _Manufacturer
FROM I_RFQItemEnhanced AS Document
LEFT OUTER JOIN I_RequestForQuotationEnhWD AS _RequestForQuotationEnhWD ON _RequestForQuotationEnhWD.RequestForQuotation = RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_RFQScheduleLineEnhanced AS _RFQScheduleLine ON _RFQScheduleLine.RequestForQuotation = RequestForQuotation AND _RFQScheduleLine.RequestForQuotationItem = RequestForQuotationItem AND _RFQScheduleLine.ScheduleLine = '0001'  -- association [0..1]
LEFT OUTER JOIN I_SupplierQuotationItemEnh AS _SupplierQuotationItem ON _SupplierQuotationItem.RequestForQuotation = RequestForQuotation AND _SupplierQuotationItem.RequestForQuotationItem = RequestForQuotationItem  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _RequestQtnItemExtension ON RequestForQuotation = _RequestQtnItemExtension.PurchasingDocument AND RequestForQuotationItem = _RequestQtnItemExtension.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_AddressTP AS _AddressTP ON _AddressTP.AddressID = ItemDeliveryAddressID  -- association [1..1]
;