P_Rfqitemsmntr

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 P_Rfqitemsmntr.
-- 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: PRFQITEMSMNTR

CREATE VIEW P_Rfqitemsmntr AS
SELECT
  I_RequestForQuotationItem.RequestForQuotation AS RequestForQuotation,
  I_RequestForQuotationItem.RequestForQuotationItem AS RequestForQuotationItem,
  I_SupplierQuotationItem.SupplierQuotation AS SupplierQuotation,
  I_SupplierQuotationItem.SupplierQuotationItem AS SupplierQuotationItem,
  I_SupplierQuotationItem.SupplierQuotation AS ActiveSupplierQuotationItem,
  I_SupplierQuotationItem.DocumentCurrency AS DocumentCurrency,
  _SupplierWeb.CreationDate AS CreationDate,
  _SupplierWeb.Supplier AS Supplier,
  I_SupplierQuotationItem._SupplierQuotation._Supplier.SupplierName AS SupplierName,
  _PurchasingDocument.QuotationSubmissionDate AS QuotationSubmissionDate,
  I_RequestForQuotationItem.PurchaseRequisition AS PurchaseRequisition,
  I_RequestForQuotationItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_RequestForQuotationItem.Material AS Material,
  I_RequestForQuotationItem._Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  I_RequestForQuotationItem.Plant AS Plant,
  I_RequestForQuotationItem._Plant.PlantName AS PlantName,
  I_RequestForQuotationItem.OrderQuantityUnit AS OrderQuantityUnit,
  _SuplrQtnScheduleLine.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  _SuplrQtnScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  I_RequestForQuotationItem.MaterialGroup AS MaterialGroup,
  I_RequestForQuotationItem._MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  case when _SuplrQtnScheduleLine.AwardedQuantity is null or _SupplierWeb.QtnLifecycleStatus = '02' then 0 else _SuplrQtnScheduleLine.AwardedQuantity end as AwardedQuantity AS AwardedQuantityendasAwardedQuantity,
  I_SupplierQuotationItem.NetPriceAmount AS NetPriceAmount,
  case when ( _SupplierWeb.QtnLifecycleStatus = '03' or _SupplierWeb.QtnLifecycleStatus = '05' ) and _SuplrQtnScheduleLine.AwardedQuantity <> 0 then cast(I_SupplierQuotationItem.EffectiveAmount as abap.curr( 18, 2 )) else cast(0 as abap.curr( 18, 2 )) end as PriceQuotation AS curr182endasPriceQuotation,
  _PurchasingDocument._Supplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  _RFQEnhancedWeb.RFQLifecycleStatus AS RFQLifecycleStatus,
  _RFQEnhancedWeb._CompanyCode.CompanyCodeName AS CompanyCodeName
FROM I_RequestForQuotationItem
LEFT OUTER JOIN I_SupplierQuotationItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RequestForQuotation AS _RFQEnhancedWeb ON RequestForQuotation = _RFQEnhancedWeb.RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_SupplierQuotation AS _SupplierWeb ON SupplierQuotation = _SupplierWeb.SupplierQuotation  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON SupplierQuotation = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_SuplrQtnScheduleLine AS _SuplrQtnScheduleLine ON SupplierQuotation = _SuplrQtnScheduleLine.SupplierQuotation AND SupplierQuotationItem = _SuplrQtnScheduleLine.SupplierQuotationItem AND _SuplrQtnScheduleLine.ScheduleLine = '0001'  -- association [1..1]
;