P_ISLM2_RELEASED_CDS

DDL: P_ISLM2_RELEASED_CDS Type: view_entity Package: S_INTSCN_LM_DB

List of released CDS views

P_ISLM2_RELEASED_CDS is a CDS View that provides data about "List of released CDS views" in SAP S/4HANA. It reads from 3 data sources (ddheadanno, ARS_APIS_RELEASED_C1_OR_GROUPS, ddddlsrc) and exposes 5 fields with key field ddl_name. Part of development package S_INTSCN_LM_DB.

Data Sources (3)

SourceAliasJoin Type
ddheadanno _AnaQueryAnno left_outer
ARS_APIS_RELEASED_C1_OR_GROUPS _released_for_c1_or_group inner
ddddlsrc _src_released inner

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label List of released CDS views view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ddl_name ddddlsrc ddlname DDL Source Name
object_type ARS_APIS_RELEASED_C1_OR_GROUPS object_type Type
object_key ARS_APIS_RELEASED_C1_OR_GROUPS object_key UUID
tadir_object ARS_APIS_RELEASED_C1_OR_GROUPS tadir_object Object Type
state ARS_APIS_RELEASED_C1_OR_GROUPS state Vehicle Region

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_RELEASED_CDS.
-- 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_RELEASED_CDS AS
SELECT
  _src_released.ddlname AS ddl_name,
  _released_for_c1_or_group.object_type AS object_type,
  _released_for_c1_or_group.object_key AS object_key,
  _released_for_c1_or_group.tadir_object AS tadir_object,
  _released_for_c1_or_group.state AS state
INNER JOIN ddddlsrc AS _src_released ON /* join condition not captured in parsed metadata */
INNER JOIN ARS_APIS_RELEASED_C1_OR_GROUPS AS _released_for_c1_or_group ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS _AnaQueryAnno ON /* join condition not captured in parsed metadata */
;