APS_IAM_INFO_RAP_RE_IAM_APP

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_RAP_RE_IAM_APP.
-- 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_RAP_RE_IAM_APP AS
SELECT
  core.AppID AS AppID,
  rt.ID AS ID,
  core.AppDescription AS AppDescription,
  core.TransactionCode AS TransactionCode,
  core.TransactionText AS TransactionText,
  core.Component AS Component,
  core.AppType AS AppType,
  rt.RestrictionTypeID AS RestrictionTypeID,
  rt.Description AS RestrictionType,
  rt.WriteAccess AS WriteAccess,
  rt.ReadAccess AS ReadAccess,
  rt.F4Access AS F4Access,
  rt.RestrictionTypeStatus AS RestrictionTypeStatus,
  rt.FieldName AS FieldName,
  rt.FieldDescription AS FieldDescription
FROM i_aps_iam_app_core AS core
INNER JOIN i_aps_iam_app_core_rt AS rt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APS_IAM_INFO_APP_TYPE AS _app_type_text ON _app_type_text.KeyValue = AppType  -- association [0..*]
;