APS_IAM_APP_APPS_LIST_DDL

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 APS_IAM_APP_APPS_LIST_DDL.
-- 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.
-- SQL view name: APS_IAM_APPS_L
-- Parameters: p_langu : lang

CREATE VIEW APS_IAM_APP_APPS_LIST_DDL AS
SELECT
  case when ( feature_toggle.FeatureToggle = 'APS_IAM_APP_AS_ENTITY' and feature_toggle.Status = 'X' ) and bc.app_migration_status = '3' then w_app.tcode else app.fiori_id end as FioriId AS fiori_idendasFioriId,
  app.reference_id AS FioriAppID,
  case when ( feature_toggle.FeatureToggle = 'APS_IAM_APP_AS_ENTITY' and feature_toggle.Status = 'X' ) and bc.app_migration_status = '3' then w_app.app_id else '' end as FioriTransaction AS app_idelseendasFioriTransaction,
  w_app.app_type AS AppType,
  app.bu_catalog_id AS BusinessCatalog,
  text.text AS Title,
  text.subtitle AS SubTitle,
  scope.scope_state AS ScopeState,
  catalog.text AS CatalogTitle,
  app.bu_catalog_app_id AS BuCatalogAppId,
  app.chip_id AS InternalId,
  text.langu AS langu,
  '' AS SuppressTile,
  app.tm_only AS TargetMappingOnly,
  '' AS TcodeText,
  '' as Deprecated AS tcodeasFioriId,
  app.app_id AS FioriTransaction,
  '' as Deprecated AS langup_languasFioriId,
  case when sp_application_text.text is null then sp_bucapp.app_id else sp_application_text.text end as Title AS textendasTitle,
  '' AS Deprecated
FROM aps_iam_a_apps AS app
LEFT OUTER JOIN aps_iam_a_appst AS text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_bucapp AS bucapp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_app AS w_app ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_bu_cat AS bc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_bucatt AS catalog ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_c_bu_cat AS scope ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN p_aps_iam_feature_scope_c AS feature_toggle ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_app AS app ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_appt AS app_text ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_w_bu_cat AS catalog ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_bucatt AS catalog_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_c_app AS app_scope ON /* join condition not captured in parsed metadata */
INNER JOIN p_aps_iam_feature_scope_c AS feature_toggle ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN r_aps_iam_app_core_tile_assign AS tile_assignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_app AS sp_application ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_appt AS sp_application_text ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): aps_iam_w_bc_app, aps_iam_w_bucapp
;