APS_IAM_INFO_BU_SERVICE_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_BU_SERVICE_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_BU_SERVICE_BASIC AS
SELECT
  stat.bname AS UserID,
  ub.ObjName AS ServiceName,
  br.id AS BusinessRoleID,
  BuCat.bu_catalog_id AS BusinessCatalogID,
  bu.UserName AS UserName,
  br.uuid AS BusinessRoleUUID,
  ub.Object AS ObjectType,
  text.description AS Description,
  stat.counter as UsageCounter AS bnameasUserID,
  case when dbu.UserID is initial then '' else 'X' end as UserDeleted AS UserIDisinitialthenelseXendasUserDeleted,
  stat.counter AS UsageCounter
FROM rsau_app_stat AS stat
INNER JOIN APS_IAM_INFO_USOBHASH AS ub ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /iwbep/i_mgw_srt AS text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_busr_ddl AS bu ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DeletedUser AS dbu ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_d_br AS br ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_d_brca AS ca ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_w_bu_cat AS BuCat ON /* join condition not captured in parsed metadata */
INNER JOIN agr_1251 AS a1251 ON /* join condition not captured in parsed metadata */
INNER JOIN /iwbep/i_v4_msgr AS g4ba ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /iwbep/i_v4_msgt AS text ON /* join condition not captured in parsed metadata */
INNER JOIN tstc AS tr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tstct AS text ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): rsau_app_stat
;