C_SrcgProjectQuotationTP_F7758

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_SrcgProjectQuotationTP_F7758.
-- 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_SrcgProjectQuotationTP_F7758 AS
SELECT
  SourcingProjectQuotationUUID,
  SourcingProjectQuotation,
  SrcgProjQuotationVersion,
  SourcingProjectQuotationType,
  _SourcingProjectTypeText.SourcingProjectTypeText : localized AS SourcingProjectTypeTextlocalized,
  SourcingProjectQuotationName,
  SrcgProjQuotationIsSimulated,
  virtual UICT_SrcgProjQtnIsSimulated : abap.int1 AS int1,
  Bidder,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  SrcgProjQtnOfferCurrency,
  _OfferCurrencyText.CurrencyName : localized AS CurrencyNamelocalized,
  SrcgProjQtnLifecycleStatus,
  _SrcgProjQtnLifecycleSts._Text.SrcgProjQtnLifecycleStatusName : localized AS SrcgProjQtnLifecycleStatusNamelocalized,
  SrcgProjQtnRevisionSts,
  SrcgProjQtnActvtnSts,
  SrcgProjQtnSubmsnSts,
  SrcgProjQtnAwardingStatus,
  SourcingProjectUUID,
  SourcingProjectNegotiationUUID,
  PricingProcedure,
  LastChangedByUser,
  CreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  SrcgProjAttchsAreForbidden,
  SrcgProjNotesAreForbidden,
  SourcingOrigin,
  _SrcgProjSourcingOriginText.SrcgProjSourcingOriginText : localized AS SrcgProjSourcingOriginTextlocalized,
  ExternalSourcingProjectQtnRef,
  QtnLatestSubmissionDateTime,
  LogicalSystem,
  SourceSrcgProjQuotationUUID,
  IsEndOfPurposeBlocked,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  NetPaymentDays,
  PurchasingCategory,
  _PurchasingCategory.PurgCatName AS PurgCatName,
  MaterialGroup,
  _MaterialGroupText.MaterialGroupName : localized AS MaterialGroupNamelocalized,
  SourcingAwardingDate,
  LglCntntMLinkdObj,
  _SrcgProjQtnSuitabilityTxt.SrcgProjQtnSuitabilityText : localized AS SrcgProjQtnSuitabilityTextlocalized,
  SrcgProjQtnSuitability,
  _SourcingProject.SourcingProject AS SourcingProject,
  _SourcingProject.SourcingProjectVersion AS SourcingProjectVersion,
  _SourcingProject.ExchangeRateType AS ExchangeRateType,
  _SourcingProject.DocumentCurrency AS DocumentCurrency,
  _SourcingProjectNegotiation.SourcingProjectNegotiation AS SourcingProjectNegotiation,
  _SourcingProjectNegotiation.SourcingProjectNegotiationName AS SourcingProjectNegotiationName,
  _SourcingProjectNegotiation.SourcingProjectNegotiationType AS SourcingProjectNegotiationType,
  _SourcingProjectNegotiation._SrcgProjNegotiationType._Text.SrcgProjectNegotiationTypeName : localized AS SrcgProjectNegotiationTypeNamelocalized,
  virtual IsLglTransIntegEnabled : abap.char( 1 ) AS char1,
  virtual SrcgProjQtnIsInPreparation : boolean AS virtualSrcgProjQtnIsInPreparationboolean,
  virtual NoteTypeListText : abap.char( 450 ) AS char450,
  virtual UICT_CurrConvCriticality : int1 AS virtualUICT_CurrConvCriticalityint1,
  cast(_DeviationPercentUnit.UnitOfMeasure as vdm_deviation_percent_unit preserving type ) AS DeviationPercentUnit,
  SourcingEnvelopeOverallStatus
FROM R_SourcingProjectQuotationTP
LEFT OUTER JOIN C_SrcgProjQtnLegalTransaction AS _LegalTransaction ON _LegalTransaction.LglCntntMLinkdObj = LglCntntMLinkdObj AND _LegalTransaction.LglCntntMIntegrationLink = 'SQN'  -- association [0..*]
LEFT OUTER JOIN R_SrcgProjQtnContrbnForUser AS _ContributionForUser ON SourcingProjectQuotationUUID = _ContributionForUser.SourcingProjectQuotationUUID  -- association [0..1]
;