P_OperationalSupplierEval

DDL: P_OPERATIONALSUPPLIEREVAL SQL: POPERSEVL Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
32 Fields 2 Data Sources

Operational Supplier Evaluation

P_OperationalSupplierEval is a Consumption CDS View that provides data about "Operational Supplier Evaluation" in SAP S/4HANA. It reads from 2 data sources (P_SuplrEvalCriterionWeight, P_VendorEvaluationQtyN) and exposes 32 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
P_SuplrEvalCriterionWeight EvaluationWeight inner
P_VendorEvaluationQtyN P_VendorEvaluationQtyN from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate bedat
P_EndDate bedat

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName POPERSEVL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Operational Supplier Evaluation view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderDate PurchaseOrderDate PO Date
PurgDocMigrtnIsCmpltdForAnlyts PurgDocMigrtnIsCmpltdForAnlyts
PurchasingOrganization OperationalScore PurchasingOrganization Purchasing Organization
PurchasingGroup OperationalScore PurchasingGroup Purchasing Group
CompanyCode OperationalScore CompanyCode Receiver Company Code
Supplier OperationalScore Supplier Supplier
PurchasingDocumentCategory OperationalScore PurchasingDocumentCategory Doc. Category
Material OperationalScore Material Vehicle Model
MaterialGroup OperationalScore MaterialGroup Product Group
Plant OperationalScore Plant Valuation Area
PurchasingCategory OperationalScore PurchasingCategory Purchasing Category
PurgCatName OperationalScore PurgCatName Purchasing Cat. Name
DisplayCurrency
TimeVarianceScore TimeVarianceScore Time Variance Score
QualityNotificationScore QualityNotificationScore Quality Notif. Score
PriceVarianceScore PriceVarianceScore Price Variance Score
QuantityVarianceScore QuantityVarianceScore Quantity Var. Score
InspectionLotQualityScore InspectionLotQualityScore Inspection Lot Score
TimeVarianceScore1
QualityNotificationScore1
PriceVarianceScore1
QuantityVarianceScore1
InspectionLotQualityScore1
PriceVarianceCount PriceVarianceCount
QuantityVarianceCount QuantityVarianceCount
TimeVarianceCount TimeVarianceCount
InspectionLotQualityCount InspectionLotQualityCount
QualityNotificationCount QualityNotificationCount
SuplrEvalCritraDelivCompleted SuplrEvalCritraDelivCompleted
SuplrEvalRelevantDocCategory SuplrEvalRelevantDocCategory

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_OperationalSupplierEval.
-- 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: POPERSEVL
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_OperationalSupplierEval AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderDate,
  PurgDocMigrtnIsCmpltdForAnlyts,
  OperationalScore.PurchasingOrganization AS PurchasingOrganization,
  OperationalScore.PurchasingGroup AS PurchasingGroup,
  OperationalScore.CompanyCode AS CompanyCode,
  OperationalScore.Supplier AS Supplier,
  OperationalScore.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  OperationalScore.Material AS Material,
  OperationalScore.MaterialGroup AS MaterialGroup,
  OperationalScore.Plant AS Plant,
  OperationalScore.PurchasingCategory AS PurchasingCategory,
  OperationalScore.PurgCatName AS PurgCatName,
  cast($parameters.P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  TimeVarianceScore,
  QualityNotificationScore,
  PriceVarianceScore,
  QuantityVarianceScore,
  InspectionLotQualityScore,
  coalesce( TimeVarianceScore, 0 ) AS TimeVarianceScore1,
  coalesce( QualityNotificationScore, 0) AS QualityNotificationScore1,
  coalesce( PriceVarianceScore, 0) AS PriceVarianceScore1,
  coalesce( QuantityVarianceScore, 0 ) AS QuantityVarianceScore1,
  coalesce( InspectionLotQualityScore, 0 ) AS InspectionLotQualityScore1,
  PriceVarianceCount,
  QuantityVarianceCount,
  TimeVarianceCount,
  InspectionLotQualityCount,
  QualityNotificationCount,
  SuplrEvalCritraDelivCompleted,
  SuplrEvalRelevantDocCategory
FROM P_VendorEvaluationQtyN
INNER JOIN P_SuplrEvalCriterionWeight AS EvaluationWeight ON /* join condition not captured in parsed metadata */
;

Learn More