I_ISLM_P_IS_DATA

DDL: I_ISLM_P_IS_DATA Type: view_entity
6 Fields 5 Data Sources

Get the IS Data

I_ISLM_P_IS_DATA is a CDS View that provides data about "Get the IS Data" in SAP S/4HANA. It reads from 5 data sources (islm_ps, islm_mdlctxcc, islm_trmodel, islm_mdlvrsn, islm_mvdeploy) and exposes 6 fields.

Data Sources (5)

SourceAliasJoin Type
islm_ps a from
islm_mdlctxcc b left_outer
islm_trmodel c left_outer
islm_mdlvrsn d left_outer
islm_mvdeploy e left_outer

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Get the IS Data view

Fields (6)

KeyFieldSource TableSource FieldDescription
ps_name islm_ps name Zone name
mdlctx_name islm_mdlctxcc name Zone name
mdlctx_guid islm_mdlctxcc guid UUID 22 char.
mdl_guid islm_trmodel guid UUID 22 char.
mdlvrsn_guid islm_mdlvrsn guid UUID 22 char.
deploy_guid islm_mvdeploy deploy_guid Deployment Guid

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 I_ISLM_P_IS_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 I_ISLM_P_IS_DATA AS
SELECT
  a.name AS ps_name,
  b.name AS mdlctx_name,
  b.guid AS mdlctx_guid,
  c.guid AS mdl_guid,
  d.guid AS mdlvrsn_guid,
  e.deploy_guid AS deploy_guid
FROM islm_ps AS a
LEFT OUTER JOIN islm_mdlctxcc AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN islm_trmodel AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN islm_mdlvrsn AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN islm_mvdeploy AS e ON /* join condition not captured in parsed metadata */
;

Learn More