R_SourcingProjectQuotationTP

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 R_SourcingProjectQuotationTP.
-- 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 R_SourcingProjectQuotationTP AS
SELECT
  SourcingProjectQuotationUUID,
  SourcingProjectQuotation,
  SrcgProjQuotationVersion,
  SourcingProjectQuotationType,
  SourcingProjectQuotationName,
  SrcgProjQuotationIsSimulated,
  Bidder,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  SrcgProjQtnOfferCurrency,
  SrcgProjQtnTotNetAmt,
  SrcgProjQtnLifecycleStatus,
  SrcgProjQtnRevisionSts,
  SrcgProjQtnActvtnSts,
  SrcgProjQtnSubmsnSts,
  SrcgProjQtnAwardingStatus,
  SourcingProjectUUID,
  SourcingProjectNegotiationUUID,
  PricingProcedure,
  LastChangedByUser,
  CreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  SrcgProjAttchsAreForbidden,
  SrcgProjNotesAreForbidden,
  SourcingOrigin,
  ExternalSourcingProjectQtnRef,
  QtnLatestSubmissionDateTime,
  LogicalSystem,
  SourceSrcgProjQuotationUUID,
  IsEndOfPurposeBlocked,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  NetPaymentDays,
  MaterialGroup,
  SourcingAwardingDate,
  SrcgProjQtnSuitability,
  _SourcingProjectNegotiation.SourcingProjectNegotiationType AS SourcingProjectNegotiationType
FROM R_SourcingProjectQuotation
LEFT OUTER JOIN R_SourcingProjectNegotiation AS _SourcingProjectNegotiation ON SourcingProjectNegotiationUUID = _SourcingProjectNegotiation.SourcingProjectNegotiationUUID  -- association [0..1]
LEFT OUTER JOIN I_SrcgProjQtnSuitabilityTxt AS _SrcgProjQtnSuitabilityTxt ON SrcgProjQtnSuitability = _SrcgProjQtnSuitabilityTxt.SrcgProjQtnSuitability  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjSourcingOriginText AS _SrcgProjSourcingOriginText ON SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _OfferCurrencyText ON SrcgProjQtnOfferCurrency = _OfferCurrencyText.Currency  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_SourcingProjectTypeText AS _SourcingProjectTypeText ON SourcingProjectQuotationType = _SourcingProjectTypeText.SourcingProjectType  -- association [0..*]
LEFT OUTER JOIN E_SourcingProjectQuotation AS _Extension ON SourcingProjectQuotationUUID = _Extension.SourcingProjectQuotationUUID  -- association [1..1]
LEFT OUTER JOIN R_SrcgProjQtnItemTP AS _SrcgProjQtnItem ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnAllowedCurrencyTP AS _SrcgProjQtnAllowedCurrency ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnSupplierContactTP AS _SrcgProjQtnSupplierContact ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnNoteTP AS _SrcgProjQtnNote ON /* condition not available in parsed metadata */  -- association [*]
;