SUSR_USERS_FOR_OBJECT_FIELD

DDL: SUSR_USERS_FOR_OBJECT_FIELD SQL: SUSRUSERSOBJFLD Type: view Package: SUSR_DDL

Users with Authorization for Auth Object + Field Value

SUSR_USERS_FOR_OBJECT_FIELD is a CDS View that provides data about "Users with Authorization for Auth Object + Field Value" in SAP S/4HANA. It reads from 3 data sources (SUSR_NORMAL_UST12, SUSR_NORMAL_UST12, usrefus) and exposes 3 fields. Part of development package SUSR_DDL.

Data Sources (3)

SourceAliasJoin Type
SUSR_NORMAL_UST12 SUSR_NORMAL_UST12 inner
SUSR_NORMAL_UST12 SUSR_NORMAL_UST12 inner
usrefus usrefus inner

Parameters (3)

NameTypeDefault
p_auth_object xuobject
p_auth_field xufield
p_auth_value xuval

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SUSRUSERSOBJFLD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Users with Authorization for Auth Object + Field Value view

Fields (3)

KeyFieldSource TableSource FieldDescription
bname usrbf2 bname User name
bnameasbname
auth usrbf2 auth Authorization

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 SUSR_USERS_FOR_OBJECT_FIELD.
-- 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.
-- SQL view name: SUSRUSERSOBJFLD
-- Parameters: p_auth_object : xuobject, p_auth_field : xufield, p_auth_value : xuval

CREATE VIEW SUSR_USERS_FOR_OBJECT_FIELD AS
SELECT
  usrbf2.bname AS bname,
  usrbf2.auth as auth AS bnameasbname,
  usrbf2.auth AS auth
INNER JOIN SUSR_NORMAL_UST12 ON /* join condition not captured in parsed metadata */
INNER JOIN usrefus ON /* join condition not captured in parsed metadata */
;