cuan_prod_reco_search_task

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 cuan_prod_reco_search_task.
-- 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: CUAN_SEARCH_TASK

CREATE VIEW cuan_prod_reco_search_task AS
SELECT
  task.db_key AS DbKey,
  Root_key,
  Parent_Key,
  task_id,
  task.engine_id AS Engine_id,
  task.model_id AS Model_id,
  Step_id,
  Algo_id,
  Description,
  Max_result,
  Weight,
  Version,
  Name,
  Generation_Status,
  Generated_On,
  ddtext AS Generation_Status_T,
  case generation_status when '' then 'X' else '' end AS Gen_Status_Not_Generated,
  case generation_status when 'S' then 'X' else '' end AS Gen_Status_Successful,
  case generation_status when 'F' then 'X' else '' end AS Gen_Status_failed
FROM preco_d_task AS task
INNER JOIN preco_d_model AS model ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS text ON /* join condition not captured in parsed metadata */
;