P_Riskmanagement

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_Riskmanagement.
-- 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: PRISKMNGMT

CREATE VIEW P_Riskmanagement AS
SELECT
  Root.db_key AS db_key,
  Root.node_cat_key AS node_cat_key,
  Root.issue_id AS issue_id,
  Root.application AS application,
  Root.object_guid AS object_guid,
  Root.risk_status AS risk_status,
  Root.risk_id AS risk_id,
  Root.cat_id AS cat_id,
  Root.sub_cat_id AS sub_cat_id,
  Root.risk_txt AS risk_txt,
  Root.severity_id AS severity_id,
  RiskMgmtSever.value AS SevID,
  RiskMgmtProb.value AS ProbID,
  cast(RiskMgmtSever.value as abap.int4) * cast(RiskMgmtProb.value as abap.int4) AS Score,
  MasterProject.db_key AS MasterProjectUUID,
  MasterProject.mp_id AS MasterProject,
  MasterProject.mp_type AS MasterProjectType,
  MasterProject.mp_stage AS MasterProjectStage,
  MasterProject.start_date AS StartDate,
  MasterProject.end_date AS EndDate,
  MasterProject.customer AS Customer,
  MasterProject.org_id AS MasterProjectOrganization,
  MasterProject.confidential AS MasterProjectIsConfidential,
  MasterProject.country AS Country,
  MasterProject.region AS Region,
  MasterProject.work_type AS WorkType,
  MasterProject.industry AS Industry,
  MasterProject.proj_risk AS ProjectRisk,
  MasterProject.fin_risk AS FinancialRisk,
  MasterProject.tech_risk AS TechnicalRisk,
  MasterProject.overall_risk AS OverallRisk,
  bintohex(MasterProject.db_key) AS MasterProjectUUID_E
FROM /iam/d_i_root AS Root
INNER JOIN /cpd/c_rm_sever AS RiskMgmtSever ON /* join condition not captured in parsed metadata */
INNER JOIN /cpd/c_rm_prob AS RiskMgmtProb ON /* join condition not captured in parsed metadata */
INNER JOIN /cpd/d_mp_hdr AS MasterProject ON /* join condition not captured in parsed metadata */
;