P_ISLM2_TR_MODEL

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_ISLM2_TR_MODEL.
-- 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_ISLM2_TR_MODEL AS
SELECT
  a.guid AS guid,
  a.name AS name,
  a.parent AS parent,
  a.model_type AS model_type,
  a.adapter_id AS adapter_id,
  cast( '' as islm_de_cruser ) AS created_by,
  cast( '' as islm_de_chuser ) AS changed_by,
  cast ( 'Transportable' as islm_de_mv_status ) AS status,
  a.new_model AS new_model,
  cast ( '' as devclass ) AS devclass,
  a.is_not_valid AS is_not_valid,
  '' AS DLG_SCVERSION_HASHID,
  '' AS ML_SC_VERSION,
  cast ( '' as islm2_de_model_state ) AS state
FROM islm_trmodel AS a
LEFT OUTER JOIN islm_modelcc AS b 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_trmodel AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN islm_modelcc AS c ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): islm_modelcc, islm_model
;