I_ProcmtIntegSuplrRskLvNotif

DDL: I_PROCMTINTEGSUPLRRSKLVNOTIF SQL: ISUPLIVNOTIF Type: view BASIC Package: MMPUR_INTEGRATION_SUPP_RISK
7 Fields 1 Data Sources

Supplier Risk Live Notification in Procurement Integration

I_ProcmtIntegSuplrRskLvNotif is a Basic CDS View that provides data about "Supplier Risk Live Notification in Procurement Integration" in SAP S/4HANA. It reads from 1 data source (mmpur_sup_notif) and exposes 7 fields with key field Supplier. Part of development package MMPUR_INTEGRATION_SUPP_RISK.

Data Sources (1)

SourceAliasJoin Type
mmpur_sup_notif mmpur_sup_notif from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISUPLIVNOTIF view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Supplier Risk Live Notification in Procurement Integration view
ObjectModel.uniqueIdField erp_supplier_id view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Supplier erp_supplier_id Supplier
SourceSystem source_system Source System
SupplierRiskLevel risk_level Risk Level
SupplierRiskRating risk_rating Risk Rating
AvailabilityStartDate supplier_state_date Date
CreationDescription incident_desc Char45
SupplierRiskScorePct score Valuation No.

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 I_ProcmtIntegSuplrRskLvNotif.
-- 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: ISUPLIVNOTIF

CREATE VIEW I_ProcmtIntegSuplrRskLvNotif AS
SELECT
  erp_supplier_id AS Supplier,
  source_system AS SourceSystem,
  risk_level AS SupplierRiskLevel,
  risk_rating AS SupplierRiskRating,
  supplier_state_date AS AvailabilityStartDate,
  incident_desc AS CreationDescription,
  score AS SupplierRiskScorePct
FROM mmpur_sup_notif
;

Learn More