C_RequestForQuotationCompare

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_RequestForQuotationCompare.
-- 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: CRFQCOMPARE

CREATE VIEW C_RequestForQuotationCompare AS
SELECT
  RequestForQuotation,
  RequestForQuotationName,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  CreatedByUser,
  cast(_ContactCard.FullName as vdm_full_name preserving type ) AS FullName,
  CreationDate,
  RFQPublishingDate,
  QuotationLatestSubmissionDate,
  RFQLifecycleStatus,
  PurchasingDocument,
  PurchasingOrganization,
  PurchasingGroup,
  IsEndOfPurposeBlocked
FROM I_RFQCompareTP
LEFT OUTER JOIN I_RFQItemEnhanced AS _RequestForQuotationItem ON RequestForQuotation = _RequestForQuotationItem.RequestForQuotation  -- association [0..*]
LEFT OUTER JOIN C_RFQBiddingRatioChart AS _BiddingRatioChart ON RequestForQuotation = _BiddingRatioChart.RequestForQuotation  -- association [0..1]
LEFT OUTER JOIN C_SuplrQtnComparisonChart AS _ComparisonChart ON RequestForQuotation = _ComparisonChart.RequestForQuotation  -- association [0..1]
LEFT OUTER JOIN C_SupplierQuotationCompare AS _SupplierQuotationCompare ON RequestForQuotation = _SupplierQuotationCompare.RequestForQuotation  -- association [0..*]
LEFT OUTER JOIN I_RFQLifecycleStatusText AS _RFQLifecycleStatusText ON RFQLifecycleStatus = _RFQLifecycleStatusText.RFQLifecycleStatus  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType  -- association [0..*]
LEFT OUTER JOIN C_RFQValueHelp AS _RFQValueHelp ON PurchasingDocument = _RFQValueHelp.RequestForQuotation  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ContactCard ON CreatedByUser = _ContactCard.ContactCardID  -- association [0..1]
;