C_SupplierQuotationCompare

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 C_SupplierQuotationCompare.
-- 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: CSUPLRQTNCOMP

CREATE VIEW C_SupplierQuotationCompare AS
SELECT
  _SupplierQuotation.RequestForQuotation AS RequestForQuotation,
  _SupplierQuotation.SupplierQuotation AS SupplierQuotation,
  _SupplierQuotation.Supplier AS Supplier,
  _SupplierContactCard.FullName AS SupplierName,
  _SupplierContactCard.AddressID AS AddressID,
  cast('' as contactcardformattedaddress) AS FormattedAddress,
  _SupplierQuotation.CreationDate AS CreationDate,
  _SupplierQuotation.DocumentCurrency AS DocumentCurrency,
  _SupplierQuotation.QuotationSubmissionDate AS QuotationSubmissionDate,
  cast( 0 as vdm_total_net_amount ) AS TotalNetAmount,
  _SupplierQuotation.QtnLifecycleStatus AS QtnLifecycleStatus,
  cast( 0 as vdm_qtn_nrof_best_priced_itms ) AS NumberOfBestPricedItems,
  cast( 0 as vdm_qtn_fully_quoted_ratio ) AS NumberOfFullyQuotedItems,
  cast( 0 as vdm_nr_of_rfq_items ) AS NumberOfReqForQuotationItems,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  PurchasingOrganization,
  PurchasingGroup,
  PurchasingDocumentType,
  IsEndOfPurposeBlocked
FROM I_SupplierQuotationCompareTP AS _SupplierQuotation
LEFT OUTER JOIN C_SupplierQuotationItemCompare AS _SupplierQuotationItem ON SupplierQuotation = _SupplierQuotationItem.SupplierQuotation AND RequestForQuotation = _SupplierQuotationItem.RequestForQuotation  -- association [0..*]
LEFT OUTER JOIN C_RequestForQuotationCompare AS _RFQCompare ON RequestForQuotation = _RFQCompare.RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_SuplrContactCard AS _SupplierContactCard ON _SupplierQuotation.Supplier = _SupplierContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_QtnLifecycleStatusText AS _QtnLifecycleStatusText ON _SupplierQuotation.QtnLifecycleStatus = _QtnLifecycleStatusText.QtnLifecycleStatus  -- association [0..*]
LEFT OUTER JOIN P_SuplrQtnCalcFields AS _SuplrQtnCalcFields ON _SupplierQuotation.SupplierQuotation = _SuplrQtnCalcFields.SupplierQuotation  -- association [0..1]
;