C_CntrlReqForQuotationBidderTP

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_CntrlReqForQuotationBidderTP.
-- 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: CCNTRLRFQBIDTP

CREATE VIEW C_CntrlReqForQuotationBidderTP AS
SELECT
  I_CntrlReqForQuotationBidderTP.PartnerFunction AS PartnerFunction,
  I_CntrlReqForQuotationBidderTP.PartnerCounter AS PartnerCounter,
  I_CntrlReqForQuotationBidderTP.CentralRequestForQuotation AS CentralRequestForQuotation,
  I_CntrlReqForQuotationBidderTP.Supplier AS Supplier,
  _Bidder.SupplierName AS SupplierName,
  cast ('' as boolean) AS HasNoSupplierQuotation,
  _CentralRequestForQuotationTP.PurchasingOrganization AS PurchasingOrganization,
  QuotationLatestSubmissionDate,
  I_CntrlReqForQuotationBidderTP.RFQLifecycleStatus AS RFQLifecycleStatus,
  I_CntrlReqForQuotationBidderTP._PartnerFunction AS _PartnerFunction
FROM I_CntrlReqForQuotationBidderTP
LEFT OUTER JOIN C_CentralRequestForQuotationTP AS _CentralRequestForQuotationTP ON _CentralRequestForQuotationTP.CentralRequestForQuotation = CentralRequestForQuotation  -- 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]
;