C_SupplierQuotationDP

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_SupplierQuotationDP.
-- 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_SupplierQuotationDP AS
SELECT
  SupplierQuotation,
  RequestForQuotation,
  SupplierQuotationExternalID,
  QuotationSubmissionDate,
  QuotationLatestSubmissionDate,
  BindingPeriodValidityEndDate,
  ExchangeRate,
  ExchangeRateIsFixed,
  QtnLifecycleStatus,
  FollowOnDocumentCategory,
  FollowOnDocumentType AS PurgDocFollowOnDocumentType,
  IsEndOfPurposeBlocked,
  PurchasingDocumentOrderDate,
  CompanyCode,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  Supplier,
  CreatedByUser,
  CreationDate,
  LastChangeDateTime,
  Language,
  DocumentCurrency,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  NetPaymentDays,
  PricingProcedure,
  PurchasingDocumentCondition AS PricingDocument,
  PurchasingOrganization,
  PurchasingGroup
FROM I_SupplierQuotation_Api01
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_PurchasingDocumentCategoryDP AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN C_PurchasingDocumentTypeDP AS _PurchasingDocumentType ON PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrganizationDP AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN C_PurchasingGroupDP AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN C_PurchasingDocumentCategoryDP AS _FollowOnDocumentCategory ON FollowOnDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN C_PurchasingDocumentTypeDP AS _PurgDocFollowOnDocumentType ON FollowOnDocumentCategory = _PurgDocFollowOnDocumentType.PurchasingDocumentCategory AND PurgDocFollowOnDocumentType = _PurgDocFollowOnDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN C_RequestForQuotationDP AS _RequestForQuotation ON RequestForQuotation = _RequestForQuotation.RequestForQuotation  -- association [1..1]
;