aps_iam_app_core

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_core.
-- 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_app_core AS
SELECT
  app.app_id AS AppID,
  app.tcode AS TransactionCode,
  app.ui_app_id AS UIAppID,
  app.change_timestamp AS ChangedOn,
  app.change_user AS ChangedBy,
  app.app_type AS AppType,
  app.abap_language_version AS ABAPLanguageVersion,
  scope.scope_state AS ScopeState,
  app.scope_dependent AS ScopeDependent
LEFT OUTER JOIN aps_iam_w_bc_app AS bc_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 tadir AS td 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 */
INNER JOIN p_aps_iam_feature_scope_c AS toggl ON /* join condition not captured in parsed metadata */
;