ISLM_CDS_AGENT_INT_DATA

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 ISLM_CDS_AGENT_INT_DATA.
-- 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.

CREATE VIEW ISLM_CDS_AGENT_INT_DATA AS
SELECT
  a.interaction_guid AS InteractionGuid,
  a.scenario_name AS ScenarioName,
  a.interaction_id AS InteractionId,
  a.version AS Version,
  a.schema_version AS SchemaVersion,
  a.query AS Query,
  a.status AS Status,
  a.created_by AS CreatedBy,
  a.created_at AS CreatedAt,
  a.changed_by AS ChangedBy,
  a.changed_at AS ChangedAt,
  b.plan_guid AS PlanGuid,
  b.parent AS Parent,
  b.version AS plan_Version,
  b.description AS Description,
  b.exec_plan AS ExecPlan,
  b.status AS exec_Status,
  b.context AS Context,
  b.error AS Error,
  b.thought AS Thought,
  b.previous_execution AS PreviousExecution,
  b.is_last_execution AS IsLastExecution,
  b.created_at AS exec_CreatedAt,
  b.changed_at AS exec_ChangedAt
FROM islm_ag_interact AS a
INNER JOIN islm_ag_execplan AS b ON /* join condition not captured in parsed metadata */
;