P_MstrProjRisk

DDL: P_MSTRPROJRISK SQL: PRISKLEVEL Type: view COMPOSITE
17 Fields 1 Data Sources

P_MstrProjRisk is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_MstrProjRiskLevel) and exposes 17 fields.

Data Sources (1)

SourceAliasJoin Type
P_MstrProjRiskLevel RiskMgmt from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PRISKLEVEL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (17)

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

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_MstrProjRisk.
-- 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: PRISKLEVEL

CREATE VIEW P_MstrProjRisk 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
FROM P_MstrProjRiskLevel AS RiskMgmt
;

Learn More