C_SrcgProjQuotationFacet

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_SrcgProjQuotationFacet.
-- 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.

CREATE VIEW C_SrcgProjQuotationFacet AS
SELECT
  SourcingProjectQuotationUUID,
  SourcingProjectQuotation,
  SrcgProjQuotationVersion,
  SourcingProjectQuotationName,
  SrcgProjQuotationIsSimulated,
  QtnLatestSubmissionDateTime,
  SourcingAwardingDate,
  SrcgProjQtnLifecycleStatus,
  CreationDateTime,
  SourcingProjectUUID,
  Bidder,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _BusinessPartner._DefaultAddress._Address.Country AS Country,
  cast(_BuPaIdentification.BPIdentificationNumber as vdm_business_partner_id) AS BPIdentificationNumber,
  _BuPaIdentification.BPIdnNmbrIssuingInstitute AS BPIdnNmbrIssuingInstitute,
  cast(0 as vdm_numberofattachments) AS NumberOfAttachments,
  cast(0 as vdm_numberofnotes) AS NumberOfNotes,
  _SrcgProjOfferedQtnItemRatio.NumberOfOfferedSrcgProjQtnItem AS NumberOfOfferedSrcgProjQtnItem,
  _SrcgProjOfferedQtnItemRatio.NumberOfRefusedSrcgProjQtnItem AS NumberOfRefusedSrcgProjQtnItem,
  _SrcgProjOfferedQtnItemRatio.NumberOfSrcgProjQtnItem AS NumberOfSrcgProjQtnItem,
  CompanyCode,
  MaterialGroup,
  IsEndOfPurposeBlocked,
  SourcingProjectQuotationType,
  PurchasingGroup,
  PurchasingOrganization
FROM R_SourcingProjectQuotation
LEFT OUTER JOIN I_BuPaIdentification AS _BuPaIdentification ON Bidder = _BuPaIdentification.BusinessPartner AND _BuPaIdentification.BPIdentificationType = 'BUP001'  -- association [0..1]
LEFT OUTER JOIN P_SrcgProjOfferedQtnItemRatio AS _SrcgProjOfferedQtnItemRatio ON SourcingProjectQuotationUUID = _SrcgProjOfferedQtnItemRatio.SourcingProjectQuotationUUID  -- association [0..1]
LEFT OUTER JOIN I_SrcgProjQtnLifecycleStsText AS _SrcgProjQtnLifecycleStsText ON SrcgProjQtnLifecycleStatus = _SrcgProjQtnLifecycleStsText.SrcgProjQtnLifecycleStatus  -- association [0..*]
;