C_EvaluationBySupplier

DDL: C_EVALUATIONBYSUPPLIER SQL: CEVALBYSUPPLIER Type: view CONSUMPTION Package: ODATA_MASTER_DATA_SUPPLIER_FS
14 Fields 1 Data Sources 1 Associations 1 OData Services

Supplier Scorecard Evaluation

C_EvaluationBySupplier is a Consumption CDS View that provides data about "Supplier Scorecard Evaluation" in SAP S/4HANA. It reads from 1 data source (I_SupplierEvalScorecard) and exposes 14 fields with key fields SuplrEvalScorecardUUID, Supplier. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F0354). Part of development package ODATA_MASTER_DATA_SUPPLIER_FS.

Data Sources (1)

SourceAliasJoin Type
I_SupplierEvalScorecard I_SupplierEvalScorecard from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_EvaluationScore _EvaluationScore $projection.SuplrEvalScorecardUUID = _EvaluationScore.SuplrEvalScorecardUUID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CEVALBYSUPPLIER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Supplier Scorecard Evaluation view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Supplier Evaluation view
UI.headerInfo.typeNamePlural Supplier Evaluations view
UI.headerInfo.title.label Supplier Evaluation view
UI.headerInfo.title.value SuplrEvalScorecardName view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F0354 ASQL_F0354 C2 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SuplrEvalScorecardUUID I_SupplierEvalScorecard SuplrEvalScorecardUUID
KEY Supplier _EvaluationSupplier Supplier Supplier
SupplierEvalScorecard I_SupplierEvalScorecard SupplierEvalScorecard
SuplrEvalScorecardName I_SupplierEvalScorecard SuplrEvalScorecardName
AuthorizationGroup _EvaluationSupplier AuthorizationGroup AuthorizGroup
SuplrEvalStartDate I_SupplierEvalScorecard SuplrEvalStartDate
SuplrEvalEndDate I_SupplierEvalScorecard SuplrEvalEndDate
PurchasingCategory
PurgCatName
CalculatedScore
CalculatedScoreValue
TargetScore
TargetScoreValue
NumberOfResponses

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_EvaluationBySupplier.
-- 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: CEVALBYSUPPLIER

CREATE VIEW C_EvaluationBySupplier AS
SELECT
  I_SupplierEvalScorecard.SuplrEvalScorecardUUID AS SuplrEvalScorecardUUID,
  _EvaluationSupplier.Supplier AS Supplier,
  I_SupplierEvalScorecard.SupplierEvalScorecard AS SupplierEvalScorecard,
  I_SupplierEvalScorecard.SuplrEvalScorecardName AS SuplrEvalScorecardName,
  _EvaluationSupplier.AuthorizationGroup AS AuthorizationGroup,
  I_SupplierEvalScorecard.SuplrEvalStartDate AS SuplrEvalStartDate,
  I_SupplierEvalScorecard.SuplrEvalEndDate AS SuplrEvalEndDate,
  cast(I_SupplierEvalScorecard._PurchasingCategory.PurchasingCategory as /srmsmc/purchasing_category_id) AS PurchasingCategory,
  I_SupplierEvalScorecard._PurchasingCategory.PurgCatName AS PurgCatName,
  cast(_EvaluationScore.CalculatedScore as /srmsmc/calculated_score) AS CalculatedScore,
  cast(_EvaluationScore.CalculatedScoreValue as /srmsmc/calculated_score) AS CalculatedScoreValue,
  cast(_EvaluationScore.TargetScore as /srmsmc/target_score) AS TargetScore,
  cast(_EvaluationScore.TargetScoreValue as /srmsmc/target_score) AS TargetScoreValue,
  cast(_EvaluationScore.NumberOfResponses as /srmsmc/response_count) AS NumberOfResponses
FROM I_SupplierEvalScorecard
LEFT OUTER JOIN P_EvaluationScore AS _EvaluationScore ON SuplrEvalScorecardUUID = _EvaluationScore.SuplrEvalScorecardUUID  -- association [0..1]
;

Learn More