APS_IAM_INFO_APP_DEP_BASIC

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_INFO_APP_DEP_BASIC.
-- 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 APS_IAM_INFO_APP_DEP_BASIC AS
SELECT
  app.app_id AS AppAuthVariantID,
  _DependentApps.dep_app_id AS DepAppAuthVariantID,
  app.tcode AS FioriTransaction,
  _AppDescription.text AS ApplicationText,
  _DepAppDescription.text AS DependentApplicationText,
  app.abap_language_version AS AbapLanguageVersion,
  app.rel_for_cust_cat_ext AS RelForCustCatExt,
  _DependentApps.dep_type AS DependencyType,
  _DependentApps.navigation_target AS IsNavigationTarget,
  app.app_type AS AppType
FROM aps_iam_w_app AS app
INNER JOIN aps_iam_w_appdep AS _DependentApps ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_app AS dep_app ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_c_app AS scope ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_c_app AS dep_scope ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_appt AS _AppDescription ON _AppDescription.app_id = app.app_id AND _AppDescription.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN aps_iam_w_appt AS _DepAppDescription ON _DepAppDescription.app_id = _DependentApps.dep_app_id AND _DepAppDescription.langu = $session.system_language  -- association [0..1]
;