P_ISLM3_TR_MODELS

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_ISLM3_TR_MODELS.
-- 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 P_ISLM3_TR_MODELS AS
SELECT
  a.guid AS guid,
  cast( a.name as islm2_de_model_name ) AS name,
  a.parent AS parent,
  c.name AS ps_name,
  a.description AS description,
  case a.adapter_id when '' then 'UMML4HANA/APL' else a.adapter_id end AS adapter_id,
  a.state AS state,
  a.signature AS signature,
  a.bindings AS bindings,
  a.new_model AS new_model,
  t.devclass AS devclass,
  a.obsoleted_at AS obsoleted_at,
  cast ( '' as islm_de_hashid ) AS DLG_SCVERSION_HASHID,
  a.is_not_valid AS is_not_valid
FROM islm_modelcc AS a
INNER JOIN p_islm2_mdlctx AS b ON /* join condition not captured in parsed metadata */
INNER JOIN islm_ps AS c ON /* join condition not captured in parsed metadata */
INNER JOIN tadir AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN islm_modelcc AS d ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): islm_trmodel
;