APS_IAM_INFO_APP_RE_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_RE_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_RE_BASIC AS
SELECT
  app.app_id AS AppAuthVariantID,
  _AppRestrictionType.restriction_type_id AS RestrictionTypeId,
  _RestrictionField.field_name AS FieldID,
  app.tcode AS FioriTransaction,
  _RestrictionTypeText.text AS RestrictionType,
  _FieldText.text AS RestrictionField,
  _AppDescription.Description AS ApplicationText,
  app.app_type AS AppType,
  att.ddtext AS AppTypeText,
  _AppRestrictionType.read_access AS ReadAccess,
  _AppRestrictionType.write_access AS WriteAccess,
  _AppRestrictionType.f4_access AS F4Access,
  _AppRestrictionType.read_access_status AS ReadAccessStatus,
  _AppRestrictionType.write_access_status AS WriteAccessStatus,
  _AppRestrictionType.f4_access_status AS F4AccessStatus
FROM aps_iam_w_app AS app
INNER JOIN aps_iam_w_app_rt AS _AppRestrictionType ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_w_rtfld AS _RestrictionTypeToField ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_w_fld AS _RestrictionField ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS att 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_w_rt_t AS _RestrictionTypeText ON _RestrictionTypeText.id = _AppRestrictionType.restriction_type_id AND _RestrictionTypeText.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN aps_iam_w_fld_t AS _FieldText ON _FieldText.field_name = _RestrictionField.field_name AND _FieldText.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN APS_IAM_BR_APPT AS _AppDescription ON _AppDescription.AppId = _AppRestrictionType.app_id AND _AppDescription.Langu = $session.system_language  -- association [0..1]
;