I_SupplierEvalScorecardQnaire

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_SupplierEvalScorecardQnaire.
-- 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: ISUPEVALSCQNR

CREATE VIEW I_SupplierEvalScorecardQnaire AS
SELECT
  cast (db_key as /srmsmc/ses_qnr_uuid preserving type ) AS SuplrEvalScorecardQnaireUUID,
  cast(parent_key as /srmsmc/ses_uuid preserving type) AS SuplrEvalScorecardUUID,
  qnr_name AS QuestionnaireName,
  cast (qnr_id as /srmsmc/ses_qnr_id preserving type) AS SupplierEvalScorecardQnaire,
  node_cat_key AS SuplrEvalScorecardQnaireCat,
  cast(parent_hier_key as /srmsmc/ses_parent_hier_uuid preserving type) AS SuplrEvalScorecardRtQnaireUUID,
  cast(minimal_score as /srmsmc/minimal_score preserving type) AS MinimalScore,
  cast(target_score as /srmsmc/target_score preserving type) AS TargetScore,
  calculated_score AS CalculatedScore,
  responses AS NumberOfResponses,
  weight_fac_val AS WeightingFactor,
  ordinal_no_val AS SuplrEvalOrdinalNumber
FROM /srmsmc/d_ses_qr
LEFT OUTER JOIN I_SupplierEvalScorecard AS _SupplierEvalScorecard ON SuplrEvalScorecardUUID = _SupplierEvalScorecard.SuplrEvalScorecardUUID  -- association [1..1]
;