P_VendorEvaluation

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 P_VendorEvaluation.
-- 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: PMMVENDEVAL
-- Parameters: P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_VendorEvaluation AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderDate,
  NetAmount,
  DocumentCurrency,
  PurgDocMigrtnIsCmpltdForAnlyts,
  SuplrEvalRelevantDocCategory,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  Supplier,
  Material,
  MaterialGroup,
  Plant,
  PurchasingDocumentCategory,
  min(PurOrdItmFirstGRPostingDate) AS PurOrdItmFirstGRPostingDate,
  max(PurOrdItmFinalGRPostingDate) AS PurOrdItmFinalGRPostingDate,
  cast(I_CalendarYear.NumberOfDays as mm_a_variance_score ) AS PriceVarianceScore,
  cast(I_CalendarYear.NumberOfDays as mm_a_variance_score ) AS QuantityVarianceScore,
  avg(TimeVarianceScore as mm_a_variance_score) AS TimeVarianceScore,
  cast(I_CalendarYear.NumberOfDays as mm_pur_ana_quality_var_score ) AS InspectionLotQualityScore,
  cast(I_CalendarYear.NumberOfDays as mm_a_variance_score ) AS QualityNotificationScore,
  cast(0 as mm_pur_ana_variance_count ) AS PriceVarianceCount,
  cast(0 as mm_pur_ana_variance_count ) AS QuantityVarianceCount,
  cast(1 as mm_pur_ana_variance_count ) AS TimeVarianceCount,
  cast(0 as mm_pur_ana_variance_count ) AS InspectionLotQualityCount,
  cast(0 as mm_pur_ana_variance_count ) AS QualityNotificationCount,
  cast(0 as abap.int4 ) AS QualityNotificationExist,
  CriteriaConfig.SuplrEvalCritraDelivCompleted AS P_StartDate,
  CriteriaConfig.SuplrEvalCritraDelivCompleted AS SuplrEvalCritraDelivCompleted
FROM P_TimeVariance
LEFT OUTER JOIN I_SuplrEvalCriteriaGenConfign AS CriteriaConfig ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarYear ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_PriceVarianceOpsSEUpdated, P_SEByQuantityUpdatedScore, P_SuplrEvalByQuality, P_SuplrEvalByQualityNotif
;