I_SupplierEvalResponse

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_SupplierEvalResponse.
-- 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: ISUPLREVALRESP

CREATE VIEW I_SupplierEvalResponse AS
SELECT
  cast(db_key as /srmsmc/srs_uuid preserving type) AS SuplrEvalRspUUID,
  cast(node_cat_key as /srmsmc/category preserving type) AS SupplierEvalResponseCatType,
  cast(id as /srmsmc/evaluation_response_id preserving type) AS SupplierEvalResponse,
  cast(name as /srmsmc/srs_name preserving type) AS SuplrEvalRspName,
  cast(eval_start_date as /srmsmc/start_date preserving type) AS SuplrEvalStartDate,
  cast(eval_end_date as /srmsmc/end_date preserving type) AS SuplrEvalEndDate,
  cast(submission_date as /srmsmc/submission_date_ts preserving type) AS SuplrEvalSubmissionDateTime,
  cast(crea_date_time as /srmsmc/created_on_ts preserving type) AS CreationDateTime,
  cast(deadline as /srmsmc/deadline preserving type) AS SuplrEvalDeadlineDate,
  cast(puc_key as /srmsmc/puc_uuid preserving type) AS PurgCatUUID,
  cast( crea_uname as vdm_createdbyuserid) AS CreatedByUser,
  cast( lchg_date_time as /srmsmc/last_changed_on_ts preserving type) AS LastChangeDateTime,
  cast( lchg_uname as vdm_lastchangedbyuserid) AS LastChangedByUser,
  cast(language_code as /srmsmc/language preserving type) AS Language,
  cast( lifecycle_stcd as /srmsmc/status preserving type) AS SuplrEvalRspLifecycleStatus
FROM /srmsmc/d_srs_rt
LEFT OUTER JOIN I_PurchasingCategory AS _PurchasingCategory ON PurgCatUUID = _PurchasingCategory.PurgCatUUID  -- association [0..1]
LEFT OUTER JOIN I_SupplierEvalRspAppraiser AS _Appraiser ON SuplrEvalRspUUID = _Appraiser.SuplrEvalRspUUID  -- association [0..1]
LEFT OUTER JOIN I_SupplierEvalRspPurchaserResp AS _PurchaserResponsible ON SuplrEvalRspUUID = _PurchaserResponsible.SuplrEvalRspUUID  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SupplierEvalResponseLanguage AS _SupplierEvalResponseLanguage ON _SupplierEvalResponseLanguage.SuplrEvalRspUUID = SuplrEvalRspUUID  -- association [1..*]
LEFT OUTER JOIN I_SupplierEvalResponseQnaire AS _SupplierEvalResponseQnaire ON _SupplierEvalResponseQnaire.SuplrEvalRspUUID = SuplrEvalRspUUID  -- association [0..*]
LEFT OUTER JOIN I_SupplierEvalResponseExtName AS _SupplierEvalResponseExtName ON SuplrEvalRspUUID = _SupplierEvalResponseExtName.SuplrEvalRspUUID  -- association [0..*]
LEFT OUTER JOIN I_SupplierEvalRespSuplrParty AS _Supplier ON SuplrEvalRspUUID = _Supplier.SuplrEvalRspUUID  -- association [0..1]
LEFT OUTER JOIN I_SuplrEvalRspLifecycleStsCM AS _SuplrEvalRspLifecycleStsCM ON SuplrEvalRspLifecycleStatus = _SuplrEvalRspLifecycleStsCM.SuplrEvalRspLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_SuplrEvalRspLifecycleStsApp AS _SuplrEvalRspLifecycleStsApp ON SuplrEvalRspLifecycleStatus = _SuplrEvalRspLifecycleStsApp.SuplrEvalRspLifecycleStatus  -- association [0..1]
;