C_RFQBidderEnhWD

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_RFQBidderEnhWD.
-- 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: CMMRFQBIDDERENH

CREATE VIEW C_RFQBidderEnhWD AS
SELECT
  I_RFQBidderEnhWD.PartnerFunction AS PartnerFunction,
  I_RFQBidderEnhWD.PartnerCounter AS PartnerCounter,
  I_RFQBidderEnhWD.RequestForQuotation AS RequestForQuotation,
  I_RFQBidderEnhWD.Supplier AS Supplier,
  cast ('' as boolean) AS HasNoSupplierQuotation,
  _RequestForQuotationEnhWD.PurchasingOrganization AS PurchasingOrganization,
  I_RFQBidderEnhWD.RFQLifecycleStatus AS RFQLifecycleStatus,
  I_RFQBidderEnhWD._PartnerFunction AS _PartnerFunction,
  _Bidder.FormattedAddress AS FormattedAddress,
  _Bidder.Country AS Country,
  _Bidder.EmailAddress AS EmailAddress,
  _Bidder.AddressID AS AddressID
FROM I_RFQBidderEnhWD
LEFT OUTER JOIN C_RequestForQuotationEnhWD AS _RequestForQuotationEnhWD ON _RequestForQuotationEnhWD.RequestForQuotation = RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN C_BidderValueHelp AS _BidderValueHelp ON _BidderValueHelp.Supplier = Supplier AND _BidderValueHelp.PurchasingOrganization = purchasingorganization  -- association [0..1]
LEFT OUTER JOIN C_BidderContactCard AS _Bidder ON _Bidder.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = purchasingorganization  -- association [0..1]
;