c_aps_iam_app_root

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 c_aps_iam_app_root.
-- 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 c_aps_iam_app_root AS
SELECT
  AppID,
  AppDescription,
  AppTypeID,
  AppTypeText,
  ReadOnly,
  TransactionCode,
  TransactionText,
  UIAppID,
  ChangedOn,
  ChangedBy,
  Component,
  PriceCategoryText,
  PriceCategoryHidden,
  ForbiddenWithSuccessors,
  DirectAssignment,
  StartAuthorization,
  TileAssigned,
  Type,
  IsDeprecated,
  DeprecatedStatusText,
  DeprecatedWithRelease,
  DeprecatedStatus,
  DeprecatedCriticality,
  DeprecatedHidden,
  CatalogCount,
  RoleCount,
  RestrictionTypeCount,
  SuccessorCount,
  AuthorizationCount,
  ScopeItemCount,
  TileTargetMapCount,
  TotalDepCount,
  CatalogsHidden,
  RolesHidden,
  AuthorizationsHidden,
  RestrictionsHidden,
  DependenciesHidden,
  SuccessorsHidden,
  ScopeItemsHidden,
  TileTargetMapsHidden,
  TranNotHidden,
  ExtNotHidden,
  virtual AppLongText : abap.string(0) AS string0,
  virtual AppAssistant : abap.sstring(20) AS sstring20,
  virtual AppAssistantLinkHidden : boole_d AS virtualAppAssistantLinkHiddenboole_d,
  SuccessorDependencies
FROM i_aps_iam_app_root
LEFT OUTER JOIN c_aps_iam_app_sucdep AS SuccessorDependencies ON SuccessorDependencies.OrigAppID = AppID  -- association [0..*]
;