I_MstrProjAlertRisk

DDL: I_MSTRPROJALERTRISK SQL: IALERTRISK Type: view COMPOSITE
20 Fields 1 Data Sources

Master Project Alert Risk

I_MstrProjAlertRisk is a Composite CDS View that provides data about "Master Project Alert Risk" in SAP S/4HANA. It reads from 1 data source (P_MstrProjRisk) and exposes 20 fields.

Data Sources (1)

SourceAliasJoin Type
P_MstrProjRisk RiskMgmt from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IALERTRISK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label Master Project Alert Risk view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
MasterProject P_MstrProjRisk MasterProject Project ID
MasterProjectUUID P_MstrProjRisk MasterProjectUUID NodeID
MasterProjectType P_MstrProjRisk MasterProjectType
MasterProjectStage P_MstrProjRisk MasterProjectStage
StartDate P_MstrProjRisk StartDate Valid From
EndDate P_MstrProjRisk EndDate Term to
Customer P_MstrProjRisk Customer Sold-to Party
MasterProjectOrganization P_MstrProjRisk MasterProjectOrganization
MasterProjectIsConfidential P_MstrProjRisk MasterProjectIsConfidential
Country P_MstrProjRisk Country Venue: Ctry/Reg
Region P_MstrProjRisk Region Venue Region
WorkType P_MstrProjRisk WorkType SAF-T Work Type
Industry P_MstrProjRisk Industry Industry Sector
ProjectRisk P_MstrProjRisk ProjectRisk
FinancialRisk P_MstrProjRisk FinancialRisk
TechnicalRisk P_MstrProjRisk TechnicalRisk
OverallRisk P_MstrProjRisk OverallRisk
MasterProjectAlert
MstrProjAlertValue P_MstrProjRisk NumberOfHighRisks
UnitOfMeasure

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_MstrProjAlertRisk.
-- 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: IALERTRISK

CREATE VIEW I_MstrProjAlertRisk AS
SELECT
  RiskMgmt.MasterProject AS MasterProject,
  RiskMgmt.MasterProjectUUID AS MasterProjectUUID,
  RiskMgmt.MasterProjectType AS MasterProjectType,
  RiskMgmt.MasterProjectStage AS MasterProjectStage,
  RiskMgmt.StartDate AS StartDate,
  RiskMgmt.EndDate AS EndDate,
  RiskMgmt.Customer AS Customer,
  RiskMgmt.MasterProjectOrganization AS MasterProjectOrganization,
  RiskMgmt.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  RiskMgmt.Country AS Country,
  RiskMgmt.Region AS Region,
  RiskMgmt.WorkType AS WorkType,
  RiskMgmt.Industry AS Industry,
  RiskMgmt.ProjectRisk AS ProjectRisk,
  RiskMgmt.FinancialRisk AS FinancialRisk,
  RiskMgmt.TechnicalRisk AS TechnicalRisk,
  RiskMgmt.OverallRisk AS OverallRisk,
  cast('0RM' as /cpd/pwsc_alert_id) AS MasterProjectAlert,
  RiskMgmt.NumberOfHighRisks AS MstrProjAlertValue,
  ' ' AS UnitOfMeasure
FROM P_MstrProjRisk AS RiskMgmt
;

Learn More