P_USER_OBJECT_AUTH

DDL: P_USER_OBJECT_AUTH SQL: PUSROBJAUTH Type: view

Users from UST12 for single Profiles

P_USER_OBJECT_AUTH is a CDS View that provides data about "Users from UST12 for single Profiles" in SAP S/4HANA. It reads from 5 data sources (usrefus, ust04, ust04, ust10s, ust10s) and exposes 7 fields.

Data Sources (5)

SourceAliasJoin Type
usrefus usrefus left_outer
ust04 ust04 left_outer
ust04 ust04 left_outer
ust10s ust10s left_outer
ust10s ust10s left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PUSROBJAUTH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Users from UST12 for single Profiles view

Fields (7)

KeyFieldSource TableSource FieldDescription
bname usr02 bname User name
profn ust10s profn Profile name
objct ust10s objct Object
bname User name
profn ust10s profn Profile name
objct ust10s objct Object
auth ust10s 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 P_USER_OBJECT_AUTH.
-- 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: PUSROBJAUTH

CREATE VIEW P_USER_OBJECT_AUTH AS
SELECT
  usr02.bname AS bname,
  ust10s.profn AS profn,
  ust10s.objct AS objct,
  ust10s.auth AS auth
LEFT OUTER JOIN ust04 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ust10s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usrefus ON /* join condition not captured in parsed metadata */
;