C_SupplierQuotationDEX

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_SupplierQuotationDEX.
-- 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.
-- SQL view name: CMMSUPLRSQTNDEX

CREATE VIEW C_SupplierQuotationDEX AS
SELECT
  SupplierQuotation.SupplierQuotation AS SupplierQuotation,
  SupplierQuotation.CompanyCode AS CompanyCode,
  SupplierQuotation.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  SupplierQuotation.PurchasingDocumentType AS PurchasingDocumentType,
  SupplierQuotation.Supplier AS Supplier,
  SupplierQuotation.CreatedByUser AS CreatedByUser,
  SupplierQuotation.CreationDate AS CreationDate,
  SupplierQuotation.LastChangeDateTime AS LastChangeDateTime,
  SupplierQuotation.Language AS Language,
  SupplierQuotation.DocumentCurrency AS DocumentCurrency,
  SupplierQuotation.IncotermsClassification AS IncotermsClassification,
  SupplierQuotation.IncotermsTransferLocation AS IncotermsTransferLocation,
  SupplierQuotation.IncotermsVersion AS IncotermsVersion,
  SupplierQuotation.IncotermsLocation1 AS IncotermsLocation1,
  SupplierQuotation.IncotermsLocation2 AS IncotermsLocation2,
  SupplierQuotation.PaymentTerms AS PaymentTerms,
  SupplierQuotation.CashDiscount1Days AS CashDiscount1Days,
  SupplierQuotation.CashDiscount2Days AS CashDiscount2Days,
  SupplierQuotation.CashDiscount1Percent AS CashDiscount1Percent,
  SupplierQuotation.CashDiscount2Percent AS CashDiscount2Percent,
  SupplierQuotation.NetPaymentDays AS NetPaymentDays,
  SupplierQuotation.PricingProcedure AS PricingProcedure,
  SupplierQuotation.PurchasingDocumentCondition AS PricingDocument,
  SupplierQuotation.PurchasingOrganization AS PurchasingOrganization,
  SupplierQuotation.PurchasingGroup AS PurchasingGroup,
  SupplierQuotation.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  SupplierQuotation.RequestForQuotation AS RequestForQuotation,
  SupplierQuotation.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  SupplierQuotation.QuotationSubmissionDate AS QuotationSubmissionDate,
  SupplierQuotation.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  SupplierQuotation.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  SupplierQuotation.ExchangeRate AS ExchangeRate,
  SupplierQuotation.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  SupplierQuotation.QTNLifecycleStatus AS QtnLifecycleStatus,
  SupplierQuotation.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  SupplierQuotation.FollowOnDocumentType AS PurgDocFollowOnDocumentType,
  SupplierQuotation.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_SupplierQuotation_Api01 AS SupplierQuotation
LEFT OUTER JOIN E_PurchasingDocument AS _SupplierQuotationExtension ON SupplierQuotation = _SupplierQuotationExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN C_RequestForQuotationDEX AS _RequestForQuotation ON RequestForQuotation = _RequestForQuotation.RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType 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_Language AS _Language ON Language = _Language.Language  -- association [0..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 I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _FollowOnDocumentCategory ON FollowOnDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurgDocFollowOnDocumentType ON FollowOnDocumentCategory = _PurgDocFollowOnDocumentType.PurchasingDocumentCategory AND PurgDocFollowOnDocumentType = _PurgDocFollowOnDocumentType.PurchasingDocumentType  -- association [0..1]
;