P_QltyNotifUpdatedScore

DDL: P_QLTYNOTIFUPDATEDSCORE SQL: PQLTYNOTIUPDTSCR Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
4 Fields 2 Data Sources

Quality Notification Updated Score

P_QltyNotifUpdatedScore is a Consumption CDS View that provides data about "Quality Notification Updated Score" in SAP S/4HANA. It reads from 2 data sources (P_QltyNotifLastUpdated, I_SuplrEvalAdjmtScore) and exposes 4 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
P_QltyNotifLastUpdated LastUpdated inner
I_SuplrEvalAdjmtScore SupplierScore from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PQLTYNOTIUPDTSCR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Quality Notification Updated Score view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_SuplrEvalAdjmtScore PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_SuplrEvalAdjmtScore PurchaseOrderItem Purchasing Document Item
IsScoreChanged I_SuplrEvalAdjmtScore IsScoreChanged Score Changed
QualityNotificationScore

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_QltyNotifUpdatedScore.
-- 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: PQLTYNOTIUPDTSCR

CREATE VIEW P_QltyNotifUpdatedScore AS
SELECT
  SupplierScore.PurchaseOrder AS PurchaseOrder,
  SupplierScore.PurchaseOrderItem AS PurchaseOrderItem,
  SupplierScore.IsScoreChanged AS IsScoreChanged,
  cast( SupplierScore.NewScore as mm_a_variance_score ) AS QualityNotificationScore
FROM I_SuplrEvalAdjmtScore AS SupplierScore
INNER JOIN P_QltyNotifLastUpdated AS LastUpdated ON /* join condition not captured in parsed metadata */
;

Learn More