P_EvaluationScore

DDL: P_EVALUATIONSCORE SQL: PEVALUATIONSCORE Type: view CONSUMPTION Package: ODATA_MASTER_DATA_SUPPLIER_FS
6 Fields 1 Data Sources

Scores of Questionnaires

P_EvaluationScore is a Consumption CDS View that provides data about "Scores of Questionnaires" in SAP S/4HANA. It reads from 1 data source (I_SuplrEvalScorecardRootQnaire) and exposes 6 fields with key field SuplrEvalScorecardUUID. Part of development package ODATA_MASTER_DATA_SUPPLIER_FS.

Data Sources (1)

SourceAliasJoin Type
I_SuplrEvalScorecardRootQnaire I_SuplrEvalScorecardRootQnaire from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PEVALUATIONSCORE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Scores of Questionnaires view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SuplrEvalScorecardUUID I_SuplrEvalScorecardRootQnaire SuplrEvalScorecardUUID
TargetScore I_SuplrEvalScorecardRootQnaire TargetScore
TargetScoreValue I_SuplrEvalScorecardRootQnaire TargetScore
CalculatedScore I_SuplrEvalScorecardRootQnaire CalculatedScore
CalculatedScoreValue I_SuplrEvalScorecardRootQnaire CalculatedScore
NumberOfResponses I_SuplrEvalScorecardRootQnaire 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 P_EvaluationScore.
-- 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: PEVALUATIONSCORE

CREATE VIEW P_EvaluationScore AS
SELECT
  I_SuplrEvalScorecardRootQnaire.SuplrEvalScorecardUUID AS SuplrEvalScorecardUUID,
  I_SuplrEvalScorecardRootQnaire.TargetScore AS TargetScore,
  I_SuplrEvalScorecardRootQnaire.TargetScore AS TargetScoreValue,
  I_SuplrEvalScorecardRootQnaire.CalculatedScore AS CalculatedScore,
  I_SuplrEvalScorecardRootQnaire.CalculatedScore AS CalculatedScoreValue,
  I_SuplrEvalScorecardRootQnaire.NumberOfResponses AS NumberOfResponses
FROM I_SuplrEvalScorecardRootQnaire
;

Learn More