C_SrcgProjQuotationCompare_2

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_SrcgProjQuotationCompare_2.
-- 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.
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW C_SrcgProjQuotationCompare_2 AS
SELECT
  SourcingProjectQuotationUUID,
  SourcingProjectQuotation,
  SrcgProjQuotationVersion,
  SrcgProjQuotationIsSimulated,
  SourcingProjectQuotationName,
  SrcgProjQtnLifecycleStatus,
  Bidder,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS Country,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _BusinessPartnerSupplier.Supplier AS Supplier,
  _SourcingProject.SourcingProject AS SourcingProject,
  _SourcingProject.SourcingProjectVersion AS SourcingProjectVersion,
  _SourcingProject.SrcgProjLifecycleStatus AS SrcgProjLifecycleStatus,
  _SourcingProject.DocumentCurrency AS DocumentCurrency,
  _SourcingProject.ExchangeRateType AS ExchangeRateType,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  SrcgProjQtnOfferCurrency,
  _SrcgProjQuotationDeviation.SrcgProjQtnDeviationAmount AS SrcgProjQtnDeviationAmount,
  _SrcgProjQuotationDeviation.SrcgProjQtnDeviationPercent AS SrcgProjQtnDeviationPercent,
  _UnitOfMeasure.UnitOfMeasure AS UnitOfMeasure,
  SourcingProjectQuotationType,
  SourcingProjectUUID,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SrcgProjQtnSuitability,
  _SrcgProjQtnSuitabilityTxt[1:Language = $session.system_language ].SrcgProjQtnSuitabilityText AS SrcgProjQtnSuitabilityText,
  IsEndOfPurposeBlocked,
  MaterialGroup,
  PurchasingCategory,
  cast ( '' as boole_d preserving type ) AS UICT_InAwarding,
  cast ( '' as boole_d preserving type ) AS UICT_InNegotiation,
  cast ( '' as boole_d preserving type ) AS UICT_CurrencyConversionError,
  SourcingProjectNegotiationUUID,
  _SourcingProjectNegotiation.SourcingProjectNegotiationType AS SourcingProjectNegotiationType,
  SourcingEnvelopeOverallStatus
FROM R_SourcingProjectQuotation
LEFT OUTER JOIN I_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON Bidder = _BusinessPartnerSupplier.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN P_SrcgProjQuotationDeviation AS _SrcgProjQuotationDeviation ON SourcingProjectQuotationUUID = _SrcgProjQuotationDeviation.SourcingProjectQuotationUUID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = '%'  -- association [0..1]
LEFT OUTER JOIN I_SrcgProjQtnSuitabilityTxt AS _SrcgProjQtnSuitabilityTxt ON SrcgProjQtnSuitability = _SrcgProjQtnSuitabilityTxt.SrcgProjQtnSuitability  -- association [0..*]
LEFT OUTER JOIN E_SourcingProjectQuotation AS _Extension ON SourcingProjectQuotationUUID = _Extension.SourcingProjectQuotationUUID  -- association [1..1]
LEFT OUTER JOIN R_SourcingProjectNegotiation AS _SourcingProjectNegotiation ON SourcingProjectNegotiationUUID = _SourcingProjectNegotiation.SourcingProjectNegotiationUUID  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON country = _Country.Country  -- association [0..1]
;