SUSR_USER_AUTH_OBJECT_VALS

DDL: SUSR_USER_AUTH_OBJECT_VALS SQL: SUSRUSRAUTOBJVAL Type: view Package: SUSR_DDL
6 Fields 1 Data Sources

Selects user, authorization, authorization object and values

SUSR_USER_AUTH_OBJECT_VALS is a CDS View that provides data about "Selects user, authorization, authorization object and values" in SAP S/4HANA. It reads from 1 data source (SUSR_NORMALIZE_UST12) and exposes 6 fields. Part of development package SUSR_DDL.

Data Sources (1)

SourceAliasJoin Type
SUSR_NORMALIZE_UST12 SUSR_NORMALIZE_UST12 inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SUSRUSRAUTOBJVAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Selects user, authorization, authorization object and values view

Fields (6)

KeyFieldSource TableSource FieldDescription
bname SUSR_USER_AUTH_OBJECT bname User name
auth SUSR_USER_AUTH_OBJECT auth Authorization
object SUSR_USER_AUTH_OBJECT object TRFM Object
field SUSR_NORMALIZE_UST12 field Logical Field
low SUSR_NORMALIZE_UST12 von_normalized
high SUSR_NORMALIZE_UST12 bis_normalized

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_USER_AUTH_OBJECT_VALS.
-- 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: SUSRUSRAUTOBJVAL

CREATE VIEW SUSR_USER_AUTH_OBJECT_VALS AS
SELECT
  SUSR_USER_AUTH_OBJECT.bname AS bname,
  SUSR_USER_AUTH_OBJECT.auth AS auth,
  SUSR_USER_AUTH_OBJECT.object AS object,
  SUSR_NORMALIZE_UST12.field AS field,
  SUSR_NORMALIZE_UST12.von_normalized AS low,
  SUSR_NORMALIZE_UST12.bis_normalized AS high
INNER JOIN SUSR_NORMALIZE_UST12 ON /* join condition not captured in parsed metadata */
;

Learn More