P_ISLM3_LOCAL_MODELS

DDL: P_ISLM3_LOCAL_MODELS Type: view_entity
11 Fields 3 Data Sources

Local models

P_ISLM3_LOCAL_MODELS is a CDS View that provides data about "Local models" in SAP S/4HANA. It reads from 3 data sources (islm_model, p_islm2_mdlctx, islm_ps) and exposes 11 fields with key field guid.

Data Sources (3)

SourceAliasJoin Type
islm_model a from
p_islm2_mdlctx b inner
islm_ps c inner

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Local models view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY guid islm_model guid UUID 22 char.
name
parent islm_model parent UUID
ps_name islm_ps name Zone name
description islm_model description Well Code Des.
adapter_id
state
signature
bindings
new_model
devclass islm_model devclass Package (Obsolete)

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_LOCAL_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_LOCAL_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,
  cast ( '' as islm2_de_model_state ) AS state,
  '' AS signature,
  '' AS bindings,
  cast ( '' as islm3_de_new_model_flag ) AS new_model,
  a.devclass AS devclass
FROM islm_model 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 */
;

Learn More